Total on detail trial balance

[jackie1948]

I have a total line that has three calculations (beginning balance, activity for the month and ending balance). On all the account on the report the totals are correct but on one account the amounts are doubled on all three calculations. I have checked the account and there is not any double records. Does anyone have a suggestion as to how to solve this problem.

 

[DoubleD]

Any time there is doubling of data, the most common cause is a one-to-many join. Review your SQL to define what joins are happening, then check out the specific data on those tables to identify why you've got a one-to-many for that record, but only one-to-one for the rest.

I am what I am based on the decisions I have made.

DoubleD