TUG Tip - Sage 100 Contractor

TUG Tip -- Sage 100 Contractor 

Use a CASE Statement for a More Readable Report

Do your Report Users wonder what "status 1" is? Or a Gender of "1" on a report?

You can solve this with a CASE statement. In the example below you see a Calculated Field for the Job Status in a report:

CASE(actrec.status,1,Bid,2,Refused,3,Contract,4,Current,5,Complete,6,Closed,NA)

Note the format is to list the field, then each possible choice with the desired output. The final choice (in this case NA) would be applied to any fields that are not provided for in the statement.

Using this calculated field provides data that makes more "sense." You can name the choices whatever you want- you are not limited to the field's "actual" choices.