Skip to main content

Sales and Inventory System using VB.NET and SQL Server with Source Code

It's a simple Sales and Inventory System developed using vb.net + SQL Server. This was developed according to the requirements of company Kapco Foods Pvt. Ltd. The system has the ability to store products, product categories, and many more. The system also stores the company purchase order details. The Sales and Inventory System generates reports for all lists such as the orders, sales, and etc.

Main Features are:

  • Customers(Super Distributors) and vendors Profile
  • Orders Processing
  • Inventory Management
  • Invoice Generation
  • Records Searching
  • Reports

How to use

To start using the Sales and Inventory System, the user must log in to the system using their system credential first to access the main form and use the system functionalities (default admin credential is provided below). After logging in, the system user must populate the list of distributors, vendors, product category and products. Then, the user will create a new stock for the products created. After that, the system user can use the other features of the system such as the ordering feature, sales/invoice, and generate a report.

How to Run

Requirements

  • Visual Studio 2010 or Visual Studio 2012, SQL Server 2008 or above, and Crystal Report for VS 2010 must be installed on your system to run this Project Successfully

Setup

  1. Download and Extract the source code zip file. (download button is located below)
  2. Open the extracted folder and locate the "Sales and Inventory.sln" file.
  3. Open the solution file (.sln) with your Microsoft Visual Studio software.
  4. Press the "F5" key on your keyboard to run.

Login Information

Username: admin
Password: 12345

Database setup

  1. Locate the "SI_DN.mdf" file inside ".\Sales and Inventory System\bin\Debug".
  2. Right-click on server explorer and add connection and select data source.
  3. Select Microsoft SQL Server Database File (SqlClient) then browse the database ("SI_DB.mdf") file.

For the Excel worksheet, you have to add references in the project known as "Microsoft.office.interop.excel" if it does not exist in the project.

That's it, you can now explore the features and functionalities of the Sales and Inventory System using VB.NET and SQL Server. If you like this project please share. And for any questions or reactions, feel free to leave a comment below.

For students or anyone else who needs program or source code for thesis writing or any Professional Software Development, Website Development, Mobile Apps Development at an affordable cost.
You can me at ff:
Email: [email protected]
FB: https://www.facebook.com/Rajcoolguy99
skype: [email protected]
what's App: +919827858191
Contact Number: +919827858191, +

note: Source Code is only available for educational purpose, plz don't use it for commercial purpose without the permission of the original author

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

Submitted byianzworld (not verified)on Wed, 07/31/2013 - 22:34

Error The website encountered an unexpected error. Please try again later.
Submitted byMamakas (not verified)on Wed, 07/31/2013 - 23:58

I can download the code. Please reupload.
Submitted bysourabhkr (not verified)on Thu, 08/01/2013 - 21:03

Where is database file and how to connect the database.. plzz help me

Database Location : .....\Sales and Inventory System\Sales and Inventory System\bin\Debug and attach the database using server explorer right click on server explorer and add connection and select data source Microsoft SQL Server Database File (SqlClient) then browse the database file from .....\Sales and Inventory System\Sales and Inventory System\bin\Debug hope it helps u :)
Submitted byauhvrey (not verified)on Mon, 09/30/2013 - 22:54

hi i got 102 errors, and i dont know where i can download crystal report
Submitted bynetsykeron Thu, 11/28/2013 - 20:01

Hello, I get the error CrystalReportViewer is not defined. What is the reason?
Submitted byrisab1on Tue, 12/24/2013 - 18:18

nice supobb great i like it .... what a great performance >>>

i can download it, but it file to open in vb, so how? need u help, thanks...
Submitted byPhan (not verified)on Mon, 01/06/2014 - 07:08

I got "An error occurred creating the form. See Exception.InnerException for details. The error is: The type initializer for 'CrystalDecisions.Shared.SharedUtils' threw an exception." When open reports. The error point to frmOrdersReport.cmbCustomerName.Text = "" Please help.
Submitted byMARVIN MENDOZA (not verified)on Thu, 02/13/2014 - 18:35

If you don't mind if you can give a little sample to sales inventory system i hope for your consideration
Submitted byLeander (not verified)on Fri, 03/07/2014 - 15:32

I got this error Error 6 Could not resolve COM reference "6ae44ff1-eccf-4a72-96ce-95bcd1ea2097" version 13.0. The type library importer encountered an error during type verification. Try importing without class members. Sales and Inventory System im running on 64 bit and all reference is added(crystal report and excel) can you help me? Thanks
Submitted byAnonymous (not verified)on Wed, 03/12/2014 - 02:24

Error 11 Could not resolve COM reference "6ae44ff1-eccf-4a72-96ce-95bcd1ea2097" version 13.0. The type library importer encountered an error during type verification. Try importing without class members. Is there a solution to this?
Submitted byaddy (not verified)on Sat, 12/06/2014 - 03:15

its good but how can i edit it
Submitted byAnandavinayagam (not verified)on Fri, 01/23/2015 - 19:22

Please send me the source code link and do you have project for pharmacy app
Submitted byatef khalf (not verified)on Thu, 01/28/2021 - 15:56

i want to open database on sql server 2008 thanks

Add new comment