SQL Accounting Linking: Difference between revisions

Revision as of 06:43, 16 June 2015

Introduction

We had 3 Methods to Integrate/Link to SQL Accounting

SQL Accounting GST Program

Version (4.2015.738.706) (Demo) - 31 Apr 2015
http://www.estream.com.my/document/SQLLink/setup-0006.exe

Database

Sample DB

Empty DB

At the Login Screen Click 2 dot Button
Click Create New Database
Follow the wizard

----------------------------------------------------------------------------------------------------------------------------------------------------

Default UserName & Password is ADMIN

To override the TaxAmt when posting :-
Click Tools | Options... | Customer  & 
Untick the option "One Cent Different Rounding (Local Currency Fields) 
for all AR/SL Documents (Recommended)"

----------------------------------------------------------------------------------------------------------------------------------------------------

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 02 May 2015
http://www.estream.com.my/document/SQLLink/DetailSpec.xlsx

Normal Used Table Name

SL_IV - Sales Invoice
SL_CS - Cash Sales
SL_CN/AR_CN - Credit Note
SL_DN - Debit Note
AR_PM - Payment

Extra Notes

Gov. 5 cents Rounding - no Tax
Doc Disc should proportion by sub total amt for mix tax code (See Cash Sales POS4)

 Example
 - Doc Discount = 30
 - Sub Total for SR = 849.53 => Disc ((849.53/1,182.51) * 30) = 21.55
 - Sub Total for ZR = 332.98 => Disc ((332.98/1,182.51) * 30) = 8.45

@@ Line 62: / Line 62: @@
 * AR_PM - Payment
-===Extra Notes===
+==Extra Notes==
 * Gov. 5 cents Rounding - no Tax
 * Doc Disc should proportion by sub total amt for mix tax code (See Cash Sales POS4)
-    - Doc Discount = 30
+  Example
-    - Sub Total for SR = 849.53 => Disc ((849.53/1,182.51) * 30) = 21.55
+  - Doc Discount = 30
-    - Sub Total for ZR = 332.98 => Disc ((332.98/1,182.51) * 30) = 8.45
+  - Sub Total for SR = 849.53 => Disc ((849.53/1,182.51) * 30) = 21.55
+  - Sub Total for ZR = 332.98 => Disc ((332.98/1,182.51) * 30) = 8.45