Article ID: KWin0134
Added: 08/01/10 DM
Out of Balance Statements due to Large Numbers
The statement may display a message at the bottom "DO NOT SEND THIS
STATEMENT" indicating the report balance doesn't match the balance on the owner
master. The difference will be pennies. This is due to large numbers
posted to the owner for charges or payments.
Solution  Change the statement report using Crystal Designer
The solution is to round the amounts on the report by following the steps
below:
 Open the statement report in Crystal Designer.
 Do the following in each sub report, excluding the Owner 558 sub report
(there should be 6 sub reports to change):
 If there isn't a TotalCost formula:
 Create a formula called TotalCost where the formula is
Round({HExpense.TotalCost},2).
 Remove the HExpense.TotalCost field from the report and replace it with the
TotalCost formula.
 Change the summary of HExpense.TotalCost to the summary of {@TotalCost} by
rightclicking on the summary and choosing Edit Summary.
 In the OwnerPayments and OwnerDirectCharges sub reports, you need to edit
the TotalPayments and TotalCharges formulas, respectively, to use Sum({@TotalCost})
instead of Sum({HExpense.TotalCost}).
 In the BalanceForward and EndingBalance sub reports, the TotalCost field
isn't used. The MasterBalanceDue field is used instead. Edit the
BalanceForwardAmt and EndBalAmt formulas, respectively, to round the
MasterBalanceDue field.
 If there's already a formula for TotalCost, edit the formula and add
rounding to the TotalCost field.
 In Field Explorer, find TotalCost under HExpense or Command.
 Rightclick on it and choose Find in Formulas.
 Change each formula to round the TotalCost field.
 In Field Explorer, find MasterBalanceDue under HExpense or Command.
 If it exists, rightclick on it and choose Find in Formulas.
 Change each formula to round the MasterBalanceDue field.
 Save the report.
