QuickBooks Link Items Options: Difference between revisions

From RangerMSP Wiki - PSA software for MSPs and IT services providers
Jump to navigation Jump to search
No edit summary
No edit summary
 
(4 intermediate revisions by 3 users not shown)
Line 1: Line 1:
[[Items]] in CommitCRM are a catalog of all the services and products you offer. The Items list in CommitCRM acts as your price list.
{{usermanualsquickbookslink}}
 
[[Items]] in RangerMSP are a catalog of all the services and products you offer. The Items list in RangerMSP acts as your price list.


Each Item has a unique Code, Name, Description and Pricing Setting.
Each Item has a unique Code, Name, Description and Pricing Setting.


There are three types of Items in CommitCRM:
There are three types of Items in RangerMSP:


'''Parts''' Items are hardware, software, or any other items you ship to your customer. These items have fixed prices.
'''Parts''' Items are hardware, software, or any other items you ship to your customer. These items have fixed prices.
Line 11: Line 13:
'''Expense''' Items are used to charge expenses, such as travel and special deliveries. Expense Items can have a fixed price per unit or a fixed hourly rate.
'''Expense''' Items are used to charge expenses, such as travel and special deliveries. Expense Items can have a fixed price per unit or a fixed hourly rate.


For each new Charge record, an Item is selected and the relevant Item data is automatically copied to the new charge. This streamlines your data entry process. Also, the selected Item for a Charge in CommitCRM will be the Item that appears on the QuickBooks invoice line when the Charge is transferred to a QuickBooks invoice.
For each new Charge record, an Item is selected and the relevant Item data is automatically copied to the new charge. This streamlines your data entry process. Also, the selected Item for a Charge in RangerMSP will be the Item that appears on the QuickBooks invoice line when the Charge is transferred to a QuickBooks invoice.


Items can be Active or Suspended. A suspended Item cannot be selected when adding new charges.
Items can be Active or Suspended. A suspended Item cannot be selected when adding new charges.


Items can be easily imported from [[QuickBooks Link|QuickBooks]], and changes can be synchronized between QuickBooks and CommitCRM via [[QuickBooks Link|Commit-QuickBooks Link]].
Items can be easily imported from [[QuickBooks Link|QuickBooks]], and changes can be synchronized between QuickBooks and RangerMSP via [[QuickBooks Link|RangerMSP-QuickBooks Link]].


==Actions in CommitCRM QuickBooks==
==Actions in RangerMSP QuickBooks==
Aside from the ability to import Items into CommitCRM, there are many other useful functions in the Commit-QuickBooks Link.
Aside from the ability to import Items into RangerMSP, there are many other useful functions in the RangerMSP-QuickBooks Link.


You can see all the synchronization options for Item records in CommitCRM and QuickBooks in the Items window on the QuickBooks drop down toolbar menu in CommitCRM.
You can see all the synchronization options for Item records in RangerMSP and QuickBooks in the Items window on the QuickBooks drop down toolbar menu in RangerMSP.


You will see one of the two following menus.
You will see one of the two following menus.
Line 26: Line 28:
The first menu is displayed when a selected Item record is not linked to an Item record in QuickBooks.
The first menu is displayed when a selected Item record is not linked to an Item record in QuickBooks.


[[File:commit_quickbooks_options_in_items_window1.gif|center]]
[[File:quickbooks_options_in_items_window1.png|center]]


The second menu is displayed when a selected Item record is linked to an Item record in QuickBooks.
The second menu is displayed when a selected Item record is linked to an Item record in QuickBooks.


[[File:commit_quickbooks_options_in_items_window2.gif|center]]
[[File:quickbooks_options_in_items_window2.png|center]]


All the options are initiated from the Items window in CommitCRM, and therefore the QuickBooks company file does not have to be open when you choose to select any of the above actions. (If QuickBooks is open you may notice performance improvements.)
All the options are initiated from the Items window in RangerMSP, and therefore the QuickBooks company file does not have to be open when you choose to select any of the above actions. (If QuickBooks is open you may notice performance improvements.)


