Inventory valuation

lanemark

On Navision V5 is there a report for Inventory valuation, say for the top 20%, I wish to check which items have the most value as a proportion of total inventory.

Alan

Savatage

Have you tried the Top__Inventory Items report?

check the options tab for "Inventory Value"

lanemark

Yes I think so, this gives a report by qty and then the value of the stock. I want to show top 10 by value not qty.
The report at the moment shows the top inventory as labels with a low value, where we may have one item in stock with a higher value but this is not on the report.
Unless I am doing something wrong!

ara3n

The easy solution would be to allow export of inventory valuation to Excel, and there you can sort it by Inventory Value.

Savatage

lanemark wrote:

Yes I think so, this gives a report by qty and then the value of the stock. I want to show top 10 by value not qty.

Maybe mine is modified - but on the options tab I have options to pick:
Top Qty or
Top Sales or
Top Value or
Bottom Qty or
Bottom Sales or
Bottom Value

ara3n

Yes, it's a modification.

lanemark

My version does not look like yours, reding the help text the version I have uses this report to show sales.
To export my stock valuation to excel is a big document, my stock sheet has over 100 pages.

Alex_Chow

ara3n wrote:

Yes, it's a modification.

This is NOT a modification. It's in standard NAV. It's been there since a long time ago.

Alex_Chow

lanemark wrote:

My version does not look like yours, reding the help text the version I have uses this report to show sales.
To export my stock valuation to excel is a big document, my stock sheet has over 100 pages.

The object that Harry is using is the NA version. My guess is that the inventory value option is not on the WW version.

Perhaps, you can ask your solution partner to get the NA version of the report for you.

Savatage

Alex Chow wrote:

lanemark wrote:

My guess is that the inventory value option is not on the WW version.

I wonder why that is? It would be useful to all.

Alex_Chow

Savatage wrote:

Alex Chow wrote:

lanemark wrote:

My guess is that the inventory value option is not on the WW version.

I wonder why that is? It would be useful to all.

Because the inventory value on this report is not accurate. It's only accurate if you're running it as of right now. You cannot backdate this report and expect the inventory value to match your inventory valuation report.

ara3n

Alex Chow wrote:

ara3n wrote:

Yes, it's a modification.

This is NOT a modification. It's in standard NAV. It's been there since a long time ago.

Sorry localization.

Savatage

Because the inventory value on this report is not accurate. It's only accurate if you're running it as of right now. You cannot backdate this report and expect the inventory value to match your inventory valuation report.

What does that actually mean

It's not available to everyone because it should not be used as an Inventory Valuation?
I'm wondering why the NA has it and the WW doesn't?

Having the option, if you want it, should be available. Maybe somebody want's to know what there Top Inventory Value Items are right now.
Only we're (NA Version) allowed to know? Who decided that :-k

anyone who wants to take a try at it, I made a copy. Your probably have to change Sales($) to Sales(VAT) or something similar.
http://savatage99.googlepages.com/Repor ... yItems.txt

generic

The As of Date argument for valuation date does not apply. So it's not the reason.

My guess why it isn't in W1 version is because people who are building the W1 version are people who add features to W1 are hard to convince. They go by the very minimalistic aproach.
The idea of Navision was to keep the core product and anything added would be something that ISV would implement vertical solutions.

Lately they've realized that doesn't work and they've mentioned that they will be moving localization into W1.

For example Kitting should be in W1, it's not.

I would also add that MS NA developers who do the localization have to suggest it to W1, and they are not doing it.

Alex_Chow

generic wrote:

The As of Date argument for valuation date does not apply. So it's not the reason.

Oh yeah? How so? :-k

generic

Just because a user cannot enter As of Date, doesn't mean it's in accurate. It's accurate based when they ran the report.

Alex_Chow

generic wrote:

Just because a user cannot enter As of Date, doesn't mean it's in accurate. It's accurate based when they ran the report.

Alex Chow wrote:

... It's only accurate if you're running it as of right now...

I've already stated this in my post.

generic

The point of not being accurate doesn't mean it shouldn't be in W1 is not valid.

There are many things that are not accurate but are in W1.

themave

Savatage wrote:

lanemark wrote:

Yes I think so, this gives a report by qty and then the value of the stock. I want to show top 10 by value not qty.

Maybe mine is modified - but on the options tab I have options to pick:
Top Qty or
Top Sales or
Top Value or
Bottom Qty or
Bottom Sales or
Bottom Value

I am on version 4.0 unmodified and mine is the almost exactly like this,

Except is option boxes, which would get you the same thing

option boxes are
largest
smallest

then
Sales
Qty
Inventory Value

themave

Alex Chow wrote:

generic wrote:

Just because a user cannot enter As of Date, doesn't mean it's in accurate. It's accurate based when they ran the report.

Alex Chow wrote:

... It's only accurate if you're running it as of right now...

I've already stated this in my post.

You can select the date filter on the first tab (Item) and it will be accurate for which ever date you want it to be.

Alex_Chow

themave wrote:

You can select the date filter on the first tab (Item) and it will be accurate for which ever date you want it to be.

No...

But if you ran the report with date filter and you got it to match w/ your inventory valuation, then good for you.

Just looking at the Cost Amount (Actual) field is not sufficient to get the inventory valuation of the company when back dating is concerned.

generic

You are right TheMave

Alex Chow

You would need to include "Cost amount (Expected)". But that's a bug in the report

  CALCSUMS("Cost Amount (Actual)","Cost Amount (Expected)");
  TopValue[NextTopLineNo] := "Cost Amount (Actual)"+"Cost Amount (Expected)";

Otherwise the report will work fine.

Alex_Chow

It will work assuming there are no abnormal posting dates.

Anywho, for quick and dirty calculation of inventory valuation, generic's solution will work. But I wouldn't recommend the client to use this report to replace the Inventory Valuation report.

themave

Alex Chow wrote:

It will work assuming there are no abnormal posting dates.

Anywho, for quick and dirty calculation of inventory valuation, generic's solution will work. But I wouldn't recommend the client to use this report to replace the Inventory Valuation report.

from his first questions it appears he just wants to get a list of his top items, not a complete inventory valuation report.

in fact this report only can list the top 99 items, so it really is just a top item report, and only if you only want to look at the top 99 of them.

Alex_Chow

But the report also has a section to display all other items as well...

Savatage

generic wrote:

There are many things that are not accurate but are in W1.

lanemark

Thanks for all the comments guys, sounds like I opened a can of worms!
Cutting through all the comments, can anyone say if there is a std report for showing the top ** percent or top ** qty, inventory value as of now.
We have have thousands of item numbers, but I want to see which ones are making up the majority of of our inventory value.

Alan

ara3n

well the answer is to get the NA version of Top ___ Inventory report and import it into your database.