The Professional and Corporate Edition of QuoteWerks can link to the QuickBooks item list. You no longer have to export your item list from QuickBooks and then import it into QuoteWerks. This is valuable because you will have real-time access to your QuickBooks items and more importantly your inventory.
In order for QuoteWerks to link to the QuickBooks item list, QuickBooks must be running locally on the workstation in which you are using QuoteWerks.
|
|
Step 1: Make sure that QuoteWerks and QuickBooks are running.
Step 2: In QuoteWerks, go to the Products -> Setup Product Sources menu, then select the [New] button on the Product Data Source Setup window:
Step 3: From the “Select Database Type” window, select “QuickBooks” 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 QuickBooks item fields to their QuoteWerks counterpart. By default, we have already mapped the QuickBooks fields to QuoteWerks fields:
|
If you want to change our default selections, simply select the QuickBooks 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 QuickBooks item list the field is called ‘QuantityOnHand.’ You may want to refer to this as ‘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 QuickBooks 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 QuickBooks item list was established:
Step 9: To use the link, select the Products -> Lookup menu and select the QuickBooks 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%”.
|