Reconciliation of articles(Purchase Orders)

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

 

When it's necessary

The missing adjustment of the average price of an article typically arises following the below handling of the order:

1. Order is invoiced for example with invoice date 31/1-2018
2. The financial period in which the invoice is posted is closed or locked by 31/1-2018
3. Order is delivered with delivery date 01/02-2018

As the financial period for the original invoice has been closed or locked, the system cannot automatically post the necessary adjustments, and therefore, cannot correctly adjust the article's average price.

 

How to solve it

To have the average price adjusted and consequently, the associated posted ledger entries for stock, you need to select Ledger > Reconciliation from the menu, then choose the tab 'Unpaid stock (purchase orders).'

1. You should only reconcile orders that have been both delivered and invoiced
2. Click on the menu on the far right of each order and select 'Reconcile Order.'

 

Decide bookkeeping date for the adjustments:

• You can choose to post the adjustments on the original invoice date, and thus post entries in a closed/locked financial period.
• You can also choose to enter another optional date on which the necessary adjustments are desired to be posted.

 

Effect of the reconciliation:

The financial accounts affected by the adjustments are:

1. 'Stock' for the involved article groups
2. 'Unpaid stock' for the involved article groups

On the article, the 'Average Price' on the stock management tab is affected.

---

---