Dear All,
I use the report wizard to extract lists of data out of Navision. My current list is really long and takes a while. When I have the list I throw away 80% of it. I think it should be possible to set a more inteliigent filter.
I hope you can help me with this.
I want to extract a list from Navision with alle 'sales invoice lines' (table 113), but only those of which have the status 'Open' = True in the table 'Cust. Ledger Entry' (table 21).
Looking forward to your support
John
Date
Votes
2 comments
-
Jet Reports Historic Posts Hello John -
The Jet Report Wizard is for extracting information from a single table. You will want to tie two tables together to accomplish what you are looking for.
It sounds like you would want to use Jet Essentials' LINK= feature (http://kb.jetreports.com/article/AA-00723).
Probably something like this:
=NL("Rows","113 Sales Invoice Line",,"Link=","21 Cust. Ledger Entry","3 Customer No.","=Sell-to Customer No.","36 Open","True") -
Jet Reports Historic Posts Hi John,
Your approach is good, but I think it would be better to turn it around. Why not extract al the open invoices and lookup the line details of these invoices?
I think this will upgrade the report performance and does not give you al the unneccessary data. I just run the report and it gave me +37.000 line records in less than 5 second.
I used this filter
=NL("Filter";"21 Cust. Ledger Entry";"6 Documentno.";"36 Open";"True";"4 Postingdate";"01/06/15..06/06/15")
With this filter you can use NL ROWS or NL TABLE function to extract the data from the invoice lines table.
=NL("Rows";"113 Sales Invoice Line";;"3 Documentno.";$C$5)
C$5$ refers to the filter i mentioned above.
=NL("Table";"113 Verkoopfactuurregel";{"131 Postingdate"\"3 Documentno."\"11 Description"};"3 Documentno.";$C$5)
C$5$ refers to the filter i mentioned above.
I you have any questions please let me know.
(eventueel in het Nederlands)
Please sign in to leave a comment.