web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Need To Clean Up Custo...
Microsoft Dynamics GP (Archived)

Need To Clean Up Customer Credits

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

There are a handful of customers with credits, that I need to get removed.  If I remember, there are two steps but I cannot remember how to get this completed. Can someone please walk me thru it?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Need To Clean Up Customer Credits

    I think you are.

    Let me revisit your request. You asked if it was possible to write off credit balances on customer accounts so you could cleanup your Receivables module. I said you can create debit memos to apply to the payments or credits that are currently outstanding in your system.

    ---

    Now, you asked how do you see invoices with an outstanding balance - not a question related to your original question, but nonetheless I replied you can do so by printing a Receivables Trial Balance with Options and avoid excluding credits, presumably because you will want to know if there are credits you can apply to those outstanding invoices - this is a common practice.

    ---

    You replied that you are confused, because you are running a SmartList. Well, I did not say to run a SmartList. I asked you to run a tried and true report out of the system called the Receivables Trial Balance with Options, found under Sales > Reports > Trial Balance : Aged Trial Balance with Options. This report should show you invoices with outstanding balances.

    ---

    NOTE: To use the Aged Trial Balance with Options report, you will first need to run the Aging routine, under Sales > Routines > Aging, to be able to get the documents to show up in the correct aging bucket on the report.

  • Community Member Profile Picture
    Community Member on at
    RE: Need To Clean Up Customer Credits

    I may be confused because when I run a customers with credit report out of Smartlist and try to apply the amount against an invoice, the unapplied amount is the credit balance that I cannot apply to anything.

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Need To Clean Up Customer Credits

    You would first need to run a Receivables Trial Balance, this will tell you all customers with open balances. Be sure to not exclude credit documents (Sales > Reports > Trial Balance with Options).

  • Community Member Profile Picture
    Community Member on at
    RE: Need To Clean Up Customer Credits

    Now how do I find what invoices for that customer, have an outstanding balance after I've gone thru the steps of Sales->Transaction->Transaction Entry

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Need To Clean Up Customer Credits

    Then proceed to create the Debit Memos and apply against the outstanding credits. Note that my assumption here is your GL is correct, hence you will need to change the transaction distributions to be an in/out to the same account to avoid affecting the General Ledger.

  • Community Member Profile Picture
    Community Member on at
    RE: Need To Clean Up Customer Credits

    Simply to get them off of our books before year end.

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Need To Clean Up Customer Credits

    Is your intent to refund these customers or simply get rid of these credits off your customer accounts and books? 

    To enter a Debit Memo, go to Sales > Transactions > Transaction Entry. Select Debit Memo as the document type. Enter the amount of the debit memo to match the outstanding credit amount for that customer. Proceed to apply the Debit Memo to all invoices with an outstanding balance. Review the accounting distribution to make sure it is what you want.

  • Community Member Profile Picture
    Community Member on at
    RE: Need To Clean Up Customer Credits

    Because I'm not too familiar how to enter debit memos, could you walk me thru it please?These are for credit balances older than 2 years old, which were are trying to get rid of.

  • Suggested answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Need To Clean Up Customer Credits

    The solution will depend on whether the credits are legit or are simply balances that are just "hanging out there".

    If the credits are legitimate, you can offset with a debit memo.

    If the credits are just "out there" then you can enter debit memos, with an in/out to the same AR account to prevent impacting your AR account balance.

    In addition, if the credits are just floating documents on the customer account, you can void them out under Sales > Transactions > Posted Transactions

    Finally, you can always use the Refund Checks module to refund any credits you intend to reimburse to your customers. You can also use the Customer/Vendor Consolidation module to achieve this as well.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans