Finance | Project Operations, Human Resources, ...

Inventory value - Quantity 0 with negative financial cost

(0) Share

Report

Posted on by Fabio C.

232

Hi All,

I was wondering if any of you know ho to solve this problems.

At the moment for a customer we have for at least 20 items with quantity value 0 and negative financial amount.

This is the item model group, and the costing method is weighted average.

2021_2D00_06_2D00_17-19_5F00_37_5F00_09_2D00_Item-model-groups-_2D002D00_-Finance-and-Operations.png

Any suggestions on how to solve this kind of problems?

Do you have links where inventory evaluation is explained well?

Best regards

I have the same question (0)

All responses (5)

Answers (0)

OsmanIstanbul 2,818 on at

Like (0)

Report

Hi,

did you change any configuration on inventory storage, tracking dimensions despite transactions exist? especially the financial inventory field? this type of change can cause this problem.

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,194 Super User 2025 Season 2 on at

Like (0)

Report

Hi FBA,

This scenario is common. When posting the transactions, it will use a running average, but will correct the postings when you run the inventory closing periodic job or when you perform an inventory recalculation.

You can find more information in the documentation: Inventory close - Supply Chain Management | Dynamics 365 | Microsoft Docs

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

This transaction happens when Inventory Revolution is done.

E.g. You did product receipt of product at 10 and then sold, your COGS will be -10,

now you received invoice for that product receipt as 12 instead 10. so now when you will post this and run inventory recalculation.

You will find there is adjustment to COGS of -2 with Zero QTY by system.

Was this reply helpful? Yes No
Fabio C. 232 on at

Like (0)

Report

Thank you all.

What if recalculations were already done?

I have this item with 0 quantity and a negative value of -42879,93

All transactions with purchased and sold status recalculation done and the value is negative probably cause it is related to 2 different transactions sold with an exceptional cost amount.

What do you suggest to correct this situation?

Best regards

Was this reply helpful? Yes No
André Arnaud de Cal... 301,194 Super User 2025 Season 2 on at

Like (0)

Report

Hi FBA,

Can you check if the receiving transactions do have the status 'Invoiced'? If not, you can check if the 'Include physical value' on the Item model group is enabled or not. Anyway, after posting the purchase invoice, the closing/recalculation should recalculate this scenario.

If the receiving transactions are all 'Invoiced', please share some more information. How many transactions do you have for this item? Can you then also check if there are inventory transactions which are not closed?

Was this reply helpful? Yes No