Setup Issues
Forms giving errors
Appanaboyina_Kishore wrote:
Hi,
I am on 10.7 Sc on Windows NT with Multi-org . I have defined a new
operating unit. While setting up Oracle Receivables, when i click on
Payment terms on the menu, Apps returns an error
FRM - 40735 Pre-form trigger raised unhandled exception, no data found.
When i click on for the Transaction Types form,returns with the following
error
APP - 010106 Routine FDFRKS Unknown structure id 0 for flexfield code GL#
with application id 101.
Both the forms return valid values when i attach any of the previously
defined operating units, I have been working on for the last 6months.
I have used the multi-org set up docuemnt to set these operating units. I
have exactly followed the steps recommended for setting up multi-org.
Thanks in advance.................
Kishore
Date: Wed, 07 Apr 1999 08:57:32 +0700
From: Argon Usman argon1234@usa.net
Subject: Re: AR Setup problems
Try to review or repeat the AR setup steps, (follow the setup steps in
Reference Manual)for the new operating unit. I have the same experience
during setting up Release 11, and found out that the System Options have
not been setup for the new Operating Unit.
Argon I. Usman
Consultant
PT Jati Piranti Solusindo
Menara Rajawali 12th Fl.
Kawasan Mega Kuningan Lot 5.1
Jakarta
12950
Indonesia
Phone:(6221)5761850
Fax:(6221)5761848
Date: Wed, 7 Apr 1999 09:54:31 +0530
From: Appanaboyina_Kishore Appanaboyina_Kishore@hts.satyam.com
Subject: RE: AR Setup problems
Hi Argon I. Usman,
Yes, the system options have to be defined first though the Oracle
Implementation reference manual recommends setting payment terms before
system options.
Kishore
tayi sanjit wrote:
Kishore,
To enable Multi-org for AR Setup ensure that you have done the
following:
1. Create a operating Unit
2. Attach Set of Books at Site and responsibility Level
3. Attach the operating unit u created at the Responsibility level for
MO: Operating Unit
4. Open AR Periods
5. Attach Set of Books at System Options
Now u are ready to enter payment terms.
If u need any further help let me know!
Bye
sandy
Date: Mon, 10 May 1999 03:27:56 +0800
From: Rhys Arnold rhysa@pacific.net.sg
Subject: Re: AR Setup problems
Hi Kishore,
Sandy is right about assigning the GL Set of Books and MO profiles to your
AR responsibilities.
One additional gotcha we found when adding a new org to our existing site
was that some Oracle seed data was missing from the new org. For example,
we were unable to launch the AR Payment Terms form after creating the new
org ("FRM - 40735 Pre-form trigger raised unhandled exception, no data
found").
Therefore after setting-up your new org you should run the "Replicate Seed
Data" concurrent program for the new org (run this from System
Administrator). It should work fine after this.
Regards - Rhys
rhysa@pacific.net.sg
Date: Mon, 10 May 1999 10:31:44 +0530
From: Appanaboyina_Kishore Appanaboyina_Kishore@hts.satyam.com
Subject: RE: AR Setup problems
Hi Rhys & Sandy,
We have run Replicate seed and the multi-org set-up was also done as per the
Oracle's Multi-org docuemnt. The Oracle Fin.Implementation docuemnt for
Oracle Receivables list the setting up of Payment terms prior to the System
Options which is not right. We set the system options and then we were able
to proceed further.
Thanks and I appreciate though it is a late reply...
Regds
Kishore
Assign Flexbuilder Rules Form
From: Roger Drolet[SMTP:rdrolet@netscape.net]
Sent: 04 May 1999 12:44
Subject: Step AR-2 (Setup)
I need to assign AR: Substitute Balancing Segment to the Original CCID in
the
Assign Flexbuilder Rules form.
I've looked at the documentation, however I have not been able to locate
the
form that I need to complete this task. If you can point me in the right
direction, I would really appreciate it.
Roger
Date: Tue, 4 May 1999 14:09:26 +0200
From: Zaman Joan ZamanJ@mail.europcar.com
Subject: RE: Step AR-2 (Setup)
go to the aol responsibility and look under flexbuilder in v11
hope this helps,
joan zaman.
System options - wrong SOB
Date: Wed, 23 Jun 1999 16:27:47 -0700 (PDT)
From: Murali Avanamuthu mavanamuthu@yahoo.com
Subject: AR: System options - wrong SOB
Hi AR experts,
I am on Rel. 11.0.2.
While entering system parameters for one of the
operating units, I chose a wrong set of books. I
realized it, immediately after saving. Now the system
doesn't let me change it. I'ven't done any other
set-up steps after this and hence obviously no
transactions either under this operating unit.
Now my question is: What's the implication if I
update AR_SYSTEM_PARAMETERS_ALL, with the correct
set_of_books_id and tax_currency_code, through SQL.
Right now, I think it's pretty safe to do so. But I
would love to hear the experts opinions.
Thanks for your time,
Murali
Date: Thu, 24 Jun 1999 09:22:15 -0500
From: Mandar Dewoolkar-G1606C Mandar_Dewoolkar-G1606C@email.mot.com
Subject: Re: AR: System options - wrong SOB
Make sure with Oracle before you do this. They won't support this; but
atleast tell you if there are any other tables that get updated in the
process. Or check it for yourself by opening the form in Designer.
Mandar
Accounting Setup
Date: Fri, 25 Jun 1999 11:54:08 -0300
From: Ken Heckbert kheckbert@ccgw.cc.hollandc.pe.ca
Subject: AR: Accounting Setup
Hello all AR Gurus,
We're currently having a discussion around the accounting
setup in our AR system. Currently, our On-Account and
Unapplied receipts are set to post to Revenue accounts, and
I think they should be posting to balance sheet accounts. In
fact, I can't see why we just don't set them to post to the
main Receivables account? Anyone have any thoughts? Any
reason not to just set these types of receipts to post these
amounts directly to the Receivables account?
Thanks in advance,
Ken Heckbert
Finance Officer
Holland College
kheckbert@hollandc.pe.ca
Date: Fri, 25 Jun 1999 13:19:09 -0500
From: "Puchniak, Stan" Stan_Puchniak@standardaero.ca
To: "'kheckbert@ccgw.cc.hollandc.pe.ca'"
Subject: Re:AR: Accounting Setup
We have these receipt types posting to balance sheet accounts. Specifically,
an "administration" receivable account. This also facilitates the
reconciliation function as the "Unapplied Receipts Register" should
reconcile to the balance in the "administration" receivable account on the
"Aged Trial Balance - 7 Bucket - By Account" report. These amounts can be
significant and could have a material effect on profit. Also, I do not
believe that these would qualify as revenue under any accounting policy
(GAAP or otherwise).
One word of caution. If you change this account, all past on account and
unapplied receipts will continue to use the old account. Even if they are
applied at the time the account change is made. If they are placed on
account after the change is made, they would use the old account. This is
not something that I have tested but believe to be so. Maybe someone can
provide their personal experience from changing the account number.
Cheers,
Stan
Date: 28 Jun 99 06:06:34 PDT
From: Roger Drolet rdrolet@netscape.net
Subject: Re: [AR: Accounting Setup]
Ken,
You certainly don't want to post on account and unapplied receipts to a
revenue account unless you are operating on the cash basis rather than ac=
crual
method. If you use Accrual Method, then I suggest you post to the approp=
riate
Receivables account.
Roger Drolet
Managing Associate
Conley, Canitano
From: "Marni Baggett" mbaggett@brk.photronics.com
Subject: Re: AR: Accounting Setup
Date: Mon, 28 Jun 1999 10:18:19 -0400
Marni Baggett wrote:
Ken,
I agree that these shouldn't be posting to revenue accounts!!! We
have set up separate receivable accts for each. All trade receivable
accts then roll up into one parent acct. I'm sure there's a good
reason to have separate accts, but we just did it b/c our Oracle
consultants told us we had to ..... great reason, huh? No one ever
gave us a very good explanation & I never took the time to research it
thoroughly, but I know it has worked fine for us over the last 15
months.
Marni Baggett
Photronics, Inc.
mbaggett@brk.photronics.com
From: CRAIG YEDINAK craig.yedinak@usa.net
Subject: RE: AR: Accounting Setup
Date: 28 Jun 99 11:15:48 CDT
Hi Marni and Ken,
The reason you use different accounts is for reconciliation purposes.
Assuming no other entries are made to the Receivable account, the Aged Trial
Balance should equal the GL Receivables balance. Once you make adjustments,
cash postings, etc. to this account you have to take that into consideration
during your recon as these entries are not shown on your ATB.
Best Wishes, Craig
Craig Yedinak
Independent Consultant
Date: Tue, 29 Jun 1999 13:50:13 +0530
From: rohit.sharma/Polaris@polaris.co.in
Subject: Re: [AR: Accounting Setup]
Hi Ken,
There is not basis of posting on account and unapplied Recipts to revenue
account.
In my opinoin you can post these reciepts to Receivable(Deposits) account also
or as suggested by Roger.
Rohit
Setup for Internal Customer
Date: Wed, 30 Jun 1999 13:38:37 -0400
From: Paul Mallon pmallon@oasys-grp.com
Subject: Setup for Inter-Org Requisitions
During setup of an Internal Customer, when I am associating a Location
with the internal customer, I get the error message:
"Internal location is already been assigned to another Ship-To
address"
This is the 1st internal customer I am creating.
Does anyone know what might be wrong?
I called in a TAR - with no successful results.
Thanks,
Paul
Date: Wed, 30 Jun 1999 15:13:00 -0400
From: "Dave MacQueen" dmacqueen@msn.com
Subject: RE: Setup for Inter-Org Requisitions
Are you trying to assign the Internal location at that Customer header or
Site Level?
Date: Thu, 1 Jul 1999 15:24:44 +0930
From: "Irani, Kermiz" Kermiz.Irani@boral.com.au
Subject: RE: Setup for Inter-Org Requisitions
The location association is not customer type dependant (atleast in
10.7)....the message implies you might have assigned the location to another
customer site.
Rgds,
Kermiz.
Tax Code
Date: Tue, 6 Jul 1999 09:42:32 +0200
From: Craig Riffel CraigR@langeberg.co.za
Subject: AR Tax Code
Hi all,
We are on Oracle 10.7 NCA.
I am currently experiencing a problem regarding tax
in Receivables. If I want the tax code to default from the customer, I tick
the "Use tax code for Customer" tickbox on the system options Tax form. The
problem is that the field called tax code on the customer classification
form is greyed out. If the "Use tax code for Customer Site" tickbox is
enabled and the tax code is captured on the bill_to business purpose, it
does not seem to always work properly. Should both these be enabled on the
system options? If you have exempt items and zero rated customers, what
should the setup be? It seems that the customer overrides the item. This
means that if a customer is a "VAT" customer and the item is exempt, the
Customer will override the item tax code.
Help would be greatly appreciated.
Many Thanks
:-)
Craig Riffel
Date: Tue, 6 Jul 1999 03:55:14 -0700
From: "Victor Chang" vchang@obaps.com
Subject: Re: AR Tax Code
Hi Craig,
If Receivables needs to use a default taxcode for all invoices, the "Use
taxcoe for Customer" at system option level can be ticked on.
In some European countries taxes need to be calculated dependent on the
item. In this case one can tick on the "use Tax code for Product".
Sometimes the ship to location determines the levy of tax. In this case one
can tick on the "use taxcode for customer site".
The sequence in AR for tax calculation is as follows:
1. Use taxcode at customer site level (ship to)
2. Use taxcode at customer heaer level
3. Use taxcode at item level.
If a customer is exempt from taxation you can define an exempt taxcode and
attach that to the customer site level.
Hope this helps,
Victor Chang
O.P.E.N. Business Applications BV
Olympia 1A-1B
1213 NS Hilversum
Netherlands
tel: +31 35 646 2650
fax: +31 35 646 2725
mobile: +31 6 53 303 522
email: vchang@obaps.com
Date: Tue, 6 Jul 1999 15:28:17 +0200
From: Craig Riffel CraigR@langeberg.co.za
Subject: RE: AR Tax Code
Thanks for your reply Victor, but allow me to
specify a bit more detail.
Th company that has been set up has both zero vat
and vat customers with multiple sites.
We have set the system options "tax code for
customer" with a default tax type of "vat".
On the Customer Header Level the field "Tax Code" is
greyed out -- Why?
Does this imply that the tax codes must be
maintained at the Customer site level?
Many Thanks
:-)
Craig Riffel
Date: Tue, 6 Jul 1999 07:01:12 -0700
From: "Victor Chang" vchang@obaps.com
Subject: Re: AR Tax Code
Hello Craig,
Under VAT rules the ship to address determines what percentage VAT is
applicable on the invoice.
Oracle AR module is doing what it suppose to do according to the rules.
In other words customer site must have taxcode defined, if not the default
taxcode at systems option level will be used.
Please keep in mind that transaction types determine tax calculations.
Best regards,
Victor Chang
Date: Tue, 6 Jul 1999 16:26:14 +0200
From: Craig Riffel CraigR@langeberg.co.za
Subject: RE: AR Tax Code
Victor,
Much appreciated!
Many Thanks
:-)
Craig Riffel
Date: 6 Jul 99 09:55:47 CDT
From: CRAIG YEDINAK craig.yedinak@usa.net
Subject: RE: AR Tax Code
Nice to see another Craig on the list!
Tax Code cannot be set on the header if you are multi-org since the customer
is not org specific. The customer site is org specific and tax codes carry
accounting information. That is why they have to be set at the site level.
For sales taxes, taxes are computed for the Ship to site. If no Ship to site
is available, the Bill to site is used. I'm not certain if this is the same
for VAT, but that could be why the Bill to site tax code is not always
working.
Good Luck, Craig
Craig Yedinak
Independent Consultant
Date: Tue, 6 Jul 1999 17:02:57 +0200
From: Craig Riffel CraigR@langeberg.co.za
Subject: RE: AR Tax Code
Craig,
Yes, thanks.
I now understand!
Many Thanks
:-)
Craig Riffel
AR trf to GL of Foreign currency trx
Date: Mon, 12 Jul 1999 17:34:41 +0300
From: demet.hatipoglu@lafarge-turkey.lafarge.com
Subject: URGENT : AR transfer to GL
Hello,
We have a problem while transfering AR transactions to GL, not all the
transactions but only the transactions with foreign currency. We enter an
invoice in USD with the exchange rate=10, we enter a payment in USD with
the exchange rate=12, and we match the payment to the invoice; when we try
to transfer it to GL, the program finished with an error. If the exchange
rates are the same, no problem occurs while transfering from AR. You will
find below the error explanation.
APP-01947 FlexBuilder : Cannot compile FlexBuilder function
AR_SUBSTI_BALANCING_SEG : Application 222
Previous Messages (for Support Purposes)
APP-00606 Cannot read value for profile option GL_DUAL_CURRENCY
APP-01943 No assignments have been created for function
AR_SUBSTI_BALANCING_SEG
APP-01840 fdfsai: No rows found in table FND_FLEXBUILDER_ASSIGNMENTS
APP-00981 ORACLE error 1403 in fdfsai
APP-00406 No message explanation found for message '&MESSAGE'
There is no answer from Oracle Support, we still are waiting. Your quick
response is highly appreciated. Thanks...
Demet
Date: Tue, 13 Jul 1999 11:18:14 +0700
From: Argon Usman argon@newmail.net
Subject: Re: URGENT : AR transfer to GL
Demet,
I've met that error before. It has something to do with gain/loss
account.
If you are working in multi currency, AR will automatically generates
gain/loss account due to diffent exchange rate between invoice and
receipts.
Please check you GL Account Code combination, make the gain/loss account
code combination is exist for each of the balancing segment. It could be
only exist for one balancing segment, and you have to create for each of
the balancing segment manually.
Feel free to email me directly, to aiusman@jatis.com, should there be
any questions.
Argon
Date: Fri, 16 Jul 1999 14:24:03 +0300
From: demet.hatipoglu@lafarge-turkey.lafarge.com
Subject: Re: URGENT : AR transfer to GL
Yes you are right, it was because of the gain/loss account, and the main
reason of the problem is the flexbuilder. We define and compile the
flexbuilder, and we achieved to transfer from AR to GL.
Thanks again....
demet
Statement Customization
Date: Tue, 20 Jul 1999 16:44:56 -0500
From: Dan Olson dolson@dacotah.com
Subject: AR:Statements Customizations
Hi
We are on 10.7 - 16.1 SC.
I am attempting to modify the AR statement report. We need to have a
separate statement form for our retail statements versus our wholesale
statements. Since the actual statement generation (ARXSGP) is spawned
by a ARXSUPST, which I believe then calls the ARXSGPO.rdf to print the
statements. If we are going to have two statements, do we have to copy,
rename and modify the ARXSUPST twice?
I am sure some of you have gone through this before, any hints?
Any shortcuts for testing modifications?
Regards
Dan Olson
Date: Tue, 20 Jul 1999 16:22:00 -0700
From: Tina.Thousand@weac.com
Subject: Re:AR:Statements Customizations
One recommendation is to tie the customized requirements to the statement
cycle
through a DFF on the statement cycle definition. The statement cycle is
then a
required parameter during statement submission which can be used to specify
which version of the statement is to be used in that statement generation /
printing.
Tina Thousand
Ernst & Young, LLP
christina.thousand@ey.com
Deferred revenue recognition until payment
Date: Mon, 26 Jul 1999 14:36:08 -0400
From: "Keane, Chris" Chris.Keane@Dialogic.com
Subject: A/R - Deferred revenue recognition until payment
Our Accounts Receivable department would like to defer revenue recognition
on sales order shipments for selected customers until payment is received.
Is this possible using out of the box features ?
We currently use an accounting rule to distribute recognition over 12
periods for selected items, but this request is different.
Thank you,
Chris Keane
Dialogic Corp.
(973) 993-3000 x-6262
c.keane@dialogic.com
Date: Mon, 26 Jul 1999 11:47:31 -0700
From: Satish Reddy SReddy@zilog.com
Subject: RE: A/R - Deferred revenue recognition until payment
I did a report for my previous client some time back,which gives the
deferred revenue and they pass the
neccessary journal adjustments.frankly I do not know what is out of box
feature.
Thanks
Date: Tue, 27 Jul 1999 20:28:54 +0700
From: Argon Usman argon@newmail.net
Subject: Re: A/R - Deferred revenue recognition until payment
Chris,
I think what your accounts receivable dept. trying to do is mixing cash
basis with accrual basis accounting, because if you want to do such
thing, you can set up using Cash basis accounting.
If, you want to do it to some customers, it is violating the accrual
basis, which is of course is not a common business practice.
You can try to make the invoice incomplete, then print the incomplete
invoice report to find the invoice when the payment is made. Of course,
the user will not comfortable to the user.
Regards,
Argon
Having multiple Remit-to-addresses based on Province
Date: 29 Jul 1999 23:25:55 -0500
From: Betty Li beli@dttus.com
Subject: help!!! assign remit-to address(AR
Hi, all,
We are implementing 10.7 AR for a Canadian client. The client has two
remit-to address, one of them is dedicated for Quebec customers. Now
we need to assign the remit-to address to all the existing customers
so the default address is based on the bill-to location of that
customer. If the bill-to is Quebec, all transaction will automatically
have Quebec remit to address; for other customers, using the Toronto
address.
I have studied the remit-to address set up in AR. My impression is if
the "State" is defined, remit-to address can be assigned to particular
state/states. But state cannot be changed to Province. We have to
modify the form to have province validated.
Or using postcode. Unfortunately, Canadian post code is not numeric,
it's 6 digit, mixed with letter and number. And we don't know how to
rank this post code without having additional software.
Has anybody here encoutered similar problem and if you can shed the
light on this, that will be higly appreciated.
Betty
Date: Fri, 30 Jul 1999 10:18:20 CDT
From: "Prodipto Mitra" pamitra@hotmail.com
Subject: Re: help!!! assign remit-to address(AR
Hi Betty,
You could have all the customer addresses for the Toronto remit to address
have a special character for the state ( say a * or a - )
and similarly have a different special character for the state in the
addresses where the remit to should be Quebec.
Then you should be able to set up those characters as the "states" for
determining the correct remit to address
-Prodipto