Solved

Report Designer Parameter relation customer id and customer location id

  • 17 February 2022
  • 3 replies
  • 701 views
A
Rank
Userlevel 3
Badge
  • abdi
  • 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

 

icon

Best answer by BenjaminCrisman 4 March 2022, 22:38

View original

3 replies

V
Rank
Userlevel 7
Badge +11

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,

 

VijayKumarU
A
Rank
Userlevel 3
Badge

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
Rank
Userlevel 7
Badge +4

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!

 

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved