Pos: Difference between revisions

Latest revision as of 00:45, 27 December 2022

Cash collection, Inventory Management and Business Intelligence - all in one place. Seamless integration make it easy to sell you products and accept multiple payments. Inventory, orders and customer data are automatically updated. SQL Pos covers a wide range of industries - Mini Markets, Book Stores, Hardware Stores, Pharmacies Medical Sore and many more.

System Requirements

The following requirements are needed in order to run SQL Pos

for Standalone or Client (Workstation) PC

  - SQL Accounting
  - Microsoft Windows 10 and above (recommended with 64 bits windows).
  - XGA - minimum of 16 bis colors recommended.
  - Intel i5 and above computer.
  - 4 GB of RAM (recommended 8 GB and above).
  - 10 GB of available hard disk space (recommended use the Solid-State Drive (SSD) Disk).
  - Microsoft Windows Compatible Printer.

for Server PC

  - Firebird.
  - SQL Accounting
  - Microsoft Windows 10 and above (recommended with 64 bits windows).
  - XGA - minimum of 16 bis colors recommended.
  - Intel i5, i7 and above computer.
  - 8 GB of RAM (recommended 12 GB and above).
  - 10 GB of available hard disk space (recommended use the Solid-State Drive (SSD) Disk).
  - Microsoft Windows Compatible Printer.
  - 100 Base-T NIC.

System

System - System

GST

Field	Description
GST Implementation	Start GST from - When GST is start Charge None - No Tax Start SST from - When SST is start Charge
Date	Enter the Start Date for GST/SST
Price set in SQL are	Tax Inclusive - System will Reverse the Price to exclude Tax Amount Tax Exclusive - System will direct get the Price
When Ask Price	Tax Inclusive - System will Reverse the entered Price to exclude Tax Amount Tax Exclusive - System will direct use the Price entered Follow Record - System will follow last Selected Setting
Tax Rate	The Tax Rate

[top]

Decimal Points

Field	Description
Qty	Quantity Field Display format
Cost	Stock Unit Cost Display format
Price	Sales Unit Price Display format

[top]

Off Line Mode

This function is let system know how to Update the Master Data From SQL Accounting

Field	Description
Auto Prepare Off Line Data on every	Set Number of Days to Update
Use Of Line Mode	Yes - To Enable Off Line Mode Function No - To Disable Off Line Mode Function
Prepare Now	Adhoc update Data

[top]

Stock Item

Field	Description
Fixed Value On	Cost - ??? Price - ??? None - ???
Mark Up	???
Round Decimal	???
Category as	Stock Category - ??? Stock Group - ???

[top]

Add On Module

Field	Description
Advance Commission Module base on	Bill - ??? Item - ??? None - ???
Serial Number	Yes - ??? No - ??? None - ???
Price Checker Module	Yes - ??? No - ??? None - ???
Sales Order Module	Yes - ??? No - ??? None - ???
iT-Sync Module	Yes - ??? No - ??? None - ???
Multiple Currency Module	Yes - ??? No - ??? None - ???
Batch No. Module	Yes - ??? No - ??? None - ???

[top]

Import Export

Field	Description
Export Cash Sales	Yes - Allow Export Cash Sales Data (Default) No - Not Allow Export Cash Sales Data
Import Cash Sales	Yes - Allow Import Cash Sales Data (Default) No - Not Allow Import Cash Sales Data
Email while Close counter	Yes - ??? No - (Default)

[top]

Group Type Date

This Option is to determine what date to post to SQL Accounting

Field	Description
Transc. Date	Post Base On Transactions Date (Default)
Open Counter Date	Post Base on Open Counter Date. This useful if Counter is Close on next Date but account to be post on Today
Close Counter Date	Post Base on Open Counter Date. This useful if Counter is Close on next Date and account to be post on next Date

[top]

Free Tools

Field	Description
Import Product list form Excel File	???
Import Customer list form Excel File	???
Import Supplier list form Excel File	???
Global Price Adjustment	???
Delete Zero Quantity Items	???
Fix Firebird Shutdown Database	???

