SQL Pos

From eStream Software
Revision as of 00:45, 27 December 2022 by Twfaung (talk | contribs) (→‎System Requirements)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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