Go to primary content
Oracle® Retail Merchandising System User Guide
14.1.1
E60812-02
  Go To Table Of Contents
Contents

Previous
Previous
 
Next
Next
 

8 Cost Management

Cost Management refers to the procedure of maintaining the cost of the different items that are used in the retailer's setup and allow the user to manage any cost changes that occur during the lifecycle of these items. There are a lot of different processes which impact the cost of an item either directly or indirectly. For goods being imported, the user would need to define any duties, expenses, and assessments that directly affect the final landed cost of the item along with their respective computational basis. Goods being moved between the retailer's locations can have costs associated with this movement. Events being processed by the future cost engine which have an effect on the cost of an item at a later point of time may also be viewed by the application user.

The navigational procedure as well as the set of activities that are required to be done by the user for each of the above scenarios are described in more detail in this chapter.

The Cost Management chapter includes the following areas:

Set up Cost Changes

A cost change is an adjustment to the cost of an item, either up or down. Before you can create a cost change, a list of user defined cost change reasons are created and then applied to each cost change.

If you are tracking Estimated Landed Costs (ELC), you set up cost zones to facilitate a cost change at the location or zone level. All items are associated with zones upon item set up.

RMS uses cost zone groups to implement the most effective pricing strategy for each item. There are two types of costing strategies.

  • Zone level: The cost for the item is the same across all locations in a price zone. The landed cost for an item and supplier relationship is the same across a zone.

  • Location level: Each location can have a unique retail price for an item. The landed cost for an item and supplier relationship can also be different at each location.

To view more information on these topics, see also:

Add a Cost Change Reason

Navigate: From the main menu, select Control > Setup > Cost Change Reason > Edit. The Cost Change Reason Maintenance window opens.

Figure 8-1 Cost Change Reason Maintenance Window

Cost Change Reason Maintenance Window
  1. Click Add. The next available line is enabled.

  2. In the Code field, enter an ID for the reason.

  3. In the Description field, enter a description for the reason.

  4. Click OK to save your changes and close the window.

View Cost Zone Groups

Navigate: From the main menu, select Control > Setup > Cost Zone Group > View.

The Cost Zone Groups window opens.

View the Cost Zones Associated with a Cost Zone Group

  1. Select a cost zone group.

  2. Click Zones. The Cost Zones window opens.

  3. Click OK to save your changes and close the window.

View the Locations Associated with a Cost Zone

  1. Select a cost zone.

  2. Click Locations. The Cost Zone Locations window opens.

  3. Click OK to save your changes and close the window.

Add a Cost Zone Group

Navigate: From the main menu, select Control > Setup > Cost Zone Group > Edit. The Cost Zone Groups window opens.

Figure 8-2 Cost Zone Groups Window

Cost Zone Groups Window
  1. Click Add. The next line on the table is enabled.

  2. In the Zone Group field, enter a unique ID.

  3. In the Cost Level field, select Zone.


    Note:

    If a location cost level is not set up, you may select Location in the Cost Level field. You can create only one cost zone group at the location cost level

  4. In the Description field, enter the description of the cost zone group.

  5. To copy the zones and locations from an existing cost zone group, in the Like Group field enter the ID of the cost zone group or click the LOV button and select a cost zone group.

Maintain Competitive Pricing Information

Competitive Pricing allows you to track pricing at competitors' stores. These windows allow you to define competitors and competitor stores, and to store competitor pricing information at the item/competitor/competitor store/day level.

The Competitive Pricing windows also allow you to create competitive shopping lists and historic records of competitors' prices. Each competitor's store must be associated with a specific competitor organization and can also be associated as a competitor of one or more of your company's merchandising stores. You can create competitive shopping lists, guides for obtaining competitor pricing information, from a standard RMS item list. Information about the individuals who perform your competitive shopping can also be stored.

  • See "Create a Competitor" in the System Administration chapter

  • See "Create a Competitor's Store" in the System Administration chapter

  • See "Create an Association Between Your Store and a Competitor's Store" in the Foundation Data chapter

  • See "Create a Competitive Shopper" in the System Administration chapter

  • See "Create a Shopping List" in the Item Maintenance chapter

  • See "Record Competitor Prices" in the System Administration chapter

  • View a Competitor's Price History

Add Cost Zones to a Cost Zone Group

  1. On the Cost Zone Groups window, click Zones to add zones to the new cost zone group. The Cost Zones window opens.

    Figure 8-3 Cost Zones Window

    Cost Zones Window
  2. Click Add. The next line on the table is enabled.

  3. In the Zone field, enter a unique zone ID.

  4. In the Description field, enter a cost zone description.

  5. In the Currency field, enter the code for the currency to be used in the cost zone or click the LOV button and select the currency.

