• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Trial Balance in Debit and Credit format - F0902 And F0911 Retreive Amounts Wrapper

Rauf

VIP Member
Trial Balance by Account in Debit and Credit format - B0900246

We have to print Trial Balance in Debit/ Credit format requested by government authority. I did not find any standard report to do this. So I have copied the standard trial balance and added the below function to retrieve the information. The function works fine but it takes too much time to print the T/B.
Our standard T/B will take 10 to 15 minutes to complete. With the below function, it runs up to 4 hours :-(

Function Description: F0902 And F0911 Retreive Amounts Wrapper
Source Module: B0900246

Is there any better way to print T/B in debit credit format ?
We need the below columns ( suppose we run for March 2018)
Account No
Account Name
Opening Balance ( balance as of February 2018 )
Debit Amount ( for the period of March 2018 )
Credit Amount ( for the period of March 2018 )
Closing Balance ( balance as of March 2018 )


I see the reports R09472 and R09473 having the same format but it is by Object Account. I'm also checking if I can customize these report to show the balance by Account.
 
Last edited:
Top