Autoinvoice generates Invoice with Sysdate as GL Date instead of Order Date
Date: Sat, 23 Oct 1999 17:23:07 -0700 (PDT)
From: rajendra nagaraju rnagaraju@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: OE to AR..Urgent
All,
We are using custom modules interfacing with Order
entry.
We run Order Import, then use the Recievables
Interface and finally use AutoInvoice to create
invoices.
Our problem is the invoices are created with the GL
Date being SYSDATE and not the Order Date.
Is there a way in either
1.The way we populate Order Entry interface tables
2.In Order Entry setup
3.In AR setup
..to set this right..
Regards,
Raj
Date: Sun, 24 Oct 1999 12:12:21 +0200
From: "James Pearson" pearsonj1@magic.fr
To: oraapps-l@cpa.qc.ca
Subject: Re: OE to AR..Urgent
I hope the following info will be of some interest...
We just recently moved to v10.7 (from v9.4) and we had a similar problem.
The problem being that the version 10.7 of GL can't manage (without some
modification) more than one ACCOUNTING_DATE when importing movements
from gl_interface. As a result the dates of the different movements are
lost.
I wrote the following procedure to solve this after taking to Oracle. Hope
it
helps.
Please click here for the procedure
James Pearson
Courriel: pearsonj@magic.fr
Date: Mon, 25 Oct 1999 08:16:25 +0530
From: "Narayana Bhatta P." Narayana_BP@inf.com
To: oraapps-l@cpa.qc.ca
Subject: RE: OE to AR..Urgent
Hello Rajendra,
Let me outline the way AutoInvoice gets the GL Date for the invoice.
1. In the AutoInvoice Interface table (RA_INTERFACE_LINES), there is a
column for GL_DATE, AutoInvoice picks this up, if it is populated.
2. Otherwise, you need to check the Derive Date option in the Invoice Batch
Source setup. (\ Navigate Setup Invoice Source). This information is in
the last zone.(AutoInvoice Data Validation - Accounting Information).
If this option is set to No, then the date given in the AutoInvoice
launch form is used (this is defaulted to the sysdate).
If this option is set to Yes, then the Ship Date Actual is used, if
it exists; else, the sales order date is used, if it exists; else, the date
given in the AutoInvoice launch form is used.
So, please check your invoice source setup.
In case, you are using Invoicing Rule, then the Earliest Invoicing Rule
Start Date, as the GL Date, instead of point 1 above.
Of course, if you are populating the OE interface tables in such a way that
the SYSDATE in going into the Ship Date Actual or / and Sales Order Date,
then you will have to look into your custom interfaces, to set this right.
I hope this helps. You can always refer to the Open Interfaces Manual.
Rgds,
Narayana Bhatta
Infosys Technologies Ltd., BANGALORE.
Ph. +91-80-852-0261 extn. 7008
Purge interface tables
From: Ajay Alur ajayall@yahoo.com
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Sent: Saturday, October 23, 1999 1:54 AM
Subject: AR Autoinvoice problem - batch + purge
Hi,
I have 2 questions related to AR AutoInvoice program.
I am importing invoices. Rel 11.03
1. Even If the Autoinvoice program has failed a batch
gets created with no entries in it ?
Is this because of a profile option ?
2. If Autoinvoice has successfully imported then all
the records are still sitting in the table.
Where is the purging option set for the interface
tables ?
TIA
A
Date: Mon, 25 Oct 1999 10:32:21 +0530
From: "PARAMESWARAN SUBRAMANIAM" params@wipsys.soft.net
To: oraapps-l@cpa.qc.ca
Subject: Re: AR Autoinvoice problem - batch + purge
hi
Use the AutoInvoice Purge Program. If you want AutoInvoice to automatically
delete the data, check the Purge Interface Tables check box in the System
Options window. You can also choose to run the AutoInvoice Purge program at
any time from the Run AutoInvoice window. The AutoInvoice Purge program
only deletes data that has been validated and transferred into Receivables.
hope this helps
Parmesh
Date: Tue, 02 Nov 1999 15:27:00 -0500
From: kewishls@mindspring.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AR Autoinvoice problem - batch + purge
To answer your second question - theres is a check box called 'Purge
interface tables' in the AR System options which you need to set fro the
successful rows to be deleted after processing into AR.
Louise Kewish
Senior Principal - Manufacturing and Distribution
TSC,
Dallas, TX
Lockbox - APP-43262 error
Date: Mon, 25 Oct 1999 08:59:49 -0400
From: "Shetler, Cindy" CShetler@atinc.com
To: "Oracle Applications List Server (E-mail)" oraapps-l@cpa.qc.ca
Subject: AR - Lockbox APP-43262 error
Getting APP-43262 Customer identified by Customer Number error when running
Lockbox. Has anyone gotten that error and know what it means? It's not in
the error message documentation. In fact when I look at the validation
report,
it doesn't put an error number next to that message, but it doesn't transfer
any
records with that message. The customer is a valid customer and there are
no
other error message on these records. Any suggestions?
Thanks,
Cindy Shetler
Date: Mon, 25 Oct 1999 09:26:25 -0400
From: "Subramani Thulasiram" subramani.thulasiram@acnenergy.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AR - Lockbox APP-43262 error
Have you given the billing location for the customer ?
Date: Mon, 25 Oct 1999 10:22:20 -0400
From: "KPMG - Chadda, Alok" CHADA@naa.org
To: "'CShetler@atinc.com'" CShetler@atinc.com
Cc: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE:AR - Lockbox APP-43262 error
Cindy-
Are you passing customer number? Make sure there is no space or extra
character with the customer number field. Also check the log file to make
sure there is no other error.
HTH
Alok
Finance Charges not being calculated
From: Orlandi, Warren [mailto:Warren.Orlandi@apra.gov.au]
Sent: Monday, October 25, 1999 5:46 PM
To: Multiple recipients of list
Subject: DUNNING IN 10SC
I have just set dunning up for the first time in Financials (16.1 SC). I
have set finance charges to calculate, and completed a print run, however I
can't see the finance charges appearing against the customer account
details, nor do they appear in the GL. I assume that I need to run
Autoinvoice, however after doing this there was no change. I have probably
left something basic out.....any suggestions??
Regards,
Warren Orlandi
Financial Systems Manager
Australian Prudential Regulation Authority
Date: Tue, 26 Oct 1999 08:08:14 -0700
From: June Siewert - ECS junesiewert@trm.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: DUNNING IN 10SC
Do you have a receivable activity setup for finance charges and do you have
sequential numbering setup for that finance charges receivable activity?
Date: Tue, 26 Oct 1999 14:26:31 EDT
From: "Satya Velagapudi" snvelaga@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: DUNNING IN 10SC
Warren,
Is the 'Charge Interest' option checked for the Customer Profile Class, to
which this customer belongs?
Is the Customer balance Past Due? Finance Charges are calculated only for
past due balances.
HTH,
Satya
Date: Wed, 27 Oct 1999 09:57:15 +1000
From: "Orlandi, Warren" Warren.Orlandi@apra.gov.au
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: DUNNING IN 10SC
YES AND YES.
Date: 27 Oct 99 08:22:25 CDT
From: CRAIG YEDINAK craig.yedinak@usa.net
To: "oraapps-l@cpa.qc.ca" oraapps-l@cpa.qc.ca
Subject: RE: DUNNING IN 10SC
Is the "Accrue Interest" flag checked in System Options?
Craig Yedinak
Consultant
Bank Charges - cannot enter
Date: Tue, 26 Oct 1999 21:49:29 NZDT
From: "Martin Bryant" marty_bryant@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: AR: Bank Charges
Hello,
I wish to be able to enter bank charges at the time of entering a cash
receipt in AR. There is a field called 'Bank Charges' in the receipt
header screen but it is greyed out and unable to be modified or added
to. I have the profile option 'AR: Create Bank Charges' set to yes, but am
still unable to enter directly into the bank charges field.
1. What is the purpose of this field?
Further more, I want to enter bank charges in NZD currency and the payment
comes in in USD.
2. Do I need to enter adjustments against my receipts to achieve this or is
there some other way to do it?
Martin.
Date: Wed, 27 Oct 1999 23:07:20 -0700 (PDT)
From: rams balasub rames_b_99@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AR: Bank Charges
Dear Martin,
In the receipt screen the bank charges can be entered
only when :
In the setup-Receipt class, the remittance method
should be no remittance, and the clearance method
should be direct, define a payment method for this
receipt class, attach this payment method when you are
creating receipt, you would find the bank charges
field is enabled for you enter value.
alternatively for a check payment, in the receipt
class setup the remittance method as standard or
factoring and the clearance method can be matching or
other. In this case the bank charges can be entered
only in the remittance screen after you create a
remittance batch for this receipt, and query the batch
again and go inside the receipt, in the receipt screen
in the alternative region you can enter the bank
charges.
Let me know for clarifications
bye
B.Ramesh
Ageing Report - By Account- Problem due to Patchset AR-S
From: McRaney Ronald-MCG32315
[mailto:rmcraney@itexchsrv2.phx.mcd.mot.com]
Sent: Friday, October 29, 1999 8:40 AM
To: Multiple recipients of list
Subject: AR: Patchset AR-S problem with Aging Report ARXAGM
Has anyone else noticed problems with 'By Account' Aging report (ARXAGM) as
a result of Patchset 'S'. Appears to be problem with 10.7 only ??
Any help appreciated.
Ron
Date: Fri, 29 Oct 1999 14:25:48 -0700
From: McRaney Ronald-MCG32315 rmcraney@itexchsrv2.phx.mcd.mot.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Patchset AR-S problem with Aging Report ARXAGM
Found it.. Just in case you might run across it. In Patchset 'S' for AR
there is a little script called b820348.sql, at the section call 'Insert New
Parameters' on the select statement for the Value Set AR_SRS_AGING_TYPE the
Select statement contains a CR which 10.7 did not like and inserted a
garbage character. Resulting in always using the default 'ARXAGS' report,
instead of the select 'ARXAGF' by account report.
This script is located in Patchset 'S' 872699/ar/patchsc/107/sql directory.
Weekend !!!!
AR to GL transfer automation
--- Debashish Bhattacharjee dkbhatta@hotmail.com
wrote:
Hello everybody
If someone out there has been able to run ar to gl
transfer using a
scheduler and can provide me with that information
I'll highly appreciate
that.
the requirement is the client should be able to
schedule this jobs at night
when tje system is idle and hence wants to be able
to schedule it.
any help
thanks and regds
DEbashish
Date: Sat, 30 Oct 1999 13:05:09 -0700 (PDT)
From: Liyakath Ali liyakath777@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AR to GL transfer Automation
Hi,
I did schedule the AR to GL Posting interface, it
runs every night with Auto Invoice.
This interface calls ARGLTP concurrent program.
I wrote a custom code to invoke this program and
register custome code as concurrent program and
sheduled this program.
If hope this helps you.
Regards.
Liyakath
Date: Sun, 31 Oct 1999 15:02:09 -0800
From: "Mohan Iyer" miyer@fortuna.com
To: oraapps-l@cpa.qc.ca
Subject: RE: AR to GL transfer Automation
Could you let me have the setup of the concurrent program that you have
registered to do this and schedule it.
I would appreciate this as we have been trying to get this done and have had
no luck as yet.
I beleive it is not supported option as far as Oracle Support is concerned ,
that is what the reply I got back from Oracle when I asked them.
You could email me directly at this email address miyer@fortuna.com
Thanks,
Mohan Iyer
Financials Consultant
Sunnyvale, CA
Date: Wed, 3 Nov 1999 10:56:38 -0800 (PST)
From: Liyakath Ali liyakath777@yahoo.com
To: oraapps-l@cpa.qc.ca
Cc: liyakath777@yahoo.com
Subject: RE: AR to GL transfer Automation CODE
All,
Here is the code. This not supported by oracle.
This program takes GL date as a paramerter, if the
parameter is null then it will take current date.
This won't kick Journal Import ( set to 'N').
If you any questions or comments please let me
know.
Regards
Liyakath
For the script please click here
Date: Wed, 3 Nov 1999 19:47:33 -0500
From: "Vijay Kumar Addanki" vijaykumar@email.msn.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AR to GL transfer Automation
Hello,
There is a great tool for scheduling AppWorx.
Which works with in tandem with Oracle Applications.
Thanks
Vijay
From: "Samir Rane" ranesami@pcsbom.patni.com
To: oraapps-l@cpa.qc.ca
Subject: AR to GL transfer Automation
Hello Debashish,
You can used Scheduling tool called "AppWorx" for scheduling concurrent
programs of Oracle Applications.
You can also write Unix scripts , PL/SQL programs and build them into
"Modules". Modules can be combined to form a "Chain". You can also set
dependencies,abort conditions on chains/modules. You can get notified by
e-mail or pager.
Thanks.
Regards,
Samir Rane
ranesami@pcsbom.patni.com
Patni Computer Systems Ltd.
Seepz Mumbai 400 096
Cross Currency Transactions
From: rams balasub [SMTP:rames_b_99@yahoo.com]
Sent: Mon 01 November 1999 9:06
To: Multiple recipients of list
Subject: Cross currency-AR
Dear all,
I created invoice in USD-functional currency,
received
and issued a receipt in GBP, while doing a
mass
transaction if there is no exchange loss, the
enteries
are smoothly transfered to GL. If suppose
there is
exchange loss of USD 5, when it gets
transferred
to
GL, in the journal entry line it shows error
EC12
-
"The entered amount must equal the accounted
amount in
a functional or stat currency journal line"?
can some one explain what this error means?
How do
we
rectify this.
thanks in advance
bye
B.Ramesh
--- Suzie Roth suzie_roth@stcl.scitex.com wrote:
Hi,
We had the same problem in Rel. 11.01.
It was fixed after upgrade to 11.03.
The reason is that the entered amount for the
cross
currency journal is 0
but the accounted amount equals to the exchange
difference that was created.
Since the currency for this journal is the
functional one, this error is
been erased.
You can fix it by using the "Correct Journal
Import
Data" form in the GL.
Set the entered amount to equals the accounted
amount then import the
journal
again.
I'm not sure if there is a patch for this
problem
but there are bugs/tars
that were opened.
Hope it helped.
-- Suzie Roth
MIS (Ext. 7151)
From: rams balasub [SMTP:rames_b_99@yahoo.com]
Sent: Mon 01 November 1999 10:38
To: Multiple recipients of list
Subject: RE: Cross currency-AR
Dear Suzie,
Thanks very much for your valuable suggestion, it
is
working perfectly fine now, is this process of
correcting import journals has to be done every
time
we do a cross currency, is there any patch
available
for correcting this bug.
Thanks
B.Ramesh
--- Suzie Roth suzie_roth@stcl.scitex.com wrote:
Hi,
We did the process of correcting the data every
time.
We didn't get a patch for it (since we had a
workaround,
the priority of the bug was never high enough to get
a
solution from Oracle) and after a while we upgrade
to 11.03
and the problem was solved.
You can still contact Oracle support and ask about
it.
Maybe a patch was released afterwards.
Regards,
-- Suzie Roth
MIS (Ext. 7151)
From: rams balasub [SMTP:rames_b_99@yahoo.com]
Sent: Mon 01 November 1999 12:52
To: Multiple recipients of list
Subject: RE: Cross currency-AR
Dear Suzie,
The problem is in 11.0.3 version, I am working only on
this version only, which have this problem. How is ok
at your end without a patch.
Thanks
B.Ramesh
Date: Mon, 1 Nov 1999 16:40:04 +0200
From: Suzie Roth suzie_roth@stcl.scitex.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Cross currency-AR
Hi,
I rechecked it and we did have the problem in 11.03.
Patch number 794157 solved it.
-- Suzie Roth
MIS (Ext. 7151)
From: satyam@sri.lanka.net
Reply-To: oraapps-l@cpa.qc.ca
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: Re: Cross currency-AR
Date: Mon, 1 Nov 1999 04:51:34 -0500 (EST)
Hi Ramesh
We have recently faced this problem.
For Cross Currency u need to define a Suspense Account in GL with Category
as 'Cross Currency' and Source as 'Receivables'.(\Nav Setup Accounts
Suspense)
Try to simulate the process again.
If still it is not working. Then there is patch for it. We got a patch for
the same,which was working fine for receivables posting to GL of cross
currency entries, but reconciliation entries from cash management were not
pushed to GL.
We are expecting the second patch set.
I hope this will help
Hema
Satyam Enterprise Solutions Ltd.
Date: Wed, 03 Nov 1999 12:30:45 GMT
From: "Sunny Sunny" sunn999@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Cross currency-AR
Hi,
There are 3 patches to solve the cross currency problem:
1) Patch# 818008 :The GL post program tends to use the rounding Account
instead of the Realised gain/loss account.
2) Patch#863103 :TheWorkflow fails to pick up the realised gain/loss
account, and instead creates an unknown CCID
3)Patch# 898879 :The exchange rate gain/loss is not computed when a receipt
is cleared from CE.
Apart from the above check that workflow process: AR Balancing Segments is
scheduled. Apart from that the other setups i.e. suspense account for AR
source and Cross currency category, plus the profile option :Enable Cross
currency - Yes.
Regards,
Sunil Wahi.