Add Locations to a Cost Zone

  1. On the Cost Zone Groups window, click Zones. The Cost Zones window opens.

  2. On the Cost Zones window, click Locations. The Cost Zone Locations window opens.

    Figure 8-4 Cost Zone Locations Window

    Cost Zone Locations Window
  3. To add a location that has not been assigned to a cost zone group, click Add.

    • In the Location Type field, select store or warehouse.

    • In the Location field, enter the location ID, or click the LOV button and select the location.

  4. To add a location to a cost zone that is currently in a different cost zone:

    • On the Cost Zones window, select the Zone that contains the location you want to put in the new zone.

    • Click Locations. The Cost Zone Locations window opens.

    • In the New Zone field, enter the zone ID of the cost zone that you would like the location to appear in, or click the LOV button and select the new cost zone.

Exit the Cost Zone Windows

Click OK to save your changes and close the windows.

View a Competitive Shopper

Navigate: From the main menu, select Control > Competitive Shopper > View. The Competitive Shopper Maintenance window opens.

  1. In the Shopper field, enter the ID of the competitive shopper, or click the LOV button and select the shopper.

  2. Click OK to close the window.

View a Competitor

Navigate: From the main menu, select Control > Competitor > View. The Competitor window opens.

  1. In the Competitor field, enter a competitor number, or click the LOV button and select a competitor.

  2. Click OK to close the window.

View a Competitor's Store

Navigate: From the main menu, select Control > Competitor > Edit. The Competitor window opens.

  1. In the Competitor field, enter the ID of the competitor, or click the LOV button and select the competitor.

  2. From the Options menu, select Competitor Stores > View. The Competitor Store Maintenance window is displayed.

  3. In the Competitor Store field, enter the ID of the competitor's store, or click the LOV button and select the store.

  4. Click OK to close the window.

View the Association Between Your Store and a Competitor's Store

Navigate: From the main menu, select Action > Organizational Hierarchy > Store. The Organizational Hierarchy Main Form window opens.

Select a store. Click View. The Store Maintenance window opens.

From the Options menu, select Assign Competitors. The Competitor Store Association window opens.

  1. Select a store.

  2. Click OK to close the window.

View a Competitor's Price History

Navigate: From the main menu, select Control > Competitive Pricing > Competitive Price History > View.

  1. In the From Date and To Date fields, select dates to create a range for your search.

  2. In the other Search Criteria fields, enter any other information to restrict your search.

  3. Click Search. RMS displays all pricing records that match your search criteria.

  4. To search for another pricing record, click Refresh.

  5. Enter different search criteria.

  6. Click Cancel to close the window.

Set Up Expenses

The landed costs functions allow you to define expenses, assessments upcharges, and combinations of both in order to track the costs involved in purchasing and moving goods from the manufacturer to the distribution center or store.

Within RMS, landed cost is defined using computation value bases (CVB), expenses, and assessments. Expenses and assessments are more generically referred to as cost components. Computation value bases describe how expenses and assessments are combined in order to provide a base for the calculation of other expenses and assessments. Assessments differ from expenses in that they are defined by a government agency.

An expense is cost component associated with moving a product from a supplier to the retailer, primarily dealing with importing. Examples include freight costs, shipping insurance, and so on. Expenses can be set up to apply to different legs of the shipment. For example, there may be an ocean freight charged for transporting goods across the ocean (between the discharge and lading ports) and then other charges associated with moving the goods from the lading port to the warehouse that is inland (for example, land freight).

View Computation Value Bases

Navigate: From the main menu, select Control > Landed Cost > CVB Maintenance > View. The computation value bases appear in the CVB Maintenance window.

  1. Select the computation value base (CVB).

  2. Click Details to view the cost components of a CVB. The cost components appear in the CVB Details window.

  3. Click OK to close the windows.

Define a Computation Value Base

Navigate: From the main menu, select Control > Landed Cost > CVB Maintenance > New.

The CVB Maintenance window opens.

Figure 8-5 CVB Maintenance Window

CVB Maintenance Window
  1. Click Add. The next available line is enabled.

  2. Enter an ID and description for the Computation Value Base (CVB).

  3. Select the types of calculations that will use the CVB.

  4. Click OK to exit, or continue to select CVB components.

Select CVB Components

  1. Click Details. The CVB Details window opens.

    Figure 8-6 CVB Details Window

    CVB Details Window
  2. Click Add.

  3. In the Component field, enter the ID of the component, or click the LOV button and select the component.

  4. In the Combination Operator field, select:

    • + (plus sign) to add the component.

    • - (minus sign) to subtract the component in the CVB.

  5. Click OK to save your changes and close the window.

Define an Assessment

Navigate: From the main menu, select Control > Landed Cost > Cost Component Maintenance > New. The Cost Component Maintenance window opens.

