How does Attribute 15 of ap_invoice_distributions_all gets populated
Date: Thu, 12 Aug 1999 12:48:50 -0400
From: "Sankala, Dinesh" Dinesh.Sankala@lgeenergy.com
HI ALL
Is there any Oracle standard programe or any oter process
that populates attribute15 in ap_invoice_distributions_all
with a value 'Y'
I am getting few records in the above column with that value but couldnt
figur eout how
was it populated
any help /lead greatel appreciated
kumar
Date: Thu, 12 Aug 1999 16:57:48 -0500
From: "Parrish, John" JParrish@dfwairport.com
The field you reference is, of course, usually used in descriptive flex
field definitions. Look there first. Assuming you have already done so,
you might also check for table level triggers. That is unlikely, however.
To be certain that there is no standard program, check your TRM. It has a
section with each table definition which tells what modules will access the
object.
How to include 1099 payments made outside Oracle system
Date: Mon, 16 Aug 1999 11:38:35 -0400
From: "Conine, Carol (CCL)" CConine@carnival.com
Cc: "Fecht, Christina M. (CCL)" cfecht@carnival.com
Subject: RE: AP 1099's
Has anyone found a good way to handle adding additional amounts to the AP
1099 that are not paid from Oracle? We have vendors that are paid outside
our Oracle Payables system for specific types of payments while paid through
Oracle AP for other types of payments. I need to send one full 1099 that
includes all payments. I do not want to modify the file that is sent to
IRS. We are on 10.7 character mode.
Please send your responses to me directly as I don't check the listserver
all the time.
Thanks. Please send responses to: cconine@carnival.com
Carol Conine
Carnival Cruise Lines
Date: Mon, 16 Aug 1999 12:13:25 -0500
From: Mike Dennis mdennis@mdp.com
To: oraapps-l@cpa.qc.ca
Subject: RE: AP 1099's
Carol,
We do this also, particularly with non-cash prizes. Our solution, while not
elegant, seems to work reasonably well for us AND permits us to stay within
the functionality without customization.
Steps
ONE TIME
1. We set up a new account number to handle the distribution charges. This
account number should always net to zero at the end of each accounting
period.
2. We set up a new bank account to handle payment of the prizes. The
account number for the cash account was pointed to the same account in step
1 above. [when an invoice is keyed and paid, this account will be netted to
zero]
3. We set up a new Pay Group named PRIZES. The paygroup allows us to
easily determine which "invoices" were prizes and permits us to do a manual
batch payment if we choose.
EACH ITEM
4. When a prize has been given, an "invoice" is added against the supplier
using the PRIZES paygroup. The distribution goes to account set up in step
one. [these suppliers are already defaulting MISC codes and state codes
into the invoice distribution, but if not, these codes are added manually]
5. The invoice is paid via manual payment to bank account set up in step2.
6. Run 1099's
I have attached a brief user document [Microsoft Word 97] for the user's
process. I hope you find this helpful. - - could not send to oraapps
because of size so only sent to you directly
Mike Dennis
Financial Systems Administrator
Meredith Corporation
mdennis@mdp.com
515-284-2554
Linking AP_INVOICE_DISTRIBUTIONS_ALL and AP_INVOICE_PREPAYS_ALL tables
Date: Wed, 18 Aug 1999 03:21:09 PDT
From: "moses rajasingh" mosesrajasingh@hotmail.com
Subject: *********Help me Very Urgent*************
Hi
In AP, the INVOICE DISTRIBUTION file will have multiple records. The
linking between the distributed records with the FOLLOWING TABLES
1. AP_INVOICES_ALL
2. AP_INVOICE_PREPAYS_ALL
3. AP_INVOICE_PAYMENTS_ALL
We could link the AP_INVOICES_ALL file with INVOICE_ID. But the other 2
files have many to many relationship with the DISTRIBUTION file. The only
link available is INVOICE_ID & PREPAY_ID. Is there any link fields or any
link tables available.
Example
TABLES
------
AP_INVOICE_DISTRIBUTIONS_ALL
FIELDS
------
INVOICE_ID AMOUNT ACCOUNTING_DATE
10001 50000 01-APR-99
10001 40000 30-APR-99
10001 5000 05-MAY-99
10001 5000 15-MAY-99
TABLES
------
AP_INVOICE_PREPAYS_ALL
FILEDS
------
PREPAY_ID INVOICE_ID AMOUNT
10001 20001 40000
10001 20002 5000
10001 20003 5000
From the above two table we are knowing that, there is a PREPAYMENT INVOICE
of 50000 and correspondingly three STANDARD INVOICES of 40000,5000,5000 are
adjusted against that PREPAYMENT.
Our ultimate aim is to get the corresponding ACCOUNTING DATE from
AP_INVOICE_DISTRIBUTIONS_ALL for each row in the AP_INVOICE_PREPAYS_ALL.
Thanks in advance
Moses
Date: Wed, 18 Aug 1999 16:28:56 +0530
From: "Bagavathi Rajan K" rajankb@wipsys.soft.net
Subject: Re: *********Help me Very Urgent*************
Hi,
To get the accounting date of a prepayment application, use
other_invoice_id in ap_invoice_distributions. in ur case,
ap_invoice_distributions will be having the entries
similar to the one given below.
AP_INVOICE_DISTRIBUTIONS_ALL
FIELDS
------
INVOICE_ID AMOUNT ACCOUNTING_DATE OTHER_INVOICE_ID
10001 50000 01-APR-99
10001 40000 30-APR-99 20001
10001 5000 05-MAY-99 20002
10001 5000 15-MAY-99 20003
Hope this helps you.
Regards,
K.Bagavathi Raja.
Date: Wed, 18 Aug 1999 05:37:44 PDT
From: "DASARI SUBRAHMANYAM" srdasari@hotmail.com
Subject: Re: *********Help me Very Urgent*************
Hi Moses,
There is no direct relationship between ap_invoice_distributions_all and
ap_invoice_payments_all. Same is the case between
ap_invoice_distributions_all and ap_invoice_prepays. They need to be linked
taking the invoice_id only.
There is no way to identify a payment/prepayment to a distribution of an
invoice, if that is ur requirement.
bye
dasari
Date: Wed, 18 Aug 1999 19:22:27 +0530
From: "Bagavathi Rajan K" rajankb@wipsys.soft.net
Subject: Re: *********Help me Very Urgent*************
Hi,
I am working on Apps 10.7 SC. I have noticed the following
things during the prepayment invoice lifecycle.
Whenever a prepayment invoice is created and it is paid, the
following entries are craeted.
Please click here for the entries
When a standard invoice is created (to be later applied against
the prepayment), the following entry is created :
Please click here for the entries
Now, when we apply the prepayment against this standard invoice
on 20-APR-99, the following entries are created.
Please click here for the entries
From this we can see that, the distribution line
created for a prepayment application can be linked to the
ap_invoice_prepays_all using invoice_id in
ap_invoice_prepays_all and other_invoice_id in ap_invoice_distributions_all
and ap_invoice_payments_all. (infact without going to the
ap_invoice_prepays_all, we can track the
applications using other_invoice_id in ap_invoice_distributions_all).
Please note that, when a prepayment is applied against
the standard invoice & then unapplied, the entry for the same will be
deleted from
ap_invoice_prepays_all. The following entries are passed when we unapply the
application discussed earlier.
Please click here for the entries
To link a payment to a line in
ap_invoice_distributions_all, we have to use the INVOICE_DISTR_LINE_NUMBER
column in ap_payment_distributions_all table. This
table can be linked to ap_invoice_payments_all using the column
INVOICE_PAYMENT_ID.
Hope this helps.
Regards,
K.Bagavathi Rajan.
AP Trial Balance out of sync after MegaPatch R
Date: Fri, 20 Aug 1999 08:55:04 -0700 (PDT)
From: JeTonne Herring herrjt_jea@yahoo.com
To: OraApps-L@cpa.qc.ca
Subject: AP Trial balance report
All,
We have AP, GL, PO, and others installed. Oracle Applications 10.7SC,
16.1 GUI, our method for accounting is accrual basis, and we have
applied up to MegaPatch set R in AP. Consequently after applying this
patch, at month end our Accounts Payable Trial Balance report gave
some very strange figures and a massive amount of unwanted data. A lot
of the data on this report was from previous periods. Has anyone else
experienced any changes in the AP Trial Balance report? We have raised
a TAR with Oracle support and have applied upon their suggestion the
following bug fixes, 375496 and 852484. Our problem still exists. Up
until this past end of the month run the report matched exactly to what
the GL balance for our accrual account was. We upgraded from AP
Megapatch set M to R.
Any suggestions for this are greatly appreciated.
JeTonne Herring
JEA
904 665-7620
herrjt@jea.com
Date: Fri, 20 Aug 1999 11:17:43 -0500
From: "Aronovici, Sarah" Aronovis@augsburgfortress.org
To: "'Oracle Apps Forum'" OraApps-L@cpa.qc.ca
Subject: FW: AP Trial balance report
JeTonne,
Did you receive the AP TB rebuild script from OWWS? The rebuild script needs
to be run after patch 852484 is applied.
Sarah
Track Vendors with no activity Query 2
Date: Thu, 09 Sep 1999 10:23:09 -0400
From: mrosm mrosm@stratos.net
To: oraapps-l@cpa.qc.ca
Subject: SQL script for Vendors without AP and PO activity
Hi,
We are trying to identify dead data. We want to identify older vendors
who have no ap or po activity. PO_Vendors is the driving table. Can
anyone offer suggestions as to the most effective script to complete
this process.
Thanks,
madi
Date: Thu, 9 Sep 1999 07:47:28 -0700 (PDT)
From: Andy Schindler aschindl@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: SQL script for Vendors without AP and PO activity
select distinct vendor_id
from po_vendors
minus
select distinct vendor_id from po_headers_all
where creation_date between
to_date('01-JAN-99','dd-mon-yy') and
to_date('31-dec-99','dd-mon-yy')
/
Andy Schindler
NRC, Inc
Date: Fri, 10 Sep 1999 23:01:32 MYT-8
From: philip@aleytys.pc.my
To: Andy Schindler aschindl@yahoo.com, oraapps-l@cpa.qc.ca
Subject: Re: SQL script for Vendors without AP and PO activity
Urm, Andy, did you do an explain plan on your query?
Anyway here is something slightly less resource intensive (he did say he
wanted PO_VENDORS to be the driving table after all):
Select pov.vendor_id
,pov.vendor_name
from po_vendors pov
where NOT EXISTS
(select 'X'
from po_headers_all poh
where poh.vendor_id = pov.vendor_id
and poh.creation_date to_date( '01-JAN-1995', 'DD-MON-YYYY')
)
Somebody else will have to do the AP side.
Cancelled Invoices created encumberance journal
From: "jagannath G" gjnath@hotmail.com
Reply-To: oraapps-l@cpa.qc.ca
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: AP: Cancelled invoices create an Encumbrance journal after
posting.
Date: Fri, 1 Oct 1999 00:31:14 -0400 (EDT)
Hi
Can anybody let me know under what are the conditions , the AP invoices
create encumbrance type journals. I have a customer who insists that
cancelled invoices were creating normal journals earlier but for a
particular batch the journal created is of encumbrance type.
could it be due to Po matching difference ? What if the invoice mentioned
is
without any PO. Need Suggessions on this.
Thanks in advance
Jagannath
Date: Tue, 05 Oct 1999 11:42:58 PDT
From: "prince suthakar" prince_sutha@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AP: Cancelled invoices create an Encumbrance journal after
posting.
Hi,
Encumbrance will create for invoice without po also.
Thanks
prince
Date: Fri, 15 Oct 1999 08:41:20 -0500
From: "Debbie Griffin" dgriffin@fnal.gov
To: "oraapps-l" oraapps-l@cpa.qc.ca
Subject: Re: AP: Cancelled invoices create an Encumbrance journal after
Yes, all invoices create a credit encumbrance entry. If they are not
matched to a PO, a debit encumbrance entry will be created when you run
Programs- Create Journals out of GL.
-- Debbie Griffin
Fermilab
dgriffin@fnal.gov
630-840-8754
Invoice matching with PO releases
Date: Mon, 04 Oct 1999 11:28:11 +0100
From: c073 c073.bbs@btinternet.com
To: Oracle Forum OraApps-L@cpa.qc.ca
Subject: AP: Payables Invoice Import
We are using many PO Releases to order small quantities of goods. A lot
of releases are being raised and we receive one consolidated invoice.
Currently we spend a lot of time matching the Invoice to the releases
which is not really practical. We could use self billing to speed up
the process or the invoice import process. The problem with invoice
import process is that we cannot match to the releases this way until
release 11.
We are using Release 10.7 NCA with PO, AP, GL, FA, CM and OPSF version
12.
Does anyone out there manage a similar situation and if so, what was
your solution?
Ian Gardner
Britannia Building Society
C073.BBS@btinternet.com
Matching Invoice (3 way) with multiple receipts
Date: Fri, 1 Oct 1999 13:45:43 -0400
From: "Plaine, Sue" PlaiS@jea.com
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: Payables Approval with Multiple Receipts Problem
We are experiencing a problem with invoice matching. Here is an example of
the problem.
We have an approved purchase order for 20,000 items with a 3-way
match specified.
The vendor invoices us partially for 7000 items, Invoice A. Invoice
A is placed on a QTY REC hold since the receipts have not been entered.
Over the next couple of days we receive and process two more
invoices: Invoice B for 3000 items and Invoice C for 4000 items.
Now we have 3 invoices in the system all on QTY REC hold:
Invoice A 7,000
Invoice B 3,000
Invoice C 4,000
Total: 14,000 items
The user acknowledges that we have received items from Invoice B and
enters receipts for 3000 items. During the next Payables Approval (run
nightly), we would expect Oracle to approve Invoice B which does not happen.
Instead, all three invoices remain on hold until the receipts for all 14,000
tems have been entered.
This is causing our payables department to find these invoices, match with
received quantity and manually release holds.
Is anyone experiencing this problem and what have you done to expedite the
invoice approval process?
Thanks to all in advance.
Sue Plaine
JEA
plais@jea.com
Date: Fri, 15 Oct 1999 01:27:50 -0400
From: Steve Harper steve.harper@pragmatek.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Payables Approval with Multiple Receipts Problem
Unfortunately AP expects a one-to-one matching of PO quantity with Invoice
quantity and it doesn't care if the quantity comes in on more than one
invoice -- it is looking for the total quantity being matched. The only
way to bypass this is to set your matching tolerances (SetupPayables
Options) to some very large percentage so it will allow you to say that an
invoice for 3000 items can be matched against a PO for 20,000 and that
constitutes a valid match. The only problem here is that AP assumes that,
once you have the match, the PO can be closed.
Alternatively, if you know in advance that the vendor is going to be
shipping and invoicing the goods in multiple shipments, you could set up a
Blanket PO and issue individual releases against that blanket with the
expected receipt dates. That way the individual receipts (and invoices)
could be matching up against individual blanket releases and everything
will clear automatically.
Hope you can find a cleaner solution.
Steve Harper
PRAGMATEK Consulting Group, Ltd.
Date: Fri, 15 Oct 1999 09:53:27 -0600
From: tom prado-irwin tprado-irwin@Quark.Com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Payables Approval with Multiple Receipts Problem
Sue-
Our AP person recommends auto-approving invoice by invoice instead of
running the auto-approval report.
Tom prado-Irwin
Quark, Inc
tprado-irwin@quark.com
303-894-3915
Custom Payment Format not listed under "Automatic Payment Programs"
Date: Thu, 07 Oct 1999 14:45:05 GMT
From: "bharathi Yarlagadda" bharathi_d72@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Custom Payment Format not listed under "Automatic PAyment Programs"
list
All,
I modified the "BACS 1/2 in ch tape format " report and saed it under
CUSTOM_AP_TOP/reports and I tried add this concurrent program under
"Automatic Payment Programs" screen but I am unable to find
the CUSTOM program.
Can somebody tell me why it was not getting picked up ?
I registered this as a new Custom program and added in security group also.
But still I am unable to see in the list of "Registered Programs" list.
Any help would be highly appreciated.
Thanks in Advance,
-Bharathi
Date: Sun, 17 Oct 1999 19:39:02 -0700
From: "Mohan Iyer" miyer@fortuna.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Custom Payment Format not listed under "Automatic PAyment
Programs" list
You need to register it with the Oracle Payables Application and not your
custom application. If I am not mistaken this should take care of your
problem.
Thanks,
Mohan Iyer
Financials Consultant
Sunnyvale, CA
Date: Sun, 17 Oct 1999 21:19:33 -0700 (PDT)
From: FMT firas70@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Custom Payment Format not listed..... More Info.
Hi,
ALL Payment format reports MUST be registered under the
AP_APPLTOP, If you want the exact steps i have prepared a
step by step doc on how to register the payment document.
(10.7 SC )