SQL Accounting Linking

Introduction

We had 3 Methods to Integrate/Link to SQL Accounting

• SDK Live (Recommended)
• SQL XML Import
• SQL Text Import

SQL Accounting GST Program

• Version (4.2014.732.704) (Demo) - 17 Jan 2015
• http://www.estream.com.my/document/SQLLink/setup-0004.exe

Database

Sample DB

• http://www.estream.com.my/document/SQLLink/GST-SampleDB-20141203.zip
• http://www.estream.com.my/document/SQLLink/Video-RestoreDB.zip

Empty DB

1. At the Login Screen Click 2 dot Button
2. Click Create New Database
3. Follow the wizard

----------------------------------------------------------------------------------------------------------------------------------------------------

Default UserName & Password is ADMIN

----------------------------------------------------------------------------------------------------------------------------------------------------

Things To Consider Before Import/Post

Before wanted to Import/Post to SQL Accounting Database, below information must be had/valid in SQL Accounting

1. Customer Code => Maintain Customer
2. Supplier Code => Maintain Supplier
3. Terms Code => Maintain Terms
4. Project Code => Maintain Project
5. Sales/Purchase Account Code => Maintain Account
6. Sales/Purchase Return Account Code => Maintain Account
7. Cash/Bank Account Code => Maintain Payment Method (Created from Maintain Account)
8. Agent Code => Maintain Agent
9. Area Code => Maintain Area
10. Currency Code => Maintain Currency

Below is Option (i.e. if had post/import item code to SQL Accounting)

1. Item Code => Maintain Stock Item
2. Location Code => Maintain Location
3. Batch Code => Maintain Batch

Table/Fields Detail

• Updated 14 Feb 2015
• http://www.estream.com.my/document/SQLLink/DetailSpec.xlsx