Overview
OPTIONAL: If your Sugar Instance is on a local server on your local network AND the computer that will be used to run the QuickBooks Web Connector is ALSO on the same local network, AND if you do NOT want to use an encrypted/secure SSL connection between Sugar and the Web Connector, please see the section Using the Integration Without SSL. Follow those steps, then return here to continue.
IMPORTANT: If you do not want to use SSL, you MUST complete the steps in the How to use the QuickBooks Desktop integration without SS guide before continuing.
Table of Contents
1. Configuring the Integration - Introduction
2. Integration Information Tab
1. Configuring the Integration - Introduction
Navigate to the Admin screen, scroll to the bottom, and click on the QuickBooks Integration Configuration.
Note: If you see a blank page or an error instead of the QuickBooks Integration Configuration just click on the back button in your browser and the QuickBooks Integration Configuration page should load.
The QuickBooks Integration Configuration page has four tabs:
- Integration Information
- Configuration
- Advanced Configuration
- Advanced Functions
2. Integration Information Tab
1. In the Integration Information tab enter the FBSG QuickBooks Integration Product Key then click the Update Key button to activate the integration.
When the product key has been verified the key’s expiration date will appear.
2. In the QuickBooks Web Connector Set-Up section of the Integration Configuration tab click on the Download Set-Up File button to download the Web Connector file.
Note: If you are using Internet Explorer you may have trouble downloading the Set-Up file due to a bug in IE. You can use any other browser such as Chrome, Firefox, Safari, or Opera to download the file.
3. Take note of the Web Connector Password as you will be required to enter this password into the Web Connector in order to authenticate the QuickBooks Integration.
Note: You will only need to enter this password once into the Web Connector. If for any reason the password has been cleared out in the Web Connector you may go back to this page and retrieve the password again.
4. The Integration Information tab also keeps track of all the total quantity of records synced between Sugar and QuickBooks as well as the last sync start and end times and the duration of the last sync
Note: The Unmatched QuickBooks Customers total will show you if there were any customers from QB that did not find a match in Sugar (this will only work when the new Account creation feature is turned off).
5. By default the Quick Integration is set up to work out of the box and does not require any further configuration in order to work.
However, please review the default settings and make any necessary changes before installing the QuickBooks Web Connector.
3. Configuration Tab
Click on the Configuration tab, there are four sections of settings within this tab:
A. Master System Using
B. QuickBooks Canada
C. Enable/Disable Syncs
A. Master System: This dropdown menu will set the “Master” data source. By default, it is set to QuickBooks. This means that for Accounts/Customers syncs the data FROM QuickBooks will OVERWRITE the data in Sugar. You may want to change the Master System to Sugar.
If the Master System is set to Sugar then this means for Accounts/Customers syncs the data FROM Sugar will OVERWRITE the data in QuickBooks.
Note: The integration can be set up to create new accounts/customers in both Sugar and in QuickBooks if the account/customer does not exist in both systems. This will be discussed later in the Advanced Configuration tab section.
B. Using QuickBooks Canada: Check this checkbox if you are using QuickBooks Canada. By default this checkbox is unchecked.
C. Enable/Disable Syncs: In this section, there are many options on what information you want to have synced between Sugar and QuickBooks. The most important sync is the Accounts ↔ Customers sync which if unchecked will grey out all the options because the other options depend on the Accounts/Customers sync.
Note: Pay careful attention to the arrows in this section as they designate the direction of the sync. I.e. Account ← Vendors will sync Vendor information from QuickBooks to Sugar.
If you are satisfied with the settings selected you may proceed to the Installing QuickBooks Web Connector section otherwise please continue to the rest of the configuration settings
4. Advanced Configuration Tab
It is HIGHLY recommended that you keep the default settings in the Advanced Configuration tab!
Each option in the Advanced Configuration tab has a description as to how that setting will affect the integration and many of the options/settings have warnings or notes to better help you decide what decisions to make. While you can view these in the Advanced Configuration tab they will also be covered below.
All of the options are divided into sub-tabs that organize them based on what module in Sugar or QB they will affect.
You can continue to the next section on the Advanced Functions Tab if you do not need to change any of the advanced settings.
The settings are currently grouped into the following four sub-tabs:
A. Customers
B. Vendors
C. Quotes
D. Misc.
A. Customer Settings
1. Create New Accounts in Sugar from QuickBooks: If this is checked/enabled when no sync-key match is found while syncing Customers from QuickBooks to Sugar, a new Sugar Account is created. Uncheck this box to prevent QuickBooks from creating new Accounts in Sugar, only allowing it to keep pre-existing Accounts in sync.
Warning: If this box is unchecked, only Accounts/Customers that exist in both Sugar and QuickBooks will be synced. No new Accounts will be created from QuickBooks’ Customers.
2. Filter QuickBooks Customer Import by Field: Filter QuickBooks Customers based on the following field and value. Any QB Customers whose field specified here does not match the value specified here will not be imported into Sugar.
Note: If you have “Create New Accounts in Sugar From QuickBooks” disabled, this setting will do nothing.
3. Sync Inactive QuickBooks Customers to Sugar: If this is checked/enabled, in addition to the “Create New Accounts in Sugar From QuickBooks” option, Inactive QuickBooks Customers will be synced to Sugar Accounts. If this option is disabled and/or the “Create New Accounts in Sugar From QuickBooks” option is disabled, then Inactive QuickBooks Customers will not sync to Sugar.
4. Create New Customers in QuickBooks From Sugar: If this is checked/enabled when no sync-key match is found while syncing Accounts from Sugar to QuickBooks, a new QuickBooks Customer is created. Uncheck this box to prevent Sugar from creating new Customers in QuickBooks, only allowing it to keep preexisting Customers in sync.
Warning: If this box is unchecked, only Customers/Accounts that exist in both Sugar and QuickBooks will be synced. No new Customers will be created from Sugar’s Accounts
5. Sugar Account Type that Trigger Export to QuickBooks: Accounts with this Account Type will be brought over to QuickBooks (if you have enabled the “Create New QuickBooks Customers From Sugar Accounts” check box option).
Warning: Leaving this blank will cause all Sugar Accounts to be brought over into QuickBooks.
6. Use “Send to QB” Checkbox on Accounts to Trigger Export to QB: Accounts with this checkbox checked off on the Account will be sent over to QuickBooks (if you have enabled the “Create New QuickBooks Customers From Sugar Accounts” check box option). If you have set the Account Type Filter above as well, then an Account will both need to have this checkbox checked off and the above Account Type in order to trigger the sync to QuickBooks.
7. Account/Customer-Sync Key: This is what links Sugar Accounts to QuickBooks Customers. The default is an email address.
Warning: Setting this incorrectly will cause problems with the syncs. If set incorrectly, duplicate accounts/customers will be created in Sugar and/or QuickBooks, which can cause bad data to be entered into QuickBooks, and potentially cause other issues.
8. Append Random Number to QuickBooks Customer Name: Appends a random number to the QuickBooks name of newly created Customer records during syncs from Sugar.
Warning: Setting this incorrectly can cause syncing issues. This random number is usually required in order to ensure there are no naming conflicts within QuickBooks.
9. Prepend Account Name to QuickBooks Customer Address Line: Accounts with this checkbox checked off on the Account will have the Account Name added to the first QuickBooks Customer Address Line.
Warning: Setting this while mapping all four street address lines will result in the loss of data in the last street address line.
10. Ignore Jobs to Accounts Import: If this is checked/enabled, QuickBooks Jobs will be ignored during the Customer to Account sync, and Accounts will not be created for Jobs.
B. Vendor Settings
1. Create New Accounts in Sugar From QuickBooks Vendors: If this is checked/enabled when no sync-key match is found while syncing Vendors from QuickBooks to Sugar, a new Sugar Account is created. Uncheck this box to prevent QuickBooks from creating new Accounts in Sugar from QuickBooks Vendors, only allowing it to keep pre-existing Accounts and Vendors in sync.
Warning: If this box is unchecked, only Accounts/Vendors that exist in both Sugar and QuickBooks will be synced. No new Accounts will be created from QuickBooks’ Vendors.
2. Sync Inactive QuickBooks Vendors to Sugar: If this is checked/enabled, in addition to the “Create New Accounts in Sugar From QuickBooks Vendors” option, Inactive QuickBooks Vendors will be synced to Sugar Accounts. If this option is disabled and/or the “Create New Accounts in Sugar From QuickBooks Vendors” option is disabled, then Inactive QuickBooks Vendors will not sync to Sugar.
3. Account/Vendor-Sync Key: This is what links Sugar Accounts to QuickBooks Vendors. The default is an email address. Warning: Setting this incorrectly will cause problems with the syncs. If set incorrectly, duplicate Accounts will be created in Sugar, can cause bad data to be entered into QuickBooks, and potentially cause other issues
C. Quote Settings
1. Set QB Sales Rep from Quote?: If you want to set the QB Sales Rep from a Sugar Quote you will have to have the Sales Rep Sync enabled and a related field between the Quotes and the Sales Rep module This integration comes with a standard Sales Rep field, but if you have already set one up then you can use that one by changing the field in the dropdown.
Note: that you will need to choose the ID field, not the name field of the related field).
2. Quote Shipping Field Mapped to QB Product: The selected product will be mapped to the Quote Shipping field, so it will appear on exported Invoices, Sales Orders, and Estimates in QuickBooks from Sugar.
3. Automatic Quote Line-Item Price Calculation from QuickBooks Price Lists: Whether or not to automatically set the unit price for Sugar Quote line items based on price lists synced from QB. Checking this box will automatically set the unit price of Quote-line items from synced price lists; however, order entry operators may still override the prices on a line-by-line basis.
4. Require Supervisor Approval for Price Changes on Quote Line Items: If this option is enabled, the Quotes page will restrict line item price changes made by order entry operators. All price changes will require a supervisor to enter their approval on the Quote before the change can be finalized and the Quote sent to QuickBooks. This prevents order entry operators from, for example, giving customers large discounts or mark-ups that conflict with the price level lists for that Account.
5. Send Email to Sales Manager Upon Quote Line-Item Price Change (Checkbox): Whether or not to automatically send an email to a sales manager when an order entry operator changes the price of a line item from the price automatically calculated from the price lists synced from QuickBooks.
6. Send Email to Sales Manager Upon Quote Line-Item Price Change (Textbox): If the “Enable Automatic Email on Line-Item Price Change” checkbox has been checked then enter an email of the Sales Manager.
7. Sync Inactive QuickBooks Items to Sugar: If this is checked/enabled, in addition to the “Product Catalog ← Items” option, Inactive QuickBooks Items will be synced to Sugar Product Catalog. If this option is disabled and/or the “Product Catalog ← Items” option is disabled, then Inactive QuickBooks Items will not sync to Sugar.
8. Lock Terms to the Account’s Terms: If this is checked/enabled, Quote terms will be locked in the value in the Account’s Term field.
9. Disable sending of Billing and Shipping Addresses: If this is checked/enabled, no addresses will be sent with a quote.
10. Filter QuickBooks Items Import by Field: Filter QuickBooks Items based on the following field and value. Any QB Items whose field specified here does not match the value specified here will not be imported into Sugar.
Note: If you have “Create New Items in Sugar From QuickBooks” disabled, this setting will do nothing.
D. Misc. Settings
1. Sync Items & Product Catalog By Name: Whether or not to match up Items in QuickBooks with Product Catalog entries in SugarCRM by name. If checked, then any items that exist in both systems at the time of sync which has not been synced before, and have the exact same product name, will be synced with each other and have a permanent link created between them.
Note: Unchecking this will simply create new Product Catalog entries in SugarCRM for all items in QuickBooks.
2. Sync Inactive QuickBooks Items to SugarCRM: If this is checked/enabled, in addition to the “Product Catalog ← Items” option, Inactive QuickBooks Items will be synced to SugarCRM Product Catalog. If this option is disabled and/or the “Product Catalog ← Items” option is disabled, then Inactive QuickBooks Items will not sync to SugarCRM.
3. Filter QuickBooks Items Import by Field: Filter QuickBooks Items based on the following field and value. Any QB Items whose field specified here does not match the value specified here will not be imported into SugarCRM. Note: If you have “Create New Items in SugarCRM From QuickBooks” disabled, this setting will do nothing.
4. Max Record Per Sync Batch: The maximum number of records to pull from QuickBooks per sync batch. Warning: Setting this incorrectly could cause syncs to fail. 50 is a good value, but some servers may require a lower value (down to a minimum of 1). The lower this number, the longer each sync will take.
5. Advanced Functions Tab
Note: Be VERY careful when using any of the Advanced Functions as they can: affect the performance of the Sugar while the function is running, change your custom settings, etc.
There are many functions in the Advanced Function tab, each option has a description as to what each function does. Many of the functions have warnings or notes to help you better understand what decisions to make. While you can view these in the Advanced Functions tab they will also be covered below.
All of the functions are divided into sub-tabs to better organize them These tabs are:
A. Sync Dates
B. Special Functions
If you are already familiar with this section (or you want to skip it for now) then you can continue to the next guide on How to install The QuickBooks Web Connector.
A. Sync Dates
1. Import Sync Customers Since: Import Customers from QuickBooks into Sugar if they have been modified since this date (UTC format).
Warning: Setting this value in the past will force Customer records to sync which may have not changed since the last sync. Setting this value far into the past (1983, for example) will cause all Customers to sync again.
Note: If Sugar is the Master System, then this setting will not have any effect.
2. Export Sync Accounts Since: Export Accounts from Sugar into QuickBooks if they have been modified since this date (UTC format). Warning: Setting this value in the past will force Account records to sync which may have not changed since the last sync. Setting this value far into the past (1983, for example) will cause all Accounts to sync again.
Note: If QuickBooks is the Master System, then this setting will not have any effect.
3. Import Sync Vendors Since: Import Vendors from QuickBooks into Sugar if they have been modified since this date (UTC format). Warning: Setting this value in the past will force Vendor records to sync which may have not changed since the last sync. Setting this value far into the past (1983, for example) will cause all Vendors to sync again.
4. Import Invoices/Receipts Since: Import Invoices/Receipts from QuickBooks into Sugar if they have been modified since this date (UTC format). Warning: Setting this value in the past will force Invoice/Receipt records to sync which may have not changed since the last sync. Setting this value far into the past (1983, for example) will cause all Invoices/Receipts to sync again.
5. Import Credit Memos Since: Import Credit Memos from QuickBooks into Sugar if they have been modified since this date (UTC format). Warning: Setting this value in the past will force Credit Memo records to sync which may have not changed since the last sync. Setting this value far into the past (1983, for example) will cause all Credit Memos to sync again.
6. Import Purchase Orders Since: Import Purchase Orders from QuickBooks into Sugar if they have been modified since this date (UTC format). Warning: Setting this value in the past will force Purchase Orders records to sync which may have not changed since the last sync. Setting this value far into the past (1983, for example) will cause all Purchase Orders to sync again.
7. Import Items Since: Import Items from QuickBooks into Sugar if they have been modified since this date (UTC format). Warning: Setting this value in the past will force Items records to sync which may not have changed since the last sync. Setting this value far into the past (1983, for example) will cause all Items to sync again.
8. Import Product Price Levels Since: Import Product Price Levels from QuickBooks into Sugar if they have been modified since this date (UTC format). Warning: Setting this value in the past will force Product Price Level records to sync which may have not changed since the last sync. Setting this value far into the past (1983, for example) will cause all Product Price Levels to sync again.
9. Import Inventory Sites Since: Import Inventory Sites from QuickBooks into Sugar if they have been modified since this date (UTC format). Warning: Setting this value in the past will force the Inventory Site record to sync which may have not changed since the last sync. Setting this value far into the past (1983, for example) will cause all Inventory Sites to sync again.
10. Sync ID Matching Updates Since: Load the ID matches between Sugar and QuickBooks where the QuickBooks Customer has changed since this date (UTC format).
Warning: Setting this value in the past will force IDs to sync which may have not had Customer data changed since the last sync. Setting this value far into the past (1983, for example) will cause all IDs to sync again.
B. Special Functions
1. Quote Pre-Check: This will list out all Quotes to be synced, and check them for certain errors which would prevent them from being synced to QB. Just because a Quote has no issues listed here does not mean that they will sync successfully, however. QuickBooks has its own set of restrictions which are far more strict.
2. Account → QB Customer (Add or Mod) Pre-Check: This will list out all of the accounts that will be added as new customers to QB, Or Accounts that have changes that will be sent to QB. This will also list out any issues that we can detect that would prevent this account from syncing to QB. Just because an Account has no issues listed here does not mean that it will sync successfully.
3. Manually Match QB Customers to Sugar Accounts: This function will allow you to manually match any QB customer that did not automatically get linked to a Sugar Account. (This will only work if the Create Sugar Accounts from Customer option is turned off) Manually Matching QB Customers to Sugar Accounts.
4. Initialize Custom Fields from QuickBooks: Forces update of QuickBooks custom fields, so they can be used for custom sync mapping in the QuickBooks Integration. The update occurs the next time the Web Connector makes a connection. This also disables the other syncs, so that you may set the Account/Customer-Sync Key to a custom QuickBooks field before running regular sync. You may then reenable all of the syncs afterward. Custom fields automatically update during regular syncs – do not use this button to force a custom field update during regular syncs. Please consult the Custom Field Mappings section for usage details and instructions.
5. Empty Logs: Empty out the old sync logs, so a fresh log can be created with only the latest sync information.
Note: This will delete the Integration logs. Before you send the “Diagnostic Email” to Faye, using the button below, it is recommended you delete the logs first, then run another sync, and then send the diagnostic email. If you skip this step, then the data being sent to Faye might be too big for your Sugar to send.
6. Empty Sync Queue & Tickets: Empties the sync queue and connection tickets. Should only be used in the event of an unexpected sync issue that prevents any syncs from completing.
7. Load Default Field-Sync Mappings: Removes all field-sync mappings and replaces them with the defaults.
Warning: This will overwrite any custom mapping you have done; any mapping changes you have made and would like to keep will have to be manually remapped after loading the defaults.
8. Re-Process ALL Ship-To Addresses: This causes a full re-processing of all shipto addresses, re-importing addresses into the Shipping Addresses module.
Notice: This re-processing uses the server CPU heavily, and may take a long time (depending on the number of transactions you have).
9. Recalculate All Account YTD Sales: This recalculates and updates the YTD sales and last year's sales fields for all Accounts.
Notice: This should only be executed at the first of the year, to force a recalculation of last year’s sales for all Accounts. Otherwise, this calculation will only occur on an account-by-account basis when an Invoice is synced with Sugar from QuickBooks.
10. Update Product YTD by Account Sales Information: This recalculates all product YTD sales information by Account.
Notice: This automatically occurs after invoices have been synced, so it should not be necessary to use this function in most circumstances.
11. Update Product YTD Sales Information: This recalculates all product YTD sales information, and updates the Product Catalog.
Notice: This automatically occurs after invoices have been synced, so it should not be necessary to use this function in most circumstances.
12. Relink Invoice History Line Items to Product Templates: This relinks all Invoice History line items to the correct product template items.
Notice: This should only be done if there is some change to product identifier mapping. This function should almost never need to be executed and is only for special circumstances.
13. Add More QB Quote Stages: This adds more Quote Stages to Sugar which will trigger export to QuickBooks.
Notice: This should only be done if you want more than one Quote Stage that can send a Quote to a particular QuickBooks transaction module (such as both Closed Accepted and Confirmed both going to QuickBooks Invoices). Once these new stages are added, you can use the Sugar Dropdown Editor to update the labels for the Quote Stages and delete any that you no longer want.
14. Download Diagnostic File For FBSG: Download a diagnostic file to send to Faye.
Note: This file contains the configuration information for the QuickBooks Integration and sync statistics. It does not contain any passwords or sensitive company information.
15. Send Diagnostic Email to FBSG: Send an email to Faye containing debugging information.
Note: This email contains the configuration information for the QuickBooks Integration and sync statistics. It does not contain any passwords or sensitive company information.
16. Send Diagnostic Email to FBSG: Send an email to Faye containing debugging information.
Note: This email contains the configuration information for the QuickBooks Integration and sync statistics. It does not contain any passwords or sensitive company information.
17. Time Filter Offset: Adds or subtracts hours from the filter used to select modified data from QuickBooks. Due to conflicting server time zones, database time zones, and QuickBooks time zones, it may be necessary to set this option to a non-zero value (likely sometime in the past, by subtracting some number of hours from the filter).
Note: It may not be necessary to change this at all. Only change it if you notice certain recently modified data is not syncing.
Comments
0 comments
Please sign in to leave a comment.