(9 intermediate revisions by the same user not shown) | |||
Line 13: | Line 13: | ||
*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 | - 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 | - 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 48: | Line 48: | ||
|- | |- | ||
| Price set in SQL are || | | Price set in SQL are || | ||
* Tax Inclusive - | * Tax Inclusive - System will Reverse the Price to exclude Tax Amount | ||
* Tax Exclusive - | * Tax Exclusive - System will direct get the Price | ||
|- | |- | ||
| When Ask Price || | | When Ask Price || | ||
* Tax Inclusive - | * Tax Inclusive - System will Reverse the entered Price to exclude Tax Amount | ||
* Tax Exclusive - | * Tax Exclusive - System will direct use the Price entered | ||
* Follow Record - | * Follow Record - System will follow last Selected Setting | ||
|- | |- | ||
| Tax Rate || The Tax Rate | | Tax Rate || The Tax Rate | ||
Line 85: | Line 84: | ||
|- | |- | ||
| Use Of Line Mode || | | Use Of Line Mode || | ||
* Yes - To Enable | * Yes - To Enable Off Line Mode Function | ||
* No - To Disable | * No - To Disable Off Line Mode Function | ||
|- | |- | ||
| Prepare Now || Adhoc update Data | | Prepare Now || Adhoc update Data | ||
Line 163: | Line 162: | ||
|- | |- | ||
| Export Cash Sales || | | Export Cash Sales || | ||
* Yes - | * Yes - Allow Export Cash Sales Data (Default) | ||
* No - | * No - Not Allow Export Cash Sales Data | ||
|- | |- | ||
| Import Cash Sales || | | Import Cash Sales || | ||
* Yes - | * Yes - Allow Import Cash Sales Data (Default) | ||
* No - | * No - Not Allow Import Cash Sales Data | ||
|- | |- | ||
| Email while Close counter || | | Email while Close counter || | ||
* Yes - ??? | * Yes - ??? | ||
* No - | * No - (Default) | ||
|} | |} | ||
Line 183: | Line 182: | ||
! Field !! Description | ! Field !! Description | ||
|- | |- | ||
| Transc. Date || Post Base On Transactions Date | | Transc. Date || Post Base On Transactions Date (Default) | ||
|- | |- | ||
| Open Counter Date || | | Open Counter Date || | ||
Line 247: | Line 246: | ||
| Show All 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> | <div style="float: right;"> [[#top|[top]]]</div> |
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 |
|
Date | Enter the Start Date for GST/SST |
Price set in SQL are |
|
When Ask Price |
|
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 |
|
Prepare Now | Adhoc update Data |
Stock Item
Field | Description |
---|---|
Fixed Value On |
|
Mark Up | ??? |
Round Decimal | ??? |
Category as |
|
Add On Module
Field | Description |
---|---|
Advance Commission Module base on |
|
Serial Number |
|
Price Checker Module |
|
Sales Order Module |
|
iT-Sync Module |
|
Multiple Currency Module |
|
Batch No. Module |
|
Import Export
Field | Description |
---|---|
Export Cash Sales |
|
Import Cash Sales |
|
Email while Close counter |
|
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 |
|
Close Counter 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
Field | Description |
---|---|
Use Unicode |
|
System Code Page | ??? |
Show All Code Page | ??? |
System - Receipt & License
- This Page is to
- Register the SQL Pos
- Design the Receipt