PCA - Balance Sheet Item in PCA standard reports

[chengshiong_kwan]

Dear all experts,

I am confused by the section in the PCA standard reports: Balance Sheet Item.

What is this and what is the logic behind?

When I select Period 1-12, both values in Balance Sheet Item and Profit Center sections are tally.

But when I select 1 single period, Profit Center section is showing total values for that single period but I could not explain the values under Balance Sheet Item section.

Thanks.

Rgds,

Sebastian

[Former Member · Accepted solution]

Hi..

You see below example for Balance Sheet Item.

Profit center report display Cumulative Balance for Balance Sheet Item.

Period	Debt	Credit	Balance	Cumulative   Balance
Jan	10	5	5	5
Feb	5	8	-3	2
Mar	10	8	2	4
Apr	30	15	15	19
May	20	30	-10	9
Jun	100	80	20	29
Jul	50	70	-20	9
Aug	40	20	20	29
Sep	60	30	30	59
Oct	10	20	-10	49
Nov	30	50	-20	29
Dec	30	15	15	44

[chengshiong_kwan · Accepted solution]

Hi Big Choi,

Thanks for your example and explanation.

I have tried to execute S_ALR_87013340 report.

I found that the P&L accounts seems to be appearing in the Balance Sheet Item section as well.

Is there any setting to exclude those P&L accounts in the BS Item section?

I do not want to change the standard report via GRR2.

Thank you.

Regards,

Sebastian

[Former Member · Accepted solution]

Hi..

I understood that you want to display only Balance Sheet Item using S_ALR_87013340 report.

If yes, Refer to below my answer.

You should input only Balance Sheet  account in profit and Loss Accounts Group or value field as below picture.

Balance Sheet Account Group or value field is only used for report title and is not relevant to data selection’s condition.