Job Processing Software
- or -
Post a project like this£250(approx. $316)
- Posted:
- Proposals: 6
- Remote
- #16105
- Expired
Description
Experience Level: Expert
Can you take an existing MS SQL Database and build a front end for it? If so we want to here from you! We need someone who can build a front end app (either windows app or a web based app) for an existing MSSQL database.
The app should have the following features:
Data bases
- customers with all contact details & notes
- suppliers with all contact details & notes
- machinery detail of machinery & notes price/hr
- materials detail of mat,size,spec,length,cost,
del cost, del to have batch no hence we can list coc with del,notes
- sub contract with all contact details & notes ,min cost
parts all parts to be used to make finished assy,min cost
Quotation
- Date prepared,quantity,description,drg no part no,machinery set up cost/hr,run time ea,set up divided by qty to give ea cost ? Notes for ea machine
materials worked out by cost in length
notes f0r ea mat pulled in from database including supplier same for all databases?
Parts ,subcontract,tooling,notes
a break down of costs is handy to see for ea heading ?
From this should be able to print &e-mail customer quote
if customer goes ahead should be able to turn this into a works order with customers order no & del date
ability to copy quote for similar jobs
Works order
As quote but should list progam no & fixture no for ea machine we willonly know this when job is up and running but should be able to up date quote so if order comes again all info in quote ready to turn into works order ,schedule date ,delivery date ,should be able to break down order into batchs for different del dates , a option to check quoted times against actual time on ea machine op to calc profit or loss
- ability to copy works order for similar jobs
- ability to create works order without a quote
Delivery note
- To print customer del note should only allow you to pick live orders for that customer ability to under and over del.should change works order to del
- should be able to print &e-mail customer
- should be able to print as coc as well
Invoices
- to print invoice should only pick for that customer and works orders that have been del. Layout to suit customers invoice paper ,export to sage ,should change works order to invoiced
- should be able to print &e-mail customer
Purchase order
- should be able to link to works order so you can see po no
for your material or parts . Allocating mat or parts to works order & any extra ordered to stock
- should be able to print &e-mail supplier
good search filters on all screens
This project will not be a job done and that's it as whoever does this will get more work from support of this app - as you built it so we would like you to support it later and maybe add to it.
The app should have the following features:
Data bases
- customers with all contact details & notes
- suppliers with all contact details & notes
- machinery detail of machinery & notes price/hr
- materials detail of mat,size,spec,length,cost,
del cost, del to have batch no hence we can list coc with del,notes
- sub contract with all contact details & notes ,min cost
parts all parts to be used to make finished assy,min cost
Quotation
- Date prepared,quantity,description,drg no part no,machinery set up cost/hr,run time ea,set up divided by qty to give ea cost ? Notes for ea machine
materials worked out by cost in length
notes f0r ea mat pulled in from database including supplier same for all databases?
Parts ,subcontract,tooling,notes
a break down of costs is handy to see for ea heading ?
From this should be able to print &e-mail customer quote
if customer goes ahead should be able to turn this into a works order with customers order no & del date
ability to copy quote for similar jobs
Works order
As quote but should list progam no & fixture no for ea machine we willonly know this when job is up and running but should be able to up date quote so if order comes again all info in quote ready to turn into works order ,schedule date ,delivery date ,should be able to break down order into batchs for different del dates , a option to check quoted times against actual time on ea machine op to calc profit or loss
- ability to copy works order for similar jobs
- ability to create works order without a quote
Delivery note
- To print customer del note should only allow you to pick live orders for that customer ability to under and over del.should change works order to del
- should be able to print &e-mail customer
- should be able to print as coc as well
Invoices
- to print invoice should only pick for that customer and works orders that have been del. Layout to suit customers invoice paper ,export to sage ,should change works order to invoiced
- should be able to print &e-mail customer
Purchase order
- should be able to link to works order so you can see po no
for your material or parts . Allocating mat or parts to works order & any extra ordered to stock
- should be able to print &e-mail supplier
good search filters on all screens
This project will not be a job done and that's it as whoever does this will get more work from support of this app - as you built it so we would like you to support it later and maybe add to it.
Neil J.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
29 Mar 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies