I need to report on Qty's by Location.
I have no problem creating the report if all I need is to get over-all Qty's. (I can get this data easily from the Item table.)
However, we have 4 locations and thousands of Items. So, where does Nav 5.0 store this information, and what fields/filters do I need?
I was hoping to find a sample report with this information (I imagine that it is fairly typical that users would want to see Qty's by Location), but I have not been able to find a sample.
Any suggestions wold be appreciated. :?:
Samuel
Date
Votes
3 comments
-
Jet Reports Historic Posts You should be able to use the flowfilters on the Item table to filter by the location.
Presuming B2 has your NL on the Item table, you could use an NF in C2. For example, if you're after Sales Qty, try something line:=NF(B2,"Sales (Qty.)","Location Filter","<your location code>","Date Filter","01/01/08..12/31/08")
This is off the top of my head, so you might need to play with it a little. You should be able to get the general idea.
If you use the Jfx button, it will prompt you for the possible filtering options. -
Jet Reports Historic Posts There is a simple example of Inventory Qty by Location
http://community.jetreports.com/viewtopic.php?f=13&t=469 -
Jet Reports Historic Posts Thank you :D markl & shermang.
In your short replies, you have both been helpful and pointed me in the right direction.
Samuel
Please sign in to leave a comment.