Hello Experst,
I have developed a customized report which display all the Items Costs, On Hand Qty, 3 months usage, 6 months usage based on different warehouse and added a condition to display only certain product workgroup item.
Issue:
I want to display the last year (2024) total sales based on above condition.
Points:
As same as for 3 months usage and 6 months usage we have created a view
And same view i have tried for previous year but it is not working.
Any help.
Thanks in Advance.
Datascripts for 6 Months:
Code:
