Producing Revaluation and Translation Reports

This section lists the pages used to run standard revaluation and translation reports. To run a report, select it from a menu and enter any necessary parameters. Once you enter the report parameters, use PeopleSoft Process Scheduler to run the report. PeopleSoft Process Scheduler manages the processes, tracks the status, and generates the report in the background while you can continue to work on something else.

For those who want to modify our standard reports, create your own reports, or reformat report output, PeopleSoft offers a variety of reporting tools.

Page Name

Definition Name

Usage and Navigation

Translation Step Definition Report Page

RUN_GLS5000

Specify the run parameters for the Translation Step Definition Report (GLS5000) SQR, which lists the details and rules of each currency translation step.

General Ledger > Process Multi-Currency > Reports > Translation Step > Translation Step Definition Report

Revaluation Step Definition Report Page

RUN_GLS5001

Specify the run parameters for the Revaluation Step Definition report (GLS5001), which lists detailed information for each currency revaluation step.

From the Reports menu option, select Revaluation Step > Revaluation Step Definition Report

Translation Calculation Log Report Page

RUN_GLS5002

Specify the run parameters for the Translation Calculation Log Report, which lists translation calculation details by process instance and translation step.

Note: the BI Publisher report GLX5002 displays as an addition option on the Process List page. The BI Publisher should only be selected for AE MultiCurrency process instances. If you are using the COBOL MultiCurrency process, then you should select the SQR report GLS5002.

Revaluation Calculation Log Report Page

RUN_GLS5003

Specify the run parameters for the Revaluation Calculation Log Report, which lists revaluation information by process instance and revaluation step.

Note: The BI Publisher report GLX5003 displays as an addition option on the Process List page. The BI Publisher should only be selected for AE MultiCurrency process instances. If you are using the COBOL MultiCurrency process, then you should select the SQR report GLS5003.

Translation in Ledger Calculation Log Report Page

RUN_GLS5004

Specify the run parameters for the Translation in Ledger Calculation Log Report, which displays the details and rules of each translation step within the ledger calculation log. For each step, the report shows the description, ledger information, output and journal options, and gain and loss ChartKeys.

Note: The BI Publisher report GLX5004 displays as an addition option on the Process List page. The BI Publisher should only be selected for AE MultiCurrency process instances. If you are using the COBOL MultiCurrency process, then you should select the SQR report GLS5004.

Translate in Ledger Report Page

RUN_GLS5005

Define your parameters for the Translate Within Ledger Step Report (GLS5005) SQR, which lists translation within ledger calculation details by process instance and revaluation step.

From the Reports menu option, select Translation in Ledger Rprt

Translate Ledger Reconciliation Report Page

RUN_GLS1005

Specify the run parameters for the Translate Ledger Reconciliation report (GLS1005) SQR, which reconciles the amounts in the currency translation ledger to the amounts in the primary ledger within a multibook ledger group.

You can include adjustment periods and select account type within the comparison. Click the Refresh button to select ChartFields for comparison.

From the Reports menu option, select Translation Ledger Reconcile > Translate Ledger Reconciliation Report

Translation Ledger In-Sync Report Page

RUN_GLS1006

Specify the run parameters for the Translation Ledger In-Sync Report (GLS1006), which lists data violating the required ledger structure in the currency translation ledger within a multibook ledger.

This report shows these structural flaws:

  • Translate ledger contains non-primary base entries.

  • Translate ledger contains POSTED_TRAN_AMT not equal to POST_BASE_AMT on matching entries in primary ledger.

  • Non-zero translate ledger entries do not have matching entries in primary ledger.

  • Primary ledger entries with no matching entries in Translate ledger.

  • POSTED_BASE_AMT of translate ledger entries in primary ledger base currency do not add up to POSTED_TOTAL_AMT of entries in translate ledger base currency.

From the Reports menu option, select Translation Ledger In-Sync > Translation Ledger In-Sync Report