Custom Scheduling for Automatic...

TL;DR Opening

Custom scheduling for automatic imports allows businesses to define their own timings for bank transaction imports into NetSuite. This feature enhances data management and supports efficient bank reconciliation processes, moving beyond fixed daily timings.

Overview of Custom Scheduling

With the introduction of the custom scheduling feature, NetSuite users can now automate bank transaction imports according to their specific business needs. Previously, automated imports were restricted to a daily run between 4:00 AM and 7:00 AM Pacific Time, but now, flexibility is the focus.

Setting Up an Import Schedule

To set up a custom schedule for automatic bank transaction imports, users need to create or edit a format profile linked to a financial institution. The steps are as follows:

Navigate to Setup > Accounting > Financial Institution.
Select an existing format profile or create a new one by clicking Add under the Format Profile Configuration subtab.
Set the Profile Type to Bank Reconciliation and ensure the Connectivity Method is a connectivity plug-in, not Manual Import.
Open the Account Linking subtab to link a general ledger account to the profile.
Access the Import Schedule subtab where you can define:
- Frequency
- Interval
- Start date
- Start time
- Preferred time zone

Key Features of Import Scheduling

Flexible Timing: Users can specify exact timings suited to their banking data availability.
Default Values: When creating a new profile, defaults are set to every day with a randomized time between 4:00 and 7:00 AM.
Account Linking Required: Import schedules are only activated with at least one account linked.
Visibility into Imports: The last successful import date and time will be visible, enhancing tracking and management of bank reconciliation processes.
Batch Adjustments: Users can edit the import schedule even when the profile is inactive, facilitating convenience in management.

Important Considerations

Ensure all fields in the Import Schedule tab are either fully completed or left blank; partial entries are not permitted.
If any linked account lacks a mapping or is marked as Manual Import, the associated import schedule will be inactive, meaning no automatic imports will occur until conditions are met.

By enabling custom scheduling for automatic imports, NetSuite enhances operational efficiency and aligns transaction imports with precise business requirements.

Source: This article is based on Oracle's official NetSuite documentation.

Key Takeaways

Custom scheduling provides flexible automation for bank transaction imports.
Users can define frequencies, timings, and time zones per format profile.
Enhances data management and efficiency in reconciliation processes.
Default values are provided for new profiles, promoting ease of setup.

Frequently Asked Questions (4)

How can I ensure bank transaction imports are aligned with my local work hours?

You can select your preferred time zone when setting up the import schedule. This ensures that imported data aligns with your local work hours, providing more timely updates and streamlining reconciliation processes.

What happens if I set up an import schedule for an inactive profile?

Imports will not execute until the profiles are activated. Scheduling can be done for inactive profiles, but they must be activated to begin functioning.

How do I enable the Payment Date Prediction feature in NetSuite?

To enable Payment Date Prediction, contact NetSuite Support to request activation. Once activated by support, enable it under Setup > Company > Setup Tasks > Enable Features in the Accounting subtab with Administrator role access.

Which permissions are necessary to manage import email notifications for file uploads?

The 'Import Online Banking File (Create or Full)' permission is required to manage notifications for file upload success and error events.

Custom Scheduling for Automatic Imports in NetSuite