Calculate Equity Pickup Results in AP&C
- Define equity pickup rules.
- Verify that the current ledger period status of the investor company isn't:
- Closed.
- Close In Progressfor theEquity Pickupjournal source.
- Not Available.
- Ensure that equity pickup journals for earlier fiscal periods are in aPostedstate before running equity pickup for subsequent fiscal periods to avoid processing errors.
- Configure theEquity Pickup Eventbusiness process and security policy in the Financial Accounting functional area so that you can approve journal entries for equity pickup before posting them to target and offset ledger accounts of investor companies.
- Security:Process: Equity Pickupdomain in the Financial Accounting functional area.
Record the equity earnings of a consolidated subsidiary onto the books of the parent company in Adaptive Planning and Consolidation (AP&C).
When you record equity pickup results in the base currency of a subsidiary, the journal entry displays in the subsidiary currency.
- Access theEquity Pickuptask.
- As you complete the task, consider:
Option Description CompanySelect the investor company or company hierarchy for recording equity pickup results.Equity Pickup RulesWhen you run equity pickup for 2 rules that use the same source and profit or loss accounts, Workday calculates equity for both.If you select multiple rules, Workday displays results for each rule when you run the task.TheEquity Pickuptask performs equity pickup for all rules simultaneously. It doesn't calculate them sequentially.Fiscal PeriodEnsure that periods are open for all investor companies to post equity pickup results.Source Book(Optional) Select a default source book for equity pickup. Leave blank to select source journals from the blank book code.Target Book Code(Optional) Select a book code to assign to the equity pickup journal entries. Leave blank to post equity pickup results to the blank book code.Post to Subsidiary CompaniesSelect to post the equity pickup journal entries to all investor companies. If you clear the check box, Workday won't create operational journals and sets the equity pickupStatustoComplete.Account Translation Rule SetSelect the rule to translate accounts in a subsidiary onto the parent books. - (Optional) From the related actions menu of theEquity Pickupbusiness process and security policy in the Financial Accounting functional area, selectView Accountingto display the equity pickupJournal Entry.
- When there's a pending approval step, the business process sets the:
- Equity pickup status toIn Progress.
- Operational journal status toPro forma.
- If there's no business process or you approved the equity pickup results, the:
- Equity pickup status isApproved.
- Operational journal status isPosted.
- If there's no accounting associated with the equity pickup results, the:
- Equity pickup status isComplete.
- The equity pickup process doesn't create an operational journal.
- (Optional) To cancel the results of an equity pickup run, find the results that you generated and selectCancelfrom theEquity Pickup Resultrelated actions menu.
When you process equity pickup, it creates a result for each investor company that you run the
Equity Pickup
task for. If you run the task for a hierarchy with multiple investor companies, Workday creates separate equity pickup results for each investor company and includes the:
- Percentage the investor company owns in the subsidiary.
- Source amount that Workday uses to calculate equity pickup.
- Provision amount that the equity picks up.
If you selected an ownership change adjustment ledger account on the equity pickup rule, Workday displays an
Ownership Change Details
tab on the result. You can use this tab to drill into how Workday calculates your equity pickup.
- Workday calculates direct ownership change adjustment amounts based on the:
- Change in ownership percentage from the current period to the prior period.
- Opening source amount at the beginning of the period multiplied by the ownership change amount.
- Workday calculates indirect ownership change adjustment amounts based on the:
- Current period ownership percentage.
- Source amount deriving from the direct ownership change adjustment result of the subsidiary on the same equity pickup run. Workday multiplies this value by the current period ownership percentage.
When no indirect ownership changes occur during the current period, Workday displays values of zero.
Use the
Find Equity Pickup Results
report to view previous equity pickup results.