Query Generator

[Former Member]

Hi Expert,

Can you please help me generate query code to generate Balance Sheet per profit center?

Thanks...

ArlmiPJ

[jbrotto]

Xl reporter has a good balance sheet template

[jitin_chawla]

Hi,

Creating a complete Balance Sheet based on customized query would be very difficult.

Instead you can go for your own Balance Sheet template and get the desired result more easily as Profir centres.

All the best.

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member]

Hi,

Thanks for your reply.. I did your suggestions on Financial Report Template however I cannot find the profit center.

Regards,

ArlmiPJ

[Former Member]

Hi........

If you go by Financial report template and create Balance Sheet Template as per Profit Centres then it would be possible to run through Standard report. Yes it is lengthy but simple process.

But if you want to go with Query Generator then you have to use OJDT and JDT1 Table where you need to join with all those tables where Profit Center is being captured........

Regards,

Rahul