account4:Contents: Difference between revisions

From eStream Software
No edit summary
No edit summary
 
(73 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 7 and above (recommended with 64 bits windows).
   - Microsoft Windows 10 and above (recommended with 64 bits windows).
   - SVGA - minimum of 16 bis colors recommended.
   - 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 7 and above (recommended with 64 bits windows).
  - [[Firebird]].
   - SVGA - minimum of 16 bis colors recommended.
   - 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="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 47: Line 47:
*[[Maintain Stock Value]]
*[[Maintain Stock Value]]
*[[Maintain Budget]]
*[[Maintain Budget]]
*[[GL Reports]]
*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]]
*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]]
*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]]
*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]]
*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]]
|- align="center" bgcolor="tan"
! width="20%" | '''Stock (Inventory)'''
! width="20%" | '''Production'''
! width="20%" | '''Inquiry'''
! width="20%" | '''Tools'''
! width="20%" | '''GST'''
|- valign="top" align="left" style="background: antiquewhite; font-size: 92%;"


| <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]]
*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 197: Line 203:
*[[SQL Power Search]]
*[[SQL Power Search]]


| <div style="float: right"></div>
*[[Maintain User Group]]
*[[Maintain User]]
*[[User Access Right Assignment]]
*[[Maintain Style]]
*[[Maintain Commission Script]]
*[[Maintain Acceptable Transaction Date]]
*[[Maintain Document Number]]
*[[Maintain Form Mode]]
*[[Maintain Agent]]
*[[Maintain Area]]
*[[Maintain Terms]]
*[[Maintain Currency]]
*[[Maintain Journal]]
*[[Maintain Payment Method (Acc)]]
*[[Maintain Project (Acc)]]
*[[Maintain Tax]]
*[[Maintain Company Category]]
*[[Maintain Shipper]]
*[[Print Audit Trail]]
*[[Analyse Data Integrity]]
*[[Report Designer]]
*[[Print Bar Code (Direct Printer)]]
*[[Print Bar Code (Windows Printer)]]
*[[Options (Acc)]]
*[[Maintain DIY]]
*[[SQL Control Center]]


| <div style="float: right"></div>
| <div style="float: right"></div>
*[[GST Count Down Timer]]
*[[New GST Return]]
*[[New GST Return]]
*[[Open GST Return]]
*[[Open GST Return]]
Line 239: Line 219:
**[[GST Treatment: Import Goods (IM)]]
**[[GST Treatment: Import Goods (IM)]]
**[[GST Treatment: ATS]]
**[[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: 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: Free Industrial Zone(FIZ) and Licensed Manufacturing Warehouse(LMW)]]
**[[GST Treatment: Construction Business]]
**[[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 ]]
**[[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]]'''
*'''[[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"
|- align="center" bgcolor="tan"
! width="20%" | '''Others'''
! width="33%" | '''SST'''
! width="33%" | '''Tools'''
! width="34%" | '''Others'''


|- valign="top" align="left" style="background: antiquewhite; font-size: 92%;"
|- valign="top" align="left" style="background: antiquewhite; font-size: 92%;"
| <div style="float: right"></div>
*[[New SST Return]]
*[[Open SST Return]]
*[[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 Commission Script]]
*[[Maintain Acceptable Transaction Date]]
*[[Maintain Document Number]]
*[[Maintain Form Mode]]
*[[Maintain Agent]]
*[[Maintain Area]]
*[[Maintain Terms]]
*[[Maintain Currency]]
*[[Maintain Journal]]
*[[Maintain Payment Method (Acc)]]
*[[Maintain Project (Acc)]]
*[[Maintain Tax]]
*[[Maintain Withholding Tax]]
*[[Maintain Company Category]]
*[[Maintain Shipper]]
*[[Maintain Tariff]]
*[[Print Audit Trail]]
*[[Analyse Data Integrity]]
*[[Report Designer]]
*[[Print Bar Code (Direct Printer)]]
*[[Print Bar Code (Windows Printer)]]
*[[Options (Acc)]]
*[[Maintain DIY]]
*[[SQL Control Center]]


| <div style="float: right"></div>
| <div style="float: right"></div>
Line 256: 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 264: 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 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