Inventory Analysis

Inventory analysis is always a problem in any ERP system, as data has to be calculated for each item through all posted item entries. Because of this approach, analysis is very slow and analyzing average inventory value or turnover coefficient over multiple locations and items is almost impossible.

Optimizing inventory is the key in any analysis and with this in mind we created daily data snapshots in BI4Dynamics NAV data warehouse to provide business users with very fast and agile analysis of complete inventory data.

Extending functionality of Microsoft Dynamics NAV

Main advantages:

• Advanced measures: average stock value, stock rotation coefficients, turnover of stock in days.
• Analyzing groups of items over multiple locations with turnover in days to see quickly which items are longer in stock.
• Decrease/increase analysis over item ledger entry type (sales, purchase, output, transfers, consumption, etc.).
• Analyze specific posting through source and reason code.

Sample scenarios

Front-end tool used: Microsoft Office Excel 2007.

A variety of measures (including different key performance indicators) and dimensions enable endless possibilities for analysis.

KPIs in BI4Dynamics (like Stock Rotation Coefficient) are calculated on daily basis. Building a report like that in Microsoft Dynamics NAV is a very time consuming process, but in BI4Dynamics it will only take you a few seconds to make that kind of report.