🧩 Integration Logging & Monitoring Dashboard in NetSuite

Introduction

Integrations are the heartbeat of a connected ERP ecosystem — connecting NetSuite with Shopify, Salesforce, 3PLs, or internal systems.
But when data fails or records go missing, you need visibility — and that’s where a custom logging and monitoring dashboard comes in.

This tutorial will show you how to build a fully auditable, real-time integration log using custom records, saved searches, and SuiteAnalytics workbooks.

You’ll also learn to capture API errors, record payloads, and set up alerts — so you can monitor and debug integrations directly within NetSuite.

💡 Why Create a Logging Dashboard?

🧱 Step 1: Create Custom Record for Logging

Name: Integration Log
ID: customrecord_integration_log

✅ Permissions:
Grant “Full” access to Integrations Admin / Developer roles only.

⚙️ Step 2: Log Data via RESTlet or Script

Example RESTlet to log integration results:

/**
 * @NApiVersion 2.1
 * @NScriptType Restlet
 */
define(['N/record', 'N/log', 'N/runtime'], (record, log, runtime) => {

    const post = (request) => {
        const start = new Date();
        let status = 'Success', message = '', nsRecordId = null;

        try {
            // Sample: Create a Customer
            const rec = record.create({ type: 'customer' });
            rec.setValue('companyname', request.companyname);
            nsRecordId = rec.save();
            message = 'Record created successfully';
        } catch (e) {
            status = 'Failed';
            message = e.message;
        }

        // Log integration details
        record.create({ type: 'customrecord_integration_log', isDynamic: true })
            .setValue('custrecord_integration_source', 'Boomi')
            .setValue('custrecord_record_type', 'Customer')
            .setValue('custrecord_external_id', request.externalId || '')
            .setValue('custrecord_request_payload', JSON.stringify(request))
            .setValue('custrecord_response_msg', message)
            .setValue('custrecord_status', status)
            .setValue('custrecord_timestamp', new Date())
            .setValue('custrecord_duration', new Date() - start)
            .save();

        return { status, message, nsRecordId };
    };

    return { post };
});

✅ Result:
Every API call is logged with payload, result, and performance data — all visible in NetSuite.

🧮 Step 3: Create Saved Search for Monitoring

Saved Search: Integration Log – Daily Summary

Filter: custrecord_timestamp within this week

Add Highlighting Rules:

• Red for Failed
• Yellow for Warning
• Green for Success

📊 Step 4: Build a SuiteAnalytics Workbook Dashboard

Create Workbook → Base Dataset: Integration Log

Recommended Views:

• Chart 1: Success vs Failed (Bar Chart by Source)
• Chart 2: Average API Duration (Line Graph by Date)
• Pivot Table: Count of integrations per Record Type and Source

💡 Bonus Tip: Add this workbook to the Home Dashboard as a portlet for real-time visibility.

🔄 Step 5: Add Auto-Alert Notifications

Option 1 — Workflow Alert

Create a Workflow on the Integration Log record:

• Trigger: On Create
• Condition: Status = Failed
• Action: Send Email to Developer/Admin
• Subject: “Integration Error – ${custrecord_integration_source}”

Option 2 — Scheduled Script Summary

Run daily summary report and email it to your Integration Team:

email.send({
  author: 1234,
  recipients: ['integration@company.com'],
  subject: 'Daily Integration Summary',
  body: 'Today’s failed transactions: 3\nPlease review the Integration Log in NetSuite.'
});

🧠 Step 6: Real-World Dashboards

Add these dashboards as Home Portlets for Admin or IT Operations roles.

🧩 Advanced Features (Optional)

🔐 Security & Performance Best Practices

✅ Limit record visibility to Admin & Developer roles.
✅ Truncate old logs (>90 days) via scheduled script.
✅ Avoid storing sensitive credentials in payload fields.
✅ Use N/cache to reduce API lookup time.
✅ Compress JSON payloads using JSON.stringify(obj, null, 0) for efficiency.

⚡ Common Issues & Fixes

📚 Related Tutorials

• 👉 SuiteScript Security & Governance Best Practices
• 👉 Custom GL Plug-in for Audit Compliance
• 👉 SuiteAnalytics Workbook for Dashboards

❓ FAQ

Q1. Can this log be used for Boomi or Celigo integrations?
Yes — simply send API responses into this RESTlet from your middleware.

Q2. Can I link integration logs to original transactions?
Yes — add a field custrecord_related_transaction to link to Sales Orders or Invoices.

Q3. Can I visualize this data externally?
Yes — use SuiteAnalytics or export via Saved Search API to Power BI or Tableau.

Q4. Can I auto-delete old logs?
Yes — use a Scheduled Script or Workflow to purge records older than 90 days.

🧭 Summary

The Integration Logging & Monitoring Dashboard transforms NetSuite into a central integration control center.
By tracking every API call, logging payloads and outcomes, and visualizing success/failure trends, you gain full transparency and control across all external systems — Shopify, Salesforce, Boomi, 3PLs, and more.

This setup is essential for modern ERP teams that value visibility, accountability, and proactive troubleshooting.