'''General'''<br>CommitCRM syncs with the following item types in QuickBooks:
'''General'''<br>RangerMSP syncs with the following item types in QuickBooks:
#Labor Items in CommitCRM are parallel to Service Items in QuickBooks
#Labor Items in RangerMSP are parallel to Service Items in QuickBooks
#Products/Parts Items in CommitCRM are parallel to the following Items in QuickBooks:
#Products/Parts Items in RangerMSP are parallel to the following Items in QuickBooks:
##Inventory Parts
##Inventory Parts
##Non-Inventory Parts
##Non-Inventory Parts
##Inventory Assembly Items
##Inventory Assembly Items
#Expense Items in CommitCRM are parallel to Other Charge Items in QuickBooks.
#Expense Items in RangerMSP are parallel to Other Charge Items in QuickBooks.


==Link Item To QuickBooks Service / Part/Assembly / Other Charge Item==
==Link Item To QuickBooks Service / Part/Assembly / Other Charge Item==
You can create a link between an existing Item in CommitCRM with an existing Item in QuickBooks.<br>This option is useful when the same Item already exists in both CommitCRM and QuickBooks. The linking function tells the system that these records are the same Item and they should e synchronized with each other.
You can create a link between an existing Item in RangerMSP with an existing Item in QuickBooks.<br>This option is useful when the same Item already exists in both RangerMSP and QuickBooks. The linking function tells the system that these records are the same Item and they should e synchronized with each other.


To link between an existing Item record in CommitCRM and an existing Item in QuickBooks, select Link Item To QuickBooks Service/Part/Assembly/Other Charge Item on the QuickBooks drop down toolbar menu.
To link between an existing Item record in RangerMSP and an existing Item in QuickBooks, select Link Item To QuickBooks Service/Part/Assembly/Other Charge Item on the QuickBooks drop down toolbar menu.


[[File:commit_link_item_to_quickbooks_record.gif|center]]
[[File:link_item_to_quickbooks_record.png|center]]


The QuickBooks Item Selection window will appear:
The QuickBooks Item Selection window will appear:


[[File:commit_quickbooks_item_selection_window1.gif|center]]
[[File:quickbooks_item_selection_window1.png|center]]


Type the name of the Item in the Name field in QuickBooks, and click Find. The relevant Items in QuickBooks will be displayed. Select the Item that matches the Item in CommitCRM and click OK.<br>Done! You have created the link between the two records.
Type the name of the Item in the Name field in QuickBooks, and click Find. The relevant Items in QuickBooks will be displayed. Select the Item that matches the Item in RangerMSP and click OK.<br>Done! You have created the link between the two records.


In the example above, we have created a link between an Expense Item in CommitCRM and an Other Part Item in QuickBooks. Updates in CommitCRM to this Item can now be synchronized with to QuickBooks, and vice versa.
In the example above, we have created a link between an Expense Item in RangerMSP and an Other Part Item in QuickBooks. Updates in RangerMSP to this Item can now be synchronized with to QuickBooks, and vice versa.


==Create New Item In QuickBooks Based on CommitCRM Item==
==Create New Item In QuickBooks Based on RangerMSP Item==
This option enables you to create a new Item in QuickBooks based on an existing Item in CommitCRM. It also creates a link between the record in CommitCRM and the newly created corresponding record in QuickBooks.
This option enables you to create a new Item in QuickBooks based on an existing Item in RangerMSP. It also creates a link between the record in RangerMSP and the newly created corresponding record in QuickBooks.


This option is useful when a new Item record was created in CommitCRM and you want to add it to the QuickBooks, without having to type the Item details again in QuickBooks.
This option is useful when a new Item record was created in RangerMSP and you want to add it to the QuickBooks, without having to type the Item details again in QuickBooks.


