Worksheet Style 307: Adjust Item Quantities

Hi group,

We are trying to get our HQ and store quantities to be equal and accurate after a physical inventory count. RMS 1.3.1010 with 7 stores in 3 countries and HQ

We are confused in all the procedures required and in which order to do them.

Question: HQ quantity for item x is 10 Store quantity for item x is 8 Physical inventory count for item x is 9

What to do? Run a Task 190 to update HQ qty to 8 and then run a WS 307 to add 1 to both the store and HQ?

What would happen if we only ran a WS 307 and added 1 to item x? Would HQ be at 11 and store 9?

Thank you. Frederic

Reply to
Frederic Hurlet
Loading thread data ...

Reply to
convoluted

Thanks convoluted.

I was still wondering what is the purpose of a WS #307 ? What does it do?

Is there a way to handle this solely from HQ based on receiving an Excel file with inventory counts on a day a store is closed? or after hours?

Perhaps I'll also ask the above during the Microsoft RMs Live chat: Thursday, October 4, 2007

1:00 - 2:00 P.M. Eastern Time

Reply to
Frederic Hurlet

I would just set the QTY to 9 and run the 309. I have used the 309 when a physical inventory count is taken at the store, but entered in at HQ...In this way HQ could initialize / overwrite the inventory at the Store Ops level.

Todd NitroSell

Reply to
Todd

Sorry...307...

Reply to
Todd

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.