You’re offline. This is a read only version of the page.
Announcements
632
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.
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.
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).
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
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
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.
#1
André Arnaud de Cal...
294,033
Super User 2025 Season 1
#2
Martin Dráb
232,854
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
