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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Duplicate transactions...
Microsoft Dynamics RMS (Archived)

Duplicate transactions in HQ

(0) ShareShare
ReportReport
Posted on by Roger Oakes 522

Hi all, just wanted to see if anyone has an idea how this happened:

We have 6 stores, all on HQ. We also have a warehouse that is set up as a store and should never actually have any "sales" transactions applied to it, only item transfers. Between April 27 and May 3rd, every sales transaction that was recorded in our flagship store is also showing up as a sale in the warehouse database, but only in HQ. The warehouse database does not show these sales transactions at all. This has not happened before, nor has it happened since. It only happened for that one week.

The store, warehouse, and HQ databases are all on the same SQL Server 2014 Standard server. No other store database is on this server as they are all located at the stores in question. We are running version 2.0.2000 of RMS All of the registers are Windows 8.1.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Antonijo Todorovik Profile Picture
    Antonijo Todorovik 4,025 on at

    Hi Roger.

    Can you send worksheets 401 and 402 for the warehouse store, but with From date/time mark previous to 27th of April and force the HQ Client. Also, do the same for the flagship store.

    Btw, You see this duplicated sales in a report right? Custom report or standard report?

    Can You see the journals of the sales??

    Waiting for your answer...

    BR, A.

  • Roger Oakes Profile Picture
    Roger Oakes 522 on at

    Hello Antonijo.

    I'll run those worksheets today, but in answer to your other questions:

    1. We can get the sales in reports from a standard report in the HQ database from both the store and the warehouse. They are all exactly the same. (Same transaction numbers, etc.)

    2. We can see the journals for both the warehouse and the store in the HQ database.

    3. Neither the journals nor the sales transactions can be found in the warehouse database, but they are in the store database.

    I'll let you know what happens with the worksheets ASAP.

    Thanks for your help!

    Roger

  • Suggested answer
    Antonijo Todorovik Profile Picture
    Antonijo Todorovik 4,025 on at

    One thing more: when you open the journals of the "sales" in the warehouse, can you open the receipt images of the transactions? I don´t know the format of your receipts, but is there any info or detail where you can see that even showing in the warehouse "store" the transaction belongs to the flagship store?

    Regards, A.

  • Roger Oakes Profile Picture
    Roger Oakes 522 on at

    Yes Antonijo,

    The journal receipts in the warehouse journal in the HQ database for the warehouse are from the flagship store, the receipts for the warehouse, if there were any, would say warehouse and not the store name.

  • Roger Oakes Profile Picture
    Roger Oakes 522 on at

    Hi Antonijo,

    We ran all the worksheets and nothing changed!

    Thanks

  • Pablo Luis Adolfo Livov Profile Picture
    Pablo Luis Adolfo L... 10 on at

    The  databases od  theFlag Store and the Warehouse are there in de same PC? Because if it´s that the case, may be yo have done yor conection to HQ with your HQClient conected in warehouse and your RMS and POS conected in Store Database. You have to delete the Warehouse from HQ and recreated again. 

  • Roger Oakes Profile Picture
    Roger Oakes 522 on at

    Yes Pablo, the thought crossed my mind that this might be the case, but this thing has been running for 12 years like this and never had this problem before. Thanks for the answer, I'm going to investigate to see if I can figure out what caused the data upload to the wrong store in HQ.

  • Community Member Profile Picture
    Community Member on at

    We are having this exact issue - One store seems to be receiving duplicate transactions for another store. If we look at todays sales report in HQ the transactions are the exact same as another store??? When we look back in February we can see at store level that the sales should have been x but they are showing far more in HQ. It looks like HQ is pulling both store sales into one store. The other store in HQ is fine, all stores at store level are fine. ??? It is only in HQ that the reporting is incorrect or corrupt. 

    Very odd, I seen this years ago but have forgotten a fix? Any suggestions?

  • Suggested answer
    Antonijo Todorovik Profile Picture
    Antonijo Todorovik 4,025 on at

    Hi Damian.

    I'm not sure if this issue was solved with the previous posts, but only things I can add as possible solution are (and with big maybe):

    - Send sync worksheet 101 for all the stores (with previous database backups and stores closed, so You can always go back)

    - go deeper in the database and see if the data is really duplicated or it's the report itself that is wrong. Make a SQL query to double check the data.

    Contact me if you can't fix this.

    Best regards, A.

  • Pablo Luis Adolfo Livov Profile Picture
    Pablo Luis Adolfo L... 10 on at

    Hi, we did this:

    In HQ delete de store that make the duplication.

    send a WS 101

    and at the store run this SQL script

    update item set HQID= 0;

    select distinct t.name
    from sys.tables t inner join sys.columns c
    on t.object_id = c.object_id
    where t.name = 'configuration'

    update AccountingAccounts set HQID=0;
    update AccountingTerms set HQID=0;
    update AccountType set HQID=0;
    update Cashier set HQID=0;
    update Category set HQID=0;
    update Currency set HQID=0;
    update CustomButtons set HQID=0;
    update CustomCaption set HQID=0;
    update Customer set HQID=0;
    update Department set HQID=0;
    update Item set HQID=0;
    update item_bck set HQID=0;
    update ItemClass set HQID=0;
    update ItemMessage set HQID=0;
    update ItemTax set HQID=0;
    update MatrixAttributeDisplayOrder set HQID=0;
    update PriceRounding set HQID=0;
    update QuantityDiscount set HQID=0;
    update ReasonCode set HQID=0;
    update SalesRep set HQID=0;
    update Schedule set HQID=0;
    update ScheduleSegment set HQID=0;
    update Serial set HQID=0;
    update ShippingCarrier set HQID=0;
    update ShippingService set HQID=0;
    update ShipTo set HQID=0;
    update Supplier set HQID=0;
    update Taskpad set HQID=0;
    update TaskpadButtons set HQID=0;
    update TaskpadLayout set HQID=0;
    update Tax set HQID=0;
    update Tender set HQID=0;

    Then at the store, in  Manager, configuration you must at multistore reset the store number.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February 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