Procedure To Payable(P2P) Techno-Functional Follow

Overview Flow:

Requisition -> Request for quotation -> Quotation analysis -> Purchase Order -> Create Inventory Receipt -> Create Invoice -> Make payment against Invoice -> Creating Accounting -> Transfer to GL -> Post the Journal to GL

 P2P Techno - Functional Flow:

Creation of Requisition: -

SELECT * FROM po_requisition_headers_all WHERE segment1 = '10222259';

SELECT * FROM po_requistion_lines_all WHERE requisition_header_id = '905489'

SELECT * FROM po_distributions_all where distribution_id in         (624201,624202,624203,624204);

Creation of Purchase order against requisition: -

SELECT * FROM po_headers_all WHERE segment1 = '15128255';

SELECT * FROM po_lines_all WHERE po_header_id = 998860;

SELECT * FROM po_lines_locations_all WHERE po_header_id = '998860'

SELECT * FROM po_distributions_all where po_header_id = '998860'

 (po_distributions_all .req_distribution_id = po_req_distributions_all.distribution_id)

Find PO / Requisition number:

SELECT DISTINCT

       reqh.segment1 Req_Number, ph.segment1 PO_Number, ph.po_header_id

  FROM po_headers_all ph,

       po_distributions_all pos,

       po_req_distributions_all rdis,

       po_requisition_lines_all rel,

       po_requisition_headers_all reqh

 WHERE     1 = 1

       AND ph.po_header_id = pos.po_header_id

       AND pos.req_distribution_id = rdis.distribution_id

       AND rdis.requisition_line_id = rel.requisition_line_id

       AND rel.requisition_header_id = reqh.requisition_header_id

       AND rel.requisition_header_id = '905489'

Receiving against Purchase Order: -

Navigation: -  Purchase Super User -> Receiving -> Receipt

Query the PO number 

Select number lines to create the receipt, enter the quantity, sub-Inventory. Next, click the ‘lot serial’ button and keen lot details, expiration date etc...,

Once click done, a receipt number will be created

SELECT * FROM rcv_shipment_headers WHERE receipt_num = '45074';

SELECT * FROM rcv_shipment_lines WHERE shipment_header_id = '869858';

SELECT * FROM rcv_transactions WHERE shipment_header_id = '869858';

Account Payable Module: -

Navigation: - Payable Super User -> Invoices -> Entry -> Invoices

Enter the po number and keen invoice amount, invoice date, invoice number, etc., 

Invoice should match /validate based on receipt, po number ..

 And click the match button, next query PO number selects the line and enter what is your purchased quantity value 

Next Click the actions button and select validate check box and press ‘Ok’ to validate the invoice

Once validate done, Status changed into ‘Needs Revalidation’       

Re – enter, Invoice amount as per the total amount value and then re-do validation again, if it validation success, status should be changed into “validate”.

Creation of Accounting & Payment:

Next action to be perform the create the accounting 

Once accounting has been successfully created. The Accounted status should be update as ‘YES’

Invoices:

SELECT * FROM ap_invoices_all WHERE invoice_num = ‘TSTINV1234’;

SELECT * FROM ap_invoice_distributions_All WHERE invoice_id = 561266;

Invoice Holds:

SELECT * FROM ap_holds_all WHERE invoice_id = 561266;

SELECT * FROM ap_holds_release_name_v WHERE RELEASE_LOOKUP_CODE = 'VARIANCE CORRECTED';

If payment button disable means, verify whether Invoice got holds or Approved status as “Required”

If it Approved Status required means, make “force Manual Approval”

Go to Action button -> select Force Approval -> okay.

Now you can verify the approval status and any holds

Payments:

 Now go Action click “Pay in Full” 

 Enter required field 

Next, transfer payment details into GL by using concurrent program - ‘Transfer Journal Entries to GL’ or “Payables Transfer to General Ledger”  

Note: ‘Transfer Journal Entries to GL’ is the common program for all the modules

Enter the ledger, end date parameters 

è View Payments

SELECT * FROM ap_invoice_payments_all WHERE Invoice_id  = 561266; --  get check_id

SELECT * FROM ap_payment_schedules_all WHERE Invoice_id  = 561266;

è Check payments

Select * from ap_checks_all WHERE Check_id in (select check_id from

ap_invoice_payments_all WHERE Invoice_id  = 561266);

è Check format

SELECT * FROM ap_check_formats;

SELECT * FROM ap_checkrun_conc_processes_all;

General Ledger:

Navigation -> Goto General Ledger Super User -> Journals -> Enter 

SELECT * FROM gl_je_headers WHERE JE_HEADER_ID = 1086045;

     

     SELECT * FROM gl_je_lines WHERE JE_HEADER_ID = 1086045;

     SELECT * FROM gl_je_batches WHERE JE_BATCH_ID = 736629;