Customer Statement Run - excluding (current) zero balances?

SOLVED

Hi there

I am sending Customer Statements dated 30/09/2022 and selecting to exclude customers with zero balances, but Sage is of course looking at the account balance of my statement date. I have customers that have since paid i.e. their account balance is currently zero, but the payment was received AFTER the 30/09. Is there a setting in Sage to exclude customers whose CURRENT balance is zero, regardless of the statement date?

Unfortunately it is not possible to date the statements for a later date, due to the fact that there is a delay in the capturing of invoices - I do not want customers to receive a statement dated 04/10 showing as zero when in fact, we have yet to capture their invoices dated 03/10.

I also cannot generate statements manually as there are too many. So I'm looking for a setting in Sage or way I can get Sage to consider current balances in an automatic run.

Thank you.

  • +1
    verified answer

    Good Day Stacy,

    Please note that the Customer Statement prints based on the selected dates. It will print transactions up to the date selected either it is the Invoices or receipts. Unfortunately, we don't have a setting or option as it is the correct amount due on the date that the statement was done. However, we did log this through to our Development team as a suggestion.

    Unfortunately, I cannot provide you with a timeframe for the implementation at this stage. I have expressed the need for this feature to our development team.
    All suggestions are implemented on the system based on the number of requests and they should not drastically affect the functionality of the program.
    The more requests we receive for a specific feature the more likely it will be implemented on the system.

    Each release requires downtime of the site which we do try to minimize by releasing builds only when it’s necessary.
    We do get a lot of requests and it is not possible to get them all implemented based on individual business requirements when taking all of this into consideration.
    This is the reason that we take into account the number of requests and how it affects the current design and nature of the application.
    New features and enhancements require a new system design and go through an extensive quality testing process before it is released.
    Therefore it can take time before considered requests are added to the application.

    Should this feature be considered, it will be implemented in a future build update.
    You can refer to the release notes online after each build update to check what new features have been implemented to keep track of them.

    I trust you find the above in order and apologize for any inconvenience caused.

    Regards

    P.S. Please could you kindly verify and let us know that this solution worked. You can do this by marking this reply as a Verified answer so that the rest of the Community can benefit from this.

    To verify an answer simply go to your post and click “More” > “Verify Answer