Add SalesPersonID_Description to the CustSalesPeople Table

Related products: Platform
  • 20 July 2018

Add SalesPersonID_Description to the CustSalesPeople Table


I need to run reports (GI's with invoices and transaction data) that pull the account owner or "default sales person" for the customer. All i can get as a result is the CustSalesPeople.SalesPersonID, which displays as a number, not a name. 

Hi Jonathan,


In this case, you can join the SalesPerson table on SalesPersonID field and get the description from there (Descr field).


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 — 2020  Acumatica, Inc. All rights reserved