WD: Subtotal Incorrect in Invoice or Purchase Order Template

ID: Q118439

The information in this article applies to:

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.

KBCategory: kbusage KBSubcategory: kbtemplate Additional query words: 6.00 6.00a invoice.dot invoice template 6.00c 7.00 word95 subtotal total negative calculate calculation incorrect word7 word6 wrong won't doesn't winword purchase order credit macword word97 7.00a 6.01 6.01a

Keywords          : kbtemplate 
Version           : 6.00 6.00a 6.00c 7.00 7.00a 97
Platform          : WINDOWS

Last Reviewed: February 6, 1998