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 Reply Children
  • 0 in reply to BigLouie

    If you want to sort already grouped data, you need to insert your sort field as a higher level group (then suppress the new group's header / footer) and then use the group sort expert.  

    With grouping by a date field, beware the default is to group by week instead of by day.