Combining Inventory, how?

Question

We have completed our EOY inventory. We do an different inventory on our POS computer and at the back room computer. Each writing to a unique Physical Inventory (I had thought that we could write to one but this did not seem to work). Since there are items that were counted in both places I cannot commit one and then the other (it would adjust to the last committed). I am going to end up having to use SQL to try and combine these into one. I have in the past imported a file (which requires more SQL since Physical Inventory has items by ItemID and the import needs them by ILC). This has been a pain every year. I feel like we are missing something simple. What are others doing?

Thanks.

dking · Accepted Answer

Sam,This is Dan King with New West Technologies.  We makea line of Mobile that can reduce a count to half the time and half thepeople. You shoudl ask your RMS partner about our Mobile solutions.they can be seen on our site.Dan

Michael · Answer

Why not just dump one of the batches out to a csv file and then use the "Physical Inventory" Import option and make sure you select the "Add to existing counts" option.

In Store Operations Administrator performin the following query replacing the PhysicalInventory.Code = '9999999' with the actual "Ref. Number" found on your Physical Inventory screen in Store Operations Manager.

SELECT Item.ItemLookupCode, PhysicalInventoryEntry.QuantityCounted FROM Item INNER JOIN (PhysicalInventory INNER JOIN PhysicalInventoryEntry ON PhysicalInventory.ID = PhysicalInventoryEntry.PhysicalInventoryID) ON Item.ID = PhysicalInventoryEntry.ItemID WHERE PhysicalInventory.Code = '9999999'

Once the data is displayed do "File" "Export" on the menu and save as a csv file and then import into your other existing batch.

viglen · Answer

Have you tried calling the support team (they are really good with solving problems)

U.S./Canada Toll-free (1) (888) 477-7989

Worldwide (1) (701) 281-6500

Availability and hours of operation: Monday–Friday, 8:00 A.M.–6:00 P.M. Central Time (UTC-6) in the U.S. and Canada.

Support,

formatting link

Combining Inventory, how?

Join the Discussion

Didn't find your answer?