Defining and Managing Flows

This chapter provides an overview of defining and managing flows and discusses how to:

• Set up flow processing.

• Manage source flow input.

• Manage journal flow input .

• Process source and journal flows.

• View data flows.

Understanding Data Flows

PeopleSoft Enterprise Global Consolidations flows feature provides the ability to capture the change in account balances for a specified period. By considering the different type of flows (or activities) affecting the net balance of an account, you can reconcile account variation using account activities that traditional ledger mapping of accounts is unable to capture.

Data flows for consolidations are used to track and reconcile gross variation. Gross variation is the difference between the opening and closing balances of an account, which can be caused by many activities. For example, the gross variation of fixed asset accounts could be distinguished by additions, disposals, asset impairment, currency translation, and reclassification. Reporting the data flow for specific accounts is often required as part of regulatory reporting.

To track flow amounts you establish flow codes. Flow codes can track each of the activities associated with account balances so that you can easily determine the impact of each activity on the change in account balance. There are two types of flow codes: pre-defined system flow codes and manual flow codes:

• System flow codes capture the system-generated information you need for any type of account, such as the opening balance of an account, the closing balance, translation adjustments, and the total amount of change.

  The amounts associated with these flow codes are captured by the system. You cannot change them. System flow codes are pre-defined. You can modify certain attributes of system flow codes, but you cannot create your own.

  See Using System Flow Codes.

• Manual flow codes capture additional activities that are specific for certain types of accounts, such as the acquisition and disposal of fixed assets. The amounts associated with these flow codes can be entered manually, or captured by the system if the manual flow codes are added to consolidation rules and journal entries. You can review, change, and add the amounts for manual flow codes.

  PeopleSoft provides several pre-defined manual flow codes with the sample data that you can import to your database. You can also create your own.

  See Defining Manual Flow Codes.

Flows are further categorized as source flows and journal flows:

• Source flows are amounts associated with the source data after it goes through the ledger preparation process and can be tracked by both manual and system flow codes. Source flows are entered in the local book currency and translated at both the closing and cash flow rates.

• Journal flows are amounts associated with journal entries or batches posted for the consolidation fiscal year and period, and can be tracked with both manual and system flow codes. Journal flow amounts are entered in the consolidation currency.

Flow templates link the flow codes with specific accounts. They specify the ledger template and effective date, which flow codes to use, and which accounts to use the flow codes with. You can also preview a flow template. There are two types of flow templates:

• Manual flow templates are used to capture flow information with a combination of system and manual flow codes. For example, you could set up manual flow templates to track fixed asset activity, investments, stock holder's equity, and short and long term debt. You enter and review the amounts for manual flow templates on the Source Flow Input and Journal Flow Input pages.

  See Setting Up Flow Templates.

• System flow templates capture account activity that is calculated automatically by the system and use only system flow codes. For example, system flow templates can track changes in balances for accounts receivable and accounts payable used for cash flow reporting.

All of the flow templates that you want to use for a specific consolidation ledger are specified in a flow group. The flow group is associated with the consolidation model.

See Defining Flow Groups.

Two processes are run to update flow information:

• The Source Flow Update process updates both system-generated and manually input flow data associated with the source data.

  See Running the Source Flow Update Process.

• The Journal Flow Update process updates both system-generated and manually input flow data associated with journal entries for the consolidation fiscal year and period.

  See Running the Journal Flow Update Process.

Phases of Flow Processing

There are three phases of flow processing:

• During the set up phase you turn on flow processing, set up manual and system flow codes, set up manual and system flow templates, assign flow templates to a flow group, and assign the flow group to the consolidation model.

  You can also add manual flow codes to consolidation rules as targets so the system automatically captures flow amounts for those consolidation entries.

• During the ledger preparation phase, you input, review, and correct amounts for manual flow codes on the Source Flow Input page as needed, and then run the source flow update engine.

• During the consolidation and reporting phase you run the consolidation engines, post manual journals (assigning flow codes to journal lines), run Journal Flow Update, and then review, correct, and add manual flow amounts as needed on the Journal Flow Input page.

