Hello Folks,
AR uses Autoaccounting feature to derive the segment values for the GL Accounts. this is fine.
but the question is how this is linked to GL..? i mean backend table link...
SELECT rads.gl_default_segment_id, rads.segment, rads.segment_num, rads.table_name, rads.constant,
rada.type "ACCOUNT TYPE", rada.org_id
FROM ra_account_default_segments rads, ra_account_defaults_all rada
WHERE rads.gl_default_id = rada.gl_default_id
AND rada.type IN ('REV')
AND rada.org_id = 204
In vision instance, if i execute this query, i'll get the details of autoaccounting setup information for Vision Operation Organization. but how actually it derives the GL Accounts..there should be link to GL...how can i link this Autoaccounting tables to GL_CODE_COMBINATIONS..?
any help is greatly appreciated...
thanks in advance...
Anant
AR Autoaccounting
-
- Posts: 194
- Joined: Tue May 15, 2007 7:45 am
- Location: United Arab Emirates
Hi Anant
To my knowledge,There is no direct link between autoaccounting and GL Code Combination Table.
In Auto accounting you are either hardcoding the values or setting up the system to pick up values from Transaction Type, Customer, Salesperson. So GL_CODE_COMBINATION picks up based on the set up what you have set in the system to pick up values from where
Regards
Sivakumar
To my knowledge,There is no direct link between autoaccounting and GL Code Combination Table.
In Auto accounting you are either hardcoding the values or setting up the system to pick up values from Transaction Type, Customer, Salesperson. So GL_CODE_COMBINATION picks up based on the set up what you have set in the system to pick up values from where
Regards
Sivakumar
-
- Posts: 4
- Joined: Tue Mar 06, 2007 7:56 pm
- Location: USA
Who is online
Users browsing this forum: Ahrefs [Bot] and 37 guests