Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Note
Community interest groups have now moved from Yammer to Microsoft Viva Engage. To join a Viva Engage community and take part in the latest discussions, fill out the Request access to Finance and Operations Viva Engage Community form and choose the community you want to join.
This article describes the Financial dimension configuration. There are two important areas for setup:
- The order of financial dimensions for financial reporting. Configure the order on the Financial reporting setup page.
- The data entity integration formats. Configure the formats on the Integrating applications page. You need data entity integration formats to import transactions that contain accounts and financial dimensions.
Financial reporting
The Financial reporting setup page lists all financial dimensions in the system (General ledger > Ledger setup > Financial reporting setup).
The Financial reporting setup page has two sections that determine the data you report on in Financial reporting:
- Dimensions tab - Different companies use different dimensions and account structures, so you need to set the order for how you want to view all financial dimensions on reports. Use this page to set the order for financial dimensions when you build and view a report in Financial reporting.
- Attributes tab - Select whether you want the ability to use Vendors and Customers as attributes for filtering and report design. Reporting on Vendor and Customer is only valuable if you don't enter multiple vendors or customers in a single voucher when posting transactions. Choosing Vendor and Customer adds extra time to the integration.
Note
To see changes in the financial reports, reset the Data Mart.
Data entities
Use the Data entities tab to define the order of financial dimensions for importing data. There's no rule about how you should set the order of your dimension formats. They're designed to be flexible so you can take your source files from an external system and import the data without spending time making the source files match your account structures. Dimension validation still occurs during the import process, to verify that you aren't importing financial dimension values that don't exist for a particular segment. However, outside validation, account structures and dimension formats are independent of each other. There are four dimension format types:
- Default dimension format – This format type is required when you import default dimensions, through both Data Management and the Microsoft Excel integration. For example, you might require a default dimension format if you're importing the financial dimensions that are associated with a customer or vendor account. Main account isn't included in this format.
- Ledger dimension format – This format type is required when you import ledger dimensions, through both Data Management and the Excel integration. The ledger dimension format is the most common format, because it's used any time that transactions are imported, such as through the general journal. The main account is specified on this format. This setting applies across all legal entities and the account structures used in your environment. The setup must include a cumulative set of all dimensions that can be used for transaction import across your legal entities. Any dimensions not used for a given legal entity are left blank in the import file.
- Budget register dimension format – This format type is required any time that you import dimensions for budgeting and budget control, through both Data Management and the Excel integration.
- Budget planning dimension format – This format type is required any time that you import dimensions for budget planning, through both Data Management and the Excel integration.
Note
The dimension format types aren't company-specific. The setup is a global setup. You can set up as many of each format type as you need, but only one format type can be active at one time. If you don't set up a dimension format type, you receive an error when you import. You also receive errors if the order is incorrect.
Let's look at some examples that show how the dimension formats work. We'll use the ledger dimension format for these examples.
Example 1
You're importing the following file.
| Date | Main account and dimensions | Amount |
|---|---|---|
| 6/1/2016 | 605140-001-02 | $150.00 |
| 6/1/2016 | 110110-002-04-ABC | $-150.00 |
When you import the file, the system reviews the Main account and dimensions column, and maps it to what you set up in the active ledger dimension format. For this example, the active ledger dimension format is as follows: Main account - Department - Cost Center
The first segment in the Main account and dimensions column is read as the main account. In this example, that segment is 605140 in the first row. Therefore, the mapping from the import file to the active ledger dimension format is as follows: Main account == 605140 Department == 001 Cost Center == 02
Now let's look at the second row. The second row contains a fourth segment, ABC. In this example, ABC is dropped during the import from the line: Main account == 110110 Department == 002 Cost Center == 04 Segment 4, ABC, isn't imported.
Example 2
For this example, use the same import file.
| Date | Main account and dimensions | Amount |
|---|---|---|
| 6/1/2016 | 605140-001-02 | $150.00 |
| 6/1/2016 | 110110-002-04-ABC | $-150.00 |
However, use the following active ledger dimension format: Main account - Department - Cost Center - Customer.
For the first row of the import file, because you define only three segments, the Customer segment is blank or dash: Main account == 605140 Department == 001 Cost Center == 02 Customer == blank.
Therefore, the string looks like this: 605140-001-02-.
The second row is imported as defined in the import file: Main account == 110110 Department == 002 Cost Center == 04 Customer == ABC.