Find Jobs
Hire Freelancers

Access Customer invoicing and quoting System

R10500-21000 ZAR

Terminado
Publicado hace casi 8 años

R10500-21000 ZAR

Pagado a la entrega
I need an access developer to quickly and efficiently develop an access database with a graphical interface that has separate pages to cater for customer details, quoting section to quote customers, invoicing section to invoice customers, inventory section to house inventory items, timesheet housing to hold day labourers timesheets, and in turn take those timesheet additions and attach it to a specific contract that is on going. This customer is a painting company and has many different projects or contracts progressing simultaneously. each contract has a foreman managing it, and each foreman has day labourers working for him, each day labourer gets paid a weekly wages depended on how many house he pout into the project. so each labourer time spent needs to be attached to a contract in order for analysis and business intelligence to be produced from each contract. such as, if the allocation of a project is ZAR100k, and the project has taken ZAR150k of inventory items together with labourers wages then contract needs to be flagged and reported to the managers in order for resolution. all of this needs to happen from within the access, so the access system needs and user friendly interface, with reporting, and user management so each transaction can be tracked. I would prefer the database to present itself to the user in his way: Landing page: menu to other links somewhere as well as immediate reporting on current contracts/ Graphs, and insights Customer Page: houses customer details records, where users with appropriate access can add and edit client details. Contracts: employees need to be able to add and edit contracts on this page, and also the ability to convert a quotation into a contract, therefore o open the project and begin assigning resources to it such as man hours from labourer timesheets, and inventory items. The also needs to be a place to add an amount, as to determine whether the project is ahead of schedule or behind, eg: if the project is quoted at ZAR100 for phase one, and the project completion rate is 2 weeks, then at the end of the first week, an admin person captures all the wages of the labourers and inventory items utilised on the project against the project, and it is ZAR80k, then they are ZAR30K over budget and the project needs to be flagged and managers notified. Information from the contracts section needs to be graphed an reported on the main page as dashboard information. Quotes: employees can create quotes on this page per customer, and attach items to it that are added in the inventory section, such as labour and paint etc. Invoicing: needs to be able to compile and send invoices to customers. Timesheets: employees will enter manually , timesheets for foreman, and labourers against a contract. Inventory: needs to be able to add/ edit/delete items such as labour codes, paint, paint brushes etc. Reporting: needs to be able to select an pull specific reports, such as contracts, item movement, customer spending, labourer wages etc. Admin: admin assets, such as adding/ editing users, permissions etc. I need the system built relatively quickly. I believe it is a simple enough task to achieve, I simply do not have the time.
ID del proyecto: 10999803

Información sobre el proyecto

2 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Access database and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html). I can send you a sample of my previous work upon request.
R15.000 ZAR en 10 días
4,8 (75 comentarios)
6,1
6,1
2 freelancers están ofertando un promedio de R16.765 ZAR por este trabajo
Avatar del usuario
Hi, I am a macro and Access developer. I have designed many database for out projects. I can help you to create this database along with self contained Interface . I would like to have a chat for more details. regards, mantu
R18.529 ZAR en 10 días
4,9 (21 comentarios)
4,8
4,8

Sobre este cliente

Bandera de SOUTH AFRICA
Johannesburg, South Africa
5,0
4
Forma de pago verificada
Miembro desde nov 10, 2015

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.