Procure to Pay cycle

--Overview---

1. Item Creation
2. Supplier Creation
3. Buyer Creation
4. Requisition

•  Internal Requisition
•  Purchase Requisition

5. Purchase Order

•  Standard Purchase Order
•  Planned Purchase Order
•  Blanket Purchase Order
•  Catalog Purchase Order

6. Receipts  

• 2 - Way -- PO, Invoice
• 3 - Way -- PO, Receipt, Invoice
• 4 - Way -- PO, Receipt, Inspection, Invoice

7. Invoice

8. Payments

9. Transfer to GL

----In Details-----

Mainly three applications are involved in Financial Module i.e. P2P cycle.

Those 3 applications are

• Purchasing (PO)
• Account Payables (AP)
• General Ledger (GL)

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.

Requisition: It is one of the purchasing documents will be prepared by the employee who required the materials or Services or Training and so on.
We have two types of Requisitions.
Those are

• Internal Requisition
• Purchase Requisition


Internal requisition will be created when we receive materials from another Inventory of the same organization. Purchase requisition will be created when we purchase materials from the Suppliers (vendors).
Requestor creates this requisition.

Navigation: Purchasing, Vision Operations (USA) ---> Requisitions ---> Requisitions

We enter the Requisition data in 3 levels. Those are Headers, Lines and Distributions.

Enter Requisition type at headers level and Item, UOM, Quantity, Price and Need-By-Date columns at lines level like below.

Click on Distributions and click on Charge Account column, Accounts information will propagate automatically. Save your data by clicking save button in menu.

Copy  Requisition  number  for  further  steps  and  observe  the  status  as   Incomplete

Now click on Approve button.

Once the Requisition is approved, you will not able to open the same requisition again but we can check the requisition status and details from Requisition summary form.

Navigation: Purchasing, Vision Operations (USA) ---> Requisitions ---> Requisition Summary

By clicking Find button, you can check the status and line level details of that particular requisition.

To see the history of that particular requisition,

Tools ---> View Action History

You can cancel the requisition.

Tools ---> Control

The tables affected with this requisition creation are:

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;

RFQ (Request for Quotation):

Once the Requisition is approved, Preparer will prepare the RFQ document and will send to different suppliers. Suppliers may or may not respond for this RFQ and they will send their Quotations.

There are 3 types of RFQ documents.

Bid RFQ: Fixed quantity and no Price Breaks (Discounts). E.g.: Servers, Building acquisition.

Catalog RFQ: Regularly used, large number of quantity and Price Breaks are available. E.g.: Milk products, water etc. . . .

Standard RFQ: Not very often and Discounts information at different quantity levels. E.g.: Laptops, Electronic devices etc. . . .

Terms and Conditions: While creating the RFQ document, we need to choose Terms and Conditions. We can enter this data by clicking Terms button.


Payment Terms: When Organization is making the payment and Interest rates. Fright Terms: Who is bearing the Transportation charges whether Buyer or Supplier. FOB (FreeOnBoard): Responsibility of materials damage or any missing quantity. Carrier: Transportation Company details.

Navigation: Purchasing, Vision Operations (USA) ---> RFQ’s a d Quotations ---> RFQ’s

Enter the RFQ details as below. You can enter price breaks (discounts) for Catalog RFQ and Terms.

Enter discounting information by clicking Price Breaks button.

Attach the suppliers to send this RFQ document them by clicking Suppliers button and save your data and copy RFQ number for further use.

The tables affected with this RFQ creation are:

SELECT * FROM PO_HEADERS_ALL WHERE SEGMENT1='309' AND
TYPE_LOOKUP_CODE='RFQ';

SELECT * FROM PO_LINES_ALL WHERE PO_HEADER_ID=110347;

SELECT * FROM PO_LINE_LOCATIONS_ALL WHERE PO_LINE_ID=173275;

Quotation:

It is also a purchasing document; prepared by the Suppliers which contain the quote details, Price, payment terms and so on. We will enter all the Quotations details in the system through a form.

There are three types of Quotations available.

• For Bid RFQ: Bid Quotation

• For Catalog RFQ: Catalog Quotation

• For Standard RFQ: Standard quotation

The management will do quote analysis and choose the best quotation from all suppliers.

Navigation: Purchasing, Vision Operations (USA) ---> RFQ’s a d Quotatio s ---> Quotations

Enter all the details of Quotation for that particular RFQ by entering RFQ number at headers level.

Enter the discounts by clicking Price Breaks button and save data.

The tables affected with this Quotation creation are:

SELECT * FROM PO_HEADERS_ALL WHERE SEGMENT1='503' AND

TYPE_LOOKUP_CODE='QUOTATION';

SELECT * FROM PO_LINES_ALL WHERE PO_HEADER_ID=110348;

SELECT * FROM PO_LINE_LOCATIONS_ALL WHERE PO_LINE_ID=173276;

PO (Purchase Order):

PO is one of the main documents, prepared and approved by the buyer according to the quotation and sends it to the supplier which contains the information of terms and Conditions, Items details, Quantity, Price, Distribution, Shipment Details and so on. .

There are four types of Purchase Orders.

1. STANDARD

2. PLANNED

3. BLANKET

4. CONTRACT 

Purchase Order types Summary:

Navigation: Purchasing, Vision Operations (USA) ---> Purchase Orders ---> Purchase Orders

Enter the Information at headers and lines level as below.

Click on Shipments button to enter Shipments level details.

Click on More tab of this form, you can find match approval level.

There are three Match Approval Levels.

Two–Way: Purchase order and invoice quantities must match within tolerance before the corresponding invoice can be paid.

Three–Way: Purchase order, receipt, and invoice quantities must match within tolerance before the corresponding invoice can be paid.

Four–Way: Purchase order, receipt, inspection and invoice quantities must match within tolerance before the corresponding invoice can be paid.

Choose one match approval level and click on Distributions button to get account details as below.

Save all your data, copy PO number for further reference, check the status  olu   as  I  o  plete

and approve the Purchase order by clicking Approve button then Click on OK.

No     he k the status as Appro ed .

The tables affected with PO creation are:

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;

You can check PO status and details in Purchase Order summary form. You can see the history of Purchase Order.

Tools Menu ---> Action History

You can create the Purchase Order document as same as previous with different PO number. Tools Menu ---> Copy Document

You can cancel the Purchase Order. Tools Menu ---> Control

Receipts:

Navigation: Purchasing, Vision Operations (USA) ---> Receiving ---> Receipts

Select Vision Operations and click Ok.

Enter Purchase Order number and click on Find button.

Check button as shown above and save, and then click on Header button.

Copy Receipt number for further use.

The tables affected with Receipt creation are:

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

SELECT * FROM RCV_SHIPMENT_LINES WHERE SHIPMENT_HEADER_ID=4812907;

Invoice:
Types of Invoices
·	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.

After creating the invoice, we have to do the 3 steps.

1.  Validate Invoice

2. Approve Invoice

3. Create Accounting Transactions.

Navigation: Payables, Vision Operations (USA) ---> Invoices ---> Entry ---> Invoices

Enter Purchase Order (PO) number, Invoice date, Invoice number, amount and tax control amount and click on Match button to match invoice with that particular Purchase order.

Enter purchase order number, line and shipment and click on Find button.

Tick match check box at lines level and click on Match button and copy invoice number.

.

Check the Status, Accounted and Approval columns in Status block.

Tick validate  he k  o  a d  li k OK  utto ,  he k “tatus  olu                       as  Validated . No   li k o

Actions button again and tick Create accounting check box with final or final post.

Click OK and check view payments, there is no data.

The tables affected with Invoices are:

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;

Payments:

Once the Invoice is created, approved and accounted. Then we can make the Payments to the supplier. There are three types of Payments.

Manual: If Organization is going to pay the amount by cheque or cash then it will be captured under the manual payment type.

Quick: System will automatically generate the payment transaction as per the Invoice number. System will automatically generate the Cheque number also.

Refund: If any refundable amount is there, we have to pay to the supplier or customer or employee then those payments will be select as Refund method.

Navigation: Payables, Vision Operations (USA) ---> Payments ---> Entry ---> Payments

Enter trading partner, payment date, bank account, payment process profile, method and document at headers level. Click on Enter/Adjust Invoices button to add this payment for particular Invoice of this supplier or trading partner.

You can create multiple payments for single invoice with different amounts.

Enter invoice number and save close this window.

Click on Actions button and tick Create Accounting check box with final.

one'>You can create multiple payments for single invoice with different amounts.

Click on OK. The following message will come.

You can check these payments in View payments tab in Invoice form.

The tables affected with this payments creation are:

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

Transfer to General Ledger:

View Menu ---> Requests

Ru    Tra sfer Jour al E tries to Ge eral Ledger progra  . Enter the parameters as below.

Submit the program by clicking OK and then Submit Button and copy the batch name. Find the request status by clicking Find button. After successful completion of this concurrent program,

By successful completion of these concurrent programs, journal entries will be transferred to General Ledger module. You can check these with Batch name.

General Ledger:

Navigation: General Ledger, Vision Operations (USA) ---> Journals ---> Enter

Enter batch details and click on Find button.

You can review your journal by clicking Review journal button.

Post your Journal Entries by clicking Post button. The following Message will display.

You can check this Concurrent program status.

The tables affected with this Journal Entries are:

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);

Tables in P2P cycle are:
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;
SELECT * FROM	PO_HEADERS_ALL WHERE SEGMENT1='309' AND
TYPE_LOOKUP_CODE='RFQ';
SELECT * FROM	PO_LINES_ALL WHERE PO_HEADER_ID=110347;
SELECT * FROM	PO_LINE_LOCATIONS_ALL WHERE PO_LINE_ID=173275;
SELECT * FROM	PO_HEADERS_ALL WHERE SEGMENT1='503' AND
TYPE_LOOKUP_CODE='QUOTATION';
SELECT * FROM	PO_LINES_ALL WHERE PO_HEADER_ID=110348;
SELECT * FROM	PO_LINE_LOCATIONS_ALL WHERE PO_LINE_ID=173276;
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;
SELECT * FROM	RCV_SHIPMENT_HEADERS WHERE RECEIPT_NUM ='8462' ORDER BY
CREATION_DATE	DESC;
SELECT * FROM	RCV_SHIPMENT_LINES WHERE SHIPMENT_HEADER_ID=4812907;
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;
SELECT * FROM	AP_INVOICE_PAYMENTS_ALL WHERE INVOICE_ID=211320;
SELECT * FROM	AP_CHECKS_ALL WHERE CHECK_ID=77550;
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);
SELECT * FROM	AP_PAYMENT_SCHEDULES_ALL WHERE INVOICE_ID=211320;
SELECT * FROM	GL_BALANCES;
SELECT * FROM	AP_HOLDS_ALL;
SELECT * FROM	IBY_PAYMENTS_ALL;

P2P Joins:

REQUISITIONS -> TO -> PO

------------------------

SELECT    *FROM

PO_REQ_DISTRIBUTIONS_ALL PRD,

PO_DISTRIBUTIONS_ALL PDA

WHERE    PRD.DISTRIBUTION_ID=PDA.REQ_DISTRIBUTION_ID;

PO-> TO ->AP

------------

SELECT *FROM

PO_DISTRIBUTIONS_ALL PDA,

AP_INVOICE_DISTRIBUTIONS_ALL AID

WHERE      PDA.PO_DISTRIBUTION_ID=AID.PO_DISTRIBUTION_ID;

PO -> TO -> RECEIPTS

-------------------

SELECT *FROM

RCV_SHIPMENT_LINES RSL,

PO_HEADERS_ALL PHA

WHERE    PHA.PO_HEADER_ID= RSL.PO_HEADER_ID;

AP ->TO -> GL

-------------

SELECT *FROM

GL_JE_LINES GJL,

AP_INVOICES_ALL AIH

WHERE    TO_CHAR(AIH.INVOICE_ID)=GJL.REFERENCE_2

AND        AIH.INVOICE_NUM=GJL.REFERENCE_5;

ACCOUNTING_EVENT -> TO -> GL

---------------------------

SELECT *FROM

AP_AE_LINES_ALL AELINES,

GL_JE_LINES GJL

WHERE AELINES.GL_SL_LINK_ID=GJL.GL_SL_LINK_ID;