Many of you already know this. However, I have seen time and again running into the same questions from consultants regarding the option of integrating capital module data with financials module.
In this post, I want to make it easy for you.
High Level Process Overview
At a high level the entire process can be broken down into 3 different sub-categories.
- Account dimension setup
- Financial Statement Mapping
- Data Map to Push data to Financials module
Let’s dive into each one in more detail.
Account Dimension Setup
The first thing to configure are the accounts that you want to use in Financials to capture the data from Capital Module. Let’s focus on few of expenses, mainly, depreciation, insurance, maintenance and repairs.
You need to configure the financials accounts you want to use as shared members rolling up to OFS_Capex_FinStmt_Integration.
The above screenshot shows you the 4 accounts being configured as children and rolling up to the OFS_Capex_FinStmt_Integration account. Remember that these are created as shared accounts.
