Master Data Setup
Objective
-
Navigate to Main Menu > Files > My Files.
-
Select the model PnL_Admin_New.
-
Open the Account dimension by clicking on AdminCOA.
-
Select the Edit Dimension Table button for the Accounts dimension AdminXXX_COA.
-
Under the Edit toolbar, select the (+) Add button to add the Rebates Account with the following details:
- Member ID - PL011
- Description - Rebates
- Hierarchy - PL100
- Account Type - INC
- Rate - Average
- Aggregation - Sum
-
Repeat the above steps to add the Rebate % Account, with Member ID KP003 with the following details:
- Member ID - KP003
- Description - Rebate %
- Hierarchy - KP000
- Account Type - NFIN
- Aggregation - Sum
- Member ID - KP000
- Description - KPI
- Hierarchy - root
- Account Type - INC
- Rate Type - Average
- Decimal Places - 0
- Units & Currencies - Currency
- Save the changes made to the model by selecting the Save icon.
-
Navigate to Main Menu > Files > My Files.
-
Select the model PnL_Admin_New.
-
Open the Account dimension by clicking on AdminCOA.
-
Select the Edit Dimension Table button for the Accounts dimension AdminXXX_COA.
-
Under the Edit toolbar, select the (+) Add button to add the Rebates Account with the following details:
- Member ID - PL011
- Description - Rebates
- Hierarchy - PL100
- Account Type - INC
- Rate - Average
- Aggregation - Sum
-
Repeat the above steps to add the Rebate % Account, with Member ID KP003 with the following details:
- Member ID - KP003
- Description - Rebate %
- Hierarchy - KP000
- Account Type - NFIN
- Aggregation - Sum
- Member ID - KP000
- Description - KPI
- Hierarchy - root
- Account Type - INC
- Rate Type - Average
- Decimal Places - 0
- Units & Currencies - Currency
- Save the changes made to the model by selecting the Save icon.
