A2X Payouts to NetSuite Journal Entries Sync (Make.com)

1. **Create Webhook in Make.com**: Add a 'Webhooks > Custom Webhook' module. Copy the unique URL and paste it into A2X under Settings > Notifications > Webhooks for the 'Payout Finalized' event. 2. **Configure NetSuite Connection**: Add the NetSuite module. Use 'Token-Based Authentication' (TBA). You must provide your Account ID, Consumer Key/Secret, and Token ID/Secret from your NetSuite Integration Record. 3. **Search for Subsidiary/Segment IDs**: Use the 'NetSuite > Search Records' module to find internal IDs for the Subsidiary, Department, and Class based on the A2X payout channel name to ensure dynamic routing. 4. **Handle Line Items with Iterator**: Add an 'Iterator' module to break down the `amounts` array from the A2X payload into individual bundles for processing. 5. **Transform Account Mappings**: Use the `switch()` function in a Variable module to map A2X Account Codes to your NetSuite Chart of Accounts internal IDs (e.g., `switch(A2X_Code; Amazon Sales; 4000; Shipping; 4010; 4999)`). 6. **Aggregate for Journal Creation**: Use an 'Array Aggregator' module. Set the 'Source Module' as the Iterator and specify the NetSuite Journal Line item structure as the target to group all debits and credits from one payout into a single bundle. 7. **Map NetSuite Journal Module**: Add the 'NetSuite > Create Record' module. Set Record Type to 'Journal Entry'. Map the Aggregated Line Items to the 'Line List' field. Use `formatDate()` for the transaction date to match NetSuite’s expected format (`YYYY-MM-DD`). 8. **Implement Duplicate Check**: Before creating the Journal, add a 'NetSuite > Search Records' module to check if a Journal with the same 'External ID' (A2X Payout ID) already exists. Use a Filter to only proceed if the search result count is 0. 9. **Configure Error Handling**: Right-click the NetSuite module and select 'Add Error Handler'. Use an 'Email' or 'Slack' module to alert the team if a Journal fails to post due to an unbalanced credit/debit or a locked accounting period.

| A2X Field | NetSuite Field | Transformation / Logic | Required | | :--- | :--- | :--- | :--- | | `payout_id` | `externalId` | Used for duplicate prevention | Yes | | `settlement_date` | `trandate` | `formatDate(date; YYYY-MM-DD)` | Yes | | `currency` | `currency` | Match ID via `Search Records` | Yes | | `lines[].amount` | `lineList.line.amount` | Use `abs()` for absolute values | Yes | | `lines[].type` | `lineList.line.account` | Use `switch()` or lookup table | Yes | | `lines[].description` | `memo` | `{{item.description}} - {{item.id}}` | No | | `subsidiary_id` | `subsidiary` | Manual Map or Dynamic Search | Yes |

* **Unbalanced Journals**: NetSuite will reject any Journal where Total Debits ≠ Total Credits. Use Make's `sum()` function on your array items before the Create Record module to validate balance. * **Rate Limiting**: NetSuite's TBA has strict concurrency limits. Set your Make.com Scenario 'Max number of cycles' to 1 to avoid 'SSS_TRANSACTION_LIMIT_EXCEEDED' errors. * **Date Formats**: Ensure your Make.com Organization settings match your NetSuite Date Format (e.g., DD/MM/YYYY vs MM/DD/YYYY) or use the ISO string format to avoid 'Invalid Date' errors. * **Internal IDs vs. Names**: Never map Names (e.g., 'Amazon Sales') to NetSuite fields; always use the Internal ID (e.g., '124') returned by a Search module.

- [ ] Trigger a 'Test Payout' from A2X and confirm the Webhook bundle is received in Make.com. - [ ] Check the 'Execution Logger' in Make to ensure the Aggregator correctly grouped all lines. - [ ] Verify in NetSuite that the Journal Entry is created with an 'External ID' matching the A2X ID. - [ ] Confirm the Journal Entry is 'Approved' if your NetSuite workflow requires it. - [ ] Intentionally trigger an error (e.g., use an invalid Account ID) to verify the Error Handler sends a notification.