Figure 8-7 Cost Component Maintenance Window

Cost Component Maintenance Window
  1. In the Component fields, enter an ID and description of the component.

  2. In the Component Type field, select Assessment.

  3. In the Assessment Type field, enter the ID of the tax or fee, or click the LOV button and select the tax or fee as necessary.

  4. In the Import Country field, enter the code for the country importing the goods, or click the LOV button and select the import country.


    Note:

    When creating an import order, make sure that the import country and the import location are the same.

Define Assessments Based on the Quantity or Dimensions of the Goods

  1. In the Calculation Basis field, select Specific.

  2. In the Component Rate field, enter the monetary amount per unit.

  3. In the Component Per Count field, enter the number of units to which the rate applies.

  4. In the Component Per Count UOM, enter the abbreviation for the unit of measure to which the rate applies, or click the LOV button and select the unit of measure.

  5. Click OK to save your changes and close the window.

Define Assessments Based on a Percentage of the Goods' Value

  1. In the Calculation Basis field, select Value.

  2. In the Component Rate field, enter the percentage per unit.

  3. In the Computation Value Base, enter the ID of the CVB to which you want to attach the assessment, or click the LOV button and select the CVB. This field is optional.

  4. In the Computation Level field, enter a number to indicate the sequence in which this component should be computed in regards to other components. For example, if it should be computed first, enter 1.

  5. In the Component Currency field, enter the code for the currency in which the assessment is denominated, or click the LOV button and select the currency.

  6. In the Component Nomination fields, select the status of the assessment in relation to the other components in a CVB.

  7. Select N/A if the assessment is not included in the calculation.

  8. Select + (plus sign) to add the assessment.

  9. Select - (minus sign) to subtract the assessment.

  10. Click OK to save your changes and close the window.

Component Rate Update Window [comprtupd]

The Component Rate Update window allows the user to change the component rate information, as well as add or delete a component.

Edit the Component Rate

Navigate: From the main menu, select Control > Landed Cost > Cost Component Maintenance > Edit. The Cost Component Maintenance window opens.

Figure 8-8 Cost Component Maintenance Window

Cost Component Maintenance Window
  1. In the Component field select a component, or select the LOV button and select a component.

  2. Click Rates. The Component Rate Update window opens.

    Figure 8-9 Component Rate Update Window

    Cost Component Maintenance Window
  3. Update any pertinent information.

  4. In the Effective Date field, enter the date or select the calendar button and select a date.

  5. Click OK to save your changes and close the window.

Delete the Component Rate

  1. Select a component rate.

  2. Click Delete.

  3. Click OK to save your changes and close the window.

Add the Component Rate

Navigate: From the main menu, select Control > Landed Cost > Cost Component Maintenance > Edit. The Cost Component Maintenance window opens.

Figure 8-10 Cost Component Maintenance Window

Cost Component Maintenance Window
  1. In the Component field select a component, or select the LOV button and select a component.

  2. Click Rates. The Component Rate Update window opens.

    Figure 8-11 Component Rate Update Window

    Cost Component Maintenance Window
  3. Click Add.

  4. In the Component Rate field enter the rate.

  5. In the Per Count field, enter the count.

  6. In the Per Count UOM field, enter the per count, or select the LOV button and select the per count.

  7. In the Component Currency field enter the currency, or select the LOV button and select the currency.

  8. In the Effective Date field, enter the date or select the calendar button and select a date.

  9. Select any of the appropriate check boxes.

  10. Click OK to save your changes and close the window.

Define an Expense

Navigate: From the main menu, select Control > Landed Cost > Cost Component Maintenance > New. The Cost Component Maintenance window opens.

Figure 8-12 Cost Component Maintenance Window

Cost Component Maintenance Window
  1. In the Component fields, enter an ID and description of the component.

  2. In the Component Type field, select Expense.

  3. In the Expense Type field, select either Zone or Country.

  4. For expenses based on the quantity or dimensions of the goods:

    1. In the Calculation Basis field, select Specific.

    2. In the Component Rate field, enter the monetary amount per unit.

    3. In the Component Per Count field, enter the number of units to which the rate applies.

    4. In the Component Per Count UOM, enter the code for the unit of measure to which the rate applies, or click the LOV button and select the unit of measure.

  5. For expenses based on a percentage of the value of the goods:

    1. In the Calculation Basis field, select Value.

    2. In the Order Cost Basis field, select the base for calculating the Expense.

    3. In the Component Rate field, enter the percentage per unit.

    4. In the Computation Value Base, enter the ID of the CVB to which you want to attach the expense, or click the LOV button and select the CVB.

  6. In the Component Currency field, enter the ID of the currency in which the expense is denominated, or click the LOV button and select the currency.

  7. In the Component Nomination fields, select the status of the expense in relation to the other components in a CVB:

  8. Select N/A if the expense is not included in a calculation.

  9. Select + (plus sign) to add the expense.

  10. Select - (minus sign) to subtract the expense.

  11. Click OK to save your changes and close the window.

