This appears to be a misunderstanding of the data shown. However, I do agree that the data as displayed (and exported) is not particularly useful at times, particularly for spotting things (invoices vs payments/credits) at a glance.
The Amount and O/S [amount] of a transaction are shown as positive numbers (regardless of type).
The O/S column shows the amount of the transaction that has not been matched off against another transaction. This has no effect on the overall balance of the account, just how the aging of the data is handled.
It would be more useful if Credits were shown, say, in Red (and/or as a negative number as they are stored internally - though for Supplier accounts this would have to be reversed with the Debits shown as negative and in Red for less accounting aware people (this reversal should be a user config option so that those with accounting awareness could have then the "proper" way round): the red shows a negative number which reduces the account balance).
The similar distinction on the Customer Receipt/Supplier Payment (credits as negative and/or in Red, subject to user preference over true accounting/casual user (as above).
As there is no running balance, I've written a macro[1] that takes the exported data, recreates the Amount column as the debit minus the credit value of the line and overwrites the O/S column (as I don't use it) with a running balance.
As a fix you could write a similar macro which then applies the sign of the new amount to the outstanding amount.
[1] I actually recorded what I did to "fix" the lack of a running balance for various activity that can be exported to excel and then merged them into a single macro which could determine the sheet and hence the "fix" needed. If you're happy to get around Sage's lack of proper features by using recorded macros, it may be easier to record a separate macro for each sheet requiring "fixing".
Guest
This appears to be a misunderstanding of the data shown. However, I do agree that the data as displayed (and exported) is not particularly useful at times, particularly for spotting things (invoices vs payments/credits) at a glance.
The Amount and O/S [amount] of a transaction are shown as positive numbers (regardless of type).
The O/S column shows the amount of the transaction that has not been matched off against another transaction. This has no effect on the overall balance of the account, just how the aging of the data is handled.
It would be more useful if Credits were shown, say, in Red (and/or as a negative number as they are stored internally - though for Supplier accounts this would have to be reversed with the Debits shown as negative and in Red for less accounting aware people (this reversal should be a user config option so that those with accounting awareness could have then the "proper" way round): the red shows a negative number which reduces the account balance).
The similar distinction on the Customer Receipt/Supplier Payment (credits as negative and/or in Red, subject to user preference over true accounting/casual user (as above).
As there is no running balance, I've written a macro[1] that takes the exported data, recreates the Amount column as the debit minus the credit value of the line and overwrites the O/S column (as I don't use it) with a running balance.
As a fix you could write a similar macro which then applies the sign of the new amount to the outstanding amount.
[1] I actually recorded what I did to "fix" the lack of a running balance for various activity that can be exported to excel and then merged them into a single macro which could determine the sheet and hence the "fix" needed. If you're happy to get around Sage's lack of proper features by using recorded macros, it may be easier to record a separate macro for each sheet requiring "fixing".