Skip to main content
Answer

Report Designer Parameter relation customer id and customer location id

  • February 17, 2022
  • 6 replies
  • 1172 views

Forum|alt.badge.img

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!

 

6 replies

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

Hi @abdi 

Please refer to following posts which guides you through the process.

An example could be found on following posts :

Hope this helps,

Regards,

 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 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
  • 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
  • Jr Varsity III
  • January 10, 2025

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
  • Jr Varsity III
  • January 10, 2025

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.

 

 

 


stacy16
Varsity I
Forum|alt.badge.img+1
  • Varsity I
  • June 5, 2025

Hello!

I am trying to add customer location parameter to the Sales Order Details By Customer report. We just upgraded to 2024R2. I read through all the comments on this thread and nothing I am trying is working 😞 Below are screen shots of the schema builder in report designer. Any ideas what I am doing wrong? Help!