on 12-01-2011 7:06 AM
dear experts,
I have no experience in accounting. I want to create Balance Sheet Crystal Report like B1. If u have any idea, pls let me know.
best regards,
zzymt
Hi.......
With reference to OJDT and JDT1 you can create report for Balance Sheet where you need to include only Accounts under Assets, Liability and Equity.......
Regards,
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
From the JDT1 table you need to sum the amounts of debit and credit fields to get the value based on the refdate field. Taking a total before a refdate will be the opening balance and during the reporting period with the current balance.
Check if you get the desired result.
Kind Regards,
Jitin
SAP Business One Forum Team
Hi,
If you don't have experience in accounting, you may need longer time in preparing it. Asking accounting department from time to time to make sure you are in the right path.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.