Skip to Main Content
Sage 200 UKI Ideas Portal

Please note the following Sage 200 Ideas Portal Guidelines apply to the use of this portal.

Status Idea Accepted - Gauging Support
Categories Generate Payments
Created by sarah wall
Created on Sep 9, 2025

Exclude accounts with Negative Cheque Balance from Suggested Payment Report

The suggest payment report is almost useless as it includes accounts with a negative balance.

There is no way to filter out these accounts so they don't show on the report which means you have to manually remove the negative amounts from the report value to check that the amount you are paying is what you wanted to pay.

Could there be a filter or tick box to exclude negative balance accounts

Idea Benefit To make the report usable without having to manually adjust the amount
How do you solve for this problem today? We currently have to go through report and add up the amount of negative accounts and remove this amount from the report total which depending on how may accounts there are can take quite a while
Product Variant Sage 200 Professional
  • Tony Davis-Coyle
    Nov 10, 2025

    This could be achieved very quickly by amending the report design. Your BP should be able to help with this. Bear in mind though, that this report reflects the data that is being used for the payment run, so taking that as gospel, with a filter for negative balances applied, would perhaps be a little dangerous.

    The whole payment process, isn't simply a case of running the suggestion, and then generating the payments. The suggestions should be reviewed, modified, and then reported on to ensure that what you're expecting to pay, is what your final report is showing.