web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Wrong Quantity update ...
Microsoft Dynamics RMS (Archived)

Wrong Quantity update at Headquarter

(0) ShareShare
ReportReport
Posted on by Shahid Ghafoor 1,445

Dear All,

I receive quantity at store i.e. 200 units of an item , when headquarter synchronize  the store, it triplicate the quantity at headquarter i.e. 600

 

update me

 

Regards,

 

Shahid Ghafoor

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Make sure you are running only one copy of HQClient for that store.  If there are more than one computers making the connection, they will all connect on the same schedule and create multiple copies of the same order or entries in that order.

  • Shahid Ghafoor Profile Picture
    Shahid Ghafoor 1,445 on at

    Dear, Actually, one Client is is wrongly configured with Headquarter Database rather than store database. When it synchronize with HQ Database, it effect the first store only(Mean Store ID is 1 in HQ) , and Now the client the correctly configured with Store database. but when we create PO from first store , then data triplicate and other stores are working fine.

  • Community Member Profile Picture
    Community Member on at

    where does it triplicate the qty? in which report or screen? can u run the following queries and post the results?

    select count(*) from item

    select count(*) from itemdynamic

    select count(*) from store

  • Shahid Ghafoor Profile Picture
    Shahid Ghafoor 1,445 on at

    select count(*) from item=10064

    select count(*) from itemdynamic=201274

    select count(*) from store=20

    Actually , Now a day problem is that I received a purchase order of 500 units of an item, it correctly update the store quantity as well as Inventory transfer log table.

    As, Store client communicate the Headquarter, it triplicate the quantity on both store and Headquarter,.

    After this check the inventorytransferlog table, there are three entries with the same PO Number,  referenceID of one PO is correct and others PO reference ID's are zero,

    Then I check the inventory transfer movement report, in which report show that one movement is made through "PO/Inventory Transfer" and  others are "Unknown", and the same case is in the HQ.

    In both the place inventory movement history report show the three entries with same PO number and two of them are "unknown"

    Still a big problem! why after the synchronization of client-server, entries and quantity triplicate

    Regards,

    Shahid Ghafoor

  • Community Member Profile Picture
    Community Member on at

    Is there any customization done on this database? like triggers created on the ITL table? or for example entries in the TableSync table?

  • Shahid Ghafoor Profile Picture
    Shahid Ghafoor 1,445 on at

    Yes Dear, Customization done  in a way that we calculate the landed cost and allocate it to the item for correct per unit cost of  the items including invoice cost.

    In this custom application we just calculate the per unit cost and just hit the PurchaseOrder,PurchaseOrderEntry table with received status.

    but commit the Purchase order through application (RMS 2.0)   ; and

    TableSync on HQ  is empty at this time

    Regards,

    Shahid Ghafoor

  • Community Member Profile Picture
    Community Member on at

    I believe u need to run the SQL profiler while the 401 being executed so that u can identify who is inserting into the ITL table

  • scherer Profile Picture
    scherer 115 on at

    I am having the same issue. have you fixed it?

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans