Report 2020: Deposit By Due Date

See previous W5 version guide

PURPOSE

To provide the details used by CS Lucas to show total amount of deposit by client sorted out by Due Date.

WHY IS THIS IMPORTANT?

Allow users to verify the details of Money Market Trade.

QUERY

1. Navigate to Reporting > Standard > Report 2020: Deposit By Due Date.

blank

2. Fill in the mandatory parameter – Acct Cntr and As At Date. Portfolio Group is an optional parameter.

3. Click Action and select the required format.

4. The report shows the Due Date, Client, Accounting Centre, Bank, Currency, Principal (Amount), Rates, Value Date, Days and Interest Earned.

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 > Money Market.

2. Select Acct Cntr: TFS-SG.

3. Select Transaction: Lend/Place.

4. Key in the MDate From* and MDate To. In this example: MDate From: 08/07/2017, MDate To: 08/07/2017.

5. Click Refresh.

6. Click on the Edit button of the trade to drill down to the Amend Money Market screen.

blank

7. I = Number of days between Value Date (H) and Due Date (A). Due Date (A) – Value Date (H).

FREQUENTLY ASKED QUESTIONS

 

RELATED INFORMATION

 

CHANGE HISTORY

blank

Categories:

0 Comments

Leave a Reply

blank

Your email address will not be published.



    Close Bitnami banner
    Bitnami