Sage 200 Reporting – Help:
Help and Support
Joins – INNER / OUTER / STATIC
Joins are drawn from the Left Hand Side table to the Right Hand Side table.
Logic Statement – IF-THEN-ELSE
A logic-test statement is evaluated and will be either TRUE or FALSE
Replace the IF with the logic-test. Replace the THEN with the TRUE result . Replace the ELSE with the FALSE result (or another IF-THEN-ELSE construct for a nested function).
True / False – Combined with AND / OR / NOT
A LOGIC statement will evaluate as either TRUE (1) or FALSE (0). Be careful when testing for a variable to be NULL. A NULL value is NOT the same as an EMPTY string.
NULL or EMPTY – What is the difference?
What is a NULL value? Consider the stock table and the supplier table. These tables can be linked to relate the suppliers associated with the stock record.
When viewing the Stock Record’s <Supplier> tab there may be no listed suppliers, there may be a single supplier or there may be many suppliers.
If there are any suppliers listed one of them will also be recorded as the preferred supplier. However, if there are no listed suppliers then we have a NULL scenario.