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, ...
Answered

Customer Payment Journal - Over Payments: D365 F&O

(0) ShareShare
ReportReport
Posted on by 307

Is there a setup for Settling Customer Payments that will allow us to:

#1 apply an over payment to an invoice that will then show a credit on the invoice

I keep getting this message and that tells me that there is a setup somewhere where we can allow over payments, I just don't know where it is at.

pastedimage1592314999160v1.png

I have the same question (0)
  • Verified answer
    Sandeep Chaudhury Profile Picture
    3,303 on at

    Vic, The parameter for the Maximum over payment or underpayment is under Accounts Receivable Parameters > Settlement tab. See screenshot below.

    COP.png

    Note that this functionality works with the Cash disc administration parameter under the same page. If you have this selected as Specific, then the OP amount remains on customer balance if the OP amount is more than the max amount. If you have this selected as Unspecific, then Cash discount amount is is reduced regardless.

  • Vickie8346 Profile Picture
    307 on at

    Is there a way that the over payment applies to the invoice vs. creating an over payment/underpayment voucher?  Here is an example:

    Invoice: 12345 = $200.00

    Payment: 678 = $300.00

    I want to apply all $300.00 to the invoice so that the invoice now reflects $-100.00

    Does that make sense?  Our old system did that and I really want to figure out how to do this in D365 F&O

    vs now there is a $-100.00 on the customer account which has no reference to it.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    300,911 Super User 2025 Season 2 on at

    Hi Vickie,

    This is not how the settlements work. In Dynamics 365, it will only settle the invoice for $ 200 and have a remaining open amount on the payment. The scenario you were used to in your old system is not supported.

    You can then decide to settle the remaining payment amount against another invoice or reimburse the customer.

  • Verified answer
    MATTGUO Profile Picture
    22,349 Moderator on at

    Hi Vickie,

    Is the payment settled once or only for that invoice?

    If so, you can find the reference from the settlement history or manually enter the payment reference on the payment journal.

  • Suggested answer
    Junaid Idrees Profile Picture
    on at

    Vic,

    Yes you can book over payment. That is default functionality but let me explain you how exactly it works,  If your invoice amount is $200, create a payment with $300 and apply against that invoice.  D365 FO will settle that invoice (It will be closed) and will book remaining payment 100 $ as advance and that you can use for next invoice. This is absolutely correct from business & accounting perspective & system also support that.

    Yes even in D365 FO you will not see any invoice reference against that $100 transaction.  It will just show you -100 balance against that customer :)

    Try it out and let us know if you face any issue.

  • Junaid Idrees Profile Picture
    on at

    Hi Vic,

    If your question is answered then please mark this case as verified to help others with same question. Thanks

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 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans