By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,617 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

how to design crystal report of trial balance

P: 1
my requirement is 1. Takes the sum of credit and debit values of each account from journal item table.
2. Find the account balance from the formula balance = sum of debit sum of credit.
3. If the balance is positive, then it must be debit.
4. If the balance is negative, then it must be credit.
i want to get the out put as
i have 3 tables accounts,journal_accountitem,journal table
Attached Files
File Type: xls TrialBalance-2009-09-01_2010-08-31.xls (895.8 KB, 1148 views)
May 30 '15 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.