Skip to main content
Solved

Adding Salesmen Parameter to AR Aging report not working


Forum|alt.badge.img

Hello all,

I am attempting to add a salesmen parameter to my AR Aging report so I can run that report as it is relevant to each salesman. I have attempted to add a parameter, however it still returns all invoices, and not just the invoices based on the salesmen entered into the parameter. Here is how it is currently set up -

As stated, the report returns all invoices regardless on the salesperson ID entered into the parameter.

 

Thanks all!

Best answer by hkabiri

@aidenwills15 

 

The reason you get the empty results if you have selected any salesperson is that there was no record matching for that date and salesperson. However, if you want the report to show the results regardless of SalesPerson being seletced or not

 

  1. you should add a second line on the filter and use OR operator as you can see in my screenshot.

This way if you leave the parameter empty you still get the results.

  1. You can check allow null flag for SalesPersonID parameter on build schema and in second line on Filter tab simply use condition IsNull instead of Equal

 

View original
Did this topic help you find an answer to your question?

6 replies

Forum|alt.badge.img+10
  • Semi-Pro III
  • 229 replies
  • April 13, 2023

Hi @aidenwills15 ,

Could you please try below solution, As I am trying and got invoices based on the salesmen entered into the parameter.

Build Schema → Filter tab → Add Salesperson ID data field as below. 
 

Adding Salesperson to Report 

Hope, It helps!

Regards,

Sweta


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 25 replies
  • April 13, 2023

@sweta68 Hi Sweta, thanks for the response.

When I do that, it clears ALL data from the aging report

This is regardless of which salesmen is entered into the filter, and regardless of if there even is that filter active. The problem is resolved by removing that filter. Is there any additional setup I need to do this?

Thanks


hkabiri
Acumatica Moderator
Forum|alt.badge.img+7
  • Acumatica Support Team
  • 195 replies
  • Answer
  • April 13, 2023

@aidenwills15 

 

The reason you get the empty results if you have selected any salesperson is that there was no record matching for that date and salesperson. However, if you want the report to show the results regardless of SalesPerson being seletced or not

 

  1. you should add a second line on the filter and use OR operator as you can see in my screenshot.

This way if you leave the parameter empty you still get the results.

  1. You can check allow null flag for SalesPersonID parameter on build schema and in second line on Filter tab simply use condition IsNull instead of Equal

 


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 25 replies
  • April 13, 2023

@hkabiri Hi Sam, when I try to add that second line, the @SalesPersonID auto-populates to ‘DELETED’. Also, there are invoices that match the date and salesperson criteria. Are there maybe additional tables I need to setup?


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2621 replies
  • May 17, 2023

Hi @aidenwills15 were you able to find a solution? Thank you!


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 25 replies
  • May 17, 2023

@Chris Hackett Hi Christopher, I’m not sure how, but yes :) Thanks!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings