Report 4004: Forex MTM By Weekly Group (W5)

This version is superseded. Click here to view the latest guide.

PURPOSE

To provide the details used by CS Lucas to show the Foreign Exchange Marked to Market by Weekly Group.

WHY IS THIS IMPORTANT?

Allow users to verify the details of Foreign Exchange.

QUERY

1. Navigate to Reporting > Standard > Report 4004: Forex MTM By Weekly Group.

2. Fill in mandatory parameters – Acct Cntr, Val Ccy, As At and Rate Type. The rest are optional parameters.

3. Click on the required format.

4. The report shows the Accounting Centre, Trade ID, Portfolio, Counterparty ID, TDate, VDate, SGD amount, AUD amount, Book Rates, Forward Rate, P/L, Rate, Val Currency and P/L-Val Ccy.

For explanation of  button, please see link.
For explanation of   buttons, please see link.

DATA SOURCE

To view the following transaction,

Follow the steps as shown below:

1. Navigate to Transaction > Foreign Exchange.

2. Key in the Vdate Fr: 24/07/2017 (Same input for report).

3. Click Refresh.

4. Select Trade ID FRX100010.00

Fwd Rate: Navigate to Tools > Forward Excrate
Rate %: Navigate to Tools > FX Profit/Loss 
P/L: Navigate to Tools > FX Profit/Loss 

FREQUENTLY ASKED QUESTIONS

 

RELATED INFORMATION

 

CHANGE HISTORY