How to build Generic inquiry filter relation?
i want show customer location ID filter from customer ID?
Answer
Generic Inquiry filter relation
Best answer by Naveen Boga
Hi,
In addition to the above comment, you cannot build a relationship between the Customer ID and Customer Location ID fields in the Generic Inquiry, this will come based on the screen design.
Here is an example and screenshot for your reference.
Screen → SO301000 (Sales Order screen)
- In the Sales Order screen, we can see the Customer ID and Customer Location ID fields on the header section.
- In the screen level, until you select the Customer ID field, Customer Location ID will not the field values.
- The relationship is already built on the screen, when you use these fields in the Generic Inquiry, you can see the same behavior, it is NOT required to build relationship.
Screenshots
- In GI screen, I have created the 2 parameters i.e., Customer ID and Customer Location ID.
- Customer Location ID field, will not load the values if there is Customer ID value (Relationship will come as-is from screen to GI)
Hope this info will helps you!!
+1Instead of Generic Inquiry you can achieve this by creating a custom inquiry screen, where we will have feasibility to achieve the expected results i.e. by modifying the selector of the second filed in the DAC or a by creating a custom selector if it involved complex logic.
Thanks
Vinay Koppula
+19Hi,
In addition to the above comment, you cannot build a relationship between the Customer ID and Customer Location ID fields in the Generic Inquiry, this will come based on the screen design.
Here is an example and screenshot for your reference.
Screen → SO301000 (Sales Order screen)
- In the Sales Order screen, we can see the Customer ID and Customer Location ID fields on the header section.
- In the screen level, until you select the Customer ID field, Customer Location ID will not the field values.
- The relationship is already built on the screen, when you use these fields in the Generic Inquiry, you can see the same behavior, it is NOT required to build relationship.
Screenshots
- In GI screen, I have created the 2 parameters i.e., Customer ID and Customer Location ID.
- Customer Location ID field, will not load the values if there is Customer ID value (Relationship will come as-is from screen to GI)
Hope this info will helps you!!
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
how about creating filter customer relations with customer relations in acumatica report designer?
I want to filter customer location based on the selected customer filter
Thanks
+19Hi
You can create a simple form-detail customization with filers (here it is possible to achieve build a relationship between the parameters) and accordingly filers the records and display in the grid.
Hi
customer location data still appears all data
+19Yes,
Hence suggested above to create a Form-Detailed/Custom inquiry screen to fulfil this requirement.
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.