Solved

Cannot get INLocation.LocationCD to be a lookup parameter on a report

  • 23 September 2021
  • 13 replies
  • 188 views

Userlevel 1
Badge

The report only has one table, INLocation.  I want a parameter linked to LocationCD to be a lookup.  I cannot get that to work.  Here is my setup:

 

What are the rules for adding a lookup parameter to a report?

icon

Best answer by Naveen Boga 27 September 2021, 15:31

View original

13 replies

Userlevel 7
Badge +12

Hi @brucewarrell96  Long back I have tried like below to get the Location ID filter. Hope this helps you as well.

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

 

Userlevel 1
Badge

@Naveen B - my image is similar to yours but not having much luck.

Userlevel 7
Badge +12

@brucewarrell96  Hope you have tried this way as well? 

Instead of LocationCD below, try with LocationID

 

=Report.GetFieldSchema('INLocation.LocationID,Warehouse')

 

 

Userlevel 1
Badge

Tried that - no luck.

Userlevel 7
Badge +12

Hi @brucewarrell96 If possible, Can you please attach your report here.

Userlevel 1
Badge

@Naveen B  - see attached.  Thanks.

Userlevel 7
Badge +12

@brucewarrell96  Thanks for sharing this and will look into it and let you know.

Userlevel 7
Badge +12

Hi @brucewarrell96  It seems Selector is NOT working with INLocation table, instead I have worked with INLocationStatus table and it is working as selector. 

Please find the attached report and screenshot. Hope this helps!!

 

 

Userlevel 1
Badge

Thank you.  That worked.  I didn’t need to add the table to the report.  I just added the table reference in the view field.

Userlevel 7
Badge +12

Great News :) Thanks for sharing the update.

Any other solutions for this?  We were using the INLocationStatus table which was working fine until we upgraded to 21 R2.  Now we’re not getting any records on the Selector popup.

Userlevel 1

I’m having the same issue. Cannot get Location selector to populate. Used same setup as the on provided in the solution and no luck.

Badge

Try creating a SiteID parameter like this:

 

Then define the LocationID parameter like this:

 

 

After picking the Warehouse, you should get this result:

 

Reply


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 — 2022  Acumatica, Inc. All rights reserved