Inventory Reconciliation

See the latest version of this topic on Keystone Help Site

Topic Highlights:

Steps to Reconcile Inventory
ARTPRTRX transaction types

Understanding the Reconcile Process

The reconcile process looks at only unreconciled transactions, starting with 'B' Balance transactions. The normal starting condition is for there to be just one unreconciled 'B' record all the transactions for the current period and possible some backdated unreconciled transactions for the prior period.

Get the beginning balance (This is normally a single unreconciled 'B' transaction)
Process all transactions in timestamp sequence including any the prior month.
- Create G/L Transaction for where appropriate
- Update the artprtrx record with
  - New cost value
  - Reconciled Flag set to Yes
  - Set Recon Session No and Recon Trans No
Write an Unreconciled 'B' record with the updated cost and quantity on hand

Simple Diagnostics

You can run this query to see the transactions that will be viewed in the process.

SELECT * FROM ARTPRTRX
WHERE PRODUCT_CODE='xxxx'
AND RECONCILED_FLAG='N'
ORDER BY TRX_DATE,TRX_TIME

The 'B' Record will appear in timestamp order, but the process will always place 'B' records first.

Inventory Reconciliation