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

One sales order with two bill-two customers

(0) Share

Report

Posted on by AD-22040756-1

642

I have a scenario where I need to create one sales order which will be paid by two different customers. The sales order has 1 sell-to customer, and it is paid using 2 posted invoices with each invoice having a different bill-to customer.

For example a subsidiary of a customer places an order, which is paid 80% by the subsidiary and 20% is paid by the parent of the subsidiary. Both the subsidiary and the parent are setup as a customer in Business Central. For this reason, I want to create two posted sales invoices (1 for 80% of the sales order amount, and 1 for 20% of the sales order amount) that both originate from 1 sales order.

Any ideas how to make this work in BC, other than creating 2 separate sales invoices? I tried to create a sales order -> post 2/10th of the quantity to bill-to customer 1, then change the bill-to customer and post the remaining 8/10th but after the 1st posting the bill-to customer cant be changed anymore. I also tried using a blanket sales order but likewise, after 1 posting the bill-to customer cant be changed.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

KasparsSemjonovs 4,764 Super User 2025 Season 2 on at

Like (0)

Report

Only way would be to create 2 Sales Invoices.

I think You can still make 1 Order, and then do the shipping of 2/10 and 8/10. Then Create Sales Invoice and from the Lines use Function - Get Shipment Lines - this will link the Invoice to Specific Sales Shipment and once both are posted, the Sales Order can be deleted (manualy or by "Delete Invoices Sales Orders" process.

Was this reply helpful? Yes No
AD-22040756-1 642 on at

Like (0)

Report

thanks for the answer - the get receipt lines function unfortunately doesnt work for this scenario.

The get receipt lines function is filtered on the bill-to customer meaning that the sales order and invoice need to have the same bill-to customer. An invoice with bill-to customer x cant be created for a sales order with bill-to customer y

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

Hi

unfortunately you can't do this

imagining that from an order you detach 2 shipments and make a first invoice with SelltoCust=X and BillToCust=X using the aprima shipment,

then you make a asecond invoice with the second shipment SelltoCust=X and BillToCust=Y, business central does not allow you to do this

I think customization is needed, maybe imagining a feature that from one order you create two different invoices or two ready-made orders with the desired customers

check my answer if it helped you, thanks

DAniele

Was this reply helpful? Yes No
KasparsSemjonovs 4,764 Super User 2025 Season 2 on at

Like (0)

Report

Rechecked info on live level - and it seems that on Sales Line table system already adds the Sell-to Customer No. and Bill-to Customer No.
So only a modification can achieve the desired result - and there are several ways how this can be achieved - so talk it over with your partner or developer (if You have such in-house).

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (1)

Report

You will have to do a 'work around'

Customer 1's sales order - use the items, unit price and a 20% discount on each line

Customer 2's sales order - use item charges on the lines with quantity and unit price and put the item descriptions, do an 80% discount on each line. Of course with item charges, you have to do the assignment but this will then show the correct selling price for each item's entire sale

This should get each customer billed correctly and inventory counts will be correct.

I would do a test in your Sandbox.

Was this reply helpful? Yes No