Revise Formula

This activity enables you to revise formulae. Active formulae cannot be modified, but can only be revised. On revising a Formula-Version, a new version of the Formula gets created with ‘Inactive’ status. The formula revision helps in tracking the variations of the formula used at various points of time.

Select the “Revise Formula” activity link under the “Formula Model” business component.

The “Revise Formula” page appears.

The system displays the following:

Status

The status of the formula, which is “Active”.

Active – indicates the status of the formula, when all mandatory fields have been entered. Only the “Active” formulas can be revised.

Enter the following:

Formula	The code identifying the formula to be revised (Alphanumeric, 12) Mandatory.
	Help facility available
Version	The number identifying the version, which is attached to each formula (Integer). Whenever the formula is revised, a new version of that Formula is created.

The system displays the following:

Formula Class

The code identifying the formula class.

Enter the following:

Description	The textual description of the “Formula” (Alphanumeric, 100). Mandatory.
Effective From	The date starting from which the formula is effective (Date Format). Mandatory
Effective To	The date until which the formula is effective (Date Format). This date must not be earlier than the “Effective From” date.
Instruction	The code identifying the instruction, which is attached to the formula (Alphanumeric, 255).
	Help facility available

The system displays the following:

Description

The textual description of the instruction.

Enter the following:

Remarks

Any additional information pertaining to revising the formula (Alphanumeric, 255).

The system displays the following:

Item Code	The code identifying the item to be used in the formula.
Variant	The variant of the item.
IO Type	The type of the item, which could be one of the following: Primary Input – indicates raw material or intermediate. In certain industries processing one input item can lead to multiple output items. The input item in such a case is defined as “Primary Input”. Primary Product – indicates finished good or intermediate. In certain industries multiple input items blend to produce a singe output item. The output item in such a case is defined as “Primary Product”.
Description	The textual description of the formula.

Enter the following:

Quantity	The quantity of the item required in the formula (Integer). Mandatory
UOM	The unit of measurement of the item.
	Help facility available

Enter the following in the “Formula Details” multiline:

Serial Number	The serial number of the item/instruction (Alphanumeric, 16). If this number is not entered for any of the rows, the system generates the line number for each item/instruction sequentially at the time of revising the formula.
IO Type	Use the drop-down list box to select the Type. The system lists the following: Co-Product – indicates items that are produced together with the “Primary Product” By-Product – indicates unwanted product, which are produced along with the “Primary Product”. Recycle – indicates secondary output, which can be recycled. Instruction – indicates the instruction id attached to the formula. Instruction Text – indicates additional information on usage of formula.
Item/Instruction	The code identifying the item/instruction, which is attached to the formula (Alphanumeric, 255).
	Help facility available
Variant	The item variant used in the formula (Alphanumeric, 08).

The system displays the following:

Item/Instruction Description

The textual description of the Item or instruction.

Enter the following:

Quantity

The quantity of the item - mandatory for Items of Type Primary Input or Primary Product. For other Items, if Quantity is not entered, system will default Quantity as ‘0’.

Note: Quantity can be in fractions only if the UOM has been set as “Allow fractions” in the “Create UOM” activity of the “UOM Administration” business component.

UOM	The unit of measurement of the item variant.
	Help facility available
Scaling	Use the drop-down list box to select the scaling type of the item quantity, which could be “Fixed” or “Variable”. Scaling is applicable only for items of Type ‘Input’ or ‘Primary Input’. Fixed – indicates the quantity specified for the input item is the same for all quantities of the “Output Item”. Variable – indicates the quantity specified for the input item varies for different Quantities of the Output Item.
Positive Tolerance %	The positive tolerance is the upper limit within which the quantity received can vary (Integer). Here, the tolerance limit affects the quantity positively.
Negative Tolerance %	The negative tolerance is the lower limit within which the quantity received can vary (Integer). Here, the tolerance limit affects the quantity negatively.
Secure View	Use the drop-down list box to specify whether a row can be viewed outside “Formula Model” business component Yes – indicates that the row cannot be viewed outside “Formula Model” business component. No - indicates that the row can be viewed outside Formula Model business component.
Loss%	The percentage indicating the loss incurred for input items (Integer). The loss% is calculated only for the input items. The loss occurs while transporting, storage, operation etc. If any value is not specified in this field, the system displays “Zero” by default.

The system displays the following:

Item Type

The Item type could be “Raw Material”, “Intermediate”, ”Utility’, “Finished Good” or “Scrap”.

Enter the following:

Remarks

Any additional comment pertaining to the revising the formula (Alphanumeric, 255).

Enter the following in the “Yield Information” group box:

Yield ID	The code identifying the yield. Based on the arithmetic combination of the input and output quantities, “Yield” is calculated (Alphanumeric, 32). This calculation enables you to analyze the production of the “Primary Product” while the actual reporting of item is made for the Production Order using this formula.
	Help facility available

Click the “Compute Yield%” pushbutton to calculate the yield percentage.

Yield %

The percentage of the yield expected for the output items (Integer).

The system displays the following:

Expression

Expression of the Yield Id used in the formula.

The system displays the following:

Created By	The name of the user who created the formula.
Created Date	The date on which the formula was created.
Last Modified By	The name of the user who last modified the formula.
Last Modified Date	The date on which the formula was last modified

Click “Revise” to update the revision details.
Click the “Revise and Activate ” button, if you wish to revise and activate the formula.

The formula must be activated for revising, only when the user is provided with the access rights.

To proceed, carry out the following

Select the “ Maintain Alternate Quantity Information” link at the bottom of the page to specify alternate Qty information for items of a formula.
Select “Attach Notes” link at the bottom of the page to attach the notes.