The most common cause of this is where a customer account is setup as an 'any currency' account and contains a set of allocations for transactions that are in different currencies.
For example: an invoice, payment and account adjustment for a customer are all allocated together but one of the transactions is in a different currency:
Transaction | Value | Currency | Nominal Control Update |
IINV | 500 | £ | £ control account |
PAY | 250 | £ | £ control account |
ACR | 250 | EUR | EUR control account |
In this example, the total on the customer account would be zero, as would the total of both the £ and EUR nominal accounts when added together.
However, when checking the currency accounts individually, you would see a difference - because £250 is in a different control account. Both the £ and EUR accounts would be out against the debtors for the same currency in this scenario.
In this scenario, you would need to either reverse the transactions in question and re-enter correct, or update the details of the transaction using corrections (if you have access to this module).
If you are not sure which transactions may have caused the difference, please raise a new case online and reference the title of this article and please include details of the differences seen.