[top]

Tools

Field	Description
Backup Database	Backup the current SQL Pos DB
Restore Database	???
Delete Data/Clean Test Data	???
Unipos Migration	???

[top]

Theme

This function is allow user to change the Application Skin/Theme to suit the user. From form till grid & label

Field	Description
Use Unicode	Yes - ??? No - ???
System Code Page	???
Show All Code Page	???

[top]

System - Receipt & License

This Page is to

Register the SQL Pos
Design the Receipt

[top]

@@ Line 9: / Line 9: @@
 <br>
 <br>
-'''System Requirements'''<br>
+==System Requirements==
 The following requirements are needed in order to run SQL Pos
 *for Standalone or Client (Workstation) PC
     - [https://wiki.sql.com.my/wiki/Account4 SQL Accounting]
-    - Microsoft Windows 7 and above (recommended with 64 bits windows).
+    - Microsoft Windows 10 and above (recommended with 64 bits windows).
     - XGA - minimum of 16 bis colors recommended.
     - Intel i5 and above computer.
     - 4 GB of RAM (recommended 8 GB and above).
-    - 10 GB of available hard disk space.
+    - 10 GB of available hard disk space (recommended use the Solid-State Drive (SSD) Disk).
     - Microsoft Windows Compatible Printer.
@@ Line 23: / Line 23: @@
     - [[Firebird]].
     - [https://wiki.sql.com.my/wiki/Account4 SQL Accounting]
-    - Microsoft Windows 7 and above (recommended with 64 bits windows).
+    - Microsoft Windows 10 and above (recommended with 64 bits windows).
     - XGA - minimum of 16 bis colors recommended.
     - Intel i5, i7 and above computer.
@@ Line 34: / Line 34: @@
 ===System - System===
 [[File:SQLPos-System-System.jpg|800px|center]]
+====GST====
 {| class="wikitable" style="margin: 1em auto 1em auto;"
-|- style="background: #CEE0F2"
-| GST|||
 |-
 ! Field !! Description
@@ Line 45: / Line 45: @@
 * Start SST from - When SST is start Charge
 |-
-|Date || Enter the Start Date for GST/SST
+| Date || Enter the Start Date for GST/SST
+|-
+| Price set in SQL are ||
+* Tax Inclusive - System will Reverse the Price to exclude Tax Amount
+* Tax Exclusive - System will direct get the Price
+|-
+| When Ask Price ||
+* Tax Inclusive - System will Reverse the entered Price to exclude Tax Amount
+* Tax Exclusive - System will direct use the Price entered
+* Follow Record - System will follow last Selected Setting
+|-
+| Tax Rate || The Tax Rate
+|}
+<div style="float: right;">   [[#top|[top]]]</div>
+====Decimal Points====
+{| class="wikitable" style="margin: 1em auto 1em auto;"
+|-
+! Field !! Description
+|-
+| Qty || Quantity Field Display format
+|-
+| Cost || Stock Unit Cost Display format
+|-
+| Price || Sales Unit Price Display format
+|}
+<div style="float: right;">   [[#top|[top]]]</div>
+====Off Line Mode====
+: This function is let system know how to Update the Master Data From SQL Accounting
+{| class="wikitable" style="margin: 1em auto 1em auto;"
+|-
+! Field !! Description
+|-
+| Auto Prepare Off Line Data on every ||  Set Number of Days to Update
+|-
+| Use Of Line Mode ||
+* Yes - To Enable Off Line Mode Function
+* No - To Disable Off Line Mode Function
+|-
+| Prepare Now || Adhoc update Data
+|}
+<div style="float: right;">   [[#top|[top]]]</div>
+====Stock Item====
+{| class="wikitable" style="margin: 1em auto 1em auto;"
+|-
+! Field !! Description
+|-
+| Fixed Value On ||
+* Cost - ???
+* Price - ???
+* None - ???
+|-
+| Mark Up || ???
+|-
+| Round Decimal || ???
+|-
+| Category as ||
+* Stock Category - ???
+* Stock Group - ???
+|}
+<div style="float: right;">   [[#top|[top]]]</div>
+====Add On Module====
+{| class="wikitable" style="margin: 1em auto 1em auto;"
+|-
+! Field !! Description
+|-
+| Advance Commission Module base on ||
+* Bill - ???
+* Item - ???
+* None - ???
+|-
+| Serial Number ||
+* Yes - ???
+* No - ???
+* None - ???
+|-
+| Price Checker Module ||
+* Yes - ???
+* No - ???
+* None - ???
+|-
+| Sales Order Module ||
+* Yes - ???
+* No - ???
+* None - ???
+|-
+| iT-Sync Module ||
+* Yes - ???
+* No - ???
+* None - ???
+|-
+| Multiple Currency Module ||
+* Yes - ???
+* No - ???
+* None - ???
+|-
+| Batch No. Module ||
+* Yes - ???
+* No - ???
+* None - ???
 |}
+<div style="float: right;">   [[#top|[top]]]</div>
+====Import Export====
+{| class="wikitable" style="margin: 1em auto 1em auto;"
+|-
+! Field !! Description
+|-
+| Export Cash Sales ||
+* Yes - Allow Export Cash Sales Data (Default)
+* No - Not Allow Export Cash Sales Data
+|-
+| Import Cash Sales ||
+* Yes - Allow Import Cash Sales Data (Default)
+* No - Not Allow Import Cash Sales Data
+|-
+| Email while Close counter ||
+* Yes - ???
+* No - (Default)
+|}
+<div style="float: right;">   [[#top|[top]]]</div>
+====Group Type Date====
+: This Option is to determine what date to post to SQL Accounting
+{| class="wikitable" style="margin: 1em auto 1em auto;"
+|-
+! Field !! Description
+|-
+| Transc. Date || Post Base On Transactions Date (Default)
+|-
+| Open Counter Date ||
+* Post Base on Open Counter Date.
+* This useful if Counter is Close on next Date but account to be post on Today
+|-
+| Close Counter Date ||
+* Post Base on Open Counter Date.
+* This useful if Counter is Close on next Date and account to be post on next Date
+|}
+<div style="float: right;">   [[#top|[top]]]</div>
+====Free Tools====
+{| class="wikitable" style="margin: 1em auto 1em auto;"
+|-
+! Field !! Description
+|-
+| Import Product list form Excel File || ???
+|-
+| Import Customer list form Excel File || ???
+|-
+| Import Supplier list form Excel File || ???
+|-
+| Global Price Adjustment || ???
+|-
+| Delete Zero Quantity Items || ???
+|-
+| Fix Firebird Shutdown Database || ???
+|}
+<div style="float: right;">   [[#top|[top]]]</div>
+====Tools====
+{| class="wikitable" style="margin: 1em auto 1em auto;"
+|-
+! Field !! Description
+|-
+| Backup Database || Backup the current SQL Pos DB
+|-
+| Restore Database || ???
+|-
+| Delete Data/Clean Test Data || ???
+|-
+| Unipos Migration || ???
+|}
+<div style="float: right;">   [[#top|[top]]]</div>
+====Theme====
+: This function is allow user to change the Application Skin/Theme to suit the user. From form till grid & label
+[[File:SQLPos-System-Theme.jpg|800px|center]]
+{| class="wikitable" style="margin: 1em auto 1em auto;"
+|-
+! Field !! Description
+|-
+| Use Unicode ||
+* Yes - ???
+* No - ???
+|-
+| System Code Page || ???
+|-
+| Show All Code Page || ???
+|}
+<div style="float: right;">   [[#top|[top]]]</div>
+===System - Receipt & License===
+: This Page is to
+* Register the SQL Pos
+* Design the Receipt
+[[File:SQLPos-System-ReceiptNLicense.jpg|800px|center]]
+<div style="float: right;">   [[#top|[top]]]</div>