-
Book Overview & Buying
-
Table Of Contents
Financial Modeling and Reporting with Microsoft Power BI
By :
Within your financial application, inventory valuations will be handled by the General Ledger control accounts on the balance sheet. We find this generally doesn't provide enough detail, so we look to manage inventory through detailed transactional data, writing DAX calculations for items such as slow-moving stock or stock turns. As a result, we'll import transactional inventory movement data to supplement the GL data.
There are two main ways that inventory data will be recorded:
Which option is chosen will depend on your inventory management system, although organizations that manage large volumes of inventory will generally have the latter, as the ERP system will support their inventory operations, and transactional records of each move are necessary.
In this chapter, we'll discuss how to approach...