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 :
Microsoft Dynamics NAV (Archived)

Reflecting payments on invoices

(0) ShareShare
ReportReport
Posted on by

Hello and thank you in advance for the excellent help I always receive on this forum.  This time I have am having an issue with the very basic concept of reflecting a customer's payment on an invoice.  I have been told by my company who set up the NAV system that it is not possible to reflect a customer payment on an invoice and I cannot believe that this can be.  I have never worked with any system that did not provide a mechanism to reflect a customer's full or partial payment.  

I have attached a sample invoice to illustrate my problem.  This customer pre-paid for their order by check and should receive an invoice reflecting that their bill is paid in full, but instead this is the invoice they were sent.  I am told there is no way to indicate a payment by check in the NAV system with a balance due of zero.  As you can imagine, a customer who has already sent a payment of $6,475 is fairly irritated when they receive an invoice reflecting that the full amount is still due.  

Is it true that NAV does not have the ability to reflect a payment received and zero balance or remainder due?  And that every invoice must have the full amount of their order regardless of whether or not it is partially or fully paid?  I have never heard of a system like this and do not understand the reasoning behind it (as I do not understand how Microsoft cannot make allowances for the fact that every company in the US accepts payment at a PO box and needs to be able to reflect this on the customer card.)

Thanks in advance for your help.

Alison

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Jens Glathe Profile Picture
    6,092 on at

    Hi Alison,

    there are several ways to do this in NAV. One is to use the prepayment functionality. In this case you require a prepayment, though. The workflow is a little different, and the invoice reflects only these prepayments.

    The other way would require some customization, but not much, IMO. You could add a section on the invoice document where the payments/credit notes applied to this invoice and (?) the payments/credit notes not applied and not marked as "on hold" are shown. Then you show the resulting balance of the customers account. Should not be too complicated to implement it, all the data is there. If you need repeatability of the printout, you should either archive this document after printing (the listing of the balance of the customers account is only a snapshot) or you need extra archiving tables to achieve this. An alternative method would be to "lock" the application when it has been printed. This would require that you do the application of the payment before printing. The application can be done from the unposted invoice, so it would be viable.

    with best regards

    Jens

  • Verified answer
    Rashed Profile Picture
    3,765 on at

    Hello.  You need a mod to make a modification to the report. i've done it for other clients.  shouldn't take that long

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 > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans