Hello,
 
I am trying to create a custom report and I have been unable to locate the table that ties invoices entered to POs. I'm wanting to do something like this:
 
SELECT all_invoices FROM "<some_table>"
WHERE po_applied_to = '1234'
 
After some quick looking about I found what appears to be the invoices table "BKAPINVT", but the only place I found the PO entered into this was in the description field BKAP_INVT_DESC. That description that can be modified by my employees thus not really safe to use as a key I think, as they could create a typo or change the format.  
 
I assume there has to be another table tying these two pieces of information together & I have overlooked it.
 
The end goal is really to find out when we have paid for a particular set of part_numbers. I know which POs we placed with these part numbers so knowing when a payment has been made on a PO will get me where I'm going. Realize of course that there can be several invoices on one PO so the table must have a one->many relationship somewhere.
 
Any hints on what tables to look at would be greatly appreciated.
 
Thanks,
 
Lenny
 
 
 

Lynn,
 
Thanks,  
 
I'll check into this. I have resisted most updates as what we have has worked well for us, but it may be time to do so.
 
....Just checked. No bkap_pol_invnm.
 
Thanks
 
Lenny