Automated Accounts Payable Pipeline: Dext to Sage Intacct (Make.com)

1. **Initialize Scenario**: Log in to Make.com and create a new scenario. Name it 'Dext to Sage: Bill Sync'. 2. **Configure Dext Trigger**: Add the 'Dext - Watch Items' module. Create a connection using your Dext API keys. Set the trigger to 'Item Published' or 'Item Reviewed' depending on your internal approval workflow. 3. **Add Data Filter**: Click the link between the Dext and Sage modules. Set a filter to ensure only items with the status 'Ready' or 'Published' pass through to prevent incomplete data syncs. 4. **Search/Create Vendor**: Add the 'Sage - Search Vendors' module. Map the 'Supplier Name' from Dext. 5. **Router for Logic**: Add a Router. **Path A**: If Vendor exists, proceed to Create Bill. **Path B**: If Vendor is not found (null), add a 'Sage - Create Vendor' module first. 6. **Format Line Items**: If the invoice has multiple rows, use the 'Iterator' module on the 'Line Items' array from Dext, then use an 'Array Aggregator' to format them into the specific JSON structure Sage requires for its 'Invoice Lines' field. 7. **Map Sage Bill**: Add the 'Sage - Create Purchasing Invoice' module. Map the `Total Amount`, `Invoice Date` (using `formatDate` to ISO 8601), and `Reference Number`. 8. **Handle Attachments**: Add the 'HTTP - Get a File' module to download the document image from the Dext URL. Follow this with the 'Sage - Upload Attachment' module, linking it to the Bill ID created in the previous step. 9. **Add Error Handling**: Right-click the Sage module and select 'Add error handler'. Use a 'Break' or 'Rollback' directive, or send a Slack/Email notification to the admin if the API returns a 400 error (e.g., closed accounting period).