I'm tryinig to create a sales dasboard. Therefor I need the sales invoice header for some information but also the sales invoice lines. A invoice header has always more lines below it.
I have build a small part of the complete dashboard in the Tableuilder and it provides very quickly the information. However I would like to build this report with the Browser because than it's easier to add some columns.
I Used exactly the same formula with the browser ( that's what I think what I did) but than it doesn't work.
Can someone help me with fixing this issue and tell what I need to do?
Date
Votes
4 comments
-
Jet Reports Historic Posts In the meantime i received some information regarding my issue above. However I have a performance issue with building this report.
I firstly take the sales invoice line, after some filters, I link the invoice header to the lines to filter on Posting date. ( This is the way to do this following the information I received). When I refresh this with a date from today, than he is busy for more than 10 minutes to give me a result, this because we have for 12 years history in our database. I added a additional filter on the document number and now it takes more than 3 minutes.
I'm used to build a query like this (via ExSion) with starting with the header and than add the lines.
Now I build this query with the Table Builder (starting with the header) and than add the following information. On this way it's much quicker, the only disadvantage with this way of building the query is that if you like to add formulas you need to do that in the table builder. That should be no problem, however if you want to use the formule V.Lookup than it is not easy because after closing the Table builder he is filling the query into a new document.
Does anyone have a idea to get the query quicker via the Browser, or to use the V.Lookup function via the Tabel Builder! -
Jet Reports Historic Posts Have you tried using NL(First) from the Browser to get the data you need from the Sales Header :
=NL("First";"36 Sales Header";"43 Salesperson Code";"1 Document Type";"Order";"3 No.";"101011") -
Jet Reports Historic Posts How about Rows for Sales Invoice LIne with a Link to Sales Invoice to filter on Posting Date?
-
Jet Reports Historic Posts Hi Hans,
your last suggest is what I already made as well. However after running and saving and than runnig again I receive an error that it's not allowed to have a empty filter. I need to rebuild the total formula before it gives me "again" the correct data
Please sign in to leave a comment.