Hi,
I first want to create a GI to show the top selling stock items at the top of the inquiry to the lowest selling items at the bottom of the screen. What would be the condition for this GI? I have attached a Generic Template that will be modified to reflect this. Let me know. After this, I will create a dashboard. i don’t need assistance for this now.
Thank you,
Frances Pantelidakis
Best answer by alicezyks51
Hi,
Not sure if this does what you need, but the attached xml of the GI was updated as follows:
The end result displays one line per inventory item sorted by quantity sold from highest to lowest. All of the original parameters are still available to filter by date, item class, etc.
If you needed to drill into the original sales orders or wanted to see the detail in the GI, this version will not accomplish that….
Please let me know if you have any questions. Hope this helps!
Hi,
Not sure if this does what you need, but the attached xml of the GI was updated as follows:
The end result displays one line per inventory item sorted by quantity sold from highest to lowest. All of the original parameters are still available to filter by date, item class, etc.
If you needed to drill into the original sales orders or wanted to see the detail in the GI, this version will not accomplish that….
Please let me know if you have any questions. Hope this helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
