Gen. Reference: Updating Stages in Preexisting Cut Routings

This article applies to Bundle-Track versions 3.6 and above.

When you edit a Lot Routing, those changes do not normally affect preexisting Cut Routings. However, with this procedure, you can edit a Lot Routing's Stages and push those updates to preexisting Cuts.

Requirements:

• Administrative access to IB Console
• the report file(s)
• knowledge of how to use IB Console's ISQL to ...
  • load a script (procedure)
  • execute a script/statement/command (procedure)

Procedure:

1. Edit the Lot Routing as desired.
    
2. Download this UpdateCutStagesByLot.sql script to your Desktop.
   1. Right-click on the link above.
   2. Choose Save Target As ...
   3. Save the file to your Desktop.
       
3. Get ISQL ready to run your commands.
   • If you don't know how, click here to learn, and then return.
      
4. Run the script in ISQL:
   1. Use ISQL's menu to select Query >> Load Script.
   2. Use the Open dialog to locate and open the UpdateCutStagesByLot.sql script.
      • This is the file that you saved to your desktop in the step above.
   3. Execute (Click the lightning bolt icon.)
       
5. Copy the following statements into ISQL:
   • execute procedure UpdateCutStagesByLot 'LotCode';
     commit;  
      
6. Edit the statements:
   • Change 'LotCode' to the actual Code of the Lot you have edited and whose Cuts you wish to update.
      
7. Execute and note the result.
   • After you run the script, if the result is anything but 'Finished Successfully', expand the result message box so you can read the whole message, and take appropriate action.
       
8. Drop the UpdateCutStagesByLot procedure:
   • Execute the following commands in ISQL:
     • drop procedure UpdateCutStagesByLot;
       commit;
        
9. Delete the UpdateCutStagesByLot.sql file from your desktop.

We welcome your comments at support@bundle-track.com.

If you would like our live assistance, you may hire us at our professional services rate.