Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Customer Over Payments on single Invoice

Posted on by Microsoft Employee

Hi All,

Our Client want to tag over payments to a specific invoice rather than just close the Invoice and keep the payment entry open.

When customer is over paid for the particular invoice, they do not want to see that there is a payment credit outstanding on the payment. They  would like to see the over payment on the invoice line.

By Base, While Applying payment for invoice in NAV "Amount to Apply must not be larger than Remaining Amount" 

For example, if the customer paid $1020.00 on a $1000.00 invoice, is there a way for it to appear like the below example in the Customer Ledger Entry?

Posting Date

Due Date

Document Type

Source Code

Document No.

Customer No.

Customer PO No.

Original Amount

Amount

Remaining Amount

10/01/2017

11/01/2017

Invoice

Sales

123456789

10000

ABC123

1000.00

1000.00

-20.00

11/01/2017

11/01/2017

Payment

BANKDEP

Dep1234

10000

BDEP123456789

-1020.00

-1020.00

0.00

 

Please provide your suggestion and opinion for this request.

Thanks

*This post is locked for comments

  • Verified answer
    AJAnsari Profile Picture
    AJAnsari 5,754 on at
    RE: Customer Over Payments on single Invoice

    I fully concur with Alexander's recommendation not to customize NAV in this area. You can only apply a payment to a receivable in the amount of the receivable. It is not GAAP compliant to over-apply a payment to a receivable of a lower amount.

    You can either leave it open, or if your client does not intend to refund it or keep it around to settle a future receivable, then they must create an invoice (from a Sales Journal to keep it simple) for the difference and apply that to the Credit Memo.

    Ideally, they will leave it open either as an unapplied portion of the payment, or handle it as Alexander has suggested.

    I hope this helps. If my response has answered your question, please verify by clicking Yes next to "Did this answer your question?"

  • Verified answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Customer Over Payments on single Invoice

    It is not possible in standard. Also, I would strongly not recommend to make any customization to achieve this, as this would damage the standard logic of how the system works, e.g. on calculating currency exchange rates.

    I would rather post two separate payments, one for 1,000 and the other for 20, the second with a comment in Description "overpayment of invoice [tag:XXX]", so there is a track which invoice has been overpaid.

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