WHAT IS DIFFERENCE BETWEEN
PROCURE TO PAY CYCLE & ORDER TO CASH CYCLE ?
Procure (to get) To Pay Cycle (buying of items to
payment of them here company buy items
from vendors)
Procure to pay cycle is genrally applicable to all the client who
give their projects to the companies (like techsignia ) here that client will
go through the p2p cycle and all its different steps and in this steps , data
generated will be stored in tables of different modules , we developer, just
make reports using that data in AOL , every client must go through P2P cycle
Exa: for example techsignia
is taking project of bank HDFC in this case HDFC will have its own oracle e
business suite license, now HDFC is our client and it will give its data to our
team in the form of excel sheet which we will enter into tables by any method,
this data entered will be related to
different modules and there tables and it will depend on the cycle like p2p
cycle where in our exa bank will first act as client to buy its necessary goods
like bank will want to buy computers in this case bank will have different
vendors from whom they can buy computers in this case bank will first place the
requisition ( demand) to different vendors , then HDFC will prepare RFQ (request for quotation ) and send it to different
suppliers to get the best and /or economical price for the product . then
supplier will reply by sending their quotation to bank ,all these data will be
stored in oracle purchasing , and after comparing
hdfc will select the best quotation , later hdfc will prepare a purchase order
(PO)and shift the orders goods , and will receive the goods and all this data
called goods received note (GRN ) will go in oracle purchasing , if HDFC want
to receive goods at inventory then entries will make changes in inventory
tables , once goods are moved to the inventory all accounting detail will be
stored into table oracle general ledger, finally supplier will send invoice for
the purchased goods and HDFC will match invoice against purchase order from
oracle purchasing in oracle payables . , finally payment is made
The requirement arises
from requirements for items,and company places order for items needed.
The vendor supplies the items .Once items are received 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 General Ledger (GL).
The vendor supplies the items .Once items are received 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 General Ledger (GL).
In P2P cycle module
included are
PO (purchase order )
AR(Account Receivable )
AP(account payable )
CM(cash management)
GL (general ledger )
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
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
sab chori kiya hua maal h saala...:P
ReplyDeletebhag sale
Delete