Join two tables

How could I link between  Purch. Invoice Line and Purchase Line tables?

  • Hey  jaweher89,

    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.

     

    Thanks

    Blog -  http://rockwithnav.wordpress.com/

    Twitter - https://twitter.com/rockwithnav

  • First Try This Link 

Related