Hi,
I'm writing a report using the Purch. Inv. Lines and Purch. Inv. Header tables and I'm having trouble with filtering. I want to show line item detail for documents with lines where the Type is "Item" plus some addl filters. But I also only want to see the lines when the Header for the document has an Order Date within a specific date range. This is basically a data dump with filters needed on both the header and lines. I don't know how to get both these filters working together.
My basic report formula is:
=NL("Rows","Purch. Inv. Line",,"No.",$C$5,"Type","Item","Posting Group","TIC|FINISHED","Quantity","<>0")
How do I add a filter on the Purchs. Inv. Header so I can filter on the Order Date?
I'm on version 7.1.2 of Jet.
Thanks,
Gretchen
Date
Votes
4 comments
-
Jet Reports Historic Posts You could try using link=
=NL("Rows","Purch. Inv. Line",,"No.",$C$5,"Type","Item","Posting Group","TIC|FINISHED","Quantity","<>0","link=","Purch. Inv. Header","No.","=Document No.","Posting date","CELL REFERENCE")
Something like that should work. -
Jet Reports Historic Posts Hi,
Thanks for steering me in the right direction. I checked out the LINK and FILTER syntax in the Jet Help after I got your reply and decided to use the FILTER because the primary table is bigger than the secondary table. And it worked! Would the LINK be better?
Gretchen -
Jet Reports Historic Posts I think in this case NL("Filter") would be better.
-
Jet Reports Historic Posts Depending on what Version of Navision you have, the Posting Date should be on the "Line" Tables as well.
=NL("Rows","Purch. Inv. Line",,"No.",$C$5,"Type","Item","Posting Group","TIC|FINISHED","Quantity","<>0","Posting Date",CellReference)
Please sign in to leave a comment.