Change Date

This field defaults to the current Login Date. To change the date, use the electronic calendar to select a date. This will be used by the system as the the item master or warehouse item change date..

Update options

Update item master

This is the default. Complete the fields that are shown.

Update warehouse items

When you select this option, additional fields appear.

Update both

When you select this option to update both item master and warehouse items, additional fields appear.

Include all warehouses

Use the options to tell the system the warehouse(s) to update.

NOTE that these options appear only when you select to update warehouse items.

Include all warehouses

Check the box to update all warehouses.

Select Warehouses(button)

Click the Lookup icon and use the pop-up that opens to select warehouses individually.

Select this option when you want to change or correct one item master and/or warehouse item at a time. Then complete these required fields.

When you enter or look up an item, then current item master cost and price are retrieved by the system and appear in the following fields. You can then change either one or change both.

NOTE that even when you are updating warehouse items, the cost and price come from the item master. When you click Process, the system updates the selected item for the item master and/or warehouses that you chose.

Item ID

Click the Lookup icon to display a pop-up and then select an Item ID to adjust.

Standard Unit Cost

The item master unit cost that you can adjust. Refer to the description of Manual adjustments for more information.

Unit Price

The item master unit price that you can adjust. Refer to the description of Manual adjustments for more information.

Select this option when you want to update a range of items based on their class by a percent of the amount of the item.

NOTE that when you do not specify a class range, then the system will update all items when you click Process.

The cost and price increase percentage represent how much to increase the item cost and price.

0.0000 = no change

10.0000 = an increase of 10%

-10.0000 = a decrease of 10% (a negative increase calculates as a decrease)

Examples

Note that you cannot just increase by 10% and then decrease by 10% and expect to go back to the original amount.

If the cost was $2.00 and you increase it by 10%, the new cost will be $2.20 ($2.00 + 10% of $2.00).

If the cost was $2.20 and you increase by -10%, the new cost will be $1.98 ($2.20 - 10% of $2.20).

When you click the Process button after selecting a percentage adjustment, a report automatically opens showing all items that were adjusted and the cost and price of each item.

From Class / To Class

To select a specific range of values to update, click the Lookup icon to display the pop-up  and then select a starting value. Repeat the process to select an ending value.

Neither - If you specify neither, adjustments to all classes will be processed.

From only - If you specify From and not To, the system it will adjust everything from the specified class to the end.

To only - If you specify To and not From, the system will adjust everything from the start to the end of the specified class.

Both From and To - If you specify both, the system adjusts only that range.

An actual class name does not need to be used, as you could enter AAAA to ZZZZ, for example. Whatever classes you enter appear on the last page of the report.

Entries appearing in the pop-up list are established in Item Master setup.

Standard Unit Cost Increase %

The item master unit cost that you can adjust.

Refer to the description of Percentage adjustments for more information.

Unit Price Increase %

The item master unit price that you can adjust. Refer to the description of Percentage adjustments for more information.

Process

Click to process your changes.

When making a Percentage adjustment, a report opens showing all items that were adjusted and the cost and price of each item.

1. From the Inventory menu, select Special—Utilities—Change Item Cost and Price.
2. Enter or verify the Change Date.
3. Select to update the item master, warehouse items, or both. Refer to Fields List for more information.
4. Select to make Manual adjustments or Percentage adjustments. Refer to Fields List for more information.
5. Click Process. If you selected to make Percentage adjustments, a report opens.

The permission must be set in the System module to access the Change Item Cost and Price menu item.

Permissions for Job Estimate

System module—Security—Users—Inventory—Special—Utilities—Change Item Cost and Price