Apps P2P Cycle

Procure to Pay Cycle (P2P)

  1. Create Item

From navigation tab select  => inventory vision operation

items-> master items->(select organisation)-> vison operation

(A form will appear and fill the form as per the below instruction)

  • enter item name and description-> (for example)-> ITEM9
  • inventory tab->checked(inventory item,stockable,transactable,reservable)
  • bill of material tab->checked(BOM ALLOWED)
  • costing tab->checked(costing enabled)
  • purchasing tab->checked(purchased,purchasable,allow descriptioin update)
  • work in process->checked(build in wip)
  • order management->checked(customer ordered,customer orders enabled,shippable,internal ordered, internal orders enabled,OE transactable)
  • invoicing->checked(invoiceable item,invoice enabled)
  • web option->checked(orderable on the web,back orderable) and save the form

Do Query in toad app just to check your created item is reflecting in database:

SELECT * FROM MTL_SYSTEM_ITEMS_B WHERE SEGMENT1='ITEM9'

SELECT * FROM MTL_SYSTEM_ITEMS WHERE SEGMENT1='ITEM9'

  • Create Requisitions
  • From navigation tab select-> PURCHASING VISION OPERATION(USA) Requisitions->Requisitions

(A form will appear and fill the form as per the below instruction)

  • After filling above details click on à Distribution
  • Close the distribution form once it reflects charge-account as shown above and save the requisition form.
  • After saving the form you will get Requisition_id reflects on your requisition form.
  • Click on Approve button to approve the form
  • We can check the requisition_id by navigationà requisitionsàrequisition summary and one form will appear put requisition-id and click on find to check.

By Requisition_id do some query in toad to check database status:

SELECT * FROM PO_REUISITION_HEADERS_ALL WHERE SEGMENT1=’14310’

SELECT * FROM PO_REQUISITION_LINES_ALL WHERE REQUISITION_HEADER_ID=’181350’

SELECT * FROM PO_REQ_DISTRIBUTIONS_ALL WHERE REQUISITION_LINE_ID=’208558’

SELECT * FROM GL_CODE_COMBINATIONS WHERE CODE_COMBINATION_ID=’13185’

SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID=’13185’

Create Suppliers

  • Goto à Navigation tabà supply base à suppliersà(click on) create supplier
  • Put the *organization nameà (for example) ITEM9-SUP àclick on apply
  • Check on toad app by below code whether supplier is reflecting in database.
  • SELECT * FROM AP_SUPPLIERS WHERE SEGMENT1=’17’
  • Click on ‘address book’ located on left hand side as shown below:-
  • A form will appear to fill supplier details, fill as per below instruction
  • Click on continue after filling above form and you will get below page, select the ‘site name’ and click on apply.
  • Check with below code in toad application to check suppliers details in database
  • SELECT * FROM AP_SUPPLIER_SITES_ALL WHERE VENDOR_ID=’38169’
  • SELECT * FROM PO_VENDORS WHERE SEGMENT1=’17’
  • SELECT * FROM PO_VENDOR_SITES_ALL WHERE VENDOR_ID=’38169’
  • Create Purchase Order
  • Gotoà Navigation tabàPurchase ordersàpurchase orders
  • Purchase order form will appear and fill it accordingly as shown below:-
  • After filling above form click on ‘Shipment’ a form will appear:-
  • Change the organization name to V1 ‘vision operation’ and also fill it accordingly as shown above image.
  • After filling above form click on ‘Distributions’ and then new form will appear as shown below
  • On above form directly click on ‘PO Charge Account’ to reflect charge account number.
  • After doing above steps close the ‘shipment’ and ‘distributions’ form and save the form
  • Moment you save the form a ‘PO’ id will generate on the form as shown below image:-

Try with below code in toad to check in database

SELECT * FROM PO_HEADERS_ALL WHERE SEGMENT1=’6052’

SELECT * FROM PO_LINES_ALL WHERE PO_HEADER_ID=’110606’

SELECT * FROM PO_LINE_LOCATIONS_ALL WHERE PO_LINE_ID=’173515’

SELECT * FROM PO_DISTRIBUTIONS_ALL WHERE LINE_LOCATION_ID=’264661’

SELECT * FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID=’13185’

SELECT CONCATENATED SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID=’13185’

  • Create Receipts

Gotoà Navigation tabà Receivingà Receiptsà select organization (Vision operations)

New form will appear put the purchase order and click on ‘find’ button

Click on check box to select the row and one pop-up will appear click ‘ok’ again to confirm as shown below

Click on ‘Header’ button and one ‘receipt header’ form will appear and click on save to get receipt number as shown below image:

After saving above form run some query in Toad app

SELECT * FROM RCV_SHIPMENT_HEADERS WHERE RECEIPT_NUM=’8467’ AND VENDOR_ID=’38169’

SELECT * FROM RCV_SHIPMENT_LINES WHERE SHIPMENT_HEADER_ID=’8421907’

SELECT * FROM RCV_TRANSACTIONS WHERE SHIPMENT_HEADER_ID=’4821907’

Goto -> Receiving -> Receiving Transactions -> select organization (vision operation)

One form will appear enter ‘PO number’ and click on ‘Find’ a new form will appear as shown below

Select the row in form and choose ‘Stores’ in ‘Subinventory’ and click on ‘Inspect’

  • Create Invoice
  • Goto -> switch responsibility -> Payable vision operation -> Invoices -> Entry -> Invoices
  • Fill the above form and click on ‘lines’ tab and fill it accordingly as shown below
  • After filling above form click on ‘Distribution’ a new form will appear just to see information and close the form, AND Save the form.
  • And do some query in toad just to check database status as shown below:-
  • SELECT * FROM AP_INVOICES_ALL WHERE INVOICE_NUM=’ITEM9-INV’
  • SELECT * FROM AP_INVOICE_LINES_ALL WHERE INVOICE_ID=’211560’
  • SELECT * FROM AP_INVOICE_DISTRIBUTIONS_ALL WHERE INVOICE_ID=’211560’
  • SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COBINATIONS_KFV WHERE CODE_COMBINATION_ID=’12854’
  • SELECT ACCOUNTING_EVENT_ID FROM AP_INVOICE_DISTRIBUTIONS_ALL WHERE INVOICE_ID=’211560’
  • Click on ‘Action’ to validate the form by selecting some option as shown below
  • Query in toad to check ‘Accouting’ for created invoice
  • SELECT * FROM XLA_EVENTS WHERE EVENT_ID=’3335711’
  • SELECT * FROM XLA_AE_HEADERS WHERE EVENT_ID=’3335711’
  • SELECT * FROM XLA_AE_LINES WHERE AE_HEADER_ID=’4957976’
  • SELECT * FROM GL_INTERFACE WHERE PREFERENCE26=’3335711’
  • For Ledger database Status Gotoà Viewà Request
  • Click on find button after selecting the same option as shown above

Click on ‘view output’ after selecting on ‘Journal import’ a PDF file will open in explorer as shown below:

  • Copy the selected ‘Batch name’ from the page as shown above and do some query in toad with that batch name for checking LEDGER STATUS:
  • SELECT * FROM GL_JE_BATCHES WHERE NAME=’Payables A 1557007 5898772’
  • SELECT * FROM GL_JE_HEADERS WHERE JE_BATCH_ID=’2939184’
  • SELECT * FROM GL_JE_LINES WHERE JE_HEADERS_ID=’4693155’
  • Create Payment

Goto -> Payments -> Entry -> Payments

A form will appear fill it accordingly as shown below image:

After filling above form click on ‘Enter/Adjust Invoice’ a new form will appear enter the invoice number automatically related data will appear in  the form as shown below

And now save the form.