Skip to main content
Dynamics 365
  • 1 min read

Sales Order Prepayment Link Appears to be Lost When Partial Invoicing


When linking a prepayment to a sales order and the sales order is partially invoiced, the settlement for the remainder of the prepayment appears to be no longer linked.

The best practice when settling a prepayment against a Sales orders is as follows:

  1. Create Prepayment Payment Journal for $10,000

Accounts receivable > Journals > Payments > Payment journal

Payment journal.

Select the Payment tab and mark the “Prepayment journal voucher” box

Prepayment journal voucher.

Post the Prepayment

  1. Create a Sales order and link the Prepayment

Accounts receivable > Common > Sales orders > All sales orders

The Net amount for my item is $10,000 with a quantity of 5.

Sales order.

To link the Prepayment, click the Invoice tab > Settle > Open transactions and Mark the box next to the Prepayment.  Click Yes when you receive the message that the transaction is a prepayment.

Settle open transactions.

Close the Settlement open transaction form.

  1. Partially Invoice the Sales order. 

On the Sales order, change the Deliver now to 3 and partial invoice the sales order for the Delivery now quantity.

Post the invoice.

Posting invoice.

Click Invoice > Settle > Open transactions

Note that the remainder of the Prepayment is not settled.

Mark to settle the remaining prepayment amount

Marking to settle the remaining prepayment amount.

In the Sales order, change the Deliver now to the remaining 2 quantity and invoice

 If you go to the Customer > Collect tab > Settle > Closed transaction editing, you can see that the entire prepayment has been settled.

Closed transaction editing.

Note:  If you wish to settle the prepayment to the remaining invoiced quantity after the invoice has been posted, you must use the Customer form and then open the Open Transaction Editing form. 

Get started with Dynamics 365

Drive more efficiency, reduce costs, and create a hyperconnected business that links people, data, and processes across your organization—enabling every team to quickly adapt and innovate.