web
You’re offline. This is a read only version of the page.
close
Skip to main content
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)
  • Shafeeque P. Profile Picture
    Shafeeque P. 6,527 Moderator on at
    RE: Retail and commerce : Mismatch in transaction count

    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.

  • Manvendra Singh Profile Picture
    Manvendra Singh 360 on at
    RE: Retail and commerce : Mismatch in transaction count

    What could be possible reason to miss at first place?

  • Verified answer
    Shafeeque P. Profile Picture
    Shafeeque P. 6,527 Moderator on at
    RE: Retail and commerce : Mismatch in transaction count

    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.

  • Hassan.Diab Profile Picture
    Hassan.Diab 5 on at
    RE: Retail and commerce : Mismatch in transaction count

    From where repull all the transactions?

  • Verified answer
    Shafeeque P. Profile Picture
    Shafeeque P. 6,527 Moderator on at
    RE: Retail and commerce : Mismatch in transaction count

    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
    RE: Retail and commerce : Mismatch in transaction count

    Hi all,

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

    Regards,

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,011

#2
André Arnaud de Calavon Profile Picture

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

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 215 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans