Balance sheet period ending balances table

[Former Member]

We have written our own Balance Sheet report in Crystal.  Unfortunately we calculate balances by going back to the beginning of time and summing all transactions through the desired period.

Is there a table that stores the period ending or year ending balances?

We like our report, it is just slow to create.

Many thanks,

Rob

[former_member186095]

Hi Rob,

period ending or year ending balances are not stored in any tables in SAP B1 database.

You must use store procedure query to calculate it.

If you need a report that display it, you must use crystal report with store procedure or reporting service.

Rgds

JM

[Former Member]

Hi Rob,

I am afraid there is no such table in B1 database. All EOP are running on the fly by runtime procedure.

Thanks,

Gordon

[kothandaraman_nagarajan]

Hi,

Not sure CCPD table will help.

Thanks & Regards,

Nagarajan