PURPOSE
To provide the details used by CS Lucas to show the Cash Balance by Counterparty.
WHY IS THIS IMPORTANT?
Allow users to verify the details of Cash Balance by Counterparty.
QUERY
1. Navigate to Reporting > Standards > Report 1416: Cash Balance by Counterparty.
2. Fill in the mandatory parameter – Acct Cntr, Cash As At, From Date, To Date, Rpt Ccy and Include MM?
3. Click Action and select the required format.
4. The report shows the Counterparty, Accounting Centre, Reference, Currency, From Date, Net Movement, To Date, Rate and Rpt Amount.
For explanation of Excel Raw export, 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 Cash Management > Cash Activities.
2. Select Acct Cntr* (From example: TFS-SG)
3. Key in the From* (From exmaple: 03/07/2017)
4. Select Total In* (From example: AUD)
5. Select SSI* (From example: TF-CI-AUD)
6. Click Refresh.
Net Movement: To Date Amount – From Date Amount -> F.
Rate: Navigate to Prices > Exchange Rate (Valuation Rate on reporting to date, e.g., 31-Jul-2017) -> H.
Rpt Amount: To Date Amount * Rate -> I.
FREQUENTLY ASKED QUESTIONS
RELATED INFORMATION
CHANGE HISTORY
0 Comments