ERPNext Conference 2019* ERPNext.com Blog

Cost center report


#1

Hi all, is there a way to see a financial report for multiple cost centers? I can currently do a report for each cost center. But I would like to see a timebased (one year for example) the different cost centers by column.

My workaround is do each cost center and export them and find a way to merge them into one report in excel.

Thank you


#2

It is not available out of the box but you sure can try to create a query report for it.


#3

Hi @Nathan,

Check Profitability Analysis report, it may help you to resolve your issue.

Thanks


#4

can you lead me to more information about creating a query report?


#5

That’s great for summary. Thanks. I would like to get the full p&l though.


#6

Hello! Have you found a solution to this?


#7

https://erpnext.com/docs/user/manual/en/customize-erpnext/articles/making-custom-reports-in-erpnext

https://frappe.io/docs/user/en/guides/reports-and-printing/how-to-make-query-report.html


#8

Hello, thank you for the reply! Would I be able to produce the same type of profit and loss report by just using query reports?


#9

Yes, that is correct.