Production Split Worksheet

Article • 4/3/2023 • 5 min read

You can split a production order line into multiple orders or multiple lines within the same production order. The Production Split Worksheet page displays the information related to the production order you choose. You can split the current record by entering the number and quantities of new records you want to create.


You cannot split a production order line that has posted Consumption, Capacity, or Output entries. Also, the production order line that has Reservation entries cannot be split.

This page displays the production scenarios that are assigned with the inventories in the production orders. These production scenarios are filtered based on the location code and the unit of measure code in the production order line.


If the production scenarios are not setup for the item in the production order line, you cannot open the Production Split Worksheet page.

You can open the Production Split Worksheet page from the following pages:

To split the single production order line into multiple production orders or multiple lines

  1. Select the Search icon , enter Released Production Orders, and then choose the related link.
    The Released Production Orders list page opens.

  2. Select the required No.
    The Released Production Order page opens.

  3. On the Lines FastTab, select Functions > Production Split Worksheet.
    The Production Split Worksheet page opens.

  4. In the No. of New Records field, enter the number of new records that you want to create.

  5. In the Quantity Per New Record field, enter the quantity that every new record should contain.

  6. On the Production Scenarios FastTab, select the checkbox in the Include field for the production scenarios you want to assign to the new records. The checkbox in this field is automatically selected if the production scenario code is selected in the production order line.


    The checkbox must be selected for at least one production scenario record. If multiple production scenario records are selected, it will automatically alternate the split lines between the selected production scenarios.

  7. On the action bar, select Actions > Functions.

    1. Calculate Split Plan: Select this action to split the current record into new records.
      The Calculate Split Results page opens.
      On the General FastTab,

      1. In the Split Method field, select the Line or Order option based on the method you want to split. If you select the Line option, the current record will be split into multiple lines in the same production order. If you select the Order option, the current record will be split into new production orders.


        You should select the Order split method if the production order has multiple lines.

      2. Turn on the Use Suffix toggle to add a suffix and use the existing production order number.
        If this toggle is turned off, it will assign new production order numbers based on the No. Series assigned on the Manufacturing Setup page. The No. Series should have the Manual Nos. checkbox selected.


        The Use Suffix field is editable only when you choose the Order split method.

      3. In the Starting Suffix field, enter the numberyou want to use as a suffix for the first production order in the split line. The next production orders will follow the sequence based on this value. You can enter any value between 01 to 99. For example, if you enter 5 in this field, the new production orders will have the suffix sequence 05, 06, 07, 08, and so on.


        It will show an error when the suffix sequence exceeds 99.

      4. In the Separator field, enter the character that you want to use to separate the new production order numbers and the suffix.


        The Starting Suffix and Separator fields are displayed only when you enable the Use Suffix toggle.

      5. Click OK.
        You can see the suggested split plan on the Split Plan FastTab. You can also make changes before accepting the plan.

    2. Accept Split Plan: Select this action to create the production orders/lines based on the plan in the Split Plan FastTab.
      When you choose the Order split method,

      1. If the sum of the quantities in the split plan is equal to or greater than the quantity in the existing production order line, it will delete the existing production order and create new production orders.
      2. If the sum of the quantities in the split plan is lesser than the quantity in the existing production order line, it will create the new production orders andupdate the remaining quantity in the existing production order for the difference.
        When you choose the Line split method,
      3. If the sum of the quantities in the split plan is greater than the quantity in the existing production order line, it will delete the existing production order line andupdate the quantity in the production order header when creating the new lines in the existing production order.
      4. If the sum of the quantities in the split plan is equal to the quantity in the existing production order line, it will delete the existing production order line and create new lines in the existing production order.
      5. If the sum of the quantities in the split plan is lesser than the quantity in the existing production order line, it will update the remaining quantity in the existing production order line and create the new lines in the existing production order.
    3. Clear Split Plan: Select this action to delete all therecords on the Split Plan FastTab.