Trying to get a handle on purchase cost over time for our Raw Materials.
I cannot find a report or dashboard for this type of information. What am I missing.
How are others solving this issue?
Noel
Trying to get a handle on purchase cost over time for our Raw Materials.
I cannot find a report or dashboard for this type of information. What am I missing.
How are others solving this issue?
Noel
Noel,
Here are a few thoughts:
Use Inquiries in Purchasing such as Order lines, Receipt lines or Invoice lines. Each of these contains product and cost information. You can also use the Stock transactions Inquiries in the Stock module and use the Criteria to look at Receipt Entry types.
If these are not exactly what you are looking for, I believe they do contain the information you need to build a query that you can add to a dashboard.
Good luck.
Assumed the data was available.
Was hoping to leverage prebuilt or standard reports, queries or dashboards.
Seems all but the basics is "build it yourself from scratch" in X3.
Thanks.
Noel
It may be semantics, but I am pointing you to prebuilt queries with the information you will likely need.
Regards,
Frank Bernal
Probably unclear in what we are seeking.
We are currently using these Inquiries, they give the information, but is very labor intensive to see trends or flagging issues.
Was looking for something we could turn into a "KPI" or Dashboard metric to minimize time spent on detailed analysis.
Noel
*Community Hub is the new name for Sage City