This is what the situation is that I need help designing.

Customer sends us a purchase order with 50 parts that cost $150k per part.
Manufacturer can only supply 1 to 2 parts a month.


Manufacturer requires payment before shipment.
We pay the manufacturer when they notify us when a shipment is ready.
We receive 1 or 2 parts.
We ship the parts to the customer.
We create an invoice and email or snailmail it to the customer.

  1. I want to enter all the part numbers from customer purchase order into an order form.
  2. I want to keep track of the backordered parts.
  3. I want to invoice for the parts as they come in. Don't want to wait until all parts from PO have arrived.
  4. I want to print a "Request for Quote" for the items on the order form so I can easily send it to vendors via email.
  5. I want a Dashboard that will show me a summary of parts "not quoted", "parts quoted", "parts shipped", "parts received", parts invoiced.
  6. I want the Dashboard to provide details about the items in line 5 with a control button.
  7. I want a packing list autogenerated indicating a shipment number. Example; Shipment 1 of 1, Shipment 2 of 2, etc..
  8. I want to be able to import a large purchase order located in a excel sheet into my order form.