Invoice Header Dates
mohan murali wrote:
Hi Everybody,
We are on AP Rel.11.0.3. I have the following problem
and need input from you.
As per the set up 'GL Date' of an Invoice Defaults to
the 'Invoice Date'.User will have an option to
override the GL date if required.
Here is the problem:
I entered an invoice today (30-SEP-99) and the GL date
defaulted to 30-SEP-99 as per the setup. I changed the
GL date to 10-OCT-99 , since the actual expense should
be booked to Oct period. I completed the distribution
lines and the line gl date is also
10-OCT-99. I approved this invoice and ran the
Payables transfer to gl process with pay through date
as 10-OCT-99. The process ran sucessfully and invoice
lines were posted to Oct-99 period.
But when went back to the same invoice, the GL Date of
the invoice header is now showing as 30-SEP-99(invoice
date) instead of 10-OCT-99(gl date previous to posting
process). Distribution lines gl date is still
10-OCT-99.
I am wondering is this standard functionality or a
bug? Is this supposed to change back to the invoice
date? If yes, what is the logic behind that?
Your input is highly appreciated.
Thanks in advance.
Mohana
From: "Anna Barbieri" abarbieri@glenraven.com
Reply-To: oraapps-l@cpa.qc.ca
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: Re: GL Date on AP Invoice ????
Date: Fri, 1 Oct 1999 06:15:26 -0400 (EDT)
Mohan
This is standard functionality. If you go in and look at the invoice
today it will have todays date in the invoice header. Oracle reason is
you can have multiple date at the distribution line level and that is
what it post's by. The date at the invoice header is meaningless.
Anna
Date: Thu, 7 Oct 1999 14:09:18 -0400
From: Darlene_D_Dougherty@CORP.CNG.COM
To: oraapps-l@cpa.qc.ca
Subject: Re: GL Date on AP Invoice ????
This is a known problem with A/P,,, according to the a/p enhancement session
I
went to at OAUG it was fixed in rel 11i
Darlene
Vendors in one SOB and multiple Legal Entities
From: liza@instructor.net [mailto:liza@instructor.net]
Sent: Friday, October 15, 1999 5:05 AM
To: Multiple recipients of list
Subject: Vendors in One SOB, But Multiple GREs
Has anyone out there encountered the same circumstance where there is only
one SOB, but there are multiple legal entities - how do you handle the
default liability account at the vendor level to be different for each legal
entity.
Thanks for your input,
Date: Fri, 15 Oct 1999 08:47:38 -0600
From: kbrown@es.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Vendors in One SOB, But Multiple GREs
Manually change them. We have two legal entities on our set of books.
Corporate and other. We have our 'other' entity add their vendors with a
unique character preceding the vendor & customer names (in our case we
selected the asterisk *) and then we have to change the company code on the
liability account as they're using the same liability account as Corporate
with the exception of the company number. Because this other Entity does
not have that many vendors or customers it has not been a big issue. We
make the changes through the forms. We can also query all of these 'other'
vendors and customers and check to see that their accounts are set to the
correct company liability account.
Kristie
Encryption of check files
From: Steve Richmeier [mailto:s_richmeier@yahoo.com]
Sent: Friday, October 15, 1999 06:54
To: Multiple recipients of list
Subject: AP Encryption of check files
Hello,
We are installing 11.03 for the client and they are
going to be on a WAN with their server in Chicago and
printing checks in Dallas.
Client has stated that the check file needs to be
encrypted so no one can open or print their check
file.
I don't need to debate why they want it but would like
to know if anyone has had to do this and what the best
and easiest way to do it would be.
Thank you for your assistance,
Steve
Date: Fri, 15 Oct 1999 09:00:54 -0600
From: "Kossmann, Bill" BKossmann@mail.dthr.ab.ca
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: AP Encryption of check files
It doesn't necessarily have to be encrypted, does it? Why not put it into a
directory (or CHMOD/CHOWN the file) so that only the client can access it?
Failing that, you could use encryption at the OS level. Unix' CRYPT
facility--admittedly very weak--might work for you; or you can try a
stronger cryptosystem. Somehow I have the impression that Oracle has an
encryption library (but I could easily be mistaken on this).
Bill
Vendor Import Query 2
From: RADHA KRISHNAN[SMTP:radha_rk@hotmail.com]
Reply To: oraapps-l@cpa.qc.ca
Sent: Friday, October 15, 1999 7:08 AM
To: Multiple recipients of list
Subject: Vendor Data migration- AP
Hello Friends,
We are on rel 1102 on NT with GL,AR and AP under implementation.
As part of Data Migration from Legacy system, the vendor data needs
to be migrated to PO_VENDORS table.
We have written a procedure to load the data from source application
to po_vendors and po_vendors_sites all tables and values for all 'not null
columns' in these tables and addl ref information as reqd have been
populated.
The data when loaded moves to po_vendors table but is not viewable from
supplier inquiry form. Since errors can not be identified in a data
transfer
of this nature, we would like to invite guidance from this august forum.
TIA,
Radhakrishnan
Date: Fri, 15 Oct 1999 12:16:30 -0400
From: "Annamaneni, Hanumantha" Hanumantha.Annamaneni@alcoa.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Vendor Data migration- AP
There are a couple of columns that need to be populated:
TERMS_DATE_BASIS (I used the value 'Invoice')
PAY_DATE_BASIS_LOOKUP_CODE (Either 'DUE' or 'DISCOUNT')
Hanumanth
Date: Fri, 15 Oct 1999 13:18:02 -0700 (PDT)
From: Rajesh S sraj1999@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Vendor Data migration- AP
Hi Radhakrishnan
I too had similar problem.
The reason the vendors are not visible is that you
need to populate even the not required columns like
the ones ending with _flag, _code (in PO_vendors)etc.
check once again
regards
Rajesh
Date: Sun, 17 Oct 1999 12:26:11 +0200
From: Nimrod Bar-Guy brnimrod@pcit-ltd.co.il
To: "Oraapps (E-mail)" oraapps-l@cpa.qc.ca
Subject: FW: FW: Vendor Data migration- AP
Hi Radhakrishnan,
the best way to find out the missing data is to insert a new vendor using the Apps.
and then compare the data in the tables.
Nimrod
Date: Sun, 17 Oct 1999 19:39:05 -0700
From: "Mohan Iyer" miyer@fortuna.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Vendor Data migration- AP
You may be missing the org_id column for the vendor-sites.
The PO_VENDORS table is not stripped and so does not need the org_id,
however the PO_VENDOR_SITES_ALL table is stripped and needs an org_id value.
This s assuming you are on multi-org.
If you are not then it would require some more information before it would
be possible to resolve the issue.
Thanks,
Mohan Iyer
Financials Consultant
Sunnyvale, CA
EFT using ClieOp 02 format
From: oraapps-l@cpa.qc.ca [mailto:oraapps-l@cpa.qc.ca]On Behalf Of
Puchniak, Stan
Sent: Saturday, October 16, 1999 1:15 AM
To: Multiple recipients of list
Subject: AP: EFT using ClieOp 02 format
Hello friends,
It is nice to see the listserver up again. I would appreciate your
assistance. One of our companies would like to produce EFT files using the
ClieOp 02 format. Payments are denominated in DEM, FRF, NLG and USD. The
documentation provided by the financial institution is difficult to follow.
The financial institution is ING. Any information or suggestions would be
greatly appreciated. Specifically, what is the payment format changes
required; and, how the various currencies are handled. The DEM, FRF and NLG
payments all come from the same account. There is a separate account for
USD.
We are on 10.7 character with HP-UX. Our systems are located in Canada and
our subsidiary is located in The Netherlands.
Cheers,
Stan
Date: Sun, 17 Oct 1999 10:32:38 +0200
From: "Victor Chang" vchang@obaps.com
To: oraapps-l@cpa.qc.ca
Subject: RE: EFT using ClieOp 02 format
Hello Stan,
Yoou need the dutch localization + KSI software.
The dutch localization will generate an EFT file and the KSI software will
transform this EFT file in a CLIEOP02 compliant format.
KSI is a dutch company based in Nieuwegein. Please make sure that your
Oracle release is covered by them.
Good luck
Victor Chang
Holds manual - unable to release
Date: Sun, 17 Oct 1999 13:04:36 -0600
From: "Rosy Virani" Rosy.Virani@CRHA-Health.Ab.Ca
To: "oraapps-l@cpa.qc.ca" oraapps-l@cpa.qc.ca
Subject: INVOICE HOLD NOT RELEASING
A user placed holds manually. These holds should only be placed by the
system. These holds are now stuck. How do you release maual holds? It
gives an error message when you try to manually release a hold.
Any assistance appreciated.
Rosy
Date: Sun, 17 Oct 1999 14:24:47 -0500
From: "Mike Dennis" mdennis@mdp.com
To: oraapps-l@cpa.qc.ca
Subject: Re: INVOICE HOLD NOT RELEASING
You might try a quick release of the hold. On 10.7SC:
1. Query the invoice
2. Click on the Actions button
3. Check the Release Holds checkbox.
4. Choose "All" for the Hold Name if you want to release everything, or
choose the specific hold name you are trying to release.
5. Select a Release Name. If you chose, "All" holds, the release name
in the list of values is "Holds Quick Released".
6. Click OK button.
I hope this helps you.
Mike Dennis
Financial Systems Administrator
Meredith Corporation
EFT - options
From: Michael Porter [mailto:MPorter@pgahq.com]
Sent: Tuesday, October 19, 1999 5:59 AM
To: Multiple recipients of list
Subject: EFT out of Oracle AP? Options?
We are looking at paying employees travel and expenses via EFT to their
bank. We are on 10.7/16.1, DB 7.3.4.4 (AIX). It looks as though Oracle
itself can handle this task (at least from the AP users manual; we don't
understand the prerequisites though...). We have also been given the
sales pitch from BottomLine that they have software, albeit expensive,
that will handle this too.
Has anybody had experiences with either, or even better yet both? Please
share some info with us and/or point us to some info or white papers.
TIA,
Mike
Date: Tue, 19 Oct 1999 11:56:17 -0600
From: Alex Waddell alex.waddell@shaw.ca
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: EFT out of Oracle AP? Options?
Mike
A good place to start would be with your bank. Check with them on the
options for transmitting files. They can likely provide you with file specs
and you can build your own code to create "Payment Program". We launch a SQL
script using a payment format that we designed. The output file is then
transferred to server where we can pick it up with bank-provided software
and transmit them the EFT directions.
I've never heard of Bottomline, they may be fantastic. But I personally like
to stay away from third party bolt-ons for such minor projects. It will
likely involve costly consulting and support fees. If you don't have someone
in house that can write SQL, you might as well spend the money on a
consultant to do that instead and you can "own" your own solution.
Feel free to ask if you need further advice.
Alex Waddell
Financial System Administrator
Shaw Communications Inc.
Phone: (403) 750-4709
Fax: (403) 750-4505
Date: Tue, 19 Oct 1999 15:41:53 -0400
From: "Michael Porter" MPorter@pgahq.com
To: oraapps-l@cpa.qc.ca
Subject: Re: RE: EFT out of Oracle AP? Options?
You took the thoughts right out of our skull!!! The Bottomline bolt-on IS
VERY expensive and although we don't have a lot of power SQL writers, we
feel we should be able to handle it - hopefully.
We have a spec from our bank on the file layout. The transmitting part is
not defined so that will have to be addressed.
Thanks again,
Mike
Date: Wed, 20 Oct 1999 13:55:23 -0400
From: sbradley@sprynet.com
To: oraapps-l@cpa.qc.ca
Subject: Re: EFT out of Oracle AP? Options?
This topic appears frequently here. Searching the archives you will find
most people modify the Oracle delivered BACH's payment to meet the NACHA
format which is the standard used by most US Banks.
I feel the more difficult issue is notification to the employees. Most
employees want to know the deposit has been made. With checks they get
feedback. With EFT they have to call the bank or AP department to see if it
happened. Many companies print remittances and snail mail them to the
employees. This does not reduce any work effort in the AP department. The
ideal solution is to have the EFT process also send the employees an e-mail
notifying them of the deposit amount and date.
Respectfully,
Steve Bradley, CPA
OASIS Consulting Group, Inc.
Office 404-352-8387
Fax 503-218-9747
Pager 888-912-2569
Date: Wed, 20 Oct 1999 20:33:39 -0700
From: "Mohan Iyer" miyer@fortuna.com
To: oraapps-l@cpa.qc.ca
Subject: RE: EFT out of Oracle AP? Options?
You need to only write a program to format the payment file that you would
send to the bank. That would be the limit of your customization or extra
effort (cost).
Rest all the setups etc. are part of the standard Oracle AP module.
Unfortunately they do not have a seeded program that can be used in the US
banking environment, they have them for a lot of European countries though.
I have implemented this and it is not a big deal. And you actually do not
need to spend any money other than the developer costs, and probably the
cost for a design doc.
Thanks,
Mohan Iyer
Financials Consultant
Sunnyvale, CA
1099 reporting for multi-state
Date: Tue, 19 Oct 1999 16:39:44 -0400
From: kewishls@mindspring.com
To: oraapps-l@cpa.qc.ca
Subject: 1099 reporting
Hi AP gurus,
CAn someone shed some light on the following :-
Does Oracle provide functionality to effectively use the 1099 Forms report to handle
multi-state 1099 hard-copy reporting? It appears that Oracle consolidates all 1099 Payables
activity into one 'Tax Reporting Site' per form, even if there is activity in multiple sites
across multiple states.
The report therefore does not produce a single 1099 form by vendor that is admissable to a
specific state.
Any insites and workaround solutions would be gratefully received!
We're on 10.7 PROD16SC Sun Solaris v.5
TIA
Louise Kewish
Senior Principal - Manufacturing & Distribution Apps
TSC
Dallas, TX
Date: Wed, 20 Oct 1999 08:25:35 -0700
From: Janet Elmore elmore1@llnl.gov
To: oraapps-l@cpa.qc.ca
Subject: Re: 1099 reporting
Louise,
I have not been in the full loop of our 1099 reporting. However I do know
the person that is working on ours had to do some modifications.
We are going to do combined filing this year. From what I understand if
the state is registered as a combined filing state then separate 1099 forms
will print. However all the states that aren't participating will get
combined on one 1099 form per vendor as there is no region code set up.
I'm not sure if this happened automatically or if she had to add a group by
for the region code in the 1099 form code.
We created a separate report for the user to show the data and there were
very few vendors that we made more than 1 reportable payment to that didn't
have a region code. So the users are going to type the few 1099's that met
this condition.
I believe we made some other minor modifications also. I don't believe the
state abbreviation showed up on the form so that was added.
Hope this gives you some ideas. Sorry I couldn't be more specific.
Bottomline is the package falls short for 1099 reporting to multiple states.
Janet Elmore
Lawrence Livermore Nat'l Lab
Hold not clearing even after cancelling invoice
From: Bob Ross [mailto:rross@siumed.edu]
Sent: Tuesday, October 26, 1999 3:35 PM
To: Multiple recipients of list
Subject: AP: Holds - Liab Acct Invalid
I have an invoice on this type of hold. Tried to cancel to reverse the
incorrect distribution lines. The invoice is now for $0.00 but remains
on hold and appears on the holds report. The problem was one segment of
the accounting flexfield (AFF) had an incorrect value entered. That
value is now no longer valid.
How do I finish canceling the invoice? We were able to input the correct
AFF value on a new invoice and I would like to finish canceling the
incorrect invoice so it drops from the holds report.
Thanks
Bob
Subject: RE: Holds - Liab Acct Invalid
Author: oraapps-l@cpa.qc.ca at iss1
Date: 10/26/1999 4:24 PM
Can you re-instate the flexfield, approve the req, and then re-invalidate
the flexfield?
Andrew R. Farber
Consumers Union of U.S., Inc.
914/378-2531
Date: Wed, 27 Oct 1999 17:21:20 +0200
From: Anand TONDAPU anand.tondapu@gemplus.com
To: oraapps-l@cpa.qc.ca
Subject: Re[2]: Holds - Liab Acct Invalid
How about correcting the dist_code_combination_id value in
ap_invoice_distributions table?
No more zero balance lines in AP Trial Balance
Date: Fri, 29 Oct 1999 13:18:25 -0500
From: "Uptmore, Chris" uptmorec@kci1.com
To: oraapps-l@cpa.qc.ca
Cc: dmakked@deltadentalva.com, Warren.Orlandi@apra.gov.au
Subject: RE: ARTB or APTB (no more zero-balance lines!)
I just found the latest APTB patch 852484 excludes the
"zero-balance lines", which makes the report less than
1/3 as long!!
This new APTB version 80.47 is also included in the latest
AP megaPatchset-T (replaced 80.46 from AP-Q)
We've been looking for this for over a year, so I thought others
might be interested to know this.
FYI,
Chris
Payment made in Non Functional currency without exchange rate info
William.Gaston@infores.com
Good morning all from snowy Chicago!
We are on 10.7SC.
A Payables clerk created a Quick Check for a
Canadian dollars payment without entering an
exchange rate.
They put the exchange type as Corporate, which
then
wouldn't allow a rate to be entered.
Now, the AP Journal Entry Exception Report shows
an
error for this entry. It posted to Payables, but
AP cannot close, and they do not want to sweep
this
into Feb. Also, the entry was not transferred to
GL.
Any ideas how we can correct this?
As always, any help is greatly appreciated.
Bill
Bill Gaston
Information Resources, Inc.
Core Business Systems
(312) 474-3171
william.gaston@infores.com
From: gramouk@yahoo.co.uk
Sent: Thursday, January 31, 2002 9:57 AM
Subject: Re: Payables Rate Problem
Run the Autorate program. It will pick up the
Exchange
rate Retrospectively.
William.Gaston@infores.com
We entered a daily rate for the type in
question,
ran AutoRate, then the
Transfer again. It worked perfectly.
Thanks,
Bill
From: mailto:milane@dc.com
Sent: Friday, February 08, 2002 8:42 AM
To: OAUGnet
Subject: RE: Payables Rate Problem
We had this issue as well, except that now one of the payments that had
been
missing a rate and been unaccounted is now accounted incorrectly.
After
running AutoRate and Payables Accounting Process the accounting lines
generated for the payment and the void have charged the converted value
of
the "CASH" entry to the "ROUNDING" account.
Anyone else have this issue? Any solutions suggested?
Michele
Subject: RE: Payables Rate Problem
From: Kishore Yalamarty TS3169@emirates.com
Date: Fri, 8 Feb 2002 13:07:57 +0400
Yes, we do have this issue. But Oracle says the issue got fixed in AP
F. We
find few transactions getting credited to rounding A/c instead of Cash
A/c.
We are now on patchset AP G.
A tar is pending with oracle on this.
Thanks
Kishore