I have a report designed based on the historical inventory valuation and I would want to introduce a date range parameter instead of using the Period as is with the standard Acumatica forms. I have the report date field selected via the filter but when I run the report on data is extracted.
Has anyone worked with an inventory valuation report where one can draw the date parameter range instead of using a period?
Best answer by Kandy Beatty
I did add the date filter , however it does not filter the transactions by “date”, if you check balance at the end of August and compare with end of October it is coming back the same with no difference yet there were transactions between the said period.
Try to change the default value to be a range, such as an if statement.
On the report parameters of my report I would like to add a date from to filter instead of having a period filter
+16
Hi
Could you please kindly share your relationship on this report.
I tried building the relationship to add Batch date but fail
Thanks so much!
Hi
Can you share the XML for your report? Or screenshots of what you are looking for?
Good day
I have attached the xml
+16Hi
Can you share the XML for your report? Or screenshots of what you are looking for?
Good day
I have attached the xml
Did you add what I showed in the screen shot?
+16Hi
Could you please kindly share your relationship on this report.
I tried building the relationship to add Batch date but fail
Thanks so much!
Hi
I did add the date filter , however it does not filter the transactions by “date”, if you check balance at the end of August and compare with end of October it is coming back the same with no difference yet there were transactions between the said period.
+16I did add the date filter , however it does not filter the transactions by “date”, if you check balance at the end of August and compare with end of October it is coming back the same with no difference yet there were transactions between the said period.
Try to change the default value to be a range, such as an if statement.
I did add the date filter , however it does not filter the transactions by “date”, if you check balance at the end of August and compare with end of October it is coming back the same with no difference yet there were transactions between the said period.
Try to change the default value to be a range, such as an if statement.
Just wanted to say. I read this whole post and utilized the file above. This is extremely helpful.
Thank you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
