WD98: How to Add Rows to Invoice and Purchase Order Templates (237305)


The information in this article applies to:

  • Microsoft Word 98 Macintosh Edition
This article was previously published under Q237305

SUMMARY

This article describes how to add rows to the Invoice and Purchase Order templates.

NOTE: The Invoice and Purchase Order templates are not installed with the drag-and-drop installation or the custom installation of Office 98. They can be installed from the Value Pack installer, or you can drag them from the Word folder, which is located in the Templates folder in the Value Pack on the Microsoft Office 98 CD. Drag them to the Templates folder in the Microsoft Office 98 folder on your hard disk drive.

MORE INFORMATION

To add rows to these templates, follow these steps:

  1. On the File menu, click Open.
  2. Open the template (Invoice or Purchord).
  3. On the Tools menu, click Unprotect Document.
  4. Position the insertion point in the last row of the table (the row just before the Subtotal row).
  5. On the Table menu, click Select Row.
  6. On the Format menu, click Borders and Shading.
  7. On the Borders tab, use the Borders sample diagram to cancel the bottom border selection.
  8. Click OK.
  9. With this row still selected, click Copy on the Edit menu.
  10. Select the Subtotal row. On the Edit menu, click Paste Rows.
  11. Double-click the Form field in the first cell (in the Quantity column). The Text Form Field Options dialog box appears.
  12. In the Bookmark box, under Field Settings, type Quantity_8. If you are adding more than one row, type the next consecutive number.

    In the Purchase Order template, there is also a Unit column. Double-click this form field. Name the Bookmark Unit_8.
  13. Double-click the form field in the next cell. In the Bookmark Name box, type Description_8.
  14. Double-click the form field in the next cell. In the Bookmark Name box, type Price_8.
  15. For the Invoice template, follow these steps:

    1. Double-click the last form field.
    2. Type Amount_8 for Bookmark Name.
    3. The Default Number box shows the following:

      =PRODUCT(A8,C8)

      Change this to:

      =PRODUCT(A9,C9)

      These cell numbers represent the quantity and price for the current row.
    For the Purchase Order template, follow these steps:

    1. Double-click the last form field.
    2. Type Amount_8 for Bookmark Name.
    3. The Default Number box shows the following:

      =PRODUCT(A8,D8)

      Change this to:

      =PRODUCT(A9,D9)

      These cell numbers represent the quantity and price for the current row.

      If you need to add more rows, repeat steps 9 through 15, incrementing the bookmark number for all form fields for each consecutive row.
  16. If you do not want to add more rows, select the last row that you created, and click Borders and Shading on the Format menu.
  17. Click the Borders tab, and use the Borders diagram to select the bottom border.
  18. Use the appropriate procedure for the template that you are using.

    For the Invoice template:

    1. Double-click the Total Due form field.
    2. Modify the calculation by adding the number of rows that have been added to the existing values. If you added two rows, then add two to the numbers, for example:

      =SUM(D11,D12,D13)

    For the Purchase Order template:

    1. Double-click the Total Due form field.
    2. Modify the calculation by adding the number of rows that have been added to the existing values. If you added two rows, then add two to the numbers, for example:

      =SUM(E11,E12,E13,E14)

  19. On the Tools menu, click Protect Document. In the Protect Document For area, click Forms. Click OK.
  20. Click Save. Close the file.

The template now contains additional rows.
Modification Type:MajorLast Reviewed:10/4/2002
Keywords:kbtemplate KB237305
©2002 Microsoft Corporation. All rights reserved.