IMPORTANT: Please remember to log in to your SQL Accounting Software first before you proceed. 

Access: Apps > SQL Accounting Sync

SQL Accounting Sync Order List

sql-accounting-sync-main

The itemized items below are referring to the numbers shown in the image above:-

  1. Settings: To change the general settings of SQL Accounting Sync. ( see Settings below )
  2. Product Matching: To insert SQL Accounting Product ID and Product UOM. ( see Product Matching below )
  3. Customer Matching: To insert SQL Accounting Customer Code. ( see Customer Matching below )
  4. Shipping Matching: To insert SQL Accounting Code and UOM for shipping cost. ( see Shipping Matching below )
  5. Payment Matching: To insert SQL Accounting Code, Payment Charge and Payment Min. Charge. ( see Payment Matching below )
  6. Checked field: You can tick this checkbox to indicate that you have synced and checked in your SQL Accounting Software to make sure everything are correct. This is solely for remark purpose.
  7. SQL Invoice No. field: To insert the Invoice No. generated from SQL Accounting Software as this is a mandatory field required to perform the Payment Sync and also for your own record purposes.
  8. Sync Invoice action: To sync invoice to SQL Accounting ( see How to Sync Invoice below )
  9. Sync Payment action: To sync payment to SQL Accounting ( see How to Sync Payment below )

 


Settings

sql-accounting-sync-settings

  • Customer ID: Set the default Customer ID in the Invoice
  • Agent: Set the default Agent the Invoice
  • Terms: Set the default Terms in the Invoice
  • Invoice No. Taken From: Set the Invoice No. to be taken from either Unicart or SQL Accounting Software
  • Tax Inclusive: Set to include tax in the Invoice
  • UOM: Set the default UOM of item in the Invoice
  • Coupon Code: Set the item code for Coupon
  • Coupon UOM: Set the default UOM for Coupon
  • Coupon Tax Class: Set the Tax Class for Coupon
  • Voucher Code: Set the item code for Voucher
  • Voucher UOM: Set the default UOM for Voucher
  • Voucher Tax Class: Set the Tax Class for Voucher
  • Rounding Code: Set the item code for Rounding Amount
  • Rounding UOM: Set the default UOM for Rounding Amount
  • Rounding Tax Class:  Set the default Tax Class for Rounding Amount
  • User Name: Enter your User Name to login to your SQL Accounting Software
  • Password: Enter your Password to login to your SQL Accounting Software
  • DCF File Path: Enter the System Database Access Path of your SQL Accounting Software
    eg: C:\eStream\SQLAccounting\Share\DEFAULT.DCF
  • Database File Name: Enter the Database File Name of your SQL Accounting Software
    e.g. SAMPLE.FDB

Click the Save button to save the settings.

 


Product Matching

sql-accounting-sync-product-matching

The itemized items below are referring to the numbers shown in the image above:-

  1. Insert SQL Accounting Item Code into Unicart SQL Accounting Product ID so the same product from both systems can be matched.
  2. Insert SQL Accounting UOM into Unicart SQL Accounting Product UOM so the same product UOM from both systems can be matched.

 


Payment Matching

sql-accounting-sync-payment-matching

The itemized items below are referring to the numbers shown in the image above:-

  1. Insert SQL Accounting Code in Unicart to match the Code displayed in “Received In :” in SQL Accounting Software.
  2. Insert the Payment Charge (Transaction Fee/Surcharge) which will be displayed as “Bank Charge :” in SQL Accounting Software.
  3. Insert the Min. Payment Charge (Transaction Fee/Surcharge) which will also be displayed as “Bank Charge :” in SQL Accounting Software.
    IMPORTANT: If both (2) and (3) are set, the system will get the lowest value as “Bank Charge :”

 


Customer Matching

sql-accounting-sync-customer-matching

The itemized items below are referring to the numbers shown in the image above:-

  1. Insert SQL Accounting Customer Code into Unicart SQL Accounting Customer Code so the same customer from both systems can be matched.

 


Shipping Matching

sql-accounting-sync-customer-matching

The itemized items below are referring to the numbers shown in the image above:-

  1. Insert SQL Accounting Shipping Code into Unicart SQL Accounting Code so the same shipping method from both systems can be matched.
  2. Insert SQL Accounting Shipping UOM into Unicart UOM so the same shipping UOM from both systems can be matched.

 


How to Sync Invoice

Step 1: Click the Sync Button located on the top-right hand corner.

sql-accounting-sync-invoice-step-1

Step 2: Wait for the Sync success popup message as shown below and click OK to close.

sql-accounting-sync-invoice-step-2

Step 3: After syncing, your invoice will now appear in your SQL Accounting Software. You can double check in there.

sql-accounting-sync-invoice-step-3

 


How to Sync Payment

Step 1: Click Sync button located on the top-right hand corner.

sql-accounting-sync-payment-step-1

Step 2: Wait for the Sync success popup message as shown below and click OK to close.

sql-accounting-sync-payment-step-2

Step 3: After syncing, your customer payment will now appear in your SQL Accounting Software. You can double check in there.

sql-accounting-sync-payment-step-3