1. User Guide
  2. Overview of ALM BI Dashboards and Reports
  3. ALM Report Details
  4. Transfer Pricing Income Statement in Consolidated Currency

8.7.24 Transfer Pricing Income Statement in Consolidated Currency

Table 8-13 Transfer Pricing Income Statement in Consolidated Currency

Report Name(s) Transfer Pricing Income Statement in Base Currency
Description Report display TP Income Statement across time buckets with Product level detail.
Dashboards Prompts

Prompt - TP Process Scenario

  • Process
  • Scenario

Prompt - TP Date Currency Result Bucket

  • As of Date
  • Currency
  • Result Type

Prompt - TP Bucket End date

  • Bucket End Date
Report Criteria 'Assets', ifnull("Standard Cash Flow Results"."Interest Cash Flow (430) Asset",0.00), ifnull("Standard Cash Flow Results"."Interest Cash Flow Transfer Rate (437) Asset",0.00), ifnull("Standard Cash Flow Results"."Interest Cash Flow (430) Asset",0.00)-ifnull("Standard Cash Flow Results"."Interest Cash Flow Transfer Rate (437) Asset",0.00), ifnull("Standard Cash Flow Results"."Interest Cash Flow (430) Liabilities",0.00), ifnull("Standard Cash Flow Results"."Interest Cash Flow Transfer Rate (437) Liabilities",0.00), ifnull("Standard Cash Flow Results"."Interest Cash Flow Transfer Rate (437) Liabilities",0.00) - ifnull("Standard Cash Flow Results"."Interest Cash Flow (430) Liabilities",0.00), ifnull("Standard Cash Flow Results"."Interest Cash Flow Transfer Rate (437) Asset Liabilities",0.00), 'Liabilities', 1, "Time Buckets"."Start Date", "Time Buckets"."End Date", "Currency"."Base Currency", ifnull("Standard Cash Flow Results"."Interest Cash Flow Transfer Rate (437) Asset",0.00), ifnull("Standard Cash Flow Results"."Interest Cash Flow Transfer Rate (437) Liabilities",0.00)
Compound Layout

Title

Pivot Table

Table