Order Management Project & Deliveries

[Aminov]

Hi everybody,

you must be familiar with MS template "Orders Managment", well I also need
to track its "deliveries"!

You know when a customer orders somthing and you simply ship the order over
multiple shipments/deliveries ...

I need a delivery form where I can enter the Order ID and it will
automatically pull all related data. next to each product on the order
details I need a "Quantity to deliver" and "Backordered" fields.

Is it another table "deliveries"? how to link it? does it have a "delivery
detail" table too?

Thanks in advance!

Regards,

 

[mnature]

How are you going to track deliveries? By the total order, or by each item
in the order? How do you know if an item is backordered? If you are
tracking deliveries by each item in the order, then you need to somehow link
your shipping information to both the item and the order. How much
information do you need about the shipping? Such as date shipped, date
received, shipping label #.

There are a lot of details that can go into tracking shipping. And all of
those details need to be entered into the database before they can be
accesssed.

 

[Aminov]

Hi mnature,

Thank you for your resposne, I think I need to clarify things more ..

I meant for each order there can be many deliveries, In one order when all
the items' "ordered quantity" matches the "delivered" quantity the order
status will change to 'complete".

Think of the "Order Managemnt" template ..

Suppose Order no.12 belongs to MNATURE and you have ordered 2 Bags and 5 Caps.
Now we're ready to ship you only 1 Bag and 3 Caps .. I open the delivery
form which looks identical to orders form but with new columns in order
details subform [Delivery Qty] and [Remaining].

Order: 12
Order Information

Customer: MNATURE
Customer Information

Order details:
[Product] [Ordered Qty] [Delivered] [Delivery] [Remaining] [Amount]
Bag 2 - 1 1
$5.00
Cap 5 - 3 2
$15.00

this is also called "progress invoicing" each delivery is an invoice for one
order!

Next time when Im ready to ship you the remianing items it should look like
this
[Product] [Ordered Qty] [Delivered] [Delivery] [Remaining] [Amount]
Bag 2 1 1 0
$5.00
Cap 5 3 2 0
$10.00

I hope its better now ... Thanks again