I am using NAV 5.0 and Jet 7.1.2.
I would like to be able to create a report to value our inventory by vendor at retail prices rather than cost values.
One way to do this would be to create a report using the NL to return each item with the inventory quantity and the retail price, and multiply the two. Then sub-total by vendor. However, given we have several thousand items but only 50 or so item vendors, this is a big and quite slow report, and is not very user friendly for our purposes.
Has anyone got a suggestion on how this could be done more quickly. Is it possible to use an array formula with Jet and is this a fast way to run the report?
Any thoughts appreciated.
Date
Votes
3 comments
-
Jet Reports Historic Posts If you upload your report Peter, we will gladly take a closer look at it to see how we may help you.
-
Jet Reports Historic Posts Thanks for that. Here it is.
-
Jet Reports Historic Posts Hmmmm… interesting… your report looks good. I wonder what happens if you change your formula in D6 to either
=NL("rows";"item";;"+vendor no.";C5;"No.";"I*")or=NL("rows";"item";;"+No.";"I*";;"vendor no.";C5)
Please let me know what the performance with each method is.
Please sign in to leave a comment.