Symptom
Writeback fails if the value being written is a comma-separated list (e.g., 7064,857), returns an error message similar to:
“Error: The '7064857' list value is not allowed for the Value field. The allowed values are (...).”
Cause
The add-in interprets comma-separated list values as locale-formatted numbers and strips the commas, turning the values 7064,857 into 7064857. This results in invalid data being sent to Acumatica, which then rejects the value.
While we are working to fix the issue, please use the workarounds documented below.
Workaround
Option 1: Specify Data Type as text in DataColumnNames
Explicitly define the data type for the affected column as text in the DataColumnNames argument of your WRITEBACK function. This prevents the add-in from modifying the value.
Example:
WRITEBACK($B$3, "IN202500", "item attributes", {"Inventory ID", "Multi-select", "Color"; "default", "text", "default"}, , A6, B6, C6)
In this example, the second column (Multi-select) is set to text.
For more details, see the dedicated section of the article about the WRITEBACK function.
Option 2: Send One Value Per Row
Instead of sending a comma-separated list in a single cell, send each value in a separate row if your workflow allows it.