You’re offline. This is a read only version of the page.
Hi,
Here is a story.
Our company wants to know item period history for several items.
I can simply goto Item Maintenence --> History
There, I am able to see monthly period data.
Through that method, we can know that we have sold 2 cans on Jan; 4 cans on Feb; 2 cans on Mar, so on.
Sure, I can pull data like that for few items.
Trick for this time, is that more than 100 items' data is requested.
Is there any alternate methods available?
Let me know if possible and thank you in advance!
*This post is locked for comments
Thanks Mahmoud, I appreciate your kind words and all the work you do for this community!
Nothing more valuable than having a look at Ms. Victoria Site, it is definitely the ultimate reference for such requests. Furthermore, I have developed several inventory reports that would be of an added-value for you
In this essence, I would like to thank Victoria as well since her site was my ultimate reference as well for definitions, table relations and many other specific and essential details while building most of my reports. Thank You Victoria :)
Let us know if you need any further assistance,
Thanks for the shout out Leslie!! :-)
Hi,
Take a look at Victoria Yudin's site, she has some remarkable SQL statements available to download (or copy) that may give you what you want. Love those SQL statements, effortless because Victoria has already done it.
Kind regards,
Leslie
If know some SQL scripting then create a query. The table is IV30102 and the quantity column is SMRYQTYS. You'll also need ITEMNMBR, SMRYPMTH (month) and YEAR1.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (