How to pass Bank Reconciliation adjustment entries
Date: Thu, 12 Aug 1999 06:00:58 GMT
From: "Sumit Sen" sens_sumit@hotmail.com
Subject: CM:Bank Reco - Rel 11
Dear All
We have a situation wherein an Invoice has been raised for us$1000 and the payment has
been made for us$1000 while the amount debited by bank is only us$950. The reason is that
this payment was made by issuing a foreign currency draft thru the Bank.Now the User does
not want to account the amount as an exchange gain but wants to reduce the expenses.The
Company uses only one currency.
One way I know is to prepare a Miscellaneous receipt but the Users do not want to do that.
The other alternative is to prepare an adjustment entry in GL and then reconcile the
amount with the GL amount.But then what should be the entry.
Is there any other solution to this?
Thanks in advance.
Sumit
Date: Thu, 12 Aug 1999 09:37:45 +0200
From: Suzie Roth suzie_roth@stcl.scitex.com
Subject: RE: Bank Reco - Rel 11
Assuming the $1000 payment are in the clearing account, available for reconciliation.
Create the following journal in the GL:
Debit Clearing Account: $50
Credit Cash Account: $50
Then reconcile the bank statement line against two transactions:
1. The $1000 payment
2. The $50 debit line in the cash account
Total amount remaining for reconciliation of this bank statement line will be 0 and the
net amount that will be in the GL cash account will be $950 which is correct.
Hope it helped.
-- Suzie Roth
MIS (Ext. 7151)
Receipts not loaded - how reconcile
At 01:56 PM 9/27/99 -0400, Tom wrote:
Hello,
We are loading our Oracle AR transactions into the Cash Management
interfaces,
and then running the import and autoreconciliation reports.
The receipts are NOT being reconciled because we are not loading the
receipt number.
Our bank does not provide a receipt number, just like the majority of
banks in
the United States.
Does anyone know how to work around this?
Thanks,
Tom
satyam@sri.lanka.net wrote:
Hello Tom,
As far as i know, receipt number is internal to oracle
applications.The
banks do not know this number. For Receipts, autoreconciliation goes
by hte
currency code, amount and date of the transaction.
Any way just cross check with others
Bhargav.
Satyam Enterprise Solutions.
From: oraapps-l@cpa.qc.ca [mailto:oraapps-l@cpa.qc.ca]On Behalf Of
Thomas Matthews
Sent: Tuesday, September 28, 1999 8:03 AM
To: Multiple recipients of list
Subject: Re: [Re: CE: Problem Reconciling Receipts]
I ran the autoreconciliation once WITHOUT the receipt number and it
didn't
reconcile the receipt. I ran it again WITH the receipt number and it
DID reconcile the receipt.
The receipt number is the same as a CHECK number.
So far Oracle support has not been able to help.
Tom
From: "Mohan Iyer" miyer@fortuna.com
Reply-To: oraapps-l@cpa.qc.ca
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: RE: [Re: CE: Problem Reconciling Receipts]
Date: Thu, 30 Sep 1999 07:32:36 -0400 (EDT)
I was reading about the Cash Management Reconciliation process and for
Receivables I was reading that you can use the Invoice Number or the
Customer Bank number for reconciliation. Though it did not say in so many
words I sort of got thst from the manual.
Probably you could try that as a resort to acheive the reconciliation
process.
I have personally only implemented the AP portion of Reconciliation and so
cannot give you any practical examples with regard to AR.
I am still in the process of implementing it for the AR module and if I run
imto anything I will kep the list posted with the results.
Thanks,
Mohan Iyer
Financials Consultant
Sunnyvale, CA
Date: Thu, 07 Oct 1999 06:23:26 GMT
From: "Sunny Sunny" sunn999@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: RE: [Re: CE: Problem Reconciling Receipts]
Hi ,
Reconciliation in CE is done first on the basis of Receipt number, and then
on any other parameters.
Receipt number has to be the check number for the banks.
Thats the reason why Receipt number has to be entered manually, there's no
automatic numbering for receipt numbers.
If you are not getting the receipt number from the bank, and if you are
using auto reconciliation, the other parameters on which you can perform
reconciliation are Deposit number, remittance batch number ( If you remitt
in batches), Customer name and currency. Try using deposit numbers, this
should help.
Regards,
Sunil Wahi
Load Bank Statement - Script to
From: "Bill Keenan" billek@ccai.net
Subject: Cash Management SQL script
Date: Tue, 19 Oct 1999 15:15:33 -0400 (EDT)
Hi,
I am in the process of defining the automated load of a daily bank
statement
to the Cash Management system. The bank statement is in the standard BAI
format. Does anyone know of a standard script out on OAUG, Metalink, Apps
Forum, etc., or any other location, that may have this standard script? It
appears to be fairly standard if your bank statement is in the BAI format,
so I'd rather not re-invent the wheel if possible.
I am currently running on 11.03, AIX.
Thank you very much in advance.
Bill
Date: Wed, 20 Oct 1999 05:23:44 PDT
From: "stephen bryant" sbryant@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Cash Management SQL script
Hi,
Below is my Cash Management Open Interface tables script.
Please Click here for the script
Date: Wed, 20 Oct 1999 20:33:45 -0700
From: "Mohan Iyer" miyer@fortuna.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Cash Management SQL script
Hi Bill,
Yes it is pretty straighforward and here is a script that you could use to
load the file. I think the client where I implemented this was using the BAI
format.
Load Data
--infile 'bnk_recon.dat'
--infile '/u01/applmgr/ssgswdevus/interface/in/ap/bnk_recon.dat'
APPEND
Into table CE_STATEMENT_HEADERS_INTERFACE
when (1:1) = '1'
(bank_name constant "BANK OF AMERICA",
bank_account_num constant "87658-00569",
statement_number "ce_statement_headers_s.nextval",
--statement_date position (14:19) DATE "YYMMDD",
statement_date SYSDATE,
last_update_date SYSDATE,
last_updated_by constant "1",
org_id constant "2"
)
Into table CE_STATEMENT_LINES_INTERFACE
when (1:1)='5'
(bank_account_num constant "87658-00569",
statement_number "ce_statement_headers_s.currval",
line_number position (3:12) integer external,
bank_trx_number position (3:12) integer external,
trx_date position(31:36) date "YYMMDD",
trx_code constant '0',
---trx_code position(37:38) integer external,
amount position (14:23) integer external ":amount/100"
)
Hope this helps.
Thanks,
Mohan Iyer
Financials Consultant
Sunnyvale, CA