Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
View Detailed Accounting Results

View Detailed Accounting Results

Security:
Prism Datasets: Create
 in the Prism Analytics functional area.
Create a custom report to view detailed accounting results.
  1. Access the
    View Accounting Source
     report.
  2. Select an accounting source for which you want to view detailed accounting.
  3. From the related actions menu of the accounting source, select
    Accounting Source
    View Implementation
    .
  4. In the
    Output Dataset
     column, click the Detailed Accounting dataset.
  5. On the
    Fields
     tab, click the
    Table View
     icon.
  6. Review some of the fields displayed:
    • Worktags and Additional Attributes
      : Are displayed in the far right of your dataset, with Additional Attributes prefixed with AA.
    • AC_Transaction_ID
      : Is a system-generated field that uniquely identifies transactions. When each row of your enriched data generates a balanced entry, each row represents a single transaction for which Workday generates a unique transaction ID. When Accounting Center groups multiple rows to generate a balancing entry with a user-supplied Transaction Grouping ID, Workday generates a unique transaction ID using the user-supplied Transaction Grouping ID.
    • Accounting Center Batch
      : Indicates the batch number for the detailed transactions.
    • Accounting Center Batch Run
      : Indicates the Detailed Accounting Batch Run stage completed by the batch run.
    • Accounting Source Snapshot
      : Click the snapshot to view the accounting source configuration that generated this line in detailed accounting. The format of this value is:
      • Name of the Accounting Source
      • Effective Date
      • Last Updated
    • Accounting_Source_Journal_Line_Rule
      : Refers to the row on your
      Journal Line Rules
       tab when you configure your accounting source.
    These fields might have Null values depending on your configuration.
    Null values aren’t errors.
    • Original Date of Reversed Journal
      : For reversal journals, displays the original date of the journal.
    • Intercompany Affiliate
      : For intercompany transactions, displays the name of the intercompany affiliate.
    • Intercompany Direction
      : Indicates whether line is an Intercompany Receivable or Payable.
    • Intercompany Type
      : Indicates intercompany accounting type. Workday supports the 2-sided use case and automatically generates both due-to and due-from entries in detailed accounting.
    • Transaction Debit and Credit Amounts
      : Amounts in your transaction currency.
    • Transaction Currency
      : The currency that you associate with a transaction when you create or edit it.
    • Ledger Debit and Credit Amounts
      : Transaction amounts in your ledger currency.
  7. These fields relate to currency conversion features:
    • Rounded as Biggest Line
      : Workday applies rounding adjustments to the largest line. Automatically populates to False.
    • Currency Rate Type
      : Type that identifies the source and purpose of a set of rates. Example: Current, Average, Historic.
    • Currency Rate
      : Rate used to convert transaction amounts to ledger amounts.
    • WPA_LoadID and WPA_LoadTimestamp
      : Are Workday generated columns.
  8. Create a derived dataset based on the Detailed Accounting dataset.
  9. Edit the data source security for the derived dataset to grant access to team members who need to see the data.
  10. Create a custom report using the Prism data source.
Report on your detailed accounting results with worktags and additional attributes as dimensions.