Credit Memo - thru Autoinvoice not updating Payment Schedule
Date: Wed, 8 Sep 1999 09:57:37 -0700
From: "Orth, Tom (torth)" torth@sequent.com
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: AR: Autoinvoice CM not updating payment schedule?
I have Credit memos that are being brought in via autoinvoice, and they
are coming in without errors. The CM can be queried, and it relates to
the correct invoice, and the amount of the CM is correct, and everything
looks perfect.....except for one thing.....
AR_PAYMENT_SCHEDULES_ALL is not updated to reflect the amount
credited by the CM. The amount_due_remaining is not changed. Has
anyone encountered this before?
Thanks,
Tom-
Date: Wed, 8 Sep 1999 10:01:04 -0700
From: Karen Blackwell KBlackwell@rockshox.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Autoinvoice CM not updating payment schedule?
Tom, what version(s) are you running? We are battling a situation here
where we have a CM that is attempting to transfer to GL at double the
original amount. We are also missing these table entries (and others) that
you mention. So I am just curious how close together our problems might be.
TIA
Date: Wed, 8 Sep 1999 10:16:27 -0700
From: "Orth, Tom (torth)" torth@sequent.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Autoinvoice CM not updating payment schedule?
Hello Karen,
This is part of a conversion, so I don't know what the issues are regarding
GL. WE are running
11.0.3 of the app on an 8.0.5 database on a Sequent Dynix platform.
Date: Wed, 8 Sep 1999 10:23:11 -0700
From: Karen Blackwell KBlackwell@rockshox.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Autoinvoice CM not updating payment schedule?
I will then assume there is no relationship with these two problems. We are
on 10.7NCA, 7.3.3.6 Solaris 2.6
Thanks anyway. We'll keep bouncing our heads off the Oracle-Support-Wall.
Regards ....
Karen
Date: Wed, 8 Sep 1999 14:10:52 -0500
From: "Puchniak, Stan" Stan_Puchniak@standardaero.ca
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Cc: "'torth@sequent.com'" torth@sequent.com
Subject: re:AR: Autoinvoice CM not updating payment schedule?
Do the credit memos have complete=Yes? The only time I have seen the
situation you are describing is when the credit memo is not complete. You
can run the "Incomplete Invoices Report" and see if the transactions in
question show up on the report.
HTH,
Stan
Date: Wed, 8 Sep 1999 17:03:27 -0400 (EDT)
From: Madhu Sudan Dada dada@csee.usf.edu
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: re:AR: Autoinvoice CM not updating payment schedule?
That is a good suggestion. Then there will be issue on how you got
incomplete CM's in.
Madhu Sudan Dada
Date: Wed, 8 Sep 1999 16:57:38 -0400 (EDT)
From: Madhu Sudan Dada dada@csee.usf.edu
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: RE: Autoinvoice CM not updating payment schedule?
Double the amount support has some hint on that. I recollect something
similar.
Madhu Sudan Dada
Date: Wed, 8 Sep 1999 14:35:28 -0700
From: "Orth, Tom (torth)" torth@sequent.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: AR: Autoinvoice CM not updating payment schedule?
The CMs come in and are marked complete. Even though they are not REALLY
complete. I incompleted one and tried to complete it again and it gave me a
salescredit error. I hit the "Credit Balance" button and it recalculated
and
then
I was able to complete the credit memo. There was an error in my script
where I
was joining with ar_payment_schedules_all in the source 10.7 instance to
populate the ra_interface_salescredits_all table, and of course, CMs won't
have
entries in ar_payment_schedules_all! I have fixed this now.
But it still seems like a bug that it didn't give an error on these CMs and
marked
them as "Complete".
Date: Wed, 8 Sep 1999 16:33:56 -0700
From: "Orth, Tom (torth)" torth@sequent.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: AR: Autoinvoice CM not updating payment schedule?
This problem is not solved as I earlier thought. It has nothing to do with
the
salescredits as I've looked at other CMs and they don't have this problem.
The following is definitely happening: CM is imported and completed,
but not applied to the related invoice. Incomplete the CM, then you
must exit the form, re-enter the form and requery the CM, then hit complete.
This must certainly be considered a bug!
Date: Thu, 9 Sep 1999 10:19:10 +0300
From: Mohammad Fouwaaz Mfouwaaz@savola.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Autoinvoice CM not updating payment schedule?
As far as I know SUM(AMOUNT_DUE_REMAINING) FROM AR_PAYMENT_SCHEDULES_ALL
WHERE CUSTOMER_SITE_USE_ID = your customers site use id should tally with
the outstanding balance of the customer/site. Does it balance? Doesn't the
new Credit Memos affect the customers' balances? What about the Aging Trial
Balance?
Regards
Date: Thu, 9 Sep 1999 10:03:30 +0200
From: Suzie Roth suzie_roth@stcl.scitex.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Autoinvoice CM not updating payment schedule?
Hi,
It's a bug that we had when upgrading to 11.03.
I don't remember the bug number but the patch we install was 918382.
Ask Oracle support about it.
Regards,
-- Suzie Roth
MIS (Ext. 7151)
Date: Thu, 9 Sep 1999 08:48:27 -0700
From: "Orth, Tom (torth)" torth@sequent.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Autoinvoice CM not updating payment schedule?
Thanks Suzie,
I forwarded this to the analyst handling my TAR!
Customers ship-to location - report on
Date: Thu, 9 Sep 1999 17:01:47 -0500
From: Mark Cymerman MCymerman@DOMINOAMJET.com
Subject: HR Locations
HELP!
I'm trying to create a report that will show me all of my customers ship
to's and any locations associated with them. However, I cannot find the link
between hr_locations and the ra_address tables. Any help would be greatly
appreciated.
Thanks
Mark Cymerman
Date: 9 Sep 99 17:46:09 CDT
From: CRAIG YEDINAK craig.yedinak@usa.net
To: oraapps-l@cpa.qc.ca
Subject: Re: [HR Locations]
Hi Mark,
I'm not sure what you're trying to do, but HR_Locations is for your company's
sites (addresses), and RA_Addresses holds your customer's addresses. Oracle
does not have any link between the 2 (tables).
Should you possibly be looking at RA_SITE_USES?
Best of luck, Craig
Craig Yedinak
Independent Consultant
Date: Fri, 10 Sep 1999 08:24:54 -0500
From: "Severtson, Anne" amsevertson@sbec.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: HR Locations
The only time I have seen it linked is for internal customers.
You see a link under the customer Site uses area to location.
If a company chooses, they could use this to set up locations for customers,
( for example if you wanted to ship to this location).
But as Craig said, the locations are generally used for Purchase Orders
(internal locations and ship-to sites).
Date: Fri, 10 Sep 1999 09:38:22 -0500
From: Mark Cymerman MCymerman@DOMINOAMJET.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: HR Locations
We use the locations as drop ship locations.
I have tried but cannot find the link between site_uses and hr_locations.
Any other information would be greatly appreciated.
Thanks
Mark
Date: Fri, 10 Sep 1999 10:32:57 -0700 (PDT)
From: tina fusari tfusari@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: HR Locations
Hi Mark,
Use ra_customers, ra_addresses_all and ra_site_uses_all.
Date: Fri, 10 Sep 1999 15:19:22 -0400
From: Kevin Bradley kbradley@mapmobile.com
To: "Oracle Apps Listserver (E-mail)" OraApps-L@cpa.qc.ca
You can link them using TP_HEADER_ID or ECE_TP_LOCATION_CODE
Hope this helps.
Kevin Bradley
Map Mobile Communications Inc.
840 Greenbrier Circle
Chesapeake, VA 23320
(757)424-1191
(800)374-5423
kbradley@mapmobile.com
Date: Sat, 11 Sep 1999 10:46:26 +0300
From: Mohammad Fouwaaz Mfouwaaz@savola.com
To: oraapps-l@cpa.qc.ca
Subject: RE: HR Locations
Hi
Customers' ship-to's are represented in RA_SITE_USES_ALL. and the respective
locations are the LOCATION field. Try
select st.site_use_id
, st.site_use_code
, st.location
from ra_customers cs
, ra_addresses_all ad
, ra_site_uses_all st
where ad.customer_id = cs.customer_id
and st.address_id = ad.address_id
/
Regards
Tax Code Problem Query 2
Date: 10 Sep 99 06:15:07 PDT
From: Roger Drolet rdrolet@netscape.net
To: oraapps-l@cpa.qc.ca
We went live on Rel 11 of Oracle Order Entry and Receivables. When we attempt
to modify a transaction that we AutoInvoice from OE, we get the following
error on approximately 10% of the transactions:
"APP-11355 Unable to locate a valid Sales Tax rate for transactions. Ensure
that an active sales tax rate exists for the location."
Our client does NOT charge sales tax or VAT tax. We are using the
State.County.City as our Location Flexfield Structure. We set up one Tax Code
"RAF" with a Tax Type of Location Based Tax. We also defined all states and
assigned each state a tax rate of 0.0 and postal code range of 00000 to
99999-9999. We did not set up counties and cities.
Oracle suggested we recompile the Location Flexfield Structure and run a
script that checked for other errors. We sent Oracle our output and now they
are suggesting that we have to define all State.County.City combinations and
then assign a tax rate of 0.0 to each county and city. I don't believe this
is necessary so I'm looking for your input.
By the way, when the user clicks OK on the error message, the system lets the
user continue.
I do appreciate your input.
Roger Drolet
Date: Fri, 10 Sep 1999 08:29:12 -0500
From: "Severtson, Anne" amsevertson@sbec.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE:
If you use the Flexfield of State, County, etc. the system expects a
tax rate entry for each combination. Since you do not charge sales tax, I
have used the VAT type of tax. I used the flexfield of country only, no
validation. We had some customers that we did charge sales tax to, so we
set the tax codes on the customer sites in order to default. You can charge
a VAT Tax of 0%.
Anne
Multiple Invoices to an Order
Date: 10 Sep 99 07:55:00 PDT
From: Roger Drolet rdrolet@netscape.net
To: oraapps-l@cpa.qc.ca
Subject: Same Sales Order generating multiple invoices
We are using AutoInvoice to import orders from Oracle Order Entry. We noticed
that the system prepares a separate invoice for each warehouse that provided
products a customer. Theses products are all listed on the same Sales Order
in OE.
Can someone tell me what we have to do so that all line items for a specific
Sales Order appear on the same AR transaction (Invoice) regardless of the
number of warehouses that delivered products to the customer?
Our client is live, so I really do appreciate any help you can provide.
Roger Drolet
Date: Fri, 10 Sep 1999 10:06:44 -0500
From: "Severtson, Anne" amsevertson@sbec.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Same Sales Order generating multiple invoices
There are mandatory grouping rules for orders from OE to AR. There is a
report that lists these (I don't have OE where I am now so I don't rememnber
the name of the report, but ....)
In addition, you can set up additional grouping rules . You can use the
transaction flexfields to add detail etc.
I would first look at the report to what the mandatory rules are.
Anne
Date: Fri, 10 Sep 1999 10:11:21 -0500
From: "Severtson, Anne" amsevertson@sbec.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Same Sales Order generating multiple invoices
The PO_Location_Associations table links the Site_Use_id in
RA_Site_Uses_all to the Location_id in HR_locations.
Anne
Date: Mon, 13 Sep 1999 09:21:12 +1000
From: "Bevin Watson" bevin.watson@abs.gov.au
To: oraapps-l@cpa.qc.ca
Subject: Re: Same Sales Order generating multiple invoices
Hi Roger,
I can't give you the exact answer, but it is most likely related to your
grouping rules which are defined in AR.
You can search the AR doco for grouping rules, or there is a report in AR
which
lists the current grouping rules.
My understanding is that there is a mandatory set of grouping rules and, if
that
includes warehouse, I think you're stuck.
hope this helps
Bevin Watson
Financials Systems Adminsitrator
Australian Bureau of Statistics
Date: Sun, 12 Sep 1999 18:54:52 PDT
From: "Prasanna Kumar Jena" pk_jena@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Same Sales Order generating multiple invoices
One simple hint.
The hierarchy followed in choosing the grouping rule_
1) The grouping rule specified in the Invoice Sources window for the batch
source of the transaction line.
2) The grouping rule specified in the Customer Profile Classes window for
the bill-to site use of the transaction line.
3) The grouping rule specified in the Customer Profile Classes window for
the bill-to customer of the transaction line.
4) Otherwise, Autoinvoice uses the default grouping rule specified in the
System Options window.
Customer Import - possible only one at a time
Date: Fri, 10 Sep 1999 10:49:53 -0700 (PDT)
From: Ajay Alur ajayall@yahoo.com
To: oraapps-l@cpa.qc.ca
Cc: kumarsundaresan@yahoo.com
Subject: Customer import Error Message - Rel 11.02
Hi,
I am trying to resolve an error message that I got while doing customer
import.
It gave an error message as follows:
racvci - AR_GDF_VALIDATION.IS_GDF_TAXID_VALID BECAUSE THE package
JG_GLOBE_FLEX_VAL is invalid. And we found that some tables were not
there. So, we suppressed the package. Then, we are able to import one
customer at a time.
Although, I have uniqueness in ORIG_SYSTEM_CUSTOMER_REF ,
ORIG_SYSTEM_ADDRESS_REF, ORIG_SYSTEM_TELEPHONE_REF ETC. in the
respective tables, I do not know why I can not import many customers
and addresses at the same time. It gives a "Select into..Too many
rows" error message. Any help would be greatly appreciated.
TIA
Ajay
Date: Fri, 10 Sep 1999 13:59:30 -0400
From: Dinesh Makked dmakked@deltadentalva.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Customer import Error Message - Rel 11.02
We have encountered the same kind of problem where we were not able to
import multiple customers at the same time because process was completing
with errors whenver there were multiple rows in PROFILES interface table.
This is due to a known bug in Rel 11 and Oracle provided the patch after
which this problem was ironed out.
Should you need further explanation, contact me.
Date: Fri, 10 Sep 1999 15:11:25 -0700 (PDT)
From: Ajay Alur ajayall@yahoo.com
To: Dinesh Makked dmakked@deltadentalva.com
Cc: oraapps-l@cpa.qc.ca
Subject: REsolved - : Customer import Error Message - Rel 11.02
Hi Everyone,
Thanks to Dinesh for sending this outstanding response. I applied
patch no. 822300, and it fixed the problem.
This oraapps group is simply Awesome.
Patch set R and Patch 895101
Date: Mon, 13 Sep 1999 09:31:21 -0700 (PDT)
From: abdulfattah abdulkarim abdulfattah_a@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: ar patch set R and patch 895101
Hi,
I will apply AR Patch set R should I need to apply patch 895101 . The
Y2K Patches Table mentioned that, 895101 should be applied with Patch
set P.
Regards to all
Abdul
Date: Mon, 13 Sep 1999 13:56:45 -0700
From: McRaney Ronald-MCG32315 rmcraney@itexchsrv2.phx.mcd.mot.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: ar patch set R and patch 895101
AR-R is patch 818461 dated May '99 timeframe, 895101 is later than that.
895101 is does not appear to be included with AR-R. Why not, just do AR-S,
which appears to include 895101 ??
Cheers.
AutoAdjustment Program very slow
Date: Mon, 13 Sep 1999 12:05:08 -0500
From: Cheryl_Moore@huntsman.com
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: AR - AutoAdjusment Program
Recently, the above program is taking 5-7 hours to complete when in the past
it
finished within minutes. Has anyone encountered this slow performance for
the
above request? If so, what was done to correct it?
Thanks
Cheryl Moore
Ph: 713-235-6193
pgr: 800-391-6124
Lockbox - SQL Loader shift to different directory
Date: Tue, 14 Sep 1999 09:51:17 -0400
From: "Kelly.Newman" Kelly.Newman@plpit.fishersci.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: Lockbox SQL Loader
We have created our own SQL Loader for lockbox transmissions. Our
consultants placed this in the $AR_TOP/bin directory on our server. We
would like to move this to a custom directory, but can't find any
documentation on pointing the process to the custom directory. Does the
loader script have to stay in the standard directory, or can we move it? If
we can move it, how do we direct the process to the new directory?
thanks!!!
Date: Tue, 14 Sep 1999 16:41:14 +0100
From: "Thornton, Steve (UK01)" Steve.Thornton@UK.Honeywell.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Lockbox SQL Loader
Kelly,
Unfortunately, the Lockbox processing routine always looks for the control
file in $AR_TOP/bin. However, there are ways around this. The answer for
your site will depend on your operating system.
We are on UNIX and have achieved your requirement by moving the control file
to the $CUSTOM_TOP/ctl directory and then creating a symbolic link in the
$AR_TOP/bin directory referencing the file residing in $CUSTOM_TOP.
Hope this helps
Regards
Steve Thornton