I would like to run a report with the data in the APTranPostBal “table”; however, it is hidden in the DAC. Has anyone used a variation of this in a GI (preferably)?
I would like to run a report with the data in the APTranPostBal “table”; however, it is hidden in the DAC. Has anyone used a variation of this in a GI (preferably)?
What values are you specifically looking to get from this hidden table? There may be other tables that are better suited.
The APAdjust table is what links the APInvoice and APPayment tables together with this information.
Or if it’s just totals by vendor by period, then take a look at APHistoryForReport.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.