| Line 1: | Line 1: | ||
==Introduction== | ==Introduction== | ||
This is the "Bridge" linking between External Program with SQL Accounting | This is the "Bridge" direct live linking between External Program with SQL Accounting | ||
===Pros=== | ===Pros=== | ||
| Line 8: | Line 8: | ||
# Can direct Retrieve/Get Information From Connected Database. | # Can direct Retrieve/Get Information From Connected Database. | ||
# Support GST. | # Support GST. | ||
# Free of Charge for End User. | # Free of Charge for End User. (Freeware) | ||
===Cons=== | ===Cons=== | ||
Revision as of 01:06, 10 February 2015
Introduction
This is the "Bridge" direct live linking between External Program with SQL Accounting
Pros
- Can Live or Batch Update.
- Can do action such as New, Edit & Delete.
- About 95% of modules is covered.
- Can direct Retrieve/Get Information From Connected Database.
- Support GST.
- Free of Charge for End User. (Freeware)
Cons
- Must had SQL Accounting installed & running.
- Must self do checking else error prompt will unable to “capture”.
Documentation
Linking Flow
Steps
- Install sqlaccounting
- Create Sample Data
- Login (username & password is Admin)
- Double click the SQLSDK.chm file
- Click Application Object | Business Objects
- Click the word "here"
- Click Yes
- 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?
- Right click the chm file & select Properties
- At General tab Click Unblock button.
- Click Apply | Ok.
B. Still can't open CHM file?
- Login SQL Accounting
- Click Tools | Options
- Click Register & follow wizard
- Exit SQL Accounting
- Login SQL Accounting
- 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)