Hi All,
Can some Guru mention in here all that happens during payable transfer to GL process? What all tables are hit and how GL batches are created in gl_je_batches table? In what manner those batches are created, what all lines are created in gl_je_headers table etc... ?
Regards,
Abhay
payable transfer to GL process
-
- Posts: 15
- Joined: Thu Mar 08, 2007 6:58 am
- Location: India
-
- Posts: 194
- Joined: Tue May 15, 2007 7:45 am
- Location: United Arab Emirates
Hi
If you have Diagnostic Patch Applied run the AP List Diagnostic script after every step what you do in AP Module, it will show the complete details
For Example if you create an Invoice what tables are pouplated, when you perform Validation if there is any hold what tables are created and when accounted what tables are populated
Similary when You run the Payables transfer process also it will show clearly the following
The basic information are transferred using reference columns 1 to 30 in GL_INTERFACE Table
From the GL_INTERFACE Table when you run the Import Journal process it populates GL_JE_BATCHES, GL_JE_HEADERS and GL_JE_LINES Tables
You can see the above details alos in AP List script if you have applied Diagnostic Patch in your Instance
Hope this helps
Regards
Sivakumar
If you have Diagnostic Patch Applied run the AP List Diagnostic script after every step what you do in AP Module, it will show the complete details
For Example if you create an Invoice what tables are pouplated, when you perform Validation if there is any hold what tables are created and when accounted what tables are populated
Similary when You run the Payables transfer process also it will show clearly the following
The basic information are transferred using reference columns 1 to 30 in GL_INTERFACE Table
From the GL_INTERFACE Table when you run the Import Journal process it populates GL_JE_BATCHES, GL_JE_HEADERS and GL_JE_LINES Tables
You can see the above details alos in AP List script if you have applied Diagnostic Patch in your Instance
Hope this helps
Regards
Sivakumar
Who is online
Users browsing this forum: No registered users and 2 guests