Sales Tax Validation
Date: Wed, 1 Sep 1999 10:51:08 -0400
From: "nkumar" nkumar@se-tech.com
To: oraapps-l@cpa.qc.ca
Subject: AR/Projects Invoice
Our Sales tax Validation is set to State.County.City. Tax Code for Sales tax has been
setup and attached to customer sites. A project has been setup with work site different
from the bill site. On running the autoinvoice program, we get the error stating
"Unable to locate valid sales tax rate for transaction. Ensure that active ST rate
exists for the transcation"
I have queried in AR for the sales tax rate using the state.county.city combination and a
valid rate exists. We have Vertax installed and are on Rel. 11.0.2
Would appreciate any help
Thanks
Nand
Date: Wed, 1 Sep 1999 12:17:17 -0400
From: alin2@csc.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AR/Projects Invoice
Have you tried to recompile the flexfield?
Alice
Date: Sat, 4 Sep 1999 16:43:46 -0400 (EDT)
From: Madhu Sudan Dada dada@csee.usf.edu
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: Re: AR/Projects Invoice
And the interesting thing check the start date or effective date
which should be earlier or same as your trx date.
Madhu Sudan Dada
Individual Receipt No. to automate AND Application of payments to Invoice Lines
Date: Wed, 1 Sep 1999 10:52:04 -0500
From: "Nguyen, Michael" MNguyen@co.scott.mn.us
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: yet another AR question
Thanks to all those who responded to my earlier AR question regarding attachments. Very
helpful. Two quick questions.
We're on 10.7SC GUI
1) In AR, I can set RECEIPT BATCH to auto number, but where can I set up individual
receipts to auto number? Is this possible? I can't seem to figure this out.
2) When applying receipts, can you apply payments to specific invoice lines rather than to
the invoice?
Thanks in advance for your asssitance!!
Date: Wed, 1 Sep 1999 11:59:13 -0400
From: "McShane, Chris" Chris.McShane@glenayre.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: yet another AR question
You can not apply receipts to invoice lines, you can only apply them to the invoice
(10.7). When I called Oracle on this question they said that applying receipts at the
invoice line level is being considered for a later release but they did not commit to a
release.
As far as I know you can not automatically number receipts without adding a DFF or some
other customization. Wouldn't you want to use the receipt number (check number) to record
a payment?
Date: Wed, 1 Sep 1999 23:02:33 +0700
From: "Srivastava S.K." sksrivastava@irs.co.id
To: oraapps-l@cpa.qc.ca
Subject: RE: yet another AR question
Hi,
Receipt can be applied to specific invoice line. There is one field of Line No. in
Application screen , by using LOV on this field it can be done.
Regards,
SKS
Date: Wed, 1 Sep 1999 12:10:27 -0400
From: "McShane, Chris" Chris.McShane@glenayre.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: yet another AR question
Can this be done in 10.7sc 16.1 or in this release 11 functionality?
Date: Wed, 01 Sep 1999 10:40:41 PDT
From: "Mohammed Liyakath" liyakath@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: RE: yet another AR question
Hi,
I won't think you can apply to a invoice line in 10.7.
Regards
Liyakath
Date: 1 Sep 99 14:13:11 CDT
From: CRAIG YEDINAK craig.yedinak@usa.net
To: "oraapps-l@cpa.qc.ca" oraapps-l@cpa.qc.ca
Subject: RE: yet another AR question
Chris and Michael,
The Line No. field has been there since at least 10.4.2, but the system doesn't track
balances at the line level, so it is not a usable feature. In addition, in 10.7 you can
only apply a receipt one time to each invoice even if you select different lines on the
same invoice. So, if you want to apply a receipt to multiple lines, you cannot do that.
There is not such a restriction in 11.0.3, possibly in anticipation of the change to line
level application.
The enhancement of multiple receivable accounts will make line level application a
necessity, but at that is in the future. Possibly 11i, probably after that.
Hope this clarifies things, Craig
Craig Yedinak
Consultant
Date: Wed, 1 Sep 1999 15:22:27 -0500
From: "Nguyen, Michael" MNguyen@co.scott.mn.us
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: yet another AR question
Craig - THANK YOU. I just tested these scenario where this may occur and you are
absolutely correct...10.7 does not support the application of payments to invoice lines.
Date: Wed, 1 Sep 1999 14:40:40 -0700 (PDT)
From: Murali Avanamuthu mavanamuthu@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AR: receipt application to invoice lines?
Hi,
I am on 11.0.2 and just looked up the screen. There's no provision to enter invoice line
information. I would be very much interested to know which version has this capability.
The table layout (AR_RECEIVABLE_APPLICATIONS) does have the capability to record invoice
line being applied.
Thanks,
Murali
Date: Thu, 2 Sep 1999 08:20:04 -0500
From: "Nguyen, Michael" MNguyen@co.scott.mn.us
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: yet another AR question
To all interested in this question:
I tested this in version 10.7 GUI (by the way we are doing this implementation on a cash
basis) and the LOV does allow you to specify the invoice line. However, upon GL interface,
the amount applied is prorated among all invoice lines. Unfortunately, a prior message
from Craig Yedinak is correct...AR does not carry balance information at the line level.
This functionality does not seem to exist as yet.
Statements- Reference No. customize
Date: Wed, 01 Sep 1999 14:35:08 -0500
From: Dan Olson dolson@dacotah.com
To: "oraapps-l@cpa.qc.ca" oraapps-l@cpa.qc.ca
Subject: AR:invoice numbering and statements
We just changed one of our AR batch imports to auto invoice numbering. Since these numbers
mean nothing to the customer, we need to include the reference number (credit card
transaction number) on the statements instead of the generated invoice number. Has anyone
else done this? Where did you get the reference number for the statements? I see it shows
up correctly in the transaction form query, but I am not sure how to select it for the
statement.
Thanks
Dan Olson
Date: Wed, 01 Sep 1999 16:14:47 PDT
From: "Mohammed Liyakath" liyakath@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AR:invoice numbering and statements
Hi,
The reference field populate from header_attribute1 from ra_interface_lines_all table for
your cast if may be diffrent attribute column. I fot got the package which tell you which
the column name. Just check all the atrribute columns. I will let you know.
Regards,
Liyakath
Tax Interface - Import very slow
Date: Wed, 1 Sep 1999 16:38:29 -0400
From: Kevin Bradley kbradley@mapmobile.com
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: Receivables
We have populated the tax interface with tax data. When we ran the import it was taking
forever. So we killed it and only loaded 1000 records. This took 2 hours to load into the
tables in Oracle. Then we loaded 2000 records. This ran for about 20hours. All of our temp
space on our drives was eaten up by the tax interface process, and subsequently, the
process just hung there. I have called a TAR into Oracle (12250196.600). They have had me
check to make sure all the triggers are enabled, which they are. They also had me check
the indexes to make sure they are valid, again they are. This has been going on now for
about a week and we are not making any real progress.
Now I will tell you that this is a test instance and that we are running apps version
11.0.3 and database version 8.0.5 on SUN Solaris. I did increase the cache size to 5000 in
(N) Setup-- System-- System Options.
I was wondering if anyone has any ideas/input as to why we cannot get the interface to run
without crashing the system. Is there anything in setup I am missing? Or is there
something I should look at on the database side? At this point any help would be greatly
appreciated.
Kevin Bradley
Map Mobile Communications Inc.
840 Greenbrier Circle
Chesapeake, VA 23320
(757)424-1191
(800)374-5423
kbradley@mapmobile.com
Date: Wed, 1 Sep 1999 18:20:29 -0400 (EDT)
From: Madhu Sudan Dada dada@csee.usf.edu
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: Re: Receivables
The best bet is trace file.
Madhu Sudan Dada
Concsub to call Autolockbox
Date: 1 Sep 99 18:20:28 MDT
From: vv vv venvivek@usa.net
To: Submit Question oraapps-l@cpa.qc.ca
Subject: AR : CONCSUB to call Autolockbox
Hi Guys.
Anyone have tried calling Autolockbox through CONCSUB, Any help will be appriciated.
Thanx in advance.
Regards.
Date: Thu, 2 Sep 1999 09:28:42 -0400 (EDT)
From: Madhu Sudan Dada dada@csee.usf.edu
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: Re: AR : CONCSUB to call Autolockbox
In the past it was not possible but recently it has been made possible. Please check with
Oracle AR Support and ask question with this background, they may be able to help.
Madhu Sudan Dada
Date: 2 Sep 99 11:15:45 MDT
From: vv vv venvivek@usa.net
To: oraapps-l@cpa.qc.ca
Subject: Re: [Re: AR : CONCSUB to call Autolockbox]
Thanx Man.
I got the syntax.
Regards.
Vivek.
Date: Fri, 3 Sep 1999 09:20:56 +0100
From: "Thornton, Steve (UK01)" Steve.Thornton@UK.Honeywell.com
To: oraapps-l@cpa.qc.ca
Subject: RE: [Re: AR : CONCSUB to call Autolockbox]
Vivek,
Could you share what you found please, as I am interested in doing this also.
Many Thanks
Steve Thornton
Autoinvoice errors
Date: Wed, 01 Sep 1999 17:41:01 PDT
From: "RADHA KRISHNAN" radha_rk@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: URGENT-Autoinvoice errors
Hi,
We are on 11.02 NCA implementing GL,AR and AP.
When working on importing invoices info from our custom invoice application into AR, the
autoinvoice program and its validation report listed out the following errors:
-duplicate transaction flexfield;
-invalid bill to customer id;
-invalid conversion type;
-invalid primary salesrep;
-invalid ship to customer id;
-bill to address id must exist in ora.receivables and must be assigned to the bill to
customer;
-supplied ship to address id must exist in Ora.receivables and must agree with the
supplied ship to customer;
-supply sales credit assignments for trx when you specify you require salesperson;
-total % of sales credit must equal 100;
Now, we are working on dealing with these errors. In the meantime if any of you can share
your views/opinions on how to set right these errors, it will be a great help.
While mapping for integration of our custom invoice application with OF,is it a must to
use RA_INTERFACE_DISTRIBUTIONS table? If not why?
Thanks for any help.
Radhakrishnan
Date: Thu, 02 Sep 1999 08:05:31 -0400
From: "Anand Gonsalves" agonsalves@glenraven.com
To: oraapps-l@cpa.qc.ca
Subject: Re: URGENT-Autoinvoice errors
Hi Radhakrishnan
Since we do autoinvoice everydya I think I could be able to help U out. The error Invalid
customer id is because U R supplying a customer id which is not present in the system.
Check ur set up and check the batch source U R passing for the invoices.Also check in the
batch source if it is set to pass bill to customer values or id.If it is id and U R not
passing ID then U get that error. The conversion type is a not null column so U have to
pass a value in it. If U want to associate a salesrep with the invoice U R importing then
U have to pass a salesrep id or value or else U can just pass the -1 default which is
provided by Oracle. Also check that the address id U R passing is associated with the
customer and is marked as bill to. same with ship to address Also U have to populate the
ra_interface_salescredits_all table . I guess this should help U out but if U require any
other help I would be more than happy to provide U with an old source code I have.
Thanks
Anand
Date: Thu, 2 Sep 1999 06:02:48 -0700 (PDT)
From: Murali Avanamuthu mavanamuthu@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AR: URGENT-Autoinvoice errors
Hi,
You should synchronize your Batch source definition and your input data. For example, if
your batch source says 'transaction type' -- id and say you're passing the transaction
type name in your data, that's a mismatch.
Your flexfields (Invoice/Line Transaction Flexfield) definitions identify a unique
transaction or a line. You cannot have two lines having the same values for this
flexfield. That's your 'duplicate flexfield' error.
If you have in your setup 'Require salespersons', then you should populate
RA_INTERFACE_SALESCREDITS_ALL table.
If you like Autoinvice to use Autoaccounting to drive the accounting, then you do not have
to populate RA_INTERFACE_DISTRIBUTIONS_ALL. But if you have specific accounting
requirements from your legacy system, then you might consider populating the above table.
Good luck,
Murali
Date: Thu, 2 Sep 1999 09:29:47 -0400 (EDT)
From: Madhu Sudan Dada dada@csee.usf.edu
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: Re: URGENT-Autoinvoice errors
If you are using autoaccounting no distribution table role else how are you going to send
your custom account codes.
Madhu Sudan Dada
Invoice with Rules
Date: Thu, 2 Sep 1999 01:45:12 -0700 (PDT)
From: david gordon dg2435@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Invoice With Rules
Hi all,
I'm trying to enter an invoice with a rule as following:
Invoice date : 01-sep-99
Invoice rule : In Advance
Duration : 3 Month
First Date : 01-aug-99
The desired result accounting:
Receivables 100%
Unearned Revenue 66.67%
Revenue 33.33%
I can't receive the above result,
Can anybody help ??
David
Customer Service Managers (CSM)
Date: Thu, 2 Sep 1999 06:28:26 -0700 (PDT)
From: Praveen shirump@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: CSM in AR
Hello all,
Does anybody have any idea about AR maintaining Customer Service Managers. If it does how
can they be linked to an Invoice.
Greatly appreciate for any help.
Praveen.
Date: Thu, 02 Sep 1999 09:51:19 -0400
From: "Rusty Kimbrell" RKimbrel@pgahq.com
To: oraapps-l@cpa.qc.ca
Subject: Re: CSM in AR
Praveen
at the risk of seeming ignorant. You have a sales person and a csm and need to track them
both. Do you have a different CSm based on the type of invoice?
I ask this beacuase Im sure you ve already looked into replacing the salesperson ont
heinvoice with the CSM. The only other way I believe would be to use a DFF in one of the
invoices reference fields. but if someone tells you other wise please pass it to the whole
list.
Thanks
Rusty
Comments to specific Invoice Lines
Date: 2 Sep 99 06:47:28 PDT
From: Roger Drolet rdrolet@netscape.net
To: oraapps-l@cpa.qc.ca
Subject: Adding comments to AR invoice lines
Does Oracle provide standard functionality that will enable us to add comments to specific
AR invoice lines?
Thank you!
Roger
Date: Thu, 02 Sep 1999 09:54:38 -0400
From: "Rusty Kimbrell" RKimbrel@pgahq.com
To: oraapps-l@cpa.qc.ca, rdrolet@netscape.net
Subject: Re: Adding comments to AR invoice lines
Roger
we have this same issue what we did was create standard memo lines with a zero dollar
amount that has the text we want to print and then select that memo line for each line
ofthe invoice that needs a special description. I wish it had printable notes but I could
find any other way to make it happen. And yes this is very labor intensive.
Rusty
Date: Thu, 2 Sep 1999 10:07:31 -0400 (EDT)
From: Madhu Sudan Dada dada@csee.usf.edu
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: Re: Adding comments to AR invoice lines
I think the canned reply with be DFF's can do if nothing is there.
Madhu Sudan Dada
Date: Thu, 2 Sep 1999 08:50:45 -0700
From: "Orth, Tom (torth)" torth@sequent.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Adding comments to AR invoice lines
There is a comments field but it is part of the mandatory grouping rule in autoinvoice. So
if the comments column, at least in autoinvoice is different for any of the lines,
autoinvoice will want to make a separate invoice.
Customer Interface Table Columns
Date: Thu, 2 Sep 1999 08:59:06 -0700 (PDT)
From: =?iso-8859-1?q?Nilanjan=20Choudhury?= npclists@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Customer Interface table Columns
Hi ,
Could any one tell me how can i use the following columns in the Customer Interface tables
1. Global attributes 1-20.
What are these used for?
2. Org_id. ( where is it mapped to?)
Regards
Prince
Multiple Tax rates to same customer
Date: Thu, 02 Sep 1999 14:45:08 -0400
From: "Bimal Patel" bimal.patel@acnenergy.com
To: oraapps-l@cpa.qc.ca
Subject: Re:Tax Interface in AR-Urgent
Hi,
We propose to use third party Tax Software for populating Tax interface table in
AR.Initially we would like to populate only AR_Location_Values and AR_Rate tables th'
Interface. We have selected seeded state.county.city structure and we are on release
11.0.2 upgraded to 11.0.3.
The issue is how to enter 2 diffrent Tax Rates for two diffrent services we provide to the
same customer location ? System option is checked for allowing Customer exemption and also
for allowing Item and Item tax rate exceptions. Any help will be appreciated.
Thanks
Bimal Patel
Date: Thu, 2 Sep 1999 16:43:49 -0400 (EDT)
From: Madhu Sudan Dada dada@csee.usf.edu
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: Re:Tax Interface in AR-Urgent
Populating interface table is not an issue. You can populate and run interface and that
should do the rest. You can use item as service and charge different tax for items by
setting exceptions on the item for those locations.
madhu sudan dada
Autoinvoice - APP-11996 error
Date: Thu, 2 Sep 1999 14:57:30 -0700
From: McRaney Ronald-MCG32315 rmcraney@itexchsrv2.phx.mcd.mot.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: AR/OE:Error APP-11996 You must supply the amount for this transac
Has anyone come across this error running AutoInvoice ? "APP-11996 You must supply
the amount for this transaction ((Nil))" not sure if it's an AR or OE issue. The
amount is not getting populated in the interface table from OE.
Thanks for any hints.
Ron
Date: Fri, 3 Sep 1999 09:05:30 -0400
From: "KPMG - Chadda, Alok" CHADA@naa.org
To: "'rmcraney@itexchsrv2.phx.mcd.mot.com'"
Cc: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE:AR/OE:Error APP-11996 You must supply the amount for this tran
McRaney-
Sounds like an OE problem and a bug. You definately need value in amount column to load
transaction and OE module should pass the amount when you run Receiables interface.
HTH
Alok
Date: Fri, 3 Sep 1999 09:08:29 -0700 (PDT)
From: tina fusari tfusari@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AR/OE:Error APP-11996 You must supply the amount for this transac
Hi Ron,
Its an OE issue. If the amount is not there for the transactions in RA_Interface_lines,
RA_Interface_distributions, then check the Order for the amounts. The Order pulls the
amount from INV.
Customer attatchments - import from legacy system
Date: Thu, 02 Sep 1999 17:08:02 MDT
From: "Sean Mayhew" smayhew35@hotmail.com
To: OraApps-L@cpa.qc.ca
Subject: Importing Attachments
We want to import customer attachments from our legacy system. Does Oracle have an
interface?
Thanks in advance
Sean Mayhew
From: KPMG - Chadda, Alok
Sent: Friday, September 03, 1999 9:01 AM
To: 'smayhew35@hotmail.com'
Subject: RE:Importing Attachments
Sean,
There is no way to load attachments into Oracle Receivables. You need to build a
customization to do it. Check my site at
http://www.geocities.com/SiliconValley/Network/9828/index.html
there are couple of scripts related to enabling and loading attachments into Oracle
Applications.
HTH
Alok