What is profitability? How do you map 'segment wise
profitability' in Oracle?

Answer Posted / soumendu

The Accounting standards in various countries expects the
organization earning revenue from multiple product segments
to show the segment wise profitability information as a
part of the Financial Reporting.

Here is how you can set up the same in R11i.

1. Set up an item category as 'Product Segment'.
2. In the GL Set of books, create a chart of account
segment as 'Product Segment'. Give validation as table, and
link it to the product segment field in the item category
table.
3. Set up the cost of goods sold account in such a way that
for each item, the corresponding 'Product Segment' value is
debited during a shipment.
4. In the item attributes for invoicing, change
the 'Product Segment' value in the 'Revenue Account' field
to the corresponding value for each item.
5. In AR, set up the auto accounting to pick the 'Product
Segment' Value from the 'Standard Lines' for Revenue
Account.
6. Create an FSG report to capture Total Revenue, Total
Cost and the Profitability for each Product Segment.


In R12 there is a feature called 'Supporting Reference'
which can provide you with the same information. This means
that you need not create a chart of account segment
called 'Product Segment' in your ledger. However you will
need to create a custom report to provide you with the
profitability since segment wise revenue information is
available in AR and segment wise cost information is
available in 'Cost Management' for Discrete inventory
and 'OPM Financials' for OPM

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

please explain with examples the below mentioned "Creating the end to end business scenarios and executing the scenarios to perform the regression testing".

1741


what r issues faced in gl

2275


What is meaning of deprecation?

618


can any one tell me what exactly functional consultant do on daily basis? client requirements?

527


What kind of budgets have you worked on?

1880






Provide an overview of AR cash receipt processing.

2164


What is the meaning holding tax?

666


Explain Customer Creation and Maintenance Process. Provide samples of customer master records with Payment Terms.

2562


On what different real time issues you worked while doing P2P cycle implementation?

1006


What is the Use of Grouping Rule in Receivables ? is it mandatory field ?

1056


Do you track and record relationships between customers e.g. franchises, subsidiaries etc.?

1593


What is the use of mo: security profile, while configure multiorg?

615


Substitute receipts and Unordered Receipts

2884


I have created an invoice and made the payment in Accounts payable. Now the payment status is Negotiable and accounting status is processed. I reconciled the transaction in Cash Mgmt, The status changed from negotiable to Reconciled in CM. I checked the payment status for the invoice in payment window(AP), the payment status changed to RECONCILED UNACCOUNTED i.e correct but the accounting status is remain processed which is not the correct. I hope the transaction will be correct if the accounting status would have changed to PERTIAL . Please suggest any solution for the above query.

4535


When we run a GL Reconciliation Report, we also see the void payments in that report. Even though i disable the option of Show Void payments, its appearing in the report.How do i proceed so that i dont see those void payments in the GL Reconciliation Report?

2460