Steps for Setting Up Flow Processing

This diagram illustrates the step you complete to establish flow processing.

Steps for setting up flow processing

You complete these basic steps when setting up flow processing:

1. Turn on and setup flow processing on the consolidation Ledger Template.

   See Establishing Flow Processing.

2. Modify descriptions for system delivered flow codes and select those system flow codes that you want to appear on your flow templates to suit your reporting purposes.

   See Using System Flow Codes.

3. Set up manual flow codes that you want to use for your flow templates.

   See Defining Manual Flow Codes.

4. Assign flow codes and accounts to manual and system activity flow templates. You generally set up flow templates for related groups of accounts, whose changes are captured by the same activities.

   • Manual flow templates specify which flow codes (columns) and which accounts (rows) appear on the Source Flow Input and Journal Flow Input pages. Manual flow templates are designed for users to review, correct, and add flow amounts. They combine both system flow codes and manual flow codes.

   • System activity flow templates are used to automatically capture change in account balances used for cash flow reporting. You can review the amounts for system activity flow templates on the Flow Inquiry page.

     See Inserting Flow Codes in a Flow Template.

5. Optionally, assign manual flow codes as targets to consolidation rules.

   If manual flow codes are assigned to consolidation rules, the system automatically captures the flow amounts when the consolidation engines are run.

Example: Tracking Fixed Asset Flow Information

The manual flow templates are designed so that users can enter information for financial statement footnotes and cash flow analysis. The templates contain system flow codes to track changes in account balances as well as foreign currency translations, and manual flow codes to track specific types of activity related to the account, such as asset acquisitions and dispositions. If the user has multi-currency business units, then all source flow information must be translated at a closing rate and at a cash flow rate. To illustrate this concept, the following example is presented.

Suppose that fixed asset opening, closing, change, and flow activity amounts (Acquisitions & Disposals) are the following in a foreign currency:

FXAJ1 and FXAJ2 are system flow codes that represent foreign currency translation and are calculated by the system. ACQ and DISP represent manual flow codes that are used to track acquisitions and disposals, respectively. Note that the flow codes of FXAJ1, FXAJ2, ACQ, and DISP add up to the Change amount.

Assume the following exchange rates.

When the amounts and balances are translated at the Closing Rate you would see the following.

Open balance of 100 is translated at opening rate of 2, which equals 200.

Close balance of 200 is translated at closing rate of 4, which equals 800.

Change amount is 600.

ACQ amount is translated at closing rate of 4 multiplied by 200, which equals 800.

DISP amount is translated at closing rate of 4 multiplied by -100, which equals -400.

FXAJ1 represents the difference between the closing rate of 4 multiplied by the opening balance (4 X 100=400) and the opening rate of 2 multiplied by the opening balance (2 X 100=200), which equals 200.

When the amounts/balances are translated at the Cash Flow Rate or average rate, you would see the following:

Open and close balances as well as the change amount are still the same as above.

ACQ amount is translated at average rate of 3 multiplied by 200, which equals 600.

DISP amount is translated at closing rate of 3 multiplied by -100, which equals -300.

FXAJ1 is the same as above.

FXAJ2 represents the difference between the closing rate of 4 multiplied by the flow amounts (4 X (200-100)=400) and the average rate of 3 multiplied by the flow amounts (3 X (200-100)=300), which equals 100.

Note. Combining FXAJ1 and FXAJ2 flow codes with the cash accounts will produce the net affect of currency translation line item on the cash flow statement.

Setting Up Flow Processing

This section discusses how to:

• Establish flow processing.

• Use system flow codes.

• Define manual flow codes.

• Set up flow templates.

• Insert flow codes in a flow template.

• Insert an account set in a flow template.

• Preview a flow template.

• Define flow groups.

• Assign flow codes as targets to consolidation rules.

Pages Used to Define Flows

Establishing Flow Processing

Access the Ledger Template, Consolidation Variables page and locate the Flow Processing group box at the bottom of the page.

To establish flow processing for the selected consolidation ledger template, in the Flow Processing group box select the Flow Processing check box and define which flow records are used.

Using System Flow Codes

Access the System Flow Codes page.

System flow codes are predefined by the system and are used to track system-generated amounts. These system flow codes and descriptions are delivered with Global Consolidations. You can change the short and long descriptions and the default settings, but not the flow code.

These fields are displayed on the System Flow Codes page:

The following table lists the seven system flow codes and their definitions.

Defining Manual Flow Codes

Access the Manual Flow Code page.

Manual flow codes are defined by the user to track account activity and are used in manual flow templates. You must take into consideration the nature of the account when creating manual flow codes. The flow codes should track the types of activities that affect the balance of the account.

To define a new manual flow code, on the Manual Flow Code - Add a new value page, enter the SetID and five digit Flow Code ID for the flow code, and then specify values in the following fields on the Manual Flow Code page:

Setting Up Flow Templates

Access the Flow Template - General page

You define a flow template by specifying SetID and Flow Template ID. On the Flow Template - General page, you specify the following:

See Understanding Data Flows.

System Flow Templates

You use the same pages to define system flow templates that you use to define manual flow templates. There are some differences, however, in how you set up the definitions.

If you are producing a cash flow statement using the indirect method, then other changes in activity from balance sheet accounts need to be translated at the cash flow average rate, such as accounts receivable or accounts payable. In this case, a separate system flow template must be setup to capture the change in activity.

Note. The system flow template only needs to be used if the user is consolidating business units in a foreign currency.

Inserting Flow Codes in a Flow Template

Access the Flow Template - Flow Codes page.

Add the flow codes that you require for your flow template and place them in the display order in which you want them to be displayed. If you want to review or edit a flow code, you can click the flow code description link to display the definition of that particular flow code.

Inserting Account Sets in a Flow Template

Access the Flow Template - Account Set page.

The account set in a flow template is made up of accounts that would logically be associated with the flow template. For example, on a fixed assets manual flow template, you would add accounts associated with fixed assets.

Note. If you specify an account in a system flow template that is also listed on a manual flow template, and both flow templates are part of the same flow group, the account in the system flow template will be excluded during flow processing.

There is no setup for node-level currency conversion rules except on the Flow Template - Account Set page. If a detail account or node with Validate set to Detail is selected on the Flow Template - Account Set page, then the currency conversion refers to the currency group set at the consolidation model level.

Previewing a Flow Template

Access the Flow Template - Template Preview page.

Select View/Refresh Template to display the format of the flow template. The Flow Template - Template Preview page displays the layout of the flow template and how it will appear on the Source Flow Input and Journal Flow Input pages. If you change the parameters of flow codes and/or account set on the previous flow template pages and then navigate to the Template Preview page, update the preview by clicking the View/Refresh Template button.

The format is in rows for accounts and columns for flow codes. Values calculated by the system are identified with #####. Values determined using manual flow codes are blank.

Previewing a System Flow Template

Like the Flow Template - Template Preview page for a manual flow template, the Template Preview page for a system flow template displays the layout of the system flow template. It displays the accounts specified on the Flow Template - Account Set page in rows. It also displays the system flow codes from the Flow Template - Flow Code page in columns. Because this template is system derived, you can only review amounts for system flow templates on the Flow Inquiry page. The amounts are displayed in the consolidation currency.

See Viewing Data Flows.

Defining Flow Groups

Access the Flow Group page.

After the flow templates have been completed, you must associate the templates with a flow group and associate the flow group with the consolidation model. Use the Flow Group page to associate manual flow templates with a flow group and indicate whether the flow group includes system flow templates.

Assigning Manual Flow Codes as Targets into Consolidation Rules

After flow setup is complete, you can use manual flow codes as targets within the consolidation rules.

If you assign manual flow codes to consolidation rules, the system generates flow amounts when the consolidation engine is run and the Update Flow Amounts check box is selected on the run control page

