You are here:  QuoteWerks Help > CHAPTER 11: Product and Service Management > Creating and Maintaining Products and Services Databases >

Linking to the Sage 50 (Peachtree) Item List

Print this Topic Previous pageReturn to chapter overviewNext page

The Professional and Corporate Edition of QuoteWerks can link to the Sage 50 (Peachtree) item list. You no longer have to export your item list from Sage 50 (Peachtree) and then import it into QuoteWerks. This is valuable because you will have real-time access to your Sage 50 (Peachtree) items and more importantly your quantity in stock availability.

In order for QuoteWerks to link to the Sage 50 (Peachtree) item list, Sage 50 (Peachtree) must be running locally on the workstation in which you are using QuoteWerks.

Note:Sage 50 (Peachtree) does not need to be selected as your Contact Manager.
Note:Before you can integrate with Sage 50 (Peachtree), you need to make sure that Sage 50 (Peachtree) security features have been configured to allow external applications to integrate with Sage 50 (Peachtree). For details, please refer to the Sage 50 (Peachtree) Security Features topic in the Sage 50 (Peachtree) link chapter.

Step 1: Make sure that QuoteWerks and Sage 50 (Peachtree) are running.

 

Step 2: In QuoteWerks, go to the Products -> Setup Product Sources menu, then select the [New] button:

 

Step 3: From the “Select Database Type” window, select “Peachtree” from the drop down menu:

Then click on the [Next] button to move to the next step.

 

Step 4: This window allows you to map the Sage 50 (Peachtree) item fields to their QuoteWerks counterpart. By default, we have already mapped the Sage 50 (Peachtree) fields to QuoteWerks fields:

If you want to change our default selections, simply select the Sage 50 (Peachtree) field on the right, then select the QuoteWerks field on the left and choose to map or un-map the fields.

Click on the [Next] button to move to the next step.

 

Step 5: On this window you can “Set Column Titles.” Column titles are the names of the columns as they will appear in the Product Lookup window for this product source.

For example, in QuoteWerks the field name is called ‘Availability,’ in the Sage 50 (Peachtree) item list the field is called ‘QuantityOnHand.’ You may want to add some spaces so the title is ‘Quantity On Hand.’ By clicking on the [Change Title] button you can rename the column title:

Click on the [Next] button to move to the next step.

 

Step 6: If the ‘Individual Product Data Source level security’ has been enabled, the Security step will appear next:

Here you can control the level of access each User or Group has to this Product Data Source. For details, see the User Maintenance and Security chapter.

 

Step 7: Here you can choose various options for the product database.

Product Lookup Custom Menu Items

You can create custom right-click menu items specifically for this Product Data Source. Please see Customizing Product Fields, Contact Fields, and Menus.

 

Show all products/services when product source is selected

Choose this option to display all of the products and services in the database when you select this product database from the Product Lookup window. If you have more than 5,000 items in your product database, it is recommended that you do not select this option.

 

Click on the [Finish] to complete the link to the Sage 50 (Peachtree) item list.

 

Step 8: Once you click on the [Finish] button it will return you to the Product Data Source Setup window where you can confirm that the link to the Sage 50 (Peachtree) item list was established:

 

Step 9: To use the link, select the Products -> Lookup menu and select the Sage 50 (Peachtree) product data source.

To perform a wildcard search in the manufacturer part number field, you ca use the ‘Begins With’ checkbox and/or the wildcard % symbol.

Example: If you wanted to see every item with a description that began with the word “door”, you could check the ‘Begins With’ box and enter “door” in the Description. You could also enter “door%” in the Description. If you wanted to see everything that ended with the word “door”, you would enter “%door”. If you wanted to see every item that contained the word “door” you would enter “%door%”.

Note:The first time QuoteWerks retrieves the Sage 50 (Peachtree) product list, it caches it in memory so that QuoteWerks does not have to re-retrieve the product list from Sage 50 (Peachtree) each time you run a search. If you have changed your Sage 50 (Peachtree) product list while QuoteWerks is running you can press the F5 key while the grid has focus to have QuoteWerks re-retrieve the list of Sage 50 (Peachtree) products.

Version 5.2 (Build 8.12)  - July 7th, 2017