How can I get a running balance to appear on statements?

SOLVED

I am using SAGE 100 4.5, and Crystal XI. When I look at the statement in Crystal, there appear to be two options for displaying invoices on statements. Details A has the invoice total in the "Balance" column, and Details B has a running balance. We would like to display the running balance in the last column, since that would be more helpful than repeating information that appears in the other columns already. This way, customers would know the total amount of the invoices from the earlier month on their statement without having to add it up themselves, which sometimes leads to a math error and a balance left subject to service charges. Is there any way to choose that option?

Also, is there any way to direct focus to a service charge so that the customer realizes that it's there? Print in another color, or separate it from the list of invoices somehow?

Thanks for any help offered.

Parents
  • 0
    verified answer

    For question #2:

    You can use the highlighting expert in Crystal Reports to change the font color based on a condition within your data.

  • 0 in reply to BShockley

    Thank you! I was able to get them to show up in red, since there is a description for the finance charges. Had there not been, I'm not sure how I would have done it, but fortunately, I don't have to find out. :) I need to do more playing with Crystal, and read the PDF that I was sent to see what useful info it might contain.

  • 0 in reply to melinda_b
    verified answer

    Never mind, I found the solution through trial and error. I don't know if the solution is within the Crystal help files, but I didn't stumble across it. I switched the suppression conditions for Details a & b, and now have running balances indicated in the final column of statements, as well as finance charges printed in red. Thanks again to BShockley for your help.

Reply
  • 0 in reply to melinda_b
    verified answer

    Never mind, I found the solution through trial and error. I don't know if the solution is within the Crystal help files, but I didn't stumble across it. I switched the suppression conditions for Details a & b, and now have running balances indicated in the final column of statements, as well as finance charges printed in red. Thanks again to BShockley for your help.

Children