I am creating a warehouse report for items which are currently in stock and back in our warehouse. I am using a key which filters by a specific item Variant (which denotes that an item is in stock and reserved for a specific customer).
Each row will then show an Item #, UPC, Description, and Quantity Available.
I am able to successfully create all of the report with the exception of the most important part - the column adding together what is actually in stock for each item. It simply doesn't show up as a column I can select in my NL function (no matter the type of NL function I choose in the "What" category).
The field is a calculated field attached to one of our tables - the "Bin Content" table and is called "Available Qty. to Take". It's a calculation that takes the Quantity (base) and then subtracts/adds various fields which would effect what is currently available for picking in our warehouse. When I use the NL function, I can always see the Quantity (Base) field, but never see "Available Qty. to Take" - which is the field I need to sum.
How do I get this field to show up in my Jet Report? I am missing some critical piece to pull a calculated (or is it called FlowField?) out of NAV and put it into Jet. Picture attached of the columns I have in Bin Content, including the one I want to sum…
Thanks,
Nate
Date
Votes
4 comments
-
Jet Reports Historic Posts Welcome to the forums Nate.
One trick that I think will help you in navigating NAV tables and trying to determine where your value is - is the Zoom window feature in NAV.
Open a record that clearly has the number you are looking for in the Flow field, then with that record open - use the keyboard shortcut CTRL+F8 - or, if you prefer your mouse, go up to the toolbar and select the Tools menu, then locate Zoom.
I think this exists on every version of NAV.
Once you have the zoom window open, scroll through the list to see if you can locate your flow field value - or at least see if you can find the field with a bunch of asterisks in the value column. (some flow fields seem to appear that way in my data)
In the installation of NAV that I have here, I've found it helpful to un-hide the Field Name column (there are only three columns on the Zoom window), because some of the fields have a 'friendly name' that was created when the database was customized, so the second column helps me identify those.
Hopefully this helps you track down your elusive value! -
Jet Reports Historic Posts Thanks Heather! It turns out that in NAV 2013 the Zoom feature turned into the Help > About this Page feature but I was able to translate that…though the rest of what I say will hinge on (hopefully) the page I'm looking at being analogous to your Zoom page.
I did find the field in the About This Page document – it's under a section entitled "Source Expressions". Do you know what the trick is to get fields from "Source Expressions" to be available in the Jet report? Note that this field, therefore, is not a Table Field for Bin Content. -
Jet Reports Historic Posts hi,
i don't know the table (and fields) in your database, but that field should be to see in the jetreports-function, when it is in the "bin Content"-table. But maybe it has another caption, so you don't find it, when you are looking after "Available Qty. to Take". Are you able to open the table via object-designer? there you could ccheck the caption (maybe you have to enable that column…)
regards
jetsetter -
Jet Reports Historic Posts The bin contents table is a transaction table with fields calculated in the matrix page the attached is a quick example of how the values are calculated
Please sign in to leave a comment.