Skip to main content
Answer

Union Customer Details and Vendor Details at one table

  • October 9, 2025
  • 1 reply
  • 20 views
B
Semi-Pro III
Forum|alt.badge.img+1

I need to union Customer Details and Vendor Details at one table(by business account). How i can do this?

 

 

Best answer by Django

You can start with the BAccount table as it contains customers and vendors (and employees and companies). Then you can left join to the Customer and Vendor tables.

Edit: You might also look at a projection (very similar to using a database view) to pull all of this data together for easier reporting.

1 reply

D
Captain II
Forum|alt.badge.img+7
  • Django
  • Captain II
  • Answer
  • October 9, 2025

You can start with the BAccount table as it contains customers and vendors (and employees and companies). Then you can left join to the Customer and Vendor tables.

Edit: You might also look at a projection (very similar to using a database view) to pull all of this data together for easier reporting.

Chris Hackett
B
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