Syncing Regions to Dimension 1 Records

If the Sync Regions to Dimension 1 Records integration flow is enabled, SRP automatically creates and updates dimension 1 records when you create or update a region.

For more information about these objects, see the following:

How is the Accounting Reporting Code Field Populated for a Region?

In Accounting, each dimension record has a reporting code that must be unique. This is used alongside the dimension name to uniquely identify the dimension and is often included in reports.

SRP adds the Accounting Reporting Code field to the Region object. This field is mapped to the Reporting Code field on a dimension.

With the integration flow enabled, when you create or update a region, if the Accounting Reporting Code field is empty, SRP automatically populates it with the name of the region. Because the reporting code has a limit of 24 characters, if the value is longer, it is automatically truncated. In addition, the value must be unique.

How Can I Create Dimensions from Regions?

If the Sync Regions to Dimension 1 Records integration flow is enabled, dimension 1 records are automatically created when you create a region. This means that, unlike most SRP integration flows, there isn't a record page button, a list view button, or a scheduled process. The integration flow runs in real time.

In addition, if you change the value of the Region Name, Accounting Reporting Code, or Dimension 1 fields on a region, the matching dimension 1 record is automatically updated.

Can I Map Existing Dimension and Region Records?

If you manually created a matching dimension for each region in your org, you can manually correlate them. You can do this by populating the Dimension 1 lookup field on each region record.

What Information is Passed from a Region to a Dimension?

The following table lists how fields on the Region object map to the relevant fields on the Dimension 1 object.

Mappings Between Region Fields and Dimension 1 Fields

Region Field

Dimension 1 Field

Region Name Dimension 1 Name
Accounting Reporting Code Reporting Code
Currency ISO Code Currency ISO Code
Dimension 1 Record ID
Record ID Region