Set Up Outside Locations

Outside locations are those locations that are not part of the organizational hierarchy. Some examples of outside locations are entry ports, discharge ports, lading ports, return centers, bill-to locations, and destination locations.

Maintain an Outside Location

Navigate: From the main menu, select Control > Setup > Outside Locations > Edit. The Outside Locations window opens.

Figure 8-13 Outside Locations Window

Outside Locations Window

Edit an Outside Location

  1. In the Location Type field, select the type of outside location that you want to edit.

  2. In the Location field, enter the ID of the outside location, or click the LOV button and select the outside location.

  3. Edit the currency, VAT region, address, and contact information as necessary.

  4. Click OK to save your changes and close the window.

Delete an Outside Location

  1. In the Location Type field, select the type of outside location that you want to edit.

  2. In the Location field, enter the ID of the outside location, or click the LOV button and select the outside location.

  3. Click Delete.

  4. When prompted to delete the record, click Yes.

  5. Click OK to save your changes and close the window.

View an Outside Location

Navigate: From the main menu, select Control > Setup > Outside Locations > View. The Outside Locations window opens.

Figure 8-14 Outside Locations Window

Cost Component Maintenance Window
  1. In the Location Type field, select the type of outside location that you want to view.

  2. In the Location field, enter the ID of the outside location, or click the LOV button and select the outside location.

  3. Enter the jurisdiction information. This further breaks down the tax rate if different than the transaction location.

  4. Click OK to close the window.

Create an Outside Location

Navigate: From the main menu, select Control > Setup > Outside Locations > New. The Outside Locations window opens.

Figure 8-15 Outside Locations Window

Cost Component Maintenance Window
  1. In the Location Type field, select the type of location that you want to create.

  2. In the Location field, enter a unique ID and description for the outside location.

  3. In the Currency field, enter the currency code for the location, or click the LOV button and select the currency.

  4. In the Country field, enter the ID of the country in which the outside location is located.

  5. Enter the jurisdiction information. This further breaks down the tax rate if different than the transaction location.

  6. Enter optional information in the remaining fields as necessary.

  7. Click OK to save your changes and close the window.

Set Up Up Charges

An up charge is a cost associated with moving items between locations in the merchandising system. Up charges are included since there is work associated with the transfer of goods (for example, cost that the origin location incurs to prepare the items for shipping) and since locations can exist in different legal entities there is accounting between the different locations.

Each up charge has a calculation basis of value or specific, a cost basis of either weighted average cost (when using average cost method) or unit cost (when using standard cost method), component currency, and up charge group, which is used to group up charge components together to show a total sum on the Transfer Up Charge window.

The following up charge types can be applied:

  • Department up charges: Incurred when transferring items within the department or within the from and the to locations.

  • Location up charges: Tracked when both average costing (as opposed to standard costing) and estimated landed cost (ELC) is used.

  • Transfer up charges: Associated with a specific Transfer/Item/From Location/To Location combination.

  • Up charge groups: A combination of up charge components.

  • Up charge components: Charges that are incurred when transferring from a RMS store or warehouse to another RMS store or warehouse.

To view more information on these topics, see also:

Add an Up Charge to an Item

Navigate: From the Main menu, select Items> Items. The Item Search window opens. Search for and retrieve an item in edit mode. The Item Maintenance window opens. From the Options list, select Item Up Charges. The Item Up Charges window opens.

Figure 8-16 Item Up Charges Window

Item Up Charges Window
  1. In the From Group Type field of the Apply block, select the locations from which the items originate.

  2. If available, enter a From Group value, or click the LOV button and select a value.

  3. Select a value in the To Group Type field.

  4. If available, enter a To Group value, or click the LOV button and select a value.

  5. In the Component field, enter an up charge component ID or click the LOV button and select an up charge component.

  6. Update the following fields as necessary:

    • Up Charge Group: Used to group up charges together on the Transfer Up Charge window. All up charge components with the same up charge group are summed together.

    • Component Rate: The rate to be charged against the weighted average cost of the Item/To Location combinations within the department. The value in this field is a percentage if the calculation basis is Value, and a monetary amount if the calculation basis is Specific.

    • Per Count: The amount of the Per Count Unit of Measure to which the rate applies. For example, when creating an up charge that is defined as $.20 for every 10 kilograms of an item, the Per Count would be 10. This field is enabled if the calculation basis is Specific.

    • Per Count UOM: Displays the unit of measure in which the Per Count is specified. This field is enabled if the calculation basis is Specific

  7. Click Apply. The Component table is updated.

  8. Click OK to save your changes and close the window.

