Understanding Operational Reconciliation Update

Run the Update Operational Reconciliations report to update:

• Reconciliation status on transactions.

• Transactions with the operational reconciliation date.

• Gain/Loss Transactions File table (F41512).

• Inventory balances to reflect physical stock levels.

• Adjusting entries to the Item Ledger File table (F4111).

• Account Ledger (F0911) with adjustments to the Bulk Gain/Loss and the Physical Inventory accounts.

• Reconciled Thru Date on the Depot/Product Information form (after all tanks for a product are reconciled).

• Item Location File table (F41021) with the quantity on hand.

• Bulk Product Transaction File table (F41511) with the reconciliation status, reconciled flag, and the operational reconciled date.

The program does not enable retroactive adjustments. It rejects any record with a general ledger date that precedes the current accounting period.

You can run this program in proof mode before you complete the actual update. Proof mode enables you to review each transaction and verify the information before you update the tables. To run in proof mode, add a proof version and leave the Update Records processing option blank.

Failure of operational reconciliations might be due to:

• Company dates that are not current.

• AAIs that are not set up.

• Missing branch/plant constants.

• Lot numbers in transactions.

• A blank account unit of measure on AAI accounts or a missing conversion factor.