Creating a Mapping Rule
ERP Cloud
By applying mapping rules, you can transform records from Planning or Accounting - Reporting Balances into Planning.
You must create a corresponding mapping rule to convert records from one dimension to another. You must specify the source of the records, where the information will be mapped, and the details you want to transfer across.
Creating a Mapping Rule from Other Sources
To create a mapping rule from Other Source data, perform the following:
- Do one of the following:
- On the Links page, click Modeling Rules | Mapping Rules.
- On the Planning Workspace tab, in the Navigation Pane, click Mapping Rules.
- Click New.
- Select the source as Other Source to create a new mapping rule.
- Select your source from the Source dropdown list, for example Sales Orders or Revenue Schedules Lines.
- Click Next.
- In the Name field, enter a unique name.
- In the Budget Year field, select a budget year. Budget Year start and end dates will be used to filter source records.
- In the Source Date field, select a Date Type field from the Source Object to filter records.
- In the Source for Budget Amount field, select a source.
- In the Budget Lines Grouping Criteria field, select a grouping criteria.
- In the Line Type field, select Expense or Income.
- [Optional] In the General Ledger Account field, select a general ledger account from Planning.
- Click Next.
- In the Budget Name field, use the populated name or enter a unique name.
- In the Company field, select a company.
- In the Budget Currency field, the corporate currency is chosen by default. If the previously selected Source for Budget Amount field is not a currency field, this field is disabled.
- In the Template field, select a budget template.
- [Optional] In the Parent Budget field, select a parent budget. Only parent budgets with the previously selected budget year are shown.
- [Optional] In the Description field, enter a description of the budget.
- Click Save or Save & Apply. After creating a budget, you will receive a confirmation email.