I have a generic inquiry “Bills and Adjustments.” I would like to add the GL code that was used during the input of that bill. My end goal is to be able to export the B&A report and sort by vendor and gl code.
Answer
Add GL code to Bills and Adjustments report
Best answer by meganfriesen37
For the GL Code - I’m assuming you mean the AP account that the bill was posted to and not the various expense accounts?
If you want the AP Account - APInvoice.APAccountID
If you want the line item details, you’ll need to join the APTran table and add APTran.AccountID. But watch out for how you’re totaling items then between the APTran and APInvoice tables because you could have multiple APTran lines per APInvoice.
Is this in reference to the Batch Nbr that is present on the bill?
If so, it would be the BatchNbr data field from the APInvoice DAC.
+12For the GL Code - I’m assuming you mean the AP account that the bill was posted to and not the various expense accounts?
If you want the AP Account - APInvoice.APAccountID
If you want the line item details, you’ll need to join the APTran table and add APTran.AccountID. But watch out for how you’re totaling items then between the APTran and APInvoice tables because you could have multiple APTran lines per APInvoice.
Megan Friesen, Contego Software Solutions, Canada
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.