cancel
Showing results for 
Search instead for 
Did you mean: 

Recreating Balance Sheet with Crystal Reports

Former Member
0 Kudos

Hello everyone.

I need to recreate the Balance Sheet report with Crystal Reports.

Which tables have the information I need?

Thanks in advance!

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

All the records are in the JDT1 table, and I used the OACT table to get the GroupMask of each account, and filter the report to display records when that field is either 1 (Assests) or 2 (Liabilities).

When the GroupMask is 4,5,6,7, or 8, the records belong to the Profit and Loss Statement.

Thank you very much!!!

former_member206488
Active Contributor
0 Kudos

Hi,

i need help in creating balance sheet and profit loss in crystal report format.

can you tell me the query to craete the reports,

Regards,

Former Member
0 Kudos

You may check this thread:

All financial reports source data are extracted from those tables mentioned in that thread.

Thanks,

Gordon