I had a parameter added to the AR Aging report based on a new Attribute. I had the report working when adding the new Attribute to the parameter, but didn’t pull in data if you selected a specific customer instead of picking the Attribute. Now, when I try to fix it, the ability to select a customer works, but the Attribute Parameter does not.
I have confirmed that I am using the correct Customer.AROWNER_Attributes in my report.
Any thoughts as to what I have done wrong?
Best answer by darylbowman
And third-to-last line (starting with ‘@Format’ needs to end with two parenthesis ‘))’
+15Line two of the filters needs to start with two parenthesis ‘((‘
+15And third-to-last line (starting with ‘@Format’ needs to end with two parenthesis ‘))’
Can you explain why? I haven’t been able to find great documentation on that aspect of the filters.
+15It's basic logic chaining. It's not specific to Acumatica. I'm afraid I can't really explain it.
Ok. I guess I’m missing why the first grouping of parameters are all related.
+15If you mean the twenty-some lines between the ones I mentioned, they are not related. The first one starts the grouping of lines 2-6 (which has a couple nested groups). The last one closes the grouping of the seventh-to-last to third-to-last lines (also with nested groups).
Seems like they were related, because one of my fix attempts was to add the new parameter inside of the double bracket, thinking the logic needed to look at all items to find the correct parameters.
+15...because one of my fix attempts was to add the new parameter inside of the double bracket
That would cause the added logic to only be evaluated in some cases instead of in every case, hence it probably not working at all or at least not consistently.
Usually, parenthesis are used to force evaluating an ‘OR’ at the proper time.
I added the ‘((‘ and ‘))’ to the highlighted areas but it did not change the results.
+15@UncompletedOnly Equals 1 ) Or
+15Yup
+15Sorry, missed that you need a double parenthesis before SOLine.OpenQty (two lines above the previous)
and you need to remove the parenthesis on the bottom highlighted one.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
