AnsweredAssumed Answered

how to make partial shipping / packing list / invoice

Question asked by Jacky168 on Mar 22, 2010
Latest reply on Jul 20, 2014 by LIZARAY

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

 

 

 

Outcomes