Automatic Cost
and Price Change
Show/Hide All
Select the method to use to change the standard cost of the items selected.
Select No Change in Cost for the standard cost of the item to remain the same.
Select Percentage for the standard cost of the item to be increased or decreased based on the value entered in the Cost Change Rate field.
Select Amount for the standard cost of the item to be increased or decreased based on the value entered in the Cost Change Amount field.
Select Use Last Cost for the standard cost of the item to be set to the value from the Last Cost field in Item Maintenance.
Select Use Average Cost for the standard cost of the item to be set to the value from the Average Cost field in Item Maintenance.
Note If the item has a Standard Cost valuation method, you must use the Standard Cost Adjustment Entry task to change the standard cost.
Type the rate (percentage or dollar) of the cost change. Type a positive number to increase the cost or a negative number to decrease the cost. This field is available only if Percentage or Amount is selected in the Cost Change Method field.
Enter....
If....
15
you want to increase the cost by a positive number or amount.
-15
you want to decrease the cost by a negative number or amount.
Select the method to use to change the price of the items selected.
Select No Change in Price for the standard and/or retail price of the item to remain the same.
Select Percentage of Price for the standard and/or retail price of the item to be increased or decreased based on the value entered in the Price Change Rate field.
Select Amount for the standard and/or retail price of the item to be increased or decreased based on the value entered in the Price Change Amount field.
Select Percentage of Cost for the standard and/or retail price of the item to be increased or decreased based on the value entered in the Price Change Rate field and the item's standard cost.
Note If cost is being changed at the same time, then the new standard cost is used in the calculation.
Standard Cost
Price Change Rate
New Standard/Retail Price
$100
10.00%
$110
Select Amount to Cost for the standard and/or retail price of the item to be increased or decreased based on the value entered in the Price Change Amount field and the item's standard cost. For example, if the standard cost of the item equals $100 and the price change amount is set to $25, then the standard and/or retail price is set to $125.
Note If cost is being changed at the same time, then the new standard cost is used in the calculation.
Standard Cost
Price Change Amount
New Standard/Retail Price
$100
$25
$125
Type the rate (percentage or dollars) of the price change. Type a positive number to increase the price or a negative number to decrease the price. This field is available only if Percentage of Price, Amount, Percentage of Cost, or Amount to Cost is selected at the Price Change Method field.
Select the price type to change. This field is available only if Percentage of Price, Amount, Percentage of Cost, or Amount to Cost is selected in the Price Change Method field.
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.
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").
