www.sql.com.my

1800 87 7061

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 rebalancing 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.

SQL Financial Accounting Advantages

 

Find out how SQL Accounting works easily with our POS system!

  1. All you need is to download the Excel template via the link provided.
  2. Export the inventory list from our BMO system and paste it directly to the sheet titled StockGroup. Make sure the stated columns are filled up, namely;
  • Sales
  • Sales Returned
  • CashSales
  • Purchase
  • CashPurchase
  • Purchase Return
  • Costing Method

Contact Us

  1. Copy the relevant data from the exported Inventory List from BMO. After which you should export the Contact List from BMO. Copy the relevant data from the exported Contact List under the Customer & Supplier Master sheet. Import the data to SQL via SourceField into MappedField and select Post to A/C.
  2. Export receipt List from BMO after which you can Import the receipt List to SQL. Under the RPT folder in BMO, select all the exported receipt list, select Send To and select Compressed (zipped) folder. In SQL Accounting Text & XML Import, select Sales in Invoice, Get File and then locate the zipped RPT file, click Open, select Verify and select Post to A/C.

SQL Accounting XLS and MDB Import – Steps

SQL Excel Template
 
 

Export Inventory List From BMO

In BMO, go to Inventory > Inventory List > Select all item > Export

Item List

Under the sheet “StockList” from the SQL template, copy the relevant data from exported Inventory List from BMO into it.

Category List

From the exported CSV file,select one of each category and paste them into the template downloaded, sheet name “Stock Group”
Also fill up the column “Sales”, “Sales Returned”, “CashSales”, “Purchase”, “CashPurchase”, “Purchase Return”, “Costing Method”.

Contact List

To export Contact List from BMO, go to Contact > Contact List > select all contact > Export
Under the sheet “Customer&Supplier Master” from the SQL template, copy the relevant data from the exported Contact List from BMO into it.

Import to SQL – Category

Launch SQL XLS n MDB Import.
Select Stock > Maintain Stock Group
On far right, select “Get File”.
Select the saved XLS file, and click Open.

Import to SQL – Category

  • Select “StockGroup” from the drop down, and click “Get Data”
  • Select the relevant data from “SourceField” to “MappedField”
  • Then select “Post To A/C” when the process is done.

Import to SQL – Item List

  • Select Stock > Maintain Stock Item
  • On far right, select “Get File”.
  • Select the saved XLS file, and click Open.
  • Select “StockList” from the drop down, and click “Get Data”
  • Select the relevant data from “SourceField” to “MappedField”
  • Then select “Post To A/C” when the process is done.

Import to SQL – Contact List

  • Select Customer > 1. Maintain Customer
  • On far right, select “Get File”.
  • Select the saved XLS file, and click Open.
  • Select the relevant data from “SourceField” to “MappedField”
  • Then select “Post To A/C” when the process is done.

Export Receipt List from BMO

  • Select Accounting > Post > SQL Accounting
  • Select “Get Data”, then “Export XML”, and “Save”

** Test Post must uncheck
** Exported reports will be saved in BMO folder, under RPT

Import Receipt List TO SQL





  • In the BMO folder, under RPT folder, select all the exported receipt list, right click them, select “Send to”, and select “Compressed (zipped) folder”.
  • In SQL Accounting Text & XML Import, select Sales > Invoice.
  • Select “Get File”, then locate the zipped RPT file, click Open.
  • Select “Verify”, then select “Post To A/c”

** Must change file format to “XML Files(*.zip)”

SQL FINANCIAL ACCOUNTING MODULES
GL (General Ledger), Customer (AR), Supplier (AP)

  • Open Period, No Need Year End (b/f auto cut off for each financial year)
  • Advance Drill from Anywhere Down to the Source Document
  • Copy & Paste of document or selected detail records
  • Export to MS Office, jpeg, html, pdf & etc
  • Unlimited level of sub account on P/L & B/S
  • External File (fax, email, letter) tracking
  • Unlimited Shipping and branch address
  • 3 Column Balance Sheet
  • Advanced Drill Down
  • Budget
  • Sales Tax

Additional Features

  • Sales Module Quotation, Sales Order, Delivery Order, Invoice, Cash Sales, Debit Note & Credit Note
  • Purchase Module Purchase Request, Purchase Order, Goods Receipt Note, Purchase Invoice, Cash Purchase & Purchase Return
  • Sales & Purchase Document Listing Report
SQL Inventory
Features & reports essential to your store inventory

  • stock document listing
  • stock reorder advice
  • stock card
  • stock month end balance
  • stock aging
  • stock analysis by document

GST Malaysia
Features & reports approved by Royal Kastam
Optional
Foreign currency, partial delivery, multi-doc number, multiple pricing
On-site Training
One time session on-site training (2 hours), software deployment & implementation
Support & Maintenance

  • 1 Year phone calls, email & internet remote support
  • (Free installation of SQL Online Support Software)

* Fair use policy apply, inclusive of program updates

Network Client Access License (Concurrent Users)

  • Client Server Database License
  • Additional 1 concurrent users (Total 2 users)

Email: sales@bizcloud.asia Tel: +604 642 0621 | +603 2780 3880 | +603 7980 1388