autoreconciliation problem [message #409755] |
Tue, 23 June 2009 20:39 |
bananaman
Messages: 71 Registered: March 2009
|
Member |
|
|
Hi! I'm having trouble in using the autoreconciliation in R12 Cash Management. Why is it that everytime I run the program "AutoReconciliation", I always get the message "Program Ran Successfully, No Error Found." from AutoReconciliation Execution Report but the target bank statement status remains "Unreconciled"?
|
|
|
Re: autoreconciliation problem [message #409825 is a reply to message #409755] |
Wed, 24 June 2009 03:37 |
tgs100
Messages: 66 Registered: July 2005 Location: Chennai, India
|
Member |
|
|
I too got this message when there are no unreconciled payable/receivable transactions for the bank account. First ensure that there are unreconciled payments/receipts for the bank account.
If you want to reconcile receipts, then the receipt status should be "Remitted".
In the case of Payables, check the payable options and make sure that clearing is enabled for the OU.
Cheers,
Saravanan
|
|
|
Re: autoreconciliation problem [message #409855 is a reply to message #409825] |
Wed, 24 June 2009 04:39 |
bananaman
Messages: 71 Registered: March 2009
|
Member |
|
|
Hi! I already checked my receipt class for that bank that I used. In the Clearance method, I chose 'By Matching' so that this will require the reconciliation in cash management. Even if the state of the receipt is 'Remitted', I still got the same result. I also tried to reconcile other bank statements with no matching receipt but the execution report did not raised any error and still prompted "Program Ran Successfully, No Error Found." on the execution report. Any other suggestion to fix this?
|
|
|
Re: autoreconciliation problem [message #409870 is a reply to message #409855] |
Wed, 24 June 2009 05:09 |
tgs100
Messages: 66 Registered: July 2005 Location: Chennai, India
|
Member |
|
|
Did you upload the bank statement or entered it manually.
Have you done transaction code setup in CM? Have you attached the transaction codes in the bank statement lines?
Cheers,
Sara
|
|
|
Re: autoreconciliation problem [message #409872 is a reply to message #409870] |
Wed, 24 June 2009 05:14 |
bananaman
Messages: 71 Registered: March 2009
|
Member |
|
|
I just entered the bank statement manually. I have set up the transaction codes. My question is how do you attach the transaction code to the bank statement lines? Thanks for the reply by the way.
|
|
|
|
Re: autoreconciliation problem [message #410021 is a reply to message #409874] |
Wed, 24 June 2009 20:20 |
bananaman
Messages: 71 Registered: March 2009
|
Member |
|
|
Ok. I got it. It is now working. I usually run the AutoReconciliation program in 11i without entering the code in the statement line and it works properly that's why I assumed this would be just the same in R12. Thanks a lot!
|
|
|
Re: autoreconciliation problem [message #410038 is a reply to message #410021] |
Wed, 24 June 2009 23:05 |
tgs100
Messages: 66 Registered: July 2005 Location: Chennai, India
|
Member |
|
|
I doubt that auto reconciliation works in R11 without transaction codes.
As per my understanding, even in R11, transaction code is mandatory in bank statement.
Cheers,
Sara
|
|
|
Re: autoreconciliation problem [message #410072 is a reply to message #410038] |
Thu, 25 June 2009 01:15 |
bananaman
Messages: 71 Registered: March 2009
|
Member |
|
|
It works, even if you don't link the bank transaction code you created to the bank statement line. The field "Code" in Bank Statement Line window is not a required field. That is what I usually do when running the AutoReconciliation program. But I always provide the receipt number in the "Number" field.
|
|
|