SAP R/3 : Profit & Loss Report - Part 1

In about three weeks from now, i have been holed up in a cubicle with two FICO functional consultants doing PS (Project System) enhancement. A massive report combining six reports (Revenue, Cost of Sales, Vendor, Vendor & Invoices, Profit & Loss, and Profit & Loss by Work Package) were plan, scope, design and implemented. The implementation was put into my hands. I developed six reports in that following three weeks. This report was crucial as it is an important requirement by company to be able to view its PNL report.

Although SAP via PS module provides the standard report to view its own PNL report but they were unable to do so due to customization of their WBS element in PS. As a result, a customized PNL is required and i had to crash my mind to come out with it.

Revenue report

A revenue report that show all of its customer by means of first and second level of project definition. It is henceforth segmented into billed and unbilled category. Billed will have the known revenue items and changed order. Unbilled is the known revenue items as well as the changed order. This will be regarded as the revenue report.

Cost of Sales report

The cost of sales report is further categorized into 3 types of report, namely, the summary of cost of sales, vendor and vendor & invoice reports. Each has its own functionality.

- Summary Cost of Sales

Based on Cost Code Group, GL account number and the unknowns (items that are bought but not specific to which project) are group into the cost of sales. Not to mention, this include known invoices which are already identified to projects.

- Vendor and Vendor & Invoice

It will display all related vendors and its invoice the summary cost of sales.

Profit & Loss/Profit & Loss By WP

Combining the Revenue report and Summary Cost of Sales report, this will become the PNL.

is sky the limit.... PNL