Reconciliation Scenario 8
Opening balances (as at the start of the month):
- 1000 t
- 0 t
Transactions:
- 20th of the month, 300 t, Process flow PF1
- 21st of the month, 500 t, Process flow PF2
Closing balances (as at the end of the month):
- 200 t
- 800 t
Run a reconciliation on location B, of type Factorise. Change closing balance of stockpile 2 to 840 t. This introduces a discrepancy of 40 t which needs to be factored amongst the incoming transactions.
First the contributing tonnage factors for each process flow are calculated:
Factor = (Total transaction tonnes of process flows into product ) * (Process flow weighting for product)
Therefore, for PF1: 300 t * 60% = 180 t, and for PF2: 500 t * 40% = 200 t, a total of 380 t.
Then calculate the weighting for each process flow:
Weighting = (Factor for the process flow) / (Total of all factors for the product)
Therefore, for PF1: 180 t / 380 t, and for PF2: 200 t / 380 t
The new transaction tonnes are then calculated using these weightings:
New tonnes = Old tonnes + Discrepancy * Weighting for process flow
Therefore, new tonnes for Transaction 1 = 300 t + 400 t * 180 t / 380 t = 318.947 t,
and new tonnes for Transaction 2 = 500 t + 40 t * 200 t / 380 t = 521.053 t
After commit, the expected results are:
- Survey of stockpile 2 of 840 t (with reason code Recon) at the end of the month.
- Total adjustment for location B: 0 t.
- Total adjustment for product Product 1 in location B: 0 t.
- Transaction 1 has tonnage changed to 318.947 t. (The old tonnage of 300 t is stored in the BulkTransactionExt table, in the field Double5.)
- Transaction 2 has tonnage changed to 521.053 t. (The old tonnage of 500 t is stored in the BulkTransactionExt table, in the field Double5.)
