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.
- I want to enter all the part numbers from customer purchase order into an order form.
- I want to keep track of the backordered parts.
- I want to invoice for the parts as they come in. Don't want to wait until all parts from PO have arrived.
- 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.
- I want a Dashboard that will show me a summary of parts "not quoted", "parts quoted", "parts shipped", "parts received", parts invoiced.
- I want the Dashboard to provide details about the items in line 5 with a control button.
- I want a packing list autogenerated indicating a shipment number. Example; Shipment 1 of 1, Shipment 2 of 2, etc..
- I want to be able to import a large purchase order located in a excel sheet into my order form.