Inital inventory count for RMS

I have a small piece of advice that will save you LOTS of time if you are going to print count sheets when you start to do your actual inventory counts. MAKE SURE you sort your count sheet on whatever field works best for you (in the print screen) so you can sort the inventory worksheet the same way when you have to enter the counts. Otherwise you will have to look all over to enter counts instead of entering your numbers row by row straight off the count sheet. I hope that makes sense ;)

Marc

Hi Joie,

Do not force enter the quanties by SQL statement to the Items record. If you do that this will not leave any audit and when you do your item movement report you will always be out by the initial starting stock. Create a transfer-in with the option for manual and in the Generation Selection select "Generate for all items in the selected group" and Group Selection "All Items". This will put a qty 1 on the order - save that. And if you want you can use sqk command to populate thetransfer in table where ever item lookup code si found populate the qty from your excel with whatever qty you want - real or imaginary. Once imported go ahead and commit the transfer in. Whenever you doa stocktake this will put your stock in correct position.

Else if you use our stocktake program and handheld solution (HandHeld Bundle) you can do all your stock of 5,000 in less than 2-3 hours. Contact me if you want to talk about this further.

Thank you Afshin

after doing some testing i understand what you mean

Does anyone know What database table should I be looking if I want to use SQL to edit all my item quantities in the Transfer In before i commit them?

PurchaseOrder ? PurchaseOrderEntry ? PurchaseOrderEntryDetail ?

Thank you again !! Regards, Joie

Joie

Go ahead and download our Store Utility and there is a Transfer-in utility in there. Send me a key request and I will give you a temporary 1 month license so you can use this to import the items and create a transfer-in