Lockbox - Credit Card
Date: Thu, 22 Jul 1999 14:46:02 EDT
From: "Debashish Bhattacharjee" dkbhatta@hotmail.com
Subject: CREDIT CARD LOCKBOXES ??How to??
Hello everybody,
My client has some serious issues with processing the credit card lockboxes.
It would be of great help if someone can list down what they do at their end
to process the credit card payments through ORacle Financials 10.7 SC
Autolockbox.
What we do is send a file to the credit card company and create a lockbox
file ourselves for importing into oracle.
This leads to a reconciliation mess over a period of time as there is a lag
time of a couple of days from the time we processed the file in oracle to
the time we receive a settlement from the Credit Card company.
I am sure there is some other way of doing this and would highly appreciate
if someone can throw some light on this issue.
regds
Debashish
Dunning Letters against invoices with partial receipts
Date: Mon, 26 Jul 1999 10:57:39 +0800
From: Stephen.Solomon@rac.com.au
Subject: AR: Dunning Letters not picking up Invoices with partial receipts
Hi all,
I was wondering whether someone could tell me whether the Dunning Letter
program is supposed to pick up invoices that have a partial receipt against
them. Basically we have debtors who have paid partial amounts against and
invoice but there is still a balance outstanding, however when we run the
dunning letters they do not get picked up.
Is this part of the Standard Program or is there an option that needs to be
enabled for these transactions to be picked up. We are on 10.7 SC 16.1 .
Thanks
Stephen
Stephen Solomon
Systems Accountant
RAC Group
Phone: +61 8 9421 4394
Fax: +61 8 9421 4545
Email: Stephen.Solomon@rac.com.au
Lockbox - Unique Constraint on ar_transmissions table
Date: Tue, 27 Jul 1999 17:04:31 BST
From: "x cbl" xcbl@hotmail.com
Subject: AR: Lockbox
I have some code that loads data into AR_PAYMENTS_INTERFACE table for
LOCKBOX. In order to mimic the SQL*LOADER procedure, I am updating
AR_TRANSMISSIONS table as well with a record.
I am hitting a problem with a unique constraint - AR_TRANSMISSIONS_U2 on the
AR_TRANSMISSIONS table.
Does anyone have any ideas of how I can get round this????
regards
robert
Date: Tue, 27 Jul 1999 09:30:43 -0700
From: "Orth, Tom (torth)" torth@sequent.com
Subject: RE: Lockbox
Are you supplying a transmission_request_id with your code? Are you
changing
it
for each load of the interface table? There should be only one record in
ar_transmissions for each run of your program.
Date: Tue, 27 Jul 1999 14:00:17 -0400
From: "Veronica Glanton/MIS/HQ/KEMET/US" VeronicaGlanton@kemet.com
Subject: RE: Lockbox
Robert,
Is there a particular reason why you are not using the APP to
import your records in the AR_PAYMENTS_INTERFACE table? I think
you're going to run into more problems besides the
transmission_request_id if you don't.
Regards,
Veronica
Date: Wed, 28 Jul 1999 07:52:46 BST
From: "x cbl" xcbl@hotmail.com
Subject: RE: Lockbox
Hi,
The main reason for loading this way is because this is an upgrade from 9.4.
In 9.4 the code used was to load manually. Seems that this will be the
quickest way as it is a basic system.
On the transmission_request_id, yes I am using this and changing it on every
run.
The main difference between 9 and 10.7 are the inclusion of the columns
TRANSMISSION_NAME and TRANSMISSION_ID (TRANSMISSION_REQUEST_ID still
exists). The index AR_TRANSMISISONS_U2 is on TRANSMISSION_ID and therefore
I require to load this column correctly??
Printing of Receipts
Date: Tue, 27 Jul 1999 17:18:32 -0300
From: Ken Heckbert kheckbert@ccgw.cc.hollandc.pe.ca
Subject: AR: Printing Receipts
Hello All!
We have a requirement to print out a receipt when someone
comes in to pay against their account. The AR system was
set up before I got here, and apparently Oracle does not
provide any standard reports for printing out receipts. Our
consultants set up an alert and three custom reports - one
for miscellaneous receipts, one for receipts applied to an
invoice and one for unapplied receipts.
I'm having a problem getting the unapplied receipt to fire from
the alert properly, but I'm also having a more basic problem
with the whole set up. Having three reports seems excessive
to me, and I was wondering what others are doing? Can
anyone share with me how they're generating printed receipts
from their AR system? Do you have different reports for
different kinds of receipts? Any tips would be most
appreciated.
Thanks,
Ken Heckbert
Finance Officer
Holland College
Driving Sales from Org level not from Master level
Date: Tue, 27 Jul 1999 16:48:25 -0400
From: "Annette Anost" aanost@goodegg.com
Subject: AR: How can item drive sales account?
We are currently working on release 11.02 / 11.03 in AR and OE and need the
ability to drive the sale account from the organization level and not the
master.
We are using Auto Invoice to import orders from OE into AR.
Any ideas would be helpful.
Thanks.
Annette Anost
aanost@goodegg.com