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) / Incorrect Tender Amount
Microsoft Dynamics RMS (Archived)

Incorrect Tender Amount

(0) ShareShare
ReportReport
Posted on by Community Member

When closing out register and running Z Report, I found that there was a $15.88 discrepancy. With further investigation, I discovered that this difference of $15.88 on one transaction where a store account had been charged. The total for this transaction was 19.51; however, the account was only charged $0.96. Could someone explain to me how this could occur? I'm not quite understanding how the cashier could have gotten past the tender screen and received a receipt without reaching a balanced state on the transaction.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    There must be an additional tender on the transaction; RMS will not allow you to complete the sale until the total tenders match the transaction total.

  • Community Member Profile Picture
    Community Member on at

    This receipt shows no other tender.

  • Community Member Profile Picture
    Community Member on at

    Check the database - query the [transaction] table and retrieve the ID

    SELECT ID FROM [TRANSACTION] WHERE TRANSACTIONNUMBER = 141478

    -- JOT DOWN THE ID

    THEN QUERY THE TENDERENTRY TABLE

    SELECT TENDERID  FROM TENDERENTRY WHERE TRANSACTIONID = X

    -- REPLACE THE X WITH THE ID FROM THE FIRST QUERY

    How many tenders do you see? The TENDERID is the ID in the tender table

    SELECT * FROM TENDER WHERE ID = Y

    SELECT * FROM TENDER WHERE ID = Z

    -- replace the Y and Z with the IDs you see in the TENDERENTRY table

  • Community Member Profile Picture
    Community Member on at

    I guess I should have mentioned that I already did that. There is only one TenderID for this transaction. That is "8" which is the store's "store charge". No other tender is listed.

  • Community Member Profile Picture
    Community Member on at

    Hi Rebecca,

    Are there any customizations (hooks) installed? Specifically a tender end hook?  The fact that you have a receipt indicates that the business rules did complete, but as we all know, you can't post an underpaid transaction so it looks like something interfered with the tender posting event.

    It's an interesting (but unsettling) issue but there is likely an explanation.

  • Community Member Profile Picture
    Community Member on at

    No customizations that I know of. This is not an isolated event, either. The store had an two occurrences like this back in February, and another in April/May. This episode was followed by another much like it the next day: a cash transaction did not register into the transaction table even though the transaction was completed and a receipt was printed. There was a $10 total, the cashier says she simply pressed the "+" on the tender window, and that nothing funny seemed to happen on her screen.

    This is not a user problem, each instance is a different cashier.

  • Community Member Profile Picture
    Community Member on at

    Hi again,

    You didn't mention your version so perhaps if you are on some old, obscure version, it could be a bug you're dealing with, but I have never, ever seen this issue.  The only other though aside from a customization causing the issue is some incompatibility - like running an really old version of RMS on SQL 2008 or 2012 (uncharted waters).

    You should check the registry on the PC running POS so see if there are any hooks - I still think it's likely customization.

    32 Bit PC:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Retail Management System\Store Operations\Hooks

    64 Bit PC;

    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Retail Management System\Store Operations\Hooks

  • Community Member Profile Picture
    Community Member on at

    No hooks. After some discussion with coworkers over the past few days, we've decided to pin it on the fact that they are still running Version 2.0.0105. They have not been updated due to collaboration issues with other parties, and we've recently been given the go ahead to take them to 159. Hopefully, this will help!

    Thanks so much for your help, Heidi and Fernando!

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

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