Patches
Date: Sat, 20 Mar 1999 18:56:21 -0800 (PST) AP Reconciliation
Date: Mon, 22 Mar 1999 10:07:31 -0500
Jagannathan wrote:
Date: Thu, 1 Apr 1999 11:13:15 -0600
"Kurylo, Mary" Kuryma@consumer.org on 02/26/99 03:40:51 PM
From: Tammy_Schmuki@ncci.com [mailto:Tammy_Schmuki@ncci.com]
Date: Mon, 1 Mar 1999 09:33:11 -0500 (EST)
Date: Thu, 18 Feb 1999 09:32:37 -0500 (EST) Rejoinder- mail recd. on 15/6/99 on point raised by Kurylo in his mail of 26/Feb/99 above"
Date: Tue, 15 Jun 1999 16:48:47 -0300 Invoices / entries included in TB
Date: Thu, 18 Feb 1999 07:50:55 -0500 (EST)
Date: Thu, 18 Feb 1999 09:57:43 -0500 (EST) Base Tables
Date: Thu, 25 Mar 1999 08:31:15 PST
Date: Thu, 25 Mar 1999 09:59:42 -0700
Date: Thu, 25 Mar 1999 15:57:56 -0600
From: Puchniak, Stan [SMTP:Stan_Puchniak@standardaero.ca]
Date: Fri, 26 Mar 1999 10:34:47 +300500 Entering Employee data
Date: Mon, 29 Mar 1999 10:24:38 +0530 Interface with Projects
DateTue, 30 Mar 1999 12:18:03 +0530
-----Original Message-----
DateTue, 30 Mar 1999 13:41:10 +300500 Tracing JEs from AP to GL
Date: Thu, 01 Apr 1999 11:04:11 +0100
Murali Parthasarathy wrote: Discounts
From: Rao, Paddy [SMTP:prao@usa.capgemini.com]
Date: Tue, 6 Apr 1999 10:56:34 -0400
Date: Tue, 6 Apr 1999 20:37:45 +0530 One Time Supplier Functionality
From: server@ibm6000.cpa.qc.ca [mailto:server@ibm6000.cpa.qc.ca]
Date: Wed, 7 Apr 1999 14:13:11 -0400
Date: Wed, 7 Apr 1999 13:35:01 -0500
Date: Wed, 07 Apr 1999 11:23:43 +0100 Audit Report
From: Jubinville, Melanie -ND [mailto:jubinvillem@espn.com]
Date: Mon, 12 Apr 1999 14:31:09 -0500
Date: Wed, 14 Apr 1999 07:10:19 PDT
Date: Thu, 15 Apr 1999 05:48:52 PDT Combined Accounting
Michelle Aguilar wrote:
Date: Fri, 25 Jun 1999 11:53:23 -0600 Web Employees in 10.7
From: Bill Bertolotti [SMTP:billbert@yahoo.com]
Date: Fri, 2 Jul 1999 13:45:47 -0500 MRC - posting and query problem
Date: Fri, 02 Jul 1999 09:54:06 +0530
Date: Fri, 2 Jul 1999 11:48:33 -0700 (PDT) Automatic spreading of prepaid expenses
Date: Wed, 7 Jul 1999 10:33:55 +0400
Date: Thu, 08 Jul 1999 10:51:50 -0600 Holds on AP Interface Table
Date: Wed, 14 Jul 1999 11:06:17 -0700 (PDT)
Date: Wed, 14 Jul 1999 11:52:34 -0700 (PDT)
Date: Wed, 14 Jul 1999 13:20:50 -0700 (PDT)
Date: Thu, 15 Jul 1999 15:33:41 +0000 (GMT) When does the AP_TRIAL_BALANCE TABLE get populated
Date: Mon, 19 Jul 1999 15:20:30 PDT
Date: 19 Jul 99 20:43:17 EDT Changing the Automatic Offset Method
Date: Fri, 23 Jul 1999 11:34:55 -0500
Date: Fri, 23 Jul 1999 12:58:00 -0400 AP Liability Account out of Balance
Date: Fri, 06 Aug 1999 10:17:52 -0500
From: Subrat Pati
Subject: Re: AP patch Q for 10.7SC
Hi,
We applied AP-Q about three weeks ago and have not faced any problems as
yet.
regards
Subrat
--- "Scott, Ora"
To All,
What is known about AP patch Q? We believe that it
should correct some
problems that we are having, but are concerned about
what else it may do or
cause.
Thank you in advance for any experiences that you may
share.
Ora Scott
From: "Jagannathan, Ravi"
To: "'oraapps-l@cpa.qc.ca'"
Subject: AP- REconciliation
Hi All!
We are in 10.6 NCA and implemented our AP and GL recently.
Can anyone please let me know the AP/GL reconciliation steps.
Any type of help will be much appreciated.
Thanks in advance
Ravi Jagannathan (MIS)
Tel : (305) 816 4831
Hi AP/GL gurus!
Can any one suggest me an easy way to locate and solve the differences
between AP TB and GL Liability balance. (Example: AP TB balace is $
5,154,120.67 and GL AP liability account shows a balance of $ 5,151,258.55).
Any help will be appreciated.
From: "Puchniak, Stan" Stan_Puchniak@standardaero.ca
Subject: RE:AP-GL Tb differences
The most likely cause of this is a non-Payables source transactions has been
posted to the GL account. The GL balance of the liability account should
always reconcile to the AP TB for entries with a source of Payables. I am
assuming that all entries for the period have been successfully posted to
the GL. Based on amount, this may be one invoice. You could try to query the
AP_Invoices table for that amount and see what you get.
cc: (bcc: Tammy Schmuki/BOCA/NCCI)
Subject: RE: AP Trial Balance - HELP!!
There's been a lot of discussion on the list about this. The first thing
you
can do is call Oracle Jim Agee in the Payables group in Orlando is very
knowledgeable about this subject. Patch #694188 will rebuild your AP Trial
Balance (if that's what you need to do).
The problem with cancelled invoices has been fixed.
However one item that has changed in the way AP reports the trial balance
is
that in the past (older versions of the report) the APTB reflected all
activity that was made to the GL. It doesn't do that anymore.
Example:
We actually close AP around the 25th of the month (lets say Feb for this
example). Any invoices that come in after that date are entered as having
a
Feb invoice date, with distribution posted to March. If that invoice is set
up with payment terms of IMMEDIATE, it gets paid on say Feb 28th and the
payment is posted in Feb (we re-open the period to cut checks). Since the
invoice is being paid before the distributions are being charged you could
say it's like a prepayment. The old APTB used to show these invoices as
negative amounts remaining (or amounts due us). The new APTB doesn't
include
these invoices at all even though the payment part of it was transferred to
the ledger in that period.
What Oracle is saying is that we shouldn't be doing this (we should be
making prepayments) the system wasn't designed to work this way. And I see
their point, but if the system doesn't want us to do that, then 1) it
shouldn't allow us to make the payments either and 2) should an AP system
enforce those types of rules or should it just report on what's actually
happened?
In the meantime I wrote a script that for the last two months has
substituted Oracle's APTB (the difference being that mine ties to the
ledger
so far).
Sent: Friday, February 26, 1999 4:22 PM
Subject: RE: AP Trial Balance - HELP!!
We were told to apply patch #375496 to rebuild our trial balance. What is
the difference in my patch and your #694188 ?
From: "Kurylo, Mary" Kuryma@consumer.org
Subject: RE: AP Trial Balance - HELP!!
Tammy,
You're correct the patch to rebuild the APTB is 375496. 694188 solves the
cancelled invoices problem.
Sorry about that.
Mary
From: "Dorothy Maguire" DPMAGUIR@us.oracle.com
Subject: Re: AP Trial Balance - HELP!!
Hi
Did you try running the Transaction Reconciliation Report?
This report will help identify the GL journal entry lines imported from
particular transactions in Oracle Payables. Transactions that have
not been transferred to GL are marked with an indicator.
Dorothy
Dorothy P. Maguire
ORACLE Consulting
Core Technology Services
Center of Excellence
520 Madison Avenue
29th Floor
New York, NY 10022
Voicemail: 800 862 4563 ext. 2697
Beep: 800 983 2494
Home: 914 353 1497
Email: dpmaguir@us.oracle.com
From: Ken Heckbert kpheckbert@ihis.org
Subject: RE: AP Trial Balance - HELP!! -Reply
Hello All,
I was cleaning up my email, and came across this old message, but I
thought I would let everyone know that this problem has now been fixed
- The bug # is 776561. Invoices now paid before the GL date do once
again show on the APTB as negative amounts.
Kne
From: Seda.Siddikoglu@Lafarge-Turkey.lafarge.com
Subject: AP: AP Trial Balance
Hi,
Does AP trial balance include all unpaid or partially paid invoices which
are transferred to GL or those for which journal entries in GL are created?
AP on-line help says that it includes those for which journal entries are
created. According to this, if I transfer an unpaid invoice to GL and
delete the related journal lines from GL interface, then report is not
going to show this invoice to me in AP trial balance as a journal entry for
that invoice is not created in GL.
Thanks in advance!
Seda
From: Ken Heckbert kpheckbert@ihis.org
Subject: AP: AP Trial Balance -Reply
It doesn't matter if you delete the line in the interface table or not. As far
as AP is concerned, the transaction was transferred to the GL, and will
show it on the AP trial balance. Whether or not it ever actually gets
posted in the GL doesn't matter to AP. This is why it is very dangerous
to edit a Payables journal entry at any point in the process. You will end
up with corrupt data.
From: "JANAKI ALLU" janaki_oracle@hotmail.com
Subject: ****AP INVOICE SCREEN - VOUCHER NO&APPROVAL_STATUS
could anybody tell me in which base table voucher number in AP Invoice
form will be stored.i checked AP_INVOICES_ALL voucher num column which
is not storing this value...
similarly approval_status in AP invoice form
From: MANTOSRIDAR@micronpc.com
Subject: RE: ****AP INVOICE SCREEN - VOUCHER NO&APPROVAL_STATUS
If you mean payment reference( check number) for the invoice, then it
is check_number column in ap_checks linked to ap_invoice_payment thru
check_id which is related to ap_invoices thru invoice_id.
From: "Veach, L. Vincent" VeachLV@bvsg.com
Subject: RE: ****AP INVOICE SCREEN - VOUCHER NO&APPROVAL_STATUS
As for approval_status, it is not stored but derived everytime that it
needs to be displayed. See Package:
AP_INVOICES_UTILITY_PKG.GET_APPROVAL_STATUS.
View AP_INVOICES_V (which is the base table for Invoice workbench)
references package AP_INVOICES_PKG.GET_APPROVAL_STATUS which in turn
references AP_INVOICES_UTILITY_PKG.GET_APPROVAL_STATUS.
Pretty fun isn't it.
Sent: Thursday, March 25, 1999 1:54 PM
Subject: RE:****AP INVOICE SCREEN - VOUCHER NO&APPROVAL_STATUS
The column name is "DOC_SEQUENCE_VALUE" from AP.AP_INVOICES_ALL.
From: Ushasi_Basu@india.notes.pwa.co.in
Subject: Re: ****AP INVOICE SCREEN - VOUCHER NO&APPROVAL_STATUS
Hello Janaki
The doc_sequence_value column of AP_INVOICES_ALL stores the invoice voucher
numbers. If you require the approval status for report purpose then you can
use the APPROVAL_STATUS_LOOKUP_CODE of AP_INVOICES_V table.
Hope this helps.
Ushasi
From: Appanaboyina_Kishore Appanaboyina_Kishore@hts.satyam.com
Subject: problem in entering the Employee data
Hi ,
I am facing a problem in entering the Employees in the Payables.There is no
HR and Purchasing installed.
After entering the data and while commiting the record the system gives the
following error;
FRM-40735 -ON-INSERT TRIGGER RAISED UNHANDLED EXCEPTION
ORA-06550 :LINE 1 ,COLUMN 7
PLS-00306: WRONG NUMBER OR TYPES OF ARGUMENTS IN CALL TO "INSERT
ROW"
ORA-06550:LINE 1,COLUMN 7
PL/SQL:STATEMENT IGNORED
I have set the Profile Options
HR User Type as HR User at Site and Responsibility level.
HR Business Group : the default business group
Regds,
Kishore.A.M.N
FromAppanaboyina_Kishore Appanaboyina_Kishore@hts.satyam.com
CcUshasi_Basu@india.notes.pwa.co.in
SubjectREInterface with projects
Hi Ushasi Basu,
You can only import Standard invoices or Credit memos. There is no facility
to take in Prepayments using the Standard Invoice interface(Payables Invoice
Import)
There is a work around to this.
You will first have to import the invoices as standard invoices and then
insert values into the production table ap_invoices_all. It worked for me.
If you need more details on this i can help you with that......
On making adjustments to a paid and posted invoice. You can only increase
the invoice amount and can't reduce the invoice value. If you want to do
that, you have to void the payment. Distributions you can always reverse
and enter new ones. The status of the invoice will change from approved to
needs reapproval.......
Kishore.A.M.N
From: Ushasi_Basu@india.notes.pwa.co.in
[SMTP:Ushasi_Basu@india.notes.pwa.co.in]
Sent: Tuesday, March 30, 1999 3:30 PM
Subject: APInterface with projects
Hello Friends
Could anyone tell me how to import prepayments from Projects into Accounts
Payables. I believe that all invoices imported through the two interface
tables viz, expense headers and lines, are of standard type.
Another questionhow does one handle an erroneus posting made from AP to
GL. Does one reverse the posting in GL reenter a fresh invoice/payment in
AP and post that to GL for correct reflection of accounting data
OR
can one make adjustments on the posted invoice/payment and re post the
same to GL
Regards and Thanks
Ushasi
FromUshasi_Basu@india.notes.pwa.co.in
SubjectREInterface with projects
Hello Kishore
Thanks for your reply. Could you please give me details of the work around
you mentioned.
Thanks again
Ushasi
From: jmcdonald@princesscruises.com (Jeanne R Mcdonald)
Subject: Re: Tracing Journal Enteries From GL to AP
I'm not sure what you're looking for- but here is an earlier post I put on the
list some time ago...
The method of recording details of posting from AP to GL was changed
significantly for release 10. AP_INVOICE_PAYMENTS.JE_BATCH_ID is no
longer assigned. The link is now through the following method.
When the posting goes to GL, a table called GL_IMPORT_REFERENCES is
populated. This contains the information:
For Invoices:
REFERENCE_1 Vendor Name
REFERENCE_2 Invoice id
REFERENCE_3 Distribution Line Number
REFERENCE_4 blank
REFERENCE_5 Invoice Number
REFERENCE_6 AP Invoices
REFERENCE_7 set of books id
REFERENCE_8 blank
REFERENCE_9 blank
REFERENCE_10 For Expense lines, this is blank (For Liabilities,
"Liability")
For Payments:
REFERENCE_1 Vendor Name
REFERENCE_2 Invoice id
REFERENCE_3 Check id
REFERENCE_4 Check number
REFERENCE_5 Invoice Number
REFERENCE_6 AP Payments
REFERENCE_7 Set of books id
REFERENCE_8 Invoice Distribution Line Number
REFERENCE_9 Invoice payment id
REFERENCE_10 Liability
Cash
Discount
Exchange Gain
Exchange Loss
Future Pay
These columns correspond exactly to REFERENCE21-REFERENCE30 in GL_INTERFACE.
This is only effective if you are posting using the Audit method for the type
of transaction you are doing (see the AP - GL post initiation form for
details of possible transactions and whether you can choose between Audit and
Non-Audit posting). For the Journal Source you are importing, you must have
set the Import Journal References field to Yes (see GL \Nav Setup Journal
Sources form). If you post to GL in summary, then only REFERENCE_6,
REFERENCE_7
and, if applicable, REFERENCE_10 will be populated in GL_IMPORT_REFERENCES.
Hi,
We need to track the journal enteries from GL to AP.
We have detail posting into GL
We have Import references checked for the Payables
source in GL.
We worked our was through the GL_IMPORT_REFERENCE table and found
out that the invoice id is stored in the reference columns.
We would appreciate if anyone could help us with this issue
Thanks in advance
Murali
Sent: Tuesday, April 06, 1999 9:23 AM
Subject: AP: discounts!!
I am trying to pay an invoice ahead of the scheduled due
date,
the system prompts me whether to take all discounts related to the
invoice. If I click ok, it automatically takes the entire invoice
amount as discounts and pays a $0 check. When i go to pay it again,
the
prompt displays that it has been paid in full.
The same thing happens if i pay partial. The invoice
amount-partial payment amount is taken as discount. I checked the
payment terms attached to the invoice and it does not have any
discount
lines defined!. Any suggestions??
I called Oracle and they have not been able to identify the
problem!
Paddy
From: "Jubinville, Melanie -ND" jubinvillem@espn.com
Subject: RE: discounts!!
When you check on the invoice, if discount terms are attached to it you will
not see any distribution lines for discount. It does not create
distribution lines visible on your form.
I would suggest the you verify if a Discount Terms was attached to that
particular invoice instead of looking at the distribution lines.
Run this little SQL to see the terms attached to your invoice:
SQL select at.name
2 from ap_terms at,
3 ap_invoices_all ai
4 where at.term_idai.terms_id
5 and ai.invoice_id (find your invoice id first)
6 /
Melanie Jubinville
Oracle Consultant
Conley & Canitano Associates
1-888-CCAI-1TH Ext.5542
From: Appanaboyina_Kishore Appanaboyina_Kishore@hts.satyam.com
Subject: RE: discounts!!
Hi Paddy,
In the payment terms, check if the discount percent has been given as 100%.
Otherwise, i don't see any reason why you sh'd face this prob.
Kishore
On Behalf Of Dan Depies
Sent: Wednesday, April 07, 1999 11:56 AM
Subject: AP: One Time Supplier Functionality
Within Oracle Payables, is there any functionality with the one-time
supplier flag. We would like to create one generic supplier and cut checks
to that supplier while filling the appropriate name and address information.
We don't want any of the supplier history other than the name/address of who
the check was cut to. There are several thousands of these checks that go
out each month.
Thanks in advance,
Dan Depies
ProVantage
414-641-3777
From: "Joe Maliszewski" jmaliszewski@csi.com
Subject: RE: One Time Supplier Functionality
No, that flag does absolutely nothing.
If you do that what is the Supplier's Name? It will print on the check.
What version are you on. There is some expanded functionality in 11. But I
do not think it will help you.
Joe Maliszewski
Consultant
jmaliszewski@csi.com
From: Oracle - Kathy Farmer oracleadmin@co.scott.mn.us
Subject: RE: One Time Supplier Functionality
If you create a supplier and have each of the names and addresses as
individual sites under that supplier, you might be able to change your check
printing script to print the name of the site instead of the name of the
supplier on the check. On the other hand, if you do that, all your pay
sites for all suppliers would have to have the supplier name you want to see
on the check. We talked about doing this for a similar situation and came to
the conclusion that the work it would take to change all the site names for
other suppliers and modify the check printing format would not be worth it.
I agree that the one-time supplier flag does nothing for you functionally.
I think it's suppose to assist in purging vendors.
Kathy Farmer
Scott County
From: jmcdonald@princesscruises.com (Jeanne R Mcdonald)
Subject: Re: One Time Supplier Functionality
You wouldn't have to really go that far ("all your paysites for all suppliers
would have to have the supplier name you want to see on the check")
Why couldn't you just set up one vendor (call him, for example, ONETIME) and,
since your modifying your print routine anyway, only do the mod (print the site
name as the vendor name ) when the vendor is ONETIME.
(Actually I'm plagarizing a suggestion for factoring that came across the
list earlier)
Which isn't to say that I don't have other concerns about the strategy
jeanne!
Sent: Monday, April 12, 1999 12:08 PM
Subject: AP Audit Report
Hi everyone,
Our users want a report for identifying duplicate invoices paid for the same
vendor, searching for similar invoice number and amount.
Any idea on how we should create that report? Anything would be
appreciated.
Thanks
Melanie Jubinville
Oracle Consultant for ESPN
Conley & Canitano Associates
860-766-2000 ext.3561
From: Mike Dennis mdennis@mdp.com
Subject: Re: AP Audit Report
We built a report like this through our report writer, Cognos Impromptu.
We built an alias table for AP_INVOICES_ALL and compared the invoices from
the original table against the alias table and excluded those where the
invoice_id was the same. Our users run the report with a date range so
they don't have to review several years worth of history.
Mike Dennis x2554
From: "Mark Nelson" mnelson_gs@hotmail.com
Cc: jubinvillem@espn.com
Subject: RE: AP Audit Reports
The standard Potential Duplicate Payment report should satisfy the
requirement.
If you are looking for additional Audit Reports, check out Tickmark
Solutions at www.tickmark.com
They offer audit, control and system management reporting software
for the Oracle Applications.
Mark Nelson
From: "Mark Nelson" mnelson_gs@hotmail.com
Cc: RJagannathan@prcnet.com
Subject: RE: AP Audit Reports
The exact names of the duplicate invoice reports supplied by Oracle
Applications are:
Invoice Audit Listing
Invoice Audit Report
both reports identify potential duplicate invoices
Please read the manual...
If you are looking for more reporting in this area - check out
www.tickmark.com
Mark Nelson
Is anyone using the Combined Accounting method that is mentioned in the AP
user's manual? Is it true that only AP can point to two set of books(primary
& secondary)
and the other Oracle modules can only point to the primary set of books??
We are installing Oracle Grants Management, Projects, AP/PO, AR, HR and LDM
v 11.0.2. Any info on the subject would be appreciated. Thanks!!
From: "Newitt, Mike/COR" mnewitt@CH2M.com
Cc: "'aguilami@rf.suny.edu'" aguilami@rf.suny.edu
Subject: Re: Combined Accounting
We are using the combined basis accounting feature. Our primary set of books
is an accrual book and our secondary set of books is a cash book. Your
understanding of the standard use of this feature is correct. We have
customized our applications to automate the import of journal entries from
sources other than AP (all other apps that post to GL plus manual entries)
into the secondary set of books.
Sent: Friday, July 02, 1999 9:44 AM
Subject: AP: Web Employees in 10.7
Folks,
Does anyone know if any 'release' of 10.7 Web Employees will allow the
employee to code project related information that will initiate the
Project Related Supplier Invoice flexbuilder routines when entered, and
also keep the project/task/e-type information through the Import? I
know this functionality is available in the 11.5/11i release, but I
have gotten conflicting information on whether or not it is available
on a 10.7 platform.
Regards,
Bill Bertololotti
billbert@ems.att.com
732-457-5272
From: "Hendrix, Deborah A." HendrixDA@bvsg.com
Subject: RE: Web Employees in 10.7
It is available in Release 11.0.2 or higher.
Debbie Hendrix
BV Solutions Group, A Black & Veatch Company
913-458-8519
hendrixda@bvsg.com
From: partha.kanjilal@in.pwcglobal.com
Subject: URGENT
Hi All APPS-GURUS
I am faced with some errors with MRC in AP. When I am
using the MRC
Payables Manager Responsibility I am unable to post to
GL and alsoquery.
The error says FRM 40735........table or view does not
exist.
I have completed all mandatory set up including
assignment of profileoptions.
The AP_SYSTEM_PARAMS_ALL_MRC_V is not updated with the
correct
Set_of_books_id. The set_of_books_id should be 2 but
it is taking -99.
Note : I have already applied the prereqisites and the
740124 series ofMRC
patches and ran the adadmin for maintaining MRC and
compilation of APPS
schema.I have creayed synonyms for all the tables of
AP for APPS_MRCand
granted ALL previlages for the same.
Thanx in
advanceregardsPartha
From: Murali Avanamuthu mavanamuthu@yahoo.com
Cc: partha.kanjilal@in.pwcglobal.com
Subject: Re: AP MRC problem
Hi,
Though I'ven't seen this error, it sounds like some of
your views in APPS_MRC schema isn't right. Look for
the status of views starting with AP% under APPS_MRC.
If you're on 11.0.2, then the latest MRC cumulative
mini-pack is 874475. You might want to review this
patch if it's applicable to you.
In our 11.0.2 installation, we had minimal trouble
with AP MRC. But AR MRC is a whole different story.
Good luck,
Murali
From: Chetan Banglorewala ChetanB@allied-medical.co.ae
Subject: Re- Automatic spreading of prepaid expenses over a period
We have a requirement to automatically accrue expenses on a monthly basis.
Say for eg a invoice is received for Dhs 1200 should be debited to Prepaid
expenses and Dhs 100 to be automatically charged to an expense account on a
monthly basis.
I have thought of a workaround solution for this using the AP & FA module as
under,
1. Create a Asset Category for Prepaid Expenses. Define the asset cost
account, clearing account and accumulated depreciation as the Same account
(Prepaid Expense account). Record the expense to the prepaid expense
account, used as clearing account in the Asset Category. This will mark it
as an asset item and can be transferred to FA using mass addition.
2. Based on the number of months to spread the expense, the
depreciation method can be selected.
3. Based on the expense account to debit, the distribution expense can
be selected.
4. When depreciation is run, the expenses will be automatically charged
and prepaid expense account credited.
Shall appreciate other workarounds and ideas, used by experts.
Best regards,
Chetan Banglorewala
From: Alex Waddell alex.waddell@shaw.ca
Subject: RE: Re- Automatic spreading of prepaid expenses over a period
Another option would be to future date distribution lines on your invoice.
You will have to open up your AP periods but as long as you don't open up
your GL periods then your prepaids won't post through to the ledger until
the month is opened. In your example do 12 lines of coding, one for each
month.
There are two small issues with this: If you are using the Payable Trial
Balance report to reconcile your GL to AP then you will find problems as
this report does not handle future dated items properly.
Also, your accounting may be slightly odd:
January
dr: exp 100
cr: ap 100
February
dr: exp 100
cr: ap 100
assume inv is paid in February:
dr: ap 1200
cr: cash 1200
as a result your accounts payable is overstated by 1100 dollars the first
month, 1000 the next, 900 the next, et cetera until it all clears out.
In other words instead of carrying your prepaids as an asset they would be
appearing as debit within your payables liability. Since prepaids likely
make up a very small part of your business, you can consider this issue
immaterial.
Sure saves time from having to have accountants amortise these sort of
expenses by journal entry and the hassle of reconciling prepaid accounts.
Cheers
Alex
Alex Waddell
Financial System Administrator
Shaw Communications Inc.
Phone: (403) 750-4709
Fax: (403) 750-4505
From: "Trang T. Vinh" tvinht@yahoo.com
Subject: AP Holds on AP Interface Table
Hello AP Gurus!
Is there a place to designate an 'invoice on hold' on
the AP_INVOICES_INTERFACE table? I looked at the TRMs
and can't seem to find it?!?!?
Thanks for you help.
Trang T. Vinh
Principal Consultant
The Visionary Group, Inc.
Phone: 619.248.3490
tvinht@yahoo.com
From: Andy Schindler aschindl@yahoo.com
Subject: Re: AP Holds on AP Interface Table
In 10.7 using the XpenseXpress interface you can.
Populate column HOLD_LOOKUP_CODE in the table
AP_EXPENSE_REPORT_HEADERS_ALL. You are only allowed 1
hold per invoice.
Andy Schindler
NRC, Inc.
From: "Trang T. Vinh" tvinht@yahoo.com
Subject: Re: AP Holds on AP Interface Table
Andy, thanks for you help. One more question: do you
know if a similar interface exists with release 11?
From: Andy Schindler aschindl@yahoo.com
Subject: Re: AP Holds on AP Interface Table
Trang, I am puzzled as to why Oracle would drop such a
useful feature from it's interface.
As a workaround, you could tag an attribute column
with the hold name and use WorkFlow to apply the hold
following the upload.
Good luck.
Andy Schindler
From: "Murali Parthasarathy" mparthas15@hotmail.com
Subject: AP TRAIL BALANCE TABLE
We are trying to get all the payments pending as of 22-JAN-99. We have
based our query on AP_INVOICE_PAYMENTS and AP_PAYMENT_SCHEDULES.
We beleive that this information can be got from the AP_TRAIL_BALANCE
table. Our question is WHEN IS THE AP_TRAIL_BALANCE TABLE getting
populated. Your ideas are most welcome.
Thanks in advance
Murali
From: Dinesh Chandra dchandra@usa.net
Subject: Re: AP TRAIL BALANCE TABLE
Hi Murali,
I think that AP_TRIAL_BALANCE table is populated when AP Invoices and Payments
are transferred to GL.
Cheers
Dinesh Chandra
From: K Tuggle ktuggle@teamisi.com
Subject: A/P Payables Options Setup
Once you have selected the Automatic Offset Method of "None" in the
Payables Options, Accounting region, is there a way to change the
Automatic Offset Method to "Account" or "Balancing"?
Kelly Tuggle
ktuggle@teamisi.com
From: "McShane, Chris" Chris.McShane@glenayre.com
Subject: RE: A/P Payables Options Setup
Not through the application.
From: Mike Dennis mdennis@mdp.com
Subject: AP: One solution to AP account out of balance
All:
We have discovered one case where the accounts payable liability accounts
become out of balance. I hope this will help others.
First our setup:
1. We have one set of books
2. We are not using the multi-org functionality
3. We have several business units, each of which has an accounts payable
liability account. When we key invoices, we change the default account on
the invoice header to the appropriate business unit.
4. We do not use Automatic Offsetting because of some constraints that the
feature would have caused.
5. 10.7 SC prod 16.1. HP-UX 10.20. Database version 7.3.4.
When reconciling the accounts payable liability account (general ledger vs.
the AP trial balance report), we found that two of our business units did
not reconcile. One was off $7,815.50 debit. The other off $7,815.50
credit. After reviewing the timing of keying, check runs, and posting to
ledger, we ran some tests in our development system. We found that we could
replicate this problem if the following steps were taken:
1. Invoice was keyed with one business unit liability account. Invoice was
approved. Entry clerk continued to key other invoices. The invoice had
terms of "upon receipt". The payment would cut with the next payment batch.
2. Payment clerk began payment batch (which included the invoice in step
1). The select process completed. The build process completed. The
formatting process completed.
3. The entry clerk discovers that the incorrect liability account was used
and modifies the field to the appropriate account. The field is not
protected.
4. The payment clerk prints the checks and confirms the batch.
5. The "Transfer to GL" program is run for distributions and payments. One
side of the entry will be to the first account. The other side will be to
the second account.
Internally, we have stopped clerks from changing data during payment batch
runs (particularly for those invoices which will be in the payment batch!).
To correct the out of balance condition, we created a well-documented
journal entry for our auditors.
Good luck all!
Mike Dennis
Financial Systems Administrator
Meredith Corporation
mdennis@mdp.com