Add an Up Charge to Items on an Item List

Navigate: From the Main menu, select Items> Item List. The Item List Search window opens. Search for and retrieve an item list in use mode. The Item List Header window opens. From the Options list, select Create Mass Item Charge > Up Charges. The Item Up Charges window opens.

Figure 8-17 Item Up Charges Window

Item Up Charges Window
  1. In the From Group Type field of the Apply block, select the locations from which the items originate.

  2. If available, enter a From Group value, or click the LOV button and select a value.

  3. Select a value in the To Group Type field.

  4. If available, enter a To Group value, or click the LOV button and select a value.

  5. In the Component field, enter an up charge component ID or click the LOV button and select an up charge component.

  6. Update the following fields as necessary:

    • Up Charge Group: Used to group up charges together on the Transfer Up Charge window. All up charge components with the same up charge group are summed together.

    • Component Rate: The rate to be charged against the weighted average cost of the Item/To Location combinations within the department. The value in this field is a percentage if the calculation basis is Value, and a monetary amount if the calculation basis is Specific.

    • Per Count: The amount of the Per Count Unit of Measure to which the rate applies. For example, when creating an up charge that is defined as $.20 for every 10 kilograms of an item, the Per Count would be 10. This field is enabled if the calculation basis is Specific.

    • Per Count UOM: Displays the unit of measure in which the Per Count is specified. This field is enabled if the calculation basis is Specific

  7. Click Apply. The Component table is updated.

  8. Click OK to save your changes and close the window.

Add Up Charges to Items in a Department

Navigate: From the Main menu, select Action > Merchandise Hierarchy. The Merchandise Hierarchy Main Form window opens. Search for and retrieve a department in edit mode. The Department Maintenance window opens. From the Options menu, select Up Charges. The Department Up Charges window opens.

Figure 8-18 Department Up Charges Window

Department Up Charges Window
  1. In the From Group Type field of the Apply block, select the locations from which the items originate.

  2. If available, enter a From Group value, or click the LOV button and select a value.

  3. Select a value in the To Group Type field.

  4. If available, enter a To Group value, or click the LOV button and select a value.

  5. In the Component field, enter an up charge component ID or click the LOV button and select an up charge component.

  6. Update the following fields as necessary:

    • Up Charge Group: Used to group up charges together on the Transfer Up Charge window. All up charge components with the same up charge group are summed together.

    • Component Rate: The rate to be charged against the weighted average cost of the Item/To Location combinations within the department. The value in this field is a percentage if the calculation basis is Value, and a monetary amount if the calculation basis is Specific.

    • Per Count: The amount of the Per Count Unit of Measure to which the rate applies. For example, when creating an up charge that is defined as $.20 for every 10 kilograms of an item, the Per Count would be 10. This field is enabled if the calculation basis is Specific.

    • Per Count UOM: Displays the unit of measure in which the Per Count is specified. This field is enabled if the calculation basis is Specific

  7. Click Apply. The Component table is updated.

  8. Click OK to save your changes and close the window.

Adjust the Unit Costs of an Item Received by Order

Navigate: From the main menu, select Finance > Receiver Cost Adjustment. The Receiver Cost Adjustment window opens.

Figure 8-19 Receiver Cost Adjustment Window

Surrounding text describes Figure 8-19 .
  1. In the Order field, enter the number of the purchase order, or click the LOV button and select the purchase order.

  2. In the Item field, enter the item number, or click the LOV button and select the item. The cost details for the purchase order/item appear by location.

  3. Select a location. The details appear in the Apply area.

  4. In the Correct Cost field, enter the new cost per unit.

  5. Select the Supplier Cost Adjustment check box to apply the cost change for the item at the location/supplier level.

  6. Select the Apply To All Locations On Order check box to apply the cost change to the items at the order level.

  7. Click Apply.

  8. You may be prompted to enter a new average cost. Enter the average cost in the Avg Cost New field.

  9. Click Apply. The unit costs are updated for the selected location.

  10. Click Next Item or Prev Item to edit unit costs for another item on the current purchase order.

  11. Click OK to save your changes and close the window.

Create a Cost Change

The initial cost of an item is established at item set-up. The cost of the item can be adjusted in the item record until the status of the item is Approved or Unapproved. Any cost changes will need to be handled through the cost change windows.

When submitted through EDI, you review the cost change, then submit the cost change for approval.

When entered manually, you enter the cost change, an event description, an effective date, and a reason code. Then submit the cost change for approval.


Note:

You cannot create a cost changes for a transformed sellable item.

After you approve the cost change, the Item/Supplier cost record is updated and any outstanding purchase orders that have not been received are recalculated.

Create a Cost Change

Navigate: From the main menu, select Costing > Cost Change. The Cost Change Search window opens.

