Gain better Visibility of Inventory Costs within your ERP System

Blogging Tips LinkedIn Post Header (9).png

In the standard ERP system (and even S/4HANA) it is difficult to find reports that give you a multidimensional view of your inventory costs. Many customers download the information to Microsoft Excel or use external reporting tools such as BI to do the analysis. There is nothing wrong with these options, but sometimes they lead to reconciliation errors (in the case of Excel) or realtime update issues (in the case of BI). With the Material Ledger Activated and by utilizing an enhanced report, there are several reporting options that will give you a more granular view of your inventory values.

Watch this live session with FICO expert, Rogerio Faleiros, where you can learn the following:

- How to create drilldown reports in Material Ledger
- How to view inventory costs, such as beginning and ending inventory, receipts and consumption by cost - components (such as Raw Materials, Labor, Overhead, Freight, etc.) for multiple materials
- How to track inventory turnover on a periodic basis
- How to view inventory costs according to dimensions such as material group, profit center, product hierarchy, etc.
- How to view standard and actual cost components for your inventory balance sheet accounts
- How to view the released costs of multiple materials for multiple periods

Watch The Recorded Webcast:

Find the answers to the below questions within the recorded video

Questions

How were you able to add cost components as a parameter?

Do these transactions work only after activating the ML CDS views?

Does the functionality work in S/4?

Is the functionality native in S/4?

How long does it take to implement the solution

Can we use for the auxiliary cost component split?

What are the restrictions to get the functionality?

Based on what you showed, is the report based on the CDS Views?

Did you use exit of FCML_AGG?

Did you add any field to KKBML, TKAF structure?

Author: Rogerio Faleiros

Rogerio is an independent SAP consultant specializing in controlling functionality. He has worked with SAP technology for more than 10 years, implementing controlling solutions in the food processing, chemical, construction and agribusiness industries. Roger has been working with IFRS and integration with product costing and material ledger minimizing the impact of the changes in SAP for companies in different locations.He has participated in rollouts in several countries such as United States, Germany, Switzerland, Italy, Turkey, UK, France, Spain, Egypt, UAE, India Sweden and Finland. Rogerio has an MBA in IT from Getulio Vargas Foundation and is a frequent presenter providing training for new consultants in Brazil. Rogerio is the author of Configuring Controlling in SAP ERP.