This example shows how flow codes are used in a Non-Controlling Interest rule:

Refer to Define Consolidation Rules, Setup Equitization Rules or Setup Elimination Rules or Setup Non-controlling Interest rules for further information on setting up flow targets on the rules.

The flow amounts captured by consolidation rules are categorized as journal flow amounts, and can be reviewed and modified on the Journal Flow Input page.

See Also

Defining Elimination Rules

Defining Non-Controlling Interest Rules

Defining Equitization Rules

Managing Source Flow Inputs

This section provides an overview of source flow input amounts and discusses how to:

• Enter Source Flow Input amounts.

• Review the Source Flow Summary.

Understanding Source Flow Input

Use the Source Flow Input page to enter and review flow amounts for the source balances that are brought in to the consolidation ledger by the ledger preparation process. For each manual flow template that you establish to work with your consolidation model, you can review, change, and add source flow amounts for manual flow codes on the Source Flow Input page. The manual flow template establishes which accounts and flow codes are displayed on the Source Flow Input page.

Source Flow Input page 1 of 2

Source Flow Input page 2 of 2

This example shows the Source Flow Input page for the Fixed Assets template. The Account, Description, and Book Code are all derived from the values specified on the Fixed Assets manual flow template. The amounts in the Open, Close, and Change columns are all derived using the system flow codes specified on the Fixed Assets manual flow template. The columns for ACQ (acquisition), DISP (disposition), Reclass (reclassification), and Impair (impairments), are used to enter actual amounts for the manual flow codes associated with the Fixed Assets template. Because source amounts for the manual flow codes cannot be extracted by the system, you must enter them manually.

After source flow input amounts are entered and validated, you update the flow activity record by running the Source Flow Update process.

You can also use spreadsheets to upload source and journal flow amounts.

See Using the ExcelToCI Spreadsheet Upload Facility.

Source Flow Input and Ledger Format

When defining ledgers, you select one of these formats: trial balance or financial statement. The way the balances are stored and how the consolidation entries are recorded differ for each format, so the Source Flow Input page also differs depending on what Global Consolidations sources are used to derive the opening and closing balances.

See Understanding Ledger Templates.

This table explains the differences in the Source Flow Input page, depending on whether you are using the trial balance or financial statement ledger format:

Note. When using the financial statement ledger format, if the period selected is the first period, then the opening balance will be derived from the last period of the previous fiscal year.

See Consolidation Data Sources.

Pages Used to Manage Source Flow Input Amounts

Entering Source Flow Input Amounts

Access the Source Flow Input page

You enter source flow amounts (also called inputs) for a manual flow template in the source currency by ledger business unit. If book code functionality has been turned on at the system level, then you enter source flow amounts by book code for that ledger business unit.

The Source Flow Input page lists the opening, closing, and change amounts for the accounts specified on the selected flow template. The opening and closing balances are derived from the consolidation ledger from the source in the source currency. In the manual flow code columns, review, change, and add flow amounts that tie to the change amount.

Reviewing the Source Flow Summary

Access the Source Flow Summary page

The Source Flow Summary page lists the flow code, short description and description. This page allows you to review the opening and closing balances in total for the template as well as the total flow activity.

Using Spreadsheets to Upload Source and Journal Flow Data

In addition to entering flow amounts manually, you can also enter source and journal flow amounts using the spreadsheet upload process.

See Also

Using the ExcelToCI Spreadsheet Upload Facility

Managing Journal Flow Inputs

This section provides an overview of entering journal flow input amounts and discusses how to:

• Assign Flow Codes to Journal Lines.

• Enter and review Journal Flow input amounts.

• Review the Journal Flow Summary.

Understanding Journal Flows

As with source flows, you enter journal flow amounts (inputs) for each manual flow template. The Journal Flow Input page is designed to for users to review, change, and add flow amounts resulting from journals or batches within Global Consolidations. On this page, you can either add flow amounts for journals or batches where no flow codes were specified, and review and update flow amounts for journals or batches where flow codes were specified.

