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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Retail and commerce : ...
Supply chain | Supply Chain Management, Commerce
Answered

Retail and commerce : Mismatch in transaction count

(0) ShareShare
ReportReport
Posted on by Hassan.Diab 5

Mismatch in transaction count for (store number) , terminal ( ID)  and shift (NO.) and hence this shift is not marked in a statement. This shift contains 8 transactions while transactions uploaded contains 5. Please check the Shift tile to acknowledge this issue.

Shift-id.png

I have the same question (0)
  • Hassan.Diab Profile Picture
    Hassan.Diab 5 on at

    Hi all,

    After acknowledge the error , sales transaction not fully-added to statement calculation and there are difference between transactions and counted amount.

    Regards,

  • Verified answer
    Shafeeque P. Profile Picture
    Shafeeque P. 6,533 Moderator on at

    Can you compare the physical X out report from store with the Z report in the store? You can  could also check the electronic  journal report in POS with the transactions uploaded to FnO to make sure that the count match ? If you are using Self hosted scale unit and have access to channel DB, you could repull all the transactions by clearing the table crt.tablereplicationlog. If you it is Cloud scale unit, you will need to raise a ticket with Microsoft support.

  • Hassan.Diab Profile Picture
    Hassan.Diab 5 on at

    From where repull all the transactions?

  • Verified answer
    Shafeeque P. Profile Picture
    Shafeeque P. 6,533 Moderator on at

    Repulling transactions from Channel DB to FnO. How you can repull the transactions depends on whether you are using Cloud hosted Commerce scale Unit or Self Hosted Commerce scale unit. If you are using Cloud hosted commerce scale unit, you will need to raise a ticket with MS support and the PG team will repull them.

    If you are using Self Hosted Cloud scale unit, you can repull the transaction by clearing the data from crt.tablereplicationlog table in channel database.

  • Manvendra Singh Profile Picture
    Manvendra Singh 360 on at

    What could be possible reason to miss at first place?

  • Shafeeque P. Profile Picture
    Shafeeque P. 6,533 Moderator on at

    The reason for missing is unknown. Async client uses replicationcounterfromorigin field in all transaction table to track if a particular line has been pulled. You can see which all transactions got uploaded by looking at the crt.replicationlog. Data corruption in this table or if the system assigns a replicationcounter value that is less than last pulled value can cause the issue.

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 301 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 120 Super User 2025 Season 2

#3
Siv Sagar Profile Picture

Siv Sagar 105 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Quality order uses default receipt location instead of actual physical receipt location

Product updates

Dynamics 365 release plans