AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register

— The Forums are now read-only —

— All new activity now takes place here: —

AugForums.com Discord Server
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 4 years ago
3 Posts
2 Users
1 Reactions
1,616 Views
RSS
William Filipiak
Posts: 10
 William Filipiak
Topic starter
January 3, 2022 12:38 pm
(@wfilipiak)
Eminent Member
Joined: 6 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 1:29 pm
(@kburns)
Active Member
Joined: 6 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 3:57 pm
(@wfilipiak)
Eminent Member
Joined: 6 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,533 Topics
  • 11 K Posts
  • 47 Online
  • 2,438 Members
Our newest member: Ralph Torres
Latest Post: Nested SubReport Issue
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

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

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×