How could I link between Purch. Invoice Line and Purchase Line tables?
You have to first find the Purchase Invoice Header then you need to find the Pre-Assigned No OR Order No and from this you can filter with Document No in Purchase Line
Purchase Invoice Header No. = Purchase Invoice Line Document No.
Note - Whenever you Post a Purchase Invoice - Invoice No goes in Pre-Assigned No of Purchase Invoice Header.
Whenever you Post a Purchase Order - Order No goes in Order No of Purchase Invoice Header.
Blog - http://rockwithnav.wordpress.com/
Twitter - https://twitter.com/rockwithnav
First Try This Link