Streamline Your Business with SQL Accounting & POS Integration

Export from POS to SQL Accounting Software

SQL Accounting Software is designed to support applications that deliver business-critical accounting system functionality to a large deployment of a network environment. It is built and optimized for the 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 that enhance performance and provides a wide range of business reports. More important, SQL Accounting Software is an open period solution that enables you to collect more data over a wider time frame for better decision-based analysis.

SQL Accounting Software Advantages

Find out how SQL Accounting Software works easily with our BMO POS System!

SQL Accounting provides many invoice and many printing format. All you need is to download the SQL Excel template via the link provided.

Export the inventory list from our BMO POS 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

Copy the relevant data from the exported Inventory List from BMO POS System. After which you should export the Contact List from the POS System. 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.

Export receipt List from BMO POS System after which you can Import the receipt List to SQL. Under the RPT folder in BMO, select all the exported receipt lists, 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

Export Inventory List From BMO POS System

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

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.

Import to SQL – Contact ListExport Receipt List from BMO POS System

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 the file format to “XML Files(*.zip)”

SQL Accounting Software Financial Modules

SQL ACCOUNTING SOFTWARE FINANCIAL MODULES	PRICE
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 3 Column Balance Sheet Sales Tax Advanced Drill Down SST Module (NEW) 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	RM1499

SQL ACCOUNTING SOFTWARE FINANCIAL MODULES

PRICE

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

Sales Tax

Advanced Drill Down

SST Module (NEW)

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

RM1499

SQL ACCOUNTING SOFTWARE FINANCIAL MODULES	PRICE
On-site Training One time session on-site training (2 hours), software deployment & implementation	From RM200 FREE with POS System Bundle purchase
Upgrade (PRO PACKAGE) Foreign currency, partial delivery, multi-doc number, multiple pricing	From RM400
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	RM1199
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	From RM700
Network Client Access License (Concurrent Users) Client Server Database License Additional 1 concurrent users (Total 2 users)	+RM700/user

** Note: We reserve the right to change the feature, function, price, and agreement without prior notice.