Figure 8-20 Cost Change Search Window

Cost Change Search Window

Note:

There are two additional ways in which to access the Cost Change by Supplier window: - From the main menu, select Items > Items. In the Item Search window, select New Cost Change in the Action field and search for the item to be edited; - From the main menu, select Items > Item List. In the Item List Search window, select Use in the Action field and search for an item list to be edited. Select Create Cost Change from the Options menu.

  1. In the Action field, select New.

  2. Click OK. The Cost Change by Supplier window opens.

    Figure 8-21 Cost Change by Supplier Window

    Cost Change by Supplier Window
  3. In the Cost Change field, enter a description for the cost change.

  4. In the Item, Supplier, and Country field, enter the item number or ID of each as necessary, or click the LOV button and select the item, supplier, or country.

  5. In the Reason field, enter the ID of the reason for the cost change, or click the LOV button and select the reason.

  6. In the Effective Date field, enter the date on which the cost changes become effective.

  7. Click Search. The records that match the search criteria appear.

Change Cost at the Item/Supplier/Country of Sourcing Level

  1. In the box on the left, select the type of item number you want to view.

    • Item: Displays the item ID.

    • Ref Item: Displays the ID of the child item.

    • VPN: Displays the vendor product number for the item.

  2. Select the type of adjustment in the Apply block.

  3. Enter the change in the box next to the selected option.

    • Change in Percent: Enter the percent by which the cost changes. Use a negative symbol (-) before the percent to indicate a decrease in cost by percent.

    • Change in Amount: Enter the amount by which the cost changes. Use a negative symbol (-) before the percent to indicate a decrease in cost by amount.

    • Fixed Cost: Enter the new cost of the item. The amount entered becomes the cost of all items selected for cost change.

  4. Click Apply. The new costs per unit are calculated.

  5. Edit the monetary amounts in the New Unit Cost field next to each item as necessary.

  6. Select the Recalc Orders check box next to each item or supplier if you want to update the costs on approved or unapproved purchase orders.

Change Costs at the Item/Supplier/Country of Sourcing/Location Level

  1. Select a supplier or item record and click Locations. The locations associated with the item/supplier/country of sourcing appear in the Cost Change by Location window.

    Figure 8-22 Cost Change by Location Window

    Cost Change by Location Window
  2. Select the type of adjustment in the Apply block.

  3. Enter the change in the box next to the selected option.

    • Change in Percent: Enter the percent by which the cost changes. Use a negative symbol (-) before the percent to indicate a decrease in cost by percent.

    • Change in Amount: Enter the amount by which the cost changes. Use a negative symbol (-) before the percent to indicate a decrease in cost by amount.

    • Fixed Cost: Enter the new cost of the item. The amount entered becomes the cost of all items selected for cost change.

  4. In the Loc Type field, select a grouping mechanism.

  5. In the Location field, enter the ID of the specific location or group, or click the LOV button and select the location or group.

  6. In the Bracket field, enter the bracket, or click the LOV button and select the bracket.


    Note:

    The Bracket field is enabled when you select warehouse group type in the Loc. Type field.

  7. Click Apply. The new costs per unit are calculated.

  8. Edit the monetary amounts in the New Unit Cost field next to each item as necessary.

  9. Select the Recalc Orders check box if you want to update the costs on approved or unapproved purchase orders.

  10. Click OK to save your changes and close the window.

Future Cost Event Log window [costeventlog]

This form will display the status of all events being processed or already processed by the future cost engine. The form will allow users to view any issues that occurred during the process.

View Future Cost Event Log

Navigate: From the main menu, select Costing > Future Cost Event Log. The Future Cost Event Log window opens.

Figure 8-23 Future Cost Event Log Window

Cost Change by Location Window
  1. In the Event field, enter an event or click the LOV button to select an event.

  2. In the Event Type field, enter an event type or click the LOV button to select an event type.

  3. In the Status field, select a status from the drop down option.

  4. In the Event Date From field, enter a date or click the calendar button and select a date.

  5. In the To field, enter a date or click the calendar button and select a date.

  6. In the User ID field, enter an ID or click the LOV button and select an ID.

  7. Click Search. The results are listed in the table.

  8. Select the event type in the table.

  9. From the View menu, select Detail. The Cost Change Detail window opens.

  10. Click OK to close the window.

  11. From the View menu, select Audit. The Audit window opens.

  12. Click OK to close the window.

  13. From the View menu, select Threads for cost event. The Future Cost Event Thread window opens.

  14. In the Status field, select a status from the drop down option.

  15. In the Thread field, select a thread or click the LOV button to select a thread.

  16. Click Search. The results are listed in the table.

  17. Select the Process checkbox of the item you want to process.

  18. Click Process. The item is processed.

  19. Click OK to close the window and save your changes.

