| Line 67: | Line 67: | ||
===Method 1 (Recommended)=== | ===Method 1 (Recommended)=== | ||
It will be had 4 transactions | It will be had 4 transactions | ||
1. RM1000 - Post to SL_CS & P_PaymentMethod field is empty | |||
2. RM700 by Cash - Post to AR_PM | |||
3. RM200 by MasterCard - Post to AR_PM | |||
4. RM100 by CreditCard - Post to AR_PM | |||
Pros : Easy to Edit or Delete the transactions<br /> | Pros : Easy to Edit or Delete the transactions<br /> | ||
Cons : Many Posting document | Cons : Many Posting document | ||
| Line 76: | Line 76: | ||
===Method 2=== | ===Method 2=== | ||
It will be had 3 transactions | It will be had 3 transactions | ||
1. RM700 by Cash - Post to SL_CS P_PaymentMethod field | |||
2. RM200 by MasterCard - Post to AR_PM | |||
3. RM100 by CreditCard - Post to AR_PM | |||
Pros : Less Posting document<br /> | Pros : Less Posting document<br /> | ||
Cons : Not Easy to Edit or Delete the transactions | Cons : Not Easy to Edit or Delete the transactions | ||
Revision as of 06:56, 16 June 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.2015.738.706) (Demo) - 31 Apr 2015
- http://www.estream.com.my/document/SQLLink/setup-0006.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
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
Posting Information
- All can post to SL_CS & AR_PM
- Below is example Today Total Simplified Invoice Sales is RM1000
Method 1 (Recommended)
It will be had 4 transactions
1. RM1000 - Post to SL_CS & P_PaymentMethod field is empty 2. RM700 by Cash - Post to AR_PM 3. RM200 by MasterCard - Post to AR_PM 4. RM100 by CreditCard - Post to AR_PM
Pros : Easy to Edit or Delete the transactions
Cons : Many Posting document
Method 2
It will be had 3 transactions
1. RM700 by Cash - Post to SL_CS P_PaymentMethod field 2. RM200 by MasterCard - Post to AR_PM 3. RM100 by CreditCard - Post to AR_PM
Pros : Less Posting document
Cons : Not Easy to Edit or Delete the transactions
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