Hello,
I am having trouble getting a parameter with lookup to =Report.GetFieldSchema('ARShippingAddress.State’) lookup works but returns an empty list, I am guessing that I need to indicate the country for the lookup or something I am missing ?
Any help would be greatly appreciate it.
Best answer by hkabiri
Yes as you also guess it right some fields in Acumatica and dependent to another field just like Primary Keys on SQL tables which are required to get certain record.
State is also one of them which only makes sense if the country is specified.
What you need to try is create another parameter with name Country and get the country value.
Set the View Name for your State Parameter to Something like this: =Report.GetFieldSchema('ARShippingAddress.State,Country’)
We have an existing KB touches on exact same topic which you can use to fulfill your need:
Hope that helps!
+8
Yes as you also guess it right some fields in Acumatica and dependent to another field just like Primary Keys on SQL tables which are required to get certain record.
State is also one of them which only makes sense if the country is specified.
What you need to try is create another parameter with name Country and get the country value.
Set the View Name for your State Parameter to Something like this: =Report.GetFieldSchema('ARShippingAddress.State,Country’)
We have an existing KB touches on exact same topic which you can use to fulfill your need:
Hope that helps!
Thank you for the prompt response YES it worked perfect.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
