account4:Contents: Difference between revisions

From eStream Software
No edit summary
No edit summary
 
(22 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>
Line 10: Line 10:
'''System Requirements'''<br>
'''System Requirements'''<br>
*for Standalone or Client (Workstation) PC
*for Standalone or Client (Workstation) PC
   - Microsoft Windows 8.1 and above (recommended with 64 bits windows).
   - Microsoft Windows 10 and above (recommended with 64 bits windows).
   - Internet Explorer 11 and above.
   - Internet Explorer 11 and above.
   - 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
   - [[Firebird]].
   - [[Firebird]].
   - Microsoft Windows 8.1 and above (recommended with 64 bits windows).
   - Microsoft Windows 10 and above (recommended with 64 bits windows).
   - Internet Explorer 11 and above.
   - Internet Explorer 11 and above.
   - XGA - minimum of 16 bis colors recommended.
   - XGA - minimum of 16 bis colors recommended.
Line 32: 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="20%" | '''GL'''
! width="33%" | '''GL'''
! width="20%" | '''Customer'''
! width="33%" | '''Customer'''
! width="20%" | '''Supplier'''
! width="34%" | '''Supplier'''
! width="20%" | '''Sales'''
! width="20%" | '''Purchase'''


|- valign="top" align="left" style="background: antiquewhite; font-size: 92%;"
|- valign="top" align="left" style="background: antiquewhite; font-size: 92%;"
Line 95: 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 131: Line 137:
**[[Print Purchase Analysis by Document]]
**[[Print Purchase Analysis by Document]]
**[[Print Yearly Purchase Analysis]]
**[[Print Yearly Purchase Analysis]]
|- align="center" bgcolor="tan"
! width="20%" | '''Stock (Inventory)'''
! width="20%" | '''Production'''
! width="20%" | '''Inquiry'''
! width="20%" | '''GST'''
! width="20%" | '''SST'''
|- valign="top" align="left" style="background: antiquewhite; font-size: 92%;"


| <div style="float: right"></div>
| <div style="float: right"></div>
Line 161: Line 148:
*[[Maintain Location]]
*[[Maintain Location]]
*[[Maintain Batch]]
*[[Maintain Batch]]
*[[Stock Take]]
*[[Stock Received]]
*[[Stock Received]]
*[[Stock Issue]]
*[[Stock Issue]]
Line 177: 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 233: Line 236:
*'''[[Transitional (from GST to SST)]]'''
*'''[[Transitional (from GST to SST)]]'''
*'''[[GST Sales/Purchase Deferred Tax Journal Adjustment]]'''
*'''[[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%;"




Line 238: Line 249:
*[[New SST Return]]
*[[New SST Return]]
*[[Open SST Return]]
*[[Open SST Return]]
*[[Maintain Tax]]
*[[Maintain Tax (SST)]]
*[[Print SST Listing]]
*[[Print SST Listing]]
*SST Related Guide
*SST Related Guide
**[[SST-Tax Code]]
**[[SST-Tax Code]]
**[[SST-Tariff Code]]
**[[SST-Tariff Code]]
**[[SST-Pending Service Tax over 12 months]]
**[[SST-Imported Service (SST-02A)]]  
 
**[[SST-Account for Pending Service Tax over 12 months]]  
|- align="center" bgcolor="tan"
! width="20%" | '''Others'''
! width="20%" | '''Tools'''
! width="20%" | '''MyTTx'''
! width="20%" | '''FAQ-Troubleshoot'''
 
|- valign="top" align="left" style="background: antiquewhite; font-size: 92%;"
 
| <div style="float: right"></div>
*[[Show Chart]]
*[[Sales Price History (Shift+Ctrl+S)]]
*[[Purchase Price History (Shift+Ctrl+P)]]
*[[Available Stock Balance (F11)]]
*[[Price Tag (Ctrl+T)]]
*[[Stock Item Picture]]
*[[Stock Item Search (F9)]]
*[[Advance Search (Ctrl+F)]]
*[[SQL Accounting Linking]]
*[[Data Import]]
*[[Customisation]]


| <div style="float: right"></div>
| <div style="float: right"></div>
Line 283: 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]]
Line 294: Line 286:
*[[Maintain DIY]]
*[[Maintain DIY]]
*[[SQL Control Center]]
*[[SQL Control Center]]
| <div style="float: right"></div>
*[[Show Chart]]
*[[Sales Price History (Shift+Ctrl+S)]]
*[[Purchase Price History (Shift+Ctrl+P)]]
*[[Available Stock Balance (Ctrl+F11)]]
*[[Price Tag (Ctrl+T)]]
*[[Stock Item Picture]]
*[[Stock Item Search (F9)]]
*[[Advance Search (Ctrl+F)]]
*[[SQL Accounting Linking]]
*[[Data Import]]
*[[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>
| <div style="float: right"></div>
Line 300: Line 329:
| <div style="float: right"></div>
| <div style="float: right"></div>
*[[FAQ Troubleshoot (SQL Acc)]]
*[[FAQ Troubleshoot (SQL Acc)]]
 
*[[Withholding Tax]]
 
*[[FAQ E Commerce]]
|}
|}

Latest revision as of 05:58, 29 December 2022

SQL Accounting

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.


GL Customer Supplier
Sales Purchase Stock (Inventory)





Production Inquiry GST



SST Tools Others


Asset MyTTx FAQ-Troubleshoot