Procure to Pay cycle-For techies Reference

Procure to Pay cycle covers the following steps:

1. Creating Requisition:

This depends on internal good requirement.This will be raised by an employee only. 

• Inter Org  transfer-From one inventory to other inventory
• Raising Purchase order-No stock supplier should provide

Important tables:

PO_REQUISITION_HEADERS_ALL

PO_REQUISITION_LINES_ALL

PO_REQ_DISTRIBUTIONS_ALL.

Joins can be made using REQUISITION_HEADER_ID and REQUISITION_LINE_ID 

2. Creating Purchase Order

• PO_HEADERS_ALL
• PO_LINES_ALL
• PO_DISTRIBUTIONS_ALL (REQ_HEADER_REFERENCE_NUM in Distributions table is the Requisition number for this PO)
• PO_LINE_LOCATIONS_ALL

The join columns are

header_id and line_id 

3. Creating Receipt

Receipt Tables are:

RCV_SHIPMENT_HEADERS

RCV_SHIPMENT_LINES (Lines Table has PO_HEADER_ID)

4. Creating Invoice in AP
Once the goods is Recieved, We will pay the vendor.Raise an invoice in AP

Invoice Tables:

AP_INVOICES_ALL

AP_INVOICE_DISTRIBUTIONS_ALL

Joins made using Invoice_id

Accounting Entries Tables:

AP_ACCOUNTING_EVENTS_ALL

AP_AE_HEADERS_ALL

AP_AE_LINES_ALL

Joins made using Accounting_event_id and ae_header_id

5. Paying the Invoice

Payment Tables:

AP_INVOICE_PAYMENTS_ALL

columns can be joined
invoice_id,accounting_event_id 

AP_PAYMENT_SCHEDULES_ALL:invoice_id

AP_CHECKS_ALL:doc_seq_id is the invoice number

AP_CHECK_FORMATS

AP_BANK_ACCOUNTS_ALL

AP_BANK_BRANCHES

AP_TERMS

6. Transfer, Import and Post to GL