SQLink Full Sync - Revision history

DavidG at 17:57, 26 July 2016

2016-07-26T17:57:48Z

DavidG: Minor grammar corrections

2016-07-26T17:56:41Z

Minor grammar corrections

Marks at 14:10, 29 March 2016

2016-03-29T14:10:51Z

Marks at 14:08, 29 March 2016

2016-03-29T14:08:42Z

Marks at 20:12, 28 May 2015

2015-05-28T20:12:52Z

Moha: Created page with "

SQLink Regular Sync Guide

SME to QuickBooks . Link Synchronization Tool '''Definitions:'''
1) QB: QuickBooks . ® by Intuit®
2) SME: Service Management ..."

2011-06-07T12:32:44Z

Created page with "<h4>SQLink Regular Sync Guide</h4> SME to QuickBooks . Link Synchronization Tool '''Definitions:''' 1) QB: QuickBooks . ® by Intuit® 2) SME: Service Management ..."

New page

<h4>SQLink Regular Sync Guide</h4>
SME to QuickBooks . Link Synchronization Tool

'''Definitions:'''
 1) QB: QuickBooks . ® by Intuit®

 2) SME: Service Management Professional (version 5) by High5 Software™

 3) SQLink: SME to QB synchronization program by High5 Software™

SQLink is an add-on product to SME5 to synchronize SME and QB databases. SME handles sales, customers, service orders, and inventory while QuickBooks . handles the accounting, payroll, and banking integration. SME and QB together make a very powerful combination for managing your service business.

This Guide explains the regular sync activity between SME and QB. The sync can be done at any time. Most customers run the sync at the beginning or end of the day, however it can be run whenever needed.

For this guide, the initial sync between SME and QB must be completed. If you have not done the initial sync, Please review the SQLink Install and Setup document.

'''Synchronization with SME and QB:'''

1) Synchronizing SME and QB

 i. Note: This will perform both an SME export and QB import. Since the SME export is performed first, records that are changed in both SME and QB will only get the SME changes.

 ii. Note: QuickBooks . will require you to log in to QuickBooks . on the computer running SQLink. Log into QuickBooks . , SME, and SQLink and then run the sync. The user logging in to QuickBooks must have privilages that allow for the actions to be preformed by SQLink.

'''SME:'''

 iii. Within SME, Tools> Sync QuickBooks . .

 iv. [[File:Sync1(1).jpg]]

 v. Answer ‘Ok’ to the prompt.
 vi. Note if you do not have the option “Synchronize with QuickBooks . ”, or the menu option “Sync QuickBooks . ” then the initial import with QuickBooks . has not occurred or has failed. Review the SQLink Install and Setup document or call contact High5 Software technical support at support@high5software.com
SQLink:

 vii. Next start processing in SQLink by selecting Processing>Start Processes

 ix. [[File:sync3(1).jpg]]

 x. You will see SQLink starting the sync process.

 1. SQLink checks for sync requests about once every few minutes.

 2. The Sync is complete when you see the words ‘Payment Processing Complete’

 xi. Note:

 xii. If you encounter issues at this point it is most likely due to drive mappings that have been changed from the original sync.

 xiii. To check:

 1. Open SQLink> File> Link Setup

 2. Open QuickBooks . > F2

 3. The paths for QuickBooks . must match exactly.

@@ Line 1: / Line 1: @@
 <h4>SQLink Regular Sync Guide</h4>
-SME to QuickBooks .  Link Synchronization Tool
+SME to QuickBooks Link Synchronization Tool
 == Overview: ==
@@ Line 16: / Line 16: @@
 == Definitions: ==
-#   QB: QuickBooks . ® by Intuit®
+#   QB: QuickBooks ® by Intuit®
 #   SME: Service Management Professional (version 5) by High5 Software™
 #   SQLink: SME to QB synchronization program by High5 Software™
@@ Line 30: / Line 30: @@
 #   Synchronizing SME and QB
 ##    Note: This will perform both an SME export and QB import. Since the SME export is performed first, records that are changed in both SME and QB will only get the SME changes.
-##   Note: QuickBooks will require you to log in to QuickBooks on the computer running SQLink. Log into QuickBooks , SME, and SQLink and then run the sync. The user logging in to QuickBooks must have privilages that allow for the actions to be preformed by SQLink.
+##   Note: QuickBooks will require you to log in to QuickBooks on the computer running SQLink. Log into QuickBooks, SME, and SQLink and then run the sync. The user logging in to QuickBooks must have privilages that allow for the actions to be preformed by SQLink.
 === SME: ===

@@ Line 20: / Line 20: @@
 #   SQLink: SME to QB synchronization program by High5 Software™
-SQLink is an add-on product to SME5 to synchronize SME and QB databases. SME handles sales, customers, service orders, and inventory while QuickBooks .  handles the accounting, payroll, and banking integration. SME and QB together make a very powerful combination for managing your service business.
+SQLink is an add-on product to SME5 to synchronize SME and QB databases. SME handles sales, customers, service orders, and inventory while QuickBooks   handles the accounting, payroll, and banking integration. SME and QB together make a very powerful combination for managing your service business.
 This Guide explains the regular sync activity between SME and QB. The sync can be done at any time. Most customers run the sync at the beginning or end of the day, however it can be run whenever needed.
