Hello users, I am using Microsoft Dynamics Navision and I want to know how someone can extract report for monthly and yearly consumption for a raw material.
Thanks a lot for your help.
The simplest answer to your question is this: open item ledger entries, apply filters on the item no., entry type, and posting date, and send the resulting dataset to Excel. But actual solution will depend on many things: which version of NAV you are using, how many entries are posted per month/year, what sort of data you want to see in the report. May happen that you need a custom report, or simple item availability per period will be sufficient for you. Or maybe you can set up the item turnover report. All depends on your expectations.
Thanks a lot Alexander,
Actually I want to withdraw reports where I can analyse the average purchase material for a particular product over the years so that I can have idea what is the avg monthly and yearly purchase volume. It will help me to get the idea about the purchase material in the past so that I can make a better forecast. I am using Microsoft Dynamics Navision 2018. Thanks a lot again
You have not to answer how do you use the consumption (production) part - Assembling or Production and how many records do you have here. And Alexander wrote correctly, the source table is ILE.
To be honest, this task for BI solution (because it is a huge quantity of lines) and it is not good to use NAV for such cases.
Another case - to full requisition worksheet for it. But again, it is better to create "a connector" for it.