Hello,
Having some trouble with this one. It seems like SysRowID should do the trick, but it’s not working out for me. I’m trying to get GLAccount, DebitAmount, and CreditAmount onto the PartTran rows. Any help is greatly appreciated!
need the tranGLC table.
Filter TranGLC by RelatedToFile = PartTran
keys are below.
select
[PartTran].[TranNum] as [PartTran_TranNum],
[PartTran].[PartNum] as [PartTran_PartNum]
from Erp.TranGLC as TranGLC
inner join Erp.PartTran as PartTran on
TranGLC.Company = PartTran.Company
and TranGLC.Key1 = PartTran.SysDate
and TranGLC.Key2 = PartTran.SysTime
and TranGLC.Key3 = PartTran.TranNum
where (TranGLC.RelatedToFile = ‘PartTran’ and TranGLC.FiscalYear = 2025)
order by TranGLC.FiscalYear Desc
1 Like
Thank you, Christian!