This is the first function NL("sheets";"vendor";"name";"no";settings!$D$5) - works and creates sheets for all vendors. This is the second function NL("first";"vendor";"no";"name";the first function) - and here a problem: for about 15 (of 800) vendors I can't get numbers, thus I can't get transactions (avaiable only via the number of the vendor).
An answer to the question why it doesn't work is simply: something's wrong with vendors in my Microsoft Dynamics NAV. But as I don't know what, and you neither, this answer is of no use (however if someone knows what is wrong, please share your knowledge).
So another question: how to get separate sheets named after vendors names and get vendors numbers at the same time. I tried with two NL sheets functions in one sheet - it gives only one sheet for the first vendor in NAV. I tried NL filter in a few combinations - nothing special: either sheets named after vendors names but all with the same vendor number (again the number of the first vendor in NAV) or some never ending calculation.
Thanks for help.
Date
Votes
1 comment
-
Jet Reports Historic Posts This is the first function NL("sheets";"vendor";"name";"no";settings!$D$5)
Be aware that Jet is giving back UNIQUE names this way.
Maybe that is why you are not getting all vendors.
Try a test worksheet that has NL("Rows";"Vendor";;"+Name";"*") in D4 and NF($D4;"No.") in D5 and NF($D4;"Name") in D6
If you run it, you have to see all vendors and their names, sorted by name.
The possible duplicates should be easy to spot.
HTH
rmw
Please sign in to leave a comment.