Reconciliation Scenario 6

Diagram of reconciliation scenario 6

This scenario shows two locations, A and B. Location A contains a single stockpile 1, and location B contains a single stockpile 2. Both stockpiles have their product types set to single, and the product to Product 1.

The scenario also shows a single transaction from stockpile 1 to 2, using a process flow PF1. This process flow's source is location A and destination is location B.

Opening balances (as at the start of the month):

  1. 1000 t
  2. 400 t

Transactions:

  1. 20th of the month, 10 t, Process flow PF1

Closing balances (as at the end of the month):

  1. 990 t
  2. 410 t

Run a reconciliation on location B, of type Factorise. Change closing balance of stockpile 2 to 395 t. This introduces a discrepancy of -15 t which needs to be factored amongst the incoming transactions (in this case, only one transaction).

However, the new tonnage of transaction 1 would be negative (10 t - 15 t = -5 t), but negative tonnages are not allowed in transactions. Therefore, the discrepancy can only be cancelled by an adjustment of 15 t.

After commit, the expected results are:

  • Survey of stockpile 2 of 395 t (with reason code Recon) at the end of the month.
  • Total adjustment for location B: 15 t.
  • Total adjustment for product Product 1 in location B: 15 t.
  • Transaction 1 has tonnage untouched.