Skip to Content
0

Cost Center wise Profit and Loss Report in SAP Business One

Oct 24, 2017 at 05:00 AM

201

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Jitin Chawla
Oct 24, 2017 at 10:12 AM
0

Hi,

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

Regards,

Jitin

Show 1 Share
10 |10000 characters needed characters left characters exceeded
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

0
P Vinod Kumar Oct 24, 2017 at 06:15 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Mohd Danish Nov 28, 2017 at 07:21 AM
0

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"

Share
10 |10000 characters needed characters left characters exceeded
Jitin Chawla
Nov 29, 2017 at 07:57 AM
0

Hi,

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

Regards,

Jitin

Share
10 |10000 characters needed characters left characters exceeded