Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2025-07-25
Correct Consolidation Data in AP&C

Correct Consolidation Data in AP&C

You can review and correct line level errors once you have uploaded consolidation data of Adaptive Planning and Consolidation (AP&C) into Workday. After you resolve the errors, you can submit the corrections, if any for approval and creating accounting journals.
You can correct errors for the ledger account and worktags only.
  1. Access the
    Consolidation Data Hub
    report.
  2. Click
    Refresh
     to display all consolidation data uploads.
  3. For the consolidation data upload that you want to correct, click
    Correct
    .
    Workday will only display the
    Correct
     button if the Consolidation Data is in a
    Draft
     status. For more information on document statuses, see Load Consolidation Data into Workday in AP&C.
    Workday displays the
    Correct Consolidation Data
     task.
  4. (Optional) On the
    Line Summary
     section:
    • Click
      Errors
       and
      Warnings
       to view summary of line errors and warnings.
    • Review number of
      Updated Lines
       that have an error. You can't drill down to view the details.
  5. On the
    Search Criteria
     section, select a search category to narrow your results.
  6. As you narrow your search criteria, consider:
    Option
    Description
    Mapped Ledger Account
    Mapped Worktags
    Select mapped ledger account and worktags. To resolve these mapping errors, you can modify rules you defined in the mapping table. See Create Consolidation Data Mapping Tables in AP&C.
    Errors and Warnings
    Select errors or warnings that you want to correct.
    You can select a single error or warning or multiple errors or warnings.
    If you select more than 1 error or warning, only those lines that satisfy all the selected errors, or warnings will populate in the grid below.
    Row ID Minimum
    Row ID Maximum
    Select a minimum and maximum row that you want to retrieve in the grid.
    Only Updated Lines
    Select if you want to search for errors from lines you previously updated.
  7. Click
    Search
    .
    Workday loads a maximum of 250 lines at one-time in the grid, as specified by your criteria.
  8. Review these columns in the grid:
    Option
    Description
    Column Heading
    Represents the row from the .CSV file. Example: First row after header row will have a Row ID of 1, and so on.
    Mapped Ledger Account
    Ledger account that Workday maps after evaluating referenced mapping tables. If this field is blank, Workday was unable to find a mapping table rule match.
    Current Ledger Account
    Mapped ledger account plus any corrections (additions or deletions) that you want to submit as your final ledger account for the given consolidation data line.
    Mapped Worktags
    Worktags that Workday maps after evaluating referenced mapping tables. If this field is blank, Workday was unable to find a mapping table rule match.
    Current Worktags
    Mapped worktags plus any corrections (additions or deletions) that you want to submit as your final worktags for the given consolidation data line.
    Mapping Results
    Provides details of the mapping tables that Workday creates by the integration and input values from the .CSV values, and the output results.
    Memo
    Line level message that you can provide when performing error handling.
    Updated
    A
    Yes
     indicates that you’ve corrected a ledger account or worktags for this consolidation line from what you mapped.
    You can either select to update single lines individually or mass update selected lines in the grid.
  9. To correct single lines individually
    1. Select a line or lines in the grid.
    2. Enter the correct values for the current ledger account or the current worktag.
    3. Click
      Update
       to update the lines in the grid with the correct values to process any changes made.
      When you resolve errors or warnings and click
      Update
      , Workday updates the error/warning count in real time. Example: Workday initially displays 10 errors. As you keep resolving errors, the number of errors displayed on the
      Line Summary
       section will adjust accordingly.
      If you’re making changes to more than 20 lines at a time, review the number of
      Processing Lines
       under the
      Line Summary
       section that Workday is processing. Click
      Update
       again, to have Workday complete processing these lines.
      While Workday is processing the lines, you can't search for and modify these lines.
    4. (Optional) Click
      Save for Later
       if you want to review the lines before submitting them for approval.
    5. Click
      Submit
       to submit the lines for approval.
      Workday launches the
      Consolidation Data Journal Creation Event
       business process to submit the lines for approval.
      Submit will only display once Workday resolves all critical errors.
    6. (Optional) Click
      Cancel
       if you want to cancel your actions.
  10. To mass update lines
    1. Select the lines that you want to update in the grid. You can also select all of them if you want to update all lines in the grid.
    2. On the
      Mass Update Selected Lines
       section, select the correct values for the ledger account and worktag.
      Workday will apply the values that you specify to all the selected lines in the grid.
    3. As you select
      Actions
      , consider:
      • Add
        : Workday either adds the correct values to the missing values or replaces the existing values in the grid with the correct values.
      • Remove
        : Workday removes all existing values from the selected lines in the grid.
      • Do not apply
        : Workday won't apply any values in the grid. You'll have to enter the correct values individually for each transaction line in the grid.
    4. Click
      Update
       to update the lines in the grid with the correct values and process the corrections.
      When you resolve errors or warnings and click
      Update
      , Workday updates the numbers in real time. Example: Workday initially displays 10 errors. As you keep resolving errors, the number of errors displayed on the
      Line Summary
       section will adjust accordingly.
      If you’re making changes to more than 20 lines at a time, review the number of
      Processing Lines
       under the
      Line Summary
       section that Workday is processing.
      While Workday is processing the lines, you can't search for and modify these lines.
    5. On the
      Mass Updated Selected Lines
       section, for
      Actions
      , select
      Do not apply
       and then click
      Update
       again.
      Workday completes processing these lines.
    6. (Optional) Click
      Save for Later
       if you want to review the lines before submitting them for approval.
    7. Click
      Submit
      .
      Workday launches the
      Consolidation Data Journal Creation Event
       business process to submit the lines for approval.
      Submit will only display once Workday resolves all critical errors.
    8. (Optional) Click
      Cancel
       if you want to cancel your actions:
      • Enter a comment and click
        OK
        .
      • Click
        Done
         to navigate back to the
        Consolidation Data Hub
         report.