I want to create a report which tells me which of our clients from (country X) ordered which products and what discount did they received. As I am working with Navision since Mai 2008 and Navision since December 2008, I am a little stuck. In my opinion I have to do the following:
Nl on customer =NL("Rijen=3";"Klant";;"Land";"Be";"Datumfilter";"01-01-2008..31-12-2008") I think this will give my all customers from Belgium who ordered within the given date.
NF on the NL to retrieve customernumber and name.
A new NL on the invoice with a link to the customernumber =NL("Rijen";"Verkoopfactuur";"Nr.";"Klantnr.";$D5)
My first problem is that Jet. retrieves invoices which don't met my recuirements. I even get invoices from 2005 etc.,which means I made in mistake during the linkage with both NL-functions.
Second problem; now I have all invoicenumbers I want to see in detail what products they orderd and how many discount they received. I really do not have any idea how to.
Date
Votes
3 comments
-
Jet Reports Historic Posts Someone?
-
Jet Reports Historic Posts I'm going to assume Klant is Customer in english.
I would put a date filter in cell F5, as whilst your formula in C5 will return the list of customers within that date range, your link in F5 is still showing all 'Verkoopfactuur' (whatever that means) for that customer, not just the date range. I'm guessing Verkoopfactuur is Sales Header, in which case Posting Date could be used as the date filter.
To maintain the report, I would put the date range into its own cell, and reference it from the forumlas in C5 and F5.
Good luck, let me know how it goes. -
Jet Reports Historic Posts Sorry for forgetting to translate. Klant means Customers indead and Verkoopfactuur translated is Sales Invoice which properbly is incorrect English. I am going to tryout your suggestion. Many thanks sofar.
Please sign in to leave a comment.