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

Hi All., Can Any one tell me how define the receivable options in AR. what are steps should be followed for creating a receipting workbench.

1 Answers  

---

Briefly list the steps for foreign currency journals?

2 Answers  

---

Hi, I am a MBA(Finance) and done my graduation in B.Com (H).I have a teaching experience of 3 years in a Management college. I want to shift in IT as an Oracle apps (Functional) consultant. Could you please suggest me some certified courses in Oracle Appa(Functional)in Delhi/NCR region which provides placements as well. or can anyone suggest some other course in line with my educational qualification. My Email ID : anshulkumarmathur@rediffmail.com Regards, Anshul

1 Answers  

---

Why are expenses items typically accrued at period end, and why are inventory items always accrued on receipt?

2 Answers  

---

I have a existing Oracle applicttions and need to bring one of the new business on it. The new business will use GL, AP and FA. We will use existing COA. This business will have 3 sets of books (1- tax book, from April to March; 2- Primary book, from July to June; 3- Reporting book, from July to June); All books will have same currency; HOW DO I TRANSFER DATA FROM PRIMARY BOOK INTO TAX AND REPORTING BOOKS EVERY MONTH? IS THERE ANY STANDARD ORACLE PROCESS WHICH CAN BE SCHEDULED? THE REPORTING BOOK WILL HAVE DIFFERENT DEPRECIATION METHOD SO HOW DO I NOT TRANSFER DEPRECIATION FROM PRIMARY TO REPORTING BOOK AND DO SEPERATE DEPRECIATION IN REPORTING BOOK FOR THE SAME ASSET THAT IS ALSO IN PRIMARY AND TAX BOOK?. HOW DO I APPROACH ON SETTING THESE NEW SETS OF BOOKS? Thank you in advance for your help.

3 Answers   Oracle,

---

---

What is the use of this Table AR_RECEIVABLE_APPLICATIONS_ALL in AR Module ?

2 Answers   Satyam,

---

How tp determaine that multi org is already implemented ?

1 Answers   IBM,

---

What is Tax Structure in US, we set-up in E-business Tax of R- 12 or 11i?

3 Answers   Oracle,

---

What is Difference between Internal Sales order and Intercompany Sales order ? How they are Different in 11i and R12

1 Answers   IBM,

---

Can any one please tell me when and how the a/cing entries will be generated from various modules when the transactions are generated Please help me in this matter Thanks KNRao

1 Answers  

---

How you will transfer payables to general ledger?

7 Answers   HCL, IBM, TCS,

---

What is primary set of book?

2 Answers   L&T,

---