The APInvExp table in V8 had the GL accounts for the transactions for each invoice line. (ex: APInvExp.GLChart)
But E10’s APInvExp does not. The Data Dictionary for E10’s APInvExp only mentions:
RefType: Link to the related GLRefTyp.RefType. Not displayed.
and
RefCode: Link to the related Code in GLRefCod.RefCode
But a query of the APInvExp table shows those fields always blank.
Any Idea of where I can get the GL Accts (and the related Exp Amounts) from for APInvDtl’s and APInvMisc?