Regarding inventory valuation reports

[sachitT43ZS]

I have observed that you can create inventory valuations from the beginning of time to the current date. While this is a very handy feature to have, there are a couple of places it breaks down.

Let us consider an example. You have a product called "Routers". Fusion Ops tracks all the inventory movements diligently and the associated costs - Receivings, consumptions, etc. All good. Due to certain issues, the team decides to perform an inventory fix - zeroing out the inventory and then an inventory fix. After the fix, the only cost that should appear as the asset value should be the cost that I am actually currently sitting on. If Fusion Ops is rolling up all the previous costs - they must ideally total to zero - but this is not the case as I have observed. For if it does not total to zero, then some additional value gets added into the asset value - which is definitely not the case physically.

To make my case, have a look at the following screenshot

The second line refers to the zeroing inventory scenario - the cost isn't subtracted here.

So how does having a date range help?

Users can directly select the range from which they zeroed inventory or any other action they performed to the current date - thus eliminating any errors even if they crept in.

Hope this suggestion helps.

Best,

[andrade_david]

Hi @sachitT43ZS , thank you for your message.

Can you share more how you've created the second inventory movement on your image? I'd like to know if it was an import, manual entry, or any other way.

When zeroing the inventory, the system should consider the average cost of what you have in inventory, and therefore the second movement should have a cost of 33000, just like the first one. I'd like to know more, as this may be a specific scenario in which the system is not behaving as expected.

Thank you!

[sachitT43ZS]

Hi @andrade_david !

Thank you for reaching out.

The second inventory movement was a zeroing movement. We were performing a zeroing activity by executing an import.

Hope that helps!

[andrade_david]

Hi @sachitT43ZS 

Thank you for waiting for my reply here. We did a few tests to the importer, and we could not replicate the system not calculating the corresponding cost - it always subtracts/adds the cost to the inventory.

Nevertheless, beware that in case you leave the cost column empty, the system will not do any cost adjustments in the importing process.

This being said, I ask you to reach out to the support team in case this happens again in the future, so that we can look at the specifics of the situation and fix it. I'll mark the idea as archived.