Editing SQLink
Jump to navigation
Jump to search
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 1: | Line 1: | ||
+ | '''SQLink for QuickBooks: | ||
+ | ''' | ||
+ | |||
SME to QuickBooks Link Synchronization Tool | SME to QuickBooks Link Synchronization Tool | ||
Definitions: | Definitions: | ||
Line 10: | Line 13: | ||
*SME – Service Management Enterprise | *SME – Service Management Enterprise | ||
*SQLink – SME to QuickBooks Import- Export data engine. | *SQLink – SME to QuickBooks Import- Export data engine. | ||
− | *QuickBooks by Intuit – | + | *QuickBooks by Intuit – all versions from 2004 to the current year. (Note: We have encountered some issues syncing with unsupported versions of QuickBooks . Review the following link regarding Intuit Sunset policies. [http://support.quickbooks.intuit.com/support/pages/knowledgebasearticle/1003113] |
*QBFC – QuickBooks File Connector XML parsing engine. Runs behind the scenes. | *QBFC – QuickBooks File Connector XML parsing engine. Runs behind the scenes. | ||
The following information covers SME to QuickBooks Sync Points, SQLink Initial Setup, and a module list covering setup, optional settings, and troubleshooting common errors. | The following information covers SME to QuickBooks Sync Points, SQLink Initial Setup, and a module list covering setup, optional settings, and troubleshooting common errors. | ||
− | + | [[Sync Points for SQLink]] - Sync points between SME and QuickBooks | |
− | + | ||
+ | [[Initial Setup for SQLink]] - Running SQLink for the first time with your QuickBooks file | ||
+ | |||
+ | Performing the sync. The sync process can be performed in two ways: | ||
+ | <br>[[SQLink Full Sync]] - How to perform the full sync process. SME to QuickBooks and QuickBooks to SME. | ||
+ | |||
+ | |||
+ | Module Sync - How to perform a module by module import/export or manual sync. | ||
+ | |||
+ | |||
+ | QuickBooks lists have character length limitations. THe following page outlines the field length differences between SME and QuickBooks. | ||
+ | |||
+ | |||
+ | [[SQLink - QuickBooks Name Length limitations]] - QuickBooks Name Length Limitations. | ||
− | |||
− | + | The following details will be updated soon. | |
− | + | Sync details by module | |
+ | |||
+ | *[[SQLink - Customers]] - Customer syncing details | ||
+ | <br>*[[SQLink - Vendors]] - Vendor syncing details | ||
+ | <br>*[[SQLink - Employees and Technicians]] - Employee and Technician syncing details | ||
+ | <br>*((SQLink - Inventory)) - Inventory syncing details | ||
+ | <br>*((SQLink - Invoices)) - Invoice syncing details | ||
+ | <br>*((SQLink - Payments)) - Payment syncing details | ||
+ | <br>*((SQLink - Tech Time)) - Tech syncing details | ||
+ | <br>*((SQLink - Purchase Orders)) - Purchase Order syncing details | ||
+ | <br>*((SQLink - Subcontractor Bills and PO's)) Subcontractor syncing details | ||
+ | |||
+ | |||
+ | Troubleshouting errors by module | ||
+ | |||
+ | *((SQLink - Customers)) - Troubleshouting Customer errors | ||
+ | <br>*((SQLink - Vendors)) - Troubleshouting Vendor errors | ||
+ | <br>*((SQLink - Techs and Users)) - Troubleshouting Tech and User erors | ||
+ | <br>*((SQLink - Inventory)) - Troubleshouting Inventory errors | ||
+ | <br>*((SQLink - Invoices)) - Troubleshouting Invoicing errors | ||
+ | <br>*((SQLink - Payments)) - Troubleshouting Payment errors | ||
+ | <br>*((SQLink - Tech Time)) - Troubleshouting - Tech time entry errors | ||
+ | <br>*((SQLink - Purchase Orders)) - Troubleshouting - Purchase Order errors | ||
+ | <br>*((SQLink - Subcontractor Bills and PO's)) - Troubleshouting - Subcontractor Billing and Purchase Order errors | ||
+ | <br>*((SQLink - TroubleShooting Connection Issues)) - Troubleshooting Connection Issues with SQLink | ||
+ | |||
+ | == Sync Points for SQLink == | ||
+ | |||
+ | '''Sync Points Between SME and QuickBooks''' | ||
+ | |||
+ | 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™ | ||
+ | |||
+ | |||
− | |||
The following table lists the synchronization points between SME and QuickBooks modules. Refer to the SQLink for QuickBooks wiki pages for detailed syncing information. | The following table lists the synchronization points between SME and QuickBooks modules. Refer to the SQLink for QuickBooks wiki pages for detailed syncing information. | ||
{| | {| | ||
− | | class="xl65" style="width: 98pt; height: 14.3pt" width="130" height="19" | | + | | class="xl65" style="width: 98pt; height: 14.3pt" width="130" height="19" | Customers |
− | | class="xl67" style="width: 401pt" width="534" | | + | | class="xl67" style="width: 401pt" width="534" | Full two-way sync.� Customers can be added or modified in either SME or QuickBooks . |
|- style="height: 14.3pt" | |- style="height: 14.3pt" | ||
− | | class="xl65" style="height: 14.3pt" height="19" | | + | | class="xl65" style="height: 14.3pt" height="19" | Customer Balances |
− | | class="xl67" style="width: 401pt" width="534" | Full sync | + | | class="xl67" style="width: 401pt" width="534" | Full sync between SME and QuickBooks . |
|- style="height: 14.3pt" | |- style="height: 14.3pt" | ||
− | | class="xl65" style="height: | + | | class="xl65" style="height: 14.3pt" height="19" | Invoices from SME |
− | | class="xl67" style="width: 401pt" width="534" | | + | | class="xl67" style="width: 401pt" width="534" | Invoices in SME fully transfer to QuickBooks . |
|- style="height: 27.2pt" | |- style="height: 27.2pt" | ||
− | | class="xl65" style="height: 27.2pt" height="36" | | + | | class="xl65" style="height: 27.2pt" height="36" | Invoices from QB |
− | | class="xl67" style="width: 401pt" width="534" | | + | | class="xl67" style="width: 401pt" width="534" | QuickBooks invoice goes to SME for balance purposes, no detailed items are transferred. ( QuickBooks invoices cannot be edited in SME.) |
+ | |- style="height: 27.2pt" | ||
+ | | class="xl65" style="height: 27.2pt" height="36" | Payments | ||
+ | | class="xl67" style="width: 401pt" width="534" | Can enter payments in QuickBooks for SME invoices. Payments can also be applied in QuickBooks for SME invoices. QuickBooks invoices can only be paid QuickBooks . | ||
|- style="height: 14.3pt" | |- style="height: 14.3pt" | ||
− | | class="xl65" style="height: 14.3pt" height="19" | | + | | class="xl65" style="height: 14.3pt" height="19" | Tax Codes and Groups |
− | | class="xl67" style="width: 401pt" width="534" | | + | | class="xl67" style="width: 401pt" width="534" | Controlled by QuickBooks . Enter new tax codes in QuickBooks . |
|- style="height: 14.3pt" | |- style="height: 14.3pt" | ||
− | | class="xl65" style="height: 14.3pt" height="19" | | + | | class="xl65" style="height: 14.3pt" height="19" | Terms |
− | | class="xl67" style="width: 401pt" width="534" | | + | | class="xl67" style="width: 401pt" width="534" | Controlled by QuickBooks . Enter new terms in QuickBooks . |
|- style="height: 14.3pt" | |- style="height: 14.3pt" | ||
− | | class="xl65" style="height: 14.3pt" height="19" | | + | | class="xl65" style="height: 14.3pt" height="19" | Items in QB |
− | | class="xl67" style="width: 401pt" width="534" | | + | | class="xl67" style="width: 401pt" width="534" | Full sync of inventory, non-inventory, service, wage, and discount items. |
+ | |- style="height: 27.2pt" | ||
+ | | class="xl65" style="height: 27.2pt" height="36" | Items in SME | ||
+ | | class="xl67" style="width: 401pt" width="534" | Option to sync with QuickBooks or not.� If not synced with QuickBooks inventory will use a generic default item to transfer accounting information for invoicing and purchase orders. | ||
|- style="height: 14.3pt" | |- style="height: 14.3pt" | ||
| class="xl65" style="height: 14.3pt" height="19" | Inventory Groups | | class="xl65" style="height: 14.3pt" height="19" | Inventory Groups | ||
− | | class="xl67" style="width: 401pt" width="534" | SME Packages = QuickBooks Inventory Groups | + | | class="xl67" style="width: 401pt" width="534" | SME Packages = QuickBooks Inventory Groups. |
− | |||
− | |||
− | |||
|- style="height: 14.3pt" | |- style="height: 14.3pt" | ||
− | | class="xl65" style="height: 14.3pt" height="19" | | + | | class="xl65" style="height: 14.3pt" height="19" | Inventory Assemblies |
− | + | | class="xl67" style="width: 401pt" width="534" | Do not sync. | |
− | |||
− | |||
− | | class="xl67" style="width: 401pt" width="534" | | ||
|- style="height: 27.2pt" | |- style="height: 27.2pt" | ||
− | | class="xl65" style="height: 27.2pt" height="36" | | + | | class="xl65" style="height: 27.2pt" height="36" | Weekly Timesheet |
− | | class="xl67" style="width: 401pt" width="534" | | + | | class="xl67" style="width: 401pt" width="534" | SME labor item records sync with QuickBooks weekly time sheet.� Customer name and job number are transferred. Time sheets must be turned on in QuickBooks to use this feature. |
|- style="height: 14.3pt" | |- style="height: 14.3pt" | ||
− | | class="xl65" style="height: 14.3pt" height="19" | | + | | class="xl65" style="height: 14.3pt" height="19" | Wage Items |
− | | class="xl67" style="width: 401pt" width="534" | | + | | class="xl67" style="width: 401pt" width="534" | Synced from QuickBooks . |
|- style="height: 14.3pt" | |- style="height: 14.3pt" | ||
− | | class="xl65" style="height: 14.3pt" height="19" | | + | | class="xl65" style="height: 14.3pt" height="19" | Vendors |
− | | class="xl67" style="width: 401pt" width="534" | | + | | class="xl67" style="width: 401pt" width="534" | Full sync between SME and QuickBooks . |
|- style="height: 27.2pt" | |- style="height: 27.2pt" | ||
− | | class="xl65" style="height: 27.2pt" height="36" | | + | | class="xl65" style="height: 27.2pt" height="36" | Subcontractors |
− | | class="xl67" style="width: 401pt" width="534" | | + | | class="xl67" style="width: 401pt" width="534" | Sync of 1099 vendors as Subcontractors in SME. Vendors that are Subcontractors are initially setup in QuickBooks due to sensitive information that is only maintained in QuickBooks . |
|- style="height: 14.3pt" | |- style="height: 14.3pt" | ||
| class="xl65" style="height: 14.3pt" height="19" | Subcontractor Bills | | class="xl65" style="height: 14.3pt" height="19" | Subcontractor Bills | ||
− | | class="xl67" style="width: 401pt" width="534" | Subcontractors used on orders in SME can create a Bill in QuickBooks | + | | class="xl67" style="width: 401pt" width="534" | Subcontractors used on orders in SME can create a Bill in QuickBooks . |
|- style="height: 14.3pt" | |- style="height: 14.3pt" | ||
| class="xl65" style="height: 14.3pt" height="19" | Subcontractor PO | | class="xl65" style="height: 14.3pt" height="19" | Subcontractor PO | ||
− | | class="xl67" style="width: 401pt" width="534" | Subcontractors used on orders in SME can create a Purchase Order in QuickBooks. | + | | class="xl67" style="width: 401pt" width="534" | Subcontractors used on orders in SME can create a Purchase Order in QuickBooks . |
|- style="height: 14.3pt" | |- style="height: 14.3pt" | ||
− | | class="xl65" style="height: 14.3pt" height="19" | | + | | class="xl65" style="height: 14.3pt" height="19" | Purchase Orders (PO) |
− | | class="xl67" style="width: 401pt" width="534" | | + | | class="xl67" style="width: 401pt" width="534" | Optional sync with QuickBooks . Multiple syncing options. |
|- style="height: 27.2pt" | |- style="height: 27.2pt" | ||
− | | class="xl65" style="height: 27.2pt" height="36" | | + | | class="xl65" style="height: 27.2pt" height="36" | PO Bill |
− | | class="xl67" style="width: 401pt" width="534" | | + | | class="xl67" style="width: 401pt" width="534" | Syncs with QuickBooks when items are received. (Partial receipt increments the Bill in QuickBooks ). |
|- style="height: 27.2pt" | |- style="height: 27.2pt" | ||
− | | class="xl65" style="height: 27.2pt" height="36" | | + | | class="xl65" style="height: 27.2pt" height="36" | Employees |
− | | class="xl67" style="width: 401pt" width="534" | | + | | class="xl67" style="width: 401pt" width="534" | Sync to SME as technicians and users table. Employees are initially setup in QuickBooks due to sensitive information that is only maintained in QuickBooks . |
|- style="height: 14.3pt" | |- style="height: 14.3pt" | ||
− | | class="xl65" style="height: 14.3pt" height="19" | | + | | class="xl65" style="height: 14.3pt" height="19" | Class tracking |
− | | class="xl67" style="width: 401pt" width="534" | Full sync | + | | class="xl67" style="width: 401pt" width="534" | Full sync of class tracking on all modules. |
|- style="height: 14.3pt" | |- style="height: 14.3pt" | ||
− | | style="height: 14.3pt" height="19" | | + | | style="height: 14.3pt" height="19" | |
− | | class="xl67" style="width: 401pt" width="534" | | + | | class="xl67" style="width: 401pt" width="534" | Class can be assigned to Customer, Order, Item, etc.. |
|- style="height: 14.3pt" | |- style="height: 14.3pt" | ||
− | | class="xl65" style="height: 14.3pt" height="19" | | + | | class="xl65" style="height: 14.3pt" height="19" | Accounts |
− | | class="xl67" style="width: 401pt" width="534" | | + | | class="xl67" style="width: 401pt" width="534" | Synced for use of assigning accounts for item syncing only. |
|- style="height: 14.3pt" | |- style="height: 14.3pt" | ||
− | | class="xl65" style="height: 14.3pt" height="19" | | + | | class="xl65" style="height: 14.3pt" height="19" | Credit Memos |
− | | class="xl67" style="width: 401pt" width="534" | | + | | class="xl67" style="width: 401pt" width="534" | Synced from QuickBooks . (Need to be applied to an invoice.) |
|} | |} | ||
+ | |||
+ | |||
== Initial Setup for SQLink == | == Initial Setup for SQLink == | ||
+ | |||
+ | ''''''SQLink Installation and Setup'''''' | ||
+ | |||
+ | SME to QuickBooks Link Synchronization Tool | ||
+ | |||
+ | Definitions: | ||
+ | <br>1) QB: QuickBooks® by Intuit® | ||
+ | <br>2) SME: Service Management Professional (version 5) by High 5 Software™ | ||
+ | <br>3) SQLink: SME to QB synchronization program by High 5 Software™ | ||
SQLink is an add-on product to SME to synchronize SME and QB databases. For a complete list of the | SQLink is an add-on product to SME to synchronize SME and QB databases. For a complete list of the | ||
Line 109: | Line 169: | ||
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. | 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. | ||
+ | |||
+ | |||
'''READ OVER THIS DOCUMENT CAREFULLY.''' | '''READ OVER THIS DOCUMENT CAREFULLY.''' | ||
+ | |||
It is very critical that the interface between SME and QuickBooks is established properly for your business. The SQLink Wizard will fill in the necessary values as defaults. It is recommended that these values remain in place unless they conflict with your business operations. | It is very critical that the interface between SME and QuickBooks is established properly for your business. The SQLink Wizard will fill in the necessary values as defaults. It is recommended that these values remain in place unless they conflict with your business operations. | ||
+ | |||
Your initial synchronization must take place on the computer hosting the SME database! Please plan for a time when you can complete the process without interruption from other system demands. If on a networked system install the programs on your server. If you do not have a server, designate a system to host the database, and install the programs on that system. | Your initial synchronization must take place on the computer hosting the SME database! Please plan for a time when you can complete the process without interruption from other system demands. If on a networked system install the programs on your server. If you do not have a server, designate a system to host the database, and install the programs on that system. | ||
+ | |||
'''SME/SQLink, and QuickBooks''' must already be installed on the computer where you will run SQLink. If either of these programs is NOT installed, you must install the missing programs. SQLink installs with SME in the SME program folder. | '''SME/SQLink, and QuickBooks''' must already be installed on the computer where you will run SQLink. If either of these programs is NOT installed, you must install the missing programs. SQLink installs with SME in the SME program folder. | ||
+ | |||
'''Important''': QuickBooks must be updated before performing the initial sync! This may mean that you will have to perform the QuickBooks update on all other computers where QuickBooks has been installed. | '''Important''': QuickBooks must be updated before performing the initial sync! This may mean that you will have to perform the QuickBooks update on all other computers where QuickBooks has been installed. | ||
+ | |||
'''SME and QuickBooks:''' Must have company data filled in. If both SME and QuickBooks are installed and the QuickBooks company file has data, please proceed with these instructions. | '''SME and QuickBooks:''' Must have company data filled in. If both SME and QuickBooks are installed and the QuickBooks company file has data, please proceed with these instructions. | ||
+ | |||
'''Suggestion:''' It is recommended to start with copies, (sandbox copies) of SME and QuickBooks, rather than your live data until you get the synchronization settings established the way you need to match your business processes. Once all settings are correct and information is passing between the applications to your satisfaction you can setup a live sync with a fresh empty SME database. | '''Suggestion:''' It is recommended to start with copies, (sandbox copies) of SME and QuickBooks, rather than your live data until you get the synchronization settings established the way you need to match your business processes. Once all settings are correct and information is passing between the applications to your satisfaction you can setup a live sync with a fresh empty SME database. | ||
+ | |||
'''Advised:''' To avoid possible data issues it is advised you run the QuickBooks Verify and Backup utility prior to setting up SQLink and SME. | '''Advised:''' To avoid possible data issues it is advised you run the QuickBooks Verify and Backup utility prior to setting up SQLink and SME. | ||
+ | |||
There are two types of initial synchronizations: | There are two types of initial synchronizations: | ||
Line 132: | Line 202: | ||
If your installation falls under number 2 please contact High5Software prior to performing the initial sync as care must be taken to clean up data that may cause issues when syncing. | If your installation falls under number 2 please contact High5Software prior to performing the initial sync as care must be taken to clean up data that may cause issues when syncing. | ||
− | + | '''Initial sync to a newly installed SME application: | |
+ | ''' | ||
SQLink will install with SME in the SME program folder. | SQLink will install with SME in the SME program folder. | ||
Line 154: | Line 225: | ||
− | + | '''Set Up For Initial QuickBooks Company''' | |
#SQLink will open with the Set up for Initial Company window. | #SQLink will open with the Set up for Initial Company window. | ||
− | <br>2.[[File: | + | <br>2.[[File:QB5(1).jpg]] |
<br>3.The following set up options require attention: | <br>3.The following set up options require attention: | ||
Line 179: | Line 250: | ||
− | + | '''SQLink - Initial Setup''' | |
+ | |||
Refer to the following steps to set SQLink options and complete the initial sync. Options and settings for the Initial Setup can also be configured after the initial sync. For detailed information on the implications of specific settings refer to the appropriate Wiki page. | Refer to the following steps to set SQLink options and complete the initial sync. Options and settings for the Initial Setup can also be configured after the initial sync. For detailed information on the implications of specific settings refer to the appropriate Wiki page. | ||
Line 185: | Line 257: | ||
On Import:''' On import settings cover SQLink functionality when importing information from QuickBooks for Invoices and Payments, Inactive Customers, Next Invoice Number, and Billing Name Options. | On Import:''' On import settings cover SQLink functionality when importing information from QuickBooks for Invoices and Payments, Inactive Customers, Next Invoice Number, and Billing Name Options. | ||
− | [[File: | + | [[File:QB7.jpg]] |
+ | |||
# '''Merge unmatched invoices and payments:''' Check this box to match QuickBooks invoices and payments. Leaving it unchecked will not import payment information from QuickBooks. (The usual setting is checked) | # '''Merge unmatched invoices and payments:''' Check this box to match QuickBooks invoices and payments. Leaving it unchecked will not import payment information from QuickBooks. (The usual setting is checked) | ||
# '''Skip inactive customers on import/export:''' Checking this box will keep SQLink from importing or exporting inactive customers. Since both SME and QuickBooks are programmed to work with inactive customers it is recommended that you do not check this option. (Usual status is Unchecked) | # '''Skip inactive customers on import/export:''' Checking this box will keep SQLink from importing or exporting inactive customers. Since both SME and QuickBooks are programmed to work with inactive customers it is recommended that you do not check this option. (Usual status is Unchecked) | ||
− | # '''Billing Name Options:''' Default setting is Billing Name = Customer Name. For more info on this topic review [[ | + | # '''Billing Name Options:''' Default setting is Billing Name = Customer Name. For more info on this topic review the SQLink Customer wiki page at: [[http://high5software.com/high5bitweaver/wiki/index.php?page=SQLink+-+Customers]] |
# ''' On Export:''' On Export settings cover Tech Time and Purchase Order options. | # ''' On Export:''' On Export settings cover Tech Time and Purchase Order options. | ||
# ''' Include SMP items on Purchase Order:''' This option will pass the default SQLink item for that actual item used in QuickBooks if the item does not exist in QuickBooks. (Usual setting is Checked) | # ''' Include SMP items on Purchase Order:''' This option will pass the default SQLink item for that actual item used in QuickBooks if the item does not exist in QuickBooks. (Usual setting is Checked) | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
# ''' Purchase Order Options.''' | # ''' Purchase Order Options.''' | ||
# Do Not Export Purchase Orders or Bills | # Do Not Export Purchase Orders or Bills | ||
Line 207: | Line 270: | ||
# Export Purchase Orders & Bills | # Export Purchase Orders & Bills | ||
# ''' Export Bills Only:''' Since Purchase Orders require further action to tie them to Bills in QuickBooks the Bill is the method of inventory adjustment in QuickBooks. (This is the recommended setting.) | # ''' Export Bills Only:''' Since Purchase Orders require further action to tie them to Bills in QuickBooks the Bill is the method of inventory adjustment in QuickBooks. (This is the recommended setting.) | ||
− | |||
− | |||
#Make your selections based on the above information and click ‘Next’. | #Make your selections based on the above information and click ‘Next’. | ||
− | |||
− | |||
#SQLink will import the following QuickBooks items: | #SQLink will import the following QuickBooks items: | ||
# Pay Methods | # Pay Methods | ||
Line 232: | Line 291: | ||
− | + | '''Initial Setup''' - Invoice Options: Options on this screen determine how invoices export from SME to QuickBooks. These options can be changed after the initial import. | |
− | Invoice Options: Options on this screen determine how invoices export from SME to QuickBooks. These options can be changed after the initial import. | ||
− | [[File: | + | [[File:QB8.jpg]] |
Line 258: | Line 316: | ||
− | + | Initial Setup - Payment and Charge Buckets: Options on this screen determine which accounts SQLink will use for the following items. You do not need to select any settings at this time as these will be filled in by the SQLink initial setup wizard. | |
− | Options on this screen determine which accounts SQLink will use for the following items. You do not need to select any settings at this time as these will be filled in by the SQLink initial setup wizard. | ||
− | [[File: | + | [[File:QB9.jpg]] |
# Charge Buckets | # Charge Buckets | ||
Line 277: | Line 334: | ||
# Click ‘Next’. | # Click ‘Next’. | ||
− | + | Initial Setup - Classes & Miscellaneous: Options on this screen determine how default classes, time tracking accounts, wage item, and other accounts will pass information. This information will be filled in automatically when the wizard completes the import process. | |
− | Options on this screen determine how default classes, time tracking accounts, wage item, and other accounts will pass information. This information will be filled in automatically when the wizard completes the import process. | ||
− | [[File: | + | [[File:QB10.jpg]] |
# Classes | # Classes | ||
Line 306: | Line 362: | ||
2. System resources available to QuickBooks during the sync. If you are running the sync on a system with marginal memory or one that is short on disk space there will be a significant impact on the time required to process the initial sync. | 2. System resources available to QuickBooks during the sync. If you are running the sync on a system with marginal memory or one that is short on disk space there will be a significant impact on the time required to process the initial sync. | ||
− | + | '''SQLink will complete the following tasks:''' | |
# Creating Default Values | # Creating Default Values | ||
Line 316: | Line 372: | ||
− | + | '''SQLink Setup Screens Post Import:''' | |
Import/Export Options: | Import/Export Options: | ||
− | |||
+ | [[File:QB11.jpg]] | ||
+ | |||
+ | |||
Invoice Options: | Invoice Options: | ||
− | <br>[[File: | + | <br>[[File:QB12.jpg]] |
Payments and Credits: | Payments and Credits: | ||
− | + | ||
+ | [[File:QB13.jpg]] | ||
Classes and Accounts Options: | Classes and Accounts Options: | ||
− | + | ||
+ | [[File:QB14.jpg]] | ||
The Initial Sync is complete. Close all programs, SME, SQLink, and QuickBooks, and reopen them to process the first regular sync. | The Initial Sync is complete. Close all programs, SME, SQLink, and QuickBooks, and reopen them to process the first regular sync. | ||
Note: This sync can also take a considerable length of time since status flags are initialized on all imported items. QuickBooks is not required to be in ‘Single User’/Admin mode for this sync. | Note: This sync can also take a considerable length of time since status flags are initialized on all imported items. QuickBooks is not required to be in ‘Single User’/Admin mode for this sync. | ||
+ | |||
+ | |||
+ | Refer to the following Wiki page for information on processing a regular sync. | ||
+ | |||
+ | http://high5software.com/high5bitweaver/wiki/index.php?page=SQLink+Full+Sync+ | ||
+ | |||
+ | |||
+ | |||
+ | == SQLink Full Sync == | ||
+ | |||
+ | <h4>SQLink Regular Sync Guide</h4> | ||
+ | SME to QuickBooks . Link Synchronization Tool | ||
+ | |||
+ | '''Definitions:''' | ||
+ | <br>1) QB: QuickBooks . ® by Intuit® | ||
+ | |||
+ | <br>2) SME: Service Management Professional (version 5) by High5 Software™ | ||
+ | |||
+ | <br>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 | ||
+ | |||
+ | <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. | ||
+ | |||
+ | <br>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:''' | ||
+ | |||
+ | <br>iii. Within SME, Tools> Sync QuickBooks . . | ||
+ | <br>iv. [[File:Sync1(1).jpg]] | ||
+ | <br>v. Answer ‘Ok’ to the prompt. | ||
+ | <br>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: | ||
+ | <br>vii. Next start processing in SQLink by selecting Processing>Start Processes | ||
+ | <br>ix. [[File:sync3(1).jpg]] | ||
+ | <br>x. You will see SQLink starting the sync process. | ||
+ | <br>1. SQLink checks for sync requests about once every few minutes. | ||
+ | <br>2. The Sync is complete when you see the words ‘Payment Processing Complete’ | ||
+ | <br>xi. Note: | ||
+ | <br>xii. If you encounter issues at this point it is most likely due to drive mappings that have been changed from the original sync. | ||
+ | <br>xiii. To check: | ||
+ | |||
+ | <br>1. Open SQLink> File> Link Setup | ||
+ | <br>2. Open QuickBooks . > F2 | ||
+ | <br>3. The paths for QuickBooks . must match exactly. | ||
+ | |||
+ | |||
== SQLink - QuickBooks Name Length Limitations == | == SQLink - QuickBooks Name Length Limitations == | ||
+ | |||
+ | '''Definitions:''' | ||
+ | |||
+ | # QB: QuickBooks . ® by Intuit® | ||
+ | # SME: Service Management Professional (version 5) by High5 Software™ | ||
+ | # SQLink: SME to QB synchronization program by High5 Software™ | ||
The following list outlines QuickBooks field name length limits. In general SME will allow longer names than QuickBooks. If you make a field entry longer than that allowed by QuicBooks SQLink will return an error. | The following list outlines QuickBooks field name length limits. In general SME will allow longer names than QuickBooks. If you make a field entry longer than that allowed by QuicBooks SQLink will return an error. | ||
Line 357: | Line 478: | ||
<td>80</td> | <td>80</td> | ||
<td>40</td> | <td>40</td> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
</tr> | </tr> | ||
<tr> | <tr> | ||
Line 422: | Line 538: | ||
<td>20</td> | <td>20</td> | ||
<td>30</td> | <td>30</td> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
</tr> | </tr> | ||
<tr> | <tr> | ||
Line 575: | Line 666: | ||
</table> | </table> | ||
− | |||
− | |||
− | |||
− | + | == Sync Details by Module == | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | < | + | <h3>Customers</h3> |
− | + | '''Customer Sync:''' | |
− | |||
− | |||
− | |||
− | + | '''Definitions:''' | |
− | + | <br>1) QB: QuickBooks® by Intuit® | |
− | + | <br>2) SME: Service Management Professional (version 5) by High 5 Software™ | |
− | + | <br>3) SQLink: SME to QB synchronization program by High 5 Software™ | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | <br> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | 1) | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | <br> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | <br> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
+ | '''Customers:''' | ||
+ | <br>Customer syncing is bi-directional when using SQLink. Customer can be modified in either SME or QuickBooks and those changes will update the other application. As is always the case there will be some instances where the update cannot take place as expected. This will only happen when exporting SME changes to QuickBooks. For more information refer to the Customer errors & troubleshooting pages. | ||
+ | <br>'''Note:''' If you are syncing SME with a QuickBooks company file that has the same customer list you will need to contact High5 Software to setup a test sync and address all issues prior to going ‘live’ with the sync. | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
'''Terms:''' | '''Terms:''' | ||
Line 725: | Line 702: | ||
− | + | '''Mandatory steps for adding new customers:''' | |
+ | |||
A best practice is to Always fill out ‘ALL’ information when setting up new records as this will avoid unnecessary errors when syncing invoices. | A best practice is to Always fill out ‘ALL’ information when setting up new records as this will avoid unnecessary errors when syncing invoices. | ||
− | + | ||
+ | '''The following Fields will sync:''' | ||
+ | |||
<br>Customer Name - QuickBooks | <br>Customer Name - QuickBooks | ||
<br>Account Number – QuickBooks or SME | <br>Account Number – QuickBooks or SME | ||
Line 743: | Line 723: | ||
− | + | '''Customer Taxes:''' | |
+ | |||
Review the customer tax setup after creating the customer regardless of the application. If you create the customer in QuickBooks review the tax and set it to the appropriate taxing authority. | Review the customer tax setup after creating the customer regardless of the application. If you create the customer in QuickBooks review the tax and set it to the appropriate taxing authority. | ||
<br>'''Note:''' (QuickBooks uses a dummy tax as the default when syncing with integrated applications.) | <br>'''Note:''' (QuickBooks uses a dummy tax as the default when syncing with integrated applications.) | ||
Line 751: | Line 732: | ||
− | + | '''SQLink Billing Options:''' | |
− | - Open SQLink and go to | + | <br>- Open SQLink and go to File> Setup |
− | <br>- Click | + | <br>- Click Edit |
− | <br>- You will see the following | + | <br>- You will see the following for Billing address export options: |
− | <br>[[File:Billing.jpg]] | + | <br>- [[File:Billing.jpg]] |
+ | <br>- Option one – Billing Name = Customer Name: | ||
+ | <br>- Billing Name = Customer Name | ||
+ | * The Billing name in SME will be matched to the ‘Customer Name’ from QuickBooks.<br>- Billing Name = Company Name | ||
+ | * The Billing Name will be matched to the ‘Company Name’ from QuickBooks.<br>- Billing Name = First Line of Billing Address | ||
+ | * The Billing Name in SME will be matched to the First Line’ of the Billing Address Block. (This is because QuickBooks does not actually treat this as a company name field. They treat it as list of 5 address fields.)<br>- Use Parent Billing Name for non billable companies. | ||
+ | * A non billable company is one that has the ‘Is Billable’ flag unchecked in SME. If this is unchecked the option that is chosen above will be used for the Billing Address. | ||
− | + | <h3>Vendors</h3> | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | <h3> | ||
− | |||
− | |||
− | |||
− | |||
Vendor syncing is bi-directional when using SQLink with the exception of the 1099 setting. Vendors can be modified in either SME or QuickBooks and those changes will update the other application. As is always the case there will be some instances where the update cannot take place as expected. This will only happen when exporting SME changes to QuickBooks. For more information refer to the Vendor errors & troubleshooting pages. | Vendor syncing is bi-directional when using SQLink with the exception of the 1099 setting. Vendors can be modified in either SME or QuickBooks and those changes will update the other application. As is always the case there will be some instances where the update cannot take place as expected. This will only happen when exporting SME changes to QuickBooks. For more information refer to the Vendor errors & troubleshooting pages. | ||
'''Note''': If you are syncing SME with a QuickBooks company file that has the same vendor list you will need to contact High5 Software to setup a test sync and address all issues prior to going ‘live’ with the sync. | '''Note''': If you are syncing SME with a QuickBooks company file that has the same vendor list you will need to contact High5 Software to setup a test sync and address all issues prior to going ‘live’ with the sync. | ||
+ | |||
+ | '''Terms:''' | ||
<br>Initial Sync: refers to the initial import of QuickBooks lists into SME | <br>Initial Sync: refers to the initial import of QuickBooks lists into SME | ||
− | + | Routine Sync: refers to syncing per the users business requirements and can be performed at any time. | |
− | + | Module Sync: refers to using the SQLink Data Functions Module sync to move SME information to QuickBooks. | |
'''Syncing:''' | '''Syncing:''' | ||
<br>Initial sync: The initial sync of SME and QuickBooks will bring all vendor records from QuickBooks to SME. | <br>Initial sync: The initial sync of SME and QuickBooks will bring all vendor records from QuickBooks to SME. | ||
− | + | Routine Sync: Once a vendor is synchronized between SME and QuickBooks, changes can be made in either SME or QuickBooks and the changes will be reflected in the other program with the exception of the 1099 setting. Note: The SME data is exported/synced first, so in the rare case that a record is changed in both SME and QuickBooks, the SME changes will take place and the QuickBooks changes will be overwritten. | |
− | |||
'''Guidelines:''' | '''Guidelines:''' | ||
<br>It is a best practice to enter new vendors in one application as this will minimize the chance of duplication. | <br>It is a best practice to enter new vendors in one application as this will minimize the chance of duplication. | ||
− | + | Do not enter Vendor names in SME in excess of 40 characters. (This is a QuickBooks limit). This shows in SQLink as an error on importing. | |
'''Mandatory steps for adding new Vendors:''' | '''Mandatory steps for adding new Vendors:''' | ||
Line 806: | Line 776: | ||
<br>Terms – QuickBooks or SME | <br>Terms – QuickBooks or SME | ||
− | + | '''Vendor 1099 or Sub Contractor:''' | |
<br> 1099(QB) or Subcontractor(SME) settings are set in QuickBooks and synced to SME. Once the initial setting is synced it is a manual setting in either program should you change the setting. | <br> 1099(QB) or Subcontractor(SME) settings are set in QuickBooks and synced to SME. Once the initial setting is synced it is a manual setting in either program should you change the setting. | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | + | <h3>Employees and Technicians</h3> | |
− | < | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | < | ||
− | |||
− | |||
− |