Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Inventory valuation residual value

(0) ShareShare
ReportReport
Posted on by 241
Hello everyone,

I have an issue regarding the inventory's residual value. I uploaded inventory using a journal, but a couple of days later, we realized that the amounts and values were incorrect. We reversed the document, but for a few items, we used the new values. This has resulted in negative or positive values in the inventory that we've been carrying since then, and some of the items now have zero units.

For example,

Item I-09 had two units in Location W-03 with a value of 860. We reversed the two units, but with a value of -112.49, and this left us with a value of 747.51 that we can't get rid of.
 
The item is not being used and has 0 units.
 
Entry TypeDocument No.Item No.Location CodeQuantityCost Amount (Actual)
Negative Adjmt.REVERSALI-09W-03-2.-112.49
Positive Adjmt.ORIGINALI-09W-032.860.00
    0747.51
 
I've tried reversing the documents and leaving the inventories at zero, but these actions affect the average cost, we use the average costing method, and in some cases, they result in negative inventories, which we don't allow. I also attempted to use the revaluation journal, but this action impacts the average cost because I don't have the items. If I make a positive adjustment followed by a negative one, it negatively impacts the average cost.
 
Thanks for the help. 
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 995 Super User 2024 Season 1 on at
    Inventory valuation residual value
    Just to add to the other answers here.
    I hope my blogpost around item revaluation can be of assistanse to you.
     
    I also think this article around cost adjustment can be worth reading:
     
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 4,055 Super User 2025 Season 1 on at
    Inventory valuation residual value
    In Inventory Setup - check if You have automatic Cost Adjustments and Automatic Cost posting. 

    At the moment seems like no. And You would need to manually run process "Adjust Cost - Item Entries" (and Post Inventory Cost to G/L (but this can be done within the AC-IE process if you place checkmark to post)).

    The process checks that outgoing entries have the same unit cost as the incoming entry that they are applied to, meaning, used item is worth the same as it was purchased for).
    If the Application to inbound entry has to be changed, Shauna already described steps to do this in previous comment.
  • Suggested answer
    Shauna Langley Profile Picture
    Shauna Langley 781 Super User 2025 Season 1 on at
    Inventory valuation residual value
    Hi,
     
    I have had to do this on a few occasions and it will involve using the application worksheet.  The first thing to do is post a positive adjustment for qty 2 and cost of 112.49 on the same posting date as the negative adjustment.  Then post another negative adjustment for qty 2 with the correct amount of 860.00
     
    Then search for application worksheet.
     
    You will need to do this setup for both negative adjustments, the one costed at 112.49 and 860 as they will be applied to positive adjustments albeit just the wrong way around.
     
    Find the entry for the negative adjustment and select applied entries.
     
     
    Make sure that the applied entry is the original positive adjustment and then select remove application.
     
     
    Then repeat this for the second negative adjustment.
     
    Then find the first positive adjustment and select unapplied entries.
     
     
    You should see the two negative adjustment entries here so select the correct one cost wise and click ok.
     
     
     
    Repeat for the second positive adjustment and that should be the issue resolved.  I will point out that you need to stay within the application worksheet to do all these steps otherwise it will revert back and you need to start again.  It is also better to do this when the system is not in use as you could get errors when trying to reapply the entries.
     
    Hope that helps,
    Shauna

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,160 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans