Error 95340 Accounting Payments in Subledger [ID 739099.1] | |||||
| |||||
修改时间 18-MAY-2010 类型 PROBLEM 状态 PUBLISHED |
In this Document
Symptoms
Cause
Solution
References
Applies to:
Oracle Payables - Version: 12.0.4 and later [Release: 12 and later ]
Information in this document applies to any platform.
Subledger Accounting Program Report
Create Accounting Process
Symptoms
Payments cannot account in the secondary ledger due to the following error:
Error 95340: The total debits and the total credits do not balance for this subledger journal entry. Please ensure that the application accounting definition Accrual Basis owned by Oracle contains journal line types for the event class Payments and event type Payment Created that can create a balanced entry. Also verify that any conditions associated with a journal line type are correct.
The difference between the accounted debits and the accounted credits is .01.
Cause
Bug 7262976 SHOWSTOPPER:PAYMENTS 804 & 833 NOT CONVERTED TO SECONDARY LEDGER
This is a set up issue for the rounding suspense account and the balancing option.
Solution
1. Enable rounding suspense account for secondary ledger where the rounding difference between
LIAB/GAIN and ITEM EXPENSE can be captured thereby accounting will be successful.
In GL, in the Accounting Setup self service page, query for the ledger.
Under the Ledger Options, update -> on the second page, there are two accounts
- Suspense Account(借貸不平暫記科目-次要總帳,主要總帳)
- Rounding Differences Tracking Account(捨入差異追蹤科目)
provide a rounding/suspense account where the rounding difference will be booked.
2. Set the option for balancing the Accounting lines by Ledger Currency to create the balancing
lines.
In GL, in the Accounting Setup Manager Self service page, query for the ledger.
Under Ledger Definition , there will be a checkbox for 'Balance Subledger Entries by Ledger
Currency' .(依據總帳幣別平衡分類帳-主要總帳)
Check this option and save the changes.
References
BUG:7205273 - R12: PAYMENTS DO NOT COVERT PROPERLY TO SECONDARY LEDGER, SHOULD USE THE SYS RAT
BUG:7262976 - SHOWSTOPPER:PAYMENTS 804 & 833 NOT CONVERTED TO SECONDARY LEDGER
BUG:7424375 - R12:OUT OF BALANCE PYMT TRANSACTIONS DO NOT ACCT