To create a new Item in QuickBooks based on an already existing CommitCRM Item, select the relevant Item in the Items window in CommitCRM and then select the Create New Item In QuickBooks Based on CommitCRM Item on the QuickBooks drop down toolbar menu.
To create a new Item in QuickBooks based on an already existing RangerMSP Item, select the relevant Item in the Items window in RangerMSP and then select the Create New Item In QuickBooks Based on RangerMSP Item on the QuickBooks drop down toolbar menu.


The following types of CommitCRM Items will be created as the following QuickBooks Items:<br>Labor items in CommitCRM will be created as Service Items in QuickBooks.<br>Expense Items in CommitCRM will be created as Other Items in QuickBooks.<br>Products/Parts Items in CommitCRM will be created as Inventory Parts or Inventory Assembly or Non Inventory Parts in QuickBooks.
The following types of RangerMSP Items will be created as the following QuickBooks Items:<br>Labor items in RangerMSP will be created as Service Items in QuickBooks.<br>Expense Items in RangerMSP will be created as Other Items in QuickBooks.<br>Products/Parts Items in RangerMSP will be created as Inventory Parts or Inventory Assembly or Non Inventory Parts in QuickBooks.


[[File:commit_new_record_in_quickbooks_based_on_commit_item.gif|center]]
[[File:new_record_in_quickbooks_based_on_crm_item.png|center]]


The Item record will now be transferred to QuickBooks. You can open QuickBooks and view the newly created record.
The Item record will now be transferred to QuickBooks. You can open QuickBooks and view the newly created record.


[[File:commit_new_item_in_quickbooks.gif|center]]
[[File:new_item_in_quickbooks.gif|center]]


==Update Linked QuickBooks Record with CommitCRM Item Data==
==Update Linked QuickBooks Record with RangerMSP Item Data==
You can update a linked QuickBooks Item with CommitCRM Item data. This option is useful you've updated an Item in CommitCRM and want to automatically transfer these updates to the corresponding linked Item in QuickBooks.
You can update a linked QuickBooks Item with RangerMSP Item data. This option is useful you've updated an Item in RangerMSP and want to automatically transfer these updates to the corresponding linked Item in QuickBooks.


To update a linked Item in QuickBooks with CommitCRM Item data, select the relevant Item in the Items window in CommitCRM and then select Update Linked QuickBooks Record with CommitCRM Item Data on the QuickBooks drop down toolbar menu.
To update a linked Item in QuickBooks with RangerMSP Item data, select the relevant Item in the Items window in RangerMSP and then select Update Linked QuickBooks Record with RangerMSP Item Data on the QuickBooks drop down toolbar menu.


[[File:commit_update_quickbooks_record_with_commit_item_data.gif|center]]
[[File:update_quickbooks_record_with_crm_item_data.png|center]]


The relevant Item will be automatically updated in QuickBooks. You can open QuickBooks and view the updated information.
The relevant Item will be automatically updated in QuickBooks. You can open QuickBooks and view the updated information.


[[File:commit_updated_item_in_quickbooks.gif|center]]
[[File:updated_item_in_quickbooks.gif|center]]


You can see in the images above how the updated 'Price' field in CommitCRM was updated in the parallel record in QuickBooks after selecting this option.
You can see in the images above how the updated 'Price' field in RangerMSP was updated in the parallel record in QuickBooks after selecting this option.


<u>Note:</u> If the linked Item in QuickBooks was also updated since the last synchronization took place, you will receive a system warning.
<u>Note:</u> If the linked Item in QuickBooks was also updated since the last synchronization took place, you will receive a system warning.


==Update Item Data from the Linked QuickBooks Record==
==Update Item Data from the Linked QuickBooks Record==
You can update a linked CommitCRM Item with QuickBooks Item data. This option is useful when you've updated an Item in QuickBooks and want to automatically transfer the changes to CommitCRM.
You can update a linked RangerMSP Item with QuickBooks Item data. This option is useful when you've updated an Item in QuickBooks and want to automatically transfer the changes to RangerMSP.


