Skip to main content


How to Handle Sales Invoice Cancellation with Different Shipment and Invoice Dates in Business Central

Jun Wang Profile Picture Jun Wang 4,053 Super User


How to Handle Sales Invoice Cancellation with Different Shipment and Invoice Dates in Business Central

In the realm of sales and distribution, handling transactions with varying shipment and invoice dates can present a challenge, especially when there's a need to reverse or cancel the entire chain of events. This complexity arises in scenarios where, for instance, a sales order (SO) is converted to a sales shipment on one date and invoiced on another. Reversing these transactions requires careful consideration to ensure accuracy in both the customer and item ledger entries.

The Scenario
Consider a situation where a sales shipment is posted on the last day of February, but the invoicing is completed on the first day of March. Now, should the need arise to cancel these transactions, the objective is to reverse the customer ledger entries on the invoice date (1st March) and the item ledger entries on the shipment date (28th February).

The Challenge
The crux of the challenge lies in ensuring that the reversal entries reflect the original transaction dates, which are critical for accurate inventory management and financial reporting. A standard cancellation might post the return entries on the same date, potentially causing discrepancies in inventory counts or financial statements.

The Solution: Sales Return Order
The solution to this issue is to utilize a sales return order within Microsoft Dynamics 365 Business Central. This approach provides the flexibility needed to address the different dates of the transaction reversal accurately. Here’s how you can implement it:

  1. Initiate a Sales Return Order: Create a new sales return order to handle the reversal of the shipment and invoice separately.

  2. Set Different Posting Dates: When processing the return order, specify the posting date for the item return shipment as the original shipment date. Similarly, set the posting date for the credit memo as the original invoice date.

  3. Separate Reversals: By separating the reversal of the shipment and the invoice, you can accurately reflect the transactions in your item and customer ledger entries corresponding to their original dates.

Benefits of Using a Sales Return Order

  • Accuracy in Financials: Ensures that financial records reflect the correct reversal date, which is essential for period-end reporting.
  • Inventory Management: Keeps the inventory levels and movements consistent with actual historical data.
  • Compliance: Maintains compliance with accounting principles and audit requirements.

Reversing a sales invoice in Business Central when the shipment and invoice dates differ requires a nuanced approach. By leveraging the sales return order functionality, businesses can maintain precise control over their financial and inventory records, ensuring both sets of ledger entries reflect the correct historical dates. This method underscores the importance of understanding and utilizing the comprehensive features available in Business Central to manage complex scenarios effectively.


*This post is locked for comments