No edit summary |
|||
(34 intermediate revisions by the same user not shown) | |||
Line 9: | Line 9: | ||
<br> | <br> | ||
<br> | <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 | ||
- Microsoft Windows | - [https://wiki.sql.com.my/wiki/Account4 SQL Accounting] | ||
- 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. | ||
*for Server PC | *for Server PC | ||
- Microsoft Windows | - [[Firebird]]. | ||
- [https://wiki.sql.com.my/wiki/Account4 SQL Accounting] | |||
- 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 28: | Line 31: | ||
- 100 Base-T NIC. | - 100 Base-T NIC. | ||
* | ==System== | ||
===System - System=== | |||
[[File:SQLPos-System-System.jpg|800px|center]] | |||
====GST==== | |||
{| class="wikitable" style="margin: 1em auto 1em auto;" | |||
|- | |||
! 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 | |||
|} | |||
<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
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