Skip to main content
Solved

APTranPostBal in a GI or Report

  • Jun 17, 2024 4:02 PM UTC
  • 3 replies
  • 169 views
  • Translate All

cmoreland
Semi-Pro III
Forum|alt.badge.img

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)? 

 

Best answer by meganfriesen37

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.

View original

3 replies

meganfriesen37
Captain II
Forum|alt.badge.img+13

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

Translate

cmoreland
Semi-Pro III
Forum|alt.badge.img
  • Author
  • Semi-Pro III
  • Jun 19, 2024 2:12 PM UTC

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

Translate

meganfriesen37
Captain II
Forum|alt.badge.img+13

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.

Translate