Worksheet Style 307: Adjust Item Quantities

Oct 02, 2007 4 Replies
F

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


Vote
Twitter Facebook LinkedIn
F

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

Vote
Twitter Facebook LinkedIn
T

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

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required