@kbeatty21 - Well, I feel rather silly. Had always been downloading it from the link provided on Acumatica’s “Open University” course pages. Using builds.acumatica.com worked perfectly. Thanks!
@Chris Hackett no I was never able to figure this out with the GI + Pivot Table. I ended up settling for a different approach (a report created via the Report Designer). Thanks!
@markusray17 That little change with the Filter fixed it. Thanks so much! Don’t think I would have ever thought of that.
@Naveen B Great info; thanks! Will look into it from my end and see if I can figure out what is causing the behavior.
@Naveen BThanks so much for taking a look. Sounds like it might be something peculiar to my environment/data.You mentioned you verified the SQL query. That would seem to be the next best step for me. How do you do this? I enabled SQL logging under Request Profiler and did not see any data relevant to the GI being logged?Thanks again!
@Naveen B Thanks for the response. Unfortunately, using “Equal” generates an error: “Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.”XML export is attached. Thanks!
@vkumar Thanks much for the advice. It is certainly helpful. However, still not quite what I was looking for. Is there any way to use the GI filters to dynamically filter the Pivot? To give a more concrete example:I adjusted the Conditions on my GI slightly to provide defaults if the parameters are not provided: Based on your advice, I created a Pivot Table as a filter: The data loads fine if I do not supply the Trans Date From/To parameters (presumably since the the default dates are passed to the Condition): However, if I fill in the Trans Date From/To parameters, I get nothing in the Pivot Table: But the data loads just fine in the main GI tab: My question is, is there anyway to use the parameters and conditions specified in the GI in the Pivot Table?Using the example above, would it be possible to (a) require both the Trans Date To/From parameters (modifying the GI condition to load no data if they are not present), and (b) load filtered data in both the GI and Pivot Table when (
@ChandrasekharM . Unfortunately, can’t really export and upload full output, but please see screenshots below.Thanks.
@DavidGelulaJedi . thanks for the response. Unfortunately, the “Initialize Scheduler” button is disabled for me.
@Irina , Thanks much for the response, but, unfortunately, I am afraid it is still giving the same error.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.