Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 22,647

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

  • Suggested answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    RE: How to Remove Transactions from Customer Record

    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

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: How to Remove Transactions from Customer Record

    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

  • Tim W Profile Picture
    Tim W 2,925 on at
    RE: How to Remove Transactions from Customer Record

    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.

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

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