What are some reasons for inventory quantity discrepancies in Headquarters?
Worksheet 401 or data upload updates HQ's on hand based on store's data.
We do a 401 worksheet every hour during the day. But sometimes our quantities are different in Headquarters. We process a 501 worksheet and do a 190 task to get Headquarters back in line.
The question is what causes the discrepancies?
it can happen especially when you have a lot stores connected to a single HQ with a minimum communication interval. The HQ item quantity is being updated when 401 communication happens. All store's inventory details are saved in the table 'ItemDynamic' and the trigger in the same table updates Item table.
You may need to run 501 WS once in a month / week to all stores and WS 190 subsequently to make both HQ and store inventory values same. Please go through RMS help file to know more about these work sheets. Hope this will help you.