In Progress

Excel Management System

Excel Management System: Labor order, Quote, Delivery order and Invoice

Purpose

We require a custom program to suit our needs as we cannot find one that does exactly what we require.

We wish to automate the creation of labor order, quote, delivery order and invoice from entering products in a labor order (LO).

We will now use the abbreviation LO for Labor Order.

The application must absolutely be built with Excel and VBA.

Activity of the company: a French company that sales and installs hygienic separation screens for hospitals.

Our wishes and constraints

This application is supposed to be used by sales people and commercial assistant.

The steps for creating various documents are:

- Build LO through Excel forms

- Convert the elements of the LO to the quote

- Complete the LO with necessary data when quote being accepted by the customer

- Generate the delivery order and the invoice from the LO.

The invoice is almost identical to the quote, some additional information is to be entered (Bank, ... ).

All documents are built from the LO.

I will describe in a little more detail the LO.

- There are 25 fields of general information on the entire LO.

- All products and specifications are added, modified or even deleted in the LO.

- A product consists of:

---> a screen

---> a rail (or not)

---> accessories (or not)

---> deliveries options (or not)

These elements determine the cost of the entire line of product.

- There are about 43 fields to include in the entry forms for entering a line of product.

This means that there are 43 columns in the LO sheet.

All columns are not necessarily fulfilled.

- The LO can contain multiple lines of products.

You’ll find more instructions in the attached documents.

Some other requirements:

- Prices need to be able to be changed on any quote and invoice without changing prices in the database.

- We need to be able to hit a save button to save as a pdf (for LO, quote, delivery order and invoice).

- The application must, of course, have a maintenance module for adding items in the various dropdowns and modify or add new products.

In the attached documents, you’ll find:

- All instructions needed.

- Screenshots of entry screens in which we must select products for the LO such as I imagined them.

- Different templates of documents (in French and some in English): LO, quote, delivery order and invoice.

- The rules to define the cost of each product line.

- The rules to edit the quote, delivery order and invoice exactly as we want.

- Examples to understand the functioning of construction cost.

- Any other support required for the good development.

I just indicate that there is no need to handle stock.

The final development must be user friendly and easy understanding.

I need that VBA code will be easily understandable (well commented) because I should keep it afterwards and I need to be able to add new information, without calling anyone to help me.

I would appreciate that the interface will be developed in French (because the final users are French people). You’ll have the screenshots of French interface (and some in English in order to understand what we are talking about, of course). However, the VBA code reviews can be in English, it’s not a problem for me.

If necessary, I will provide to the person who gets the project other documents translated in English like Quote, Delivery Order and Invoice (if necessary).

I'm sorry, I've forgotten to insert the attached document mentioned in the description.

Skills: Excel, Visual Basic for Apps

See more: what support will i need from management, what does purpose means, what are data entry forms, sales person on line, excel support company, define data entry, data entry screens, data entry screen examples, data entry management system, data entry in hospitals, cost of applications, convert from french to english, construction line application, bank-creation, application development prices, what is vba in excel, find in vba, excel vba help, define specifications, excel database data entry and management, define project management, customer database in excel, convert english to french, vba excel pdf, vba code excel

About the Employer:
( 7 reviews ) Orvault, France

Project ID: #5410847

Awarded to:

maverick44000

Hi Macgyver. I have made a very similar invoicing application in Excel before. It was completely implemented using VBA. I have read your project requirements and I can make the required application for your according t More

$1000 USD in 10 days
(71 Reviews)
6.8

31 freelancers are bidding on average $505 for this job

zExcel

H,I will be happy to help you with this project, but I will need to see the source data file and the screenshots that you referred to Please feel free to message me prior to accepting my bid

$388 USD in 4 days
(252 Reviews)
7.6
Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$421 USD in 0 days
(321 Reviews)
7.6
deepbluetech

Hi, I am an Excel macro expert and can take on the project. let me know and we can discuss further. Regards, Arul

$400 USD in 5 days
(194 Reviews)
7.2
seaanddream

Hello; your 5-star excel and vba coding expert is ready to help your project. pls check my profile and feedbacks first to have some idea about the quality of my business...I had many similar excel/vba tasks, all achiev More

$370 USD in 7 days
(217 Reviews)
7.3
bharanisrihari

Hi, I'm an Excel expert / VBA programmer. I can get your requirements done perfectly! Please refer the excellent reviews for my completed projects in Freelancer.com. One of the reviews for your reference: "Where More

$777 USD in 15 days
(69 Reviews)
6.4
paris2785

VB and VBA expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for: [url removed, login to view] Estate (video demonstration) [url removed, login to view] (video demonstration More

$350 USD in 10 days
(109 Reviews)
6.4
gokulanand

Hello, I read through your requirements and I am happy to assist you in this assignment. I can get you a VBA application that suit your needs. I had done these kind of assignments in the past. Please check out my More

$450 USD in 2 days
(95 Reviews)
6.0
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

$333 USD in 10 days
(110 Reviews)
6.2
nagybatonyi

In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are includ More

$377 USD in 10 days
(61 Reviews)
5.7
SiroosJafary

Good day, I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. I work with excel since 1999. Here a More

$777 USD in 14 days
(68 Reviews)
5.8
tomislav1975

Hello, I can help you with your project. I had projects like yours, and I'm very good in VBA and Excel. Please check my reviews, profile and portfolio. Play on me, you will not fail. With regards, Tom

$400 USD in 10 days
(33 Reviews)
5.2
abdolah2014

I am an excel-vba Expert and I am sure I can help you with your project .................................................................................. ............................................................. More

$500 USD in 10 days
(36 Reviews)
5.3
nblsoft

Hello, I am interested in your project and offer my services. I checked your supplied documents and I shall complete it withing given time. If you are willing to use this document on mobile devices then please no More

$555 USD in 28 days
(3 Reviews)
3.8
srdas2012

Hi, We are Expert in Word and Excel Macro VBA/VB6/VB.Net can bring almost VB6 in Macro. We have seen your Description understand the process ready to start We have delivered the following Excel Macro project More

$250 USD in 6 days
(6 Reviews)
3.2
seanmdale

Hi macgyver44, thank you for the detailed requirements. I am currently working on a very similar project for a company in the UK relating to contract generation and billing management (based on lead requirements and More

$350 USD in 7 days
(5 Reviews)
3.1
Muhammad78608

Hello, Ready to start. Please give me chance. I would try to complete the project with accuracy. Thanks.

$250 USD in 15 days
(3 Reviews)
1.6
gerardsmith

Hello, My name is Gerard, I'm a Systems Analyst. I have experience in excel VBA. You can visit my web page Argentina: [url removed, login to view] I can design and implement your system in 20 to 25 days (well tested). M More

$555 USD in 20 days
(2 Reviews)
1.5
Abhisog

A proposal has not yet been provided

$555 USD in 10 days
(2 Reviews)
1.0
mynameisajay

I am just posting a suggestion for an android app. It would be better for end users thats why If you are intrested please ping me.

$277 USD in 10 days
(1 Review)
1.0
aeriex22

A proposal has not yet been provided

$777 USD in 10 days
(0 Reviews)
0.0