GL Trail Balance report
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'