Skip to main content

Supplier balance does not match outstanding transactions

Updated this week

Using multi currency

It is possible to post transactions to a supplier account in multiple currencies. It is also possible to enter these transactions with a 0 in one of the currency fields. For example, £50 and €0.
This will cause the transaction to only appear with a value of £50 when the transactions are shown as their £GBP value. When the transactions are listing using their €EUR value it will show a value of €0.

In this situation, the total balance for an account will be £50, but when the list of transactions is displayed in €, the total of the outstanding column for the transactions will be 0.

To change the view:

  1. Open the Transactions window for the supplier in question. A new window appears with a grey bar along the top.

  2. On the right of the grey bar, use the drop-down and select the different currencies from this list. This will allow you to see the transactions that have a value in one currency and not in another.


Not using multi currency (or the above didn't resolve the issue)

To resolve this issue Support will need to run some scripts on the database. Therefore please raise a new case online and reference the title of this article and include details the account(s) affected.

Did this answer your question?