back 2 back orders demo
TRANSCRIPT
8/4/2019 Back 2 Back Orders Demo
http://slidepdf.com/reader/full/back-2-back-orders-demo 1/14
http://functionalguy.blogspot.com/2009/02/back-to-back-order-cycle.html
Back-to-Back Order Cycle In Order Management In today‟s environment where lead times are often only a matter of 24 hours, many
companies want to create a specific supply order linked to each customer order andthey want these supply order created as soon as the customer orders have beenbooked. These companies want to have the supply order “hard pegged” to thecustomer order that it is supplying, and once the supply reaches the warehouse theydo not want it inadvertently taken by another order or demand. They also needvisibility to where the Sales Order line is in the process at all times, so they cananswer customer service inquiries. We call this process „Back-to-back orders‟,indicating that the Sales Order and the supplying Purchase Order are very closelylinked, often where one PO is tied to one Sales Order.
Key Business Drivers Lower inventory cycle time and cost Link supply to specific demand Can offer a variety of product to customer Used heavily in contract manufacturing environment where the product is
standardized and the company plans to focus more on product design ratherthan manufacturing.
1. Create a B2B item :o In the Order Management tab, check the Assemble to Order flag (ATO).
8/4/2019 Back 2 Back Orders Demo
http://slidepdf.com/reader/full/back-2-back-orders-demo 2/14
o In the Purchasing tab, enter a value in the List Price field (in this demoit is 100).
o In the Work in Process tab, make sure the Build in WIP flag is checked.o In the General Planning tab, set the Make or Buy flag to Buy.o Save, and assign to Organization M1Note:
the ATO item attribute is checked as the B2B process utilizes theATO process of the workflow. However, the item is not manufactured inWIP, and instead is a 'Buy' item that is replenished by a supply order in PO.Hence the item may also be called an ATO Buy item
2. Assign the item to the price list
8/4/2019 Back 2 Back Orders Demo
http://slidepdf.com/reader/full/back-2-back-orders-demo 3/14
8/4/2019 Back 2 Back Orders Demo
http://slidepdf.com/reader/full/back-2-back-orders-demo 4/14
5. Book the order. Note down the Order Number
The line status will move to Supply Eligible (flow_status_codeSUPPLY_ELIGIBLE)
8/4/2019 Back 2 Back Orders Demo
http://slidepdf.com/reader/full/back-2-back-orders-demo 5/14
6. Place cursor on the line and go to Actions > Progress Order. Select Create
Supply Order - Eligible to progress the workflow of the line
The line status will now show PO-ReqRequested (flow_status_codePO_REQ_REQUESTED)
OM has inserted a record in the PO requisitions interface table.
8/4/2019 Back 2 Back Orders Demo
http://slidepdf.com/reader/full/back-2-back-orders-demo 6/14
Check reservation status: Go to Tools > Scheduling > Reservation Details >
'Supply' tab. Right now it is Inventory as Requisition is not yet created.
7. Go to Purchasing > Reports > Run and run the concurrent program RequisitionImport with the Import Source parameter = CTO (or blank). Leave the otherparameters as default. The concurrent program can also be run from OM >Orders, Returns > Requisition Import
8/4/2019 Back 2 Back Orders Demo
http://slidepdf.com/reader/full/back-2-back-orders-demo 7/14
8/4/2019 Back 2 Back Orders Demo
http://slidepdf.com/reader/full/back-2-back-orders-demo 8/14
The line status of the sales order line will now show PO-ReqCreated(flow_status_code PO_REQ_CREATED)
Check Reservation status: Go to Tools > Scheduling > Reservation Details >'Supply' tab. As the requisition has created now the supply for reservationchanges
8/4/2019 Back 2 Back Orders Demo
http://slidepdf.com/reader/full/back-2-back-orders-demo 9/14
8. Go to Purchasing > Requisitions > Requisition Summary. In the Find Requisitions window, enter requisition number found in the previous
step and click on Find. Verify that the status is Approved Requisition must have status APPROVED as
we ran Req. Import with Requisition approval initiation= Yes9. Go to Purchasing > Autocreate. From Edit > Clear > Record, clear any query criteria that may be defaulted. Enter requisition number and click Find.
Check the checkbox to the left of the line, and click on Automatic. Enter the Supplier and Supplier site such as the following and click on Create10. The Purchase Order form will automatically open with the PO that got
created. Click on the Approve button. Click on the OK button in the Approval Documents window to approve the PO. Note down the PO number, and verify that the status is Approved.
For More details also Refer: Requisition to Pay Cycle
The line status of the sales order line will now show PO-Created(flow_status_code PO_CREATED).
8/4/2019 Back 2 Back Orders Demo
http://slidepdf.com/reader/full/back-2-back-orders-demo 10/14
Check Reservation status: Verify that the order line is reserved against the PO.
11. Go to Purchasing > Receiving > Receipts. Enter Purchase Order number and click on Find. In the Receipts window, check the checkbox to the left of the line and enter
1. Destination Type : Inventory2. Subinventory : FGI3. Save the receipt.
12. Go to Purchasing > Receiving > Receiving Transactions Summary. Enter the Purchase Order number and click on Find. Click on the Transactions button. Verify a Receive and Delivery transaction. This means that the B2B item has
been received into Inventory.
The line status of the sales order line will now show Awaiting Shipping(flow_status_code = AWAITING_SHIPPING)
Check Reservation status: As the material is now in FGI sub-inventory, supplychanges to Inventory.
8/4/2019 Back 2 Back Orders Demo
http://slidepdf.com/reader/full/back-2-back-orders-demo 11/14
Check Shipping status of Order on shipping Transaction Form.
13. Pick Release the Sales Order
8/4/2019 Back 2 Back Orders Demo
http://slidepdf.com/reader/full/back-2-back-orders-demo 12/14
Make sure all the concurrent program gets completed successfully.
Check Shipping status of Order on shipping.
8/4/2019 Back 2 Back Orders Demo
http://slidepdf.com/reader/full/back-2-back-orders-demo 13/14
Check Line Status on Order.
14. Now the Line is eligible for Shipping Activity. Ship the Order and verify theline status.
15. Go ahead with invoicing the Order Line/s.16. In this case there will be two invoices.
1. One in AR which will be issues against Sales Order2. One in AP which will be issued against Purchase Order / Receipt.
Managing Changes in Purchasing Changes to a requisition (other than requisition cancellation) will NOT be
reflected in the reservation to the sales order. Therefore, it is recommendedthat users never change a requisition with source type CTO.
8/4/2019 Back 2 Back Orders Demo
http://slidepdf.com/reader/full/back-2-back-orders-demo 14/14
If the PO is canceled without canceling the requisition, the reservation istransferred back to the requisition. If both are canceled, the reservation isremoved. In the latter case, you can run the autocreate purchase requisitionbatch program to create a new requisition for sales order.
If a partial PO quantity canceled, or the PO qty is reduced, then the
reservation quantity is reduced accordingly. Again, run the autocreatepurchase requisition batch program to create a new requisition for theoutstanding quantity.
Receive an Assembly: When a purchase order has been reserved to the salesorder, the inventory will be automatically reserved against the sales orderwhen you receive the purchase order.
Once a sales order reservation to the PO has been removed (eitherautomatically or manually), it cannot be manually re-reserved. You canmanually reserve on-hand stock to the sales order or the autocreate purchaserequisition batch program can pick it up again and create a new supply orderalong with a new reservation.
Now if for some business reason customer needs to cancel the PO and requisition, insuch a case Cancellation of PO result in deletion of the complete record fromMTL_RESERVATION table and also B2B order line workflow rewind back to “CreateSupply Order – Eligible” workflow activity , also flow status code onOE_ORDER_LINES_ALL updated back to "Supply Eligible"Now if user cancel the requisition and once again progress the workflow it result increation of new requisition ( via requisition import) and now record in mtl_reservationtable.