Hi,
1.In which table, we will capture the PO_NUMBER in Payables moudle
(AP).
2. How to identify the payment is done or not(front end) for po_NUMBER in Purchasing module
Regards,
Yknev
PO-NUMBER
-
- Posts: 463
- Joined: Thu Nov 09, 2006 4:50 pm
- Location: India
- Contact:
Dear Yknev,
Please Check AP_INVOICES_ALL table or AP_INVOICE_LINES_ALL or AP_INVOICE_DISTRIBUTIONS_ALL, one among these three tables, you can find the PO number details if the invoice is matched with the Purchase Order.
Also from Purchasing Module, at the shipment screen / Distribution Screen, keep your cursor and from the FOLDER menu, select show fields, and select Amount Billed, Amount Received or Delivered. These columns would reflect the invoice amount of the PO and the amount paid for that PO.
Regards,
Karthikeyan
Please Check AP_INVOICES_ALL table or AP_INVOICE_LINES_ALL or AP_INVOICE_DISTRIBUTIONS_ALL, one among these three tables, you can find the PO number details if the invoice is matched with the Purchase Order.
Also from Purchasing Module, at the shipment screen / Distribution Screen, keep your cursor and from the FOLDER menu, select show fields, and select Amount Billed, Amount Received or Delivered. These columns would reflect the invoice amount of the PO and the amount paid for that PO.
Regards,
Karthikeyan
-
- Posts: 463
- Joined: Thu Nov 09, 2006 4:50 pm
- Location: India
- Contact:
Dear Yknev,
PO_HEADER_ID is available in the AP_INVOICES_ALL, AP_INVOICE_LINES_ALL table.
Based on the header_id, you can derive the PO number, there are many views available as well in AP tables. I am not technically proficient to fetch the information required, so i am directing you on the correct lines ..
Regards,
Karthikeyan
PO_HEADER_ID is available in the AP_INVOICES_ALL, AP_INVOICE_LINES_ALL table.
Based on the header_id, you can derive the PO number, there are many views available as well in AP tables. I am not technically proficient to fetch the information required, so i am directing you on the correct lines ..
Regards,
Karthikeyan
Who is online
Users browsing this forum: No registered users and 2 guests