Skip to main content
Solved

APTranPostBal in a GI or Report

  • 17 June 2024
  • 3 replies
  • 47 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)? 

 

3 replies

Userlevel 7
Badge +10

What values are you specifically looking to get from this hidden table?  There may be other tables that are better suited.

Userlevel 4
Badge

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

Userlevel 7
Badge +10

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