Initial Setup for SQLink

From High5Wiki
Jump to: navigation, search

'SQLink Installation and Setup'

SME to QuickBooks Link Synchronization Tool

Definitions:
1) QB: QuickBooks® by Intuit®
2) SME: Service Management Professional (version 5) by High 5 Software™
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 synchronization points review the Sync Points for SQLink page.

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.


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.


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.


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.


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:

  1. To an SME install with no prior data importing the QuickBooks data. (Referred to as an initial sync.)
  2. To an SME installation that has been used for running your business and a QuickBooks file that has also been used to run your business without synchronization. (An in place sync.)

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.

  1. SQLink will locate your open QuickBooks file.
  2. QuickBooks will open the Access Confirmation dialogue shown below.
  3. Note: on some versions of QuickBooks this will happen again at a later stage in the setup process.
  4. You will see the following screen in QuickBooks.
  5. QB1.png
  6. Click on ‘Yes’, always allow access even if QuickBooks is not running.
  7. Login as “Admin” (Note: Admin is the level required for SQLink to accesses QB. It is not the level users of SQLink access QB.)
  8. Check the “Allow this application to access personal data…” This will allow transfer of technician information to QuickBooks.
  9. Your settings should be as follows:

QB2.jpg
10. Click “Continue”.
11.You may get a certification warning. Click 'Yes' on this screen.
12.QB3.jpg
13.You will see the following QuickBooks screen:
QB4.jpg
14.Click “Done”.
15.SQLink will now be listed in the Integrated Applications List in QuicBooks.


Set Up For Initial QuickBooks Company


  1. SQLink will open with the Set up for Initial Company window.


2.QB5(1).jpg


3.The following set up options require attention:
4.Database name (Select Existing) field. Copy the database name from this field.
5.Company Name (Select Existing or Enter New) field. Paste the database name into this field.
6.QuickBooks Company File Location: Click the ellipse in the QuickBooks Company File location and browse to the location of your company file.
7.Note: You can obtain the QuickBooks Company file location by going to QuickBooks and pressing the ‘F2’ key. This will open the Product Information screen. The company file location is in the File Information block:


8.QB6.jpg


9.The paths must match exactly!
10.Note: On Vista and Newer operating systems you will be required to close QuickBooks before you can set the path. This is also true of Windows Server 2008.
11.Enter your Area Code
12.Select your Country. (Default is US.)
13.Enter your email address if you want error logs emailed
14.Select your QuickBooks year
15.Click ‘Ok’.
16.Note: On some operating systems you may need to repeat the above steps 2 times before QuickBooks will register the company file path.


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. 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.

SQLinkImportExport.png


  1. 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)
  2. 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)
  3. Billing Name Options: Default setting is Billing Name = Customer Name. For more info on this topic review the SQLink - Customers wiki page
  4. On Export: On Export settings cover Tech Time and Purchase Order options.
  5. 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)
  6. Purchase Order Options.
  7. Do Not Export Purchase Orders or Bills
  8. Export Purchase Orders Only – Bills will not export
  9. Export Purchase Orders & Bills
  10. 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.)
  11. Make your selections based on the above information and click ‘Next’.
  12. SQLink will import the following QuickBooks items:
  13. Pay Methods
  14. Sales Tax Codes
  15. Terms
  16. Classes
  17. Sales Reps
  18. Tax Code Groups
  19. Accounts
  20. Pay Items
  21. Discount Items
  22. Wage Items
  23. Employee List
  24. Vendor List
  25. Inventory List
  26. Non-Inventory List
  27. Service List
  28. Other Charges List
  29. Inventory Groups


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.

QB8.jpg


  1. Invoice Line Items – determines what shows on the invoice for Labor, Material, and Services. These items are ‘default’ items and will be passed on the invoice should an item that is only in SME, and not in QuickBooks, be used on an invoice. (Default settings are to Show Labor, Materials, and Service.)
  2. Line Item Order: Determines the order of information as it is exported to QuickBooks. (Usual setting is to keep Detail Order.)
  3. Other Options:
  4. Show Services Requested. (Usual option is to Not show Services Requested.)
  5. Show Services Preformed On Invoice. Usual option is To show Services Preformed.)
  6. Export Purchase Orders for Subcontractors:
  7. Use Invoice Reference Number:
  8. Export Bills for Subcontractors
  9. Use Invoice Reference Number
  10. Mark Invoice as ‘To Be Printed’ in QuickBooks
  11. Use ticket number for QuickBooks P.O. Number
  12. Show Technician Name in Labor Line Item
  13. Service Location:
  14. Show at Top
  15. Show with Charges
  16. Show at Bottom
  17. Service Location:
  18. Make your selections and press ‘Next’


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.

QB9.jpg

  1. Charge Buckets
  2. Travel Charges Bucket
  3. Premium Charges Bucket
  4. Other Charges Bucket
  5. Freight Charges Bucket
  6. Excise Charges Bucket
  7. Late Fees Bucket
  8. Credit Buckets
  9. Prepaid Used Bucket
  10. Discount Bucket
  11. Credit Bucket
  12. Refunds Bucket
  13. 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.

QB10.jpg

  1. Classes
  2. Labor Class
  3. Material Class
  4. Services Class
  5. Miscellaneous Accounts
  6. Time Tracking Service Item
  7. SMP Tax Code
  8. Wage Items
  9. Default Pay Wage Item
  10. Accounts
  11. Default Payment Receivable Account
  12. Default Payment Deposit Account
  13. Default Inventory Asset Account
  14. Default COGS Account
  15. Default Service Expense Account
  16. Default Sales Income Account
  17. Click ‘Finish’: SQLink will create SQLink default items named SMP_<Item name> in QuickBooks and then complete the importing process.


NOTE: The time required to process an initial import will depend on 2 factors:

1. Number of items in QuickBooks – Customer List, Item List, & Invoice/Payment list. Company files with a lot of information can take hours to process the initial import. Be prepared for this eventuality when starting the syncing process. 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:

  1. Creating Default Values
  2. Retrieving Tax Codes
  3. Creating SMP_tax item
  4. Retrieving QuickBooks Customers
  5. Retrieving Invoices and payments
  6. When the import is complete SQLink will return to the initial Setup tab; Import/Export Options.


SQLink Setup Screens Post Import:


Import/Export Options:

SQLinkImportExport.png


Invoice Options:

SQLinkInvoiceProposal.png

Payments and Credits:

QB13.jpg


Classes and Accounts Options:

SQLinkClassesAccounts.png


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.


Refer to the following Wiki page for information on processing a regular sync.

http://high5software.com/high5bitweaver/wiki/index.php?page=SQLink+Full+Sync+