| APPROVED INVOICE STATUS NOT FOUND [message #94669] |
Tue, 11 December 2001 04:35  |
Corey Glidden
Messages: 4
Registered: June 2000
|
Junior Member |
|
|
We are trying to write reports that find 'Approved' invoices in a batch. We are unable to locate the 'Approved' status flag. Our examination of the forms tells us that AP_INVOICES_V contains the information that we need. We are a multi-org site. We have tried running our report through the application and still cannot find the status.
Can anyone tell us how to find the approved status?
Thanks,
Corey
----------------------------------------------------------------------
|
|
|
|
|
|
| Re: APPROVED INVOICE STATUS NOT FOUND [message #94684 is a reply to message #94679] |
Fri, 21 December 2001 20:36  |
vinod srinivasan
Messages: 7
Registered: October 2001
|
Junior Member |
|
|
Hi,
U can find the status flag in AP_invoice_distributions_all
if the match_status_flag ='A' then
then the invoice is approved. And as far as my knowledge goes u will not find any transaction in ap_invoices_v . U fill find transaction only in AP_invoices_all table .
Kindly check it out and revert to me if u find any difficulty.
Regards,
vinod
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
