No edit summary |
No edit summary |
||
(78 intermediate revisions by 3 users not shown) | |||
Line 4: | Line 4: | ||
SQL Business Suite is designed to support applications that deliver business-critical functionality to large deployment of network environment. It is build and optimized for mission-specific application. | SQL Business Suite is designed to support applications that deliver business-critical functionality to large deployment of network environment. It is build and optimized for mission-specific application. | ||
At the core SQL Business Suite lies a robust Client-Server architecture that allows it to deliver significant advantages in flexibility, reliability, performance and stability. Self-tuning features include cost-based query optimization and dynamic re-balancing of reports structures enhance performance and provides a wide range of business reports. | At the core SQL Business Suite lies a robust Client-Server architecture that allows it to deliver significant advantages in flexibility, reliability, performance and stability. Self-tuning features include cost-based query optimization and dynamic re-balancing of reports structures enhance performance and provides a wide range of business reports. | ||
More important, SQL Business Suite is an open period solution that enables you to collect more data over a wider time frame for better decision-base analysis. | More important, SQL Business Suite is an open period solution that enables you to collect more data over a wider time frame for better decision-base analysis. For more information, visit https://www.sql.com.my/ | ||
<br> | <br> | ||
<br> | <br> | ||
<br> | <br> | ||
'''System Requirements'''<br> | '''System Requirements'''<br> | ||
*for Standalone or Client (Workstation) PC | *for Standalone or Client (Workstation) PC | ||
- Microsoft Windows | - Microsoft Windows 10 and above (recommended with 64 bits windows). | ||
- | - Internet Explorer 11 and above. | ||
- 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]]. | ||
- | - Microsoft Windows 10 and above (recommended with 64 bits windows). | ||
- Internet Explorer 11 and above. | |||
- XGA - minimum of 16 bis colors recommended. | |||
- Intel i5, i7 and above computer. | - Intel i5, i7 and above computer. | ||
- 8 GB of RAM (recommended 12 GB and above). | - 8 GB of RAM (recommended 12 GB and above). | ||
Line 30: | Line 32: | ||
{| width="100%" bgcolor="#fff" border="0" cellpadding="3px" cellspacing="2px" style="margin:auto;" | {| width="100%" bgcolor="#fff" border="0" cellpadding="3px" cellspacing="2px" style="margin:auto;" | ||
|- align="center" bgcolor="tan" | |- align="center" bgcolor="tan" | ||
! width=" | ! width="33%" | '''GL''' | ||
! width=" | ! width="33%" | '''Customer''' | ||
! width=" | ! width="34%" | '''Supplier''' | ||
|- valign="top" align="left" style="background: antiquewhite; font-size: 92%;" | |- valign="top" align="left" style="background: antiquewhite; font-size: 92%;" | ||
Line 47: | Line 47: | ||
*[[Maintain Stock Value]] | *[[Maintain Stock Value]] | ||
*[[Maintain Budget]] | *[[Maintain Budget]] | ||
* | *GL Reports | ||
**[[Print G/L Document Listing]] | **[[Print G/L Document Listing]] | ||
**[[Print Journal of Transaction Listing]] | **[[Print Journal of Transaction Listing]] | ||
Line 54: | Line 54: | ||
**[[Print Trial Balance]] | **[[Print Trial Balance]] | ||
**[[Print Receipt & Payment Report]] | **[[Print Receipt & Payment Report]] | ||
**[[Print Profit & Loss Statement]] | **[[Print Profit & Loss Statement (Consolidation)]] | ||
**[[Print Balance Sheet Statement]] | **[[Print Balance Sheet Statement (Consolidation)]] | ||
| <div style="float: right"></div> | | <div style="float: right"></div> | ||
*[[Maintain Customer]] | *[[Maintain Customer]] | ||
*[[Customer Invoice]] | *[[Customer Invoice]] | ||
*[[Customer Deposit]] | |||
*[[Customer Payment]] | *[[Customer Payment]] | ||
*[[Customer Debit Note]] | *[[Customer Debit Note]] | ||
Line 65: | Line 66: | ||
*[[Customer Refund]] | *[[Customer Refund]] | ||
*[[Customer Contra]] | *[[Customer Contra]] | ||
* | *Customer Reports | ||
**[[Print Customer Document Listing]] | **[[Print Customer Document Listing]] | ||
**[[Print Customer Balance Report]] | **[[Print Customer Balance Report]] | ||
Line 83: | Line 84: | ||
*[[Supplier Refund]] | *[[Supplier Refund]] | ||
*[[Supplier Contra]] | *[[Supplier Contra]] | ||
* | *Supplier Reports | ||
**[[Print Supplier Document Listing]] | **[[Print Supplier Document Listing]] | ||
**[[Print Supplier Balance Report]] | **[[Print Supplier Balance Report]] | ||
Line 92: | Line 93: | ||
**[[Print Supplier Analysis By Document]] | **[[Print Supplier Analysis By Document]] | ||
**[[Print Supplier Purchase and Payment Analysis]] | **[[Print Supplier Purchase and Payment Analysis]] | ||
|- align="center" bgcolor="tan" | |||
! width="33%" | '''Sales''' | |||
! width="33%" | '''Purchase''' | |||
! width="34%" | '''Stock (Inventory)''' | |||
|- valign="top" align="left" style="background: antiquewhite; font-size: 92%;" | |||
| <div style="float: right"></div> | | <div style="float: right"></div> | ||
Line 103: | Line 112: | ||
*[[Credit Note]] | *[[Credit Note]] | ||
*[[Sales Cancelled Note]] | *[[Sales Cancelled Note]] | ||
* | *Sales Reports | ||
**[[Print Sales Document Listing]] | **[[Print Sales Document Listing]] | ||
**[[Print Outstanding Sales Document Listing]] | **[[Print Outstanding Sales Document Listing]] | ||
Line 122: | Line 131: | ||
*[[Purchase Returned]] | *[[Purchase Returned]] | ||
*[[Purchase Cancelled Note]] | *[[Purchase Cancelled Note]] | ||
* | *Purchase Reports | ||
**[[Print Purchase Document Listing]] | **[[Print Purchase Document Listing]] | ||
**[[Print Outstanding Purchase Document Listing]] | **[[Print Outstanding Purchase Document Listing]] | ||
Line 128: | Line 137: | ||
**[[Print Purchase Analysis by Document]] | **[[Print Purchase Analysis by Document]] | ||
**[[Print Yearly Purchase Analysis]] | **[[Print Yearly Purchase Analysis]] | ||
| <div style="float: right"></div> | | <div style="float: right"></div> | ||
Line 158: | Line 148: | ||
*[[Maintain Location]] | *[[Maintain Location]] | ||
*[[Maintain Batch]] | *[[Maintain Batch]] | ||
*[[Stock Take]] | |||
*[[Stock Received]] | *[[Stock Received]] | ||
*[[Stock Issue]] | *[[Stock Issue]] | ||
*[[Stock Transfer]] | *[[Stock Transfer]] | ||
*[[Stock Adjustment]] | *[[Stock Adjustment]] | ||
* | *Stock Reports | ||
**[[Print Stock Document Listing]] | **[[Print Stock Document Listing]] | ||
**[[Print Stock Reorder Advice]] | **[[Print Stock Reorder Advice]] | ||
Line 174: | Line 165: | ||
**[[Print Stock Serial Number Conflict]] | **[[Print Stock Serial Number Conflict]] | ||
**[[Print Stock Serial Number Outstanding]] | **[[Print Stock Serial Number Outstanding]] | ||
|- align="center" bgcolor="tan" | |||
! width="33%" | '''Production''' | |||
! width="33%" | '''Inquiry''' | |||
! width="34%" | '''GST''' | |||
|- valign="top" align="left" style="background: antiquewhite; font-size: 92%;" | |||
| <div style="float: right"></div> | | <div style="float: right"></div> | ||
Line 179: | Line 185: | ||
*[[Stock Item Assembly]] | *[[Stock Item Assembly]] | ||
*[[Stock Item Disassembly]] | *[[Stock Item Disassembly]] | ||
* | * Production Reports | ||
**[[Print Job Order Listing]] | **[[Print Job Order Listing]] | ||
**[[Print Outstanding Production Document Listing]] | **[[Print Outstanding Production Document Listing]] | ||
Line 196: | Line 202: | ||
*[[Serial Number Inquiry]] | *[[Serial Number Inquiry]] | ||
*[[SQL Power Search]] | *[[SQL Power Search]] | ||
| <div style="float: right"></div> | |||
*[[GST Count Down Timer]] | |||
*[[New GST Return]] | |||
*[[Open GST Return]] | |||
*[[Maintain Tax]] | |||
*[[GST Effective Date]] | |||
*[[Gift / Deemed Supply]] | |||
*[[Print GST Listing]] | |||
*[[Print GST-03]] | |||
*[[Generate GST Audit File (GAF)]] | |||
*[[Print GST Bad Debt Relief]] | |||
*GST Special Treatment | |||
**[[GST Margin Scheme]] | |||
**[[GST Treatment: Import Goods (IM)]] | |||
**[[GST Treatment: ATS]] | |||
**[[GST Treatment: Non-Refundable Deposit]] | |||
**[[GST Treatment: How to report GST-03 item 16 Capital Goods Acquired for Purchase of machinery from Oversea]] | |||
**[[GST Treatment: Free Industrial Zone(FIZ) and Licensed Manufacturing Warehouse(LMW)]] | |||
**[[GST Treatment: Construction Business]] | |||
**[[GST Treatment: Partial Exemption]] | |||
**[[GST Treatment: Imported Services]] | |||
**'''[[GST: Set Tax Year & Longer Period Adjustment]]''' | |||
**[[Special-GST Treatment: Non-deductible Expenditure ]] | |||
**[[GST-03 Item 12 (ES + IES) : How to compare the Total Value of Exempt Supplies between GST-03 and Ledger]] | |||
*'''[[Migration System Features-How to handle the GST Past Documents Opening Balance for Customer and Supplier]]''' | |||
*[[GST - Payment to RMCD]] | |||
*[[GST - GST-03 Amendment]] | |||
*[[How to Avoid Costly GST Errors]] | |||
*'''[[Adjustment to negative value in GST-03]]''' | |||
*'''[[GST-Submission of Final GST Return]]''' | |||
*'''[[Transitional (from GST to SST)]]''' | |||
*'''[[GST Sales/Purchase Deferred Tax Journal Adjustment]]''' | |||
|- align="center" bgcolor="tan" | |||
! width="33%" | '''SST''' | |||
! width="33%" | '''Tools''' | |||
! width="34%" | '''Others''' | |||
|- valign="top" align="left" style="background: antiquewhite; font-size: 92%;" | |||
| <div style="float: right"></div> | | <div style="float: right"></div> | ||
*[[Maintain User Group]] | *[[New SST Return]] | ||
*[[Maintain User]] | *[[Open SST Return]] | ||
*[[User Access Right Assignment]] | *[[Maintain Tax (SST)]] | ||
*[[Print SST Listing]] | |||
*SST Related Guide | |||
**[[SST-Tax Code]] | |||
**[[SST-Tariff Code]] | |||
**[[SST-Imported Service (SST-02A)]] | |||
**[[SST-Account for Pending Service Tax over 12 months]] | |||
| <div style="float: right"></div> | |||
*[[Maintain User Group (Acc)]] | |||
*[[Maintain User (Acc)]] | |||
*[[User Access Right Assignment (Acc)]] | |||
*[[Maintain Style]] | *[[Maintain Style]] | ||
*[[Maintain Commission Script]] | *[[Maintain Commission Script]] | ||
Line 214: | Line 274: | ||
*[[Maintain Project (Acc)]] | *[[Maintain Project (Acc)]] | ||
*[[Maintain Tax]] | *[[Maintain Tax]] | ||
*[[Maintain Withholding Tax]] | |||
*[[Maintain Company Category]] | *[[Maintain Company Category]] | ||
*[[Maintain Shipper]] | *[[Maintain Shipper]] | ||
*[[Maintain Tariff]] | |||
*[[Print Audit Trail]] | *[[Print Audit Trail]] | ||
*[[Analyse Data Integrity]] | *[[Analyse Data Integrity]] | ||
Line 224: | Line 286: | ||
*[[Maintain DIY]] | *[[Maintain DIY]] | ||
*[[SQL Control Center]] | *[[SQL Control Center]] | ||
| <div style="float: right"></div> | | <div style="float: right"></div> | ||
Line 255: | Line 291: | ||
*[[Sales Price History (Shift+Ctrl+S)]] | *[[Sales Price History (Shift+Ctrl+S)]] | ||
*[[Purchase Price History (Shift+Ctrl+P)]] | *[[Purchase Price History (Shift+Ctrl+P)]] | ||
*[[Available Stock Balance (F11)]] | *[[Available Stock Balance (Ctrl+F11)]] | ||
*[[Price Tag (Ctrl+T)]] | *[[Price Tag (Ctrl+T)]] | ||
*[[Stock Item Picture]] | *[[Stock Item Picture]] | ||
Line 263: | Line 299: | ||
*[[Data Import]] | *[[Data Import]] | ||
*[[Customisation]] | *[[Customisation]] | ||
*[[List of Accounting can be import to SQL Accounting]] | |||
|- align="center" bgcolor="tan" | |||
! width="33%" | '''Asset''' | |||
! width="33%" | '''MyTTx''' | |||
! width="33%" | '''FAQ-Troubleshoot''' | |||
|- valign="top" align="left" style="background: antiquewhite; font-size: 92%;" | |||
| <div style="float: right"></div> | |||
*[[Maintain Asset Group]] | |||
*[[Maintain Asset Item]] | |||
*[[Process Depreciation]] | |||
*[[Open Depreciation]] | |||
*[[Asset Disposal]] | |||
*[[Print Yearly Depreciation]] | |||
*[[Print Asset Analysis]] | |||
*[[Print Asset Disposal Listing]] | |||
*Specific Asset Guide | |||
**[[How to process Asset Opening and tally with the GL Maintain Opening Balance]] | |||
**[[Import-Asset Master List]] | |||
*[[FAQ-Asset]] | |||
| <div style="float: right"></div> | |||
*[[Malaysia Tourism Tax System (MyTTx)]] | |||
| <div style="float: right"></div> | |||
*[[FAQ Troubleshoot (SQL Acc)]] | |||
*[[Withholding Tax]] | |||
*[[FAQ E Commerce]] | |||
|} | |} |
Latest revision as of 05:58, 29 December 2022
SQL Business Suite is designed to support applications that deliver business-critical functionality to large deployment of network environment. It is build and optimized for mission-specific application.
At the core SQL Business Suite lies a robust Client-Server architecture that allows it to deliver significant advantages in flexibility, reliability, performance and stability. Self-tuning features include cost-based query optimization and dynamic re-balancing of reports structures enhance performance and provides a wide range of business reports.
More important, SQL Business Suite is an open period solution that enables you to collect more data over a wider time frame for better decision-base analysis. For more information, visit https://www.sql.com.my/
System Requirements
- for Standalone or Client (Workstation) PC
- Microsoft Windows 10 and above (recommended with 64 bits windows). - Internet Explorer 11 and above. - 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. - Microsoft Windows 10 and above (recommended with 64 bits windows). - Internet Explorer 11 and above. - 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.