11 Replies Latest reply: May 26, 2016 9:12 AM by Hans kleijnen RSS

    indirect mapping invoice to order

    Hans kleijnen

      Hi

       

      my todays challenge:

      3 tables

       

      Table 1
      Order NumberQty
      15100012
      15100023
      15100031
      15100044
      15100055
      15100062
      15100078
      15100082
      15100091

        

      Table 2
      Delivery NumberPredecessorPredecessor Table
      152000115100011
      152000215100031
      152000315100021
      1520004
      152000515100041
      1520006
      152000715100051
      15200081510006

      1

       

      Table 3
      Invoice NumberPredecessorPredecessor Table
      153000115200012
      153000215200032
      153000315200022
      153000415200052
      153000515100071
      153000615100091

      My Invoice table does not contain always an ordernumber. It contains the reference to the document that triggers the invoice and the reference from which table that trigger document originates. The trigger is either a delivery document, or the order document itself.

       

      how to connect ordernumber to the invoicenumber. the result in the end needs to give me all orders and all invoices

       

      thank you for your help