Skip to main content
Solved

APTranPostBal in a GI or Report

  • 17 June 2024
  • 3 replies
  • 49 views

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.


@meganfriesen37 I want to grab these fields as they pertain to the payment. Ultimately, I want to pull this into Tableau for better analysis. 


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.


Reply