Lab B: Full 3-Statement Configuration

Extend FictoCorp with CapEx, Balance Sheet, Cash Flow, and Geography

Module 2Lab45–60 min
📖 Tell Phase 2 Requirements FictoCorp is expanding to full 3-statement planning — what changes from Lab A and why.
👁 Show Instructor Preview Facilitator shows what the full 3-statement configuration looks like vs. Lab A — highlighting the key differences.
✅ Do Configure and Generate Complete Phase 2 configuration and generate the full FictoCorp application, including CapEx, Balance Sheet, and Cash Flow.
App Framework Financial Planning section — questions for margin planning, expense dimensionality, product and customer dimensions
Financial Planning section questions — configure margin planning approach, top-down targets, and product/customer dimensionality. For Lab B, also enable Balance Sheet and Cash Flow in the Top-Level questions section.
App Framework Headcount section — showing multi-currency support, department dimension, and Job term questions
Headcount section questions — multi-currency support (custom), department dimension separate from Entity, and Job term naming. Required for both Lab A and Lab B.
Application Framework overview page — 43 configuration questions, 4 models, 1 UX app, generation status showing last generated Jan 28 2026 with warnings
Application Framework overview after generation — 43 configuration questions answered, 4 models generated; the activity log shows generation events with any warnings; review logs immediately after generation to catch misconfigured questions before proceeding
IFP Financial Planning model — Source models tab showing CapEx and Headcount spoke models mapped to the hub
Source model mapping — after generation, map the CapEx and Headcount spoke models to your copy of the FP hub so data can flow between them. This step is required before running demos.
ℹ Starting Point

Begin with a fresh workspace or re-run the Application Framework from scratch. Do not extend Lab A's workspace.

What Changes from Lab A

SettingLab ALab B
CapExOption B — GL levelOption A — IFP CapEx Model
Balance SheetNoYes
Cash FlowNoYes
GeographyNoYes — Geography (2 levels: All Regions → Americas · EMEA)
Models GeneratedAdmin + FP + HC (CE deleted)Admin + FP + HC + CE (all 4 kept)

Requirements Brief — FictoCorp Phase 2

RequirementYour Configuration Choice
All Lab A settingsSame — Entity, Dept, Product, Customer, HC Option A, multi-currency
GeographyYes — Geography (2 levels)
CapExOption A: IFP CapEx Model
Balance SheetYes
Cash FlowYes — indirect cash flow
BS list namePlanning Account BS Hierarchy (default)
CF list namePlanning Account CF Hierarchy (default)
CE model questionsMulti-currency: Yes; IS + BS list names: defaults

Lab Steps

  1. Configure Top-Level questions — same as Lab A, plus Geography (2 levels), CapEx Option A
  2. Hierarchy Configuration — add Geography (2 levels, name: 'Geography')
  3. FP questions — same as Lab A, plus Balance Sheet: Yes, Cash Flow: Yes
  4. CE questions — multi-currency: Yes, IS list: default, BS list: default
  5. Generate and review logs
  6. Post-generation — complete all required tasks including CapEx General Admin setup
  7. CapEx General Admin — set entity-to-dept mapping, asset types, depreciation accounts, CWIP account, FX rate type
  8. Run FIN – Import from CapEx Model
  9. FIN – BS – Manage Planning Methods — assign a method to every BS account
  10. FIN – BS – Manage Cash Offset Accounts — categorize every BS account's cash impact
  11. FIN – BS – Cash Flow Mappings — map every leaf-level BS account to a CF line
  12. Run the Balancing Routine — confirm BS balances
⚠ CapEx Dimension Constraint

CapEx in v2.0 is planned at Entity level ONLY — no Department, Geography, or other dimensions. The entity-to-department mapping in CapEx General Admin handles distribution of depreciation costs to the correct P&L dimensions.

Debrief Questions

  1. What is the purpose of the Cash Offset Accounts mapping? What happens if an account is missing?
  2. Why does the Balancing Routine run month-by-month sequentially rather than all at once?
  3. If a customer wants to track CapEx by department, what are their options?
  4. When would you choose Geography at 3 levels vs. 2 levels?
  5. What is the difference between a Direct Load and a Transformation Load in ADO?
💡 Full 3-Statement Validation

After completing Lab B, check that the balance sheet balances by running the Balancing Routine, then navigate to Reporting & Analysis → Balance Sheet & Cash Flow Validations.

← PreviousNext →