Home › General Ledger › Reports

Currency Exchange Gain And Loss Report

Wed, 2014-06-25 08:18 — santanumondal

Overview

The report shows list of all Current Assets and Current Liabilities G/L accounts that are having foreign currency (in the Currency attribute in the General Ledger entity) along with their currency and closing balance for the current period.
The report calculate the gain or loss for each G/L account by applying the current market Exchange Rate for each currency on the Domestic book balance of the account and compare it with the Domestic calculated balance. The gains and loss amount listed in the report.
The market exchange rate will be latest rate value of each currency.

Navigation

General Ledger ► Reports ► Currency Exchange Gain and Loss Report

Currency Exchange Gain And Loss Report

Fields

Description

Fiscal Year

User types Fiscal Year. This parameter is mandatory and shows the current fiscal year by default.

Fiscal Period

Current Fiscal Period to be selected for generating the report.

Sub Ledger Type

Sub Ledger type Bank Account, Vendor, Customer can be selected as the filter criteria for the report.

Currency

Currency for the report.

Multi-Fund Concept

User can select more than one fund as filter. If no elements are selected, system will take them all.
This should appear only when multi fund parameter is true, when such parameter is false, then this group does not apply.
System will insert a page break between funds.

Group by Fund

If checked indicates that the report will be grouped by Fund.

Group By Object Code

Indicates the output result is grouped by Object Code segment.

Include Sub Ledger Code

Users can select it to include the Sub Ledger code to display.

Comment

Comments for this report. Optional Parameter.

Hierarchy Rollups UACS Elements

Indicates that there will be a hierarchical element restriction and Coding block restriction used to filter.