(Blanked the page) |
No edit summary |
||
(119 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
{{DISPLAYTITLE:SQL Financial Accounting}} | |||
[[File:SQLAcc Logo.jpg|None|right|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/ | |||
<br> | |||
<br> | |||
<br> | |||
'''System Requirements'''<br> | |||
*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. | |||
<br /> | |||
{| width="100%" bgcolor="#fff" border="0" cellpadding="3px" cellspacing="2px" style="margin:auto;" | |||
|- align="center" bgcolor="tan" | |||
! width="33%" | '''GL''' | |||
! width="33%" | '''Customer''' | |||
! width="34%" | '''Supplier''' | |||
|- valign="top" align="left" style="background: antiquewhite; font-size: 92%;" | |||
| <div style="float: right"></div> | |||
*[[Maintain Account]] | |||
*[[Cash Book Entry]] | |||
*[[Journal Entry]] | |||
*[[Foreign Bank Adjustment]] | |||
*[[Maintain Opening Balance]] | |||
*[[Bank Reconciliation]] | |||
*[[Maintain Stock Value]] | |||
*[[Maintain Budget]] | |||
*GL Reports | |||
**[[Print G/L Document Listing]] | |||
**[[Print Journal of Transaction Listing]] | |||
**[[Print Transaction Summary Listing]] | |||
**[[Print Ledger Report]] | |||
**[[Print Trial Balance]] | |||
**[[Print Receipt & Payment Report]] | |||
**[[Print Profit & Loss Statement (Consolidation)]] | |||
**[[Print Balance Sheet Statement (Consolidation)]] | |||
| <div style="float: right"></div> | |||
*[[Maintain Customer]] | |||
*[[Customer Invoice]] | |||
*[[Customer Deposit]] | |||
*[[Customer Payment]] | |||
*[[Customer Debit Note]] | |||
*[[Customer Credit Note]] | |||
*[[Customer Refund]] | |||
*[[Customer Contra]] | |||
*Customer Reports | |||
**[[Print Customer Document Listing]] | |||
**[[Print Customer Balance Report]] | |||
**[[Print Customer Due Document]] | |||
**[[Print Customer Aging Report]] | |||
**[[Print Customer Statement]] | |||
**[[Print Customer Post Dated Cheque Listing]] | |||
**[[Print Customer Analysis By Document]] | |||
**[[Print Customer Sales and Collection Analysis]] | |||
| <div style="float: right"></div> | |||
*[[Maintain Supplier]] | |||
*[[Supplier Invoice]] | |||
*[[Supplier Payment]] | |||
*[[Supplier Debit Note]] | |||
*[[Supplier Credit Note]] | |||
*[[Supplier Refund]] | |||
*[[Supplier Contra]] | |||
*Supplier Reports | |||
**[[Print Supplier Document Listing]] | |||
**[[Print Supplier Balance Report]] | |||
**[[Print Supplier Due Document]] | |||
**[[Print Supplier Aging Report]] | |||
**[[Print Supplier Statement]] | |||
**[[Print Supplier Post Dated Cheque Listing]] | |||
**[[Print Supplier Analysis By Document]] | |||
**[[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> | |||
*[[Quotation]] | |||
*[[Sales Order]] | |||
*[[Delivery Order]] | |||
*[[Invoice]] | |||
*[[Cash Sales]] | |||
*[[Extra Delivery Order]] | |||
*[[Debit Note]] | |||
*[[Credit Note]] | |||
*[[Sales Cancelled Note]] | |||
*Sales Reports | |||
**[[Print Sales Document Listing]] | |||
**[[Print Outstanding Sales Document Listing]] | |||
**[[Print Sales Picking Listing]] | |||
**[[Print Sales Price History]] | |||
**[[Print Profit & Loss by Document]] | |||
**[[Print Sales Analysis by Document]] | |||
**[[Print Yearly Sales Analysis]] | |||
| <div style="float: right"></div> | |||
*[[Purchase Request]] | |||
*[[Purchase Order]] | |||
*[[Goods Received]] | |||
*[[Purchase Invoice]] | |||
*[[Cash Purchase]] | |||
*[[Extra Goods Received]] | |||
*[[Purchase Debit Note]] | |||
*[[Purchase Returned]] | |||
*[[Purchase Cancelled Note]] | |||
*Purchase Reports | |||
**[[Print Purchase Document Listing]] | |||
**[[Print Outstanding Purchase Document Listing]] | |||
**[[Print Purchase Price History]] | |||
**[[Print Purchase Analysis by Document]] | |||
**[[Print Yearly Purchase Analysis]] | |||
| <div style="float: right"></div> | |||
*[[Maintain Stock Group]] | |||
*[[Maintain Stock Item]] | |||
*[[Maintain Stock Category]] | |||
*[[Maintain Stock Category Template]] | |||
*[[Maintain Stock Price Tag]] | |||
*[[Maintain Item Template]] | |||
*[[Maintain Stock Item Matrix Profile]] | |||
*[[Maintain Location]] | |||
*[[Maintain Batch]] | |||
*[[Stock Take]] | |||
*[[Stock Received]] | |||
*[[Stock Issue]] | |||
*[[Stock Transfer]] | |||
*[[Stock Adjustment]] | |||
*Stock Reports | |||
**[[Print Stock Document Listing]] | |||
**[[Print Stock Reorder Advice]] | |||
**[[Print Stock Physical Worksheet]] | |||
**[[Print Stock Card]] | |||
**[[Print Stock Card Qty]] | |||
**[[Print Stock Month End Balance]] | |||
**[[Print Stock Aging]] | |||
**[[Print Stock Analysis By Document]] | |||
**[[Print Stock Batch Expiry]] | |||
**[[Print Stock Serial Number Conflict]] | |||
**[[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> | |||
*[[Job Order]] | |||
*[[Stock Item Assembly]] | |||
*[[Stock Item Disassembly]] | |||
* Production Reports | |||
**[[Print Job Order Listing]] | |||
**[[Print Outstanding Production Document Listing]] | |||
**[[Print BOM Relation]] | |||
**[[Print BOM Listing]] | |||
**[[Print BOM Material Usage]] | |||
**[[Print BOM Planner]] | |||
**[[Print BOM Wastage Report]] | |||
| <div style="float: right"></div> | |||
*[[Account Inquiry]] | |||
*[[Cash Flow Inquiry]] | |||
*[[Cash Flow Forecast]] | |||
*[[Customer Pricing Inquiry]] | |||
*[[Supplier Pricing Inquiry]] | |||
*[[Serial Number Inquiry]] | |||
*[[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> | |||
*[[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> | |||
*[[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> | |||
*[[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.