0

Inventory Value

What seems simple, has me stumped. I'd like to calculate inventory by location, in one Jet Report function.
We're using Microsoft Dynamics 5.0 SP1

Here is what I'm using that isn't working.
=NL("Sum","Item Ledger Entry","=NF(,""Quantity"")*NF(,""Cost Amount (Actual)"")","Open","Yes","Location Code",F7)

Has anyone done this before?

We just upgraded from NAV 2.6. Looks like I need to go back to Jet training for 5.0!
Thanks for all your help!

4 comments

Please sign in to leave a comment.