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

Problem with the Stock

(1) Share

Report

Posted on by Community member

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)

All responses (3)

Answers (0)

Suggested answer

NAV_with_Narang 2,320 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
KasparsSemjonovs 4,817 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community member 19 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No