Analysing and reporting in NAV 5.01, Analysis Types

Business Central/NAV User Forum
1

I have a customer who tries to build analysing reports. This customer is trying to build up a Column Template that shows: In SalesOrder (Amount and Qty) - In PurchaseOrder (Amount and Qty) and Stockvalue(Amount and Qty) - 6 columns. When using this template in a report, we get correct values in all columns exept for Stock Value Amount.

This column uses Analysis Type Code = Inventory and Analysis Value Type = Cost Amount. It seems that Analysis Value Type = Cost Amount gets it’s values from Cost Amount (Expected). This column will only have values when Item Entries are open (not invoiced) and I can not see that this is correct. I my head, Stock Values are based on Actual Cost not Expected.

Now to my question: Does anyone know how I can get the report to show what I need?

I have tried to create new Analysis Type, but find no Value Type that will give me exactly what I need. I have also tried using other Analysis Types, but they are based on the same Value Type and therefore no help.

Thanking you in advance for your reply.

Toril

2

Analysis reports from NAV is really an annoying tools. Sometimes you get the value right and sometimes you don’t. Sometimes it shows even grand total wrong although your formula there is right. Because of these errors i build reports myself by reports objects, it takes time but at least you can get result right and do what ever you can.

3

Then what is the point in having such a tool? Reports are static, Analysing and reporting as well as Account Schedules are exellent dynamic tools, but worthless if you have errors like this.

How do one explain this to a customer? Difficult. Creating reports by report objects will cost money, using Analysing and Account Schedule tools are free…

Thanks anyway! :slight_smile:

4

They are excellent tools but sorry to say about the errors but still try to make them work as you want to. Does any one else have problems with analysis reports in sales or purchase, please share, thanks.