Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Problem with the Stock
Small and medium business | Business Central, N...
Suggested answer

Problem with the Stock

(1) ShareShare
ReportReport
Posted on by Community member 19
We have had some problems with historic stock.
 
It was decided at the time that it would be too much work and too much time intensive to correct. 

However, I’ve been looking and there is also a lack of continuity across different reports for the same stock item. 

I’ve taken 1 item that I know is a problem (C1144SA), along with relevant inventory reports that we use; 
Inventory Valuation – Value of £2,905.03Item Age Composition Value - £6,371.67Item Age Composition Qty – 130Item list from Nav – 0 

If there were consistency across these reports it wouldn’t be too much of an issue – However it causes problems when every report is different. 

Could you please let me know how we can solve this, so there is at least a consistency across all reporting. 
Because the reports are not matching each other
  • Community member Profile Picture
    Community member 19 on at
    Problem with the Stock
    Hi,
     
    As you can see (See highlighted rows) that there is a discrepancy between these two despite being run at exactly the same time.

    So I agree they would be different in some instances but in the instance of this item (There are others but will need to look at in more detail) should be the same on both reports.
     
    Invetory Valuation
     
     
    Item Age Composition East
     
  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,993 Super User 2024 Season 2 on at
    Problem with the Stock
    Also before doing any analysis on Inventory value in NAV, run the "Adjust Cost - Item entries" process - and if You are posting the values to G/L use the Post to G/L option. 

    To make sure all is ok, run manually the Post Inventory Cost to G/L process - to make sure it is empty and all costs/adjustments calculated have been posted to G/L. 

    Then the Inventory Valuation report should be in match with Your G/L accounts.
  • Suggested answer
    NAV_with_Narang Profile Picture
    NAV_with_Narang 2,238 Super User 2024 Season 1 on at
    Problem with the Stock
    Hey There - It is very important to understand and acknowledge that the 3 reports you have listed, have a very different function. Your item age composition (value) always will show you value of an item as today, whereas the inventory valuation will show you what the GL Value of the stock was on a particular date. You can't possibly open these 3 reports side by side and compare their numbers to conclude there is inconsistency. Read this blog for some context
    http://cowmasterscorner.blogspot.com/2016/05/dynamics-nav-item-age-composition-vs.html
     
    IMHO, you inventory valuation (as on a date) should match with your COA's Inventory Accounts (filtered by the same date). That's when you realize your stock values are consistent. If you find there is a discrepancy, check if the Adjust Cost GL Entries batch has run
     
    Also, you have mentioned about some "mistakes" being made when the opening stock was imported. I'd rather suggest contact your Local MS Partner and have their functional consultants to look at the system and give you a analysis if anything needs correcting at all. Share your concerns with your MS Partner and they'll help you understand the system better

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,703 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,433 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans