Skip to main content

Notifications

Business Central forum
Answered

Item revaluation journals

Posted on by 315
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
  • Verified answer
    Jun Wang Profile Picture
    Jun Wang 4,078 Super User on at
    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 Profile Picture
    YUN ZHU 61,112 Super User on at
    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 Profile Picture
    Valentin Castravet 4,707 Super User on at
    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. 
     

Helpful resources

Quick Links

Contextual content recommendations & SharePoint Q&A

Instantly access relevant sales materials…

Beyond the DRA Cloud Label Printing

Explore cloud-based label printing within Dynamics 365…

HR Infrastructure Customer merge

Important considerations for HR Customer migrations…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,418 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,631 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,142

Featured topics

Product updates

Dynamics 365 release plans