Microsoft KB Archive/118439

= WD: Subtotal Incorrect in Invoice or Purchase Order Template =

Article ID: 118439

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Word 6.0 Standard Edition
 * Microsoft Word 6.0a
 * Microsoft Word 6.0c
 * Microsoft Word 95 Standard Edition
 * Microsoft Word 95a
 * Microsoft Word 6.0 for Macintosh
 * Microsoft Word 6.01 for Macintosh
 * Microsoft Word 6.01 for Macintosh
 * Microsoft Word 97 Standard Edition

-



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:

 On the File menu, click Open. Change to the Template (or Templates) folder and open the Invoice or Purchase Order template. Unprotect the template by clicking Unprotect Document on the Tools menu. Double-click the Subtotal form field.  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)  Protect the template by clicking Protect Document on the Tools menu. Select Forms and click OK.</li> Save and close the template.</li></ol>

Additional query words: 6.00a invoice.dot invoice template 6.00c 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 KB118439

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.