Hello,
For financial accounting and statutory reporting purposes companies have to be able to evaluate their inventory according to different valuation methods, such as FIFO, LIFO, etc. in parallel.
Currently it is only possible to assign a single inventory model to an item. There is a standard Russian functionality (dual warehouse) available that allows assigning two inventory models. This Russian functionality does, however, also not help in cases where companies need more than two inventory models, which is often the case in international companies that have to report to local GAAP, local tax rules and - at the group level - IFRS if those accounting standards require different valuation methods.
Please note that this does not require that items in the inventory are revalued. What is needed is a financial feature that allows obtaining alternative inventory values based on different inventory valuation principles.
It would be great if this gap could be closed with the next release/update.
Many thanks and best regards,
Ludwig
Comments
Hello,i still missing production in - and outgoing document types.At the moment just the below documents are supported. Product Receipt Invoice Packing slip Invoice Movement Adjustment Counting Transfer Shipment ReceiveKR Roland
Category: Cost Management
This was planned for April 2020 - what is the new release date for this much needed functionality?
Category: Cost Management
In Spanish legislation it is mandatory to provide the average price valuation as long as it is valued to other criteria (Standard Cost, FIFO, ...) to verify that the differences between both valuations.
Category: Cost Management
This is in fact very much needed in many scenarios.
Ideally, paralell inventory valuation models should be like Fixed Assets models, at module level and at ledger lever attached to a different posting layer.
Category: Cost Management
Really necessary for manufacturing companies in countries where Standard Cost inventory evaluation is not allowed by local gaap
Category: Cost Management
That is a very good point by Boštjan Golob about elimination of IC profit from inventories, WIP and COGS! Since it is also a requirement of IFRS 10, it does deserve more attention and better support.
Category: Cost Management
@Uwe: I had a case in Germany for a "standard cost for ... and an average costing model" at one site, therefore +1 to Ludwig :)
Category: Cost Management
Hi Ludwig,
Sounds to me more like a reporting requirement where you need to adjust the receipts and issues accordingly. Not sure if this should be calculated at run-time. Especially looking at manufacturing and project accounting etc.
What I have though in a real life scenario is the requirement to have a standard cost for a product in the manufacturing site and an average costing model in the sales sites. So I would support this request to have different inventory models per site and calculated in real time. Having different costing models in parallel is a reporting request from my point of view and only adds an overhead to calculations at the time of processing.
Regards
Uwe
Category: Cost Management
For intercompany/consolidation scenarios, a welcome addition would be the ability to run inventory closing across legal entities. The reason is the elimination of intercompany profit from inventories, WIP and COGS. In case where there are complex intercompany supply/subcontracting/manufacturing relationships between companies within a consolidated group, "rule of thumb" (deduct an estimated percentage from inventory, WIP and COGS accounts) becomes an increasingly poor measure of actual intercompany profits, especially if companies operate on an "arms-length" relationship, that is, working on mostly market conditions without agreeing up front on transfer prices.
Category: Cost Management
Administrator on 8/4/2022 1:14:54 PM
Global Inventory Accounting add-in for Dynamics 365 Supply Chain Management is GA (General Available).
Provides a comprehensive solution that enables organizations to account Inventory simultaneously in user defined costing ledgers by applying various methods (Standard cost, Average) or currencies.
Learn more
https://docs.microsoft.com/en-us/dynamics365/supply-chain/global-inventory-accounting/global-inventory-accounting-home