Solved

Adding Vendor Class ID to AP Register Report (AP621500) as parameter

  • 9 February 2023
  • 2 replies
  • 44 views

Userlevel 3
Badge

Hi!

I am trying to add the Vendor Class ID as a parameter on the AP Register Report - AP621500, the Vendor Table is not on the report.  I am not sure what relationships I need to create when I add the vendor table.  Any help would be appreciated.

 

Thanks,

Coleen

icon

Best answer by hkabiri 9 February 2023, 23:24

View original

2 replies

Userlevel 6
Badge +5

@coleenmcnally22  You probably need to add both Vendor and Vendor Class to this Report.

Use APRegister.VendorID = Vendor.BAccountID

and Vendor.VendorClassID=VendorClass.ClassID

to relate these Tables.

Userlevel 3
Badge

@hkabiri -- thank you that did it.

 

Appreciate the help,

 

Coleen

Reply


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