SCM

Procurement to pay cycle

Procurement to pay cycle;

In P2P cycle the moduled included are PO,AR,AP,CM and GL

The requirement arises from requirements for items,and company places order for items needed.
The vendor supplies the items.Once items are recieved payment will be made.That is a invoice will be raised and payment will be made to the vendor.The payment can be of cash,cheque etc.

This is governed under cash management and finally the transaction detalis will be accounted in GL.

Important Base Tables Invoved are:

Requisition
po_requisition_headers_all
po_requisition_lines_all ( segment1 ========== requisition number)
po_req_distributions_all
Note: requisition_header_id is the link between po_requisition_headers_all and po_requisition_lines_all
requisition_line_id is the link between po_requisition_lines_all and po_req_distributions_all

Purchase order
po_headers_all
po_lines_all
po_distributions_all
po_line_locations_all
Note: po_header_id is the link between all these tables

Receipt
rcv_shipment_headers
rcv_shipment_lines
rcv_transactions
quality result stored in qa_results table
Note: shipment_header_id is the link between rcv_shipment_headers and rcv_shipment_lines
po_header_id is the link between rcv_shipment_headers and rcv_transaction

Invoices
ap_invoices_all
ap_invoice_distributions_all
Note: invoice_id is the link between ap_invoices_all and ap_invoice_distributions_all

Payments
ap_checks_all
ap_invoice_payments_all
ap_payment_schedules_all

Payment Reconcillation
ap_banks
ap_bank_branches

GL Transfer
gl_periods
gl_period_status
gl_set_of_books
glfv_charts_of_accounts

---

1. Go to Purchasing > Requisitions > Requisition Summary.
   

• In the Find Requisitions window, enter requisition number found in the previous step and click on Find.
  

2. Go to Purchasing > Autocreate.
   

• From Edit > Clear > Record, clear any query criteria that may be defaulted.
  
• Enter requisition number and click Find.
  
• Check the checkbox to the left of the line, and click on Automatic.
  
• Enter the Supplier and Supplier site such as the following and click on Create

4. Go to Purchasing > Receiving > Receipts.
   

• Enter Purchase Order number and click on Find.
  
• In the Receipts window, check the checkbox to the left of the line and enter
  
  1. Destination Type : Inventory
     
  2. Subinventory : FGI
     
  3. Save the receipt.
     

5. Go to Purchasing > Receiving > Receiving Transactions Summary.
   

• Enter the Purchase Order number and click on Find.
  
• Click on the Transactions button.
  
• Verify a Receive and Delivery transaction. This means that the B2B item has been received into Inventory.
  

         6.Payables > Invoices > Entry > Invoices
             Enter the supplier, amount and other details.
         7. Match the invoice with Receipt or with PO. Open Invoice > Match (B) > Enter PO / Receipt Number > Find (B)

Validate Invoice: Open Invoice > Actions… 1 (B)


          Verify Invoice Status:

Create Accounting and initiate Payment: Open Invoice > Actions… 1 (B)
Enter Payment details and Save:

Order to cash

Order to cash normally refer to the process in which taking customer sale order via different sales channel like email, internet, sales person and then generating an invoice and collecting payment for that invoice and then receipt


Complete Order to cash cycle steps including
1. Entering the Sales Order
2. Booking the Sales Order
3. Launch Pick Release
4. Ship Confirm
5. Create Invoice
6. Create the Receipts either manually or using Auto Lockbox ( In this article we will concentrate on Manual creation)
7. Transfer to General Ledger
8. Journal Import
9. Posting

Tables:

1. OE_ORDER_HEADERS_ALL

2. OE_ORDER_LINES_ALL

3. WSH_DELIVERY_DETAILS

4. WSH_DELIVERY_ASSIGNMENTS

5. WSH_NEW-DELIVERIES

6. WSH_DELIVERY_LEGS

7. WSH_TRIP_STOPS

8. WSH_TRIPS

9. M TL_TRX_REQUEST_LINES

10. MTL_MATERIAL_TRANSACTION_TEMP

11. OE_SETS

12. OE_LINE_SETS

13. OE_LINES_ALL

14. MTL_RESERVATIONS