Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Unanswered

Prepayment Breakdowns and Combine Sales Invoices

(0) ShareShare
ReportReport
Posted on by 15

We have recently set up prepayment set up in our SaaS BC.

I am unable to find answers to 2 of our concerns;

  • On Sales Order lines, if I have received lets say 3 batches, 1000, 1000, 1000. So my field Prep. Amount Deducted would show 3000. However, I would like to see for tracking purposes the breakdown of this 3000 where can I find it please?
  • If I have a Sales Invoice combined that was created from 2 different sales order which had prepayment, my Sales Invoice would have 1 GL Account customer deposit line, how can I know how did it get allocated, was it from SO 1, SO 2? Or both but then what percentages out of each two.

Thank you very much for the guidance.

  • HVGEEL Profile Picture
    HVGEEL 288 on at
    RE: Prepayment Breakdowns and Combine Sales Invoices

    Hi,

    on the first question: what exactly do you mean by breakdown? When using Prepayments, a Prepayment invoice is created for x% of the Order value. That does not break down. So please, enlighten us.

    on the second question: combining 2 orders on 1 invoice implies that they have been shipped, because that is what the Combine Shipment functionality does essentially.

    The orders being shipped, implies that they were released... and they can only be released when the Prepayment has been fulfilled on every single one of them.

    The resulting Sales invoices will result in 1 single Customer line, obviously because it is 1 single document.

    The amount for that single invoice will be the non-prepaid amount, posted as 1 Customer Ledger Entry.

    What sense does it make trying to figure out the percentage for the individual orders? The percentages will be those on your Sales Order. If you have 2 orders, one for 1 000 000, and one for 100, both prepaid for 50%... you have received 500 500 in prepayments.

    There is no application of "order"lines inside the Sales Invoice, it would make no sense, since the Prepayment invoices and the corresponding posted prepayment amounts have been applied upon payment receipt: that is a requirement to ship them... which brings us back to square 1.

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans