Aged Trial Balance CR Amounts being shown as DR
Date: Mon, 22 Mar 1999 14:53:55 +0200
From: Mohammed Alshaarawi m_sharawy@tccbce.com
To: "'Oracle international group'" applsys@egroups.com,
Subject: aged trial balance-URGENT
hi all
i was asking about a bug in the ATB "aged trial balance' report, the
unapplied reciepts appears as a debit amount on the cusmoter account!!
although it should be credit to affect correctly on the cusmoer balance.
please its urgent
thanks
sameh
Date: Sat, 21 Aug 1999 21:29:02 -0700 (PDT)
From: FMT firas70@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Unapplied Receipts and aged trial balance reports
Hi Mr. Shaarawi,
Needs more details and Which module?
firas Al Tamimi
Invoice No. prefix - change
Date: Sun, 22 Aug 1999 21:04:29 PDT
From: "YOU HIN TAN" tanyouhin@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Q on Pay on Receipt Autoinvoice Program
Hi,
We are in 10.7 sc 161. Is anybody know how to change the prefix of
invoice number for Oracle Payables that auto generated from ERS.
(Evaluated Receipt Settlemet or Pay on Receipt Autoinvoice program)
Currently the invoice number is of the following format :-
'ERS'- X - Seq#
where:
- Seq# is a unique system generated number.
- X depends on the summary level:
- if summary level = Pay Site then X = Invoice Date
- if summary level = Packing Slip then X = Packing Slip
Number
- if summary level = Receipt then X = Receipt Number
Thanks,
YH
Customer site - deactivate thru customer i/face
Date: Mon, 23 Aug 1999 11:22:58 +0300
From: Siva Siva@nrec.com.kw
To: oraapps-l@cpa.qc.ca
Subject: Deactivating customer site through customers interface
Hi all,
Is it possible to de-activate a customer site(bill to or ship to) through
Customer Interface. I am trying to achieve this functionality by inserting
anew record in the ra_customers_interface_all with
orig_system_customer_ref,orig_system_address_ref,customer_status(I),insert_u
pdate_flag fields(U). But it is updating customer itself and making it
inactive.
Any help is greatly appreciated.
Nandakishore
Date: Mon, 23 Aug 1999 10:09:08 +0100
From: "Kaelin, Marcel" Marcel.Kaelin@che.xerox.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: AW: Deactivating customer site through customers interface
Hi Nandakishore
I've got the same problem. I'ts also impossible to inaktivate an
address
through the interface.
I've tried many times !
The only possibility I see, is an update within SQL direct on the
tables.
But who knows the consequences.
Greetings, Marcel
Receivable A/cs in one invoice - multiple
From: Nilanjan Choudhury npclists@yahoo.com
Reply-To: oraapps-l@cpa.qc.ca
Subject: Separate receivables account for Invoice Lines
Date: Wed, 25 Aug 1999 10:41:38 -0400 (EDT)
Hi,
Is it possible in Oracle Apps Version 11.0.2 to assign diferent
recievables account to the lines of an invoice( Salesrep being the same
for the invoice)?. Going through the autoaccounting set up documents it
seems we can have different accounts only for the revenue,freight and
tax accounts.
Regards
Prince
Date: Wed, 25 Aug 1999 14:58:40 -0400 (EDT)
From: Madhu Sudan Dada dada@csee.usf.edu
Subject: Re: Separate receivables account for Invoice Lines
No
Madhu Sudan Dada
Date: Wed, 25 Aug 1999 11:17:15 PDT
From: "Prasanna Kumar Jena" pk_jena@hotmail.com
Subject: Re: Separate receivables account for Invoice Lines
Hi
The Receivable Account has only two sources.
Transaction Type and
Salesperson
In one Invoice, Transaction Type will be the same. As the Salesrep is also
the same - I cann't see such a possibility. The use of Standard Lines as
sources in Revenue, Tax and Freight gives them the flexibility.
regards
Prasanna Jena
KAY Software Inc.
Silicon Valley
Date: Wed, 25 Aug 1999 12:09:38 -0700 (PDT)
From: =?iso-8859-1?q?Nilanjan=20Choudhury?= npclists@yahoo.com
Subject: Re: Separate receivables account for Invoice Lines
Hi ,
Thanks for the reply.Can we populate the ra_interface_distributions
table with multiple values for recievable code combination id and
achieve this?.
As far as I know there are no table level restrictions in doing so. Is
there any validations incorporated into
auto invoice import program preventing this?
Regards
Prince
Date: Wed, 25 Aug 1999 12:16:59 -0700
From: "Orth, Tom (torth)" torth@sequent.com
Subject: RE: Separate receivables account for Invoice Lines
Yes, this is possible. The sum of the amounts or percents of the
distribution lines must then equal the total for the individual invoice
line that they refer to.
Date: 26 Aug 99 06:59:46 CDT
From: CRAIG YEDINAK craig.yedinak@usa.net
Subject: RE: Separate receivables account for Invoice Lines
Hi Tom (and Prince),
This thread has been a little confusing. You can have multiple revenue
distributions that total "the individual invoice line that they refer to", but
you cannot have multiple receivable accounts for an invoice. As Alok said in
a separate posting, this is not possible with standard functionality. The
auto invoice program will not allow it, and even if it did get in the table,
the cash application, credit, adjustment processes, etc. would not handle it
correctly.
This is an enhancement request, and Oracle said they were trying to have it
ready for 11.5 (now 11i), but I wouldn't depend on it being ready AND working
anytime soon.
Hope this clears things up. Craig
Craig Yedinak
Independent Consultant
Customer maintenance from legacy system
Date: Thu, 26 Aug 1999 13:03:28 +0900
From: kameoka@mkb.fujikura.co.jp
To: "'OAUG_ML'" oraapps-l@cpa.qc.ca
Subject: AR: Customer maintenance from legacy system
Hi everybody!
We are on R10.7 SC 16.1, AP and AR, and we have legacy systems feeding to
the AP and AR. We maintain our legacy masters as the corporate master and we
try to update Oracle masters through Oracle Open Interface. AP has been live
for 5 months and AR is scheduled to go live in a month.
Our problem is that we get so many errors when try to update the Customer
master through the Open Interface, for example Customer Addresses. Our guys
are wondering if anybody out there is in similar situation, that is to have
the legacy master and to update Oracle master accordingly. If so, do you do
it through Oracle Open Interface or through your custom codes? We have
customized the master updating for Supplier because Oracle Open Interface
did not support updating Suppliers.
Any help or suggestions will be appreciated.
Tak KameokaInformation Systems, Fujikura Ltd.
tkameoka@fujikura.co.jp
kameoka@mkb.fujikura.co.jp
Phone: +81-3-5606-1243
Fax: +81-3-5635-2084
Autoinvoice - Determining Dates
Date: 26 Aug 99 08:19:30 PDT
From: Roger Drolet rdrolet@netscape.net
Subject: Determining Dates and AutoInvoice
Our client wants to use the promise date entered in Order Entry as the
transaction date (i.e., the invoice date). Does anyone know how we can
accomplish this? Also, the ship date and the promise date may not be the
same.
Thank you.
Roger
Consolidated Billing
Date: Thu, 26 Aug 1999 10:53:04 -0500
From: Cheryl_Moore@huntsman.com
Subject: AR - Consolidate Billing
Hello All-
Has anyone worked with consolidated billing? We need to generate 1 invoice a
month for a few select customers that receive multiple shipments throughout
the month. We use OPM\GEMMS for order entry and the Autoinvoice process to
generate invoices. Currently we enter these type of orders as a stock transfer with a
0 price which does not generate an invoice and then at the end of the month we
enter a consolidated sales order which generates a consolidate invoice.
Any help or ideas would be greatly appreciated.
Thanks
Cheryl Moore
Ph: 713-235-6193
pgr: 800-391-6124
e-mail cheryl_moore@huntsman.com
Date: Sun, 29 Aug 1999 12:32:45 GMT
From: "Sunny Sunny" sunn999@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AR - Consolidate Billing
Hi,
First if you have one Consolidated Sales order in OE you will get one
invoice in Ar for which you do not need Consolidated Billing.
Consolidated Billing works on the Proxima Payment Terms Concept wherin you
have to define a payment term with a cut off day.Then you have to assign
this Payment Term to the Customer Bill to site. Remember to enable
Consolidated Billing in the Profile Class of this Customer.
When you are entering an Invoice in AR this Payment term will default on the
invoice.
Consolidated Billing does not use this Payment Term.
Next is run the Consolidated Billing program.In the parameters of this
program specify the same cut off day and payment term which is associated to
the bill to site of that customer and run the program for the same customer.
This gives you a report which will be a consolidated bill of all the
Customer invoices which were associated with this Payment Term raised before
the Cut off day.
The next time you run this program for the next month it carries forward the
old balance due and gives you the net balance after deducting payments.
Regards,
Sunil Wahi.
From: Cheryl_Moore@huntsman.com
To: "Sunny Sunny" sunn999@hotmail.com
Subject: Re[2]: AR - Consolidate Billing
Date: Mon, 30 Aug 1999 15:10:08 -0500
Thanks for the info -
We use OPM\GEMMS for OE and as orders are shipped an invoice is generated
via an
AR Update program and the AutoInvoice process in Receivables so our current
process is as many invoices are generated as items are shipped
BUT
I'm curious about your other suggestion - it sounds like a monthly
statement?
The next time you run this program for the next month it carries forward
the
old balance due and gives you the net balance after deducting payments.
How do you run the consolidated billing program - is this info in any of
the AR
reference manuals?
Cheryl Moore
Ph: 713-235-6193
pgr: 800-391-6124
e-mail cheryl_moore@huntsman.com
Date: Tue, 31 Aug 1999 13:37:51 GMT
From: "Sunny Sunny" sunn999@hotmail.com
To: Cheryl_Moore@huntsman.com
Cc: oraapps-l@cpa.qc.ca
Subject: Re: Re[2]: AR - Consolidate Billing
Hi Cheryl,
You are right, Consolidated billing is like statements but it's a different
concept all together.
I have mailed you the set up steps in my earlier mail.More is available in
the AR reference manuals.
There is a separate program if you access the print documents/Consolidated
billing which generates this report.
This actually is not another invoice,it 's only a report which is an invoice
format that can be sent to the customer.
There is one profil;e option called AR Use Billing number which you have to
enable, to use a separate number generated by this program.This number will
then be on every Invoice which shall be printed on this report.
We are going to use this concept for multiple invoices generated from
Projects of the same customer.
If you need any thing else on this topic get back to me.
Regards,
Sunil Wahi,
Autoinvoice - AFLOG_MODULE profile option
Date: Thu, 26 Aug 1999 19:46:41 -0700 (PDT)
From: Harikrishna Babu geethari99@yahoo.com
Subject: AR: AutoInvoice
Hi Experts,
Can anyone out there help me find out the solution for this problem.
We are now perparing scripts for the AR Import through AutoInvoice
Feature.
It fails and come out with the following error:
"Cannot read the value for the profile option AFLOG_MODULE"
I'm unable to trace this profile.
Can anybody guide me to find out this profile option.
Thanks
Date: Thu, 26 Aug 1999 21:00:18 -0700
From: McRaney Ronald-MCG32315 rmcraney@itexchsrv2.phx.mcd.mot.com
Subject: RE: AutoInvoice
Patch BUG:753872 eliminates the "Profile not found" messages for the
AFLOG_...
profiles.
Date: Fri, 27 Aug 1999 13:32:42 +0700
From: Argon Usman argon@newmail.net
Subject: Re :AR: AutoInvoice
Try to populate the System Profile Values OE: Item Validation
Organization
in the System Administrator Responsibility?
--
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
Aged TB Report - Second Report with same As Of date
Date: Fri, 27 Aug 1999 13:53:00 -0500
From: Heyman_Howard Heyman_Howard@videojet.com
Subject: AR: Aged Trial Balance Report
All -
Hopefully an easy one. If the Aged Trial Balance Report is run a
second time but using the same criteria, especially the as of date,
will the results be the same or different? A user is complaining that
the results have changed and my gut reaction is that they SHOULD
change (from entering adjustments to invoices, etc.), but I can't find
any documentation to support my feelings. (She runs the report on day
X and then re-runs the same report with the same as of date a week
later. Her issue is reconcilliation back to the GL.)
Can anyone confirm my suspicion and give me examples of the
transactions that may cause a change in the balance?
Thanks
Howard Heyman
Process Leader
Videojet Systems International
Date: Fri, 27 Aug 1999 15:11:11 -0400
From: "McShane, Chris" Chris.McShane@glenayre.com
Subject: RE: Aged Trial Balance Report
If she is using the same as of date she should be getting back the same
information unless someone has gone back and re-opened the period to enter
more transactions
Date: Sun, 29 Aug 1999 13:00:45 +1000
From: "Mckenzie, Rosemary" ROSEMARY.MCKENZIE@cai.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Aged Trial Balance Report
That's what we thought too. But it didn't always happen. We ended up
running all our reconciliation reports for the EOM on the first working day
of each month and nothing was entered in the new period until all the
reports were reconciled. (This was not a huge organization and we also had a
few custom reports that had to be run for reconciliation.)
Apart from reloading the output reports into a temp table and comparing the
results (which I have done! - for a totally different reason) there's no way
of telling what transactions are the difference between the two reports. My
gut reaction, as to the cause, is the same, with adjustments, some type of
payments, reversal of payments, or something like that, but I've not
investigated it.
Date: Sat, 28 Aug 1999 05:47:16 -0700 (PDT)
From: Murali Avanamuthu mavanamuthu@yahoo.com
Cc: Chris.McShane@glenayre.com, Heyman_Howard@videojet.com
Subject: Re: AR: Aged Trial Balance Report
Hi,
AR Aged Trial Balance Report is a point-in-time
report. So you might see different results even
though you use the same as-of-date. The logic is such
that it looks for 'Open' items and then calculates the
balance. If you run as of today, the balance is what
is stored in the payment schedules. If you run for a
prior-date, then the report reads the applications
against the transaction and backs them out, to arrive
at the balance as of the date, you want.
Let's say you run this report as of 01-Aug-99 and
you've a invoice I1 with $100 balance and I2 with $200
balance. During the first week of August, let's say
there's a partial payment of $50 applied to I1, which
brings the balance to $50. Also I2 is paid off fully.
So if you run the report on 10th August, but with
'01-Aug-99' as your date, the report will pick up $100
for I1. But guess what, I2 will not appear in the
output at all!!. Because the report only looks for
'Open' items.
In this sense, AR is very different from GL.
Coming to the actual requirement of your user:
Reconciling AR to GL. The Aged Trial Balance is not
the best tool to do this. For GL reconciliation, what
you really need what are the activities for a period ,
rather than what your customers owe you. So, please
instruct her to consider a combination of 'Sales
Journal by GL account', 'Receipts Register' and/or
'Adjustments Register' 'Miscellaneous Receipts
Register' etc. I believe there's a chapter in AR
Users guide about reconciliation to GL. Also I
vaguely remember browsing through some good articles
in past OAUG conferences on this topic.
Good luck,
Murali
Date: Sun, 29 Aug 1999 08:27:45 -0700
From: DOROTHY MAGUIRE dpmaguir@us.oracle.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Aged Trial Balance Report
We also ran into this mystery. The parameters were exact.
In our findings, the only time there were differences was when "clean-up"
was done "behind the scenes" to either the subleder or the GL in the tables,
or just the subleder and not the GL or vice versa. It was human error each
time, not Oracle. You may want to ask the technical team if something
was done that you weren't aware of.
Hope this helps.
Date: Mon, 30 Aug 1999 09:52:39 +1000
From: "Bevin Watson" bevin.watson@abs.gov.au
To: oraapps-l@cpa.qc.ca
Subject: Re: AR: Aged Trial Balance Report
Sadly, the answer will change every time you run the aged trial balance
report.
The report (at least in 9.3 through 10.7, I dunno about 11x) looks at the
CURRENT outstanding amounts from ar_payment_schedules. Therefore if any
applications have been done the aged trial balance will change.
I think it is theoretically possible to create an aged trial balance that
recreates a point in time, but I wouldn't like to do it myself and it would
probably take a week to run. The simplest answer is to make sure your AR
people
routinely run and save one at the end of each period.
Bevin Watson
Financial Systems Administrator
Australian Bureau of Statistics
Date: Mon, 30 Aug 1999 09:18:34 -0400
From: "McShane, Chris" Chris.McShane@glenayre.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Aged Trial Balance Report
We originally had a problem with these totals not matching. My AR department
said this was unacceptable. I logged a tar with Oracle and they supplied a
patch with updated reports. Now, when we use an 'As of Date' we always get
the same amount regardless of when the report is run.
Due to the response I got to my posting, I went and verified this fact this
morning. I grabbed a report dated '01-FEB-1999' and was run as of
'31-JAN-1999'. I ran the AGED TRIAL BALANCE - $ BUCKET and the AGED TRIAL
BALANCE - BY ACCOUNT. Both were exactly the same totals (taking into account
the differences between 7 and 4 buckets) as my report from 01-FEB-1999.
Date: Mon, 30 Aug 1999 09:46:32 -0400
From: "Marni Baggett" mbaggett@brk.photronics.com
To: oraapps-l@cpa.qc.ca
Subject: AR: Aged Trial Balance Report
I do not agree. We implemented Oracle AR on 10.7 & have since upgraded to
11.02. In
both versions, once you have finished closing an accounting period, your
ending ATB
doesn't change-----UNLESS, of course, if someone 'reopens' the period &
proceeds to
enter trans/receipts/adjs/etc. in that period. If July 31, 99, is your
month-end and
invoices that are outstanding/open at that point are subsequently paid by
customers in
August 99, they will still appear on your EOM ATB @ 7/31/99...........
Marni Baggett
Photronics, Inc.
Date: Mon, 30 Aug 1999 13:36:01 -0500
From: "Puchniak, Stan" Stan_Puchniak@standardaero.ca
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Cc: "'mbaggett@brk.photronics.com'" mbaggett@brk.photronics.com
Subject: RE:AR: Aged Trial Balance Report
Hi Marni,
We are currently on 10.7 and experience the same issue that you do not agree
with. Is there something in your setup that allows this to work for you? I
would be very interested in knowing what it is. If you reverse, or re-apply
a receipt in the following period and run the ATB for July 31, 1999, it will
provide the same information as the original ATB? We find that the issue is
usually linked to reversing and re-applying receipts. We are very diligent
in closing AR immediately after the fiscal period has ended.
When you state that you have finished closing an accounting period, is this
just AR; or, does it include GL?
Your assistance is greatly appreciated,
Stan
Unable to make Remittances
Date: Mon, 31 Aug 1998 13:29:24 +0300
From: aragab a_ragab@tccbce.com
To: oraapps-l@cpa.qc.ca
Subject: TOP_URGENT_TO_AR_EXPERTS
Hi all
When we try to make remittances we got no data found , but when we print
the receipt awaiting remittance we got some receipt the GL & MATURITY
date is correct how can i do?????
Best regards / A.ragab
Receipt- apply across Org
Date: Tue, 31 Aug 1999 13:55:09 EDT
From: "Ragu N" oapps@hotmail.com
To: OraApps-L@cpa.qc.ca
Subject: Applying Receipt in a Multi-Org environment
Hai All,
Can we apply a single receipt(check) to invoices arcoss Org,
through Auto-Lockbox process.
As far as i know the answer is No
Have anyone tested this condition?
Thx. in Adv.
Ragu
Date: Wed, 1 Sep 1999 08:08:23 -0400
From: "Mitesh Patel" miteshp@mastech.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Applying Receipt in a Multi-Org environment
Ragu,
You are absolutely correct. It is not possible to apply receipt to invoices
across Orgs.
Cheers,
Mitesh Patel
Conversion of Receipt applied against closed invoices
Date: Tue, 31 Aug 1999 11:23:38 -0700
From: "Orth, Tom (torth)" torth@sequent.com
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: AR: Cash Receipt Conversion
Hello AR experts, Gurus, and Jedi Knights.
When doing this AR conversion to Rel 11 multi-org, I am
taking this strategy:
1) Import only open invoices
2) Import Credit memos against open invoices
3) Import cash receipts applied against open invoices
4) Make adjustments to open invoices
This is all fine except in step 3), cash receipts are applied
against invoices that are CLOSED, but I don't want to
migrate those closed invoices. Then I have to bring their
CMs, cash receipts, and adjustments....then their cash
receipts will apply to yet more closed invoices etc.
So, how do I deal with the unapplied amounts that I get
when bringing in receipts that have amounts applied against
closed invoices that I don't want to convert?
Date: Tue, 31 Aug 1999 12:57:08 -0700 (PDT)
From: Murali Avanamuthu mavanamuthu@yahoo.com
To: oraapps-l@cpa.qc.ca
Cc: torth@sequent.com
Subject: Re: AR: Cash Receipt Conversion
Hi,
I just completed a similar exercise, but in my case,
it was from 9.4.2 to 11.
There are some operating units within our company, who
took the decision (wise) of bringing over open
invoices, credits and receipts with the amount due.
Whereas the operating units I'm helping with wanted to
bring open invoices, credits and receipts, but with
original amount. Poor me!. So this is what I did. I
wrote a PL/SQL program to extract from 9.4.2 - which
picks up only open items first. Then it goes within a
recursive loop, to read applied transactions against
these open items. The recursion I've noted has even
gone 7 levels deep.
Anyway once all the open and their applied
transactions are available, I write invoices and
credits into the format required by Autoinvoice. For
receipts, I used Lockbox's maximum capability of
having 8 invoices against each receipt. So there's
more logic to group upto 8 invoices for a receipt.
And if there's more than 8 invoices, the programs
prints an output with the application information.
Using this output, we would manually apply those
invoices to the receipts.
Also the program also prints out all credit memo
applications (Autoinvoice can only handle one
application per credit memo). So we decided to bring
all credit memos as on-account. Using this output, we
manually applied invoices to the credit memos.
Anyway, to conclude: You should consider option 1 -
bring open items with amount-due. OR do this
recursion.
Hope this helps,
Murali
Date: Tue, 31 Aug 1999 13:23:40 -0700
From: "Orth, Tom (torth)" torth@sequent.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: AR: Cash Receipt Conversion
This is great information. Thanks Murali.
Salesperson at customer level to default to invoice
Date: Tue, 31 Aug 1999 15:56:02 -0400
From: ddicondina@SUNGARDRS.COM
To: oraapps-l@cpa.qc.ca
Subject: AR: 10.7 NCA Invoicing
Hello All,
While Entering an invoice in 10.7 Character and selecting the bill-to
customer, the salesperson which was setup at the customer level
is automatically populated. While testing invoicing in 10.7 NCA, a LOV
appears with all of the salesreps rather than the one associated
with customer. How do I get this field, at the invoice header level to
default to the salesperson which was setup at the customer level?
Thanks,
Dominic DiCondina
Sungard Recovery Services, Inc.
Autoinvoice - Tax code problem
Date: Tue, 31 Aug 1999 13:43:31 -0700 (PDT)
From: subba sista subbusista@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: help on Auto invoice
Hi all,
I am getting a problem with auto invoice and i just want to know how to
approch the my problem
i have written and pl/sql procedure for importing all the open ar
invoices and i am getting an error_message like
Errors: 1) Unable to find a tax code for the transaction.
Ensure that you have defined an active Tax Code for
either the Customer Site, Customer or Inventory item and that
Oracle Receivables System Option enables the usage of a
tax code at that level.
2) Unable to find a tax code for this transaction
CAUSE: A default Tax Code was not found for this
transaction.
what i have done is i have changed the set of transaction type where
the tax calculation was on
and set it to no and after that my pl/sql worked and all the records
were processed.
i just want the suggestion,can u help me out
thanks
Subba Rao Sista
Date: Tue, 31 Aug 1999 14:12:35 -0700
From: "Orth, Tom (torth)" torth@sequent.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: help on Auto invoice
Check to see if this transaction is a tax only transaction without
a tax specific line.
Date: Tue, 31 Aug 1999 14:17:11 -0700 (PDT)
From: "MURTHY ADURI UDAY B." adurimurthy@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: help on Auto invoice
Hi,
1.Auto Invoice gives the option of calculating the tax automatically
using the set up in Apps or pass the tax lines in
RA_INTERFACE_LINES_ALL.
2.If the tax calculation flag is set in the transaction type then tax
is calculated based on the values for the tax set up for the different
segments of the location flexfield.
3.This way only the gross amount of the invoice is passed into the
interface table and based on the rates set up in apps the tax is
calculated.
4.You can choose to have sales tax or vat tax (predefined) taxes or
make a custom tax code and define the location flexfield stucture
accordingly.
5.This tax code can be defaulted at the customer level which will be
used whenever the customer is picked for the invoice.
Hope this is gives you some clue,
Good luck,
Murthy.
Autoinvoice and Child Processes
Date: Tue, 31 Aug 1999 15:01:22 -0700
From: "Francis Chang" fchang@mvsn.com
To: Oracle Apps List Server OraApps-L@cpa.qc.ca
Subject: AR: AutoInvoice Child Processes
Hello All,
How does AutoInvoice determine how many child process (instances) to
spawn? When I submit the master program, I specified 8 instances,
however, the number of child instances that are spawn are inconsistent
and is less than 8.
We have a specizlied concurrent manager just for AutoInvoice and it has
10 processes running.
I would appreciate it if someone can shed some light on this issue.
Francis
Date: Tue, 31 Aug 1999 18:16:45 -0400 (EDT)
From: Madhu Sudan Dada dada@csee.usf.edu
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: Re: AR: AutoInvoice Child Processes
Call support, I have written a paper on this with the help of
Autoinvoice Developer. 8 is your upper bound and it uses one
sql to group those like invoices and create the instances.
Madhu Sudan Dada