Enterprise Financials Data Imports

Enterprise Financials Data Imports

The following imports have been updated to align with the changes to Enterprise Financials:

Import Builder

Data for all five tabs can be imported using the Import Builder. You must map a minimum of four fields:

Project Job Code or Project ID. This is the project to add/update the data for

Account Code. The account code to add/update data for

The period. The period YYYYMM to update data for

[Tab name]. The value for the period and account code. The tab name needs to be one of Estimate, Budget, Forecast, Actual or Commitment.

If workflow is not configured for the selected tab, then iteration zero will be updated with the imported values which will replace any existing data for the code/period. If workflow is enabled, you can choose the action to take:

Update saved data only. The current iteration zero is updated (or a new iteration zero is created if there is not currently a saved version of the data)

Submit imported data to workflow. Iteration zero is updated AND submitted to workflow

Bypass workflow and create a new approved version. A new, approved, iteration is created with the imported data.

Financial Import (Admin)

The Financial Import (ADMINISTRATION | IMPORTS | FINANCIAL IMPORTS) has been updated to allow for the new Enterprise Financials model.

As with Import Builder (above), if workflow is configured, you can choose whether the data is submitted to workflow or directly to a new approved iteration.

Budget Import (Top Nav)

The Financial Import (TOP NAV | MANAGEMENT | FINANCE | BUDGET IMPORT) has been updated to allow for the new Enterprise Financials model.

As with Import Builder and the Financial Import (above), if workflow is configured, you can choose whether the data is submitted to workflow or directly to a new approved iteration.

Note: All of the functionality within the Financials Import and the Budget Import is also available in the Import Builder. Import Builder is the preferred way to import data into Enterprise Financials. We have updated the other two imports for compatibility and to ease the upgrade path for customers using these imports, but they may be deprecated in a future release.

For all imports, only data for supplied periods and account codes is updated. Any other values are unaffected. Therefore, if you need to clear previous values, the import file must contain zero values for those periods/accounts. This is current functionality and not a change introduced in this release.