Auto Invoice Question
- From: "Sweetser, Joe" <JSweetser@xxxxxxxx>
- To: <ora-apps-dba@xxxxxxxxxxxxx>
- Date: Tue, 16 Jun 2009 12:26:39 -0600
Forgive my ignorance as I know next to nothing about accounting. My
situation is this: we have a process where we use Auto Invoice (along
with other programs) to import external data into our 11.5.9 (I know, I
know!) E-Biz environment. Some of this data is what they call bulk
payments - multiple (somewhat related, somewhat unrelated) payments on a
single invoice for a single vendor. The first time this type of invoice
comes through it processes correctly on the Financials side. If another
one comes through from the same vendor with the same invoice, the record
is rejected due to duplicate invoice number.
It seems to me the way to handle this situation is with line
items/numbers but I do not see a place to store that information in the
ap_invoices_interface table. Is there where a flexfield makes sense?
In other words, use a descriptive flexfield to store each individual
line number on the invoice. And, if that's the case, is there a way to
make the Auto Invoice aware of that flexfield? I am not looking for a
technical answer here, just if I am on the right path to solving this
issue.
Any/all comments/suggestions/stock tips welcome.
Thanks in advance,
-joe
Other related posts:
