Question: What are the key points to select/setup customized fields on templates for Quote, Sales Order, Purchase Order, and to Invoicing, to use QB software as a main company accounting system, so that reports get more informative across those different phases? I heard once that a careful planning and selecting those fields are the key, so that each report has meaningful common information. Also, I heard that there are 7 optional columns we can use in Premier 2008...Any tips on where/how I should look into this via QB's "help" menu?


Answer:
Custom fields let you add more information about your customers, vendors, and employees, and the items that you purchase and sell.  You can use these fields on your form templates as well as most reports.  You can access the custom field input screen for customers, vendors and employees by editing any name, choosing the Additional Information tab, and clicking on the Define Fields button.  For instance, go to Customer Center, double-click on any name and you’ll see the Additional Information tab.  You can only add 7 custom fields for each type, and you can use the same field for more than one type.  You can add 5 custom fields to Items by double-clicking on any item and clicking on the Custom Fields box.
You can also add additional information to reports by defining Types.  For Customers and Vendors, this is also found on the Additional Information tab.  For Employees, you need to change the drop down tab from Personal Info to Employment Info to find it.
 
You’ll find that there’s an enormous amount of information you can add to your customers, vendors, employees and items by exploring the edit screens.  These information fields can be used to filter just about any report, and is one of the keys behind our ability to customize reports for our clients.

Follow-Up Question: Thank you for your help. For those 7 fields I can check in Estimates, Sales Order, Purchase Order, (and maybe Invoice--I have not looked yet), say, if I assign a definition on Note 1 field, (say, I wanted Delivery State), would it relate to all those different activity phases in the same Note 1? Or, is it just a matter of creating the same name field (not necessary in the same order among Note 1 to 7 in Estimate, Sales Order, etc.)? Or, do we need to go into each template to setup 7 optional fields, most preferably in the same matter, to make sure we see commonly needed information from various customer and vendor related reports?

Answer:
First you need to setup the fields in your customer, vendor, employee and items edit screens.  Once you do, you can use those fields on your estimates, sales orders, purchase orders, invoices, etc.  

Since you only have 7 custom fields for customers, vendors, and employees, and only 5 for items choose them carefully because the same 7 fields need to be used for all your customers, the same 5 for all your items.  And don’t forget, you can use the same field for both customers and vendors, but it does use up one of the 7 fields for each. 

If this answered your question, please consider spending a minute or two posting a review for us. ____________________________________________________________

Written by Ruth Perryman, MBA, CMA, CFE, CFM

Ruth is the president of The QB Specialists, an Intuit Solutions Provider that has helped thousands of businesses nationwide get the most out of QuickBooks and payroll. Ruth has over 20 years of industry experience, including 5 years as a Chief Financial Officer. She is an Advanced Certified QuickBooks ProAdvisor and a member of Intuit’s Trainer/Writer Network. She is also certified in QuickBooks Enterprise and Point of Sale.

Online payroll for only $25.99/month - try it free until April 2010! Instant paychecks, direct deposit, electronic tax payments & completed forms. Call us at 800-707-0940 or visit www.online-payroll.com for more details.

Enjoyed this post? Subscribe to QuickBooks Tips & Tricks via RSS Feed or via Email and receive free daily QuickBooks tips.