Match and pay POs in AP
From: Han Allen-A11606 [SMTP:a11606@tjisbdc.tianjin.corp.mot.com]
Sent: Friday, March 26, 1999 11:19 AM
Subject: PO: Match and Pay External PO in Oracle AP
Hi, experts
We are using Oracle Payables and Oracle Purchasing, and we also have a
separate Purchase instance. If we need to match the external purchasing
instance POs and pay the matched invoices in Oracle Payables, what
specific
data is required by the Oracle Payable system that need to be extracted
from
the external purchase instance. If need to setup an interface between
this
external purchase instance and our Oracle purchase. Any comments will be
highly appreciated.
Thanks in advance!
Best Regards - Allen Han
Project Leader
SSIT
Date: Fri, 26 Mar 1999 13:57:25 -0500
From: "Palad, Ed" EdPalad@firstusa.com
Subject: RE: Match and Pay External PO in Oracle AP
Allen,
You need to create record in po_headers, po_lines,
po_line_locations, po_distributions (minimum)
and maybe too po_notifications, po_action_history. Create the PO
with an approve status.
When you match an invoice to a po it copies po_distribution_id into
ap_invoices_distributions. I did this
into 10.5. I'm just proceeding from your line of thinking.
Another approach I'm thinking of is to make a DB link to the tables
I mentioned above instead of the locals (view)
point PO_HEADERS, etc...... to your PO instance. Just a thought.
Would be nice to know the repercussions
of this approach to anybody who has implemented this architecture in
10.7. Thanks a lot in advance.
Regards,
Ed Palad
Consultant Oracle Financials, First USA
(302) 985-8591
EMail - EdPalad@FirstUSA.com
Date: Fri, 26 Mar 1999 22:56:56 -0800
Date: Sun, 28 Mar 1999 12:58:40 -0500 (EST) Autosource Rules
Date: Sat, 27 Mar 1999 07:54:36 PST Accrue on Receipt flag default
From: Klunk, Angie AKlunk@PG.Knouse.com
From: KS Kim [mailto:kskim@netcom.ca]
From: Cary Walker cwalker@tc.fluke.com
From: rstenstr@csc.com [SMTP:rstenstr@csc.com]
Date: Thu, 18 Mar 1999 21:28:03 -0500 PO Approval
Date: Tue, 30 Mar 1999 17:58:49 +0700
Date: Thu, 1 Apr 1999 14:59:58 +0800
Date: Thu, 1 Apr 1999 15:57:30 +0530
Date: Sat, 3 Apr 1999 11:26:04 +0800
Date: Mon, 5 Apr 1999 22:22:08 -0700 (PDT) FAX Purchase Orders
From: DAVID HANCOCK [mailto:CMCIDSH@njtransit.state.nj.us]
Date: Mon, 12 Apr 1999 06:49:32 -0700
Date: Mon, 12 Apr 1999 09:16:51 -0500
Date: 12 Apr 99 11:15:58 EDT Close for invoicing
From: Leanne Andre CMCILMA@njtransit.state.nj.us
Date: Tue, 20 Apr 1999 08:19:20 PDT
Date: Tue, 20 Apr 1999 15:06:07 -0400 (EDT) PO: Close vs. Finally Closed
Date: Tue, 18 May 1999 14:24:40 -0700
Date: Wed, 19 May 1999 10:32:18 -0300
Date: Wed, 19 May 1999 09:32:03 -0500
Date: Wed, 14 Jul 1999 10:33:57 -0400
Date: Wed, 14 Jul 1999 11:15:31 EDT
Date: Wed, 14 Jul 1999 13:35:38 -0400
Date: Wed, 14 Jul 1999 15:57:06 -0500
Date: Wed, 14 Jul 1999 17:55:45 -0400
Date: Thu, 15 Jul 1999 13:08:45 -0500
Date: Thu, 15 Jul 1999 14:47:45 -0400 Requisition Import
Date: Mon, 14 Jun 1999 13:01:43 -0400
Date: Mon, 14 Jun 1999 13:46:47 -0400 (EDT) Problem querying names containing apostrophe
Date: Wed, 16 Jun 1999 11:25:02 -0500
Date: Wed, 16 Jun 1999 11:30:57 -0500
Date: Wed, 16 Jun 1999 14:08:49 -0400
From: "chithra perumal"
Subject: Match and pay External PO's in AP
Hi,
If we need to match external purchasing
instance POs and pay the matched invoices in Oracle Payables, what specific data is required by the Oracle Payable system that need to be extracted from the external purchase instance.Any comments will be highly appreciated.
Thanks in advance!
Best Regards
chithra
From: Subrat Pati
Subject: Re: Match and pay External PO's in AP
Hi,
There are six PO.tables to be populated for PO/receipt information to be
available for matching in Payables. You will get good input from AP help
files in your SC.Our client required this feature and we have developed
the interfacing that works fine.
Can contact me if you need any clarifications.
bye
Subrat
From: "Vasanth Reddy" vasanth7@hotmail.com
Subject: URGENT -- PO- BLanket POs into Autosource Rules
Hello PO Gurus
I am trying to load the Blanket Purchase Orders into the Autosource
Rules using sqlplus. We are not using the
interface programs for this. I am populating the data into tables
PO_AUTOSOURCE_RULES, PO_AUTOSOURCE_VENDORS AND
PO_AUTOSOURCE_DOCUMENTS_ALL. But the main problem here is the data is
fine
when I check in the Autosource Rules form.When I
go and query in the Requisitions form the vendor information is not
populated into the Requisitions. Is my aproach correct.
Please respond directly if you have any suggestion, Help.
Thanks in Advance
Rama Vidiyala
I am curious to see what you find regarding the "subledger(PO) entries not
making it to GL." We recently had this same "problem." The way that we
"fixed" it for the month was to make a manual entry because we could not
locate the entry anywhere in the system to transfer it to the general
ledger. This happened to us two months in a row - December and January,
then
February was fine.
Good luck to you!
Angela M. Klunk
Cost Analyst
Knouse Foods Coop, Inc.
Sent: Tuesday, March 16, 1999 11:39 PM
Subject: Re: PO: Accrue on Receipt flag default
Yes, I've seen this behaviour. However, I haven't been able to determine
whether it's a system bug or a user error yet. I'm in the process of
reconciling my client's accrual account and uncovering some abnormal system
behaviour/bug, i.e. the accrual flag is set to null on the PO distribution;
the shipment accrual flag and the distribution accrual flag do not match; a
whole chunk of sub-ledger(PO) entries not making to GL. By the way, if the
accrual flag is set to 'N' or null, the system treats it as Period End
accrual. In other words, the uninvoiced/unreceived balance is accrued in
the current period and reversed in the next period. One word of caution,
make sure to reconcile your accrual account(s) each month. It can get
extremely messy if you don't get a good handle on this from the beginning.
Good luck,
Kim
Date: Tuesday, March 16, 1999 8:02 PM
Subject: RE: PO: Accrue on Receipt flag default
I'm not sure. This is the first month we've seen this (was working fine)
and we have not closed the period yet or run the period end process to
create the accrual.
Have you seen this before?
Thanks
Sent: Tuesday, March 16, 1999 10:26 AM
Subject: Re: PO: Accrue on Receipt flag default
When this condition occurs will an accrual entry be made the first month
and then no month there after???
"Yet, on some PO's (both Expense and Inventory) the Accrue on Receipt flag
in the Shipments subform is unchecked."
From: "KS Kim" kskim@netcom.ca
Subject: Re: PO: Accrue on Receipt flag default
Angela,
Are you using Period End or Accrue on Receipt? Have you switched the
accrual method recently? If you have, this can cause all sorts of problem.
For example, in 10.7 PO, a system bug can cause not creating sub-ledger
entries for Accrue on Receipt transactions, hence no GL entries (actually, I
encountered the similar problem in 10.4 without switching the accrual
method). Also, there's something causing the sub-ledger entries not ending
up in GL. It could be another bug or a user innocently dropping the batch
after accidentally importing it into GL. Whatever it is/was, the damage has
been done already. We're testing our solution right now (i.e. reversing all
the previous incomplete batches and replacing them based on the receiving
transactions in PO) . Our preliminary test result shows that it's an
acceptable solution. If you think of doing this in your organization, make
sure that you test it until you're 100% confident with the solution. We'll
be implementing our solution this weekend after many long days and nights of
testing and re-testing.
HTH,
Kim
From: "Nagamohan U."
Subject: PO Approval
Hi all
We are on 10.7 SC GUI.
We have five operating units and hence five responsibilities in
Purchasing as we have decentralized purchasing. But some of the POs that
are prepared in individual operating units have to be approved by the
top management.
So every time the top management has to go the individual division's
responsibility and approve the PO .
Is it possible that the top management goes to only one responsibility
and approves all the PO s from different operating units?
Regards/Nagamohan
From: "Solomon, Stephen"
Subject: RE: PO Approval
Yes it is possible for you to this under certain conditions.
If you are operating under the same set of books and the flexfields that are
being used by the separate areas are all part of one chart of accounts then
it is relatively simple. All you would need to do is assign security rules
through the purchasing module giving your management access to all the
accounts that relate to those five business groups.The you assign these
security rules to the responsibility of your choice. Hence they can approve
all accounts under one responsibility. If you need more info let me know.
From: Appanaboyina_Kishore Appanaboyina_Kishore@hts.satyam.com
Subject: RE: PO Approval
Hi Solomon,
My understanding is that the transaction information entered in every
operating unit carries with it org_id to the tables and the data remains
split on this basis. At responsibility level you will not be able to access
the transactions of another operating unit, though they share the same set
of books. The transactions are not restricted on the basis of the accounting
flexfield........
Pl. give me more info. on this..............
Regds
Kishore
From: "Solomon, Stephen" Stephen.Solomon@rac.com.au
Subject: RE: PO Approval
Kishore,
My answer was on the basis of you being a single org, if you are working on
multi org then it would not be possible due to the org id being different
for each responsibility. hence your understanding is correct.
Stephen
From: Assim Gupta assimgupta@yahoo.com
Subject: RE: Senior Mgr approving all POs
Hi all
I hope I am not responding to this too late.
The problem is that of a Senior Manager who wants to
approve purchase orders of multiple Operating Units
through a single responsibility (In a Multi-Org
setup).
Although I agree with Dawn that this can not be done
just by functional setups, this can be achieved by
changing the code of the PO form.
What I would do is change the code of a copy of the
form so that it retrives all the data instead of the
data for a particular Operating Unit and then give the
access to this modified form to the senior manager's
responsibility.
Rest of the guys will have access to the original form
only.
Hope this is of help
Assim
Sent: Monday, April 12, 1999 6:33 AM
Subject: FAX Purchase Orders
Hi All:
I am looking for alternative products (or programming) used to fax approved
purchase orders to suppliers. I have already looked into Oracle's Fax
Gateway,
it is a possible solution. What other products might you all be using and
satisfied with?
Dave Hancock
From: Michael Blunck michael.blunck@aris.com
Subject: RE: FAX Purchase Orders
David,
There is a product called Optio that is used by many companies to perform
this task. A much cheaper alternative is to develop a word template and use
fax from a local pc.
Michael Blunck
From: Vijay.Govathoti@fritolay.com
Subject: RE: FAX Purchase Orders
I have used HostFax s/w to fax POs/RFQs from Oracle Applications. It was
set up as a backend server and
print requests were sent to it!!! I had to do some minor customizations to
the PO print and RFQ reports..
worked pretty good..
Regards
Vijay
From: Alok Chadda alok_chadda@usa.net
To: CMCIDSH@njtransit.state.nj.us
Subject: RE:FAX Purchase Orders
There are three software available to FAX documents from Oracle Applications
OptioFax
Commerce Path
and FaxComamnder
HTH
Alok
Subject: PO: Close for Invoicing
Date: Tue, 20 Apr 1999 09:32:58 -0400 (EDT)
Good morning,
I am trying to find a way to stop invoices from being processed
against a
specific purchase order. I have tried selecting the "Close for
Invoice" action
in the Control Action Box under the Special menu option on the
Purchase Order
Summary form. When I try to match an invoice against that purchase
order, I
get a message that the PO line is closed, but I am able to continue
on matching
the invoice and processing it for payment. Is this the way the
"Close for
Invoice" functionality is intended to work, or is this a bug?
Thanks in advance,
Leanne
From: "Ananth Swaminath" ananth999@hotmail.com
Subject: Reply: PO: Close for Invoicing
Hi Leanne
Place a hold on the invoice. Create a user-defined hold and apply
that on the invoice till the time you resolve any issues you may have
on the PO. After resolving your issues, release the hold, approve the
document and proceed with matching.
Closed for Invoicing is an internal control measure to indicate that
a shipment has been fully invoiced already. It has nothing to do with
the placement of a hold on the invoice to stop a PO Match. Note that
this is a reversible action.
Hope this helps.
Ananth
Senior Functional Consultant
Financials/Supply Chain
From: Leanne Andre CMCILMA@njtransit.state.nj.us
Subject: Re: Reply: PO: Close for Invoicing
Hi Ananth,
Thanks for the suggestion, but the client does not want to have to identify all
of the invoices related to a specific purchase order and manually place holds
on those invoices. They just want to be able to place some type of hold on the
purchase order and automatically stop invoices from being processed against
that PO. I have also tried the "On Hold" option in the Control Actions box.
This works well for placing an entire PO on hold, but cannot be used to stop
invoice processing against a specific PO line on the purchase order. That is
why I was hoping the "Close for Invoice" option could be used for a specific PO
line.
Please let me know if you have any other ideas or suggestions.
Thanks,
Leanne
From: "m. smith" mrsmith@hotbot.com
Subject: PO: Close vs. Finally Closed
Hi All,
Can someone tell me what would be the benefit of finally closing a PO vs.
closing a PO? I know that an action cannot occur on a PO line once it is
finally closed. Are POs simply closed to prevent any potential trouble.
Also, is a PO line automatically closed is Purchasing when quantity_received
= quantity_ordered. Any extensive elaboration would be greatly appreciated.
Please forward responses to mrsmith@hotbot.com as well.
Thank you so much,
Madi
From: Ken Heckbert kpheckbert@ihis.org
Subject: PO: Close vs. Finally Closed -Reply
With the proper version of the report, finally closed PO's will not appear
on the Encumbrance Detail Report, and PO's need to be finally closed
before you can purge them from your system. Other than that, I can't
think of any advantages.
From: "Debbie Griffin" dgriffin@fnal.gov
Subject: RE: PO: Close vs. Finally Closed
You cannot pay an invoice against a Finally Closed PO. If an invoice is
entered against a PO, but not paid, when the PO is Finally Closed, it will
go on Final Matching hold and this hold cannot be released. You need to
cancel the invoice, and if still needs to be paid, re-enter it but do not
match it to the PO.
Closed and cancelled PO's can have invoices paid against them. They will
get warnings as they are being entered and they will go on hold, but the
holds can be overridden.
We use Final Close against a PO when a project's final costs have been
reported to our parent and absolutely no more costs can be charged to it.
Debbie Griffin
Fermilab
dgriffin@fnal.gov
630-840-8754
From: "Fowler, John P, CFCTR" jpfowler@att.com mailto:jpfowler@att.com
Subject: RE: PO: Close vs. Finally Closed
Is there a program in Oracle Purchasing that can be used to "Close" or
"Finally Close" purchase orders based on customer specified selection
criteria????
John Fowler
jpfowler@att.com mailto:jpfowler@att.com
From: Dkasper1@aol.com
Subject: Re: PO: Close vs. Finally Closed
no
From: "Fowler, John P, CFCTR" jpfowler@att.com
Subject: RE: PO: Close vs. Finally Closed
Thanks for the quick easy to understand response... Next question... Has
anyone developed an automated batch process to close POs based on user
specified selection criteria???/
John Fowler
From: "Debbie Griffin" dgriffin@fnal.gov
Subject: RE: PO: Close vs. Finally Closed
There is a MassCancel function. I have only been testing it and have not
run it in production yet. I keep getting an error status on the print
functionality that is taking Support weeks to figure out.
Anyway, in this form you can select by vendor, date range, or accounting
flexfield, to find PO's to cancel. You can then deselect those that you may
not wish to cancel on a second screen.
Cancelling is pretty close to Final Closing as I have explained before. The
only difference is that invoices can be paid against a cancelled PO if you
override the holds.
I would welcome hearing from anyone who has used this functionality
successfully myself.
-- Debbie Griffin
Fermilab
dgriffin@fnal.gov
630-840-8754
From: "Fowler, John P, CFCTR" jpfowler@att.com
Subject: RE: PO: Close vs. Finally Closed
Debbie,
Thanks for the info. We really want to Close/Final Close the orders instead
of cancel. Our AP organization is notorious for releasing holds...
Thanks again...
John
From: "Debbie Griffin" dgriffin@fnal.gov
Subject: RE: PO: Close vs. Finally Closed
There is an enhancement request under PO: # 572767 "User desires the
ability to do a mass final close on purchase orders for year end."
All we can do is vote for it, and hope it will happen.
-- Debbie Griffin
Fermilab
dgriffin@fnal.gov
630-840-8754
From: "Fowler, John P, CFCTR" jpfowler@att.com
Subject: RE: PO: Close vs. Finally Closed
Debbie,
Thanks for the info but I may be able to manually close the thousands of POs
faster. We may need to grow something on our own. If anyone out there has
something to bootstrap our efforts I would appreciate the help.
Thanks
John Fowler
From: "Ynes Coiscou, TRI" YCoiscou@tricom.com.do
Subject: RE: Requisition Import Help Required!!!!!!!
I'm posting this again. If someone has imported requisitions to
Po_requisitions_interface_all table , please answer and give some lights on
it.
Hi all:
Oracel Financials GUI 10.7 SC 16.1
I'm testing the requisition import program in PO. I've created records in
table po_requisitions_interface_all , when I submit the import program
I'm
getting differente error on APPROVER_ID, and Deliver_to_location_id. The
records are created with status Incomplete so I have null on approver_id
and when I checked the table after the import process runned the column
approver_id has a value on it. Deliver_to_location_id is valid because I
can create a regular requisition with the same deliver_to_location .
Is there any bug related? or do I have to consider anything else when
populating the interface table? any help will be highly appreciated.
I have the open interface manual for realese 10.5 , I don't have the same
manual for 10.7 are any considerable diferencees?
TIA
From: Siva Shanmugham CMCISRS@NJTRANSIT.STATE.NJ.US
Subject: Re: Requisition Import Help Required!!!!!!!
I had problems similar to yours.
The approver_id gets populated from the preparer_id or requestor_id.
Check those values.
If a Approval hierarchy is attached to the Document Type - Requisitions, the
hierarchy should have the
Preparer id already existing in the structure. You can check this set up. In
that case, I think the interface
program will not populate the approver_id. Try attaching a Approval hierarchy
as the default hierarchy and
run the program again.
I don't understand the error on deliver_to_location_id. Can u explain that
further?
Can u give the error code and message?
thanks,
siva
From: "Kalidindi, Shanthi" SKalidin@obiwan.Intecom.com
Subject: 10.7 NCA - Problem querying names containing apostrophe!!!!
Hi All,
We are on 10.7 NCA, HP UX platform. We have a problem while querying Names
of employees containing a apostrophe(ex. O'Connor). This problem appears in
PO requisitions, Purchase order screen, Define Employees etc.
Basically, when we query names with pattern O'C%, we get a "FRM-40301: Query
caused no records to be retrieved. Re-enter". However, O'% and O% retrieves
records. We have a tar open with Oracle support regarding the same and were
informed that this is a bug in the Oracle Forms 4.5!. We tested the same by
creating a test form using Forms 4.5.10.6 and get error message "ORA-01756 :
quoted string not properly terminated". Is someone out there having similar
issue?. Any ideas/suggestions are greatly appreciated.
Thanks in advance,
Shanthi
From: "Carver, Elizabeth" ecarver@MarkAndy.com
Subject: RE: 10.7 NCA - Problem querying names containing apostrophe!!!!
We are also 10.7 NCA HP UX
I tried this on the Define Employee form. It returned records when I entered
%O'C% in the last name field
When I entered O'C% it did not return records. Try putting a % sign before
and after you should retrieve records.
Beth Carver
From: Ken_Rosenbaum@lcc.com
Subject: Re: 10.7 NCA - Problem querying names containing apostrophe!!!!
We had the same problem in 10.7 NCA(forms 4.5.10.10.2). Oracle said we had to
go to the next set of forms(4.5.10.11).
Hope this helps,
Ken Rosenbaum
LCCI