AutoSelect-restrict selection Query 2
Date: Mon, 12 Jul 1999 18:58:47 +0530
From: "Mehra, Varun (CAP, GECSI)" Varun.Mehra@geind.GE.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: AP experts-AutoSelect program...
Hello everyone
We are on Oracle Apps 10.7 SC Prodn 16.1 on HP-UX 10.20 live on AP, AR, GL
and FA. The issue that I am hoping to get some inputs from all you AP
experts concerns the Quick Payment of approved invoices. Presently as Apps
logic has it, please feed in if I go awry, all approved-Invoices (which are
fed in batch mode at our site) are selected in the AutoSelect Program and
are Built for payment in the same Payment Batch. Hence a single Payment
Batch ends up paying for say 10 Invoices Batches, if all these batches have
'Approved' status.
Now here is the requirement for assistance:
Has anybody been succesful to enable the AutoSelect and Build Programs to
select Invoices to be paid Batch-wise? What this means is that the user,
while defining the Payment Batch, should be in a position to select the
Batch of Invoices s/he wants to pay and leave out the rest of the approved
batches.
Any suggestions to achieve this preserving the standard programs would be
GREATLY appreciated.
Many thanks for your time.
Varun Mehra
Manager-Applications
GE Capital Services India
Tel:0091+124+358030(x666)
DialCom: 7406 666
Date: Mon, 12 Jul 1999 12:41:02 -0400
From: "Maliszewski, Joseph" Joseph.Maliszewski@FMR.COM
Subject: RE: AP experts-AutoSelect program...
Why try and reinvent the wheel?
Look into Paygroups and Payment Priorities. You can accomplish the same
thing with these two items if you use them appropriately.
Joe Maliszewski
Consultant
Date: Tue, 13 Jul 1999 21:03:47 +0530
From: "Mehra, Varun (CAP, GECSI)" Varun.Mehra@geind.GE.com
Subject: RE: AP experts-AutoSelect program...
Joe/Everyone
The Invoice Batches created, often contain invoices of vendors with mixed
Paygroups and Priorities. How do you suggest I filter out this kind of mix
enabling only specific invoices to be selected for Payment??
Anyways many thanks for the suggestion.
Varun Mehra
Manager-Applications
GE Capital Services India
Tel: +91-124-358030(x666)
DialCom: 8*7406 666
Date: Tue, 13 Jul 1999 12:59:12 -0400
From: "Maliszewski, Joseph" Joseph.Maliszewski@FMR.COM
Subject: RE: AP experts-AutoSelect program...
You are not giving us enough information.
What are you using Paygroups and Priorities for if you are not using them to
select the invoices for payment?
Joe Maliszewski
Consultant
Payments interface
Date: Tue, 13 Jul 1999 05:46:17 -0700 (PDT)
From: =?iso-8859-1?q?Venkata=20Ramana?= cvrtech@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Payments interface in AP
Hi,
We need to load payments from legacy system at
frequent intervals.
But unfortunately there is no standard interface for
loading payments in AP.
Does anyone has work-around for this problem.
We have tried inserting rows directly into
AP_CHECKS_ALL , AP_INVOICE_PAYMENTS tables etc..
But we are facing problem in transferring the data to
GL interface tables.
Please help.
Thanks in Advance ,
Venkata Ramana
Electronic Payment - Address Style not defaulting
Date: Tue, 27 Jul 1999 09:54:43 IST
From: "Kuntal Ray" k_file2@hotmail.com
Subject: AP: In Electronic Payment, address style is not getting stored
Hi All,
I am facing a problem in AP. In case of electronic payment AP is not
storing Address Style from PO_VENDOR_SITES_ALL in AP_CHECKS_ALL table. As a
result, my report is not able to print address in correct format. But in
other cases (check) it's taking the Address Style from PO_VENDOR_SITES_ALL
and properly storing it in AP_CHECKS_ALL and all the reports are working
correctly. Did anybody face this problem or can extend any help in this
regard?
Thank you in advance,
Kuntal
Open invoice conversion
Date: Thu, 29 Jul 1999 01:00:32 MYT-8
From: philip@aleytys.pc.my
Subject: AP:10.7SC: Open Invoice conversion
Hi Oracle People,
I need to migrate all our open invoices from 9.4 to 10.7 SC. Through the
invoice interface. I plan to bring over only the net unpaid portion of
the open invoices. However my AP key user has asked me to bring over the
gross amounts plus payments against these invoices.
I'm quite blur here. Do I bring these over as Credit invoices? How do I
apply the credits against the standard invoices? There does not seem to
be an AP open cheque/payments interface in 10.7 . The lockbox thingy
appears to be a AR function.
Philip
Duplicate Invoices
Date: Thu, 29 Jul 1999 16:25:07 -0400
From: Margaret_Mason@keybank.com
Subject: AP: Duplicate Invoices in Payables
Hello Everybody,
We are currently on 10.7 SC and we are getting this unusual message lately.
When
our users are trying to key in the invoices, they get this error APP-100224
Value already exists. But when we query for the Invoice # we are unable to
find
them. This has started recently. We have not applied any Patches lately.
We called Oracle and they recognized it as a bug and a Tar is in place. The
work around is to add an alphabet at the end of the invoice # and let it go
through.
Just wanted to see why it started all of a sudden and is there anybody else
having the same problem.
Thanks in advance.
Margaret,
Check print order
Date: Fri, 30 Jul 99 15:49:59 -0700
From: oracleapps oracleapps@leco.com
To: oraapps-l oraapps-l@cpa.qc.ca, scott_kurland scott_kurland@leco.com
Subject: AP Check Print Order
Hello,
We currently have our vendors assigned to individuals in AP and when we
print
form feed checks (in one check run) they are sorted and grouped by each AP
person's id. This allows us to easily seperate them and distribute them
throughout AP people.
Now in Oracle, we are attempting to match this process. We have tried
priority
level, pay group and the checks still are put in alpha order for the whole
check
run.
Is there any way to change this? A work around possibly?
We realize we can run this by using multiple payment batches but we would
like
to do it in one.
Thanks and regards,
Jody R. Michaels
LECO Corporation
616-982-2288
Jody_Michaels@Leco.com
How to diable deletion of an Invoice
Date: Mon, 2 Aug 1999 10:55:45 +0100
From: geir.bardstu@ac.com
Subject: Deleting Invoices in AP
A client of mine is running a R10.7 NCA Accounts Payables without the
Purchasing
system. After doing a preliminary registration of an Invoice, the Red X in
the
toolbar is still active, and it is possible to delete the registered
invoice.
In the old characterbased system, it was possible to define in the setup
that
deletion of Invoices should not be possible (locally recommended by the
Auditors). Any suggestions on how to make sure that Invoices are not
deleted in
AP ?
Regards
Geir
Factoring in Ver 11 as compared to that in Ver 10
Date: Thu, 5 Aug 1999 08:14:42 -0500
From: "Marcia Michalik" marcia_michalik@edisonday.com
Subject: AP: Factoring
Does Release 11 handle factoring any better than Rel 10 did - specifically
the ability to write a check to a "vendor," typically a bank, other than the
vendor matched from the PO? If not, I'd be interesting in knowing what
others are doing as a work-around. Thanks in advance for your help.
Regards,
Marcia Michalik
Edison Day & Associates, Ltd.
612.943.3981
marcia_michalik@edisonday.com
Date: Thu, 5 Aug 1999 08:17:17 -0500
From: "Aronovici, Sarah" Aronovis@augsburgfortress.org
To: "'Marcia Michalik'" marcia_michalik@edisonday.com
Subject: RE: Factoring
Marcia,
I don't know how Rel 11 handles factors, but the workaround that I've seen
work (in 10.7) is to have the factoring bank name as the first address line
of the vendor pay site.
I've worked at a couple of companies that interacted with factoring
relationships, and they've always been able to reference both the vendor and
the factor name on the checks with no problems.
Thanks,
Sarah
Payments against Letter of Credit / Bill of Exchange
Date: Thu, 5 Aug 1999 18:26:18 -0400
From: Ashok Anmalsetty AANMAL@geminidj.com
Cc: "'jraams@mvest.com'" jraams@mvest.com,
Subject: AP:Letter of Credit/Bills of Exchange
We would like to know if any body implemented Letter of Credit/Bills of
Exchange in oracle applications.
Regards
Ashok
Tracking of Credit Memo matched to an invoice
Date: Thu, 12 Aug 1999 05:54:18 GMT
From: "Sumit Sen" sens_sumit@hotmail.com
Subject: AP:Tracking of Cedit memos matched to Invoices
Dear All
Could anyone suggest as to how does one come to know if a credit invoice has
been matched to an Invoice. The Invoice has been raised without a PO in Rel
11.
Thanks
Sumit
Unable to review or void system generated check payments
Date: 12 Aug 1999 16:37:06 -0700
From: Ramirez Rosalie rosalie@itconvergence.com
Subject: Check Payments Unavailable for Review or Voiding
What would cause for a system-generated check to not be available for review
and voiding (in the Payment Batch/Payment form)? When we view the invoice,
it is showing that is paid by certain check number but we are unable to
bring up the document number to make adjustments.
Any input is appreciated.
Rosalie
Expense Report - Employee not created as supplier
Date: Tue, 17 Aug 1999 07:03:41 -0700 (PDT)
From: srinatra dev srinatra@yahoo.com
Subject: Expense Reports
Hi Guys,
I have a problem with Expense reports.
we are using 10.7.0SC161
WE r using: AP,AR,FA,CM&GL
I have set up payables. Checked the payable option "Automatically
create Employee as Supplier". Selected the default Business group
Entered the employees. Created a expense report. Employee is available
in the pick.
Performed "Payables Invoice Import".
The message in the Exception region is "Create as Supplier"
The problem is, Iam not able to view the invoice nor does the system
automatically create the Employee as supplier.
Could some one tell me what am I missing
Thanks in Advance
Regds
Sri
Date: Mon, 23 Aug 1999 00:09:44 +0200
From: Mike Bennet MikeB@langeberg.co.za
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Expense Reports
Do you have automatic or manual numbering for suppliers?
You cannot automatically create employees as suppliers if you use manual
supplier numbering.
Regards
Mike Bennet
Date: Mon, 23 Aug 1999 01:12:21 -0700 (PDT)
From: srinatra dev srinatra@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Expense Reports
Thanks Mike. You've got it right. It's working now.
DS
Invalid Item id
Date: Tue, 17 Aug 1999 12:47:51 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: Invalid Item Id when navigating in AP Payments
All,
We are using 11.0.28 and are ready to go for 11.0.3.
I woul like to know if any of you guys have come across this BUG.
Whenever I navigate Invoice Distributions, i get an error dialog box
"Invalid Item ID ".
Please let me know if anyone of you guys have come across this problem.
Thanks,
-chakrapani
Date: Tue, 17 Aug 1999 14:32:50 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: FRM -41045 Cannot find Item: Invalid Id in Enter Payment Methods
Hi,
We are using 11.0.28 on HP-UX and we are encountering this FRM error when
we navigate to PAyments zone in "Enter Invoices" screen.
When I navigate to "PAyment Method" field I am getting following error:
FRM -41045 Cannot find Item: Invalid Id in Enter Payment Methods.
We were told that we need to upgrade to 11.0.3 and we upgraded to 11.0.3 but
still it is giving error.
Please let me know if this is a SETUP problem and what needs to be done.
Thanks,
-chakrapani
Withholding tax - netting the transaction
Date: Tue, 17 Aug 1999 12:18:06 -0700 (PDT)
From: mark liberman m_liberman@yahoo.com
Subject: AP: Withholding tax - netting the transaction
Hi all,
I've set up AP withholding tax (at payment).
After entering a supplier invoice, the AP reports show the total gross
invoice amount as the liability.
After paying the invoice, the same reports show only the net amount
(after withholding tax deduction) as the invoice amount.
We need to see in the supplier reports the whole gross invoice amount
(to know the total supplier turnover) and see that the payment was
divided between the actual amount paid to the supplier and the tax
deduction.
Does anyone know if AP supports that? Or is there any way to achieve
that?
Would appreciate any input,
Mark
Handling Unclaimed Monies
Date: Wed, 18 Aug 1999 10:30:36 +1000
From: Sheila Cruickshank scruickshank@assist.com.au
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: AP: Solution for handling Unclaimed Monies
Hi all,
We have recently come across a situation requiring a solution in AP (and
possibly GL). Just wondering if anyone has seen this before and developed a
solution for dealing with the requirements.
REQUIREMENTS:
Where cheques issued from AP remain unpresented for a defined period of
time, legislation requires this money to be held in trust, and after a
further period of time they must be reported in a government gazette. The
gazette reporting requires that all of the payee/payment details be notified
(ie name, address, amount etc). If the monies are then not claimed, they
must be handed to the Reserve (Central) Bank. An administration fee can be
deducted which in most cases will reduce the amount payable to the Reserve
Bank to nil.
The process that needs to be implemented in AP/GL after the payment is
voided is:
1) Store payment information to reflect that the funds are being held in
trust
2) This should include ability to store all payment / payee information
3) This should include the ability to deduct an administration fee
4) This should include the ability to report all of this information for
gazettal
5) This should provide the ability to ultimately pay the funds to the
Reserve Bank, net of the administration fee.
Please let me know if you have any ideas.
Thanks
Sheila Cruickshank
ASSIST
On entering Prepayment invoice system hangs
Date: Wed, 18 Aug 1999 10:46:22 LKT
From: "Sannidhi Kris" sannidhik@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: AP Prepayments
Hi All
We are experiencing problem in entering Prepayment Invoice. The systems is
hanging after entering the invoice header details. It is hanging either we
press Distributions or we save it. Has any body got this type of situation .
Please let me know how they have resolved it.
Thnks in Advance
Krishna
Voiding Check programmatically from external system
Date: Wed, 18 Aug 1999 08:30:56 -0400
From: =?iso-8859-1?Q?Fran=E7ois_Gendron?= francois.gendron@videotron.ca
To: OraApps-L OraApps-L@cpa.qc.ca
Subject: AP: Voiding checks programatically from external system
All,
Has anyone ever voided checks from within a custom
developed PL/SQL procedure.
How did you go about it?
Thanks,
--
François Gendron
La Société d'Informatique Gendron Inc.
Tél: (514) 212-3994 Fax: (450) 651-7375