Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

Terms Agreed Text

Report design issues and solutions.
Post Reply
JoesJo
User
User
Posts: 1
Joined: 04 Jul 2019, 13:50
Sage Version: Other

Terms Agreed Text

Post by JoesJo » 04 Jul 2019, 14:01

Hi ,

I am trying to adjust our invoice print template to show if a customer has credit terms agreed.

I can put on the field (SALES_LEDGER.TERMS_AGREED) easily enough but the data which is returned is either a "0" or a "1" depending on whether the box has been ticked or not

Is there a way with conditional formatting which can show predetermined text instead of the 1 or 0 eg:
if SALES_LEDGER.TERMS_AGREED = 1 "Terms Agreed"
if SALES_LEDGER.TERMS_AGREED = 0 "Terms Not Agreed"

Any suggestions would be greatly received.

Thank you :D

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: Terms Agreed Text

Post by brucedenney » 04 Jul 2019, 14:18

"IF" statements in the report designer are weird!

This expression should work, not sure if the flag is number or text, assumed number, if it is text you need quote marks around the 1

SALES_LEDGER.TERMS_AGREED = 1?"Terms Agreed":"Terms NOT agreed"

----------------------------------------------------
Format of a basic If statement

A typical If statement uses the following format:

Condition ? Instruction 1 : Instruction 2

where:

The ? command is used to mean then.

The : command is used to mean else.


The expression is therefore saying:

If the condition is true THEN apply instruction 1, ELSE apply instruction 2.

When constructing the If statement, you must always include at least one condition, an instruction 1 and an instruction 2.

Format of a nested If statement

You can specify more than one condition with different results within one expression.

This is a nested If statement.
Nested If statements use the following format:

Condition 1 ? Instruction 1 : Condition 2 ? Instruction 2 : Instruction 3


The expression is therefore saying:

If condition 1 is true THEN apply instruction 1, ELSE if condition 2 is true THEN apply instruction 2, ELSE apply instruction 3.

When constructing a nested If statement, you must always end the statement with an else instruction to cover when the specified conditions aren't met.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

Post Reply

Who is online

Users browsing this forum: No registered users and 10 guests