Edit a Cost Change

Navigate: From the main menu, select Costing > Cost Change. The Cost Change Search window opens. Search for and retrieve a cost change in Edit mode. Restrict the search to cost changes in worksheet or submitted status. The Cost Change by Supplier window opens.

Figure 8-24 Cost Change by Supplier Window

Cost Change by Supplier Window

In the Cost Change field, edit the description of the cost change as necessary.

Edit Costs at the Item/Supplier/Country of Sourcing Level

  1. To add a supplier or item:

    1. Click Add.

    2. Select a supplier or item from the list of values that opens.

  2. To edit a supplier or item:

    1. Select a record.

    2. Select a Delivery Country associated with the supplier.

    3. Select a record.

    4. When prompted to delete the record, click Yes.

  3. To delete a supplier or item:

    1. Select a record and click Delete.

    2. When prompted to delete the record, click Yes.

  4. Select the type of adjustment in the Apply block. Then enter the monetary amount or percentage in the box next to the selected option.

  5. Click Apply. The new retail values and costs per unit are calculated.

  6. Edit the monetary amounts in the New Unit Cost field next to each item as necessary.

  7. Select the Recalc Orders check box next to each item or supplier if you want to update the costs on approved or unapproved purchase orders.

Edit Costs at the Item/Supplier/Country of Sourcing/Location Level

  1. Select a supplier or item record and click Locations. The locations associated with the item/supplier/country of sourcing appear in the Cost Change by Location window.

    Figure 8-25 Cost Change by Location Window

    Cost Change by Location Window
  2. To add a location:

    1. Click Add.

    2. Select a location from the list of values that opens.

  3. To delete a location:

    1. Select a location and click Delete.

    2. When prompted to delete the record, click Yes.

  4. Select the type of adjustment in the Apply block. Then enter the monetary amount or percentage in the box next to the selected option.

  5. In the Loc Type field, select a grouping mechanism.

  6. In the Location field, enter the ID of the specific location or group, or click the LOV button and select the location or group.

  7. In the Bracket field, enter the bracket, or click the LOV button and select the bracket.


    Note:

    The Bracket field is enabled when you select a warehouse in the Location field.

  8. Click Apply. The new retail values and costs per unit are calculated.

  9. Edit the monetary amounts in the New Unit Cost field next to each item as necessary.

  10. Select the Recalc Orders check box if you want to update the costs on approved or unapproved purchase orders.

  11. Click OK to save your changes and close the window.

Cost Change Search Window [ccfind]

The Cost Change Search window allows you to enter criteria in order to search for cost change events and view the results of the search.

The default view for the Cost Change Search window opens when you open the window for the first time. You can also create a custom view.

Search for a Cost Change

Navigate: From the main menu, select Costing > Cost Change. The Cost Change Search window opens.

  1. In the Action field, select either Edit or View.

  2. In the Origin field, select Cost.

  3. Enter additional criteria as desired to make the search more restrictive.

  4. Click Search. The Price Change Search window displays the cost changes that match the search criteria.

  5. Select a task:

    1. To perform another search, click Refresh.

    2. To display the details of a cost change, select a record and click OK. The details appear in the Cost Change by Supplier window.

  6. Click Close to close the window.

Delete a Cost Change

Navigate: From the main menu, select Costing > Cost Change. The Cost Change Search window opens. Search for and retrieve a cost change in Edit mode. Restrict the search to cost changes in Worksheet, Submitted, or Rejected status. The Cost Change by Supplier window opens.

Figure 8-26 Cost Change by Supplier Window

Cost Change by Supplier Window
  1. From the Options menu, select Delete. You are prompted to delete the cost change.

  2. Click Yes. The cost change is deleted. The Cost Change Search window opens.

    Figure 8-27 Cost Change Search Window

    Cost Change Search Window
  3. Click Close to save your changes and close the window.

Edit a Cost Change Reason

Navigate: From the main menu, select Control > Setup > Cost Change Reason > Edit. The Cost Change Reason Maintenance window opens.

Figure 8-28 Cost Change Reason Maintenance Window

Cost Change Reason Maintenance Window
  1. Edit the description as necessary.

  2. To delete a cost change reason:

    • Select a reason.

    • Click Delete. You are prompted to delete the record.

    • Click Yes.

  3. Click OK to save your changes and close the window.

Accept Cost Changes Received Through EDI

Navigate: From the main menu, select Items > EDI Cost Changes. The New EDI Cost Changes window opens.

Figure 8-29 New EDI Cost Changes Window

