Reconciliation of articles (purchase orders)

Function for reconciliation of average prices and the ledger account Unpaid stock.

When is reconciliation necessary?

Lack of adjustment to an articles average price can occur in the following situation:

1. An order is invoiced with invoice date 20/01/2024
2. The financial period in which the invoice was posted is closed or locked as of 31/01/2024
3. The order is delivered later with delivery date 05/02/2024

When the financial period for the original invoice has been closed, the system cannot automatically post the necessary adjustments. As a result, the articles average price will not be correctly updated, and a difference will occur on the ledger account Unpaid stock.

How to fix it

To adjust the average price and update the related ledger entries for the stock:

1. Go to Finance > Reconciliation
2. Select the tab Unpaid Stock
3. Only reconcile orders that are both delivered and invoiced
4. Click the menu on the far right of the order and select Reconcile order

Select posting date for adjustment

When reconciling an order, you must choose which date the adjustments should be posted on:

• Original invoice date:
  The adjustments are posted using the original invoice date (may be in a closed or locked period).
• Custom date:
  You can instead enter another date on which the adjustments should be posted.

Effect of reconciliation

When the reconciliation is performed, the following ledger accounts and values are affected:

• Stock – for the involved article groups
• Stock, unpaid – for the involved article groups
• The Average price is updated on the article under the Stock Management tab

After reconciliation, the stock postings are corrected, and differences between invoice and delivery are balanced.
This ensures that average prices once again match the financial postings.

---

---