Corresponding GL debit/credit transaction for a Part Transaction


TranGLC to PartTran

 

Company --> Company

Key1       --> SysDate

Key2       --> SysTime

Key3       --> TranNum

I’m trying to write a report that can tie a part transaction to its debit/credit transactions in the GL.  Any ideas?

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055
 
email:  MAbell@...

 

 

There's an excel file in the "Files" section called "TranGLC_Keys", which shows how to connect different tables to TranGLC. You can connect PartTran to TranGLC based on the system date, time, and transaction #. We do this both in a BAQ and an SSRS report.