In the following example, the Item Description field was updated in QuickBooks:
In the following example, the Item Description field was updated in QuickBooks:


[[File:commit_updated_item_in_quickbooks2.gif|center]]
[[File:updated_item_in_quickbooks2.gif|center]]


To update the linked CommitCRM Item with the changed data from the parallel QuickBooks Item,  select the relevant Item in CommitCRM and then select the option: Update Item Data from the Linked QuickBooks Record on the QuickBooks drop down toolbar menu.
To update the linked RangerMSP Item with the changed data from the parallel QuickBooks Item,  select the relevant Item in RangerMSP and then select the option: Update Item Data from the Linked QuickBooks Record on the QuickBooks drop down toolbar menu.


[[File:commit_update_item_with_quickbooks_data.gif|center]]
[[File:update_item_with_quickbooks_data.png|center]]


The selected record in CommitCRM will be updated with the changes made in QuickBooks.
The selected record in RangerMSP will be updated with the changes made in QuickBooks.


[[File:commit_updated_item.gif|center]]
[[File:updated_item.png|center]]


In the example above, you can see that the Description field in CommitCRM has been updated with the new information from the linked QuickBooks record.
In the example above, you can see that the Description field in RangerMSP has been updated with the new information from the linked QuickBooks record.


<u>Note:</u> If the linked Item in CommitCRM was also updated since the last synchronization took place, you will receive a system warning.
<u>Note:</u> If the linked Item in RangerMSP was also updated since the last synchronization took place, you will receive a system warning.


==Remove Link Between the Item and QuickBooks Record==
==Remove Link Between the Item and QuickBooks Record==
You can remove the link between a CommitCRM Item and a QuickBooks Item. This feature is useful for removing links that were created by mistake, removing links to QuickBooks records that were deleted, or when you don't want to continue synchronizing data between records. When you remove a link between records, you will no longer be able to synchronize changes them. You can always link the records again in the future with the Link Item To QuickBooks Item Record on the QuickBooks drop down toolbar menu as described above.
You can remove the link between a RangerMSP Item and a QuickBooks Item. This feature is useful for removing links that were created by mistake, removing links to QuickBooks records that were deleted, or when you don't want to continue synchronizing data between records. When you remove a link between records, you will no longer be able to synchronize changes them. You can always link the records again in the future with the Link Item To QuickBooks Item Record on the QuickBooks drop down toolbar menu as described above.


To remove the link between the records, select the relevant Item in CommitCRM and then select Remove Link Between the Item and QuickBooks Record on the QuickBooks drop down toolbar menu.
To remove the link between the records, select the relevant Item in RangerMSP and then select Remove Link Between the Item and QuickBooks Record on the QuickBooks drop down toolbar menu.


[[File:commit_remove_link_between_items.gif|center]]
[[File:remove_link_between_items.png|center]]


==New Item in CommitCRM Based on QuickBooks Item==
==New Item in RangerMSP Based on QuickBooks Item==
This option allows you to create a new Item in CommitCRM based on an existing Item in QuickBooks. It also creates a link between the record in QuickBooks and the newly created corresponding record in CommitCRM.
This option allows you to create a new Item in RangerMSP based on an existing Item in QuickBooks. It also creates a link between the record in QuickBooks and the newly created corresponding record in RangerMSP.


This option is useful when a new Item was created in QuickBooks and you want to add it to CommitCRM, without typing the details again in CommitCRM.
This option is useful when a new Item was created in QuickBooks and you want to add it to RangerMSP, without typing the details again in RangerMSP.


