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

Notifications

Announcements

Sign Up for Ask a Community Pro Today!
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) / HQ Detail Sales Report...
Microsoft Dynamics RMS (Archived)

HQ Detail Sales Report shows extra Items on Transactions for 1 store

(0) ShareShare
ReportReport
Posted on by Community Member

One of our clients is having a problem in HQ with the Detail Sales Report.  When they run the Detail Sales Report 1 of the Stores in right one the money and the other store show around 900.00 more sales than what the store shows at the store level.  I looked into the Transaction table in HQ and it is correct but when I looked into the TransactionEntry Table in HQ there are extra item list on this table under certain Transaction numbers.  Has anyone ever experience this and do you know how to correct it?

*This post is locked for comments

I have the same question (0)
  • Spencer McCandless Profile Picture
    Spencer McCandless 2,087 on at

    Did you restore the store database from a backup? Most of the times I've seen this happen it turns out to be due to transaction numbers being reused after a store backup was restored.

  • Community Member Profile Picture
    Community Member on at

    Is there a fix for this or am I better off going into HQ delete the extra items and re-set the store with the database from HQ?

  • Spencer McCandless Profile Picture
    Spencer McCandless 2,087 on at

    Well, for future transactions, you can do a "Select max(transactionnumber) from [transaction] where storeid = '{the affected store's id}'" to get the highest transaction number for that store in the HQ database, then go to Store Ops Admin and use the Set Next Transaction Number function under the database drop down to set it to one higher than that number.

    This won't fix the existing incorrect data, though. Let me think on it for a bit and I'll see if I can come up with a way of fixing whats already done while preserving all of the data.

  • Spencer McCandless Profile Picture
    Spencer McCandless 2,087 on at

    Sorry, haven't come up with an easy solution so far. The best I can think of would be to use a while loop with a couple of incrementing variables to assign new transaction numbers to those entries in the transaction and transactionentry tables that exist in HQ but not in Store Ops, but I'm having trouble wrapping my head around it.

    Also, just a heads up, there's probably a similar situation going on with the PurchaseOrder and PurchaseOrderEntry tables. You'll likely start seeing random items showing up in transfers and purchase orders in HQ.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Thanks Spencer I will start the procedure tonight and catch up on the HQ in the next couple of days.

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

Sign Up for Ask a Community Pro Today!
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