Easify Forums

Forums -> Paperwork Designer

 Addition formula

Post Reply
Page 1 of 1 1
Posted by Jowo

Addition formula

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

Posted by Richard

Re: Addition formula

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)

Posted by Jowo

Re: Addition formula

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

Post Reply
Page 1 of 1 1

Easify Website V 5.0    © 2024 Easify Ltd ® All rights reserved.     Privacy Policy