Hi Everyone,
Good Morning,
I have added a multiple filters in Report Designer.
But, all are working fine expect Location lookup data not populated.
Here is my setup…
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/2e98ab6d-48d8-42cf-8ae1-797c8218288e.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/59a76a2c-75be-4801-9ad8-49f1743164c5.png)
So please help me out, How to fix this?
Thanks,
Nageswararao A.
Hi Everyone,
Good Morning,
I have added a multiple filters in Report Designer.
But, all are working fine expect Location lookup data not populated.
Here is my setup…
So please help me out, How to fix this?
Thanks,
Nageswararao A.
Hi
Since this was 2 years ago there is a slight tweak, that being the Customer parameter needs to called CustomerID:
Which are the same locations we see on the actual service order:
Hello
Thanks so much for your guidance and assistance.
The statement you sent worked!!!
Hi
But I'm little bit confused. how is it possible without table (ARPayment)
=Report.GetFieldSchema('ARPayment.CustomerLocationID,CustomerID')
When we are adding this line Location lookup data populated.
Could you please elaborate how is going on here...?
Similarly, in a GI, you can add a table to the GI but not join it in and still use it for schema fields on the results grid.
Hi
When we are selecting the CustomerID and LocationID in lookup filters are not working.
Please give me some suggestions.
how to fix this?
Technically these are IDs being retrieved, but even if the ID is used it still returns no results, so it’s strange, but I suspect it is how the report is configured.
Are you just modifying the standard Service Order report, or is this all custom report?
Technically these are IDs being retrieved, but even if the ID is used it still returns no results, so it’s strange, but I suspect it is how the report is configured.
Are you just modifying the standard Service Order report, or is this all custom report?
Yes
adding new sub report like Inventory Item list.
Here showing all service orders getting filters CustomerID and LocationID.
Shortly after your last response I realized that, at least for me, I was pasting in the incorrect details into the parameters when I was testing in Report Designer, this actually worked as expected for me.
Just make sure to mark the the doc type and ref nbr parameters as not required and add conditions in the filters to allow for Null results.
You could try uploading the report here to see if I could test it locally also
Hello
Yes, you are the correct.
The doc type and ref nbr parameters as not required. When we removed this filter , the functionality working fine.
Location filter working like this.
Location.LocationCD | Equal | @LocationID |
Thanks for your support.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.