Report 4010: FX Profit and Loss By Counterparty

See previous W5 version guide

PURPOSE

To provide the details used by CS Lucas to show the FX Profit and Loss By Counterparty.

WHY IS THIS IMPORTANT?

Allow users to verify the details of Foreign Exchange.

QUERY

1. Navigate to Reporting > Standard > Report 4010: FX Profit and Loss By Counterparty.

blank

2. Fill in mandatory parameters – Acct Cntr, Report Ccy, VDate From, VDate To and Rate Type. The rest are optional parameters.

3. Click Action and select the required format.

4. The report shows the Accounting Centre, Counterparty ID, Trade ID, Portfolio, TDate, VDate, Contract, Rate, Profit/Loss Currency, Profit/Loss, Rate, Val, P/L-Val Ccy and Narrative.

blank

For explanation of Excel Raw export, please see link.
For explanation of blank buttons, please see link.

DATA SOURCE

To view the following transaction,

blank

Follow the steps as shown below:

1. Navigate to Transaction > Foreign Exchange.

2. Key in the Vdate Fr* In this example: 30/06/2017 (Same input for report).

3. Select Ctpy ID. In this example: CITI-SG.

4. Click Refresh.

5. Click the Edit button next to the Trade ID: FRX100004.00.

blankblank

Rate: Navigate to Tools > FX Forward Excrate -> J

P/L: Navigate to Tools > FX Profit/Loss -> L/O

Rate %: Navigate to Prices > Exchange Rate (Valuation/Accounting/Alternate) – > M

FREQUENTLY ASKED QUESTIONS

 

RELATED INFORMATION

 

CHANGE HISTORY

blank

Categories:

0 Comments

Leave a Reply

blank

Your email address will not be published. Required fields are marked *



    Close Bitnami banner
    Bitnami