Notifications
Announcements
No record found.
I'm looking for a way to display the Annual Historical Usage from Inquiry>Inventory>Item>History. If anyone can be of assistance it would be much appreciated.
*This post is locked for comments
Wondering if one of Victoria Yudin's Inventory SQL Views would help? victoriayudin.com/.../inventory-sql-views They can always be made into a SmartList. If that is not helpful, maybe this is a better fit: shahfaisalmuhammed.blogspot.com/.../dynamics-gp-annual-historical-usage.html
as john stated...we us a view and then filter it further to only use transactions from the MFG module. (source reference number begins with M ...)
Because we have 100s of thousands of transactions in MFG we have different views for the different years..we then use either crystal or a custom smartlist...we also have some excel reports
Tami
One of the issues with only using the MFG transactions is that we also directly sell our parts so I'm not sure if the Sales transactions can be combined with the MFG ones.
Sales Line transactions by date...lots of historical data in the Sales module
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
