Skip to main content
Answer

APTranPostBal in a GI or Report

  • June 17, 2024
  • 3 replies
  • 118 views
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.

Luck is what happens when preparation meets opportunity. ~Seneca

3 replies

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

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

Megan Friesen, Contego Software Solutions, Canada
cmoreland
Chris Hackett
cmoreland
Semi-Pro III
Forum|alt.badge.img
  • cmoreland
  • Author
  • Semi-Pro III
  • June 19, 2024

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

Luck is what happens when preparation meets opportunity. ~Seneca
meganfriesen37
Captain II
Forum|alt.badge.img+12

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.

Megan Friesen, Contego Software Solutions, Canada
Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved