P2P

#  P2P Technical Flow..........

During the Purchasing application flow, three types of roles are involved. Those are

• Requestor : Employee who require or request for the materials.
• Preparer : Employee who is going to prepare the Document.
• Buyer         : Employee who is having the authority to purchase materials.


1. Requisition, we have 2 types of requision 1. Internal 2. Purchase.
        Internal means receiving the material from another organization in the company,
        purchase indicates company purchasing material from suppliers.
        Requisition will be enter at  3levels 1.headers, lines, distributions.
        Here 3 tables will be effected    Po_requision_headers_all, po_requision_lines_all, Po_req_distributions_all.
                       
     SELECT * FROM PO_REQUISITION_HEADERS_ALL WHERE SEGMENT1='14308';
     SELECT * FROM PO_REQUISITION_LINES_ALL WHERE REQUISITION_HEADER_ID=181210;
     SELECT * FROM PO_REQ_DISTRIBUTIONS_ALL WHERE REQUISITION_LINE_ID=208398;
       SELECT * FROM PO_ACTION_HISTORY WHERE OBJECT_ID=181210;


2. RFQ : Once the requision has approved rfq will be created and rfq will be sent to suppler.
        We have 3  types of rfq 1. Bid, 2. Catalog 3.standard.
        a. bid rfq created for large & expensive items-no price breaks,
        b. catalog  rfq will be created for purchasing frequently .
        c. standard rfq will purchase only once or very often.
        Rfq information will be entered 3 levels headers, lines, shipments.
        Here po_headers_all, po_lines_all, po_line_locations_all will be effected.

           SELECT * FROM PO_HEADERS_ALL WHERE SEGMENT1='309' AND TYPE_LOOKUP_CODE='RFQ';
   SELECT * FROM PO_HEADERS_ALL WHERE SEGMENT1='503' AND TYPE_LOOKUP_CODE='QUOTATION';
           SELECT * FROM PO_LINES_ALL WHERE PO_HEADER_ID=110347;
           SELECT * FROM PO_LINE_LOCATIONS_ALL WHERE PO_LINE_ID=173275;


3. PO : after receiving the quotations from supplier, we will send purchase order to the supplier.
        4types of purchase order 1.standard po, 2.planned po 3.blanket purchase agreement 4.contract purchase agreement.
        a. standard specity-terms&conditions, items, price, delivery schedule.
        b. Planned po specify-long term agreement including chare account estimated cost,
        c. blanket po specity-whenever buyer is required material he will release the order as per that supplier will supply material.
        d. Contract po specify-terms and conditions without indicating the goods and services that you will purchase.
        Po order information will be entered at 4 levels. 1. Headers level, 2. line livel 3. Shipments, 4. Distributions level.
        Here po_header_all, Po_lines_all, po_line _locations_all, po_distributions_all tables will be effected.

SELECT * FROM PO_HEADERS_ALL WHERE SEGMENT1='6037' AND TYPE_LOOKUP_CODE='STANDARD';
  SELECT * FROM PO_LINES_ALL WHERE PO_HEADER_ID=110349;
  SELECT * FROM PO_LINE_LOCATIONS_ALL WHERE PO_LINE_ID=173277;
  SELECT * FROM PO_DISTRIBUTIONS_ALL WHERE LINE_LOCATION_ID=264447;


4. Receive Material: Next step is receiving the material from supplier based on match approval like
        2 way-po, invoice
        3 way-po, recipt, invoice
        4 way-po, receipt, insepection, invoice.
        Here rec_shipments_headers, rcv_shipements_lines, rcv_transactions table will be effected.

SELECT * FROM RCV_SHIPMENT_HEADERS WHERE RECEIPT_NUM ='8462' ORDER BY CREATION_DATE DESC;
SELECT * FROM RCV_SHIPMENT_LINES WHERE SHIPMENT_HEADER_ID=4812907;


5. Create & Approve Invoice: next company is paying amount to the supplier by creating invoice and approving invoice.
        There are different types of invoices are there standard invoice, credit memo, debit memo,pre-payment, po default, quich match  etc.,
        here ap_invoices_all, ap_invoice_distributions_all, ap_ae_header_all, ap_ae_lines_all tables will be effected.

• Standard   : For all the normal payments we will create this.
• Prepayment   : Advance Payment to the supplier based on the requirement.
• Credit Memo   : If supplier give the discount
• Debit Memo   : If company is going to deduct the amount
• Withholding tax   : if supplier is not recognized, the on behalf of the supplier company will pay the tax.
• PO Default   : We will give the PO number according to that it will generate the Invoices.
• Recurring Invoices: We will generate the Invoices multiple times for fixed supplier, fixed amount,                                       and fixed duration.
• Expense Report    : Employee expenses
• Quick Match   : 2 Way, 3 Way, 4 Way
• Mixed Invoice   : Miscellaneous expenses
• Interest Invoice  : If the invoice due date is over or supplier is interested to pay Interest.
• Retinae invoice   : Some amount will be released based on the satisfaction.
• Transportation    : Transportation expenses.


SELECT * FROM AP_INVOICES_ALL WHERE INVOICE_NUM='3M05';
SELECT * FROM AP_INVOICE_LINES_ALL WHERE INVOICE_ID=211320;
SELECT * FROM AP_INVOICE_DISTRIBUTIONS_ALL WHERE INVOICE_ID=211320;


6. Payments:  based on the  invoice make the payments to the supplier after validate  .
         Here 3 payment types are there 1.manual 2. Quick. 3. Refund.
         Here ap_invoice_payments_all, ap_checks _all,  ap_bank_accounts, ap_bank_branches table will be effected.

SELECT * FROM AP_INVOICE_PAYMENTS_ALL WHERE INVOICE_ID=211320;
SELECT * FROM AP_CHECKS_ALL WHERE CHECK_ID=77550;

7. Transfer: From the SRS window by running the standard programme paybles  transfer to gl system will submit the programme.
        By copying of Journam import request id post the unposted items to GL.
        Here from_date and  to_date are parameters and gl_je_headers, gl_je_lines, gl_je_batches tables will be effected.

SELECT * FROM GL_JE_BATCHES WHERE NAME LIKE '3M05BATCH%';
SELECT * FROM GL_JE_HEADERS WHERE JE_BATCH_ID=2927184;
SELECT * FROM GL_JE_LINES WHERE JE_HEADER_ID IN (468115, 4681156);