WD: Subtotal Incorrect in Invoice or Purchase Order Template (118439)


The information in this article applies to:

  • Microsoft Word for Windows 6.0
  • Microsoft Word for Windows 6.0a
  • Microsoft Word for Windows 6.0c
  • Microsoft Word for Windows 95
  • Microsoft Word for Windows 95 7.0a
  • Microsoft Word for the Macintosh 6.0
  • Microsoft Word for the Macintosh 6.0.1
  • Microsoft Word for the Macintosh 6.0.1a
  • Microsoft Word 97 for Windows
This article was previously published under Q118439

SYMPTOMS

When you use the Invoice or Purchase Order template, if you enter a negative number in the Unit Price column, the Subtotal form field will be calculated incorrectly, and the Total will reflect an incorrect amount.

CAUSE

The Subtotal form field in the template contains the SUM(ABOVE) formula, which is not calculating negative numbers.

STATUS

Microsoft has confirmed this to be a problem in Word. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

WORKAROUND

Modify the Subtotal form field expression so that it uses a range rather than the ABOVE argument.

Use the following steps to change the expression of the form field:

  1. On the File menu, click Open. Change to the Template (or Templates) folder and open the Invoice or Purchase Order template.
  2. Unprotect the template by clicking Unprotect Document on the Tools menu.
  3. Double-click the Subtotal form field.
  4. In the Text Form Field Options dialog box, change the expression from =SUM(ABOVE) to one of the following, and then click OK.
       Purchase Order template:     =SUM(E2:E8)
   Invoice template:            =SUM(D2:D8)
  5. Protect the template by clicking Protect Document on the Tools menu. Select Forms and click OK.
  6. Save and close the template.
Modification Type:MinorLast Reviewed:8/16/2005
Keywords:kbtemplate KB118439
©2004 Microsoft Corporation. All rights reserved.