I am trying to produce a report with a running list of invoices paid for a specific project, including vendor name, date of invoice, and amount (so far, so good). I need to also identify the check number that paid each invoice. I can't figure out how to get the check number to populate. Any advice :?:
Many thanks….
Date
Votes
2 comments
-
Jet Reports Historic Posts Well, I figured it out….. :D
If anyone using Nav is interested:
=NL("First","Vendor Ledger Entry","Document No.","Applies-to Doc. No.",$H4) where $H4 is the document no. from the purch. inv. header (or line, depending on what you were filtering for to access the document number). -
Jet Reports Historic Posts Sorry for our late reaction, maybe you could add a filter on "type" to be absolutely certain (double doc nos). Usually your No Series are correctly specified, but sometimes they're not.
Please sign in to leave a comment.