Journal Entry Detail Cost Transactions

Kinetic ERP
1

Hello all,

I am trying to put together a baq that displays all of the cost transactions journal entries are made of. So far I have found the transactions for finished goods under the PartTran table but I can’t find any foreign keys or links to the journal entry. When I use chart tracker and pull up the cost transactions for a journal entry it pulls up the correct data so I’m assuming there is a link somwhere. Does anybody know where that is? Or is the data I’m looking for in a different table?

2

TranGLC table will have most, if not all, of the links you’re looking for. The RelatedToFile column will show which table the record is linked to and then Keys 1-6 will be the foreign keys to those tables. There are also columns in TranGLC specific to certain types of data – for example, InvoiceNum, LaborDtlSeq, etc. that you can use directly.