Page 1 of 1
COA Parent and Child Mapping
Posted: Mon Aug 23, 2010 11:11 am
by 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
Posted: Mon Aug 23, 2010 2:56 pm
by admin
You want to export data or want to see online? tks
Posted: Tue Aug 24, 2010 1:10 am
by EMANUEL
Hi
I need to export the full list of Data with Parent along with its child values in R 12
Rgds
Emanuel
Posted: Tue Aug 24, 2010 6:02 am
by 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
Posted: Tue Aug 24, 2010 7:06 am
by 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
Posted: Thu Sep 02, 2010 9:52 am
by 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.