Skip to main content

Notifications

Supply chain | Supply Chain Management, Commerce
Answered

Retail and commerce : Mismatch in transaction count

Posted on by 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

  • Shafeeque P. Profile Picture
    Shafeeque P. 6,512 Super User 2024 Season 2 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,512 Super User 2024 Season 2 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,512 Super User 2024 Season 2 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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans