Onaccount Receipt
Date: Fri, 19 Mar 1999 05:22:37 PST
Date: Fri, 19 Mar 1999 19:06:39 +0530
x-------------x
From: Tom Wyatt [mailto:tom.wyatt@sitel.com]
From: Wells, Larry LWells@dfwairport.com
Date: Thu, 29 Apr 1999 21:04:18 +0530
Date: Thu, 29 Apr 1999 13:55:33 -0500 Automating application of Unapplied Receipts
From: On Behalf Of Saranath P
On Fri, 26 Feb 1999 11:37:00 bgavin wrote:
Date: Sun, 28 Feb 1999 06:15:44 -0500 (EST) Apply / Unapply same Receipts
Date: Tue, 29 Jun 1999 13:31:50 -0400
"Mancuso, Keeley" KMancuso@ENERGY.TWC.com 06/29 2:14 PM
Date: Tue, 29 Jun 1999 14:30:41 -0400 Lockbox - Converting Historic Pmts.
Date: 24 Mar 99 06:43:24 CST
Date: 24 Mar 99 13:59:37 MST
Date: Mon, 22 Mar 1999 09:01:07 -0700 Lockbox without sql*load
Date: Fri, 19 Mar 1999 08:43:29 -0700
We are having Character 10.7. This is how we are doing now. Lockbox interface
From: "mike ruff" mikeruff@hotmail.com
From: "Basanta Kumar Dash" dashbk@hotmail.com
From: "mike ruff" mikeruff@hotmail.com
Date: Sat, 24 Apr 1999 19:03:23 PDT
Date: Mon, 8 Mar 1999 08:00:03 -0500 (EST) LockBox / Autocash Rules
From: "Indrasena Kasi reddy" indrasen98@hotmail.com
Date: Tue, 27 Apr 1999 18:50:05 PDT BAI2 format for AR app in 10.7SC
From: "Lee, James W." James.W.Lee@fmr.com
Date: Fri, 14 May 1999 06:39:00 PDT AutoLockbox Overflow records
Date: Mon, 22 Feb 1999 17:37:08 -0500 (EST)
Stefan Ziemer stefanz@oakton.com.au Lockbox and overpaid amount
Date: Thu, 4 Feb 1999 12:08:01 -0800
Date: Fri, 5 Feb 1999 11:45:53 -0500 (EST) Uploading BAI files
Date: Tue, 1 Jun 1999 13:41:04 -0400
Date: Tue, 01 Jun 1999 22:32:54 -0700 LockBox and Negative Amounts/Credit Memos
Date: Tue, 22 Jun 1999 06:02:23 -0700 (PDT)
Date: Tue, 22 Jun 1999 10:23:54 -0400 Lockbox Error APP-43281
Date: Thu, 1 Jul 1999 10:56:16 +0100
Date: 1 Jul 99 16:45:58 CDT
Date: Fri, 2 Jul 1999 09:04:13 +0100
From: "simon daniel"
Subject: AR : onaccount receipt (help)
Hi ,
Can someone help me in understanding onaccount receipts.I see that
the balance of a invoice does'nt come down. how can i adjust
this amount ?
When i raise a standard receipt the system passes an additional
dr and cr line indicating the unapplied account
ie for Trade reciepts the JE lines
dr bank 100
cr receiveables a/c 100
dr unapplied 100
cr unapplied.100
why does the system pass a balancing entry for unapplied account?
Thanks in anticipation
Simon
From: B Bharat Bhaaradwaj
Subject: RE: AR : onaccount receipt (help)
You have got it a little wrong.
See when u make a standard receipt first the money is taken into
unapplied cash then at the time of application it is taken into the
respective receivable account.
Entries go this way=20
1. On entry of receipt.
Dr. Bank 100
Cr. Unapplied 100
2. On application i.e to a specific invoice.
Dr. Unapplied 100
Cr. Receivables 100
I hope i am able to explain to u correctly.
Regards
Bharat
B.Bharat Bhaaradwaj
Wipro Infotech - ESD
40/A Bassappa Complex
Lavelle Road
Bangalore 560001
Ph.2215010 Ext.220/221
Sent: Thursday, April 29, 1999 8:27 AM
Subject: How to Enter an on-account receipt
I thought I understood this matter. However; could someone consider
the
following scenario and inform me of what I am doing wrong.
Application: Oracle Receivables 10.7SC
Scenario:
A Customer remits payment of $400, I apply $300 to the close the open
invoice leaving $100 dollars unapplied.
Question:
How do I move the $100 dollars from unapplied to on-account? Or does
the
$100 remain in unapplied? If so, how do I now indicate that the
customer
has $100 on account?
I hope this makes sense to anyone that's listening.
Sent: Thursday, April 29, 1999 8:34 AM
Subject: RE: How to Enter an on-account receipt
There is a field called Transaction Number on the application receipt
screen
when you are telling the system which invoices to apply the money to.
Within that field, there is a value that you can populate instead of the
invoice number called On-Account. Just select that value, and the
remaining
$$$ will automatically migrate to the On-Account account.
Subject: RE: How to Enter an on-account receipt
Date: Thursday, April 29, 1999 7:12 PM
I thought that to be the case, but I don't see the on-account value.
That's
why I am so confused. Does this value only appear sometime? Or is there
a
bug in the system?
From: "Shamica Wakade" shamica@sohm.soft.net
Subject: Re: How to Enter an on-account receipt
Hi,
I think you are talking of applying receipts through Batches -
Manual-Quick. On this screen there is a field - 'Application type'. You can
set this field to 'On-Account'.
If entering receipts through manual-quick batches, you can also enter
'Application Type' as 'Autocash rule set'. And when defining the rule set,
set the field 'Remaining Remittance Amount' field to On-Account. This would
direct all your remaining receipt amounts as On-Account instead of
Unapplied.
But, apps does not allow you to enter the amounts as On-Account if you are
applying an individual receipt and not through a batch. It always puts it
as Unapplied.
HTH
Shamica.
From: "Puchniak, Stan" Stan_Puchniak@standardaero.ca
Subject: RE: How to Enter an on-account receipt
We had the problem where the "On Account" value was not listed in the LOV.
This was caused by Oracle Support closing transactions with an inappropriate
status of open. Check the AR_PAYMENT_SCHEDULES_ALL table for TRX_NUMBER "On
Account" and see what the STATUS is. The status should be "OP". If the
status is "CL" then this is your problem. Modify the status to "OP" and
everything should be O.K.
Stan
Sent: Friday, February 26, 1999 5:38 AM
Subject: AR: Application of large volumes of Unapplied Receipts
automatically
Hello AR Gurus,
We are on 10.7 Rel. 16.1. We have a large volume of customers in AR and
consequently
high volume of invoices raised and collections made (Running to approx.
100,000 invoices and 70,000 receipts a month). These invoices and receipts
are imported from an external system. The receipt import results in large
volume of unapplied receipts of miniscule amounts (Say below INR 100.00). On
an average this unapplied receipts amount to almost 15000.
If any of you have worked on AUTOMATIC APPLICATION OF UNAPPLIED RECEIPTS,
will you please help us as to how you achieved?
Thanks in Advance.
Prabu
Prabu,
Are you looking to automate the process of importing these receipts? Would
it be beneficial for you to be able to automate this process? If so, we may
be able to help you. Please email me if you would like to discuss this
matter further.
Authentically,
Brian Gavin
From: "Saranath P"
Subject: RE: Application of large volumes of Unapplied Receipts automatically
Hi Brian,
Thanks for your response. The problem in detail is this.
1. Receipts are downloaded against pending invoices with application details. However,
there will be some unapplied amount against almost all these receipts due to customers
paying round-off sums etc.
2. These excess amounts needs to be applied against subsequent invoices raised in the external
system and imported into Accounts Receivable.
We are looking at automating the application of the unapplied portion of the old receipts against
subsequently imported invoices against respective customers.
Looking forward to hearing from you
TIA
Prabu
From: "Rusty Kimbrell" RKimbrel@pgahq.com
Subject: AR PROBLEM Apllied/Un applied
Has anyone ever seen this problem.
We get in a series of receipts and are forced by our internal staff to
apply them to an invoice that we have made up. Just to recognize the
revenue(which by the way is truely a deposit).
Then when an agreement is finally come to we create the "real" invoice and
unapply the cash from the one invoice and apply it to the other. Herein
lies my problem.
We have set up the receipts to have the same account for applied and
unapplied cash thinking that the result should always net to zero.
WRONG!!! for some reason the system is creating unbalanced journal entries
for the activities of the receipt and now my applied/unapplied account is
carrying a HUGE balance.
Has anyone ever experienced this, and can any of you figure out why Oracle
will create out of balance journals out of the subsytem.
PS we have intercompany turned on so the journal balances itself that
way on the GL side.
HELP ME PLEASE!!!!!
Rusty
Look at your tables, sometime offsetting entries get hosed up and you
have
to do some table maintenance (with Oracle's help).
From: "Rusty Kimbrell" RKimbrel@pgahq.com
Subject: Re: RE: AR PROBLEM Apllied/Un applied
Keeley thanks for the reply which tables should I check and what would you
suggest i check for. I have check in the tables to some extent and found
that the journal created is truely going to the tables with 3 lines or 7
lines or some other odd number.
can you give me any more advice
Rusty
From: Mani Kumar Manda
Subject: Converting historic Payments using Lockbox Interface
Hi,
We are trying to convert historic payments using AutoLockbox
interface into AR. The Payments are being imported into AR,
but all of them are coming as 'On Account' payments, even
though the Invoice number was specified in the Lockbox data.
The Match Receipts by field is set to 'Transaction Number'
at Lockbox and Customer level. The AutoCash Rule Set is
defined with following rules: 1) Clear the Account and
2) Match Payment with Invoice Number.
We are using Oracle Applications Release 11.0.200 on Sun
Solaris on Oracle DB 8.0.5.0.0.
Thanks in advance for the help.
Mani Kumar Manda
Email: mmanda@usa.net
From: CRAIG YEDINAK craig.yedinak@usa.net
Hi Mani,
First of all, take a look at the receipts in the payment batch as it is
processed in the Maintain Transmission form and the Quick Cash Batch to get a
better idea of where the problem is. Something is probably being truncated or
padded with zeros so it isn't working.
Good Luck, Craig
Craig Yedinak
Independent Consultant
From: MANTOSRIDAR@micronpc.com
Subject: RE: LockboxDate: Mon, 22 Mar 1999 09:01:07 -0700
From: MANTOSRIDAR@micronpc.com
Subject: RE: Lockbox
Bevin
Here's what I did.
1. created temporary tables ( one for check, one for invoices and
one for batch info).
2. developed upload process ( use pl/sql or forms 4.5 or sqlloader ).
This process read the bank file and pupulates the temp tables without
missing the actual relation among batch, checks and invoices.
3. Developed reports on the uploaded batch (if needed).
4. Developed custom import process to populate ar_transmission
and ar_payments_interface from the temp tables. Proper Lockbox format
should be used After data is imported into interface, go to the lockbox
process form :
New Transmission : No
Enter Transmission Name
Submit Import : No
Submit Validation : Yes
Thanks
Michael
-----Original Message-----
From: Bevin Watson [mailto:bevin.watson@abs.gov.au]
Sent: Sunday, March 21, 1999 3:52 PM
To: Michael Antosridar
Subject: Lockbox
Hello Michael. Thanks for your response. It's good to know that things
are possible !
If you have time, could you give me just a few more starters on your custom
import process.
For instance, do you need to populate ar_transmissions ? And accordingly,
transmission_request_id and transmission_id on ar_payments_interface.?
How do you submit the lockbox - do you just fill in all the fields except
for "Sumit import"
Thanks for your help - you've already saved me days of work.
Bevin Watson
Australian Bureau of Statistics
+61 2 62525292
From: MANTOSRIDAR@micronpc.com
Subject: RE: Lockbox without sql*load
From: Bevin Watson [mailto:bevin.watson@abs.gov.au]
Sent: Thursday, March 18, 1999 6:42 PM
Subject: AR: Lockbox without sql*load
I am on 10.7 (char, Solaris, 7.3.4.3)
I currently create a dos payments file from a feeder system. I then upload
the file to unix and then run lockbox. Lockbox calls sql*loader which
loads the file into the interface tables and then starts the real work.
I'd like to cut out the dos file and the ftp. The obvious thing to do is
to get the feeder systemto directly insert into the interface tables via
ODBC. However, it looks like the lockbox import does lots of things in
addition to just running sql*loader.
Has anybody tried this? I'm looking for any ideas.
I created Forms Interface for upload. Icon is created to point on the network. User can select
the file using window file open dialog and upload to temp tables in Apps database server,
ofcourse under custom schema. This upload is done thru pl/sql I/O. After that we custom import
process is used to populate payments interface followed by regular lockbox process. By doing
this way, user no need to use ftp and sqlloader.
Thanks, Michael
Subject: AR:LOCKBOX INTERFACE
Date: Fri, 23 Apr 1999 17:17:37 -0400 (EDT)
Hi,
We are on release 11.0.2 and we have to migrate legacy receipt data
into Oracle AR using the lockbox. We would like to populate the
AR_PAYMENTS_INTERFACE table directly instead of using the
Transmission
Format and control file formats provided by Oracle for Open
Receipts.
When we try to run lockbox interface it asks for the control file,
dat
file and the transmission format. How do we get over this problem,
since we do not use any???
Anyone who has used this methodology, please throw some light on
this.
Any kind of help is welcome
TIA
Regards,
MIKE RUFF
ORACLE APPS PROJECT MANAGER
NEXEON INTERNATIONAL INC.
Subject: Re: AR:LOCKBOX INTERFACE
Date: Fri, 23 Apr 1999 20:08:34 -0400 (EDT)
Hi Mike,
Why are you not using Oracle control file and transmission format?
Even if you load yr data into AR_PAYMENT_INTERFACE table directly,
you
might be using control files (if you are using SQL*Loader).
I don't think you can avoid using oracle control file and
transmission
format if you are using autolock box.
We are using autolockbox (we are on rel 11.0.2) to transfer receipts
from other non-oracle systems using control file and transmission
formats. It's working perfectly fine.
Basanta.
Subject: Re: AR:LOCKBOX INTERFACE Thanks Basanta!!
Date: Sat, 24 Apr 1999 19:27:35 -0400 (EDT)
Thanks Basanta,
I guess u are right!
Could you send me the control file u used to transfer the legacy
receipts and a sample of the data extracts. Did u change the control
file given by Oracle??
How did u define the Transmission Format?
Please let me have your phone number so that I or any of team
members can call u up and discuss the matter in detail.
Regards,
MIKE RUFF
ORACLE APPS PROJECT MANAGER
NEXEON INTERNATIONAL INC.
From: "Basanta Kumar Dash" dashbk@hotmail.com
Subject: Re: AR:LOCKBOX INTERFACE Thanks Basanta!!
Hi Mike,
Currently, I am out of my previous project and company too. I was
working as a project manager. I won't be able to provide you the
control files, but, I can help you in guiding through the set ups.
Yes ! we did change the control file. We copied the deafult control
file provided by Oracle and changed it as per our requirements in the
ASCII file provided by the other non-oracle system. Just change the
field names and their positions as defined in yr ASCII file.
The transmission format and the control file should go hand in hand.
Field names and their positions should be same. We copied the default
transmission format provided by Oracle and modified as per our
requirements.
we could do all these after reading the documents on LOCKBOX provided
by Oracle. It's a nice document and will provide you all the
informations required for your interface. I would suggest you to go
through this document before implementing yr interface. Requirements
varies from site to site, but, document information is same for all.
Sorry, I couldn't help you much.
BASANTA.
From: James_Brown@cch.com
Subject: RE: AR-Receipts - URGENT
You can use Lockbox even without an official transmission file from the
bank. We use sqlldr to load an ascii file directly into
ar_payments_interface. If you list the invoices being paid, (and select
the appropriate options on the lockbox submit form) the payments will be
applied against those invoices, else the payments will be left unapplied.
The biggest quirk we came up against was that autolockbox has its own
internal call to sqlldr to load the transmission file into
ar_payments_interface. When we loaded data directly, we had to give it an
empty file to 'load'.(10.7 character)
Other than that, it was problem-free.
Subject: AR LockBox / Autocash Rules
Date: Tue, 27 Apr 1999 12:50:25 -0400 (EDT)
Hi All,
We are in the process of looking into the feasibilities of
Customization of AR Post QuickCash Process (ARCABP - PostBatch) to
accomodate our clients's requirements.
Details
As per the standard Autocash rule ( Match Payment with Invoice )we
can match a receipt with the invoice having the same amount. In case
of having multiple Invocies with the same amount, the Process picks
the earliest invoice for matching with the receipt.
But our client wants - If there are two or more invoices each with
the same amount of receipt - DONOT match. Match the invoice ONLY when
there is one invoice with equal amount of receipt.
If any one had a similar requirement, and achieved it without major
customization, Can you please share your experiences with us ?
AR Tech/Func GURUs!!! Your advice is highy appreciated.
Thanks ,
- Sen
From: "tayi sanjit" sandytayi@hotmail.com
Subject: Re: AR LockBox / Autocash Rules
Hi!
The only other way is to use the Order Number as a link between the
Invoice and Receipt. You have to pass the Order Number value into one
of the Attribute columns and pick up the same when defining your
autocash rules.
This is how we are currently doing it!
If u need more info please let me know.
SANDY
Subject: BAI2 format for AR app in 10.7SC
Date: Wed, 12 May 1999 12:12:21 -0400 (EDT)
Our company currently receive feeds directly from multiple banks using the
lockbox features of Oracle AR and these banks marry the wire and lockbox
functionality into 1 BAI1 file feed to us. However, one major bank cannot
marry the two files into BAI1 format, thus we get one file in format BAI1
and another containing wire receipt info in the BAI2 format. We end up
losing the automatic lockbox features and have to re-key the info manually
into Oracle.
My question is, does anyone out there know of an efficient method for
decrypting the BAI2 to fit into the lockbox functionality of Oracle AR.
Any info is greatly appreciated
James Lee
james.w.lee@fmr.com
From: "nekkanti rao" raonvv@hotmail.com
Subject: Re: BAI2 format for AR app in 10.7SC
Hi,
Yes. We did. The lockbox receipts from several banks received through
mailbox are split into several files i.e, one file per bank per record,
using unix shell scripts. Once these files are ready, the rest of the job is
standard functionality - creation of transimission formats i.e, one for BA11
and one for BAi12; import inot ar_payments_interface using SQL Loader etc.
If you are in 11.0.2, some of the problems in 10.7 are solved like using
other matching numbers, posting of remaining unmatched receipt into on
account etc.
Please send an email to nvvrao@hotmail.com, if you have further questions.
Thanks,
NVV Rao
From: mark.drogemuller@nz.eyi.com
Subject: AutoLockbox Overflow records
Hi all
Thanks to those who have replied to my questions so far. I now have
another.
Can someone please explain how the overflow process within the lockbox
works. Does it apply the receipts against the invoices or is it just a
data collection means, for which an additional manual proess is required?
Many thanks
Mark
on 23/02/99 12:21:36 PM
To: Mark Drogemuller/DIV5/WGTN/ErnstYoung/NZ
Subject: RE: AutoLockbox Overflow records
Mark,
Overflow records allow you to simply specify more INVOICE1-8, AMOUNT1-8
pairs for the given receipt. The receipt is applied to the invoices for the
amounts specified in the same way as the entries in the primary record are
handled. No further manual processing is required.
Regards,
Stefan Ziemer
From: Dayakar Reddy t_dayakar_r1@verifone.com
Subject: Lockbox Problem
Hai Receivable Gurus
We are implementing lockbox at our client site.
Thay want the overpaid amount [Customer suppose to pay $250, but he send
the
check for $300. So $50 is over paid.] should become" On Account" instead of
"Unapplied". Is there any setup needs to be done to make this or there any
work
around for this problem.
Thanks
Dayakar
From: "Rapavi, David" drapavi@kpmg.com
Dayakar:
To get the additional amount of the receipt paid to go On-Account rather
than to Unapplied, simply setup an AutoCash Rule Set and indicate that the
"Remaining Remittance Amount" goes to "On-Account" in the Automatic Matching
Rule zone.
Note: if your Lockbox file includes a transaction number, the above will
not work. The extra amount will automatically go into "Unapplied" and the
user will have to manually apply this to On Account.
hope this helps...
David Rapavi
From: Cathy Cakebread cathyc@compuserve.com
Subject: RE: AR LOCKBOX
Diane Wrote:
We are beginning are testing of Lockbox on REL. 11.02. I would like to
get some feedback from those who are experienced with setting up
Autolockbox.
My question is whether there is a need to write a program to upload the
daily BAI file from the bank or do we need to just rely on the Oracle
setups? The implementation manager believes that we need to hire a
technical consultant to write the script.
Plus, I am aware of the FALL OAUG paper on Lockbox; however, is there a
paper or SQL loader script published on Lockbox??
Response:
You should be able to use the standard definitions that Oracle provides
(without using another front end, unless you have particular issues with
your data. The default script is in $AR_TOP/bin. But you must also define
the Transmission (using the setup screen).
I usually modify the script to include both the amount and the invoice
numbers for all transactions to be paid (since then Lockbox does exactly
what the customer intended). Also, if you expect to have more than 398
invoice paid with a single receipt, you will need to expect the overflow
sequence field from 2 to 3 characters.
The key is to start working with your bank as soon as is possible since I
have seen it take 8 weeks for a 1 character change to the layout.
I wrote a paper on this topic a couple of years ago, but the concepts are
still the same. Send me an email at cathyc@best.com to get a copy.
Cathy Cakebread - Consultant
(650) 562-1167
From: dstreu@pacbell.net
Subject: Re: AR LOCKBOX
Cathy,
Thanks for your quick response to my dilemna.
We have a BAI file sample from the bank, and wanted to know what is the best
approach to setup the Lockbox and to test the functionality.
If the paper you wrote several years ago was called "Unlocking the Secrets of
Lockbox", then believe it or not, I have a copy. I will start with that.
Thanks again,
Diane
From: Kevin Johnson kevin_t_johnson@yahoo.com
Subject: LockBox and Negative Amounts/Credit Memos
Does anyone know whether the standard Oracle LockBox functionality can
handle Credit Memos and/or Negative Invoices?
For instance if our company issues a Credit Memo to a client for $500.
Can they then reference that Credit Memo and -$500 while making a
payment for an invoice?
I have not seen anything in the documentation about this at all.
From: Cathy Cakebread cathyc@compuserve.com
Subject: RE: LockBox and Negative Amounts/Credit Memos
I have been told that you can have the bank pass negative amounts as long
as the amount is preceded by the minus sign. E.g -10.00 would need to
passed as -0000001000 (depending on how long you have defined the field).
Note that if the credit memo number the customer provides is not correct
(e.g., for a customer deduction that is not already in the system), it will
reject.
I hope that this helps!
Cathy Cakebread - Consultant
cathyc@compuserve.com
(650) 562-1167
From: "Thornton, Steve (UK01)" Steve.Thornton@UK.Honeywell.com
Subject: AR Lockbox Error APP-43281 Receipt has invalid applications
Fellow Lockboxers,
I'm trying to import a lockbox and have just received the above error on
several of the imported records. I have implented several lockboxes, but
have not seen this error before, does anybody have any ideas?
When I look at the transmission data, the individual receipt application
lines have the separate error APP-43254 ERROR Receipt may not be applied to
this invoice type. I have had a quick look at the invoices, but nothing
obvious appears to be wrong.
Any help would be much appreciated.
Many Thanks
Steve Thornton
From: CRAIG YEDINAK craig.yedinak@usa.net
Subject: RE: AR Lockbox Error APP-43281 Receipt has invalid applications
Is the transaction type Open Receivable checked? If it's not, you can't
apply cash to it.
Craig
From: "Thornton, Steve (UK01)" Steve.Thornton@UK.Honeywell.com
Subject: RE: AR Lockbox Error APP-43281 Receipt has invalid applications
Thanks to those who helped.
The answer to this problem lies in a registered bug. The problem occurs
when an invoice number is the same as a receipt number. For those of you
interested, the following patches should prevent this occuring:
487472
381582
448188
668130
509949
600427
732570
748769
Regards
Steve Thornton