manual inventory quandry (liquor wine)

I believe that add to existing counts refers to adding to existing counts within the current physical inventory count, not after the inventory is committed. We just did an inventory of about 5,000 item lookup codes using (3) handheld data collectors yesterday. We imported the first file from the first data collector and then the second and third files. Each time as we imported the subsequent files after the first import, the quantities were added to the previous quantity within the inventory. Once we were satisfied that the inventory was as good as it was going to get, we committed the inventory and it became our new book inventory, overwriting the previous book inventory.

Regards,

Kinnard

K> I hate to tell you this but...... you are going to have to recount. Unless

Doug

where do u go to reset the quantities to zero.

Thanks in advance

"Doug Pic-N-Pac" wrote:

First of all not sure why you would want to set it them to zero unless you were about to start out. But even then it wouldnt really matter. But you can just put a blank file in and since nothing is there everything will be zero after you save it. Kinnard what you said about adding to that makes sense but what i dont understand is why dont you get the scann data CSV file and add to it there. But i see where you are coming from as well. The problem I dont like about the physical inventory count is the fact that if you have parent/ child items it kinda screws you up. For instance Cartons of cigs have

the reason i adjusted the QOH to 0 was because the inventory counts were corrupt and i needed a marker to designate items not in inventory or not counted. i have only had this software three months and the learning curve is vertical. after much trial i have discovered the real problem is this: when entering the inventory count the software records the qty counted and reconciles it against the expected qty at the time of entry- but- there may be sales not accounted for from the time of entry to the time the item is comitted, ie item x is counted and entered on monday count = 100 expected • delta =-5 tuesday sales wed sales thursday the item is comitted inventory does not reflect sales tues & wed of 40 so inventory count is useless. my old software allowed sales to be put in a holding mode while doing inventory then run once the counts were comitted, reconciling the count.

you can reset inventory counts globaly with the inventory wizard - you will need a reason code

i just recently changed my cigs to a p/c c> First of all not sure why you would want to set it them to zero unless you

entry time

the count was

WOW! I thought I was the only one with inventory issues. Our partner does not speak English as a first language and we had many miscommunications from the very beginning. We too have 5000+ items in our inventory that we counted by hand. If I ran across an item that was not in our database, but obviously for sale in our store, I created the item and then I did a separate physical inventory sheet for them. I have not experienced any problems with our inventory being way off from the time of entering and time of committal. If I counted an item on the third of January, and I entered it today with the count date of 1-3, it appears that sales were taking into consideration. I have been working on inventory since 12-31-07. I still have a ton to learn, and seemingly on my own since the "training" we go from our partner SUCKED! That is another long story. We've had RMS since August and my boss is ready to put it in the dumpster and try Quickbooks POS. I think he wants to see my head spin!

to work for

the entry time

the count was

recount. Unless

to work for

all inventory

the entry time

when the count was

recount. Unless

to work for

all inventory

the entry time

when the count was