| Line 38: | Line 38: | ||
:: - ST_AJ -> Stock Adjustment | :: - ST_AJ -> Stock Adjustment | ||
== | ==Problems== | ||
===With CHM File=== | |||
A. Problem with opening CHM Help files? <br> | A. Problem with opening CHM Help files? <br> | ||
# Right click the chm file & select Properties | # Right click the chm file & select Properties | ||
| Line 51: | Line 52: | ||
# Login SQL Accounting | # Login SQL Accounting | ||
# Run CHM File | # Run CHM File | ||
===With Compiler=== | |||
If you compiler had error may try add the '''esfw10.dll''' file under the SQL Accounting\bin folder | |||
==Extra Notes== | ==Extra Notes== | ||
Revision as of 07:09, 9 October 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”.
- Only supported in IE for JScript
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
Problems
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
With Compiler
If you compiler had error may try add the esfw10.dll file under the SQL Accounting\bin folder
Extra Notes
Login Database Profile
- Can use the "Common.Agent.RO" Report Objects to get the Profile info.
- Then use the cdsProfile Dataset
- - CompanyName Field
- - Remark Field
- Refer to "How to retrieve data from Customer Invoice Listing Report?" on chm
- - Can by pass the Steps 5 Spool Parameters
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)
- http://www.estream.com.my/document/SQLLink/Example-ST_Item.jpg (Using Delphi)
- http://www.estream.com.my/document/SQLLink/Example-AR_PM.jpg (Using Delphi)
- http://www.estream.com.my/document/SQLLink/AR_PM-JScript.zip (Using JScript)
