Data Load Rule in Close Management and Consolidation Sync

To add and set up a data load rule:

1. In NetSuite, go to NetSuite EPM > Close Management and Consolidation > Manage Jobs.

2. On the Manage Jobs page, do one of the following:

   • In the list of jobs, click Edit next to a data load rule of your choice.

   • If you do not see the data load rule in the list, click the Add Job button, and follow steps 3 through 6 in Adding a Job in Close Management and Consolidation Sync.

3. If you want to specify the accounting period during which the data load rule should be executed, click the Job Parameters subtab, and do the following:

   1. From the Period Type list, choose one of the following target date periods:

      • Relative to specify an accounting period that is relative to the current date.

        Note:

        If you have defined your custom accounting periods at Setup > Accounting > Manage Accounting Periods, the selected relative period may not function as expected.

      • Absolute to set up a specific date range.

      • Substitution Variables to use the substitution variables configured in your Financial Consolidation and Close to set up the start and end month and year of the accounting period.

        Note:

        The Substitution Variables period type is only supported for data load rules loading data. For data load rules loading metadata, the Absolute or Relative period types need to be used.

      For Relative and Absolute, you have the following options:

      • Start Period

      • End Period

      For Substitution Variables, you have the following options:

      • Start Period Month

      • Start Period Year

      • End Period Month

      • End Period Year

   2. Specify the Import Mode and Export Mode of the job execution, as defined in Data Exchange.

4. If you want to schedule the data load rule, click the Schedule subtab, and follow step 3 in Scheduling a Job in Close Management and Consolidation Sync.

5. If you want to override the saved search criteria next time a saved search is executed, click the Source Filters subtab, and do the following:

   1. In the Name column, add the names of source filters that are defined in your Financial Consolidation and Close. The field values must match exactly, including upper and lower case.

   2. From the Value list for each of the source filters in the list, select the substitution variables by which you want to filter the saved search results.

   Read the following details about using the source filters:

   • When you run the data load rule, this setting overrides the filters you have previously defined in NetSuite on the saved search record’s Criteria subtab.

   • When you want to use a different substitution variable for filtering, you can change it here instead of logging in to your Financial Consolidation and Close and changing it there. For information about how you can use NetSuite to manage substitution variables configured in your Financial Consolidation and Close, see Substitution Variables in Close Management and Consolidation Sync.

   • When you run the data load rule, and use source filters, you can expect the following behavior:

     • Close Management and Consolidation Sync applies filter operators you defined in NetSuite on the saved search record’s Criteria subtab.

     • Close Management and Consolidation Sync ignores the condition that is set for the source filters in Data Exchange.

     For example, if you set a date as a source filter value in Data Exchange, Close Management and Consolidation Sync applies the filter operator from NetSuite to that source filter.

     This functionality lets you pass the start and end date for a target period from Data Exchange to NetSuite, and filter NetSuite saved searches based on that target period. To pass the start and end dates, you can use the following variables as source filter values in Data Exchange:

     • $START_PERIODKEY[yyyy-MM-dd]$

     • $END_PERIODKEY[yyyy-MM-dd]$

     For more information about using these variables in Data Exchange, see Selecting Period Report Parameters from the Oracle ERP Cloud in the Oracle Help Center.

     Note:

     Make sure the date format you use when you set these variables in Data Exchange is compatible with NetSuite. For information about the NetSuite date formats, see Formatting Dates, Numbers, Phone Numbers, and Time.

6. Click Save.

Related Topics