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

All responses (5)

Answers (0)

PS-20050952-0 69 on at

Like (0)

Report

create multiple invoice from sales order

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

Valentin Castravet 26,349 Super User 2025 Season 1 on at

Like (2)

Report
create multiple invoice from sales order

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/
Suggested answer

Jun Wang 7,604 Super User 2025 Season 1 on at

Like (1)

Report

create multiple invoice from sales order

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
Suggested answer

KasparsSemjonovs 4,075 Super User 2025 Season 1 on at

Like (3)

Report

create multiple invoice from sales order

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.
Saurav.Dhyani 14,302 Super User 2025 Season 1 on at

Like (1)

Report

create multiple invoice from sales order

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

Community site session details

create multiple invoice from sales order

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

Announcing Our 2025 Season 1 Super Users!

Kudos to the February Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

create multiple invoice from sales order

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

Announcing Our 2025 Season 1 Super Users!

Kudos to the February Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates