Reconciliation of inventory with Gl

Hi,

My user want to reconcile the inventory with general ledger, close inventory period and run all report to reconcile the inventory with inventory org.

kindly advise how to reconcile the inventory.

Kind Regards

hI

Please review:

Note 291005.1 - Costing Reports and Reconciliation

1485361.1 Analyzing Discrepancies in the Period Close Reconciliation report

1447211.1 A guide to Inventory Period Closing activities and Inventory-SLA-GL Reconciliation.

782305.1 - How to verify data Between GL And Inventory transactions through SLA.

779102.1  How to check for reconciliation problems between INV, SLA & GL R12

332250.1 Questions on Period Close Reconciliation Report and tables used

I would build a report that looks at the inventory cost distribution table gl_batch column and match that up to the reference column in the GL; that will be a direct reconciliation; anything in your inventory valuation accounts that does not fit within that filter should be manual entries or entries from other subledgers (hopefully  nothing from AP/AR going to your Inventory!!).