Reverse a payables posting in GL..urgent..plz help.. [message #223816] |
Sun, 11 March 2007 16:18 |
kawal.kaur
Messages: 4 Registered: March 2007
|
Junior Member |
|
|
Hi,
In Oracle Payables (AP), for an invoice, I create accounting, and then it is tranferred to GL. The transfer process is - Transfer to General ledger in Summary(accouting date).
My requirement is to reverse this posting and create a new posting for the same line to another account using GL_interface table.
can anyone please tell me how to achieve this.
|
|
|
Re: Reverse a payables posting in GL..urgent..plz help.. [message #224088 is a reply to message #223816] |
Tue, 13 March 2007 00:40 |
tgs100
Messages: 66 Registered: July 2005 Location: Chennai, India
|
Member |
|
|
I don't think standard functionality supports your requirement.
1. Is this requirement for all transactions or only for few?
2. What is your real requirement? i.e why do you want to do this? If you explain in detail, exports over here might suggest some other method.
Cheers,
Sara
|
|
|
Re: Reverse a payables posting in GL..urgent..plz help.. [message #224097 is a reply to message #224088] |
Tue, 13 March 2007 01:43 |
reachkiran
Messages: 7 Registered: February 2007
|
Junior Member |
|
|
Hi
Your Q: The transfer process is - Transfer to General ledger in Summary(accouting date).My requirement is to reverse this posting and create a new posting for the same line to another account using GL_interface table.
I would suggest you to follow the process of
1. Pass a reverse entry for the cancellation of old entry.
2. Re do the process of payables transfer to GL and choose the
option of journal import as "NO"
3. Go to GL interface table , based on accounting date, invoice date,id etc query the invoice and UPDATE /CORRECT GL account.
4.Once the interface table gets updated run journal import.
Rgds
Kiran
[Updated on: Tue, 13 March 2007 01:47] Report message to a moderator
|
|
|
|
Re: Reverse a payables posting in GL..urgent..plz help.. [message #224152 is a reply to message #224104] |
Tue, 13 March 2007 05:07 |
reachkiran
Messages: 7 Registered: February 2007
|
Junior Member |
|
|
Hi,
There should be two solutions for this problem.
1. Delete the data and re-import
2. Update the data
Practically once the data is imported into GL tables it is not advisable to delete the data until advised by Oracle.
For the second option you need to check various other factors like
Does data still exists in interface tables? If so can update the accounting from backend if transaction_type value is "UPDATE" . RE-submit journal import.
Rgds
Kiran
|
|
|
Re: Reverse a payables posting in GL..urgent..plz help.. [message #224154 is a reply to message #223816] |
Tue, 13 March 2007 05:18 |
tgs100
Messages: 66 Registered: July 2005 Location: Chennai, India
|
Member |
|
|
Delete records in GL? Through backend?
Don't ever think of deleting (updating also) GL records through backend in production instance. Oracle will never support updating/deleting of GL data.
If you update the account combination in interface table after transferring payables to GL, you may end up problems in reconciliation.
If at all you want to correct any account combination in GL, you need to reverse the journal and enter the corresponding adjustment journal in GL.
Cheers,
Sara
|
|
|
Re: Reverse a payables posting in GL..urgent..plz help.. [message #224165 is a reply to message #224154] |
Tue, 13 March 2007 05:50 |
reachkiran
Messages: 7 Registered: February 2007
|
Junior Member |
|
|
Sara,
I agree with you. Oracle would not support deleting of GL data. I was talking about deletion of data with respect to an invoice batch i said it's not advisable but for doing it you need to have script and support from oracle.
-- I believe that this forum is a platform to communicate, discuss and to share the subject.Pls dont use harsh words as
Don't ever think of
You Better do this etc
Rgds
Kiran
|
|
|
Re: Reverse a payables posting in GL..urgent..plz help.. [message #224193 is a reply to message #224165] |
Tue, 13 March 2007 06:45 |
kawal.kaur
Messages: 4 Registered: March 2007
|
Junior Member |
|
|
to make my point more clear, the requirement is -
for intercompany Transfer, when the AP invoice is generated at the selling org and i create the accounting for the invoice, Cogs account is debited. but at this point instead of making the posting to COGS account, i have to make it to some intransit account. Later on at the time of sending invoice to customer, my this posting made to intransit account needs to be revered and the same posting has to be done COGS account now.
I can not cancel the posting or delete the records from GL.
To reverse the posting and make a new posting, i have to make use of GL_interface table. the problem I am facing is what data should be populated in interface table.
|
|
|
Re: Reverse a payables posting in GL..urgent..plz help.. [message #224218 is a reply to message #224193] |
Tue, 13 March 2007 07:26 |
manojr
Messages: 38 Registered: January 2006 Location: Pune India
|
Member |
|
|
Hi,
Please try following.
Reverse the entire batch which is transfered to GL as a result of Payables accounting process.
go to payables, navigate drill down from gl.
Drill down the complete batch.
and again rerun the payables accounting process after making necessary changes.
Regards
Manoj
|
|
|
|
Re: Reverse a payables posting in GL..urgent..plz help.. [message #224467 is a reply to message #224193] |
Wed, 14 March 2007 06:59 |
David.K.Dickson
Messages: 413 Registered: October 2005 Location: Surrey, England
|
Senior Member |
|
|
kawal.kaur wrote on Tue, 13 March 2007 11:45 | ..... the requirement is for intercompany Transfer, when the AP invoice is generated at the selling org and i create the accounting for the invoice, Cogs account is debited. but at this point instead of making the posting to COGS account, i have to make it to some intransit account. Later on at the time of sending invoice to customer, my this posting made to intransit account needs to be revered and the same posting has to be done COGS account now.
|
Can I suggest that you treat this as a sort of Accrual? When the system generates the Debit to COGS, you raise a GL journal to Credit COGS and Debit the intransit account, then when you send the invoice to the customer, you reverse the journal, Debiting COGS and Crediting the intransit account.
Yes, it is a manual process, but it provides a better audit trail than editing or deleting system-generated transactions.
HTH
David
|
|
|