Job Processing Software

  • Posted
  • Proposals 6
  • Remote
  • #16105
  • Expired
Ashraf A.David O.Jason T.Atif P.Usecureit L. + 1 other have already sent a proposal.
  • 1

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.

Clarification Board

    There are no clarification messages.