Report 3002: Account Transaction History – By Account Code

PURPOSE

To provide the details used by CS Lucas to show the Account Transaction History – By Account Code.

WHY IS THIS IMPORTANT?

Allow users to verify the details of Account Transaction History – By Account Code.

QUERY

1. Navigate to Reporting > Standards > Report 3002: Account Transaction History – By Account Code.

blank

2. Fill in the mandatory parameter – Acct Cntr, PDate From, PDate To, Account No. range and portfolio.

3. Click on the required format.

4. The report shows the Post Date, Reference, Currency, Portfolio, Counterparty, Dr/Cr, Balance, XRate, Base Currency, Dr/Cr and Balance.

blank

For explanation of  blankbutton, 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 Back Office > Journals.

2. Select Acct Cntr* (From example: TFS-SG)

3. Key in the PDate Fr* and PDate To* (From example: 01/06/2017, 30/06/2017)

4. Click Refresh.

blank

5. XRate: Navigate to Prices > Exchange Rate.

Look for the selected currency and post date. If no accounting rate on the post date, system will take last available rate.

blank

6. Base: Accounting base currency of the selected accounting centre.

Navigate to Set Up > Static > Accounting Centre.

blank

7. H = D * F

8. I = E * F

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