Skip to main content
Solved

Report Designer Parameter relation customer id and customer location id

  • February 17, 2022
  • 5 replies
  • 978 views

Forum|alt.badge.img
  • Jr Varsity III
  • 51 replies

How to set parameter from relation?
in report designer for now customer location id showing all data but I want filtering data customer location ID from customer ID.

please help me, im stuck

 

Best answer by BenjaminCrisman

Hi @abdi ! I have seen this request before and it can be a tricky one, but you need to find where these dependent parameters already exist sometimes.

In this case I would recommend the following setup for the Location parameter:

=Report.GetFieldSchema('ARPayment.CustomerLocationID,CustomerID')

When set like this, it will display properly:

Let me know if this was helpful, thanks!

 

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

5 replies

Forum|alt.badge.img+12
  • Acumatica Support Team
  • 871 replies
  • February 17, 2022

Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 51 replies
  • February 17, 2022

Hi @vkumar 

I've tried and it doesn't work. :frowning2:
I use a table relation between customer, location, address and contact.

can you tell me the right relation to filter data from CustomerID then CustomerLocationID


BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 706 replies
  • Answer
  • March 4, 2022

Hi @abdi ! I have seen this request before and it can be a tricky one, but you need to find where these dependent parameters already exist sometimes.

In this case I would recommend the following setup for the Location parameter:

=Report.GetFieldSchema('ARPayment.CustomerLocationID,CustomerID')

When set like this, it will display properly:

Let me know if this was helpful, thanks!

 


Forum|alt.badge.img
  • Freshman II
  • 14 replies
  • January 10, 2025
abdi wrote:

How to set parameter from relation?
in report designer for now customer location id showing all data but I want filtering data customer location ID from customer ID.

please help me, im stuck

 

I know this is an old topic but I was wondering if anyone would know if we still need to declare Relationships for the ARPayment? Or is using it directly for Report.GetFieldSchema should be okay?

Thank you in advance.


Forum|alt.badge.img
  • Freshman II
  • 14 replies
  • January 10, 2025
Crisel wrote:
abdi wrote:

How to set parameter from relation?
in report designer for now customer location id showing all data but I want filtering data customer location ID from customer ID.

please help me, im stuck

 

I know this is an old topic but I was wondering if anyone would know if we still need to declare Relationships for the ARPayment? Or is using it directly for Report.GetFieldSchema should be okay?

Thank you in advance.

I have set the relationships but Location parameter still coming up empty. 

I even change BAccountID to CustomerID and both did not have any output. 

 

Thanks in advance.

 

 

 


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