Configuration Specific to Each System

Use the following links to jump to a section:

• Configuration Specific to Each System
•  
• Sage X3
• Sage 100
• Sage 300
• Acumatica

 

Sage X3

Opening Balance

If your accounts are not closed in Sage X3, Opening Balances must be loaded for each fiscal year.

Opening Balances generated from UDM are more detailed than those from Sage X3.

Therefore, this is why we highly recommend that you use Opening Balances from UDM and not the ones generated by the closing fiscal year from Sage X3.

To generate Opening Balances:

1. Make sure the @@X3SIMULATED global variable is enabled:
   1. In the Administration section , click on Global Variables in the left pane.
   2. Make sure the Script value is set to YES. If not, click on , change the value and click on Update.
      
2. In the Data Models and Views tab, expand the Universal Data Model folder.
3. Expand the Configuration and Sage X3 Specific folders.
4. Right-click on the Opening Balance data model and select View Info Pages.
5. In the Fiscal Year fields (From and To), enter the year for which you want to generate the Opening Balances and click on Calculate Open Balance depending on your server (SQL or Oracle).
   

Mapping of Analytical Dimensions

In order to do so:

1. In the Data Models and Views tab, expand the Universal Data Model folder.
2. Expand the Configuration and Sage X3 Specific folders.
3. Expand the Analytical Dimension Mappings data model and open the Mapping view.
   
4. Click on the cell of the module column then click on the Prompt symbol (purple question mark).
5. In the Prompt window, select the Dimension you want to map to the Analytical Dimension ID and click on Confirm.
   
   

6. After having loaded the Finance Staging cube (refer to Building and Loading Cubes for more details), whenever you will use Analytical Dimension (From Analytical Dimension 01 to Analytical Dimension 04 in relation to the example above) in your Views (in the right panel, click on to get access) from the Finance data model, it is the values you set in the Mapping view that will be used.

Sage 100

For Sage 100, there is no Chart of Accounts to set. Chart of Accounts are the same as Company IDs.

The only thing you need to do is to map the reference currencies to each of the companies.

In order to do so:

1. In the Data Models and Views tab, expand the Universal Data Model folder.
2. Expand the Finance and Configuration folders.
3. Right-click on the Sage 100 Ledger Currency Setup data model and select View Info Pages.
4. Under the Load Companies section, click on Import and close the window.
   
5. Expand the Sage 100 Ledger Currency Setup data model and open the Ledger Currency Setup view.
6. In the Ledger Currency column, enter for each Company their reference currency.
   

Sage 300

Mapping of Chart of Accounts

To set Chart of Accounts for each Company available in Sage 300, you need first to import the Companies.

To do so:

1. In the Data Models and Views tab, expand the Universal Data Model folder.
2. Expand the Finance and Configuration folders.
3. Right-click on the Sage 300 Chart of Accounts Setup data model and select View Info Page.
4. Under the Refresh Companies section, click on Import.
   
5. Once imported, assign to each of them a code of Chart of Accounts.

If the Companies share the same account structure, it is recommended to assign the same Chart of Account.

If not: assign a different code of Chart of Accounts and perform an Account Grouping (refer to Account Grouping for more details).

To assign a code of Chart of Accounts:

1. Expand the Sage 300 Chart of Accounts Setup data model and open the Company Setup view.
2. In the Chart of Account column, select a row and enter a code.
   

Mapping of Analytical Dimensions

In order perform analyses on Optional Fields, we must first map the Optional fields to Analytical Dimensions in UDM.

To do so:

1. In the Data Models and Views tab, expand the Universal Data Model folder.
2. Expand the Configuration folder and Sage 300 Optional Fields Mapping data model.
3. Open the Analytical Axes view.
4. Click on one of the row of the Optional Fields columns then click on the Prompt symbol (purple question mark).
5. In the Prompt window, select the Field Code you want to map to the Analytical Dimension ID and click on Confirm.
   

Choosing a default Sales Representatives

In Sage 300, you can assign multiple Sales Representatives to a Customer and assign a Percentage to them but there is no flag(indicator) to define the default Sales Representative. In order to define the default Sales Representative, we need to import the Customers with the 5 possible Sales Representative to a new table.

To assign a default Sales Representative:

1. In the Data Models and Views tab, expand the Universal Data Model and Configuration folders.
2. Right-click on the Sage 300 Customer Default Sales Rep data model and select View Info Page.
3. Under the Generate Sales Rep List section, click on Generate.
   
4. Expand the Sage 300 Customer Default Sales Rep data model and open the Default Sales Rep view.

In the generated list, the default Sales Representative is chosen by being the one with a higher percentage than the others. However, in cases where there are 2 Top percentage Sales Representative, you will need to define it manually through the Default Sales Rep column.

Acumatica

Mapping of Company

To set Chart of Accounts for each Company available in Acumatica, you need first to import the Companies.

To do so:

1. In the Data Models and Views tab, expand the Universal Data Model folder.
2. Expand the Finance and Configuration folders.
3. Right-click on the Acumatica Chart of Accounts Setup data model and select View Info Page.
4. Under the Refresh Companies section, click on Import.
   
5. Once imported, assign to each of them a code of Chart of Accounts.

If the Companies share the same account structure, it is recommended to assign the same Chart of Account.

If not: assign a different code of Chart of Accounts and perform an Account Grouping (refer to Account Grouping for more details).

To assign a code of Chart of Accounts:

1. Expand the Acumatica Chart of Accounts Setup data model and open the Company Setup view.
2. In the COA column, select a row and enter a code.
   

Opening Balances

To generate Opening Balances:

1. In the Data Models and Views tab, expand the Universal Data Model folder.
2. Expand the Finance and Configuration folders.
3. Right-click on the Acumatica Opening Balance data model and select View Info Pages.
4. In the Year fields (From and To), enter the year for which you want to generate the Opening Balances.
5. [Optional step] In the Company field, click on the Prompt symbol (question mark) to select the company for which you want to generate the Opening Balances.
6. Click on Run.