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

Multiple Customers Making Payments for a Single Sales Order

(4) Share

Report

Posted on by Muzammil Ahmed

Hi Community,

I have a scenario where a customer places an order, and accordingly, I create a Sales Order in Business Central. However, at the time of payment, it’s not always the same customer who makes the payment — sometimes a different customer pays on their behalf.

In cases where only one other customer is paying, I simply change the "Bill-to Customer" field on the Sales Order to reflect the paying customer, and this works fine.

But I am unsure how to handle situations where two or more different customers are contributing payments for the same Sales Order.

Is there a standard way to manage this in Business Central? Has anyone figured out an effective solution or workaround for handling multiple paying customers against a single order?

Any guidance or suggestions would be greatly appreciated.

Thanks in advance!

Categories:

Dynamics 365 Business Central

All responses (7)

Answers (0)

Suggested answer

YUN ZHU 86,134 Super User 2025 Season 1 on at

Like (1)

Report

Multiple Customers Making Payments for a Single Sales Order

There is really no good way... If you just want the simplest customization, you can consider adding a final customer or payment customer, which is independent of the BC standard customer. You need to select this final customer when making Sales Invoice and Payment. In this way, the order is still the original order, but a reference field is added. This is much simpler than splitting the posted data.

Hope this can give you some hints.

Thanks.

ZHU
Suggested answer

RockwithNav 7,265 on at

Like (0)

Report

Multiple Customers Making Payments for a Single Sales Order

No, you can use the 'Bill-to' field to change the billing customer, but you can't assign two or three customers at the same time. Customizations are possible, but make sure the payment engine algorithms are properly validated

Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/
Suggested answer

Andrés Arias 1,384 on at

Like (1)

Report

Multiple Customers Making Payments for a Single Sales Order

Hello,

According to my understanding, the standard way would be to generate at cash receipt journal level the invoice settlement and open new transactions for each customer.

The next option would be to make a development to generate such collection automation to different customers.

I hope I can help.

Regards,

Andres
Suggested answer

Sohail Ahmed 4,844 on at

Like (1)

Report
Multiple Customers Making Payments for a Single Sales Order

Hope this might be helpful:

No, there is no standard functionality in Business Central to handle multiple customers making payments against a single Sales Order. The "Bill-to Customer" field on a Sales Order is designed to be a single entity responsible for the invoice and payment.

To achieve this, you would require AL code customization. This scenario is complex and typically involves:

Splitting the Sales Order: Creating multiple sales orders (or invoices) to reflect the different paying parties, even if they originated from a single "master" order.

Custom Payment Application Logic: Developing custom logic to apply partial payments from different customers to the same underlying original order/invoice, potentially using a linking table.

Manual Reconciliation: Relying on manual reconciliation outside the standard system or through custom reports to track payments from various sources against a single order.

It is highly recommended to contact your Microsoft Partner or an in-house developer to design and implement a custom solution for this specific business requirement.

✅ Mark this answer as verified if it helps you.
Suggested answer

Ramesh Kumar 5,503 on at

Like (1)

Report

Multiple Customers Making Payments for a Single Sales Order

Hi,

I would suggest using Cash Receipts Journal for posting payments if its involved more than 2 customers or see if you can create 2 different invoices.

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.
Muzammil Ahmed 38 on at

Like (2)

Report

Multiple Customers Making Payments for a Single Sales Order

Thanks @CU13051416-1, I think we will have to go with the customization as making different sales order for each payments sound very inefficient.
CU13051416-1 64 on at

Like (2)

Report

Multiple Customers Making Payments for a Single Sales Order

Hello,

Splitting payment responsibility across multiple customers on one order isn’t natively supported.

Common approaches and workarounds used in the field include splitting the Sales Order into multiple orders by creating separate Sales Orders for each paying customer, where each order corresponds to the portion paid by a specific customer.

Another approach is custom extension development, where a tailored solution is created to handle multiple payers linked to one Sales Order. For example, this could involve a “Payment Split” table associated with the Sales Order to track multiple payers and allocate payments accordingly. On the payment posting side, the logic would post incoming payments against the respective customer ledgers and then allocate them internally.

Hope this helps.

Best regards,