There are two ways in which amounts for journal flows are captured by the system:

• Assign manual flow codes as targets in consolidation rules. When the consolidation engines are run, the system captures these journal flow amounts.

  Note. The Update Flow Amounts option must be selected on the run control page.

• Enter flow codes on manual journal entry lines. The flow codes and accounts on the journal entry line must be include in a manual flow template associated with the consolidation model, or the flow amounts will not be processed.

After the journal flow amounts are reviewed, changed, or added, and validated on the Journal Flow Input page for a template, you update the flow activity record through the Journal Flow Update process.

See Running the Journal Flow Update Process.

Journal Flow Input and Ledger Format

When installing Global Consolidations, you can choose the ledger format to use: trial balance or financial statement. Because how balances are stored and how the consolidation entries are recorded differ according to the ledger format, the Journal Flow Input page also differs for each format as to what Global Consolidation sources are used to derive the opening and closing balances, and the change amount.

See Understanding Ledger Templates.

This table explains the differences in how balances are derived on the Journal Flow Input page, depending on whether you are using the trial balance or financial statement ledger format:

Note. When using Financial Statement ledger format, if the period selected is the first period, then the opening balance will be derived from the last period of the previous fiscal year.

See Consolidation Data Sources.

Pages Used to Manage Journal Flow Inputs

Assigning Flow Codes to Journal Lines

Access the Journal Entries page

If the flow code functionality has been turned on for the consolidation ledger template, you can enter manual flow codes on journal lines, along with the account, amount, and other information.

After the journal entry has been posted, run the journal flow update engine to update the flows to the activity record. The flow amounts will appear in the journal flow input page for the manual flow template. When entering flow codes for journal lines, it is important to select a flow code where both the flow code and the account exist on a manual flow template that is included in the flow group associated with the consolidation model, or the flow amounts will not be processed.

Note. If a journal entry is created with an account where the account exists on a system flow template, then the system activity flow code will be assigned to the journal line amount.

Note. If a journal entry is created with an account where the account exists within a manual flow template and the account set is a node option with a validation at the node level, then the amount will be recorded on the flow activity table with the tree node specified from the template.

Entering and Reviewing Journal Flow Input Amounts

Access the Journal Flow Input page.

You enter journal flow amounts for each affected manual flow template in the consolidation currency by ledger business unit, and if book code functionality has been turned on at the system level, by book code.

The Journal Flow Input page has the same functionality as the Source Flow Input page with a few exceptions.

• Journal flow amounts are entered in the consolidation currency.

  (Source flow amounts are entered in the source currency.)

• Journal flows are reconciled against the change amount and no open and close balance columns are displayed.

  The change amount is derived from journals (manual, recurring, or reversing) allocations, or consolidation entries. If no change amount exists for the account, then the account will not appear on the Journal Flow Input page for the selected template.

The Attachments hyperlink and Validate button operate as they do on the Source Flow Input page.

Reviewing the Journal Flow Summary

Access the Journal Flow Summary page.

The Journal Flow Summary page lists the flow code, short description and description. You can review the open and close balances in total for the template as well as the flow activity.

Processing Source and Journal Flows

This section provides an overview of the flow update process and discusses how to:

• Run the Source Flow Update process.

• Run the Journal Flow Update process.

• Run the Flow Flattener.

Understanding the Flow Update Process

Flow processing is divided into two phases: Source Flow Update and Journal Flow Update.

Source Flow Update

The source flow update engine validates, translates, and updates the flow amounts to the flow activity record. Even though the templates may be validated, the engine revalidates the flow amounts for the template.

Because the source flow amounts are entered in the source currency, the source flow update engine translates the source flows into the consolidation currency if the source currency is not the same as the consolidation currency. The engine translates the flow amounts both at the closing rate and the cash flow rate.

See Establishing Currency Rules.

After the engine runs, it updates the flow activity record, and sets the status of the flow template to Done. The engine also updates the Source Flow status on the Ledger Enrichment Manager.

