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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Prepayment made - show...
Small and medium business | Business Central, N...
Suggested Answer

Prepayment made - show payment on final invoice?

(0) ShareShare
ReportReport
Posted on by Hamish Duff 37

Hi folks,

I can issue Prepayment invoices to customers fine - however the accounts department wants to show the prepayment received on the final invoice.

Essentially, prepayments are used for 50% deposit in this firm

The final invoice should show the full invoice details, payment already received, and then the balance owed.

Is there an easy way to achieve this, or is a custom sales invoice report required?

Cheers,

Hamish

Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    NAV_with_Narang Profile Picture
    NAV_with_Narang 2,294 Moderator on at

    Seems to me a custom report designed to show all the above parameters may be the most optimum way out.

    P.S.: Let's say you posted an invoice A with 50% prepayment. When you process the final invoice, a GL Line will show up in the final invoice, which will subtract the prepayment invoice's amount from your final invoice. To the best of my understanding when you print this final invoice, you should be able to see 2 lines, one with the original amount, second GL line with the prepayment amount deducted from the total. Check if this print works for you. If it doesn't get it customized

  • Hamish Duff Profile Picture
    Hamish Duff 37 on at

    Thanks for the incredibly speedy response Rahul. I'll get a custom report created, and try out the prepayment lines too.

  • NAV_with_Narang Profile Picture
    NAV_with_Narang 2,294 Moderator on at

    Thnakyou, do try and let me know how it goes. If it helps, do mark the above answer as verified so it helps other community members too and closes this thread.

  • RustyAustralis Profile Picture
    RustyAustralis 202 on at

    If you are serious about reports I'd seriously suggest ForNAV. We use them and have customised to do this without any coding and picture perfect. We also in our PTE show a starts view of prepayments showing if one is required, been created, been paid all from original sales line. It's all possible just not trivial.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans