Skip to main content

Notifications

Microsoft Dynamics RMS forum

Headquarter Item Quantities?

Posted on by Microsoft Employee

My Headquarter Item Quantities are not the same as the store quantities. When an item is sold in a store should the headquarters also deduct the item quantity because my headquarters does not deduct item. Is worksheet 401 enough for this? The only way at the moment I can get both the same is by running worksheet 501 and then Task 190.  

*This post is locked for comments

  • Suggested answer
    archelle16 Profile Picture
    archelle16 1,735 on at
    RE: Headquarter Item Quantities?

    Request full item count will do the work for you. It counts item quantities in store and automatically adjust quantites in hq.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Headquarter Item Quantities?

    If the inventory is consistently off, you might have a shrinkage problem at the store.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Headquarter Item Quantities?

    Style 501: Request a Full Item Count
    Use this worksheet to upload the current on-hand and committed quantities for all
    items from the selected store to Headquarters. Then:

    • Run the Inventory Wizard Task 190 (WIZARDS→INVENTORY WIZARD) to compare these quantities with those computed by Microsoft Retail Management Headquarters, and then perform a full item count reconciliation.
      • Item counts are not committed to the Headquarters database until the Inventory Wizard Task 190 is completed.
      • This provides a system check for the inventory tracking processes at both the store and Headquarters, and can help detect unauthorized quantity updates or shrinkage at the store level.
      • For each item in the store's inventory, Headquarters uploads its quantities and simultaneously captures quantities as computed at Headquarters for the item based on the store's actual sales transactions. The actual and computed quantities are time-tagged and saved so quantity discrepancies can be later reported via the  REPORTS→ITEMS→QUANTITY DISCREPANCY LIST report.

    NOTE: Whenever a Worksheet Style 501 is processed, an Inventory Wizard Task 190
    MUST be completed before Headquarters correctly reflects the store quantities.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,129 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans