Report 1415: Cash Balance by Accounting Centre

See previous W5 version guide

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.

blank

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.

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

blank

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

blank

Categories:

0 Comments

Leave a Reply

blank

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



    Close Bitnami banner
    Bitnami