New EDI Cost Changes window
  1. In the Supplier field, enter the ID of the supplier, or click the LOV button and select the supplier.

  2. In the Create Date field, enter the date on which the cost changes were received, or click the LOV button and select the date. The items that match the criteria appear.

  3. In the Description field, enter a description for the cost change event.

  4. In the Reason field, enter the ID of the reason for the cost change, or click the LOV button and select the reason.

  5. In the Cost Change Approval Method area, select an approval method.

  6. In the Status field, select either Accepted or Rejected for each cost change.


    Note:

    To accept all the cost changes, click Accept All.

  7. Select the Recalc Orders check box next to each cost change if you want to update the cost on unapproved purchase orders.

  8. Select the Update Children check box next to each cost change if you want to apply the change to subordinate items.

  9. Click OK to save your changes and close the window.

View additional details about the item

  1. Select an item.

  2. Click Item Detail. The details appear in the Item Maintenance window.

  3. Click OK to close the windows.

Delete a Cost Component from a Non-Merchandise Code

Navigate: From the main menu, select Control > Setup > Non-Merchandise Codes > Edit. The Non-Merchandise Codes Maintenance window opens.

Figure 8-30 Non-Merchandise Codes Maintenance Window

Non-Merchandise Codes Maintenance Window

Note:

This window is only available when you are using Oracle Retail Trade Management (RTM) with RMS. If simplified RTM is used, the functionality may differ.

  1. Select a non-merchandise code in the table.

  2. Click Cost Comp. The Non-Merchandise Cost Components window opens.

  3. Select a cost component in the table.

  4. Click Delete. You are prompted to delete the component.

  5. Click Yes.

  6. Click OK to close the window and save your changes.

Add a Cost Component for a Non-Merchandise Code


Note:

This window is only available when you are using Oracle Retail Trade Management (RTM) with RMS. If simplified RTM is used, the functionality may differ.

Navigate: From the main menu, select Control > Setup > Non-Merchandise Codes > Edit. The Non-Merchandise Codes Maintenance window opens.

  1. Select a non-merchandise code in the table.

  2. Click Cost Comp. The Non-Merchandise Cost Components window opens.

  3. Click Add.

  4. On the next available line, enter the ID of the cost component in the Component ID field, or click the LOV button and select a cost component.

  5. Click OK to save your changes and close the window.

Cost Change Approval Process

For a cost change to take affect, it needs to be in approved status. Depending on your user role, you may be able to move the cost change to the next status. A cost change may be in any of the following statuses:

Table 8-1 Cost Change Statuses

Status Status definition

Worksheet

The cost change event is incomplete. You can edit, submit, or delete the cost change event.

Submitted

The cost change event is complete and submitted for approval. You can approve, reject, or delete the cost change event.

Approved

The cost change event is complete and has been approved. You can return the cost change event to Worksheet status for editing or cancel the cost change event.

Rejected

The cost change event is complete and has been approved. You can return the cost change event to Worksheet status for editing or cancel the cost change event.

Extracted

The details of the cost change event were extracted to the locations affected by the cost change event. Only cost change events in Approved status are extracted.

Canceled

The details of the cost change event were extracted to the locations affected by the cost change event. Only cost change events in Approved status are extracted.


Submit a Cost Change for Approval

Navigate: From the main menu, select Costing > Cost Change. The Cost Change Search window opens. Search for and retrieve a cost change in Edit mode. Restrict the search to cost changes in Worksheet status. The Cost Change by Supplier window opens.

Figure 8-31 Cost Change by Supplier Window

Cost Change by Supplier Window
  1. From the Options menu, select Submit.

  2. When prompted to submit the cost change, click Yes. The status of the cost change changes to Submitted.

  3. Click OK to save your changes and close the window.

Approve a Cost Change

Navigate: From the main menu, select Costing > Cost Change. The Cost Change Search window opens. Search for and retrieve a cost change in Edit mode. Restrict the search to cost changes in Submitted status. The Cost Change by Supplier window opens.

  1. From the Options menu, select Approve.

  2. When prompted to approve the cost change, click Yes. The status of the cost change changes to Approved.

  3. Click OK to save your changes and close the window.

Reject a Submitted Cost Change

Navigate From the main menu, select Costing > Cost Change. The Cost Change Search window opens. Search for and retrieve a cost change event in Edit mode. Restrict the search to cost changes in Submitted status. The Cost Change by Supplier window opens.

  1. From the Options menu, select Reject. You are prompted to reject the cost change.

  2. Click Yes. The status of the cost change changes to Rejected.

  3. Click OK to save your changes and close the window.

Cancel an Approved Cost Change

Navigate: From the main menu, select Costing > Cost Change. The Cost Change Search window opens. Search for and retrieve a cost change in Edit mode. Restrict the search to cost changes in Approved status. The Cost Change by Supplier window opens.

  1. From the Options menu, select Cancel. You are prompted to cancel the cost change.

  2. Click Yes. The status of the cost change changes to Cancelled.

  3. Click OK to save your changes and close the window.