Production Split Worksheet

Article • 7/2/2025 • 6 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, variant code, 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 number you 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. In the Copy Setup Time on Split to field, select the required option from the following list to control how the routing setup time is applied to the resulting lines.

        OptionDescription
        NoneThe routing setup time is not updated for any of the lines.
        First New LineIf the Split Method field is set to Line, the routing setup time is updated for the first line.
        If the Split Method field is set to Order, the routing setup time is updated for the first production order.
        First New Line per Prod. ScenarioIf the Split Method field is set to Line, the routing setup time is updated only for the first line in each production scenario.
        If the Split Method field is set to Order, the routing setup time is updated only for the first production order in each production scenario.
        All New LinesThe routing setup time is updated for all the lines.

      6. 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 and update 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 and update 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 the records on the Split Plan FastTab.