Print Invoices with Open Balance Only?

SUGGESTED

We send customer Invoices with their Statements at the end of each month.  Is there a way to print all Invoices with Open Balances ONLY?  This would be ever so helpful and time saving.

Thank you!

Parents Reply Children
  • 0 in reply to Coleen Graber
    Could you set up a Crystal Report that somehow only picked up the ones that are "open". Say with another template just for that, and then include those invoices with the statements? Just a thought. Not even sure if Business Works could do this.
  • 0 in reply to The Report Store.com
    SUGGESTED
    Crystal reports is a third party program that allows you write your own reports. You can use that program to create a custom reports or to create a custom customer statement for your company. If trying to recreate the Customer Statement report, you would want to work with someone who is knowledgeable in both writing Crystal Reports as well as the Sage BusinessWorks Data tables because it would be a sophisticated report to create since it would need to use calculation formulas, formatting, and multiple data tables (invoice, credit memos, debit memos, payments, etc.…). You can contact our client care at 800-477-5700 to assist with finding a reseller in your area to assist with Crystal Reports.

    The customer statement in Sage BusinessWorks is designed to print all history since the last statement date. Some customers minimize the history by printing the statement once to clear the historical information, then print it again to show only open invoices.

    For additional information on customer statements, please see KnowledgeBase article # 18706 “How to work with customer statements” or contact support directly at 800-447-5700 to discuss additional options.
    Thanks-
    Coleen