Find Jobs
Hire Freelancers

Create a Purchase order form

$30-250 USD

Completed
Posted almost 7 years ago

$30-250 USD

Paid on delivery
I need an order form built for my clients. I need the form to allow the client to select quantity of set items with fixed costs. The form must populate total cost based off of fixed product cost and the variable quantity. I want all items to be fixed so that the client may not change the item or the cost of the item. I want to be able to create an order form for each of my clients as I want the clients information to be locked on their form. Client information is the client name, price level, address, client identifying number, payment terms and the sales rep associated with the account. I would like the form to allow for checkboxes that the client can select for payment option (ach, credit card) and delivery option (fedex instate $30, FedEx out of State $50 and Local delivery Free) I would like the selection of fedex to add to the final total. Attached is a basic sheet I put together that has the products, pictures and formula to calculate total cost. I have 4 different price levels. 1 is for the majority of my clients. The other 3 are for 3 individual clients. I need to create form for around 180 clients total.
Project ID: 13871509

About the project

42 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello. I can do this for you in PDF if this is preferred, or even as a web-based form that then sends a PDF attachment with the results upon submission. Please PM me to discuss further (if desired) before awarding the project. Thanks in advance!
$230 USD in 25 days
5.0 (4 reviews)
3.6
3.6
42 freelancers are bidding on average $140 USD for this job
User Avatar
Hello Sir, My name is Jay and I am #1 Excel VBA programming expert on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story). About Me - I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I always take project to completion. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a sample work before you consider awarding me the project. Thanks, Jay
$250 USD in 3 days
5.0 (847 reviews)
9.1
9.1
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$200 USD in 3 days
4.9 (493 reviews)
8.4
8.4
User Avatar
Experienced FREELANCER HERE to work for your project. Let's discuss more and finalize the project and cost. Feel free to ask me questions, if any. I look forward to work with you. Have a good day and stay fine :-) Sincere regards, Jubair
$200 USD in 5 days
4.9 (327 reviews)
7.8
7.8
User Avatar
Hello Sir Im excel VBA macro and formula Expert :) i can make form as your sample attacment Sir via VBA mcro :) please give me a chance for doing your project and im able to start working right now Thank You Sincerely Prameswara
$100 USD in 3 days
4.9 (427 reviews)
7.6
7.6
User Avatar
Hi there! I’m an expert on any data entry jobs and I’ve lot of experience on this type projects.. I’m ready to start it right away. I look forward to hearing from you. Regards
$250 USD in 5 days
4.8 (304 reviews)
7.4
7.4
User Avatar
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me for further details. Thanks and regards Roy
$150 USD in 3 days
4.9 (495 reviews)
7.4
7.4
User Avatar
Hi, I already created a similar order_form. So I can suggest you a secured application in Microsoft Excel to manage this process as follows: databases: a client list, a product catalog (with pictures), a set of price lists, a primary database with the orders and it's status (delivered, invoiced, paid, etc.). Excel sends a customized catalog or/and a customized order_form to each customer (can be by email in Microsoft Outlook). Excel adds new order_from's from customers to the primary database. Excel is updated with the status of the orders (open orders, delivery status payments) manually (in user form) or from another system (like SAP or QB). Excel issues status reports regarding the orders (total sales, open order, engine report etc.
$250 USD in 3 days
4.9 (93 reviews)
7.5
7.5
User Avatar
Hi, ​​I'm interested in your project. Please send me a message so that we can discuss more. I have lot's of experience any Data Entry & Scraping jobs. I've a great researching skills to find personal/business contact info and also an expert on all of product uploading jobs. I look forward to hearing from you soon. Regards
$200 USD in 3 days
4.9 (163 reviews)
6.9
6.9
User Avatar
Dear employer, I have read your project brief and reviewed your attached Excel file. I have guaranteed my bid (Expert Guarantee) as i have experience of creating similar type of project before. Kindly let me know the followings: 1. Total how many pages you are expecting the PDF document to print? 2. Do you have all 180 Client data ready? 3. When you need the job done? Cordially requesting you to view my portfolio, profile reviews and contact me in pvt message for further discussion about this project. Thank you in advance.
$240 USD in 3 days
5.0 (105 reviews)
6.2
6.2
User Avatar
- Went through the PO form and the various Part# and its prices. - Can build the form such that the user selects only the quantities required and select the mode of Delivery (FedEx, BlueDart....) based on which the totals for the client can be calculated including the Delivery Charges and probably add any Sales Tax component to it. - The template can be built as 3 different one, so that one could be used by majority of the clients, and the remaining two for specific clients you may want. - Clients will not be able to alter the price of the products but only change the qty required. - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Pl. review my portfolio on recent projects. Sample HighComplex Projects using Macros:(via Freelancer) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations. - System log generation (users logged in time, duration, days) between time period based on the text log files. Generate report. - Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables. - Stocks Portfolio - Showing client portfolio stocks with various indicators
$100 USD in 4 days
4.7 (49 reviews)
6.1
6.1
User Avatar
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA. I also have expertise in Manipulating Data of Multiple Sheets, Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I will use drop down to select item name and price will be auto selected. So, user need to less typing. Total price will be calculated according to qty and price. So, I can do this job nicely. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio Ready to start please reply soon. Thanks, Virendra
$120 USD in 3 days
4.8 (111 reviews)
5.8
5.8
User Avatar
Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards
$133 USD in 3 days
4.6 (100 reviews)
6.2
6.2
User Avatar
Hello, i can do this. I am an expert in making fillable forms. just check my reviews and rating. ping me if you are interested in me. thank you.
$170 USD in 3 days
5.0 (60 reviews)
5.3
5.3
User Avatar
Hi I hope all's well with you. I see you'r looking for a developer proficient in Excel/VB. I’m a ms Access/Excel/VB programmer, a mathematician and a full time 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. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$155 USD in 3 days
4.8 (27 reviews)
5.6
5.6
User Avatar
I have the expertise in Excel VBA and can do this task, as per requirements, quickly and accurately. Ready to start work immediately.
$100 USD in 2 days
4.6 (66 reviews)
5.4
5.4
User Avatar
Hi My name is Dan. I am an expert in excel and all advanced functionalities. I have created several order forms with great visual appeal and user-friendliness. I can create one for you with the ability to automatically pull a variable price base on client. Also delivery charges can be added with a checkbox selection as desired. Your clients will not be able to alter any of the fields except inputting quantity. Please message me and we can discuss and proceed further. Thanks, Regards, Dan
$100 USD in 3 days
4.9 (10 reviews)
4.3
4.3
User Avatar
Dear Sir I am an excel professional having hands on expertise in developing purchase order forms I will do your project as per your requirements by applying advanced excel formulas with VBA so It would be easy to just select what you want. Best regards humayoon
$175 USD in 3 days
4.7 (12 reviews)
4.1
4.1
User Avatar
Hi, This is a very interesting project. Though it can be best done in MS Access but you since you said your clients need to fill the information so MS Excel will be best for this project. I can start working on the project right away and deliver it on time. Thanks and best regards, John
$100 USD in 3 days
5.0 (19 reviews)
3.9
3.9
User Avatar
Lets start with design elegency. We are ready for the project. Please visit our portfolio https://www.freelancer.pk/hireme/dezinerinsectDezinerinsect Dezinerinsect is an innovative studio specialize in logo, brochure, flyer, illustrations, poster, business card, stationary design, corporate identity, icon design, website design and development. We will work one o one with you to create unique product will allow your business flourish and establishing in 6 sigma companies 100% unique design concept. We will offer you unlimited revisions until you approve the design. Provide 2 – 3 initial design option Work until client gets satisfied. Offer 60 days free to charge design services Get high quality source files of the selected design ( fully editable file ) Money back guarantee.
$50 USD in 0 day
4.5 (4 reviews)
2.9
2.9
User Avatar
I did a purchase order form using excel before. I can make you change the client name and send the form to him and let him change item and quantity then all cost will change as a result. Hope to discuss other criteria with you.
$167 USD in 1 day
5.0 (2 reviews)
2.0
2.0

About the client

Flag of UNITED STATES
Denver, United States
5.0
3
Payment method verified
Member since Apr 14, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.