Reconciliation Scenario 7
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.
The reconciliation template configuration contains two locations B and A. The reconciliation type for location B is Factorise, and the reconciliation type for location A is Adjust. Reconciliations are performed for product Product 1 in both locations.
Additionally, for factorise type reconciliations, there is a weighting assigned to each process flow into the location, for a particular product. The total must add up to 100%.
The order of the locations is important: in this case, location B must be reconciled before A.
Opening balances (as at the start of the month):
- 1000 t
- 0 t
Transactions:
- 20th of the month, 200 t, Process flow PF1
Closing balances (as at the end of the month):
- 800 t
- 200 t
Run a reconciliation on location B, of type Factorise. Change closing balance of stockpile 2 to 250 t. This introduces a discrepancy of 50 t which needs to be factored amongst the incoming transactions (in this case, only one transaction). This has a follow-on effect: location A now has a closing balance of 750 t because the outgoing transaction tonnage has been changed.
Run a recon on location A, of type Adjust. Change closing balance to 775 t. This introduces a discrepancy of 25 t which is cancelled by an adjustment of -25 t.
After commit, the expected results are:
- Survey of stockpile 2 of 250 t (with reason code Recon) at the end of the month.
- Survey of stockpile 1 of 775 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.
- Total adjustment for location A: -25 t.
- Total adjustment for product Product 1 in location A: -25 t.
- Transaction 1 has tonnage changed to 250 t. (The old tonnage is stored in the table BulkTransactionExt, in the field Double5.)
