Question Status

Verified
SammySue asked a question on 17 Feb 2015 12:17 PM

What are some reasons for inventory quantity discrepancies in Headquarters? 

Reply
Archelle Marcito responded on 17 Feb 2015 8:04 PM

Synchronization.

Worksheet 401 or data upload updates HQ's on hand based on store's data.

Reply
SammySue responded on 18 Feb 2015 8:43 AM

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?

Reply
Verified Answer
j.arun responded on 23 Feb 2015 11:04 PM

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.

Reply
Verified Answer
j.arun responded on 23 Feb 2015 11:04 PM

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.

Reply