Hi
I have modifield a copy of the customers statement to show all orders ( Paid and outstanding )
Do you have a formula for adding up the total amount paid of all the orders. I have tried Customer.OrdersTotalPaid from the explorer but this just gives a result of 0.00
Customer.OrdersTotalIncTax just gives a result of the last order so ithink i need a way to add up amount paid
Cheers
Jowo
Jowo said:
Hi
I have modifield a copy of the customers statement to show all orders ( Paid and outstanding )
Do you have a formula for adding up the total amount paid of all the orders. I have tried Customer.OrdersTotalPaid from the explorer but this just gives a result of 0.00
Customer.OrdersTotalIncTax just gives a result of the last order so ithink i need a way to add up amount paid
Cheers
Jowo
Hi Jowo,
It looks like Customer.OrderTotalIncTax only gives the total of orders that are unpaid. It is not intended to give a total for all orders both paid and unpaid.
The Paperwork Designer wasn't really created for summing reports such as customer statements, these are usually handled by the main reports under the Reports Menu using reports that are in the Crystal Reports format.
So I don't think what you are trying to achieve will be doable under the current system.
PS. We have eliminated Crystal reports in the forthcoming Easify V4 and have replaced it with our own reporting engine. It won't allow for much customisability in the initial release, but it will allow us to increase your ability to tweak reports in the future.
HTH
Regards - Richard (Easify Developer)
Hi Richard
Ok thanks, Look forward to perhaps getting this report in the future
Richard said:
Jowo said:
Hi
I have modifield a copy of the customers statement to show all orders ( Paid and outstanding )
Do you have a formula for adding up the total amount paid of all the orders. I have tried Customer.OrdersTotalPaid from the explorer but this just gives a result of 0.00
Customer.OrdersTotalIncTax just gives a result of the last order so ithink i need a way to add up amount paid
Cheers
Jowo
Hi Jowo,
It looks like Customer.OrderTotalIncTax only gives the total of orders that are unpaid. It is not intended to give a total for all orders both paid and unpaid.
The Paperwork Designer wasn't really created for summing reports such as customer statements, these are usually handled by the main reports under the Reports Menu using reports that are in the Crystal Reports format.
So I don't think what you are trying to achieve will be doable under the current system.
PS. We have eliminated Crystal reports in the forthcoming Easify V4 and have replaced it with our own reporting engine. It won't allow for much customisability in the initial release, but it will allow us to increase your ability to tweak reports in the future.
HTH
