Order Multiple and Transfer Multiple Validation

In this article

To validate changed quantity against the Order Multiple

To validate changed quantity against the Transfer Multiple

Usage of Purchase Unit of Measure in Replenishment Journal

Usage of Transfer Unit of Measure in Replenishment Journal

See also

While the Quantity would have been rounded to a full multiple value during the Replenishment Journal calculation, you can manually adjust the Quantity in the journal which could result in a non-full multiple value. To prevent this, the system can be set up to validate the changed quantity against the Order Multiple, Transfer Multiple, or even the Purchase Unit of Measure.

To validate changed quantity against the Order Multiple

When the Quantity is changed in the Purchase Replenishment Journal, you can validate if the Quantity fulfills the Order Multiple assigned to the item. To activate the option:

  1. Click the icon, enter Replen. Setup, and select the relevant link.
  2. In the Integration FastTab, the Order Multiple group, select Warn if Not Full Multiple in the Replen. Journal Quantity Warning field.

When the warning is activated, if the changed Quantity does not fulfill the Order Multiple of the item, a warning message is displayed showing the details, such as the Item No., Vendor No., and Location Code where the violation first occurred.

You can also validate the Quantity against the Purch. Unit of Measure of the item, where the changed value should be a full multiple based on the Qty. per Unit of Measure of the Purchase Unit of Measure. For more information, see the Usage of Purchase Unit of Measure in Replenishment Journal section below.

To validate changed quantity against the Transfer Multiple

When the Quantity is changed in the Transfer Replenishment Journal, you can validate if the Quantity fulfills the Transfer Multiple assigned to the item. To activate the option:

  1. Click the icon, enter Replen. Setup, and select the relevant link.
  2. In the Integration FastTab, the Transfer Multiple group, select Warn if Not Full Multiple in the Replen. Journal Quantity Warning field.

When the warning is activated, if the changed Quantity does not fulfill the Transfer Multiple of the item, a warning message is displayed showing the details, such as the Item No. and Location Code where the violation first occurred.

The Transfer Multiple is also used to validate the Quantity to Cross Dock field when the Purchase Replenishment Journal is calculated with cross docking enabled.

Note: When updating the Quantity or Quantity to Cross Dock in the Threshold Exceptions Purch. Details or Threshold Exceptions Transf. Details page, whether or not the changed value results in a non-full multiple value is specified with the Qty. Not in Full Multiple or Cross Dock Qty. Not in Full Multiple check boxes.

Usage of Purchase Unit of Measure in Replenishment Journal

Below are some basic setups that are available in the Replen. Setup page, in the Integration FastTab, Purchase UoM group to enable you to use the Purch. Unit of Measure assigned to the item in Replenishment calculation. Available setups:

Purch. UoM Updates Multiple Field

This setup is used to determine if the item's Order Multiple field and the Item Store Rec's Purchase Order Multiple field will be updated with the value setup for Qty. per Unit of Measure when the Purch. Unit of Measure of the item is changed. The multiple fields will also be updated when the Qty. per Unit of Measure field is changed, if the quantity changed belongs to the Purch. Unit of Measure currently assigned to the item.

There are three options to choose from:

  • Never - the item's Order Multiple and Item Store Rec's Purchase Order Multiple fields will never be updated.
  • With Confirmation - you are asked if you wish to update the item's Order Multiple and Item Store Rec's Purchase Order Multiple fields.
  • Without Confirmation - the item's Order Multiple and Item Store Rec's Purchase Order Multiple fields will always be updated.

Note: A field named Lock Order Multiple is available on the Replen. Item Store Rec page to allow its relevant record to lock its Purchase Order Multiple from being updated when its item's Purch. Unit of Measure is altered.

Purch. Replen. Journal Quantity Warning

This setup is to define if a warning will be displayed when the quantity being changed in the Purchase Replenishment Journal is not in full multiple, based on the Qty. per Unit of Measure of the Purch. Unit of Measure assigned to the item. The setup consists of these options:

  • No Warning
  • Warn if Not Full Multiple

Note: This setup is not applicable to the BOM Purchase Replenishment Journal because Purchase Order is not created in the journal.

