Hi, Could someone please enlighten me to the following: A customer has two stores, Store 1 and Store 2 running under HQ and they like to prepare local inter-store transfers. Store 1 does a Transfer Out and eventually (maybe a day or more later) Store 2 receives the Transfer In. Now here's the thing. What if there was a packing error en-route and they only receive part of the transfer. They receive into stock what was actually received and not what was issued and they then Close. What happens to the balance of the stock that never left Store 1? Will the stock return to Store 1's inventory? Or will they have to check the Inventory Received reports for Store 2 to see the difference and manually adjust? That would suck. Thanks.
Inter-store inventory transfers query
Feb 06, 2008
3 Replies
it is suck
you may have to accept all the transfer and create another one from Store 2 with differences to go with upcoming connection.
See my entry (maybe 8 down) on "Transfer Quantities Don't Match." I requested our reseller look into it and they confirmed my fears. The system adds/subtracts from inventory whatever your stores enter. So, if store 1 transfers out 10 and store 2 receives 12, then the system just created 2 items out from air and your overalll inventory valuation went up. The system should not allow for these transfers to be closed until the quantities match
- But it does allow for it.
You could have someone (inventory control-type person) run the item movement report looking for mismatched quantities and force the stores to change the quantities to match. Or, you could wait till the next time the stores take a full physical inventory and let that correct it.
There is also another scenario where Store 2 may show "Ordered 50" from Store 1, but Store 1 sends 52. Then Store 2 does a "Receive All" and receives the 50 they ordered. The system will then add the full 52 to Store
2's inventory but show 50 as being on-hand and the other 2 as "Committed.""Tara" wrote:
It has to work this way, because what if Store 1 puts 12 boxes on the truck but one falls off along the way? Then Store 1 did, in fact ship out 12 and Store 2 did, in fact, only receive 11.
Now if there are MANUAL changes to the quantities at either store prior to committing, outside of the receive/issue/commit procedures, then I agree that both sides should update. That is an oversight in RMS I believe. At least you should have the option to propagate changes to the other store!
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required