Financial Management - PSFT (MOSC)

MOSC Banner

GL Trail Balance report

edited Apr 30, 2020 5:04AM in Financial Management - PSFT (MOSC) 4 commentsAnswered

Good Afternoon

Hope all is well with you fine people.

I have a situation where my ledger query does not agree with the Trail balance report. I dump all my ledger data for the related account and analyzed it but the numbers do not match with that of Trail balance.

I am going crazy with this as I have no idea from where the Trail balance is getting its numbers in the report.

I considered all the accounting periods including/ excluding the '0','999' & '998', still the data is not matching.

query:

SELECT * FROM PS_LEDGER WHERE FISCAL_YEAR <= '2019' AND ACCOUNT = 'XXXXXX'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center