Page 1 of 1

interface tables for PO to AP

Posted: Wed Mar 04, 2009 6:59 am
by vannadi
Hi All,
When we crate orders and run workflow background process,the orders gets in to the interface table.Then in receivables when we run Auto invoice then they are picked from those tables to crate the transactions.

Similarly, when we create PO we get directly into the payables by entering the PO.Do we have any interface tables for the payables to pick and how are those getting triggred.
Could anyone clarify on this?
Thanks,
Venkat

Posted: Wed Mar 04, 2009 10:11 am
by gurudba
Hi Venkat,

In Payables you have to run the Payable Auto Invoice program to populate the PO's record in to AP interface table:

Table:
AP_INVOICE_INTERFACE
AP_INVOICE_LINES_INTERFACE

thanks
Gurumurthy.k

Posted: Thu Mar 05, 2009 4:17 am
by vannadi
Hi Gurumurthy,

I am sorry,but i should have mentioned the oracle version ,its R12.We don't need to run any thing to populate the PO in AP module.
It is by default which w get the PO in AP.
As far as i came to know is that there exists connecting tables between the two modules where the data is shared among the two modules.

Thanks,
Venkat

Posted: Thu Mar 05, 2009 8:17 am
by gurudba
Hi Venkat,

In that case we have a concept call Pay on Receipt.
After receiving the items from the supplier , Load invoice program will trigger automatically to push the PO's record into AP table.


thanks.
K.Gurumurthy