See Viewing Source Flow Status.

Journal Flow Update

The journal flow update engine performs two functions.

• It processes all posted and unposted journals/batches for flow updates.

  Even if there are no flow amounts attached to a journal, the system keeps a log that the journal/batch has been processed.

• The engine updates the flow information from the journal flow input templates.

  The journal flow update engine validates and updates the flow amounts to the flow activity record. Even though the journal flow input amounts may have been validated for a manual flow template, the engine re-validates the flow amounts.

After it is run, the journal flow update engine updates the flow activity record, and sets the status of the flow template to Done. The engine also updates the Journal Flow status and Flow Journals Pending Status on the Consolidation Manager page.

Note. The Journal Flow Update engine does not perform any translations because all journal flows are entered in the consolidation currency.

Flow Flattener

The Flow Flattener application engine populates the flow flattener table, which designates the flow template and accounts by business unit, scenario, fiscal year, and accounting period. This table is a key input for the Flow Inquiry. The system calls the Flow Flattener application engine when the Source Flow Update or Journal Flow Update application engines are run. Occasionally, you may need to run this engine separately. You can access the Flow Flattener run control page to run this application engine, if needed.

Pages Used to Process Flow Updates

Running the Source Flow Update Process

Access the Source Flow Update run control page.

Unit, Scenario ID, Fiscal Year, and Period	Enter the common consolidation business unit, scenario ID, fiscal year, and accounting period to process.
Run Group ID and Ledger Unit	Select either a run group ID to process or a single ledger unit (the business unit associated with the ledger).

Running the Journal Flow Update Process

Access the Journal Flow Update run control page.

Unit, Scenario ID, Fiscal Year, and Period	Specify the common consolidation business unit, scenario ID, fiscal year, and accounting period to process.
View Pending Batches	Click to view pending or posted batches on the Journal Flow Update - Pending Batches page. This does not have the same functionality as in the Post process. All the pending batches will be processed.

Selecting Pending Batches

Access the Journal Flow Update - Pending Batches page.

Select the pending batches to update.

Running the Flow Flattener

Access the Run Flow Flattener page.

Unit, Scenario ID, Fiscal Year, and Period	Specify the common consolidation business unit, scenario ID, fiscal year, and accounting period to process.
Jobstream ID	Accept the default value, GC_FLOWFLT, to use the delivered jobstream ID.
Rerun Option	Select this check box if you are rerunning this job. If you get the same record suites, the system does not re-resolve the tables prior to running the job. Re-resolving means that data is reselected from the permanent table and moved to temporary tables of the assigned record suite. By selecting this option, you can enhance performance.

Viewing Data Flows

This section provides an overview of the flow inquiry component and discusses how to:

• Specify flow inquiry parameters.

• View flow inquiry results.

• View the flow inquiry details.

• View the flow inquiry difference details.

• View the flow inquiry audit.

Understanding the Flow Inquiry Component

After updating flow amounts, you can review the flow templates (both manual input and system activity) in the consolidation currency for the source and journal flows. The flow template inquiry enables you to look at the template from a single ledger business unit or by multiple ledger business units using a business unit filter tree.

Pages Used to View Data Flows

Specifying Flow Inquiry Parameters

Access the Flow Inquiry selection page

