cancel
Showing results for 
Search instead for 
Did you mean: 

How To Query for Balance Sheet Report

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

dear rahul,

how can i calculate Beginning of Year Amount and Current Period Amount?

best regards,

zzymt

jitin_chawla
Advisor
Advisor
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

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