how to make partial shipping / packing list / invoice
I have following tables
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.