Hello -
I am using Dynamics NAV + Jet and trying to create a report that pulls in links from the record link table. I have no issue pulling in the first link attached to a purchase invoice, but if an invoice has 2 or more links, I can't pull them in. Here is the function I am using:
=NL("First","Record Link","URL1","Record ID","Purch. Inv. Header: "&$H15) – this one successfully pulls in the link. H15 references the PI number.
How would I write a function to pull in the second/third/fourth links for the same PI? I tried:
=NL("Last","Record Link","4 URL2","Record ID","Purch. Inv. Header: "&$H15)
&
=NL("First","Record Link","4 URL2","Record ID","Purch. Inv. Header: "&$H15) - But neither works, even when I know the PI has a second link.
Would I need to use NL(Rows)? I tried:
=NL("Rows","Record Link","3 URL1","10 Created","1/1/14..1/31/14","Document No.","PI*") - which seems to pull in all of the first links, but then I can't figure out how to reference which PI number the links belong to! This does not work: =NL("First","2000000068 Record Link","14055650 Document No.","3 URL1",$D23), where D23 references the link from NL Rows.
And when I enter in
=NL("Rows","Record Link","4 URL2","10 Created","1/1/14..1/31/14","14055650 Document No.","PI*") to try to pull in all second links, nothing appears (even though I know some of the PIs do have two links).
Date
Votes
3 comments
-
Jet Reports Historic Posts Hello -
What issue do you experience when you replace your working NL(First) function
=NL("First","Record Link","URL1","Record ID","Purch. Inv. Header: "&$H15)
with the corresponding NL(Rows) function?
=NL("Rows","Record Link","URL1","Record ID","Purch. Inv. Header: "&$H15)
For example, if I were working with the Purch. Inv. Header and Line tables and had my document number in cell B4 and my NL(Rows) in C5:
-
Jet Reports Historic Posts Hello,
It worked! Thanks for getting back with me.
Does this mean "URL1" is the field for all record links? -
Jet Reports Historic Posts Hello -
While I am not familiar with any "Record Link" table, I would assume that "URL1" is simply a field in that table.
The function:
=NL("Rows","Record Link","URL1","Record ID","Purch. Inv. Header: "&$H15)
would simply return a list of all "URL1" values in the "Record Link" table where the "Record ID" value matches what is listed.
Please sign in to leave a comment.