General Ledger Report

Kinetic ERP
,
1

I have been tasked with creating a General Ledger Report where the part transactions include the part class and product group. Is there a GL data table that already has the part number data or do I need to parse it from the description field?
TIA
Monica

2

If you’re using the TranGLC table, you can join the PartTran table when TranGLC.RelatedToFile = 'PartTran', and get the PartNum, ProdCode, and ClassID from there. The join looks like:

inner join Erp.PartTran as PartTran on
  TranGLC.Company = PartTran.Company
  and TranGLC.RelatedToFile = 'PartTran'
  and TranGLC.Key1 = PartTran.SysDate
  and TranGLC.Key2 = PartTran.SysTime
  and TranGLC.Key3 = PartTran.TranNum
1 Like
3

Thanks for the suggestion, I was using the GLJrnDtl table.