Someone reactivated an old thread this week that links GLJEH to PO receipts, based on the fields DRILLDWNLK (drill down link) and DRILLAPP.  I had never used that before, but I tried it and it worked. For Inventory, the GL transactions might come from IC, PO, or OE, and multiple tables in each.  So you’d need a bunch of outer joins to those subledger tables, instead of the inner join - but this give you some idea:

www.sagecity.com/.../349341

Someone reactivated an old thread this week that links GLJEH to PO receipts, based on the fields DRILLDWNLK (drill down link) and DRILLAPP.  I had never used that before, but I tried it and it worked. For Inventory, the GL transactions might come from IC, PO, or OE, and multiple tables in each.  So you’d need a bunch of outer joins to those subledger tables, instead of the inner join - but this give you some idea:

www.sagecity.com/.../349341

Other than that, see if your GL has any journal entries, or IC Adjustments that debit and credit the same account.  That’s a fairly common mistake that can throw the GL out of balance with IC.

Thanks much!