Skip to main content
Documentatie
Documentatie
Adaptive Planning
Laatst bijgewerkt: 2024-10-04
Manage Journal Line Summaries for Import

Manage Journal Line Summaries for Import

  • Create a Workday data source and credential.
  • Set up Security for Manage Journal Line Summaries.
  • Verify the registered API client for your Workday data source credential includes these Workday Owned Scopes in Scopes (Functional Areas):
    • Integration
    • Tenant Non-Configurable
    • System
    • Financial Accounting
  • Security:
    • Integration Build
       domain in the Integration functional area.
    • Data Designer
       and
      Integration Operator
       permissions in Adaptive Planning.
You can manage the Workday Financials journal line summaries you want to import as actuals in a Workday data source. By managing journal line summaries and creating integration systems you:
  • Don't need to select and manage individual reports within a Workday data source to import aggregated journal lines.
  • Avoid managing complex concatenations.
Each journal line summary imports as a separate staging table in the data source. Each field becomes a column.
Manage journal line summaries supports:
  • Up to 5 million journal line rows per period.
  • Ledger Currency related fields, only.
  • Balance sheet accounts.
  • Importing ending balance and translated amounts.
Manage journal line summaries doesn't support:
  • Custom calculated fields.
  1. Navigate to
    Design Integrations
     from the main navigation.
  2. Select a Workday data source configured with a Workday data source credential.
  3. From the
    Actions
     pane, select
    Manage Journal Line Summaries
    .
  4. (Optional) Click
    +
     to create folders to organize multiple integration systems.
  5. Click
    +
     and select
    Create Integration System
    .
  6. As you complete the integration system, consider:
    Optie Omschrijving
    Integration System Name
    The name for the integration system.
    Names can't contain spaces.
    Required Fields
    These fields automatically import from Workday Financials journal line summaries into Adaptive Planning:
    • Company.
    • Fiscal Period.
    • Ledger Account.
    • Ledger Amount for Natural Debit or Credit.
    Optional Fields
    Additional fields you want to import from Workday Financials into Adaptive Planning. Examples:
    • Cost Center.
    • Revenue Category.
    • Spend Category.
    • Business Unit.
    Company
    The company in Workday Financials to import journal line summaries from into Adaptive Planning.
    Ledger
    The ledger account in Workday Financials to import.
    Book
    The journal line summary book in Workday Financials.
    Amount Type
    • (View only) Activity. We recommend selecting income statement accounts in the Ledger Accounts and Summary Accounts prompt.
    • Ending balance. We recommend selecting balance sheet accounts in the Ledger Accounts and Summary Accounts prompt.
      You must contact your Named Support Contact or Professional Services/Implementer to enable this feature.
    Period Start Date
    The starting date for the period to import.
    Period End Date
    The ending date for the period to import.
    Report Effective Date
    (Optional) The effective date of the journal line summaries to import.
    Ledger Accounts and Summary Accounts
    (Optional) The ledger account and summary accounts to import.
    Additional Options
    (Optional) Include or exclude journals, report by date using plan structures, and other options. Examples:
    • Calculate Ledger Amount for Translated Beginning Balances.
    • Exclude Adjustment Journals.
    • Exclude Allocation Journals.
    • Exclude Pro Forma Journals.
    • Include In Progress Journals.
  7. (Optional) Create additional integration systems.
  8. (Optional) Drag and drop integration systems into folders to organize them.
  9. Apply changes and close.
  10. Select
    Import Structure
    .
    The column structure imports, but doesn't populate the rows with data.
  11. Save.
Select
Import Data
 to populate rows with data in the staging table.
Select
Repair
 to re-associate your managed journal line summaries after:
  • An Adaptive Planning tenant sandbox instance refresh.
  • An Adaptive Planning tenant migrates from sandbox to production.