All Collections
[qCLIPxe] Global Replacement - Item List
[qCLIPxe] Global Replacement - Item List

How to replace job items globally (all at the same time)

Jonathan Conaway avatar
Written by Jonathan Conaway
Updated over a week ago

This article will explain how to import and change the item list so it reflects the item list that you have selected in each of your jobs. This will be useful if you need to change information in your QuickBooks item list and then have the change show up in CLIP for each job. Note: This function is only for the QuickBooks version of CLIP called qCLIPxe.

To start, we will need to gather information from your QuickBooks item list. In QuickBooks, click on the List menu then click Item List. Find the item or items that you have recently changed, and then make sure you have imported that information from QuickBooks into qCLIPxe . For more information on how to Import Data From QuickBooks click on the following link: 

After you have Imported your updated Item List from QuickBooks, click the Pattern Jobs icon on the main screen of CLIP.

Look through the list of Pattern Jobs, and find the one that needs the updated item under the job detail tab.

Once we change the item here, it will change it so that it will carry over to any new customers that you add new jobs to. For example, to make sure that this item shows up for all Landscaping Maintenance Job Number 2 we must check verify it in the CLIP system. From here, open your QuickBooks then click List menu and then Item List. Find the updated item and then copy the item name exactly as it shows in QuickBooks.

Click File, Global Replacement then Replace Information.

Select Job under Choose Database.

Click Fields button.

Find the field called JB.QuickBooks Item field, double click. Click Replace With.

From here, open QuickBooks and find the Item from List menu and then click Item List. Select and copy the name of the Item, this way you can simply right click in this field and paste it in. If you manually type it in, make sure you type the Exact Item name that appears in QuickBooks. When satisfied click Ok. Click Choose Condition. The job number we pulled up in Pattern Jobs was Landscaping Maintenance #2. For this condition, we will be pulling Job Number Equals 2.

Under Step 1, select JB.Job Number, double click or press enter. Under Step 2, click Equals.

Under Step 3, type 2 to represent Job Number 2, then press enter.

For our example, the End Result should show JOB.JOBNUM = 2. Click Use This Condition.

At this point, make sure the Replacement Command shows the correct Item Name and Job Number. Once you are satisfied, click Perform Replacement.

Let us know if you need further assistance!

Did this answer your question?