Hey All this is my first time on here so I apologize if this isn't the correct location.
I am having trouble with some code and I can't seem to figure it out:=-NL("Sum","Item Ledger Entry","Invoiced Quantity","Posting Date",$H$1,"Entry Type","Sale","Location Code","51","Item No.",NL(,"Item","No.","Bottle Size",$D25,"Bottles Per Package",$E25))
D25 is a valid size
E25 is a valid bottle per package
H1 contains a range set like this: 12/1/2013..12/31/2013
In NAV I can create this first portion with filters just fine. I pulled it out then applied the 2nd function (the nested one above) and it seemed to do what I wanted just fine. Any suggestions on this?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
i think you have to use the "Link="-Function in the second part like this:
=-NL("Sum","Item Ledger Entry","Invoiced Quantity","Posting Date",$H$1,"Entry Type","Sale","Location Code","51","Item
No.","Link=","Item","No.","= itemno","Bottle Size",$D25,"Bottles Per Package",$E25)
=> Link to the item-table, where the number is the item-no of the item-ledger-entry….
give it a try
regards
jetsetter
Please sign in to leave a comment.