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 GP (Archived) / How to Remove Transact...
Microsoft Dynamics GP (Archived)

How to Remove Transactions from Customer Record

(0) ShareShare
ReportReport
Posted on by Bill Campbell 12

Situation

We have a situation where a customer has fully paid their invoice (via Credit Card) and then returned materials that generates Return doc and a Negative Cash Receipt.

Customer Invoice: 12/02/16 $1,334.35

Customer Payment: 12/05/16 $1,334.35

- Applied and all is good.

- then Customer returns materials and requests a REFUND to be entered on Credit Card

Customer Return: 1/30/17  $284.50

Negative Cash Receipt: 1/30/17 -$284.50

- Can not apply the Negative Cash Receipt to the Return

- Customer Trial Balance shows that there is ZERO balance - that is good.

- all transactions are processed and posted to the Bank for the Credit Card

Question

How do we now remove these two transactions from the Customer record so that when we generate Statements they do not appear.  We have attempted many things, however there is nothing I can create to apply against the Negative Cash Receipt.

Historical Reference Thread: https://community.dynamics.com/gp/f/32/t/109345

*This post is locked for comments

I have the same question (0)
  • Tim W Profile Picture
    Tim W 2,925 on at

    We deal with this scenario a bit, for us it works this way (off the top of my head anyway).

    We would see a reverse payment in our bank module as the Credit Card company would take a credit.

    Return is created as you have done and is posted to Customer account.

    'Negative Cash Receipt' we would enter as a debit memo in the RM module.  Offset to AR account is a clearing account we use for such credits.  

    Debit Memo is posted and the Return is applied to it to clear the Customer account.

    A Bank Transaction is entered against the checkbook account to clear the clearing account and create a transaction to offset and clear the reverse payment in the bank module.

    I hope I described that correctly.

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    Hi Bill,

    This seems to be coming up more and more for some reason. I wish GP would not allow a user to create a negative cash receipt for the exact problem you have. You cannot get rid of it.

    Whenever I've been faced with this issue I have removed the transaction using SQL. After it's removed, you will have a credit on the customer's account. A couple of ways to handle this. You could use the customer refund feature and move the credit to payables if you actually want to write a check, or you could enter a payment on the SOP document itself. Entering a Return document in RM Transaction entry will also work.

    Kind regards,

    Leslie

  • Suggested answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    I try to recommend not using the negative cash receipt transactions. Instead, enter the payment back to the customer directly on the return transaction.

    To clean up the current issue, this blog post may help:

    victoriayudin.com/.../how-to-get-rid-of-negative-payment-transactions-in-dynamics-gp

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 GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans