I’m looking for information on how to create a report to show slow moving inventory in Epicor 8. I’m not good at creating BAQs and don’t know where to begin with this. We’re looking to have a BAQ show parts, part description, on hand quantity, last date used, warehouse, and BIN with a date of last used a year or more.
Any tips or help on getting this BAQ up and running?
The BAQ designer in V8 is so primitive e.g. summarized tables only allow the use of TOTAL, AVG, or COUNT expressions.
So… for slow moving inventory, instead of BAQ, I have used ODBC with something… e.g. Crystal, Excel, etc…
Keep in mind ODBC can open up a can of worms so personally, I am pretty conservative with its use/who I’d grant access.
NO, as far as I know the only thing even close in V8 is the inventory usage report that you might be able to find slow moving items with. But it is pretty hard to work with, one of those old Progress “Text” style reports that can’t be modified. i.e. why you’re probably looking at Crystal, ODBC and/or adding SQL view(s).
Yes, when not well defined up front… expect endless rework.