728x90 AdSpace

Latest Article

Point of Sale System in database Project using C#.NET and SQL Server





Point of Sale System in database DB project using C#.NET and SQL Server with detail database design description article and ERD digram.

Point of Sale System that could be used for any sales system like a Provision Store, Pharmaceuticals, Departmental Store, Mobile Phones Outlet, Computers Sale etc.

Develop a Point of Sale System which could manage the stock and Inventory from Small Scale to Large Scale business in any Business Domain.



Source Code Download Click here


Project scope includes the following milestones:

1)                  Stock and Inventory Management
a.       Purchase
b.      Sale
c.       Returns
d.      Invoices
                                                                                      i.      Purchase Invoice
                                                                                    ii.      Sale Invoice
                                                                                  iii.      Return Invoice
e.       Reports
                                                                                      i.      Stock Reports
                                                                                    ii.      Daily Sale Report
                                                                                  iii.      Monthly Sale Report
2)                  Accounts
a.       Trial Balance
b.      Balance Sheet
3)                  Barcode Enabled Product Codes

System Module

Following will be the modules of the System:
1    Item Detail Module
2    Purchase Module
3    Sale Module
4    Reporting Module
5    Accounts Module

1    Item Detail Module
The Item Detail Module will encode a new item of the business. It deals with the information as the item name, description and units of the item.

2    Purchase Module
Purchase Module will deal with the purchase of the items from a supplier, it will outline the details of the items purchased like the item name, quantity, cost per unit and discounts if any.

Purchase module will have sub parts, one will be Purchase and the other will be Purchase Return.

3    Sale Module
Sale Module will deal with the Sale of the items to customers. It will deal with the information of the items sold as the item name, packing, cost per unit and discounts if any.

4    Reporting Module
Reporting module will provide the different reports like the Itemized Stock Report, Item Specific Stock Report, and Sale Report.

5    Accounts Module
Accounts module will deal with the recording of Journal and General Ledger against the business transactions.

The reporting part of the Accounts Module will deal with the Trial Balance and Balance Sheet reports.

Users/Roles of the System

Following will be the users of the System:
1)                  Sales Person – a direct user of the system with expert level and a frequent use.

2)                  Business Owner – a direct user of the system with Novice/Intermediate/Expert level and a seldom/frequent use.

3)                  Customer – an indirect user of the system, concerned only with the invoice. Customer will be categorized as a frequent indirect user.

4)                  Administrator – a direct user of the system with expert level, concerned with the installation, maintenance and smooth running of the System.

Forms, Queries and Reports

Forms:
1)         Purchase Invoice Form
2)         Sale Invoice Form
3)         Purchase Return Form
4)         Sale Return Form
5)         Item Details Form
6)         Supplier Details Form
7)         General Journal Form
8)         Account Opening Form
Queries & Reports:
1)         Stock Report
2)         Purchase Report
3)         Sale Report
4)         Item Wise Sale Report
5)         Item Wise Purchase Report
6)         Profit Report
7)         Trial Balance
8)         Balance Sheet

Entity Relationship Digram 



Table Description

Item
Table Name:  Item
Primary Key: Code
Purpose:         Store New Items
Column Name
Data Type and Domain
Null Constraint
Key Constraint
Application based Constraint
Code
Char(5)
Not Null
Primary Key

Item Name
varchar (30)
Not Null


2.6.2 Item Details
Table Name:  Item Details
Primary Key: Code
Purpose:         Store New Items Details, like packing and units
Column Name
Data Type and Domain
Null Constraint
Key Constraint
Application based Constraint
Code
Char(5)
Not Null
Primary Key

Packing
Char(15)
Not Null


Units
Int(4)
Not Null



Invoice Master
Table Name:  Invoice Master
Primary Key: Invoice Number
Purpose:         Store Invoice attributes which are common in all invoices
Column Name
Data Type and Domain
Null Constraint
Key Constraint
Application based Constraint
InvoiceNo
Int(4)
Not Null
Primary Key

InvoiceDate
Date
Not Null


SupplierID
Char(5)
Not Null
Foreign Key

TotalCost
Decimal
Not Null


TotalDiscount
Decimal
Not Null


TotalPrice
Decimal
Not Null


2.6.4 Invoice Detail
Table Name:  Invoice Detail
Primary Key: Invoice Number
Purpose:         Store Invoice attributes which are specific to the Invoice
Column Name
Data Type and Domain
Null Constraint
Key Constraint
Application based Constraint
InvoiceNo
Int(4)
Not Null
ForeignKey

InvoiceType
Int(4)
Not Null


ItemNo
Char(5)
Not Null
Foreign Key

Packing
Char(15)
Not Null


Units
Int(4)
Not Null


UnitPrice
Decimal
Not Null


Discount
Int(4)
Not Null

Discount will be in Percentage, defaults to zero
TotalCost
Decimal
Not Null


Customer
Table Name:  Customer
Primary Key: CustomerID
Purpose:         Stores information about customer
Column Name
Data Type and Domain
Null Constraint
Key Constraint
Application based Constraint
CustomerID
Char((12)
Not Null
Primary Key

FirstName
Char(10)
Not Null


LastName
Char(10)
Not Null


Address
Char(50)
Not Null


Phone
Char(15)
Not Null


Email
Char(20)
Not Null

Must be valid email address
2.6.6 User
Table Name:  User
Primary Key: User ID
Purpose:         Store user information who will use the software
Column Name
Data Type and Domain
Null Constraint
Key Constraint
Application based Constraint
UserID
Int(4)
Not Null
Primary Key

Nick
Char(10)
Not Null
Secondary Key
Must be a unique name for all users
Password
Char(10)
Not Null


Name
Char(30)
Not Null


Access
Char(50)
Not Null

Access of forms to users
Journal
Table Name:  Journal
Primary Key: Journal ID
Purpose:                     Record daily accounting transactions
Column Name
Data Type and Domain
Null Constraint
Key Constraint
Application based Constraint
JournalID
Int(4)
Not Null
Primary Key

Description
Varchar(50)



Date
DateTime
Not Null


Debit
Decimal


If Debit is null, credit will not be null
Credit
Decimal


If Credit is null, debit will not be null
Balance
Decimal


Debit and Credit Balance should be equal
Cash Payment Voucher
Table Name:  CachPayment
Primary Key: VoucherID
Purpose:                     Record cash payment made by company
Column Name
Data Type and Domain
Null Constraint
Key Constraint
Application based Constraint
VoucherID
Int(4)
Not Null
Primary Key

Description
Varchar(50)



Date
DateTime
Not Null


Amount
Decimal



Party
Char(5)

Foreign Key


Cash Receive Voucher
Table Name:  CachReceive
Primary Key: VoucherID
Purpose:                     Record cash payment received by company
Column Name
Data Type and Domain
Null Constraint
Key Constraint
Application based Constraint
VoucherID
Int(4)
Not Null
Primary Key

Description
Varchar(50)



Date
DateTime
Not Null


Amount
Decimal



Party
Cahr(5)

ForeignKey



Source Code Download Click here
Point of Sale System in database Project using C#.NET and SQL Server
  • Title : Point of Sale System in database Project using C#.NET and SQL Server
  • Posted by :
  • Date : 10:34
  • Labels :





  • Blogger Comments
  • Facebook Comments

1 comments:

  1. its not running ...
    1 its giving an error of UNC share although my services and configurations are done accordingly.
    2 all the forms you mentioned are not present there.

    ReplyDelete

Top