Closed

Simple order form system VB

Want a simple order form program which can handle the following tasks:

Develop in Visual Basic

Order Form Frontend:

- Fill in creation date automatically

- Create unique order form reference number automatically (print with bar code to be read by backend)

- Input customer name and contact number by sales

- Input product code by sales person or barcode reader

- Read product description, price, from existing POS system (SQL Server MDF database, read only, no update required).

- Allow manual entry if product detail is not available in the database

- Remarks field for each product to allow manual input for size, color or other options

- Price read from database on form but can be changed by sales person if needed

- Form can handle 1-10 products

- Print order form to customer with all entries, 80mm POS printer format, ignore blank products

- Create a flag (for order form) to indicate the order form is being processed, canceled or completed

- Create a flag (for each product in each order form) to indicate the product is processed, canceled, out of stock, completed

- Save the order form data to database in remote location

- Frontend software can read all save order forms, can be filtered by the order form flag status or date. (Hide from frontend if flag set to Hide)

- Re-print of desired order form

- Default view is new order form creation

Backend:

- Show summary, can switch between following, or read the order form by barcode

-- Show all order forms summary, can be filtered by the order form flag or date

-- Show all products summary, can be filtered by the product flag or date (e.g. show all products not ordering by default)

-- Can read the product unique reference ad change the product flag as completed, order form change to completed if all product entries within the order form are completed, canceled or out of stock.

- Read desired order forms with corresponding products

- Print each product with unique reference with bar code, date, order no, customer name, contact number and entry number (e.g. 3 of 9, if it is the 3rd product in current order with 9 products) individually (i.e. if the order form with 10 entries, 10 forms will be printed), 80mm POS printer format.

- Option to print all products grouped by product code, with desired date range, order status, etc.

- All products flag set to processed, order from flag to processed after printed

- Order from flag can set to processed, canceled, completed, hide

- Re-print of desired order form

- Delete desired order form

All print out forms must be customizable

Only small amount of forms will be created everyday (less than 100), so just keep it as simple as possible.

Source code required upon finish of the project.

THANK YOU!

Skills: Database Programming, Microsoft SQL Server, Visual Basic

See more: php simple form order, access form vb sorting order, form validation textarea field example, software development, sql, software architecture, visual basic, vb.net, database programming, simple field validation php, form mysql simple, form order system joomla, form textarea empty field, contact form cms simple, using contact form hack simple easy website, html form capture entries field php, pdf form calculate last field, adobe form calculate date field, php form database simple, javascript web form order

About the Employer:
( 3 reviews ) 28 Kwai Fung Crescent, Hong Kong

Project ID: #13892763

38 freelancers are bidding on average $380 for this job

schoudhary1553

Do you have any questions about the job description? not yet Proposal: 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. W More

$250 USD in 3 days
(81 Reviews)
6.7
esalem

Do you have any questions about the job description? Can you send the database that contains the products data to check it ? Proposal: Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer More

$1621 USD in 15 days
(12 Reviews)
6.4
mpalgeo

Hello, my proposal is this. I will use MSSQL Server Express Edition which is free for the database and VB.NET for the application. Reports will be done with SSRS, a MSSQL feature. The application will by multiuser. More

$1000 USD in 30 days
(55 Reviews)
5.9
fanninson45

Do you have any questions about the job description? Yes Proposal: SHOWCASE An experienced Microsoft Certified Professional with Database Programming and Administration skills across both MS SQL and Business Intellig More

$155 USD in 3 days
(15 Reviews)
5.5
SPARKtechBD

Do you have any questions about the job description? No question Proposal: C, C++, VB3, VB4, VB5, VB6, VB, VB.NET 2015, ASP.NET, MVC, WPF, XML, MSSQL 2014, HTML & CSS3, AWS(Amazon Web Service) programmer. I have e More

$750 USD in 60 days
(10 Reviews)
5.1
carlosperezit

Do you have any questions about the job description? No Proposal: Hi I'm an expert in .Net technologies and SQL Server. I have been working in software development for the last 20 years I'm a specialist in web so More

$155 USD in 5 days
(21 Reviews)
5.0
vw7209238vw

Do you have any questions about the job description? What kind of connection to database are you using? is it possible to use ODBC? Other way? Proposal: Hi, I know what you are asking about because I developed a P More

$150 USD in 7 days
(27 Reviews)
5.0
lavizsolutions

Do you have any questions about the job description? Can we make web based application Proposal: Hi, Kindly share me more details so that i can give you estimated time and cost. Please check my below work.. More

$1555 USD in 45 days
(2 Reviews)
5.0
$250 USD in 7 days
(21 Reviews)
5.4
point5nyble

Do you have any questions about the job description? No Proposal: Hello, I have been working with a MNC based company since last ~ 6 years, as an IT BI DWH Professional. The project is a BI DWH project which cover More

$250 USD in 3 days
(25 Reviews)
4.7
vsprybhanu

Do you have any questions about the job description? You have described your project in much details. So, I have not nay question right now but of course I will have many questions while programming. Proposal: Hi, More

$600 USD in 20 days
(38 Reviews)
5.0
$155 USD in 3 days
(24 Reviews)
5.1
sherifamgadnabih

Do you have any questions about the job description? no i dont have thank you Proposal: i am a lead .NET software engineer and responsible for creating a web and desktop applications using different languages and tec More

$200 USD in 3 days
(16 Reviews)
4.0
axiomswb

we have expertise in vb,sql,dba,data [login to view URL] satisfaction is our main motto for long term relationship

$175 USD in 5 days
(10 Reviews)
3.5
$200 USD in 7 days
(5 Reviews)
3.5
$125 USD in 10 days
(9 Reviews)
2.9
idicesolutions01

Hi, I have few queries in Backend process (summary & printing). Please let me know your convenient time to chat/Skype call. Please visit below URL which includes few of screen shots from our previous POS developm More

$390 USD in 10 days
(1 Review)
2.4
$250 USD in 5 days
(2 Reviews)
2.3
ieota

Do you have any questions about the job description? Yes, Could we discuss in PMB? Proposal: We @ IEOTA TECHNOLOGIES have lot of exposure and experience in development for past 4 years served for several clients acros More

$616 USD in 16 days
(1 Review)
2.6
pamrulla

A proposal has not yet been provided

$166 USD in 7 days
(1 Review)
1.3