I was testing the account sync IO data flow from NetSuite to salesforce, During testing of the account data flow, I found that when a customer is created in NetSuite, not all information syncs to the Salesforce account. The primary address and a few other fields are missing.
However, when the same customer is edited in NetSuite, all fields, including the primary address, sync correctly to Salesforce through the same flow.
Why this is not a mapping issue: the field mappings are identical for create and edit. If a field were mapped incorrectly, it would fail in both cases. Since the edit syncs everything correctly, the mappings are working as designed.
What this indicates: the issue is specific to the create event in the Celigo integration flow, most likely related to how or when record data is picked up from NetSuite at the time of creation. This is behavior in the integration layer, not something that can be fixed by changing the mappings.