General Ledger Report AR Invoice Desc

Epicor ERP 10
, ,
1

Hi All,

I try to design gl report by using baq due to Epicor standard gl report don’t have line description.
Then I use below script to link InvcDtl to GLJrnDtl
select Max(b.LineDesc) from GLJrnDtl as a
left join InvcDtl as b on
a.company = b.company and a.arinvoicenum=b.invoicenum and a.creditamount=b.docextprice
But then if got transaction same total amount in same invoice line, both line will showing max length desc.
Appreciate for any reply.
My Epicor version 10.2.500.20
Thanks!

2

Take a look at the TranGLC table instead.

1 Like
3

dear ckrusen, thank you very much! love you.

4

Do you know if this is possible in Epicor Vista 8.03? I’m not seeing the TranGLC table

5

I think the GL accounts are stored right in the PartTran table (in 8.03)

6

Will that tie to AR invoices? I’m trying to pull all GL Journal details but include the AR Invoice info. Such as part, description, quantity etc.