I use Navision. I am trying to run a report that will give me open POs and closed POs that have been invoiced. The reports are running fine by themselves. I can't seem to link these two tables. The linking field between the two tables will be "Order Date". Has anyone had this problem?
Date
Votes
3 comments
-
Jet Reports Historic Posts Sorry,
I don't see how you "link" tables based on date. Can you sketch a report/post an xls(x) to illustrate what you're trying to achieve? -
Jet Reports Historic Posts Thanks so much for responding.:) The link does not have to be a date. I have been trying to use that but I am open to suggestions. I am trying to get a report that will show all purchase orders that have been opened within a date range. I need to show the purchase orders even if they have been closed by invoicing. I am trying to link together the "Purchase Header" table with the "Purch. Inv. Header" table. I want the purchase order number to show up only one time.
-
Jet Reports Historic Posts Due to the nature of Jet, you will need two NLs to pull your data (purch header and purch inv header), but I don't see where you'd struggle?
Please sign in to leave a comment.