Page 1 of 1

26000 GL_COde Combinations

Posted: Thu Mar 15, 2007 12:16 am
by amit_gupta
Hi,

I am Functional Consultant and I need to Disable 26000 code combinations in GL can any body tell me how can we able to do it from the backend. If you have the Query or procedure Please forward me so that I can able to do it

Regards
Amit Gupta

Posted: Thu Mar 15, 2007 1:31 am
by admin
Login with GL responsibility and then Setup > Accounts > Combinations and search the code and enter to date. Hope it will work for you. thanks

Posted: Thu Mar 15, 2007 2:10 am
by amit_gupta
Yes it can be possible from the frontend also through combinations and I know the process of that but there are 26000 combinations which will take a long time so I want to know how to do it from TOAD

Posted: Thu Mar 15, 2007 4:01 am
by admin
Pl check the following query and filter the data as per your requirements.

SELECT code_combination_id, chart_of_accounts_id, end_date_active
FROM gl_code_combinations
WHERE chart_of_accounts_id = ?

I am sure you will first test all this on test. thanks