Customer.Totaldue and TotalTax formulas
Good day
I have created a report in the way of Customer's statement to show certain orders based on their status. I have to sum total of these orders and total of tax of these orders. I have used Customer.OredersTotalDue and Customer.OrdersTotalTax templates from the right tree, but they give zero value. Can you please advise the formulas used by these commands so that I will try to adjust them?
This is what I use to select orders to show:
if({Customer.Order.Paid} || {Customer.Order.TotalDue} == 0 || {Customer.Order.Status} == "Cancelled" || {Customer.Order.Status} == "In Progress") return true;
And this is the formula:
if (IsDate({Customer.Order.DateInvoiced})) {
return {Customer.Order.OrderComments};
} else {
return "";
}
Thank you