Item revaluation journals

(1) Share

Report

Posted on by MarisolC

338

Hi everyone:

I have this situation, my product MPAS003 has 333,705.24 KG as shown by Inventory Valuation,

I need to revaluate it and I'm using Item Revaluation Journals with this parameters:

And I get this line:

I don't know where this quantity comes from... is there something I'm missing, maybe a setup or some option I don't getting right?

I would be very thankful if you can help me.

TIA,

Marisol

Categories:

Inventory and warehouse management

All responses (3)

Answers (1)

Verified answer

Jun Wang 7,146 Super User 2024 Season 2 on at

Like (0)

Report

Item revaluation journals

previous response makes sense. inventory valuation report includes values of items received but not invoiced and values of invoiced items. so you won't be able to revaluate those items. export your item entries and look deeper.

Jun Wang
Suggested answer

YUN ZHU 69,639 Super User 2024 Season 2 on at

Like (1)

Report

Item revaluation journals

Hi, this value comes from Item Ledger Entries, you can view it through the following method. But this standard Query is not divided By Variant.

Hope this helps.

Thanks.

ZHU
Suggested answer

Valentin Castravet 22,181 Super User 2024 Season 2 on at

Like (2)

Report

Item revaluation journals

Is this an item you purchase and is the full item quantity invoiced? The Item Revaluation Journal only works for fully invoiced lines. For example, if some quantity is received but not invoiced it won't appear in the journal when you run Calculate Inventory Value.

In the Inventory Value report you have 333,705.24 and in the Item Revaluation Journal you only have a quantity of 9,571.4018. Perhaps the difference of these is not invoiced (333,705.24 - 9,571.4018 = 324,133.8382 is not invoiced?)

You can check in the item ledger entries if its fully invoiced by looking at the invoiced quantity field.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/