Apply Product Line Information - Fields Home | FAQs & Troubleshooting

 

Apply Product Line Information

Apply to Inventory Items

Select the check box for each field that contains updated information that you want to apply to the items selected in the Item Code field. The selections made in the corresponding field(s) in Product Line Maintenance will be applied to those items in the selected product line. Clear the check box for each field that you want to exclude from the update.

The Allocate Landed Cost check box is available only if the Allow Entry of Landed Cost check box is selected in Purchase Order Options.

The Confirm Cost Increase check box is available only if the Purchase Order module is integrated with Inventory Management.

The Explode Kit Items check box is available only if the Sales Order module is integrated with Inventory Management.

The Allow Returns and Restock Methd/Chrg check boxes are available only if the Return Merchandise Authorization module is installed.

The Warranty Code check box is available only if the Enable Warranty Tracking check box is selected in Inventory Management Options.

The Internet Enabled check box is available only if the eBusiness Manager module is installed.

Note Internet-enabled items cannot be inactive. If you select the Inactive Item check box in both Product Line Maintenance and this window, when you click Proceed, the Internet Enabled check box in Item Maintenance will be cleared and disabled for the selected items/product line.

The Lot/Serial Expiration Settings check box is available only if the Enable Lot/Serial Expiration Dates check box is selected in Inventory Management Options.

 

Category

Enter a category for the Internet items selected in the Item Number field, or click the Lookup button to list all categories. At least one category must be defined for an item in order for the item to display on the Products and Services Web page.

Note This field is available only if the eBusiness Manager module is installed, and the Internet Enabled check box is selected.

 

Apply to Open Items

Select the Sales Orders and/or Purchase Orders check boxes to update product line information to items included on open sales orders or open purchase orders. Clear the check boxes if you do not want to update this information.

The Sales Orders check box is available only if the Commission Method and/or Sales Tax Class check boxes are selected, and the Sales Order module is integrated with Inventory Management. The Purchase Orders check box is available only if the Purchases Tax Class check box is selected, and the Purchase Order module is integrated with Inventory Management.

If the Sales Orders and/or Purchase Orders check boxes are selected, and the Sales Tax Class and/or Purchases Tax Class check boxes are selected, the taxable/non-taxable total amounts on the sales order or purchase order are changed based on the Sales Tax Class and/or Purchases Tax Class check box setting.

 

Operand

Select an operand to limit your selection to a particular value or range of values. When selecting a value using the Lookup button or entering a value directly into the Value field (and moving out of the field), the operand automatically changes to Equal to. Likewise, when selecting a value using the Lookup button for a range or entering values directly into both Value fields, the operand automatically changes to Range.

The following operands are available:

Operand	Operand Function
All	Selects all information for the Select Field.
Begins with	Selects only the information for the Select Field that begins with the value entered in the Value field.
Ends with	Selects only the information for the Select Field that ends with the value entered in the Value field.
Contains	Selects only the information for the Select Field that contains the value entered in the Value field.
Less than	Selects only the information for the Select Field that is less than, but not equal to, the value entered in the Value field.
Greater than	Selects only the information for the Select Field that is greater than or equal to the value entered in the Value field.
Range	When Range is selected, two Value fields are used. Information is selected that is greater than or equal to the first value entered and less than or equal to the second value entered in the Value fields. Note Entries in the "From" Value field may change to the entry made in the "To" Value field, if the "From" Value contains a lowercase letter and the "To" Value contains an uppercase letter. This occurs because lowercase letters are greater than uppercase letters. For example, if 01a is entered in the "From" Value field and 01C is entered in the "To" Value field, the "From" Value field changes to 01C.
Equal to	Selects only the information for the Select Field that is equal to the value entered in the Value field.
Not Equal to	Selects only the information for the Select Field that is not equal to the value entered in the Value field.

 

Additional operands are available for date Select fields. The system date is used to calculate the date ranges. When one of the date operands is selected, the Value fields automatically default to the appropriate dates.

You can use commas (,) to separate multiple values; however, if your selection values already contain commas, you must use alternate separators to separate them.

Note When alternate separators are used, the value list must end with the alternate separator character.

The alternate separators include the following:

~ ! @ # $ % ^ & * ( ) = [ ] \ ; " / _ + { } | : < > ?

Note If you enter a value that contains a comma (for example, if a vendor number is 01-SAGE,WEST), then you must enclose the value with an alternate separator (for example, %01-SAGE,WEST%). Because the comma is a separator, if the value is not enclosed in alternate separators, the system can search for two incorrect values (for example, "01-SAGE" and "WEST", instead of "01-SAGE,WEST").

If your company uses commas in item codes, use an alternate separator to select one or multiple item codes.

 

Note Any changes to the product line information are applied to these items.

 

Value

Enter a value based on the operand entered, or click the Lookup or Calendar button to select a value from the list. Multiple values can be entered by using a comma or alternate separators to separate values.

For customer number, vendor number, and item code select fields, you can start typing a customer name, vendor name, or item description to locate a record. As you type, a list of records matching your entry appears. You can then select a record from the list.

Note If Country Code is an option in the Select field, and your source documents have no value in the Country Code field, the default Country Code entered in Company Maintenance is used as selection criteria for those documents.

You can enter single or multiple values as follows:

Operand	Value
All	Selects all information for the Select Field.
Begins with	Multiple values are separated by a comma or alternate separator. An OR condition is assumed.
Ends with	Multiple values are separated by a comma or alternate separator. An OR condition is assumed.
Contains	Multiple values are separated by a comma or alternate separator. An OR condition is assumed.
Less than	Only single values are allowed.
Greater than	Only single values are allowed.
Range	Both Value fields are used to define a range. Only single values are allowed at each Value field.
Equal to	Multiple values are separated by a comma or alternate separator. An OR condition is assumed.
Not Equal to	Multiple values are separated by a comma or alternate separator. An AND condition is assumed.

Note If you enter a value that contains a comma (for example, if a vendor number is 01-SAGE,WEST), then you must enclose the value with an alternate separator (for example, %01-SAGE,WEST%). Because the comma is a separator, if the value is not enclosed in alternate separators, the system can search for two incorrect values (for example, "01-SAGE" and "WEST", instead of "01-SAGE,WEST").