Dynamics Community Forum Thread Details

Prepayment Breakdowns and Combine Sales Invoices

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.

Categories:

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.

Quick Links

Leaderboard