Cost Center wise Profit and Loss Report in SAP Business One

[Former Member]

Hello All,

I want to run Cost Center wise report in SBO:

CC1
P&L
CC2
P&L
CC3
P&L

Please let me know how this can be done.

Syed Hussain

[jitin_chawla]

Hi,

Check with other reports like Cost Center Report, Distribution Rules Report & Cost Accounting Summary Report.

Regards,

Jitin

[MD1]

please try

SELECT distinct T1."Account", T2."AcctName", Sum(T1."Debit") AS "Debit",
Sum(T1."Credit") As "Credit", Sum (T1."Debit" - T1."Credit") As "Balance" ,T1."Project"
FROM OJDT T0
INNER JOIN JDT1 T1 ON T0."TransId" = T1."TransId"
INNER JOIN OACT T2 ON T1."Account" = T2."AcctCode"
WHERE T0."RefDate" >='[%0]' AND T0."RefDate" <='[%1]'
GROUP BY T1."Account",T2."AcctName",T1."Project"

[jitin_chawla]

Hi,

Please check SAP Note 843508 regarding clarification on usage in reports of Distri Rule.

Regards,

Jitin

[Former Member]

Hi Jitin,

What I am looking is to run profitability report for different cost centers one at a time. For example Profit & Loss for CC1 download and save. Profit & Loss for CC2 download and save and so on. We have to run this report 14-15 times to get profit & loss statement for the cost centers. Is there a way to save the report with parameters or to have a profit & loss summarized by Cost centers?

Syed Hussain

[pvinod_kumar]

Hi sayed

when u open P & L report window, u can find Expand Button, right side, open the window and will have option to select Cost Center

Regards