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
COA Parent and Child Mapping
-
- Posts: 463
- Joined: Thu Nov 09, 2006 4:50 pm
- Location: India
- Contact:
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
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
Who is online
Users browsing this forum: Ahrefs [Bot] and 2 guests