Skip to content
Martin Danielsson edited this page Nov 17, 2025 · 1 revision

Maps boolean-like values to Acumatica-compatible boolean integers.

Description

The acubool operator converts various boolean representations (true/false, True/False, 1/0) to Acumatica's boolean format, which uses 1 for true and 0 for false.

Parameters

Parameter Type Description
value String The value to convert. Accepts: "true", "True", "1" (mapped to 1), "false", "False", "0" (mapped to 0), or any other value (defaults to 0)

Return Value

Returns "1" for true values, "0" for false values or any unrecognized input.

Example

Configuration

<Field name="IsActive">acubool($IsEnabled)</Field>
<Field name="IsDeleted">acubool("false")</Field>
<Field name="IsPublished">acubool($Published)</Field>

Input Data

IsEnabled Published
true 1
True 0
false yes
1 False

Output

IsActive IsDeleted IsPublished
1 0 1
1 0 0
0 0 0
1 0 0

Notes

  • The operator is case-insensitive for "true" and "false" strings
  • Any unrecognized value defaults to 0 (false)
  • This is useful when importing data into Acumatica, which expects bit/boolean fields as 0 or 1

See Also

Clone this wiki locally