web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

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

Problem with the Stock

(1) ShareShare
ReportReport
Posted on by 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
I have the same question (0)
  • Suggested answer
    NAV_with_Narang Profile Picture
    2,250 Moderator 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
  • KasparsSemjonovs Profile Picture
    4,677 Super User 2025 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.
  • Community member Profile Picture
    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
     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 2,568

#2
Sumit Singh Profile Picture

Sumit Singh 2,536

#3
YUN ZHU Profile Picture

YUN ZHU 2,015 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans