Write some Software to generate and print invoice from Excel file
₹1500-12500 INR
Completed
Posted about 8 years ago
₹1500-12500 INR
Paid on delivery
Require some sort of software that can generate and print invoice from excel file.
What we have is a database sheet that is updated manually by us. This contains Customer details and the products they buy from us.
What requires to be done is :
The excel sheet data to be presented in the form of an invoice (see attached images) that can be printed.
So, where it says, "Invoice #" should be a drop down menu where we select A1, A2 .. A3.. etc. that is fetched from the database. When we click the invoice number, say A1 it should be able to generate the invoice for that particular transaction. When we select A2 all particular of that invoice be generated and printable with a click of button.
Other requirements:
- PRINT ALL INVOICE button - when clicked, this should be able to print all the invoices from the excel database from A1, A2, A3..... A999, etc.
- Our company name, logo, vat number, etc. should be left editable. So we could change it any time we want.
- The amount should be displayed in currency relevant to the particular transaction as it is in database. Example, Euros, Pounds or Dollars
We have attached the excel file which contains both the data and also a sample copy of expected output.
Important:
Some orders with more than one item are not displayed in a single row but separately in different rows (invoice A3 in this sample file). So, kindly study the database file thoroughly and place your bids only if you are sure you can do this. No timewaster please.
Kindly note, attached file is only in sample database. In real world situation we have a thousands of invoice.. so the number goes from A1 to... A990098
Dear Sir or Madam,
I have developed a prototype which shows the concept of implementing the features you asked for.
My proposal is to do the task by VBA scripts in the same Excel file. The same logic may be implemented in a standalone application, but it will still use Excel VBA features through COM technology.
Please reply so I could send you the file.
Best regards,
Alexander.
₹3,500 INR in 3 days
5.0 (21 reviews)
4.7
4.7
13 freelancers are bidding on average ₹8,982 INR for this job
I CAN do this job, and do it well! If you look at my portfolio you will see that my skills are a good fit. Do You need a freelancer who can fulfill all of your requirements? IF SO, push the button "Hire me!" - I think it will be the beginning of a good partnership!!
Hi, I developed a POS system by myself, so I am sure what I need to gie you a clean resilust to your requirements.
Please read my profile and comments from my clients as a reference
Let us chat for details.
Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. I'll build Ms Access DB based on your scenarios..Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
I have advanced knowledge in the use of databases and Excel spreadsheets. I would use Visual Basic to create this for you. It will give you all the functionality that you need to make this application work. I look forward to the opportunity of working with you on this project. Thank you in advance for your consideration.
I can write software in VB.NET using your excel file as database. I can start working your project write now. Please contact me for further discussion.