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
Define the activities of the Configuration Manager (AP,GL,FA) in the team. Give examples
What kind of necessary ap information you gather from the client?
Please post the setups required to approve the payable invoice in AP.
What is gap analysis, what are the pre-requisities?
What do you mean by controlling buyers workload?
What is the Process of Reconciliation Between AP to GL
1)What cannot be consolidated in GCS? 2) When you setup calendar in GL is it possible to change it?
how to do customization while doing oracle implementation. what is the role of functional consultant in customization?
explain with examples what r the roles & Responsiblities of a functional consultant who reviews the Test Scripts, Test Cases and Test Execution Results of AP, FA and GL.
can any one tell me what exactly functional consultant do on daily basis? client requirements?
Write Test Scripts for a telecummunication project on the basis of priority with some examples with regard to AP,GL,FA.
explain your project plan with exam pal? i am preparing inter view .............
what is the use of hr: security profile, while configure multiorg?
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?
What is the use of hr: user type, while configure multiorg?