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!
Date
Votes
4 comments
-
Jet Reports Historic Posts Why is it not working? Do you get an error message? Is the result not correct?
Please know that inventory costing in NAV 5 is very different from NAV 2.6. Not just a little, but very different! One of the things to be aware of is that the table structure and the field names are different. If I were you I would go through the What's new in NAV 5 training manuals from Microsoft - there are some chapters on inventory costing. You may download these manuals from customer source on the Microsoft website, and otherwise your NAV partner may help you to get a copy. -
Jet Reports Historic Posts Thank you for the help. I'm sitting with my programmers right now, so I'll request the manuals!
What isn't working is that the value is extremely larger than reality. My programmer tells me that I need to take the Unit Cost Actual, divide by quantity, then multiply by remaining quantity.
If that's correct, how would I write it into a single line jet statement? -
Jet Reports Historic Posts Hmmm… that doesn't make sense to me. Unfortunately I don't have NAV nor the manuals on line here (it's 22.30 PM over here)… You could also try the NAV Help to find out more.
Good luck and have a great weekend. -
Jet Reports Historic Posts You should try the Value Entry table instead for NAV 5.0.
Something like
=NL("Sum","Value Entry","Cost Amount (Actual)","Location Code",F7)
Please sign in to leave a comment.