Previous	Next		Contents	Index	Navigation	Glossary	Library

This report prints the line number, account, transaction date, description, reference information, and the foreign, functional and statistical debit or credit amounts for each foreign currency journal line. Totals are provided for all of the debit and credit amounts for each journal and for the batch(es). In addition, a total is provided for your journal source(s), and a grand total is provided for all of the debit and credit amounts included in your report.

Parameters

Type: Choose Line Item to generate a report showing REFERENCE_1 from the GL_JE_LINES table. Choose Source Item to generate a report showing REFERENCE_4 from the GL_JE_LINES table. These references appear only if you used Journal Import and included a journal voucher number, an invoice date and number, or some other source document information that helps you to identify the origin of this journal.

Posting Status: Choose Posted to generate the Foreign Posted Journals Report showing all posted journals in your batch. Choose Unposted to generate the Foreign Unposted Journals Report showing all journals in your batch which have not been posted. Choose Error to generate the Foreign Error Journals Report showing all journals that errored out during the posting process, possibly due to a control total violation or posting to a closed period. Note that if your error is due to a code combination violation (for example, you tried to post to an account for which posting is not allowed), General Ledger prints the code combination error in place of the account.

Currency: Choose any foreign currency for which you entered journals. You cannot choose your functional currency or STAT.

Period: (optional) Choose an accounting period in your calendar for which you entered foreign currency journals. This field is optional only if you are not entering a Start/End Date.

Start/End Date: (optional) For unposted and error journals, enter the batch effective date range for which you want a report. For posted journals, enter the posting date range. This field is optional only if you are not entering a Period.

Source: (optional) Choose the journal source for your batch. Batches originating within General Ledger include manual journal batches which have a source of Manual, and formula journal batches which have a source of Recurring or MassAllocations. Journals you import have a source corresponding to your feeder system.

Batch Name: (optional) Choose any journal batch containing foreign currency journals.

Selected Headings

Batch Effective Date: For manual journals to prior periods, the last day of the period you specified in your batch. For manual journals to future periods, the first day of the period you specified in your batch. For manual journals to the current period or for journals created by feeder systems, the date on which the batch was created.

Balance: Actual, Budget, or Encumbrance to indicate the balance type of your batch. General Ledger prints your actual balances followed your budget balances, and then your encumbrance balances.

Reference: Journal Import reference information according to the report type you specify.

Units: statistical amount, if any, associated with your journal line.