Sage 50 Accounts - Report Designer. How show credits/account payments as negative on chaser letters

[rlellie14]

Hi, I'm trying to redesign the ICHASETERMS1 letter so that it includes unallocated payments and outstanding credit notes, regardless of their date. I've changed the criteria of the report so that it shows it but I need to change it to a negative value.

Currently the Expression is this:
Due > 0 ? AUDIT_SPLIT.DATE_FLAG <> 1 ? SignedAgedTransaction : 0 : 0
but I want to amend it so that if AUDIT_HEADER.TYPE is "SC" or SA" then SignedAgedTransaction needs to turn negative. I'm good with Excel but knowledge of those formula seem to be of no help here!!

Tried for a long time now, no luck!

Any help much appreciated

Thanks!

 

[MikeJ]

@johndon68 (I think) sorted a Sage problem for me many years ago. It costs, but it worked perfectly first time. Don't know if he still does this kind of thing,

 

[GLAbusiness]

CoPilot says:

Due > 0 ? AUDIT_SPLIT.DATE_FLAG <> 1 ?
(AUDIT_HEADER.TYPE == "SC" || AUDIT_HEADER.TYPE == "SA" ? -SignedAgedTransaction : SignedAgedTransaction)
: 0
: 0