IntelliTrack for QuickBooks® Desktop Synchronization Options
By using the Plugin, the following data may be synchronized from QuickBooks with IntelliTrack:
- Units of Measure
- Inventory Items
- Vendors (active)
- Receiving Orders
- Customers (active)
- Picking Orders
- Inventory data is imported from QuickBooks into IntelliTrack. The on hand quantity must be greater than zero in order to be imported into IntelliTrack.
- Inventory adjustments are exported from IntelliTrack to QuickBooks.
Important: For best results, before syncing data with the Plugin, the configuration options, QuickBooks settings, and IntelliTrack settings should be in place.
Auto Synchronization
The Plugin will automatically sync this data at a specified interval if you set an auto sync interval (see "Auto Synchronization"). You may also sync the data manually at the Synchronization tab.
Manual Synchronization
Data may be manually synchronized via the Plugin. This is useful when initially setting up the dataset between IntelliTrack and QuickBooks or if you need to verify that the data is in sync while working with the inventory and orders in IntelliTrack and QuickBooks.
- The data is manually synchronized at the Synchronization tab.
- Select the Synchronization tab to bring it to the front.
- By using the Plugin, the following data may be synchronized from QuickBooks with IntelliTrack: units of measure, items, vendors, receiving orders, customers, and picking orders. The inventory data is imported from QuickBooks into IntelliTrack. The inventory adjustments are exported from IntelliTrack to QuickBooks.
- To synchronize data, import the inventory, or export inventory adjustments via the Synchronization tab, click the applicable button.
- The status bar along the bottom of the Plugin notifies you when the import is complete.
- The options at this tab are explained in the table below.
Option |
Description |
---|---|
Synchronize Unit of Measure |
Click to manually import QuickBooks units of measure into IntelliTrack. The units of measure in QuickBooks will populate the Units of Measure grid at the Manage Lookups page. |
Synchronize Items |
Click to manually import QuickBooks items into IntelliTrack. The inventory part items will be imported into IntelliTrack. They are placed in the Item list for the selected division at the Manage Items page.
|
Import Inventory |
Click to import QuickBooks inventory for the inventory part items into IntelliTrack. The inventory items are sent to IntelliTrack and may be found at the Inventory Data page.
|
Export Inventory Adjustments |
Important: In order to export inventory adjustments you must select a QuickBooks Inventory Adjustment account in the Basic Configuration tab. Single Site: Click to export inventory adjustments for inventory part items from IntelliTrack to QuickBooks. Multiple Sites: If using the Multiple Sites feature, the inventory will be placed in the QuickBooks site that corresponds to the IntelliTrack Division-Site-Location as set in the Multiple Sites tab of the Plugin. |
Synchronize Vendors |
Click to manually import QuickBooks vendors into IntelliTrack. The vendors will populate the Vendor list found at the Manage Vendors page. Important: The fields in the vendor record in QuickBooks are mapped to specific fields in the vendor record in IntelliTrack. For best results, we recommend that you check the vendor setup in QuickBooks before importing your vendors into IntelliTrack; see "QuickBooks Customer and Vendor Setup" for more information. This is most important for the address importing. |
Synchronize Customers |
Click to manually import QuickBooks customers into IntelliTrack. The customers will populate the Customer list at the Manage Customers page. Important: The fields in the customer record in QuickBooks are mapped to specific fields in the customer record in IntelliTrack. For best results, we recommend that you check the customer setup in QuickBooks before importing your customers into IntelliTrack; see "QuickBooks Customer and Vendor Setup" for more information. This is most important for the address importing. |
Synchronize Receiving Orders |
Click to manually synchronize IntelliTrack Receiving Orders and QuickBooks Purchase orders. |
Synchronize Picking Orders |
Click to manually synchronize IntelliTrack Picking Orders and QuickBooks Sales Orders. |