Hi guys,
Im fairly new to Jet but have mastered the basics, I'm trying to produce a report to include current free stock. As this is a caluculated field and not something that you can drop in using the browser function can anyone tell me what the formula/calculation/tables are?
Huge thanks!
Ash
Date
Votes
3 comments
-
Jet Reports Historic Posts Official comment Hi Huges,
Thanks for such a prompt response, after much scratching of the head I managed to find the table. It returns the inventory value and a simple formula to minus the qty on sales order results in free stock. PERFECT!
=NF($B4,"Inventory","Location Filter","MAIN")
Thanks again,
Best wishes,
Ash -
Jet Reports Historic Posts Hi Ash,
Assuming you are a NAV user, this sounds like something you should ask your NAV solution center about. Assuming it is a field you find somewhere in NAV, the people who know how NAV is setup for you can probably tell you either (a) where that field exists if it's a flow field or (b) what calculation NAV is doing to get the number you see in NAV. Either way, once you know this it should be easy to get the same result in Jet. Does this help?
Regards,
Hughes -
Jet Reports Historic Posts Hi Ash,
I'm glad you found the field! I just remembered there is something called Zoom on the Tools menu in NAV that might be helpful to you in the future as well. As long as you have the granule for it on your NAV license, you should be able to do Tools -> Zoom from any NAV form and it will open a new window which has the name of the table in the title bar and shows you the field you are looking at. This can be helpful for figuring out where a particular piece of data comes from. Sorry I didn't remember it earlier, but I'm glad you figured it out.
Regards,
Hughes
Please sign in to leave a comment.