Purch. Replen. Journal UoM Handling

This setup is to enable the creation of a Purchase Order from the Purchase Replenishment Journal in Purch. Unit of Measure. When the Purchase Order is created, the Unit of Measure is changed from Base Unit of Measure to Purch. Unit of Measure, if the quantity ordered is in full multiple based on the Qty. per Unit of Measure of the Purch. Unit of Measure assigned to the item.

For example, the Purch. Unit of Measure for an item is set to BOX and it is known that there are 50 PCS in 1 BOX, examples of full multiples would be 50, 100, or 150 PCS since they are equivalent to 1, 2, or 3 BOXES.

This setup consist of the below options:

  • Keep Calculated Base UoM - the Unit of Measure will be kept as it is and will not be converted in the Purchase Order.
  • Convert to Purch. UoM if Possible - the Unit of Measure will be converted to Purch. Unit of Measure in the Purchase Order, if the quantity is in full multiple.

Example:

Samantha Dress has the following Units of Measure setup:

  • Base Unit of Measure = PCS
  • Purch. Unit of Measure = BOX (1 BOX contains 50 PCS)

The Purchase Replenishment Journal is calculated and 100 PCS of Samantha Dress will be purchased.

When the Purchase Order is created from the Replenishment Journal, the quantity to be ordered for Samantha Dress will be converted to 2 BOX as 100 PCS is a full multiple.

Usage of Transfer Unit of Measure in Replenishment Journal

Below are some basic setups that are available in the Replen. Setup page, in the Integration FastTab, Transfer UoM group to enable you to use the Transf. Unit of Measure assigned to the item in Replenishment calculation. Available setups:

Transf. UoM Updates Multiple Field

This setup is used to determine if the item's Transfer Multiple field and the Item Store Rec's Transfer Multiple field will be updated with the value setup for Qty. per Unit of Measure when the Transf. Unit of Measure of the item is changed. The multiple fields will also be updated when the Qty. per Unit of Measure field is changed, if the quantity changed belongs to the Transf. Unit of Measure currently assigned to the item.

There are three options to choose from:

  • Never - the item's Transfer Multiple and Item Store Rec's Transfer Multiple fields will never be updated.
  • With Confirmation - you are asked if you wish to update the item's Transfer Multiple and Item Store Rec's Transfer Multiple fields.
  • Without Confirmation - the item's Transfer Multiple and Item Store Rec's Transfer Multiple fields will always be updated.

Note: A field named Lock Transfer Multiple is available on the Replen. Item Store Rec page to allow its relevant record to lock its Transfer Multiple from being updated when its item's Transf. Unit of Measure is altered.

Replen. Journal UoM Handling

This setup is to enable the creation of a Transfer Order from the Transfer Replenishment Journal or from the Purchase Replenishment Journal with Cross Docking in Transf. Unit of Measure. When the Transfer Order is created, the Unit of Measure is changed from Base Unit of Measure to Transf. Unit of Measure, if the quantity ordered is in full multiple based on the Qty. per Unit of Measure of the Transf. Unit of Measure assigned to the item.

For example, the Transf. Unit of Measure for an item is set to BOX and it is known that there are 50 PCS in 1 BOX, examples of full multiples would be 50, 100, or 150 PCS since they are equivalent to 1, 2, or 3 BOXES.

This setup consist of the below options:

  • Keep Calculated Base UoM - the Unit of Measure will be kept as it is and will not be converted in the Transfer Order.
  • Convert to Transf. UoM if Possible - the Unit of Measure will be converted to Transf. Unit of Measure in the Transfer Order, if the quantity is in full multiple.

Example:

Samantha Dress has the following Units of Measure setup:

  • Base Unit of Measure = PCS
  • Transf. Unit of Measure = BOX (1 BOX contains 50 PCS)

The Transfer Replenishment Journal is calculated and 100 PCS of Samantha Dress will be transferred.

When the Transfer Order is created from the Replenishment Journal, the quantity to be ordered for Samantha Dress will be converted to 2 BOX as 100 PCS is a full multiple.

See also

Create Purchase and Transfer Orders