SageForum for UK versions of Sage 50- Help and support.

I am trying to print a detail line where an entry in a particular column is printed or left blank not by whether it is (e.g.) Debit or Credit but by the evaluation of an expression.

Example:

One column in the detail line is for sales invoice values (SI) or sales credit values (SC).

In the variable specification for the invoices and credits column, I would like to put something like:

if AUDIT_SPLIT.TYPE= “SI” or AUDIT_SPLIT.TYPE = “SC” then AUDIT_SPLIT.GROSS_AMOUNT

but this is an invalid expression.

Assuming that what I am trying to do is possible, any advice on how pls?

There is a different if statement which does work, this is just a quirck of the report designer.

<<Expression>>?<<Do_this_if_True>>:<<Else_Do_This>>

So your code should be

AUDIT_SPLIT.TYPE= “SI” or AUDIT_SPLIT.TYPE = “SC”?AUDIT_SPLIT.GROSS_AMOUNT:0