8.7.98 Result Master to Instrument Reconciliation in Consolidated Currency

Table 8-92 Result Master to Instrument Reconciliation in Consolidated Currency

Report Name	Result Master to Instrument Reconciliation Base Report Result Master to Instrument Reconciliation Cons Report
Description	This report displays Result master and instrument data.
Dashboards Prompts	Prompt - AsofDate As of Date Prompt GL Recon Process Scenario Prompt - Result Master to Instrument Balance Balance Prompt - Currency Currency
Report Criteria	"Product"."Product Name Level20","Product"."Account Type","Product"."Product Leaf Name",(ifnull(case when '@{IRBal}{Par}'='Par' then "Master Results"."Cur Par Bal" else "Master Results"."Cur Defer Bal C" end,0)) - (ifnull(case when '@{IRBal}{Par}'='Par' then "Account Summary"."Eop Bal" else "Account Summary"."Deferrecur Bal" end,0)),(((ifnull(case when '@{IRBal}{Par}'='Par' then "Master Results"."Cur Par Bal" else "Master Results"."Cur Defer Bal C" end,0)) - (ifnull(case when '@{IRBal}{Par}'='Par' then "Account Summary"."Eop Bal" else "Account Summary"."Deferrecur Bal" end,0)))*100)/ifnull(case when '@{IRBal}{Par}'='Par' then "Account Summary"."Eop Bal" else "Account Summary"."Deferrecur Bal" end,0),ifnull(case when '@{IRBal}{Par}'='Par' then "Master Results"."Cur Par Bal" else "Master Results"."Cur Defer Bal C" end,0),ifnull(case when '@{IRBal}{Par}'='Par' then "Account Summary"."Eop Bal" else "Account Summary"."Deferrecur Bal" end,0),"Currency"."Base Currency","Currency"."Currency Name"
Conditions	"Product"."Account Type" IN (100, 300)
Compound Layout	Title Pivot Table