SOE Duplicate Checking Parameters Control Maintenance Records

The following control maintenance records belong to the SOE (Sales Order Entry) category and apply to duplicate checking parameters.

Allow Material Detail Type/Tag-SubType Duplicates

Indicate whether the system allows duplicate Tag/Type and SubType combinations on the Lot Item Material Detail window for master orders. ClosedMore:

Options

  • Yes - Allows duplicates.

  • No - Prevents duplicates.

  • Prompt - Prompts users whenever they enter duplicate entries.

Outcome of setting this control record

The system displays this setting in the Allow Type/Tag-SubType Duplicates field on the Lot Item Material Detail / Lot Detail Additional Information window. Users must be assigned the OE.LOT.OVRD.TYPE.DUPS authorization key to edit this field.

Default Value(s)

No

Action if set to Null

Same as if set to No.

Additional Information

None

Duplicate Customer P/O Number Check

Indicate whether the system checks sales orders for duplicate customer purchase order numbers. The validation is not case sensitive. For example, TEST123 and test123 are considered to be duplicates. ClosedMore:

Options

  • Yes - The system checks for duplicate customer purchase order numbers on all open or invoiced sales orders for the bill-to customer and any of its associated ship-to customers. If the system finds a duplicate number for the bill-to or any of its related ship-to accounts, the system displays the following prompt: Customer P/O # Already on File. Continue? N. Answering Yes at the prompt allows use of the duplicate number.

  • No - The system does not check sales orders for duplicate customer purchase order numbers.

Outcome of setting this control record

The value you enter determines the action the system takes when a user enters a value in the Customer P/O # field on the Header tab in sales order entry.

Default Value(s)

No

Action if set to Null

Same as if set to No.

Additional Information

You can override the setting in this record at the customer level using the Disable Duplicate P/O# / Order Check option in the Miscellaneous Customer Information window.

Duplicate Order Check

Indicate whether the system checks whether the item being entered on a sales order is already on an existing order the customer has placed in the same branch. ClosedMore:

Options

  • Yes - Checks for the item on orders with the customer has placed at the same branch.. If found, the system warns that you may be creating a duplicate order for the item.

  • No - Does not check for the item on orders the customer has placed at the same branch.

Outcome of setting this control record

If set to Yes, the system checks all existing open orders and any closed orders with ship dates that are found within the time period specified in the Duplicate Order History Days To Checkcontrol maintenance record.

Entering a negative order quantity for a returned item does not trigger a duplicate order check and the system does not present returns as possible duplicate orders.

Products with a LotItem status do not trigger a check for duplicates.

Default Value(s)

No

Dependencies

  • To include closed orders within a specific date range in the check, set the Duplicate Order History Days To Checkcontrol maintenance record.

  • To include bids in the check, set the Duplicate Bid Days To Checkcontrol maintenance record to a value greater than zero.

  • If set to Yes and the system finds a duplicate order, the order writer must be assigned the SOE.DUP.ORDER.OK authorization key to continue to add the item to the order.

Action if set to Null

Same as if set to No.

Additional Information

You can override the setting in this record at the customer level using the Disable Duplicate P/O# / Order Check option in the Miscellaneous Customer Information window.

You can override the setting in this record at the product level using the Disable Duplicate Order Check option on the Product Miscellaneous Information window.   

Duplicate Order History Days To Check

Enter the number of days prior to and including the current day for which the system checks open and invoiced orders for duplicate items. ClosedMore:

Options

Any number of days between 0 and 99999.

Outcome of setting this control record

The system checks open and invoiced orders based on the ship date for the specified number of days prior to and including the current day for the item entered on a sales order.

Products with a LotItem status do not trigger a check for duplicates.

Default Value(s)

31

Example(s)

For example, if you enter 1, the system checks only the current day. If you enter 30, the system checks the current day and the 29 previous days.

Dependencies

Set the Duplicate Order Checkcontrol maintenance record to Yes for this record to take effect.

Action if set to Null

If blank or set to zero, the system does not check open or invoiced orders for possible duplicates, regardless of the setting in the Duplicate Order Checkcontrol maintenance record.

Additional Information

None

Duplicate Product Check On Current Order

Indicate whether the system checks all products on all open generations of an order for a match when a user enters a product on a sales order. ClosedMore:

Options

  • Yes - The system checks for duplicates on all generations of the order.

  • No - The system does not check for duplicate products on the same order.

Outcome of setting this control record

If set to Yes, and a product is already on the order on the same or a different generation, the system displays a message telling you that the product is already on the order, along with the line number where the product was previously entered.

Products with a LotItem status do not trigger a check for duplicates. The duplicate product check is never in effect for consignment billings. It is in effect for consignment transfers, but only for comparing consignment transfers that involve the same customer and the same product.

Default Value(s)

No

Action if set to Null

Same as if set to No.

Additional Information

The setting in the Disable Duplicate P/O# / Order Check option in the Miscellaneous Customer Information window does not override this record for the customer.

You can override the setting in this record at the product level using the Disable Duplicate Order Check option on the Product Miscellaneous Information window.