Need a Smartlist that will display Annual Historical Usage.

(0) Share

Report

Posted on by Community Member

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

All responses (4)

Answers (0)

Tami Farrelly 5,080 on at

Like (0)

Report

RE: Need a Smartlist that will display Annual Historical Usage.

Sales Line transactions by date...lots of historical data in the Sales module
Community Member on at

Like (0)

Report

RE: Need a Smartlist that will display Annual Historical Usage.

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.
Tami Farrelly 5,080 on at

Like (0)

Report

RE: Need a Smartlist that will display Annual Historical Usage.

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
Community Member on at

Like (0)

Report

RE: Need a Smartlist that will display Annual Historical Usage.

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