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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

AR Credit Memos and Payment terms

(0) ShareShare
ReportReport
Posted on by 75,850 Moderator

Why is it when you go to enter an A/R credit memo does the payment term box go dim?

This makes for extra work when you have a customer who takes a discount when they should not and then on you agree to give it to them

When you go to enter the credit memo it now applies the customer's discount to the credit memo and you get stuck in an endless loop.

The only way I found to stop this was to go to the customer card first and change the payment term.

It would be a lot easier to simply change the payment terms on the credit memo.

Categories:
I have the same question (0)
  • Suggested answer
    Cheryl Waswick Profile Picture
    on at

    Hello Richard, 


    Payment terms only apply to 'Invoice' type documents that need to be paid, and so the 'payment term' field is available for the document types of invoices, debit memo's, finance charges and service/repair.  The amount is due and if they pay early then a discount is taken at the time of payment.   The payment term follows the invoice, not the payment document.   That is why if you select any 'payment' types such as credit memo's, returns, warranties, or cash receipts, the payment term field then becomes unavailable.  You do not put a 'payment term' on a 'payment type' because it already is a payment.

    The discount is driven by the 'payment term' on the invoice that you are applying the credit memo to, and the 'Apply date'  that is used.     (You can see in the RM20101 that invoice type documents carry the payment term in the PYMTRMID column, and this is blank for any cash receipts or credit memo's or payment type records.) 

    The documents are already keyed, so changing it at the customer card level really wouldn't have any impact on posted documents. 

    Under Transactions | Sales | Edit transaction Information, you can change the 'discount date' for the invoice that you are applying the credit memo to.   If the customer has a 2%/net 10' payment term, and that is carried on the invoice (inv date of Feb 1 for example), then 2% will be taken if you apply a cash receipt or credit memo prior to Feb 10, and will not be taken if you apply it 10 days after.  So you really can drive whether the discount is taken or not, by adjusting the 'discount date' on the invoice itself to be before or after the apply date you are using.   

    Hope that helps.   Do some testing and review the window above to see for yourself. 

    Thanks

    Cheryl Waswick

    Microsoft Dynamics GP 

  • Richard Wheeler Profile Picture
    75,850 Moderator on at

    Cheryl, that is a good alternative. Changing the payment terms on the customer card before entering the credit worked as well. This way no discount was applied to the amount.

  • Cheryl Waswick Profile Picture
    on at

    Hi Richard, 

    Respectully I do not agree.   It matters if the invoice you are apply to has a payment term on it or not, and the 'date' you are applying the credit memo/payment to the invoice in comparison to the nvoice date.  It's not going to matter what is on the customer card at the time you apply, unless you have a 3rd party product that changes the way it works out of the box.   It is best for the user to know what the payment term is, and then drive the 'discount date' in the 'Edit transaction information' window on the invoice they are apply to, to either before before or after the apply date for the credit memo.   It's totally date-driven, so what is on the customer card at the time will not matter.  The invoice you are applying to already had the payment term on it, so that is what you need to be aware of and then drive the dates from there. 

    Cheryl

    Microsoft Support

  • Richard Wheeler Profile Picture
    75,850 Moderator on at

    That is true Cheryl. In the case I just corrected it was from last year. I entered the credit memo after changing the payment terms. When I then applied the credit memo to the invoice I changed the shortage to Write-Off Amount and then adjusted the distributions.

    I must admit your solution is much cleaner and will use that going forward. The bottom line on both is this old invoice was finally moved to history. Thanks for the tip.

  • Richard Wheeler Profile Picture
    75,850 Moderator on at

    Cheryl, the other issue I had was over a measly $8.11. They had taken the discount when they should not have taken it.  So they had short paid by $230.44. They were 1.73% NET 30.

    The date of the invoice was 04/07/2021. They paid on 05/10/21. When I went to apply the credit memo on 02/04/2022 it kept giving them a discount of $8.11. They did not qualify for the discount it was mystery as to why GP was doing this.

    RM20101.DSCAVAMT and RM20101.DSCTKAMT where both $230.44.

  • Cheryl Waswick Profile Picture
    on at

    There is a reason for everything... (smile!).   GP either takes the full discount for the payment term or it doesn't, which sounds like $230.44 was the full discount amount.   If another discount is being taken for $8.11 then I would next check to see if there is a 'trade discount' set up on the customer.  This is a separate discount from the payment term.

  • Richard Wheeler Profile Picture
    75,850 Moderator on at

    Cheryl, I just found myself in a recursive function with diminishing returns. The $8.11 is 1.73% of $230.44. That is the discount percentage. GP just kept fighting me. All is well right now. It was a pleasure virtually chatting with you.

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…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 451 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 428 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans