"sales ledger departmental analysis" sage line 50

[rockingroom]

I have run a report: "sales ledger departmental analysis" of all my customers to get an idea of my sales turnover and the report shows:
account ref - name - debit - credit - balance
now i understand all of the above except the balance figures.
I know that the balace is the diffrence between the debit and the credit but for example:
one of my customers has a debit of 119.00 and a credit of 139.83 this gives me a ballance of 20.83 but when i go into their account all of the debits add up to 139.83 and the credits add up to 139.83 so I dont understand why their is a balance of 20.83.
I thought maybe there is an invoice that has not been posted and the analysis has included this in the report but there is no unposted invoices.
Any help with this would be good
thanks

[brucedenney]

Are you using different periods? - Is there a transaction that is in a different financial year?

What version of Line 50 are you using ?

It could be that the report is not taking into account a part payment against an item.

Can you see a transaction for the differing amount somewhere?

[rockingroom]

The period is from the 13/11/2005 to the 13/11/2006
on some accounts there is older transactions but they are not included in the report and I have also figured it is not the diffrence between the invoice and the payment at a later date.

I am using line 50 V12.01.0034

We also rarley take deposits/part payments so I know this is also not the case.

Ive looked on their account and it all adds up to the same amount, i just can't figure out how it is calculating the balance
thanks for your post
phil