General Ledger Report - Cash Basis

Summary:

Hi Team,

I would like to extract or build a custom report for General Ledger in oracle fusion with the below columns data.

Required columns are:

1. GL Date
2. Transaction type (deposit, expense, journal entry, payment, check, etc…)
3. Journal ID, Check #
4. Name of Payee
5. Description of JE/deposit/expense/etc…
6. Debit amount
7. Credit amount
8. Running account Balance YTD

• 9. Account name and cost center

10. Beginning balance of the account

Please suggest any seeded report to use or provide the query details to build the custom report.

Thanks in advance.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):