Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2024-09-20
Example: Create Financial Plan to Actuals Composite Reports with Eliminations in AP&C

Example: Create Financial Plan to Actuals Composite Reports with Eliminations in AP&C

This example illustrates how to set up a composite report in Adaptive Planning and Consolidation (AP&C) that displays:
  • Company plan lines and actuals.
  • Intercompany transaction elimination options.
You want to create a composite report that applies intercompany transaction eliminations to your financial plan and actuals for comparison and viewing.
  • Set up elimination rules for your intercompany ledger accounts.
  • Enable intercompany affiliate worktags on intercompany elimination:
    • Plan lines for an existing plan.
    • Journal lines.
  • Security: these domains in the System functional area:
    • Custom Report Creation
    • Manage: All Custom Reports
  1. Access the
    Copy Standard Report to Custom Report
     task.
  2. Select
    Financial Plan to Actuals
     from the
    Standard Report Name
     prompt.
  3. Click
    OK
    .
  4. Enter
    Financial Plan to Actuals with Eliminations
     in the
    Name
     field.
  5. Click
    OK
    .
  6. Access the
    Edit Custom Report
     task.
  7. Select
    Financial Plan to Actuals with Eliminations-Financial Plan Consolidation Sub-Report
     from the
    Report Name
     prompt.
  8. Click
    OK
    .
  9. In the
    Prompt Defaults
     grid on the
    Prompts
     tab, clear the
    Do Not Prompt at Runtime
     check box for these fields:
    • Eliminations Only for Plan
    • Perform Intercompany Eliminations for Plan
  10. Click
    OK
    .
  11. Access the
    Edit Custom Report
     task.
  12. Select
    Financial Plan to Actuals with Eliminations
     from the
    Report Name
     prompt.
  13. Select
    Edit
     from the related actions menu of the C3 column header.
  14. On the
    Value Type
     column in the
    Map Sub Report Prompts
     grid, select
    Prompt User for Value at Run Time
     for these prompt fields:
    • Eliminations Only for Plan
    • Perform Intercompany Eliminations for Plan
  15. Click
    OK
    .
  16. Access the
    Prompts
     tab in the report settings.
  17. Select the
    Populate Undefined Prompt Defaults
     check box.
    When you select the check box, Workday populates the
    Prompt Defaults
     grid with undefined prompt defaults based on the configurations on the subreport. The check box automatically clears once Workday finishes updating the
    Prompt Defaults
     grid.
  18. On the
    Prompt Defaults
     grid, clear the
    Do Not Prompt at Runtime
     check box for these fields:
    • Eliminations Only
    • Perform Intercompany Eliminations
  19. Click
    OK
    .
  20. Click
    Run
    .
    Select these check boxes to display only intercompany transaction eliminations lines on your reports:
    • Eliminations Only
    • Perform Intercompany Eliminations
    • Eliminations Only for Plan
    • Perform Intercompany Eliminations for Plan
    When you don't select the check boxes, Workday displays all plan lines and actuals on your reports.
When you run your custom report, you can compare your data and check for any variances on:
  • All plan lines and actuals with eliminations.
  • Only intercompany eliminations for plan and actuals.