Difference between revisions of "SQL Accounting Linking"

From eStream Software
Jump to: navigation, search
(Empty DB)
(Database)
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

SQL Accounting GST Program

Database

Sample DB

Empty DB

  1. At the Login Screen Click 2 dot Button
  2. Click Create New Database
  3. Follow the wizard
----------------------------------------------------------------------------------------------------------------------------------------------------
Template.Tips-01.jpg
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