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

Sales vs Prepayment

(2) Share

Report

Posted on by rcboiler

1,172

The 3rd invoice in this list is a prepayment invoice. you will notice it has a negative sales amount. should a prepayment invoice count against the total sales or simply not count?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

OussamaSabbouh 736 on at

Like (3)

Report

Sales vs Prepayment

Hello,

A prepayment invoice shouldn’t be counted in total sales since it’s an advance payment, not actual revenue.

It’s recorded as a liability until the final invoice is posted.

Only the final invoice reflects real sales in your reports.

Regards,
Oussama

1 people found this reply helpful.

Was this reply helpful? Yes No
rcboiler 1,172 on at

Like (2)

Report

Sales vs Prepayment

So you are saying that BC should be showing a 0 rather than a negative sales value, correct?

Was this reply helpful? Yes No
Suggested answer

Sumit Singh 7,861 on at

Like (1)

Report
Sales vs Prepayment

Hi,
In BC, a prepayment invoice represents an advance payment (deposit) requested from the customer before goods or services are delivered. It is not considered revenue at the time of posting because:

The amount is posted to a liability account (Prepayment G/L account) until the final invoice is issued.

The prepayment invoice does not affect actual sales revenue; it only reduces the outstanding balance on the order.

When the final invoice is posted, the prepayment amount is applied, and only then does the revenue get recognized.

Therefore, a prepayment invoice should not count toward total sales. It is a financial liability until the goods or services are delivered and the final invoice is posted.
Official Microsoft Documentation:

Invoice prepayments - Business Central

Set up and invoicing sales prepayments

Create prepayment invoices

Key excerpt:

1 people found this reply helpful.

Was this reply helpful? Yes No
rcboiler 1,172 on at

Like (1)

Report

Sales vs Prepayment

So we are in agreement that BC should not be showing the negative sales amount as indicated in the initial post, correct?

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 29,882 Super User 2025 Season 2 on at

Like (1)

Report

Sales vs Prepayment

In the Customer Ledger Entries, the prepayment invoice amount should appear as a positive value, not negative as shown in your screenshot. I tested it as well, and it shows as positive. Do you have any customizations that might be affecting this?

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

Rishabh Kanaskar 4,958 on at

Like (1)

Report

Sales vs Prepayment

Hi,

A prepayment invoice should normally show as a positive amount, because it represents an amount the customer owes (a receivable), not revenue.

Thanks

Rishabh

Was this reply helpful? Yes No