What is profitability? How do you map 'segment wise
profitability' in Oracle?
Answer / 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 |
What is Deposit? A customer deposit Rs.15,000/ and he ordered the goods of Rs.10,000/ against the deposit. Now he wants the remaining cash back. how do you do in receivables?
i have studied oracle 11i finance courser at Oracle Universiyt at chennai. Now, i want some experience in same filed. If any have this chance, please inform to me
where does COGS account hit?
What is ment by prorate convention?
what is the profile options
What is the Entry in Oracle Apps AP,AR,GL for following Transations 1.One Pipe purchase at Rs.100 2.One Pipe Sales At Rs.150 Which account Afected ,What is the journal entry What is the entry at respective module how many modules are afected through above transation
what is the importance of below three profile options? 1.HR Business group 2.HR User type 3.HR Security
What is Profile ?
Re: what are the Issue that we face in Gl,PO and AP while Supporting
How can we Integrate AP,AR,CM & FA to GL? What is the procedure need to fallow as a functional consultant?
where will you enter tax in ap module
one employee went on site , we given to him 1000 through prepayment . but i final spends amount is 800, then what about remaining 200 , how can we refund to organisation. through debit memo or credit memo, or , prepayment or if any, please give me best solution , if any one know this question answer reply me this mail, nmallioracle@gmail.com