Problem Statement

When a Sales Order includes prepayments and the order is subsequently invoiced, Business Central correctly deducts the prepaid amount from the final invoice and considers the related prepayment line fulfilled.

However, if the invoiced item is later returned and a Sales Credit Memo is posted, the associated prepayment amount is not automatically considered when resetting the invoiced and prepaid status of the transaction. This creates inconsistencies in the return process and requires users to perform additional manual corrections.

Current Behavior

1. A Sales Order is created with one or more prepaid lines.
2. The prepayment invoice is posted.
3. The final sales invoice is posted, and the prepaid amount is deducted as expected.
4. The customer returns the item, and a Sales Credit Memo is posted.
5. The return reverses the sale, but the original prepayment relationship is not fully restored or reconciled.
6. Users must manually process additional prepayment credits and perform further corrections.

In scenarios where the same order contains additional prepaid lines that have not yet been fulfilled, using the Post Prepayment Credit Memo action may credit all prepaid lines on the order, including those unrelated to the returned item. This can create further reconciliation work and increase the risk of accounting errors.

Expected Behavior

When a Sales Credit Memo is posted against an invoiced sales transaction that originated from a prepaid Sales Order, Business Central should provide a mechanism to automatically reconcile the related prepayment amounts.

Possible approaches include:

• Automatically restoring the appropriate prepayment balance associated with the returned transaction.
• Providing an option during return processing to reverse or reapply the related prepayment entries.
• Allowing prepayment credits to be generated only for the specific returned lines rather than all outstanding prepaid lines on the order.

Business Impact

The current process:

• Creates a cumbersome and error-prone return workflow.
• Requires manual accounting adjustments.
• Can result in duplicate or excess credits being generated.
• Increases the effort required to manage partially fulfilled prepaid orders.
• Causes confusion for end users who expect a return transaction to fully reverse the financial effects of the original sale, including prepayments.

For organizations that frequently use prepayments, this behavior increases administration overhead and introduces unnecessary complexity into standard return scenarios.

Requested Enhancement

Please enhance the Sales Return and Prepayment functionality so that prepayment amounts are automatically and accurately reconciled when processing returns and credit memos, reducing manual intervention and ensuring a more consistent end-to-end business process.