Order To cash Cycle-Techie reference

 

• Enter the Sales Order

Tables :oe_order_headers_all  -Header_id referencing key

• oe_order_lines_all
• wsh_delivery_details- delivery_id is the number
• wsh_delivery_assignments

*In shipping transaction form order status remains “Ready to Release”.

• Book the Sales Order

Data to be checked in :mtl_demand and mtl_reservations

• Launch Pick Release 

MTL_MATERIAL_TRANSACTIONS

• Ship Confirm

• MTL_MATERIAL_TRANSACTIONS_TEMP
• oe_order_lines_all
• MTL_MATERIAL_TRANSACTIONS
• mtl_transaction_accounts
• wsh_delivery_details
• wsh_delivery_assignments
• MTL_ONHAND_QUANTITIES

• Create Invoice .

       ra_customer_trx_all and ra_customer_trx_lines_all

RA_CUSTOMER_TRX_ALL will have the Invoice header information. The column INTERFACE_HEADER_ATTRIBUTE1 will have the Order Number.

RA_CUSTOMER_TRX_LINES_ALL will have the Invoice lines information. The column INTERFACE_LINE_ATTRIBUTE1 will have the Order Number.

• Create the Receipts either manually or using Auto Lockbox ( In this article we will concentrate on Manual creation)
• Transfer to General Ledger
• Journal Import
• Posting