Data Items and Report Performance

zeninoleg · 2006-04-17

Hello, everybody

I am in process of creating a report in Navision 3.70 and have following question. How does Data Item Indent influence speed of the report.
Let me explain what I mean. Suppose I have a simple performance test
1) Data Items/indentation are
Sales Header
--Sales Line(indeded under Sales header wih the No.= Document No. link)
2) Data Items is
Sales Line

In both cases there is a counter counting the Sales Lines. Reports are processing only. Question: which one will be faster?

I have done this test and it looks like the first one is even faster then the second one.
Has anybody done any tests on the large amounts of data?

Savatage · 2006-04-17

try 3) Item Ledger Entry

if you need cust info
DataItem
Customer
->Item Ledger Entry

I Created a report a while back to Print Shelf labels for every item a customer bought. First I used Sales Header & Line - But when I updated the report to use item Ledger Entry it was much much faster.

That report used
Item ledger Entry
->Item (so I can use the item info n' stuff)

the Source # is the Customer #
& you just have to specify the Entry Type (ie. Sale, Credit Memo.....)
Posting Date if you want to use Ranges

That's my story & I'm sticking with it. O:)

What are you trying to do?

zeninoleg · 2006-04-17

Thanks for the quick reply.

Actually I have just used Sales Header and Sales line as examples. My problem is that I have to get all sales for the particular Item for the particular posting date range(I also need a Bill-to customer). So I am between 2 solutions:

1) Create a record variable SalesInvoiceHeader and set range on it for the date range, then get first and last numbers for the posted invoices. And finally set range on the DataItem Sales Inv. Line for the document numbers. This will get me a range of all the Posted Invoice lines for the particular Posting Date Range

2) Create report on the following structure of DataItem's
Sales Invoice Header
--Sales Invoice Line(with the link by the Document No.)

The amount of Invoice lines will be hugggggge, so i am not sure which way to select...

David_Cox · 2006-04-17

I agree with the Item Ledger option, you have the type Sale, also a Source Type (Customer)and Source No. (Customer No.), which I belive is the bill to Customer, not sure if there is a suitable key, you would have to check that one.

Alex_Chow · 2006-04-17

Use the item ledger instead of sales invoice line.

The reason is that the sales invoice line has more records than the item ledger. The item ledger only has item information while the sales invoice line has G/L, Item, Resource, Fixed Asset, comments, etc etc.

zeninoleg · 2006-04-18

My problem is that Item Ledger Entry has only Sell-to Customer but I need the Bill-to Customer number from the particular transaction

kriki · 2006-04-18

I would go with "Sales Invoice Header" and indented "Sales Invoice Line" with a filter on "Type". This way if a date is not good, the header is already skipped and you don't need to read all the records of the lines.
Of course it would be good to have a nice index on the header-table.
In case you need also to read the item-table, check this post : Limiting database reads when processing lots of records.

DenSter · 2006-04-18

Just be aware that going off the invoice documents, you can't guarantee accurate results, as users can delete invoices from the system.

zeninoleg · 2006-04-18

Thanks for all you input! =D>

Data Items and Report Performance

Answers

Categories