SDK Live

Introduction

This is the "Bridge" linking between External Program with SQL Accounting

Pros

1. Can Live or Batch Update.
2. Can do action such as New, Edit & Delete.
3. About 95% of modules is covered.
4. Can direct Retrieve/Get Information From Connected Database.
5. Support GST.
6. Free of Charge for End User.

Cons

1. Must had SQL Accounting installed & running.
2. Must self do checking else error prompt will unable to “capture”.

Documentation

• http://www.estream.com.my/document/SQLLink/SQLSDK.zip

Linking Flow

• http://www.estream.com.my/document/SQLLink/LinkFlow.pdf

Steps

1. Install sqlaccounting
2. Create Sample Data
3. Login (username & password is Admin)
4. Double click the SQLSDK.chm file
5. Click Application Object | Business Objects
6. Click the word "here"
7. Click Yes
8. In the list Look for (example)

- AR_IV -> Customer Invoice

- AR_CN -> Customer Credit Note

- AP_PI -> Supplier Invoice

- SL_ID -> Sales Invoice

- ST_AJ -> Stock Adjustment

Problem with CHM File

A. Problem with opening CHM Help files?

1. Right click the chm file & select Properties
2. At General tab Click Unblock button.
3. Click Apply | Ok.

B. Still can't open CHM file?

1. Login SQL Accounting
2. Click Tools | Options
3. Click Register & follow wizard
4. Exit SQL Accounting
5. Login SQL Accounting
6. Run CHM File

Example External Program

• http://www.estream.com.my/document/SQLLink/Accountinglink-VBDotNet.zip (Using VB.Net)
• http://www.estream.com.my/document/SQLLink/Customer_RO-VBScipt.zip (Using VB Script)