PURPOSE
To provide the details used by CS Lucas to show the Cash Balance by Accounting Centre.
WHY IS THIS IMPORTANT?
Allow users to verify the details of Cash Balance by Accounting Centre.
QUERY
1. Navigate to Reporting > Standards > Report 1415: Cash Balance by Accounting Centre.
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 Accounting Centre, Counterparty, 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 example: 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