Order to Cash Cycle

Order to cash flow is the process of entering an order ,delivery of the the goods, then producing the invoice for the goods.

Creating the Order:

1)Navigation: Order Management Super user,Vision Operations(USA) >>Orders, Returns > Sales Orders

Enter the Customer Name ,Order type in the Order Information Form

2)Go to the Line items tab

Enter the ordered item,Quantity

3) Click on the Book Order button

4)Run the sql query

select order_number, header_id, flow_status_code from oe_order_headers_all
where order_number = 66555;

This is related to the Header information

select flow_Status_code from oe_order_lines_all where header_id = 195864;

Here the line status is Awaiting Shipping

Pick Release:

1)Navigation: Shipping>>Transaction>>

In the Query Manager screen, enter the order number in the From Order Number field and tab out. Then, click on the Find button.

Click on the Actions and select Launch Pick Release for the LOV then Go

The following Message will be displayed

Now Check for the status in the same form

Ship Confirm:

1)Move on to the Delivery tab and select the Ship confirm button then ok then the confirmation message is displayed.

2)Run this query

select delivery_detail_id, released_status, oe_interfaced_flag, inv_interfaced_flag
from wsh_delivery_details
where source_code = 'OE' and source_line_id = 393680;

Released_Status is C (Shipped) becomes shipped after the ship confirm

OE_Interfaced_Flag is Y –Interface Trip Stop has interfaced shipping data to OM

Inv_Interfaced_flag = Y -- Interface Trip Stop has interfaced shipping data to INV

Invoice:

1)Checking the line status

Move on to sales order form and query the sale order, move onto the line item tab and check the status of the line as”SHIPPED”

Go to the Tools>>Workflow Status

2)Verify that the order line workflow is now at the Fulfill - Deferred activity with a status of Deferred. This means that the next steps is to run the Workflow Background Process.

Navigate to sale order form and view>>Request

Run the workflow background program

Check whether this program is successfully completed. In addition to this notice that the AR concurrent requests Autoinvoice and Autoinvoice Import Program will run automatically to import the invoices into AR.

3)The workflow status for the order line (go to Tools > Workflow Status) should now show the following progression.

4)Run this sql Query

select line_id, open_flag, flow_status_code, invoice_interface_status_code
from oe_order_lines_all
where line_id = 393680;

5)Move on to the sales order Form and Line Items then Click on the Action button select Additional Information from the LOV.

Move onto the Deliveries tab here the status is Closed and pick status is Shipped

Check for the line status Closed.

This Status (Closed) indicates that the O2C cycle has completed successfully.