Inventory Usage Report

Kinetic ERP
1

Does anybody have the SQL version of the Inventory usage report?

I cannot find it in my BAQ list. Is this because it’s a native report?

2

Welcome aboard @Trung_Vo

I personally don’ have one, it’s a system report so there is no BAQ.

Because you are on prem you could use sql extended events or Profiler to get a copy of the generated query…

This post might help… and this one.

Tips for asking question on the forum - Experts’ Corner - Epicor User Help Forum

3

Thanks! I saw this thread but did not know how to get the SQL from it. I extracted it and put it in notepad but it wasn’t SQL.

4

You would need to import the baq. You will need to refer to the help, users guides or the Epicor learning center to learn how to work with baqs.