Account Reconciliation Sync SuiteApp: SuiteQL Query Support, Pipeline Jobs, and Terminology Changes

What changed

SuiteQL query support for transaction data loads (v26.1)

You can now write SuiteQL queries to pull transaction data and metadata from NetSuite into Account Reconciliation. This replaces or supplements saved-search-based data loads and gives you direct control over the SQL sent to the analytics data source. Refer to Manage SuiteQL Queries in Account Reconciliation Sync in SuiteApp help for syntax and field-mapping details.

Inbound connection verification (v26.1)

A new Use Entered URL to Verify Inbound Connections checkbox has been added to the connection setup (step 3 of Setting Up the Connection to Account Reconciliation). When enabled, NetSuite validates that the originating Account Reconciliation instance URL matches the configured value before accepting inbound calls. This is a security hardening measure — enable it in all production environments.

New job types schedulable from NetSuite (v26.1)

• Pipeline jobs — can now be scheduled and executed directly from within NetSuite.
• Import Profiles — a new job type with its own parameter configuration screen.

Terminology and UI changes (v26.1)

• Data Load Rule jobs are now called Data Integration jobs throughout the UI. Any custom scripts or saved searches referencing the old label in logs or descriptions should be updated for clarity.
• Relative period options in Data Integration and Group jobs have been renamed:
  • This Month → This Period
  • Last Month → Last Period
  • New option: Period Before Last
• The Job Calendar page UI has been refreshed.

CSV cleanup option (v26.1)

After a Data Integration job completes, you can now opt to automatically delete the imported CSV file from the Inbox/Outbox Explorer in Account Reconciliation, reducing file clutter and limiting data-retention exposure.

Security improvement (v26.1.1 — July 7, 2026)

Version 26.1.1 includes an unspecified security-related improvement. Oracle provided no further detail. Check SuiteApp release notes or contact support if you need specifics before upgrading.

What to do

1. Update the SuiteApp — Install or update to Account Reconciliation Sync v26.1 (or v26.1.1 for the security patch) via SuiteBundler or SuiteApp Marketplace.
2. Enable inbound URL verification — In Setup > Account Reconciliation > Connection, check Use Entered URL to Verify Inbound Connections and confirm your Account Reconciliation URL is correctly entered.
3. Migrate any saved-search-based loads to SuiteQL (optional) — If you want tighter control over the data sent to Account Reconciliation, build SuiteQL queries using the new management screen. Test queries in the SuiteQL query tool or via N/query first to validate results.
4. Review scheduled jobs — The rename from "Data Load Rule" to "Data Integration" is cosmetic, but if you have scripts, workflows, or monitoring that key off job names or log strings, update those references.
5. Update period selections — If you previously configured relative periods using "This Month" or "Last Month", verify that the renamed values (This Period, Last Period) mapped correctly after upgrade. Consider using the new Period Before Last option where applicable.
6. Evaluate Pipeline and Import Profile jobs — If you currently trigger these from the Account Reconciliation side, you can now schedule them from NetSuite for centralized job management.