2 Replies Latest reply on Jul 20, 2014 11:55 PM by LIZARAY

    how to make partial shipping / packing list / invoice

    Jacky168

      Title

      how to make partial shipping / packing list / invoice

      Post

      Hi everybody, 

       

      I have following tables

      CUSTOMER

      ORDERS

      OPLINES

      PRODUCTS

       

      Relationships are:

      CUSTOMER::_kp_customer_id = ORDERS::_kf_customer_id

      ORDER::_kp_order_id = OPLINES::_kf_order_id

      OPLINES::_kf_product_id = PRODUCTS:: _kp_products_id

       

      CUSTOMER -< ORDERS -< OPLINES >- PRODUCTS

       

      I can now import multiple orders for a customer with multiple products for one order. 

      For example: Customer Bob has 2 orders (order A and order B each ordered on different day)

      Order A has  Apple 100 pcs , Pears 100 pcs

      Order B has Apple 50 pcs, Strawberry 200 pcs

       

      Now I'd like to make partial shipments like Apple 50 pcs from Order A with Apple 50pcs from Order B. 

      (So the database should know I still haven't delivered Apple 50pcs from Order A, Pears and Strawberries.)

      So I can generate a packing list and a invoice for the partial shipment. 

      Further more I have to track all open shipments. 

       

      How can I store partial shipments?

       

      Sorry if this seems to be a stupid question... I am still new to Filemaker. 

       

      best regards

      Jacky