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 / Microsoft Dynamics RMS (Archived) / How to remove a credit...
Microsoft Dynamics RMS (Archived)

How to remove a credit card transaction from batch?

(0) ShareShare
ReportReport
Posted on by bzivali 50

In a few occasions, I had cashiers credit customers unintentionally to their credit cards.

What happens -- cashier scans items. $10 total. Customer gives cash ($20), but decides to add something.  However, cashiers enters, $20 for example, in cash slot. Hits cancel/escape and adds new product and hits enter.  That $20 is still there. This time customer gives credit card. Swipes the card without deleting the $20 from cash slot -- that $20 is refunded to customer and cashier is short.

First of all, is there a way so that, that $20 is deleted by default from the cash slot.

Most importantly, can I delete that transaction?  Since I don't have the card on hand, I cannot charge the customer for the refund he received.  Without the card, RMS doesn't let me void the transaction. 

Is there a way to delete that transaction before settling the batch?

Thank

Burak

 

*This post is locked for comments

I have the same question (0)
  • Jonathan Kimberley Profile Picture
    Jonathan Kimberley 25 on at

    here is what you can do, are you using EDC? if yes, I would recommend you to close the batch for that transaction from the system(using query not using EDC) then when you do settle you will see all the transaction except the transaction that you just closed from the system.

    Here is the query you can try!

    update visanetauthorization set status = 0 where id (put the transaction#)

    I think status 0 is closed. if not, try 1 or 2

  • Community Member Profile Picture
    Community Member on at

    what is the the id( transaction#) is that the RMS transaction number or the credit card transaction id under EDC transaction info.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    You must first Backup everything.  Then lookup the tender entry.  You can find these in the dbo.TenderEntry table.  Search for the tender entry by TransactionNumber

    select * from tenderentry where transactionnumber = {your number here}  

    replace everything after the equals sign.

    You are looking for the VisaNetAuthorizationID value.

    you will need that value to search for the entry in the VisaNetAuthoization table

    select * from VisaNetAuthorization where ID = {your visa net auth id}

    change the status to

    update VisaNetAuthorization set status  = # where ID = {your visa net auth id}

    replace # with your status number.  

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 > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans