Has anyone had a problem with your HQ total inventory dollars not matching with your total dollars from your store levels. We are not allowing items to be set up at the store level and we are set up on a average cost when item are received. Please post I would appreciate any input.
HQ Inventory Matching with store levels inventory $$
Sep 07, 2007
3 Replies
Its not uncommon that HQ qties don't match store qties - you could have had issues during store connections, not all sales have gone to HQ - at the store level make sure you've set a reason code to track manual inventory adjustments and physical inventory counts (store ops manager - file - configuration - options - reason code options; create your reason codes in store ops manager - database - reason codes); run a movement report at the store for the SKUs that have variances with HQ - the movement report should support your current store qties- if it does, create a 501 worksheet at HQ then run an inventory task 190 count reconciliation after the 501 has uploaded store counts to HQ - do this before the next scheduled connection )
- RMS is apparently geared/designed to have more faith > Has anyone had a problem with your HQ total inventory dollars not matching
I have had a problem with almost every aspect of RMS when it comes to reconciling HQ & Store Ops.
Inventory values, sales figures, customer account balances, ship-to addresses, you name it.
RMS needs a Worksheet that reconciles inventory, sales figures and customer account balances on a regular schedule.
Tom
Can you do a 501/190 during store hours? How do sales that occur in between the 501 and the 190 affect the procedure?
While on the subject of reason codes for manual changes, there should be an option for "other" so the employee can type in a reason not offered. It's impossible to list every reason that a manual inventory change would be done.
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required