Pos: Difference between revisions

From eStream Software
 
(28 intermediate revisions by the same user not shown)
Line 9: Line 9:
<br>
<br>
<br>
<br>
'''System Requirements'''<br>
==System Requirements==
The following requirements are needed in order to run SQL Pos
The following requirements are needed in order to run SQL Pos
*for Standalone or Client (Workstation) PC
*for Standalone or Client (Workstation) PC
   - [https://wiki.sql.com.my/wiki/Account4 SQL Accounting]
   - [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.
   - XGA - minimum of 16 bis colors recommended.
   - Intel i5 and above computer.
   - Intel i5 and above computer.
   - 4 GB of RAM (recommended 8 GB and above).
   - 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.
   - Microsoft Windows Compatible Printer.


Line 23: Line 23:
   - [[Firebird]].
   - [[Firebird]].
   - [https://wiki.sql.com.my/wiki/Account4 SQL Accounting]
   - [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.
   - XGA - minimum of 16 bis colors recommended.
   - Intel i5, i7 and above computer.
   - Intel i5, i7 and above computer.
Line 34: Line 34:
===System - System===
===System - System===
[[File:SQLPos-System-System.jpg|800px|center]]
[[File:SQLPos-System-System.jpg|800px|center]]
====GST====
{| class="wikitable" style="margin: 1em auto 1em auto;"
{| class="wikitable" style="margin: 1em auto 1em auto;"
|- style="background: #CEE0F2"
| GST|||
|-
|-
! Field !! Description
! Field !! Description
Line 45: Line 45:
* Start SST from - When SST is start Charge
* 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>

Latest revision as of 00:45, 27 December 2022

SQL Pos

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

SQLPos-System-System.jpg

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

Decimal Points

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

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

Stock Item

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

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 - ???

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)

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

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 ???

Tools

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

Theme

This function is allow user to change the Application Skin/Theme to suit the user. From form till grid & label
SQLPos-System-Theme.jpg
Field Description
Use Unicode
  • Yes - ???
  • No - ???
System Code Page ???
Show All Code Page ???

System - Receipt & License

This Page is to
  • Register the SQL Pos
  • Design the Receipt
SQLPos-System-ReceiptNLicense.jpg