Tutusfunny

this tutorial we will discuss about how to make the point of sales system step by step.

Main Function of the System

1. We sell Products / Services —– > Customer / Client
2. We Purchase Products —- > Supplier / Vendor
3. Sales Return — Customer Return the product
4. Purchase Return                    — Return Product to Supplier
5. Stock Maintain
6. Users Maintenance
7. Ledger
8. Dashboard

Process

• Sales Process –   Customer / Qty / Product Details / Price / Price Level /

Date of Sales / Loyalty Points / Discounts

• Purchase Process
• Inventory / Stock Maintenance — Product Details / Pricing / Stock / Supplier / Brand / Category
• Reports – Daily / Weekly / Monthly / Yearly
  • Sales
  • Purchase
  • Sales Return
  • Purchase Return
  • Stock Movement
  • Cash Book
  • Supplier Reports
  • Customer Reports

 

Inventory (Stock) – Product Based Business

1. Stock
   1. Product Details Table
      1. Product ID (String) – Manual / Auto Generate (Random / Serial)
      2. Product Name / Description (String)

• Product Category ID – Dropdown Box – Category Table

1. Product Brand ID – Dropdown Box – Brand Table
2. Product Barcode – Auto Generate / Manual Enter
3. Product Price (Decimal) – Sales Price / MRP

• Product Cost (Decimal)
• Product Discount (Decimal) – Fixed Amount / Percentage

1. Expiry Status – Y / N
2. Expiry Item Movement – Expiry Date
3. Valuation Method (Cost) – FIFO / LIFO / Average – Choose

• Active Status – Active / Inactive (Bool)

 

Category Table

1. Product Category ID
2. Product Category Name

 

Brand Table

1. Product Brand ID
2. Product Brand Name

 

Expiry Details

1. Expiry ID (Primary Key)
2. Product Id

• Batch No / Lot No

1. Manufacture Date
2. Expiry Date

 

Stock Movement Table

(Sales / Purchase Return – Stock Out, Purchase / Sales Return – Stock In)

1. Stock Movement Id – Auto Generate / Primary
2. Stock Movement Date

• Product Id

1. Stock-In Qty
2. Stock-Out Qty
3. Detail

 

Note:

Stock Out:

1. Sales – Sales Date, Product Id, Stock Out (Sales Qty), Sales (Details)
2. Purchase Return – Purchase Return Date, Product ID, Stock Out (Purchase Return Qty), Purchase Return

Stock In

1. Purchase – Purchase Date, Product Id, Stock In(Purchase Qty), Purchase
2. Sales Return – Sales Return Date, Product Id, Stock In(Sales Return Qty), Sales Return
3. Purchase
   1. Supplier Table
      1. Supplier ID (Primary)
      2. Supplier Name

• Address

1. City
2. Contact Person
3. Contact No

• Credit Limit
• Account No – Chart of Account – Account Payable

 

1. Purchase Table
   1. Purchase ID (Primary) – Generate
   2. Purchase Date

• Supplier ID

1. Supplier Bill No
2. Purchase Amount

 

1. Purchase Detail Table
   1. Purchase ID
   2. Product Id

• Product Cost

1. Product Price
2. Product Discount
3. Purchase Qty

 

1. Purchase Return Table
   1. Purchase Return ID (Primary) – Generate
   2. Purchase Return Date

• Supplier ID

1. Supplier Bill No
2. Purchase Return Amount

 

1. Purchase Return Detail Table
   1. Purchase Return ID
   2. Product Id

• Product Cost

1. Product Discount
2. Purchase Return Qty

 

3. Sales
   1. Customer Table
      1. Customer ID (Primary)
      2. Customer Name

• Address

1. City
2. Contact Person
3. Contact No

• Credit Limit
• Account No – Chart of Account – Account Receivable

 

1. Sales Table
   1. Sales ID (Primary) – Generate
   2. Sales Date / Bill Date

• Customer ID

1. Bill No – Auto Generate
2. Bill Amount

 

1. Sales Detail Table
   1. Sales ID
   2. Product Id

• Product Sales Price

1. Product Discount
2. Purchase Qty

 

1. Sales Return Table
   1. Sales Return ID (Primary) – Generate
   2. Sales Return Date

• Customer ID

1. Bill No – Sales Bill
2. Sales Return Amount

 

1. Sales Return Detail Table
   1. Sales Return ID
   2. Product Id

• Sales Price

1. Product Discount
2. Sales Return Qty

 

1. Payment Transaction Table
   1. Date
   2. Bill No

• Payment Type – Cash / Cheque / Credit Card / Voucher / Loyalty Points

1. Payment Amount

 

Payment Transaction Table

Date                 Bill No   Payment Type                   Payment Amount

10-12-2020      1                Cash                                      500.00

10-12-2020      1               Card                                   1,500.00

4. Loyalty Table
   1. Customer ID
   2. Card Expiry Date
   3. Card Type
   4. Points Calculation Amount – 100
   5. Points Amount – 1
   6. Total Points – 150

 

5. Loyalty Transaction Table – Add Points / Deduct Points
   1. Transaction Id
   2. Date of Transaction
   3. Points Earned / Point Deducted

 

Points Earned = Sales Amount / Points Calculation Amount

Points Redeemed = Redeemed Points * Points Amount

 

6. Accounting Tables
   1. Ledger Table – Transaction Table – Double Entry
      1. Account No 11001 – Cash In Hand                   51001 Sales A/C
      2. Details of Transaction Sales                                                 Sales

• Debit Amount 5000.00                                                      0 .00

1. Credit Amount                               0.00                                           5,000.00

 

1. Chart of Account
   1. Accounts Group Id 1
   2. Parent Account No 11000 – Current Asset

• Account No 11001

1. Name of Account Cash In Hand

 

1. Accounts Group (Fixed)
   1. Group Id 1
   2. Group Name Assets

• Starting Account No 10000

1. Ending Account No 19999

 

Assets + Liabilities = Equity

 

 

1^st – 2021-01-31 – 10  – 200/=   –  2000/=

2^nd – 2020-12-31 – 05 – 220/= –   1100/=

15                    3100/=    – 206.50