AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • Consulting
  • Login
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Report De...
Getting the salespe...
 
Notifications
Clear all

Questions Getting the salesperson name from a parameter

 
Acumatica Report Designer
Last Post by William Filipiak 2 years ago
3 Posts
2 Users
1 Likes
845 Views
RSS
William Filipiak
Posts: 10
 William Filipiak
Topic starter
January 3, 2022 11:38 am
(@wfilipiak)
Eminent Member
Joined: 4 years ago

Hi, In a lot of the Acumatica reports, when selecting a salesperson, the salesperson code (parameter) prints. 

Is there a way to get the Salesperson name to print? Is there a function to use or a table to join to use the parameter? 
An example of this is the Sales Profitability by Salesperson and Customer. 
The @Salesperson prints & We would like the Salesperson Description to print. 
Here is a pic of the Report. 

image

Thanks in advance for any assistance.

Bill

2 Replies
Kelly Burns
Posts: 11
 Kelly Burns
January 3, 2022 12:29 pm
(@kburns)
Active Member
Joined: 3 years ago

The field you're looking for is likely [ARTran.SalesPersonID_description].

Replace the @Salesperson with ARTran.SalesPersonID_description and see if that is what you prefer. 

Capture
capture2

 

Reply
William Filipiak
Posts: 10
 William Filipiak
Topic starter
January 3, 2022 2:57 pm
(@wfilipiak)
Eminent Member
Joined: 4 years ago

Excellent! Thank you! 

Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,363 Topics
  • 10.3 K Posts
  • 1 Online
  • 1,986 Members
Our newest member: Jay Sudak
Latest Post: Unable to Add Field "Unapplied Balance" to Generic Inquiry "Payments and Applications"
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2023 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×