Hi
Can you please advice if there is any Oracle seeded report that shows accounts in Transactional currency
Because i think if i run Trial balance in each currency it shows the converted amounts .. am i correct?

If i run a USD trial balance , i don't want to see any transactions in CAD that are converted to USD.

Same with CAD- i want to see only CAN transactionsnot USD and CAD transactions together, shown in AUD

what i am lloking is how much of Accounts receivables in each currency .. how much AP in each currency
Thanks

You can run Trial Balance report in General Ledger module for entered currency if you wish, as oppose to total currency.

Simply choose "Entered" in Currency Type field, and "USD" or "AUD" in Entered Currency field.

For example.

Lets say you have entered following journals in GL:

Journal 1
DR: EXPENSE1 $100 (CAD)
CR: CASH $100 (CAD)

Journal 2
DR: EXPENSE1 $100 (USD, rate 1.2)
CR: CASH $100 (USD, rate 1.2)

The trial balance in Total Currency will display following results:

EXPENSE1 | $220 | 0
CASH | 0 | $220

The trial balance in CAD Entered Currency will display following results:

EXPENSE1 | $100 | 0
CASH | 0 | $100

The trial balance in USD Entered Currency will display following results:

EXPENSE1 | $100 | 0
CASH | 0 | $100

Thanks so much for the Help..

Is there a way to get the account activity by entered currency?

Please advice if there is any report

Thanks in advance

Account Analysis report could be run with Entered Currency parameter set to a desired value. (e.g. USD)