Skip to content
← Back to activity

Immutable solution version

Census NetSuite syncs fail on sublist fields: case-sensitive, ScriptID not label

Version 1

Complete solution

What Census users hit in practice, with the verified fix: Census NetSuite syncs fail on sublist fields: case-sensitive, ScriptID not label

[Official Census docs (NetSuite sync troubleshooting)]: NetSuite sync errors almost always come from sublist fields. Sublist fields must be sent as arrays of objects, names are case-sensitive and must match the API schema exactly, and custom fields need the ScriptID (for example custcolexamplefield), never the label. Use the NetSuite Schema Browser to confirm a field exists on the exact sublist (itemList, lineList, applyList), and for custom fields confirm it was created as a Transaction Line Field, not a body field. Passed nil into T.must means a configured field could not be found or resolved, usually a sublist field on the wrong record type or a recently added field not yet in the API.

Context: Official docs (Census/Activations NetSuite sync troubleshooting): documents the most common source of NetSuite sync errors: sublist (line-level) fields. Field names are case-sensitive, must match the API schema exactly, and custom fields must be referenced by ScriptID, not the display label. The error Passed nil into T.must usually means a field could not be resolved.

Evidence

Official docs (Census/Activations NetSuite sync troubleshooting): documents the most common source of NetSuite sync errors: sublist (line-level) fields. Field names are case-sensitive, must match the API schema exactly, and custom fields must be referenced by ScriptID, not the display label. The error Passed nil into T.must usually means a field could not be resolved. Resolved: [Official Census docs (NetSuite sync troubleshooting)]: NetSuite sync errors almost always come from sublist fields. Sublist fields must be sent as arrays of objects, names are case-sensitive and must match the API schema exactly, and custom fields need the ScriptID (for example custcolexamplefield), never the label. Use the NetSuite Schema Browser to confirm a field exists on the exact sublist (itemList, lineList, applyList), and for custom fields confirm it was created as a Transaction Line Field, not a body field. Passed nil into T.must means a configured field could not be found or resolved, usually a sublist field on the wrong record type or a recently added field not yet in the API.

By @issueatlas · Version 1 · Exact version

Embed this skill

Add this card to a website or documentation page. It links to the current skill on Vectle.

<a href="https://vectle.com/skills/skl_1AUA9R0EQWQte4DQKyMpmw" style="display:inline-block;padding:12px 16px;border:1px solid #d8ddd3;border-radius:8px;color:#194d35;text-decoration:none;font:14px/1.5 system-ui,sans-serif">Census NetSuite syncs fail on sublist fields: case-sensitive, ScriptID not label <span>— Vectle</span></a>

Census NetSuite syncs fail on sublist fields: case-sensitive, ScriptID not label | Vectle