equestrian
Technical User
I am having a problem that is about to make me crazy!!!!
We are using Crystal 10.
I took an Aged Receivables report that shows the detail and changed some things.
First, I did not want to see certain customers. So, I used the Select Expert to omit them. No problem.
Next, I changed the report so that if a customer's balance is zero or less, the report does not list the account or the open invoices. Again, no problem
Next, I changed the report so that if the total invoices that are current is greater than or equal to the customer's balance, the report does not list the account or the open invoices. Again, no problem
The previous two omission were done with the following formula in the select expert:
Sum ({vr_08610dp.DocBal}, {Customer.CustId}) > 0.00 and
Sum ({vr_08610dp.Cur}, {Customer.CustId}) < Sum ({vr_08610dp.DocBal}, {Customer.CustId})
Here's the problem. I want totals at the bottom of the report that show the total for: current, 0 to 30, 31 to 60, 61 to 90, and Total respectively. These sums include the amounts from customers whose balance is zero or less and customers whose current balance is greater than or equal to the customer's balance. The invoices are not listed on the report, but they are included in the sum.
Any suggestions??
We are using Crystal 10.
I took an Aged Receivables report that shows the detail and changed some things.
First, I did not want to see certain customers. So, I used the Select Expert to omit them. No problem.
Next, I changed the report so that if a customer's balance is zero or less, the report does not list the account or the open invoices. Again, no problem
Next, I changed the report so that if the total invoices that are current is greater than or equal to the customer's balance, the report does not list the account or the open invoices. Again, no problem
The previous two omission were done with the following formula in the select expert:
Sum ({vr_08610dp.DocBal}, {Customer.CustId}) > 0.00 and
Sum ({vr_08610dp.Cur}, {Customer.CustId}) < Sum ({vr_08610dp.DocBal}, {Customer.CustId})
Here's the problem. I want totals at the bottom of the report that show the total for: current, 0 to 30, 31 to 60, 61 to 90, and Total respectively. These sums include the amounts from customers whose balance is zero or less and customers whose current balance is greater than or equal to the customer's balance. The invoices are not listed on the report, but they are included in the sum.
Any suggestions??