Hello,
I'm looking for assistance in JET to pull Unit Cost from Navision based on an Item No., Location Code and Lot No. The Item No & Location Code are located in the stock keeping Unit table and the Lot No. is located in the Item Ledger Entry table. I used Jet sometime back and have a gotten a bit rusty so to speak, so any assistance with the formula would be appreciated. Using latest Jet and NAV 2013 R2. Can anyone assist in getting the below to pull correctly? I don't think from "Link…." on is working as it's pulling the Item & location code only and disregarding the Lot #. Not sure if there is one place in Navision that has all 3 information pieces in one table. Thank you! Below is the formula that is not complete. File is attached also. =NL(,"Stockkeeping Unit","Unit Cost","Item No.",$D5,"Location Code",$F5,"Link=","Item Ledger Entry","Lot No.",K5)
Jay
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Jay -
One thing you will want to keep in mind when using LINK= is that you have to tell the function how to link your two tables together.
Here's Jet's KB article on that feature –> http://kb.jetreports.com/article/AA-00723
In the first example listed in that article:
=NL("Rows","Sales Invoice Header","No.","Posting Date",">1/1/2009","LINK=","Sales Invoice Line","Document No.","=No.","Type","Item")
The secondary table (SALES INVOICE LINE) is tied to the primary table (SALES INVOICE HEADER) through the "Document No." and "No." fields (respectively).
I noticed that your NL("First") function:
=NL(,"Stockkeeping Unit","Unit Cost","Item No.",$D5,"Location Code",$F5,"Link=","Item Ledger Entry","Lot No.",K5)
did not include that.
I hope that helps point you in the right direction.
Please sign in to leave a comment.