account4:Contents: Difference between revisions

From eStream Software
(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 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