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

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]