Skip to Content
avatar image
Former Member

Cost Center wise Profit and Loss Report in SAP Business One

Oct 24, 2017 at 05:00 AM | 292 Views

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

SAP Business One, version for SAP HANA
SAP Business One | gordon du
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Jitin Chawla
    Oct 24, 2017 at 10:12 AM

    Hi,

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

    Regards,

    Jitin

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Oct 24, 2017 at 10:40 PM

      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

  • avatar image
    P Vinod Kumar
    Oct 24, 2017 at 06:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Mohd Danish
    Nov 28, 2017 at 07:21 AM

    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"

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Jitin Chawla
    Nov 29, 2017 at 07:57 AM

    Hi,

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

    Regards,

    Jitin

    Add comment
    10|10000 characters needed characters exceeded