Oracle Basic

Create Sale order >

in the Header Level - enter customer name whos should be having both Bill to and Sit to Address> enter Payment Terms> enter the pricing > enter the transaction Type of that sale, then go to Line item and pick the invenotiable ( or ono inventoribale item) items from item master from the Sub Inventroy Orginsation, then attch this line to a particular sales man or collection agent.

Save the data, ( Line statius is 'Entered') then book the order ( shows the line status as " line is awating shippment" ( order status will be 'booked' > release the sales order > ( Line status will be " Picked") and ship the Materail which eventually show the line status as 'closed'.

this shows the inventroy is credited with inventory Cost and COGS is Debited

The next face is interfacing to AR ( Autoinvoicing Rule) - Customer is Debited and Sales is Credited.

enter the order:

---------------

oe-order-headers-all

oe-order-lines-all(flow_status_code = entered)

book the order:

--------------

oe_order_headers_all

oe_order_lines_all(flow_status_code = booked)

wsh_new_deliveries(status_code =open)

wsh_delivery_details(releases_status = R 'ready to release)

pick release:

---------------

which items on sales order we need to take out from inventory.

normally pick release SRS program run from backend once this over.

oe_order_lines_all(flow_status_code=picked)

wsh_delivery_detalis(release_status = S 'submitted for release)

pick confirm:

-------------

items are transfered from salable to staging sub inventory.

mtl_material_transaction

mtl_transaction_accounts

wsh_delivery_details(released_status = Y 'released')

wsh_delivery_assignments

ship confirm:

-------------

here ship confirm program run from backend and data removed from wsh_new_deliveries.

oe_order_lines_all ( flow_status_code =shipped)

wsh_delivery_details (released_status = shipped)

mtl_transaction_interface

mtl_material_transactions (linked through source_header_id)

data deleted from mtl_demand & mtl_reservations

item deducted from mtl_onhand_quantities.

Enter invoice:

--------------

this is also called recivables interface,that mean information moved to accounting area for invoicing

details.

invoicing workflow activity transfers shipped item info to recevables.

ra_interface_lines_all

then auto-invoice program imports data from this.

then effected tables : ra_customer_trx_all (trx_number is the invoice number)

ra_customer_trx_lines_all (line_attribute 1 & 6 ) linked to header_id

and lined_id for orders....

complete line:

-------------

order line level table get updated with flow status & open flag.

oe_ordr_lines_all ( flow_status_code = shipped & open flag = N)

close order:

------------

once we close the order oe_order_lines_all table get updated with flow_status_code as closed.

Drop Shipment is done when your customer has ordered an item that you dont manufacture. In this case you purchase the same product from another company and the ship to location will the customers address. In Oracle the steps that are followed are as follows:

Enter the order with a Dropship item >> Book >> Workflow Background Process is run>>

Then Purchase release is run>> now in PO super user>> run Requisition import>> it will create the requisition>> Autocreate the requisition to a PO>> receive the PO into thedropship subinventory>> Verify the SO lines should be shipped by now>>> Run workflow and Autoinvoice.