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

create multiple invoice from sales order

(1) Share

Report

Posted on by PS-20050952-0

While I can create sales orders to split invoices by quantity in Business Central , our client requires invoices to be split by amount rather than quantity. Is there a possible solution for this?/

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Saurav.Dhyani 14,380 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

Interesting but how they want to do that.

Scenario - a sales order has 5 lines and 2 quantity each and a total value of 1000.

How would they like invoices to split in this scenario?

Regards,

Saurav Dhyani

https://bit.ly/SubscribeSauravYouTube

Was this reply helpful? Yes No
Suggested answer

KasparsSemjonovs 4,766 Super User 2025 Season 2 on at

Like (3)

Report

If You are selling items, this is a weird ask from the Customer.
As if You sell 3 items, for 100 each, with total of 300, You cannot really divide the Amount to two Invoices of 150 each, because You normally Invoice what You have shipped/delivered.

Only way that I can think of to achieve this, can be done by adding additional G/L Account lines to the Order, 1 line of negative 300, and 2 lines of positive 150. Then You could mark that You are invoicing just the first line of positive 150, but this would still cause problems to mark when the items are invoiced (all items with 1st invoice, or all with 2nd), and the management of such process is quite hard. This also could ruin some reports.

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,202 Super User 2025 Season 2 on at

Like (1)

Report

you need to explain to customer this is not something out of box. you could either manually adjust the invoiced qty and amount.

or consider a customization. However, it would be key to find out why this is asked for and there might be other options.

Jun Wang

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,435 Super User 2025 Season 2 on at

Like (2)

Report
This is definitely possible out of the box by using item charges.

create a sales order where you ship this item and invoice with the 1st invoice amount

for each additional invoice, add an item charge line and apply it to the 1st item line shipment
invoice the item charge separately

I wrote a blog post how to invoice multiple customers from 1 sales order, you could do the same thing but you would have the same customer on all sales documents - Invoice Multiple Customers From One Sales Order - Dynamics 365 Business Central Insights. Alternatively, as I wrote above, since you only have one customer, you don't need to use separate sales documents. All the item charges can be added on the first sales order.

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
PS-20050952-0 69 on at

Like (0)

Report

Thank you to each and every one for providing your solutions and suggestions.

Was this reply helpful? Yes No