I'm encountering an issue with the IMPORT SCENARIO feature in Acumatica where a hardcoded value (e.g., =CBool('false')
) works correctly, but a formula (e.g., IIf( PMProject.IsCompleted = true, CBool('false'), CBool('true'))
) fails to insert the record into the target object.
Details:
- The import scenario is based on a generic inquiry resultset.
- The GI is based on a join between two objects (INLocation and PMProject).
- The target object is the warehouse summary and I am inserting records to the Locations → Location Table.
Formula:
IIf( PMProject.IsCompleted = true, CBool('false'), CBool('true'))
Question:
Has anyone else encountered this issue? If so, what was the solution? Are there any specific considerations or limitations when using formulas in IMPORT SCENARIO?