Ideas for Acumatica

Feedback processing: We do not reply to all messages, but we do read them, analyze them, and work to improve Acumatica based on the feedback we receive. Ideas and comments may not appear immediately. Some legitimate ideas are flagged as spam and will be added when we review the spam folders.
Content: This portal is for product ideas and feedback only. If you need customer service assistance, contact your Acumatica Support Partner, submit a support case, or get assistance from community resources: LinkedIn Group or StackOverflow
No Reliance: Information is maintained on a best-efforts basis and may be changed without notice. Acumatica cannot guarantee the accuracy of the information provided or guarantee completion of features/ideas described on this portal.

Add SalesPersonID_Description to the CustSalesPeople Table

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. 

  • Jonathan McDole
  • Jul 20 2018
  • Rejected
  • Attach files
  • Vladimir Panchenko commented
    11 Oct, 2018 02:31pm

    Hi Jonathan,

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