To create a new Item in CommitCRM based on an Item in QuickBooks, select New Item in CommitCRM Based on QuickBooks Item from the Items window in CommitCRM, and then select the type of item you want to import: Service/Inventory Part/Inventory Assembly/Non Inventory Part/Other Charge.
To create a new Item in RangerMSP based on an Item in QuickBooks, select New Item in RangerMSP Based on QuickBooks Item from the Items window in RangerMSP, and then select the type of item you want to import: Service/Inventory Part/Inventory Assembly/Non Inventory Part/Other Charge.


[[File:commit_new_item_based_on_quickbooks_record.gif|center]]
[[File:new_item_based_on_quickbooks_record.png|center]]


The QuickBooks Item Selection window will open.
The QuickBooks Item Selection window will open.


[[File:commit_quickbooks_item_selection_window2.gif|center]]
[[File:quickbooks_item_selection_window2.png|center]]


Search for the Item in QuickBooks that you want to use to create the new Item in CommitCRM.
Search for the Item in QuickBooks that you want to use to create the new Item in RangerMSP.


Enter the name of the Item in the Name field in QuickBooks and click Find. Any related Items will be displayed. Select the relevant record and click OK.
Enter the name of the Item in the Name field in QuickBooks and click Find. Any related Items will be displayed. Select the relevant record and click OK.


[[File:commit_new_item.gif|center]]
[[File:New_item_from_qb.png|center]]


Done! The new Item will now be created in CommitCRM.
Done! The new Item will now be created in RangerMSP.


==Import New Records / Update Linked Records from QuickBooks==
==Import New Records / Update Linked Records from QuickBooks==
his option is the same one that may have been used to initially import all the records from QuickBooks into CommitCRM.
his option is the same one that may have been used to initially import all the records from QuickBooks into RangerMSP.


Using this option after the initial import enables you to import all the QuickBooks records that have been added to QuickBooks after the initial import. It also syncs all updates performed to records in QuickBooks and applies them to the corresponding linked records in CommitCRM.
Using this option after the initial import enables you to import all the QuickBooks records that have been added to QuickBooks after the initial import. It also syncs all updates performed to records in QuickBooks and applies them to the corresponding linked records in RangerMSP.


During the first import, all the relevant Items records from QuickBooks will be imported into CommitCRM.
During the first import, all the relevant Items records from QuickBooks will be imported into RangerMSP.


From the second import and on:
From the second import and on:
#All the new records in QuickBooks that were created during the period between the last import and the current import, will be imported to CommitCRM as a new records.
#All the new records in QuickBooks that were created during the period between the last import and the current import, will be imported to RangerMSP as a new records.
#All the records in QuickBooks that were updated during the period between the last import and the current import, will be updated in CommitCRM as well.
#All the records in QuickBooks that were updated during the period between the last import and the current import, will be updated in RangerMSP as well.


To sync/import all the records, go to Items window > QuickBooks drop down toolbar menu and select the option 'Import New Records / Update Linked Records from QuickBooks...':
To sync/import all the records, go to Items window > QuickBooks drop down toolbar menu and select the option 'Import New Records / Update Linked Records from QuickBooks...':


[[File:commit_importing_items_from_quickbooks.gif|center]]
[[File:importing_items_from_quickbooks.png|center]]


==See Also==
==See Also==
*[[QuickBooks Link|Commit-QuickBooks Link]]
*[[QuickBooks Link|RangerMSP-QuickBooks Link]]
*[[Items]]
*[[Items]]



Latest revision as of 13:26, 8 July 2020

User Manuals > QuickBooks Link > QuickBooks Link Items Options

Items in RangerMSP are a catalog of all the services and products you offer. The Items list in RangerMSP acts as your price list.

Each Item has a unique Code, Name, Description and Pricing Setting.

There are three types of Items in RangerMSP:

Parts Items are hardware, software, or any other items you ship to your customer. These items have fixed prices.

Labor Items are services you provide to your customers, such as server installation, network installation, on-site technician visits, etc. Each Labor item can have a fixed price, a fixed hourly rate, or a dynamic hourly rate that varies depending upon the employee who performs the service.

