Valuing inventory at retail prices rather than cost

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.


Please sign in to leave a comment.