Linking APInvMsc to APInvExp

Kinetic ERP
, , ,
1

Is there a way to link the APInvMsc table to the APInvExp table? I have a dashboard for AP Invoice Miscellaneous Charges and they want to see the GL Account for that transaction.

I can link the TranGLC table to the APInvExp table to get the GL Account but I can’t figure out how to limit it to just the Miscellaneous charges.

Thanks,
Jeff Martinson

2

You need to follow the below flow to have all data from APInvcMsc only.

image
image876×97 3.95 KB