Hello,
Which table(s) do we need to use to link GL entries in GLJED back to the transactions in the subledgers?
Ty.
There is no simple answer, different modules use different tables. What are you trying to accomplish?
Track inventory transactions from the GL entries to the subledger. Thanks.
Not possible
So how do you reconcile? I am working on a valuation that does not balance with the GL but did at the end of last month.
You can't link directly from GLJED to any I/C tables, so you'll have to analyze it at a different level like transaction date.
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:
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!
also look for non stock items where the non stock clearing account has been entered as the stock account - causes so much grief!!
Check source codes in GLPOST against ICIVAL to see if you have a difference for a source type and then go from there
Thanks you Eva.
*Community Hub is the new name for Sage City