Expense Items are used to charge expenses, such as travel and special deliveries. Expense Items can have a fixed price per unit or a fixed hourly rate.

For each new Charge record, an Item is selected and the relevant Item data is automatically copied to the new charge. This streamlines your data entry process. Also, the selected Item for a Charge in RangerMSP will be the Item that appears on the QuickBooks invoice line when the Charge is transferred to a QuickBooks invoice.

Items can be Active or Suspended. A suspended Item cannot be selected when adding new charges.

Items can be easily imported from QuickBooks, and changes can be synchronized between QuickBooks and RangerMSP via RangerMSP-QuickBooks Link.

Actions in RangerMSP QuickBooks

Aside from the ability to import Items into RangerMSP, there are many other useful functions in the RangerMSP-QuickBooks Link.

You can see all the synchronization options for Item records in RangerMSP and QuickBooks in the Items window on the QuickBooks drop down toolbar menu in RangerMSP.

You will see one of the two following menus.

The first menu is displayed when a selected Item record is not linked to an Item record in QuickBooks.

The second menu is displayed when a selected Item record is linked to an Item record in QuickBooks.

All the options are initiated from the Items window in RangerMSP, and therefore the QuickBooks company file does not have to be open when you choose to select any of the above actions. (If QuickBooks is open you may notice performance improvements.)

General
RangerMSP syncs with the following item types in QuickBooks:

  1. Labor Items in RangerMSP are parallel to Service Items in QuickBooks
  2. Products/Parts Items in RangerMSP are parallel to the following Items in QuickBooks:
    1. Inventory Parts
    2. Non-Inventory Parts
    3. Inventory Assembly Items
  3. Expense Items in RangerMSP are parallel to Other Charge Items in QuickBooks.

Link Item To QuickBooks Service / Part/Assembly / Other Charge Item

You can create a link between an existing Item in RangerMSP with an existing Item in QuickBooks.
This option is useful when the same Item already exists in both RangerMSP and QuickBooks. The linking function tells the system that these records are the same Item and they should e synchronized with each other.

To link between an existing Item record in RangerMSP and an existing Item in QuickBooks, select Link Item To QuickBooks Service/Part/Assembly/Other Charge Item on the QuickBooks drop down toolbar menu.

The QuickBooks Item Selection window will appear:

Type the name of the Item in the Name field in QuickBooks, and click Find. The relevant Items in QuickBooks will be displayed. Select the Item that matches the Item in RangerMSP and click OK.
Done! You have created the link between the two records.

In the example above, we have created a link between an Expense Item in RangerMSP and an Other Part Item in QuickBooks. Updates in RangerMSP to this Item can now be synchronized with to QuickBooks, and vice versa.

Create New Item In QuickBooks Based on RangerMSP Item

This option enables you to create a new Item in QuickBooks based on an existing Item in RangerMSP. It also creates a link between the record in RangerMSP and the newly created corresponding record in QuickBooks.

This option is useful when a new Item record was created in RangerMSP and you want to add it to the QuickBooks, without having to type the Item details again in QuickBooks.

To create a new Item in QuickBooks based on an already existing RangerMSP Item, select the relevant Item in the Items window in RangerMSP and then select the Create New Item In QuickBooks Based on RangerMSP Item on the QuickBooks drop down toolbar menu.

The following types of RangerMSP Items will be created as the following QuickBooks Items:
Labor items in RangerMSP will be created as Service Items in QuickBooks.
Expense Items in RangerMSP will be created as Other Items in QuickBooks.
Products/Parts Items in RangerMSP will be created as Inventory Parts or Inventory Assembly or Non Inventory Parts in QuickBooks.

The Item record will now be transferred to QuickBooks. You can open QuickBooks and view the newly created record.

Update Linked QuickBooks Record with RangerMSP Item Data

