Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Planning Chart of accounts has Fixed Accounts and KPI accounts. When you first initialise the Planning CoA is easiest to copy the Operation CoA Fixed Account mapping to the Planning CoA Fixed Account mapping then adjust depending on level of detail in the Planning CoA.

...

See Draft: Mapping Fixed Accounts for a review on how Fixed Accounts are mapped.

To enable driver-based planning the follow Fixed Accounts must be mapped in the Planning Chart of Accounts.

...

Fixed Account

...

Please map these Fixed Accounts.

  • C3_

...

  • CTA - Cumulative translation adjustments - CTA

  • C3_TOTOPEX

...

  • - Total Operating Expenses

  • C3_NPAT

...

  • - Profit After Taxes

  • C3_EBIT

...

  • - Earning Before Income Tax

  • C3_EBITDA

...

  • - Earning Before Income Tax, Depreciation and Amortization

  • C3_AP

...

  • - Accounts Payable

  • C3_AR

...

  • - Accounts Receivable

  • C3_INV

...

  • - Inventories

  • C3_COGS

...

  • - Cost of Goods Sold

  • C3_CASH

...

  • - Cash and cash equivalents

  • C3_GP

...

  • - Gross Profit

  • C3_NCHGCASH

...

CF8999

...

  • - Net increase / decrease in cash and cash equivalents net of FX effect

Populate Plan Type

The core planning is broken up into Balance Sheet Planning, Revenue Planning and Expense Planning. Based on the Fixed Account mapping, populating the plan type determines which account is planned in which core planning module.

...

Reset Planning Flags: Override the existing Planning Flag with the calculated mapping. This should be set to Yes unless you are manually maintaining the planning module mappings (FIN Plan Type ID).

OCoA Mapping: Calculate the mapping from the Planning CoA to the Operational CoA.

...