Page 1 of 1
Auto-reconcilitation Missing matching criteria
Posted: Thu Apr 30, 2009 3:35 am
by AIMAM
Hi,
In oracle apps 11i , manual reconcilation for bank statements is done by the user. On the attempt to try Autoreconciliation program the statement lines had the error"Missing matching criteria " in the AutoReconciliation Execution Report.
I have found in the cash mangement user manual the following:
The statement line needs at least one of the following criteria to
match, and all are missing: 1) transaction number; 2) invoice
number and agent name; 3) invoice number and agent bank
account.
But I do not know how to do any of the 3 points above because the bank statement lines entered either manually or uploaded through the interface consist of the following information only:
POST DATE, VALUE DATE , DR AMOUNT , CR AMOUNT,and BANK TRANSACTION CODE
What do we have to do to use the auto-reconciliation program?
Posted: Thu Apr 30, 2009 5:41 am
by oteixeira
Hello.
We successfully use Auto-reconciliation. The bank statement data consists exactly on the same data as yours, what we do is to add the transaction number before uploading it to the system.
Octavio
Posted: Thu Apr 30, 2009 9:44 am
by AIMAM
can you please specify what do you mean exactly by transaction number?
Should it be matched to a specific information in the application?
Thank you for your help...
Posted: Thu Apr 30, 2009 10:26 am
by oteixeira
Hello.
For AR and AP, the system stores the transaction numbers in 2 views:
CE_222_TRANSACTIONS_V
CE_200_TRANSACTIONS_V
Octavio
Posted: Sun May 03, 2009 9:00 am
by oracleapps1983
Hi Aimam
Transaction number either Check numbers of internal Bank or Third parties Bank Check Number.
Matching will be done based on Transaction numbers.
Regards
Oracleapps1983
Posted: Sun May 03, 2009 9:01 am
by oracleapps1983
Hi Aimam
Transaction number either Check numbers of internal Bank or Third parties Bank Check Number.
Matching will be done based on Transaction numbers.
Regards
Oracleapps1983
Posted: Sun May 03, 2009 9:01 am
by oracleapps1983
Hi Aimam
Transaction number either Check numbers of internal Bank or Third parties Bank Check Number.
Matching will be done based on Transaction numbers.
Regards
Oracleapps1983
Posted: Sun May 03, 2009 9:03 am
by oracleapps1983
Hi Aimam
Transaction number either Check numbers of internal Bank or Third parties Bank Check Number.
Matching will be done based on Transaction numbers.
Regards
Oracleapps1983
Posted: Sun May 03, 2009 9:03 am
by oracleapps1983
Hi Aimam
Transaction number either Check numbers of internal Bank or Third parties Bank Check Number.
Matching will be done based on Transaction numbers.
Regards
Oracleapps1983
Posted: Sun May 03, 2009 9:04 am
by oracleapps1983
Hi Aimam
Transaction number either Check numbers of internal Bank or Third parties Bank Check Number.
Matching will be done based on Transaction numbers.
Regards
Oracleapps1983
Posted: Sun May 03, 2009 9:04 am
by oracleapps1983
Hi Aimam
Transaction number either Check numbers of internal Bank or Third parties Bank Check Number.
Matching will be done based on Transaction numbers.
Regards
Oracleapps1983
Posted: Sun May 03, 2009 9:09 am
by oracleapps1983
Hi Aimam
Transaction number either Check numbers of internal Bank or Third parties Bank Check Number.
Matching will be done based on Transaction numbers.
Regards
Oracleapps1983
Posted: Wed May 20, 2009 1:01 am
by anjan.614
Hi,
We are getting problem when we are doing auto reconciliation. we are unable to do the auto reconciliation for an perticular bank. can you please help me what we have to(Set up) check before conclude the problem.
Regards,
Anjan