5 Create an Average Cost Adjustment

The Average Cost Adjustment page allows you to enter a new average cost for an item at a selected location.

Figure 5-1 Average Cost Adjustment Page

Average Cost Adjustment window

The Average Cost Adjustment Page displays the following fields.

Table 5-1 Average Cost Adjustment - Fields and Description

Fields Description

Item

Enter, or search for the item for which you want to adjust the average cost.

Location

Select the location type (valid values are store and warehouse). Then enter, select or search for the location for which you want to adjust the average cost.

Stock:

This section allows you to view the item and pack item component on hand and in transit quantities at a location.

Right side of the section header displays the UOM (unit of measure) for the stock quantities shown.

Item - On Hand

Displays the stock on hand of the item at the selected location.

Item - In Transit

Displays the stock of the item in transit to the selected location.

Pack Item Component - On Hand

Displays the stock on hand of the pack item component at the selected location.

Pack Item Component - In Transit

Displays the stock of the pack item component in transit to the selected location.

Total

Displays the total stock on hand of the item at the selected location.

Adjust Average Cost:

This section allows you to view the current costs of an item at a location and allows you to change the average cost.

Right side of the section header shows the location currency.

Unit Cost

Displays the unit cost of the item at the selected location.

Current Average Cost

Displays the current average cost of the item at the selected location.

New Average Cost

Enter the new average cost for the selected item/location.

Average Cost Adjustment Toolbar

The toolbar contains the following button, as well as icons and buttons described in “Screen Level Action - Icons and Buttons" in the Oracle Retail Merchandising Do the Basics User Guide.

Table 5-2 Average Cost Adjustment Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Tran Data button

Opens the Transaction Data page. The item/location information is populated in the search criteria in the Search section.

For more information about the Transaction Data page, see the "View Transaction Data" chapter.

Save and Close

Click Save and Close to save the entered records and close the page.

Save and Create Another

Click Save and Create Another to save the entered records and create a new average cost adjustment.

The menu contains the following options. In both cases, the new average cost field is reset and the user has to enter a new value.

  • New Item and Location

    Any value you have entered in the New Average Cost field for a given item/location combination, is saved. The page is reset. Select a new item/location combination.

  • Same Item/New Location

    Any value you have entered in the New Average Cost field is saved. The location-related fields are reset. Select a new location for the item.

Adjust the Average Cost for an Item/Location

To adjust the average cost for an item at a selected location, follow the steps below.

  1. From the Tasks menu, select Finance > Average Cost Adjustment. The Average Cost Adjustment page appears.

  2. In the Item field, enter, or search for the item.

  3. In the Location field, select the location type from the list. Then enter, select or search for the location.

  4. In the New Average Cost field, enter the new cost for the item at the selected location.

  5. Then choose one of the saving options. For more information about the available options, see the Average Cost Adjustment Toolbar section.