GNet Solutions » Windows Administration

While setting up a custom template for a sales order in QuickBooks 2012, I found the default data fields were limited in selection and that I needed my own data fields for specific order templates. QuickBooks offers this ability, however it is not as intuitive as one might expect. This is a guide on how I managed to extra data fields to QuickBooks.

Create the Data Field¶

1. Once QuickBooks is open, click on the Customer Center.
2. Next select and edit a customer, any customer will work.
3. Then click on the Additional Info tab and click on Define Fields.
4. Label the new data field and select which group will be able to use the extra data field.
   • Cust will be available to members in the Customers group.
   • Vend will be available to members in the Vendors group.
   • Empl will be available to members in the Employees group.
5. Click OK when finished adding the new data field.
   • Close the customer edit window and Customer Center.

Use the Data Field¶

1. Open a new Sales Order or Invoice.
2. From the top menu in the order window, select Customize -> Manage Templates.
3. Select the template to add the new data field to.
4. Click on Additional Customization...
5. In the Header tab, locate the new data field name and check the Screen and Print boxes to add them to the invoice.
6. Click the Layout Designer... to adjust the layout and position of the new data field on documents printed using the template.
7. Click OK to apply changes in the Layout Designer, then click OK to finish editing the template.

Resources¶

• http://www.sleeter.com/blog/2013/11/custom-fields-in-quickbooks/