You can update a linked QuickBooks Item with RangerMSP Item data. This option is useful you've updated an Item in RangerMSP and want to automatically transfer these updates to the corresponding linked Item in QuickBooks.

To update a linked Item in QuickBooks with RangerMSP Item data, select the relevant Item in the Items window in RangerMSP and then select Update Linked QuickBooks Record with RangerMSP Item Data on the QuickBooks drop down toolbar menu.

The relevant Item will be automatically updated in QuickBooks. You can open QuickBooks and view the updated information.

You can see in the images above how the updated 'Price' field in RangerMSP was updated in the parallel record in QuickBooks after selecting this option.

Note: If the linked Item in QuickBooks was also updated since the last synchronization took place, you will receive a system warning.

Update Item Data from the Linked QuickBooks Record

You can update a linked RangerMSP Item with QuickBooks Item data. This option is useful when you've updated an Item in QuickBooks and want to automatically transfer the changes to RangerMSP.

In the following example, the Item Description field was updated in QuickBooks:

To update the linked RangerMSP Item with the changed data from the parallel QuickBooks Item, select the relevant Item in RangerMSP and then select the option: Update Item Data from the Linked QuickBooks Record on the QuickBooks drop down toolbar menu.

The selected record in RangerMSP will be updated with the changes made in QuickBooks.

In the example above, you can see that the Description field in RangerMSP has been updated with the new information from the linked QuickBooks record.

Note: If the linked Item in RangerMSP was also updated since the last synchronization took place, you will receive a system warning.

Remove Link Between the Item and QuickBooks Record

You can remove the link between a RangerMSP Item and a QuickBooks Item. This feature is useful for removing links that were created by mistake, removing links to QuickBooks records that were deleted, or when you don't want to continue synchronizing data between records. When you remove a link between records, you will no longer be able to synchronize changes them. You can always link the records again in the future with the Link Item To QuickBooks Item Record on the QuickBooks drop down toolbar menu as described above.

To remove the link between the records, select the relevant Item in RangerMSP and then select Remove Link Between the Item and QuickBooks Record on the QuickBooks drop down toolbar menu.

New Item in RangerMSP Based on QuickBooks Item

This option allows you to create a new Item in RangerMSP based on an existing Item in QuickBooks. It also creates a link between the record in QuickBooks and the newly created corresponding record in RangerMSP.

This option is useful when a new Item was created in QuickBooks and you want to add it to RangerMSP, without typing the details again in RangerMSP.

To create a new Item in RangerMSP based on an Item in QuickBooks, select New Item in RangerMSP Based on QuickBooks Item from the Items window in RangerMSP, and then select the type of item you want to import: Service/Inventory Part/Inventory Assembly/Non Inventory Part/Other Charge.

The QuickBooks Item Selection window will open.

Search for the Item in QuickBooks that you want to use to create the new Item in RangerMSP.

Enter the name of the Item in the Name field in QuickBooks and click Find. Any related Items will be displayed. Select the relevant record and click OK.

Done! The new Item will now be created in RangerMSP.

Import New Records / Update Linked Records from QuickBooks

his option is the same one that may have been used to initially import all the records from QuickBooks into RangerMSP.

Using this option after the initial import enables you to import all the QuickBooks records that have been added to QuickBooks after the initial import. It also syncs all updates performed to records in QuickBooks and applies them to the corresponding linked records in RangerMSP.

During the first import, all the relevant Items records from QuickBooks will be imported into RangerMSP.

From the second import and on:

  1. All the new records in QuickBooks that were created during the period between the last import and the current import, will be imported to RangerMSP as a new records.
  2. All the records in QuickBooks that were updated during the period between the last import and the current import, will be updated in RangerMSP as well.

To sync/import all the records, go to Items window > QuickBooks drop down toolbar menu and select the option 'Import New Records / Update Linked Records from QuickBooks...':

See Also