Skip to main content
Answer

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

  • February 9, 2023
  • 2 replies
  • 81 views
C
Jr Varsity II
Forum|alt.badge.img

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

Best answer by hkabiri

@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.

-Coleen

2 replies

hkabiri
Acumatica Moderator
Forum|alt.badge.img+8
  • hkabiri
  • Acumatica Support Team
  • Answer
  • February 9, 2023

@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.

SAM KABIRI | L2 Support Engineer | hkabiri@acumatica.com | www.acumatica.com
Chris Hackett
C
Jr Varsity II
Forum|alt.badge.img
  • coleenmcnally22
  • Author
  • Jr Varsity II
  • February 9, 2023

@hkabiri -- thank you that did it.

 

Appreciate the help,

 

Coleen

-Coleen
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