Database for business management

I want a system where I generate Job orders imported from an excel file

When the job order is generated there will be 2 types of products

Products in stock for resale and products to be manufactured

There needs to be 3 milestones for products to be resold

Ordered,

In-stock

Ready to dispatch

There needs to be 3 milestones for products to be manufactured

Doors machined

Gables Machined

Doors and Gables Painted

Carcasses machined

Ready for assembly

Units assembled ready for dispatch (This would need to be for each item to be manufactured on the order sheet the other milestones are for the collection of goods to be manufactured)

When these have been fulfilled I want to be able to create a delivery note

I want to be able to account for follow on items if there is something not in stock or a remedial needs to be raised in the event of a product been faulty

For each Job order I need the following Milestones

Houses Ready

Kitchen Delivered

Wardrobes Delivered

Kitchen Fitted

Wardrobe Fitted

Worktop Fitted

Kitchen Painted

Kitchen & Wardrobes Snagged

Job invoiced
About the recuiter
Member since Mar 14, 2020
Siddharth Bhang
from Western, Ghana

---

---

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions