1) Purchase Orders : It is one of the purchasing document at the time of purchasing from the supplier we will create this document by specifying terms and conditions and shipping details distribution details and so on. We have 4 types of Purchase Orders
a. Standard
b. Planned
c. Blanket
d. Contract
Purchase Order Types Summery
Standard Purchase Order
When we require the materials from suppliers we will cerate standard PO by specifying terms and conditions price, quantity and so on.
Select * from PO_HEADERS_ALL
where segment1=’3445’ and type_lookup_id = ‘STANDARD’
Select * from Po_lines_all where PO_Header_id = 11858
Select * from PO_Line_locations_all where Po_line_id=12216
Primary Key – LINE_LOCATION_ID
Select * from po_distributions_all where line_location_id
Primary Key – PO_DISTRIBUTION_ID
⦁ (N) – Open the purchase order form – Purchase Orders-Purchase Orders and enter select PO type and suppliers information enter the line level details like Items quantity price and so on.
⦁ Select shipments button enter shipping location details quantity promice date, need by date and so on select distribution button enter distribution details and save the transactions.
⦁ Select approve button system will submit the document for approvals.
⦁ Copy the PO number and go to purchase or summary form enter PO number select find button.
⦁ To cancel the purchase order go the tools menu – control option.
⦁ Tools menu copy document to create the same document.
⦁ Auto Create
⦁ By using Auto Create option we can create purchase orders automatically from approved requisition by selecting document type as Purchase order.
SELECT pha.segment1 ponum,
pha.type_lookup_code potype,
TRUNC (pha.creation_date) cdate,
pv.vendor_name supplier,
pvs.vendor_site_code suppliersite,
(pvc.first_name || ',' || pvc.last_name) contact,
hl1.location_code shipto,
hl2.location_code billto,
pha.currency_code currency,
ppf.full_name buyer,
pha.authorization_status postatus,
SUM ( (pla.quantity * pla.unit_price)) linelevelprice,
pha.comments podesc
FROM po_headers_all pha,
ap_suppliers pv,
ap_supplier_sites_all pvs,
ap_supplier_contacts pvc,
hr_locations hl1,
hr_locations hl2,
per_all_people_f ppf,
po_lines_all pla
WHERE pha.segment1 = '3449'
AND pha.vendor_id = pv.vendor_id
AND pha.vendor_site_id = pvs.vendor_site_id
AND pha.vendor_contact_id = pvc.vendor_contact_id
AND pha.ship_to_location_id = hl1.location_id
AND pha.bill_to_location_id = hl2.location_id
AND pha.agent_id = ppf.person_id
AND pha.po_header_id = pla.po_header_id
GROUP BY pha.segment1,
pha.type_lookup_code,
TRUNC (pha.creation_date),
pv.vendor_name,
pvs.vendor_site_code,
(pvc.first_name || ',' || pvc.last_name),
hl1.location_code,
hl2.location_code,
pha.currency_code,
ppf.full_name,
pha.authorization_status,
pha.comments
Blanket Purchase Order
⦁ When ever company would like to have the agreement with supplier that time first we will create Blanket Agreement, when ever we require materials we will go for releasing the purchase orders.
⦁ Open the purchase order form select Blanket Purchase agreement and enter the details and approve the purchase order.
⦁ Select releases form either blanket PO Number and Item quantity details select distributions button enter distribution details, select approve button for approvals.
Match Approval
2 way PO Qty – 100 Invoice Qty 80
3 way PO Qty – 100 Receipt Qty 80 Invoice Qty 80
4 way PO Qty – 100 Receipt Qty 80 Invoice Qty 50 Invoice Qty 50
⦁ At the time of creation Purchase Order in the shipments, release we will specify the Match approval option.
⦁ Two way matching is nothing but company purchase order quantity, price with Invoice price.
⦁ Three way matching is nothing but comparing 3 documents Purchase Order, Receipt and Invoice.
⦁ Four ways Matching is nothing but company PO receipt inspection and Invoice documents.
Receipt Documents
1. Standard - 3 Way
2. Direct Delivery - 2 way
3. Inspection Required - 4 way
⦁ It is one of the purchasing document will be created while receiving the materials form the suppliers we have 3 types of receipt.
⦁ Navigation – Receiving – Receipts and enter.
⦁ Create the purchase order and approve it open the receipts from enter PO Number, select find button, system will show the PO Line details, check the check box save to transactions, system write automatically generate Receipt number
Select * from RCV_SHIPMENT_HEADERS
SELECT * FROM RCV_SHIPPMENT_LINES
SELECT * FRO RCV_TRANSACTIONS
SELECT * FORM ORG_ORGANIZATIONS_DEFINITIONS.
⦁ Create PO write 3 lines
⦁ Go to receipt – generate the receipt for only one Item and either the PO Number again – create another receipt until all the Items over.
Select Receipt_Num
From RCV_shippment_headers
Where shipment_header_id IN (Select shipment_header_id
From rcv_shpment_lines
Where PO_header_id IN( Select Po_Header_ID
From PO_heaer_all
Where segment1=’3452’))
