Profit & Loss Statement Using Cost Centers

[former_member476276]

We had built Profit & Loss statements in XL Reporter that have worked for us for the last few years.  We have recently began using cost centers and have modified the P&L statements to reflect these cost centers.  We have ran into a couple issues:

1.  I want the ability to split by GL account direct allocation costs vs. indirect allocation costs.  I cannot find a way in excel reporter to do this.

2.  Under the budget scenario, I have added cost centers and added dollar amounts to the individual cost centers.  These amounts are not showing up in the P&L statement.

Is Crystal reports the better report designer to use in the case?  If so, is there a place for canned reports that I can download a P&L template and modify it to fit our needs?

Since crystal reports is table based, is there a table that would pull through the indirect allocations properly without much configuration?

Thanks,

Ryan

[KennedyT21]

Hi Ryan Krutzfeldt ...

try this quedry

Try this to start:

SELECT T0.[FormatCode], T0.[AcctName], SUM(T1.[Credit]-T1.[Debit]) Balance 

FROM OACT T0 INNER JOIN JDT1 T1 ON T0.AcctCode = T1.Account 

INNER JOIN OJDT T2 ON T1.TransId = T2.TransId WHERE T0.[ActType] in ('I','E') 

and DateDiff(YY,T2.[RefDate],GetDate()) = 0 

AND T1.[Debit] != T1.[Credit] GROUP BY T0.[FormatCode], 

T0.[AcctName] Having SUM(T1.[Debit]-T1.[Credit]) != 0 ORDER BY T0.[FormatCode] 

check with the link

http://www.passage.co.nz/blog/sap-business-one-cost-center-p-l-report

Regards

Kennedy