Version R12/11i? = 11i
Instance PROD/TEST/VIS? = PROD
Module? = GL
OS? = WINDOWS XP
Hi Team,
Am trying to load records into GL_INTGERFACE (Related to Accruals). I.e extracting the data using discoverer tool and then load the extracted data into GL_INTERFACE, the problem is when i run the JOURNAL IMPORT program it ends up with warning stating that with the Error EU02,P: i.e. the journals are unbalanced, and when i check the sum of debits is not equal to sum of credits. and also the suspense account is not enabled. Can you please let us know how to deal with the amount i.e the amount from AP_INVOICE_DISTRIBUTIONS_ALL to ENTERED_DR and ENTERED_CR in the GL_INTERFACE.
Please anyone can share there ideas who had already done this kind of work
Thanks
GL_INTERFACE
Hello.
I believe it is not the first time I see this question. At least I?ve given a reply to a similar question a few days ago.
The problem for the unbalanced journals has to do with the fact that you are dealing with invoice distributions, which contain only part of the accounting data. To have all info you need to look at AP_INVOICES_ALL and AP_INVOICE_DISTRIBUTIONS_ALL tables (joined by INVOICE_ID column). Let?s see the accounting of a simple Standard invoice:
Line 1 Debit Cost $80
Line 2 Debit Tax $20
Line 3 Credit Liability $100
For line 1 you need to select column AMOUNT from AP_INVOICE_DISTRUBUTIONS_ALL, with LINE_TYPE_LOOKUP_CODE = Item
For line 2 you need to select column AMOUNT from AP_INVOICE_DISTRUBUTIONS_ALL, with LINE_TYPE_LOOKUP_CODE = Tax
For line 3 you need to select column INVOICE_AMOUNT from AP_INVOICES_ALL
I?m considering this solution for a simple standard invoice, in functional currency, with just two distribution lines, one for cost and one for tax.
If you just consider to complicate things just a little bit, like considering an extra distribution line for Withholding Tax and everything changes.
What you are trying to do is not an easy task (even using both tables).
Octavio
I believe it is not the first time I see this question. At least I?ve given a reply to a similar question a few days ago.
The problem for the unbalanced journals has to do with the fact that you are dealing with invoice distributions, which contain only part of the accounting data. To have all info you need to look at AP_INVOICES_ALL and AP_INVOICE_DISTRIBUTIONS_ALL tables (joined by INVOICE_ID column). Let?s see the accounting of a simple Standard invoice:
Line 1 Debit Cost $80
Line 2 Debit Tax $20
Line 3 Credit Liability $100
For line 1 you need to select column AMOUNT from AP_INVOICE_DISTRUBUTIONS_ALL, with LINE_TYPE_LOOKUP_CODE = Item
For line 2 you need to select column AMOUNT from AP_INVOICE_DISTRUBUTIONS_ALL, with LINE_TYPE_LOOKUP_CODE = Tax
For line 3 you need to select column INVOICE_AMOUNT from AP_INVOICES_ALL
I?m considering this solution for a simple standard invoice, in functional currency, with just two distribution lines, one for cost and one for tax.
If you just consider to complicate things just a little bit, like considering an extra distribution line for Withholding Tax and everything changes.
What you are trying to do is not an easy task (even using both tables).
Octavio
[quote]Version R12/11i? = 11i
Instance PROD/TEST/VIS? = PROD
Module? = GL
OS? = WINDOWS XP
Hi Team,
Am trying to load records into GL_INTGERFACE (Related to Accruals). I.e extracting the data using discoverer tool and then load the extracted data into GL_INTERFACE, the problem is when i run the JOURNAL IMPORT program it ends up with warning stating that with the Error EU02,P: i.e. the journals are unbalanced, and when i check the sum of debits is not equal to sum of credits. and also the suspense account is not enabled. Can you please let us know how to deal with the amount i.e the amount from AP_INVOICE_DISTRIBUTIONS_ALL to ENTERED_DR and ENTERED_CR in the GL_INTERFACE.
Please anyone can share there ideas who had already done this kind of work
Thanks
<i><div align="right">Originally posted by velichetiraghav
Instance PROD/TEST/VIS? = PROD
Module? = GL
OS? = WINDOWS XP
Hi Team,
Am trying to load records into GL_INTGERFACE (Related to Accruals). I.e extracting the data using discoverer tool and then load the extracted data into GL_INTERFACE, the problem is when i run the JOURNAL IMPORT program it ends up with warning stating that with the Error EU02,P: i.e. the journals are unbalanced, and when i check the sum of debits is not equal to sum of credits. and also the suspense account is not enabled. Can you please let us know how to deal with the amount i.e the amount from AP_INVOICE_DISTRIBUTIONS_ALL to ENTERED_DR and ENTERED_CR in the GL_INTERFACE.
Please anyone can share there ideas who had already done this kind of work
Thanks
<i><div align="right">Originally posted by velichetiraghav
Who is online
Users browsing this forum: No registered users and 5 guests