July 27, 2010

Procure 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 Involved 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

No comments:

Post a Comment

Thanks for your comments submitted.,will review and Post soon! by admin.

COALESCE-SQL

Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...