| Line 26: | Line 26: | ||
|} | |} | ||
:::---------------------------------------------------------------------------------------------------------------------------------------------------- | :::---------------------------------------------------------------------------------------------------------------------------------------------------- | ||
===Things To Consider Before Import/Post=== | |||
Before wanted to Import/Post to SQL Accounting Database, below information must be had/valid in SQL Accounting | |||
# Customer Code => Maintain Customer | |||
# Supplier Code => Maintain Supplier | |||
# Terms Code => Maintain Terms | |||
# Project Code => Maintain Project | |||
# Sales/Purchase Account Code => Maintain Account | |||
# Sales/Purchase Return Account Code => Maintain Account | |||
# Cash/Bank Account Code => Maintain Payment Method (Created from Maintain Account) | |||
# Agent Code => Maintain Agent | |||
# Area Code => Maintain Area | |||
# Currency Code => Maintain Currency | |||
Below is Option (i.e. if had post/import item code to SQL Accounting) | |||
# Item Code => Maintain Stock Item | |||
# Location Code => Maintain Location | |||
# Batch Code => Maintain Batch | |||
==Table/Fields Detail== | ==Table/Fields Detail== | ||
* Updated 18 Dec 2014 | * Updated 18 Dec 2014 | ||
* http://www.estream.com.my/document/SQLLink/DetailSpec.xlsx | * http://www.estream.com.my/document/SQLLink/DetailSpec.xlsx | ||
Revision as of 06:27, 2 February 2015
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.729.703) (Demo) - 29 Nov 2014
- http://www.estream.com.my/document/SQLLink/setup-0003.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
- At the Login Screen Click 2 dot Button
- Click Create New Database
- 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
- Customer Code => Maintain Customer
- Supplier Code => Maintain Supplier
- Terms Code => Maintain Terms
- Project Code => Maintain Project
- Sales/Purchase Account Code => Maintain Account
- Sales/Purchase Return Account Code => Maintain Account
- Cash/Bank Account Code => Maintain Payment Method (Created from Maintain Account)
- Agent Code => Maintain Agent
- Area Code => Maintain Area
- Currency Code => Maintain Currency
Below is Option (i.e. if had post/import item code to SQL Accounting)
- Item Code => Maintain Stock Item
- Location Code => Maintain Location
- Batch Code => Maintain Batch
Table/Fields Detail
- Updated 18 Dec 2014
- http://www.estream.com.my/document/SQLLink/DetailSpec.xlsx