@@ Line 30: / Line 30: @@
 #   Synchronizing SME and QB
 ##    Note: This will perform both an SME export and QB import. Since the SME export is performed first, records that are changed in both SME and QB will only get the SME changes.
-##   Note: QuickBooks .  will require you to log in to QuickBooks .  on the computer running SQLink. Log into QuickBooks . , SME, and SQLink and then run the sync. The user logging in to QuickBooks must have privilages that allow for the actions to be preformed by SQLink.
+##   Note: QuickBooks will require you to log in to QuickBooks on the computer running SQLink. Log into QuickBooks , SME, and SQLink and then run the sync. The user logging in to QuickBooks must have privilages that allow for the actions to be preformed by SQLink.
 === SME: ===
@@ Line 36: / Line 36: @@
 #   [[File:Sync1(1).jpg]]
 #    Answer ‘Ok’ to the prompt.
-#    Note if you do not have the option “Synchronize with QuickBooks . ”, or the menu option “Sync QuickBooks . ” then the initial import with QuickBooks .  has not occurred or has failed. Review the SQLink Install and Setup document or call contact High5 Software technical support at support@high5software.com
+#    Note if you do not have the option “Synchronize with QuickBooks”, or the menu option “Sync QuickBooks” then the initial import with QuickBooks  has not occurred or has failed. Review the SQLink Install and Setup document or call contact High5 Software technical support at support@high5software.com
 === SQLink: ===

@@ Line 6: / Line 6: @@
 # Run SQLink
 # In SQLink select one of the following:
-## For manual sync:
-### select Processes>Start Processes
+=== Manual sync: ===
-### From within SME select Tools>Synch QuickBooks.  Note this will only show for users with rights for QB sync.
+## select Processes>Start Processes
-## For automatic sync: In SQLink Select Processes>Auto Process
+## From within SME select Tools>Synch QuickBooks.  Note this will only show for users with rights for QB sync.
-### Be sure to set the sync time in File>Setup>Auto Process Timer.  Setting to about 5 for 5 mins is usually good.
 == Definitions: ==
@@ Line 39: / Line 42: @@
 #  [[File:sync3(1).jpg]]
 #    You will see SQLink starting the sync process.
 #   SQLink checks for sync requests about once every few minutes.
 #   The Sync is complete when you see the words ‘Payment Processing Complete’
 #   Note: If you encounter issues at this point it is most likely due to drive mappings that have been changed from the original sync.
 #   To check:
 ##   Open SQLink> File> Link Setup
 ##   Open QuickBooks . > F2
 ##   The paths for QuickBooks .  must match exactly.

@@ Line 2: / Line 2: @@
 SME to QuickBooks .  Link Synchronization Tool
-Overview:
+== Overview: ==
 # Run QuickBooks
 # Run SQLink
@@ Line 12: / Line 12: @@
 ### Be sure to set the sync time in File>Setup>Auto Process Timer.  Setting to about 5 for 5 mins is usually good.
-'''Definitions:'''
+== Definitions: ==
-<br>1)   QB: QuickBooks . ® by Intuit®
+#   QB: QuickBooks . ® by Intuit®
+#   SME: Service Management Professional (version 5) by High5 Software™
-<br>2)   SME: Service Management Professional (version 5) by High5 Software™
+#   SQLink: SME to QB synchronization program by High5 Software™
 SQLink is an add-on product to SME5 to synchronize SME and QB databases. SME handles sales, customers, service orders, and inventory while QuickBooks .  handles the accounting, payroll, and banking integration. SME and QB together make a very powerful combination for managing your service business.
@@ Line 25: / Line 23: @@
 For this guide, the initial sync between SME and QB must be completed. If you have not done the initial sync, Please review the SQLink Install and Setup document.
-'''Synchronization with SME and QB:'''
+== Synchronization with SME and QB: ==
-)   Synchronizing SME and QB
+#   Synchronizing SME and QB
+##    Note: This will perform both an SME export and QB import. Since the SME export is performed first, records that are changed in both SME and QB will only get the SME changes.
-<br>i.    Note: This will perform both an SME export and QB import. Since the SME export is performed first, records that are changed in both SME and QB will only get the SME changes.
+##   Note: QuickBooks .  will require you to log in to QuickBooks .  on the computer running SQLink. Log into QuickBooks . , SME, and SQLink and then run the sync. The user logging in to QuickBooks must have privilages that allow for the actions to be preformed by SQLink.
-'''SME:'''
+=== SME: ===
+#    Within SME, Tools> Sync QuickBooks . .
-<br>iii.    Within SME, Tools> Sync QuickBooks . .
+#   [[File:Sync1(1).jpg]]
+#    Answer ‘Ok’ to the prompt.
-<br>iv.   [[File:Sync1(1).jpg]]
+#    Note if you do not have the option “Synchronize with QuickBooks . ”, or the menu option “Sync QuickBooks . ” then the initial import with QuickBooks .  has not occurred or has failed. Review the SQLink Install and Setup document or call contact High5 Software technical support at support@high5software.com
-<br>xiii.    To check:
+=== SQLink: ===
-<br>1.   Open SQLink> File> Link Setup
+#   SQLink checks for sync requests about once every few minutes.
-<br>2.   Open QuickBooks . > F2
+#   Note: If you encounter issues at this point it is most likely due to drive mappings that have been changed from the original sync.
-<br>3.   The paths for QuickBooks .  must match exactly.
+##   Open SQLink> File> Link Setup