Preference	Displays the selected preference. If you want to use previously saved selection criteria, select Get Preference and select the preference. If you want to save the selection criteria that you enter on this page, select Save Preference. See Analyzing Consolidations/Saving and Loading Inquiry Preferences
Business Unit, Scenario ID, Fiscal Year, From Period , and To Period	Specify the common consolidation business unit, scenario ID, fiscal year, and range of accounting periods on which to inquire.
Template	Select the flow template ID. Your choices are dependent on the flow templates you create for the flow group associated with the business unit, scenario, fiscal year, and accounting period.
Translation Type	Select the translation type. You have two options to select from to view the currency translated flows: Cash Flow Rate or Closing Rate. If you select Closing Tate as the translation type, the 99980 FXAJ1 column appears on this page as the translation flow code. It represents the flow translation adjustment to adjust the opening balance, translated at prior rates to the closing balance at the closing translation rate. This amount derives from the GC_SOURCE 08, for currency translations adjustments. If you select Cash Flow Rate as the translation type, both the 99980 FXAJ1 and 99985 FXAJ2 columns appear on this page as the translation flow code. It represents the flow translation adjustment to adjust the flow amounts translated at the average rate to the closing rate. See Understanding Data Flows.
Book Code Group	Select the book code group by which you want to further filter the inquiry report data. This is an optional field and is only available if you turn on book code functionality on the General Options page and you create book code values with the Book Codes and Book Code Group pages.

Filter Tree

Select the business unit tree used to roll up and navigate through the flow data. The flow inquiry allows you to look at the template from a single ledger business unit or by multiple ledger business units by using the filter tree.

See Using Reporting Trees with Inquiries.

Saving and Loading Preferences

You can save a set of defined values to a named preference, which you can use to generate the flow amounts. Click the Save Preference button after defining the field values, and enter a preference ID and description. To load a previously saved preference, click the Get Preference button, and select the preference. If a preference is currently active, its name appears in the Preference field.

Viewing Results

Click Go to view the Flow Inquiry - Results page.

Viewing Flow Inquiry Results

Access the Flow Inquiry results page.

The flow amounts appear in the grid.

Select a tree node to view the data associated with that node. When you reach an end node, you view details for the filter tree objects within that node.

Drilling on Flow Amounts

When viewing the Flow Inquiry page, click an amount to view more details on the Flow Inquiry for Selected Amount page. The flow amounts and difference amounts that are highlighted as links enable you to can click the linked amount in the grid and get more detailed information about the flow amounts for the related accounts.

Note. System flows such as the Open, Close, and Change columns do not have active links for viewing details.

Links on the Flow Inquiry Page

You can select these links on the Flow Inquiry page:

Viewing the Flow Inquiry Details

Access the Flow Inquiry for Selected Amount page.

The Flow Inquiry for Selected Amount page provides details about the flow amounts, the account, and flow code by ledger business unit. The flow amounts are segregated by source flow amount and journal flow amount. This distinguishes where the flow amount originated. Selecting any amount in the Source Flow Amount column or Journal Flow Amount column directs you to the flow audit page.

Viewing Flow Inquiry Difference Details

Access the Flow Inquiry for Selected Amount - Difference Details page.

On the Flow Inquiry page, drill on the Difference to be Reconciled amount to access the Flow Inquiry for Selected Amount - Difference Details page. Because flow amounts originate from two different sources, the difference amounts are divided into the Source Difference and the Journal Difference columns.

If there are amounts in either column, you can drill down to the relevant input page and correct the difference:

• If there is an amount in the Source Difference column, you can select the Source Flow Input link to drill down to the Source Flow Input page.

• If there is an amount in the Journal Difference column, you can select the Journal Flow Input link to drill down to the Journal Flow Input page.

Note. After correcting the flow amount in the respective flow input page, use the Validate button on the flow input page to validate the flow template. After the flow amounts are corrected, rerun the update engine to eliminate the difference to be reconciled amount.

Viewing the Flow Inquiry Audit

Access the Flow Audit page.

Because the flow inquiry amounts are in the consolidation currency and the source input templates are in the source currency, the Flow Audit page enables you to view the base flow amount and the source flow amount in their respective currencies. You can access the Currency Rule setup page by clicking on the currency rule link. You can also drill to the flow input pages when drilling on a flow amount that originated from source flows or journal flows.

You can use the navigation path to navigate back to the Flow Inquiry and Flow Inquiry for Selected Amount pages.

Note. If there are multiple currencies on the input template, then there are multiple rows of data detailing the multiple base amounts with the multiple source amounts and source currency. When drilling on a system flow, the source and journal flow input link will not display as the flow is system generated.