COA Parent and Child Mapping

[EMANUEL]

HI,

How to get the detail mapping of COA in GL, I.e I need to know which are the parents codes and the child values mapped to each parent accounts in R 12 ?


Rgds
Emanuel

[admin]

You want to export data or want to see online? tks

[EMANUEL]

Hi

I need to export the full list of Data with Parent along with its child values in R 12


Rgds
Emanuel

[karthikeyanp1981]

Dear Emanuel,
You can perform the below steps to export the Values of an Value Set used in the Chart of Accounts Structure.
Navigate to Setup > Financials > Flexfields > Key > values
Query for your Application, Flexfield and Segment and click Find
Click on the Values, Hierarchy, Qualifiers TAB
Place your cursor on the first record below.
Click on the File Menu and Click Export Function.
System will promt for three options...Choose CONTINUE TO END.
Once the progess is 100%, system will open an excel sheet with the values indicating whether it is a parent or not ...
However the above steps does not export the hierarchy relationship between parents and child values ...
I did not find any standard reports as well..

Regards,
Karthikeyan

[EMANUEL]

Dear Karthikeyan

I am aware of this, but the data exported does not show any relationship between the Parent,Subparent and child values


Rgds
Emanuel

[vvrsankar]

There is one standard report %chart%Listing% OR %segment%listing% (exact name I don't remember I dont have facility to view PDF now) gives COA for each sigment values along with heirarchies.