Efficiently Update Imported Data for NetSuite Connected Accounts On Demand

Managing your financial data in NetSuite has been taken a notch higher with the ability to update imported data for connected accounts on demand. This functionality is particularly useful for tasks involving bank reconciliation and corporate card expenses, providing real-time accuracy and efficiency in your financial processes.

Understanding On-Demand Updates

Previously, NetSuite users were limited to daily scheduled imports of transaction data available from their Account Information Service Provider (AISP). These AISPs include well-known names such as Yodlee, MX, Salt Edge, and American Express. With advancements in NetSuite plug-ins, users can now initiate data imports on demand, ensuring that transaction records are as up-to-date as possible. This is contingent on having the proper plug-in updates in place.

Note: For bank reconciliation, this feature only supports custom plug-in implementations. The Bank Feeds SuiteApp, for instance, does not currently support on-demand updates, although such support is anticipated in future releases by March 11, 2026.

Implementation Details

To utilize this feature, ensure that your system supports the required plug-in methods. Navigate to Setup > Accounting > Financial Institution, select a financial institution record, and view the Format Profile. A new Update Imported Bank Data button will be visible. This tool instigates an on-demand import for all connected accounts defined in the format profile, provided your plug-ins support it.

For an account-level update, the Update Imported Bank Data button on the Match Bank Data page is available, offering similar functionality for individual accounts.

Scheduled imports set at intervals of 6 or 12 hours have been improved to automatically prompt data updates if your system's plug-ins support such operations.

Limitations and Considerations

While this enhancement marks significant progress, there are limitations:

• The AMEX Corporate Card Integration SuiteApp uses a file-based import process. It only updates data if a new file is provided by American Express.
• Real-time updates or new file requests from American Express are not performed by the SuiteApp.
• In cases of update failure, account-level error messages may present themselves, providing feedback for troubleshooting.

Developer Insights

Plug-in developers should implement the refreshData(context) method in the Financial Institution Connectivity Plug-in to enable these on-demand updates effectively. For corporate card expenses, also implement getRefreshRequestStatus(context) to monitor and check the import status.

Here's a condensed example of the refreshData function:

function refreshData(context) {
    var configurationId = context.pluginConfiguration.getConfigurationFieldValue({fieldName: "configuration_id"});
    var configuration = loadConfiguration(configurationId);
    const accounts = JSON.parse(context.accountRequestsJSON);
    accounts.forEach(account => {
        const accountMappingKey = account.accountMappingKey;
        if (accountMappingKey === '123456') {
            context.addAccountError({
                accountMappingKey: accountMappingKey,
                errorCode: '2000001200'
            });
        }
    });
    // Corporate Card Expenses only
    context.setRefreshRequestId({ refreshRequestId: '1' });
}

Error Handling:

Should any data updates fail, the system will alert you with account-specific error messages, helping you diagnose and resolve issues quickly.

Key Takeaways

• On-Demand Updates: You can now refresh financial data from connected accounts in real-time using supported plug-ins.
• Button Accessibility: The Update Imported Bank Data button facilitates quick updates, subject to plug-in support.
• Scheduled Imports: Automatic updates are possible under certain configurations and support scenarios.
• Developer Implementation: Essential for developers to implement refreshData and getRefreshRequestStatus for full functionality.
• Limitations: Be aware of the current restrictions and planned enhancements, particularly concerning SuiteApps like the Bank Feeds and AMEX Corporate Card Integration.

Ensure your NetSuite environment is primed for these updates to make the most of on-demand data refresh capabilities!