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.
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: