Supply chain | Supply Chain Management, Commerce

Remaining Inventory Value - but No Inventory Quantity

(0) Share

Report

Posted on by PatriciaSNAG

Hello!

I'm really looking into solving this issue. When downloading the Inventory Value Report, it displays an inventory value for items with no inventory quantities (and no physical quantities). How to clean up these values? I can't seem to find how to do just that.

Many thanks!

I have the same question (0)

All responses (9)

Answers (0)

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

Like (0)

Report

Hi Patricia,

Can you tell which inventory costing you are using and an example? What exact transaction do you have on this item?

If you are using FIFO, LIFO or average, are you running inventory recalculation and closing regularly?

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

this is certainly to with the costing model

should revalue or close inventory and system would fix that

suggest if helps

Was this reply helpful? Yes No
MATTGUO 22,349 Moderator on at

Like (0)

Report

Hi PatriciaSNAG,

It is very common case.

During daily work, sometime the actual item cost could not reach inventory before the item is sold. Such as invoicing SO before invoicing PO, and the PO invoice price is different from PO price, that will cause the inventory variance. If the item is FIFO, LIFO or weighted average, as others said, inventory recalculation could fix this variance.

And please also check the inventory dimensions level and if all transactions of the item have Physical/Financial date.

Was this reply helpful? Yes No
PatriciaSNAG 15 on at

Like (0)

Report

Thank you André for your reply. We're using FIFO. I did run an inventory recalculation yesterday and closing (it was our month end), and it didn't change anything.

Here is what I get when dowloading the Inventory Value Report, after recalculation and closing yesterday:

This image shows 2 things:

1- We have several items for which there are no physical/financial quantity/value, but the system displays a line in the inventory. For exemple, items 101860, 100511 (batch R13058), etc.

2- We have several items for which there are no physical/financial quantity, but the system displays a financial value.

Would you have an idea where to look to avoid these situations, and how to fix the existing ones?

Many thanks!!

Was this reply helpful? Yes No
PatriciaSNAG 15 on at

Like (0)

Report

Thank you Rahul Mohta for your reply. We're using FIFO. I did run an inventory recalculation yesterday and closing (it was our month end), and it didn't change anything.

Here is what I get when dowloading the Inventory Value Report, after recalculation and closing yesterday:

This image shows 2 things:

1- We have several items for which there are no physical/financial quantity/value, but the system displays a line in the inventory. For exemple, items 101860, 100511 (batch R13058), etc.

2- We have several items for which there are no physical/financial quantity, but the system displays a financial value.

Would you have an idea where to look to avoid these situations, and how to fix the existing ones?

Many thanks!!

Was this reply helpful? Yes No
PatriciaSNAG 15 on at

Like (0)

Report

Thank you MATTGUO for your reply. I remember you helping me in the past, so I have great hopes here!

I understand what you mean re. the sources of the problem. We're using FIFO. I did run an inventory recalculation yesterday and closing (it was our month end), and it didn't change anything.

Here is what I get when dowloading the Inventory Value Report, after recalculation and closing yesterday:

This image shows 2 things:

1- We have several items for which there are no physical/financial quantity/value, but the system displays a line in the inventory. For exemple, items 101860, 100511 (batch R13058), etc.

2- We have several items for which there are no physical/financial quantity, but the system displays a financial value.

Regarding checking the inventory dimensions, could you explain more what you mean and where to look at?

Is there is a place where I can also check quickly about physical/financial dates? I can run a transaction movements report, and I believe it will work.

Many thanks!!

Was this reply helpful? Yes No
MATTGUO 22,349 Moderator on at

Like (0)

Report

Hi PatriciaSNAG,

For question 1, those items should have inventory transaction during the date interval.

For question 2, how about the financial inventroy parameter of storage/tracking dimension groups?

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

could you confirm to have done an inventory close?

also suggest model group setting and storage and tracking dimension groups visuals

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Hi Patricia,

When e.g. a purchase invoice is not posted, it can not close the transactions and do the settlement. On the item model group you can define if you want to include physical transactions or not. That might change the behavior. For sure when the inventory transactions are 'Sold' or 'Purchased' then it can do the final recalculation and close the inventory.

Was this reply helpful? Yes No