Double Accounting Entries in AP
Posted: 19 July 2005 01:09 PM
Newbie
Avatar
Rank
Total Posts:  12
Joined  2005-07-19

Normal Payment was made in AP. By right, the correct accounting entries shld be:
Dr liability $456 {dummy figure}
Cr cash $456

Transaction captured in Oracle:
Dr liability $456 {dummy figure}
Cr cash $456
Dr Revenue $123 {dummy figure}
Cr liability $123

In this case, $456 is the actual payment amount.

In ap_invoice_payments_all table, result returns only 1 record, $456 (correct transaction).
In ap_ae_lines_all table, 2 entries created (as above).

After we did AP to GL tranfer, the same entries created in GL journal entries.

How can this possibily happen?

Profile
 
Posted: 20 July 2005 08:38 PM   [ # 1 ]
Newbie
Rank
Total Posts:  2
Joined  2005-01-16

Stanley,

normally this is not possible. however, check following things: 1. if the invoice for which you paid is matched with PO/Receipt or unordered rcpt.check the related PO or Rcpt. 2. check accounting entries at the time of booking invoice either matched or no matched. 3. check the setup of the bank account.

I have never come across such situation in practical, but the above points might help.

thanks,

Profile
 
Posted: 21 July 2005 08:56 AM   [ # 2 ]
Newbie
Avatar
Rank
Total Posts:  12
Joined  2005-07-19

Basically, there were extra entries created in ap_ae_lines_all table. This is intermittent problem. Other payment transactions for the same customer and bank is OK.

Anyway to backtrace what had happened?

Profile
 
Posted: 01 September 2005 11:23 AM   [ # 3 ]
Newbie
Avatar
Rank
Total Posts:  12
Joined  2005-07-19

Logged TAR to Oracle, duplicate accounting entries found for AP payment transaction. Reason: UNKNOWN. Fix: Remove duplicate records. I was not satified with the explanation but they just can’t do much about it…

Profile
 
Posted: 30 November 2005 01:02 PM   [ # 4 ]
Newbie
Rank
Total Posts:  5
Joined  2005-05-08

Hi
Can you give the exact figures?
Have you set up customer / supplier association? Is it linked to this by any chance?
Regards
Ram

Profile
 
     Auto Lock box Process ››