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