free excel invoice templates
You are here: HOME  >>>  Excel Invoice Manager

Tutorial: Adding a Notes Field to Your Invoice Template

A Notes field on the invoice template allows you to enter any text when creating invoices, and save the text along with your invoices to the backend database. Starting from Version 2.6 Build 1010, the standard invoice template included in Excel Invoice Manager includes the Notes field.

If you are using an invoice template customized from the standard invoice template included in the earlier versions of Excel Invoice Manager, you may want to add the Notes field to the invoice template by yourself. Here are the detailed steps.

  1. Copy the standard invoice template (INVOICE.xls) in the data file folder of Excel Invoice Manager, or copy your customized version of the invoice template, to create a backup of your template.
  2. Open the template in Microsoft Excel.
  3. Unprotect the Invoice worksheet. For information about how to do this in Excel, see Customizing the Invoice Template.
  4. Switch the invoice template into design mode. For information about how to do this in Excel, see Customizing the Invoice Template.

    In design mode, Excel Invoice Manager does not react to the click events on the ActiveX objects.

  5. Scroll down the Invoice worksheet until you find the empty area on the bottom of the Invoice worksheet.
  6. Drag your mouse to select all the empty cells in which you want to put the notes text.

    sample invoice - adding a notes field -1
    Select cells (Click to enlarge)

  7. In Excel 2000 - 2003, click the Merge and Center button on the Formatting toolbar; In Excel 2007, click the Merge & Center button in the Alignment group of the Home tab.
  8. Name the big/merged cell oknNotes. To do this, click the name box at the left end of the formula bar, and then enter "oknNotes".
  9. Right click the merged cell and choose Format Cells from the menu.
  10. Switch to the Protection tab and clear the Locked box.

    Sample invoice - unlock cells
    Unlock cells (Click to enlarge)

  11. Switch to the Alignment tab. You may like to set the Horizontal option to Left, set the Vertical option to Top. Check the Wrap text option.
  12. Switch to the Border tab. Set the border type as needed.
  13. Set other options as needed.
  14. Click OK to close the Format Cells dialog box.
  15. Enter a text label for the newly created notes field, e.g. Notes or Comment.
  16. The maximal length of a text field in the backend database is 255 characters. You can create a Data Validation to limit the number of characters that can be entered into the notes field. To do this in Excel 2000 - 2003, click Excel menu Data -> Validation; Or, in Excel 2007, go to the Data tab and in the Data Tools group click Data Validation.

    In the Allow box, choose Text Length. In the Minimum box enter 1, and in the Maximum box enter 255. Set other validation options as needed.

    Sample invoice - data validation
    Data validation (Click to enlarge)

  17. When finishing your customization work, exit design mode and protect the worksheet again.
  18. For more information about customizing the template, please see Customizing the Invoice Template.

 
EXCEL INVOICE MANAGER Free Download and Try
LEARN MORE Excel Invoice Manager Home What's New Difference between Editions Quick Start Introduction Setting up Company Information, Tax Invoice Template Working with Excel 2007 Installing / Upgrading Settings Workbook Taxes Misc Data Interface Database In-Cell Lookup Print Customers Creating Customer Editing Customer Customer Detail Products Creating Product Editing Product Product Detail Invoices Creating Invoice Editing Invoice Invoice Detail Payments Adding Payment Editing Payment Payment Detail Reports Generating & Printing Reports Setting Visible Columns Extracting Reports Common Tasks Using the Search Bar Using Data List Windows Importing Data into Excel Invoice Manager Networking Working with Form Properties File Free Invoice Form with Support for Incomplete Lines on Invoice Body Using Credit Note or Credit Memo Copying Report Worksheets from One Invoice Template to Another Two Versions of Customer Statement Report Custom Fields Custom Fields - Overview Custom Invoice Fields - Tutorial Customizing the Invoice Template Customizing the Invoice Template Tutorial: Creating an Invoice Template with Additional Rows Tutorial: Adding a Notes Field to Your Invoice Template Tutorial: Adding or Removing the "Same As Bill To" Button Tutorial: Adding a Clear button to the Report Worksheets Tutorial: Displaying Summary Information on Customer Statement Tutorial: Creating a Receipt Form Using Multiple-Line Address in Invoice Form Printable Invoice - Invoice Printing in a Flexible Way Adding Postcode Cells Manually to Invoice Template More Topics Registration and Services Reference
Online-Only Articles Billing Software Powered by Excel Buttons in the Template Don't Work Sample Invoice Template: Using handwriting Signature Sample Invoice Template: Using Drop-Down List Sample Invoice Template: Long Product Descriptions Sample Invoice Template: Using Line# as Product IDs How to: Password-Protecting an Invoice Template How to: Transferring Excel Invoice Manager to a New System How to: Removing Auto-created Macros from Your Invoice Template Creating a Packing Slip Template Modifying Standard Fields with Database Designer Sample Invoice Template: Replacing the Product IDs with Line Numbers Invoice Template with Support for Product-Type Specific Tax Rates Editing Paid Invoices Working with Multiple Companies or Currencies Sharing/Linking Tables between Access Databases Tutorial: Adding New Fields to Reports Sample Invoice Template: Displaying 'FREE' for Zero Values Customizing Header and Footer of Printed Invoices Customizing Invoice Template for Pre-printed Invoice Forms Charging GST Tax on Shipping Cost Invoice Form with Fixed or Static Product / Service Items
Home Contact Us Privacy Link to Us
copyright © Office-Kit.com, all rights reserved