Go to primary content
Oracle® Retail Merchandising Foundation Cloud Service Oracle Retail Merchandising System User Guide
Release 19.3.000
F83161-01
  Go To Table Of Contents
Contents

Previous
Previous
 
Next
Next
 

14 Application Administration

In order to optimally configure the application, the user is provided with a set of windows which allow viewing, editing, and maintenance of system parameters which help customize various defaults and constants that are used throughout the system. The parameters range from setting the application UI features such as the decimal precision in which quantity values should be displayed, setting up important business features that are used by retailers such as Value Added Tax (VAT), Banners, Channels, and so on. The majority of these parameters should be defined during the system implementation and changes to any of the parameters thereafter requires careful planning.

System Options

The system options module provides a means of maintaining the relatively static information about a retailer's business.

Many of the system variables must be set during installation and cannot be changed without major implications. Most system variables are specific to functional areas such as ordering, pricing, transfers, stock ledger and history. While some indicators dictate the level at which these functions perform, others indicate the length of time that the data is maintained for these areas.

In addition to the functional variables, other variables span all functional areas and determine how the system must perform as a whole. Some of these variables include the multiple currency indicator, primary language, and system dates.

You can access the System Options window from the Task menu, select Application Administration > System Options. The System Options window appears.

The System Options window contains the following sections.

System

The System section contains the general information in Merchandising such as the language, currency, calendar, and the base country of the business.

Figure 14-1 System Section

System section

Financials

The Financials section contains the options for stock ledger, sales, and other financial information.

Figure 14-2 Financials Section

Financials section

Foundation

The Foundation section contains the merchandise level settings.

Figure 14-3 Foundation Section

Foundation section

Functional

The Functional section contains the options to determine if functions, such as importing, contracts, franchise, deals, and replenishment are supported in the system. It also determines the unit of measure (UOM) information used across the system.

Figure 14-4 Functional Section

Functional section

Inventory

The Inventory section contains the options for inventory movements. This section is divided into the following subsections.

Replenishment

This section displays replenishment variables.

Figure 14-5 Replenishment Section

Replenishment section

Shipment

This section displays shipment variables.

Figure 14-6 Shipment Section

Shipment section

Transfers and Returns to Vendor

This section displays transfer and returns to vendor variables.

Figure 14-7 Transfers and RTVs Section

Transfers and RTVs section

Allocation

This section displays allocation variables.

Figure 14-8 Allocation Section

Allocation section

Sales and Returns

This section contains sales and returns variables.

Figure 14-9 Sales and Returns Section

Sales section

Stock Counts

This section displays stock counts variables.

Figure 14-10 Stock Counts

Stock Counts section

Localization

The Localization section contains the options for taxations in Merchandising.

Figure 14-11 Localization Section

Localization section

Procurement

The Procurement section contains the settings for order related options.

Figure 14-12 Procurement Section

Procurement section

Data Retention

The Data Retention section contains the options for setting the data retention.

Figure 14-13 Data Retention Section

Data Retention section

RTM

The RTM section contains the Retail Trade Management (RTM) related options.

Figure 14-14 RTM Section

RTM section

Security

The Security section contains the options for setting how the data is maintained in the system.

Figure 14-15 Security Section

Security section

Integration

The Integration section determines which business applications are integrated with Merchandising (for example, Advanced Inventory Planning (AIP), Store Inventory, Sales Audit, and so on). This section also contains configurations for the software integrations.

Figure 14-16 Integration Section

Integrated Application section

System Options Toolbar

The toolbar contains the following icons and buttons.

Table 14-1 System Options Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon Help icon

You can access the online help for a particular page by clicking the Help icon Help icon.

Expand and Collapse icon Expand and Collapse icon

You can expand all the sections and collapse all the sections in the window by clicking the Expand and Collapse icon Expand and Collapse icon.

Save

Click Save to save the entered records.

Save and Close

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

Cancel

Click Cancel to reject all entries and close the window.

Done

If you open the window in view mode, the Done button is displayed.

Click Done to close the window.


Report Options

The report options module helps you configure/setup the options available for the Dashboard and the Contextual Reports.

You can access the Report Options window from the Task menu, select Application Administration > Report Options. The Report Options window appears.

The Report Options window contains the following sections.

Cross Report Option

The Cross Report Option section contains inventory variance to forecast and order alerts, filter location type, stock count location exception count information.

Figure 14-17 Cross Report Option Section

Cross Report Option section

Cumulative Markon Variance Report

The Cumulative Markon Variance Report section contains the options variance threshold and minimum variance information.

Figure 14-18 Cumulative Markon Variance Report Section

Cumulative Markon Variance Report section

Early/Late Shipments Report

The Early/Late Shipments Report section contains the beginning of week to estimated arrival date, estimated arrival date top open to buy date, not after date to end of week, and display OTB information.

Figure 14-19 Early/Late Shipments Report

Early Late Shipments Report section

Inactive Items and Inactive Item Locations Report

The Inactive Items and Inactive Item Locations Report section contains display items created and display items last transferred information.

Figure 14-20 Inactive Items and Inactive Item Locations Report Section

Inactive Items and Inactive Item Locations Report section

Incomplete Items Report

The Incomplete Items Report section contains the different attributes of an item, based on which the item can be categorized as an incomplete item.

Figure 14-21 Incomplete Items Report Section

Incomplete Items Report section

Inventory Variance to Forecast Report

The Inventory Variance to Forecast Report section contains lower inventory variance and upper inventory variance information.

Figure 14-22 Inventory Variance to Forecast Report

Inventory Variance to Forecast Report section

Late Posted Transactions Report

The Late Posted Transactions Report section contains transaction count threshold, location count threshold, and organizational hierarchy display level information.

Figure 14-23 Late Posted Transactions Report Section

Late Posted Transactions Report section

Negative Inventory Report

The Negative Inventory Report section contains quantity threshold information.

Figure 14-24 Negative Inventory Report Section

Negative Inventory Report section

Order Alerts Report

The Order Alerts Report section contains the validate reference items check box and include factory check related options.

Figure 14-25 Order Alerts Report

Order Alerts Report section

Orders Pending Approval Report

The Orders Pending Approval Report section contains the show worksheet orders.

Figure 14-26 Orders Pending Approval Report Section

Orders Pending Approval Report section

Overdue Shipments Report

The Overdue Shipments Report section contains the past expected receipt date.

Figure 14-27 Overdue Shipments Report Section

Overdue Shipments Report section

Shrinkage Variance Report

The Shrinkage Variance Report section contains the maximum variance, variance tolerance, and variance count options.

Figure 14-28 Shrinkage Variance Report Section

Shrinkage Variance Report section

Stock Count Unit Variance Report

The Stock Count Unit Variance Report section contains variance threshold option.

Figure 14-29 Stock Count Variance Report Section

Stock Count Unit Variance Report section

Stock Count Value Variance Report

The Stock Count Value Variance Report section contains variance threshold option.

Figure 14-30 Stock Count Value Variance Report

Stock Count Value Variance Report section

Stock Counts Missing Report

The Stock Counts Missing Report section contains past count date days option.

Figure 14-31 Stock Counts Missing Report Section

Stock Counts Missing Report section

Stock Orders Pending Close Report

The Stock Orders Pending Close Report section contains past receipt date days option.

Figure 14-32 Stock Orders Pending Close Report Section

Stock Orders Pending Close Report section

Transfers Pending Approval Report

The Transfers Pending Close Report section contains past creation date days option.

Figure 14-33 Transfers Pending Approval Report Section

Transfers Pending Close Report section

Unexpected Inventory Report

The Unexpected Inventory Report section contains the configurations such as the threshold inventory level above which the item/location will appear in this report. Other configurations can also be made to make the item/location records be pulled in this report.

Figure 14-34 Unexpected Inventory Report Section

Unexpected Inventory Report section

WAC Variance Report

The WAC Variance Report section contains maximum variance, variance tolerance, and variance count information.

Figure 14-35 WAC Variance Report Section

WAC Variance Report section

Report Options Toolbar

The toolbar contains the following icons and buttons.

Table 14-2 Report Options Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon Help icon

You can access the online help for a particular page by clicking the Help icon Help icon.

Expand and Collapse icon Expand and Collapse icon

You can expand all the sections and collapse all the sections in the window by clicking the Expand and Collapse icon Expand and Collapse icon.

Save

Click Save to save the entered records.

Save and Close

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

Cancel

Click Cancel to reject all entries and close the window.

Done

If you open the window in view mode, the Done button is displayed.

Click Done to close the window.


Translate Data

You can create, modify and delete translations of data in Merchandising. This can be done in two different ways.

  • for a single entity at a time

  • by viewing all entities that have translatable values and translate them in a centralized page.

Translate Multiple Entities

The Translations page is a centralized page where you can see all entities that have translatable values in Merchandising.

Perform the following procedure to translate an entity:

  1. From the Tasks menu, select Application Administration > Translations. The Translations page appears.

    Figure 14-36 Translations Page

    Translations Page

    Depending on the entity to translate you have selected in the header, the title of the search results section varies.

    For example, if you select an Entity to Translate of 'Warehouse', the title of this section will be 'Warehouse' and a list of all existing warehouses in the system will display in the table. You can select the row containing the desired warehouse to see any existing translations in the Translations table below.

Translations

The Translations section contains all available translations of the selected entity to translate. Existing translations can be modified directly in the table.

Use the Actions Menu and icons to apply actions to the table. In addition to editing existing translations, you can add new translations or delete existing translations. For more information about how to add translations, see the Add a Translation section.

Translate a Single Entity

The Translate page for a single entry displays the primary language and the current language in the top right corner. The table of the Translate page displays the language and the corresponding description for the entry. Existing translations can be modified directly in the table.

There are two scenarios you may encounter when translating a single entity:

Figure 14-37 Translate page - Single Entity

Translate window Single Entry

Add a Translation

To add a translation, follow the steps below.

  1. Select Actions > Translate or use the Translate icon Translate icon, if available. The Translate page appears.

    Figure 14-38 Translate Page - Single Entity

    Translate window Single Entry
  2. In the table, select Actions > Add, or use the Add icon Add icon. The Add Translation pop-up appears.

    Figure 14-39 Add Translation

    Add Translation dialog
  3. In the Language field, select the desired language from the list. This field is a required field.

  4. In the Description field, enter the desired translation. This field is a required field. Depending on the entity being translated, there may be more than one translation field that is required to be entered. For example, item descriptions have up to three descriptions that can be translated - the long description, the secondary description, and the short description.

  5. Then choose one of the following options.

    • Click OK to add the translation to the table and close the page.

    • Click OK and Add Another to add additional translations.

    • Click Cancel to reject all entries and close the page.

Edit a Translation

To edit a translation, follow the steps below.

  1. Select Actions > Translate or use the Translate icon Translate icon, if available. The Translate page appears.

    Figure 14-40 Edit a Translation

    Edit a translation
  2. Edit the description directly in the table (the fields are in-line editable).


    Note:

    The Language field cannot be edited. If a desired language is no longer wanted, the row should be deleted and a new row added for the desired language.

  3. Click OK to update the translation and close the page.

Asynchronous Job Log

The asynchronous job log is used for viewing and reprocessing asynchronous jobs in Merchandising.

  • Search for asynchronous jobs by various search criteria

  • View the search results

You can access the Asynchronous Job Log window from the Task menu, select Application Administration > Asynchronous Job Log. The Asynchronous Job Log window appears.

The window contains the following two sections.

Figure 14-41 Asynchronous Job Log Window

Asynchronous Job Log window

Search for an Asynchronous Job

To search for an asynchronous job:

  1. From the Task menu, select Application Administration > Asynchronous Job. The Asynchronous Job Log window appears.

  2. You can search for an asynchronous job by using basic or advanced search criteria, depending on the requirement. The basic mode is the default search mode.

    • Click Advanced to access the search section in advanced mode.

    • Click Basic to return to the basic mode.

Search for an Asynchronous Job Log Through the Basic Search Criteria

To search for an asynchronous job by using basic search criteria

  1. Enter, select or search for one or all of the following basic search criteria.

    Table 14-3 Asynchronous Job Log Search - Basic Search Criteria and Description

    Fields Description

    Match option

    Check radio button All or Any.

    All - only jobs matching all entered search criteria are shown.

    Any - jobs matching any of the entered search criteria are shown.

    Job

    Enter, select or search for the job.

    Job Type

    Enter, select or search for the job type.

    Status

    Select a status from the list.

    Date

    Enter a date or use the Calendar icon to select a date.

    Initiated By

    Enter, select or search for the user, the job has been initiated by.


  2. Click on the Saved Search list to select one of the saved search criteria. Selecting a saved search populates the search section with the saved search criteria. If the run automatically function is enabled for the search, the search is executed immediately.

    You can also personalize your saved searches by selecting Personalize. The Personalize Saved Searches window appears.

    For more information about the Personalized Saved Search, see the Common User Interface Controls chapter, section "Manage Saved Searches".

  3. Click Search. The jobs that match the search criteria are displayed in the Results section.

  4. Click Reset to clear the search section and results.

  5. Click Save As... to save the current search criteria. The Create Saved Search window appears.

    For more information about how to save your search criteria, see the Common User Interface Controls chapter, section "Create a Saved Search".

  6. Click Done to close the window.

Search for an Asynchronous Job Through Advanced Search Criteria

To search for an asynchronous job by using advanced search criteria, follow the steps below.

  1. To search by using advanced search criteria, enter or select one or all of the advanced search criteria.

  2. To narrow down the search, use the list next to the search fields. For example, determine if the entered value should equal or not equal the search result.

  3. Click on the Saved Search list to select one of the saved search criteria. Selecting a saved search populates the search section with the saved search criteria. If the run automatically function is enabled for the search, the search is executed immediately.

    You can also personalize your saved searches by selecting Personalize. The Personalize Saved Searches window appears.

    For more information about the Personalized Saved Search, see the Common User Interface Controls chapter, section "Manage Saved Searches".

  4. Click Search. The jobs that match the search criteria are displayed in the Results section.

  5. Click Reset to clear the search section and results.

  6. Click Save As... to save the current search criteria. The Create Saved Search window appears.

    For more information about how to save your search criteria, see the Common User Interface Controls chapter, section "Create a Saved Search".

  7. Click Add Fields to add more fields for the advanced search. To remove the field from the search, click the x right next to the field.

  8. Click Reorder to change the order of the available search fields. The Reorder Search Fields window appears.

    • Select the desired search field and use the up and down arrows to rearrange the order of the fields.

    • Click OK to confirm the new order of the fields and exit the Reorder Search Fields window.

    • Click Cancel to reject any changes and close the window.

  9. Click Done to close the window.

Results

The Results section lists the retrieved asynchronous jobs.

Results - Actions Menu and Icons

Use the Actions Menu and icons to apply actions to the table. You can perform the actions listed below.

Table 14-4 Results - Actions Menu/Icons and Description

Actions Menu/Icons Description

Export to Excel and Export to Excel icon Export to Excel icon

You can copy the records in the table to a Microsoft Excel spreadsheet by selecting Actions > Export to Excel or by using the Export to Excel icon Export to Excel icon.

Reprocess or Reprocess icon Reprocess icon

Use the Reprocess option or the Reprocess icon Reprocess icon to reprocess asynchronous jobs.


Results - View Menu and Icons

You can customize the view of the table. Use the View Menu and icons to customize the view as listed below.

Table 14-5 Results - View Menu/Icons and Description

View Menu/Icons Description

Columns

You can manage which of the columns will be shown in the table by clicking the Show All and Manage Columns options.

Detach and Detach icon Detach icon

You can view the tables in the application in a separate window by clicking Detach or using the Detach icon Detach icon.

Sort

You can sort columns by the following options:

  • Ascending

  • Descending

  • Advanced

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

Query by Example and Query by Example icon Query by Example icon

You can filter the items by one or multiple column values by clicking the Query by Example option or by using the Query by Example icon Query by Example icon.


Details

The Details section displays job details such as attempt number, date, retried by and errors.

Details - Actions Menu and Icons

Use the Actions Menu and icons to apply actions to the table. You can perform the actions listed below.

Table 14-6 Details - Actions Menu/Icons and Description

Actions Menu/Icons Description

Export to Excel and Export to Excel icon Export to Excel icon

You can export the records in the table to a Microsoft Excel spreadsheet by selecting Actions > Export to Excel or by using the Export to Excel icon Export to Excel icon.

Wrap icon Wrap icon

You can wrap the values in the table column by first clicking the column on which you would like the text to wrap and then using the Wrap icon Wrap icon.


Details - View Menu and Icons

You can customize the view of the table. Use the View Menu and icons to customize the view as listed below.

Table 14-7 Details - View Menu/Icons and Description

View Menu/Icons Description

Columns

You can manage which of the columns will be shown in the table by clicking the Show All and Manage Columns options.

Detach and Detach icon Detach icon

You can view the tables in the application in a separate window by clicking Detach or using the Detach icon Detach icon.

Sort

You can sort columns by the following options:

  • Ascending

  • Descending

  • Advanced

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

Query by Example and Query by Example icon Query by Example icon

You can filter the items by one or multiple column values by clicking the Query by Example option or by using the Query by Example icon Query by Example icon.


Asynchronous Job Log Toolbar

The toolbar contains the following icons and buttons.

Table 14-8 Asynchronous Job Log Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon Help icon

You can access the online help for a particular page by clicking the Help icon Help icon.

Done

Click Done to close the window.


Cost Event Search

The Future Cost Events option opens the Cost Event Search window. In this window you can perform the following actions.

  • Search for cost events by various search criteria

  • View the search results

  • View cost events

  • Edit cost events

You can access the Cost Event Search window from the Task menu, select Foundation Data > Application Administration > Future Cost Events. The Cost Event Search window appears.

The Cost Event Search window contains the following sections.

Figure 14-42 Cost Event Search Window

Cost Event Search window

Search for a Cost Event

To search for a cost event:

  1. From the Task menu, select Foundation Data > Application Administration > Future Cost Events. The Cost Event Search window appears.

  2. You can search for a cost event by using basic or advanced search criteria, depending on the requirement. The basic mode is the default search mode.

    • Click Advanced to access the search section in advanced mode.

    • Click Basic to return to the basic mode.

Search for a Cost Event Through the Basic Search Criteria

To search for a cost event using basic search criteria:

  1. Enter, select or search for one or all of the following basic search criteria.

    Table 14-9 Cost Event Search - Basic Search Criteria and Description

    Fields Description

    Match option

    Check radio button All or Any.

    All - only cost events matching all entered search criteria are shown.

    Any - cost events matching any of the entered search criteria are shown.

    Event

    Enter, select or search for the cost event ID.

    Type

    Select the cost type from the list.

    Status

    Select the status from the list.

    Created Date

    Enter a create date or use the Calendar icon to select a date.

    Created By

    Enter, select or search for user.


  2. Click on the Saved Search list to select one of the saved search criteria. Selecting a saved search populates the search section with the saved search criteria. If the run automatically function is enabled for the search, the search is executed immediately.

    You can also personalize your saved searches by selecting Personalize. The Personalize Saved Searches window appears.

    For more information about the Personalized Saved Search, see the Common User Interface Controls chapter, section "Manage Saved Searches".

  3. Click Search. The cost events that match the search criteria are displayed in the Results section.

  4. Click Reset to clear the search section and results.

  5. Click Save As... to save the current search criteria. The Create Saved Search window appears.

    For more information about how to save your search criteria, see the Common User Interface Controls chapter, section "Create a Saved Search".

  6. Click Done to close the window.

Search for a Cost Event Through Advanced Search Criteria

To search for a cost event using advanced search criteria:

  1. To search using advanced search criteria, enter or select one or all of the advanced search criteria.

  2. To narrow down the search, use the list next to the search fields. For example, determine if the entered value should equal or not equal the search result.

  3. Click on the Saved Search list to select one of the saved search criteria. Selecting a saved search populates the search section with the saved search criteria. If the run automatically function is enabled for the search, the search is executed immediately.

    You can also personalize your saved searches by selecting Personalize. The Personalize Saved Searches window appears.

    For more information about the Personalized Saved Search, see the Common User Interface Controls chapter, section "Manage Saved Searches".

  4. Click Search. The cost events that match the search criteria are displayed in the Results section.

  5. Click Reset to clear the search section and results.

  6. Click Save As... to save the current search criteria. The Create Saved Search window appears.

    For more information about how to save your search criteria, see the Common User Interface Controls chapter, section "Create a Saved Search".

  7. Click Add Fields to add more fields for the advanced search. To remove the field from the search, click the x right next to the field.

  8. Click Reorder to change the order of the available search fields. The Reorder Search Fields window appears.

    • Select the desired search field and use the up and down arrows to rearrange the order of the fields.

    • Click OK to confirm the new order of the fields and close the window.

    • Click Cancel to reject any changes and close the window.

  9. Click Done to close the window.

Results

The Results section lists the retrieved suppliers and supplier sites.

Results - Actions Menu and Icons

Use the Actions Menu and icons to apply actions to the table. You can perform the actions listed below.

Table 14-10 Results - Actions Menu/Icons and Description

Actions Menu/Icons Description

Edit and Edit icon Edit icon

Select Actions > Edit, use the Edit icon Edit icon, or click on the event link to edit the selected cost event.

For more information about how to edit a cost event, see the Edit a Cost Event section.

Export to Excel and Export to Excel icon Export to Excel icon

You can export the records in the table to a Microsoft Excel spreadsheet by selecting Actions > Export to Excel or by using the Export to Excel icon Export to Excel icon.


Results - View Menu and Icons

You can customize the view of the table by using the options in the View Menu.

Table 14-11 Results - View Menu/Icons and Description

View Menu/Icons Description

Columns

You can manage which of the columns will be shown in the table by clicking the Show All and Manage Columns options.

Detach and Detach icon Detach icon

You can view the tables in the application in a separate window by clicking Detach or using the Detach icon Detach icon.

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

Query by Example and Query by Example icon Query by Example icon

You can filter the items by one or multiple column values by clicking the Query by Example option or by using the Query by Example icon Query by Example icon.


Cost Event Search Toolbar

The toolbar contains the following icons and buttons.

Table 14-12 Cost Event Search Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon Help icon

You can access the online help for a particular page by clicking the Help icon Help icon.

Done

Click Done to close the window.


Cost Event Window

The Cost Event window displays the status of all events being processed or already processed by the future cost engine. The window allows you to view any issues that occurred during the process.

The Cost Event window contains the following sections.

Figure 14-43 Cost Event Window

Cost Event window

Event Details

The Event Details section displays a table with the future cost event details. The information shown in this section depends on the selected event type.

Possible event types are:

  • Deal

  • Cost Change

  • Cost Zone Location Move

  • Deal Passthrough

  • Estimated Landed Cost Component

  • Item Cost Zone Changes

  • Merchandise Hierarchy

  • New Item Location

  • Organizational Hierarchy

  • Primary Pack Cost

  • Reclassification

  • Item Supplier Country Location Relationship Changes

  • Supplier Hierarchy

  • WF Cost Template

  • WF Cost Template Relationship

  • Change of Costing Location

  • Retail Change

Event Details - Actions Menu and Icons

Use the Actions Menu and icons to apply actions to the table. You can perform the actions listed below.

Table 14-13 Event Details - Actions Menu/Icons and Description

Actions Menu/Icons Description

Export to Excel and Export to Excel icon Export to Excel icon

You can export the records in the table to a Microsoft Excel spreadsheet by selecting Actions > Export to Excel or by using the Export to Excel icon Export to Excel icon.

Wrap icon Wrap icon

You can wrap the values in the table column by first clicking the column on which you would like the text to wrap and then using the Wrap icon Wrap icon.


Event Details - View Menu and Icons

You can customize the view of the table by using the options in the View Menu.

Table 14-14 Event Details - View Menu/Icons and Description

View Menu/Icons Description

Columns

You can manage which of the columns will be shown in the table by clicking the Show All and Manage Columns options.

Detach and Detach icon Detach icon

You can view the tables in the application in a separate window by clicking Detach or by using the Detach icon Detach icon.

Sort

You can sort columns by the following options:

  • Ascending

  • Descending

  • Advanced

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

Query by Example and Query by Example icon Query by Example icon

You can filter the items by one or multiple column values by clicking the Query by Example option or by using the Query by Example icon Query by Example icon.


Threads

The Threads section displays all threads for the given event. You can choose to process a thread by clicking the Process checkbox. Upon clicking the Save or Save and Close button the checked thread is processed.

Threads - Actions Menu and Icons

Use the Actions Menu and icons to apply actions to the table. You can perform the actions listed below.

Table 14-15 Threads - Actions Menu/Icons and Description

Actions Menu/Icons Description

Export to Excel and Export to Excel icon Export to Excel icon

You can export the records in the table to a Microsoft Excel spreadsheet by selecting Actions > Export to Excel or by using the Export to Excel icon Export to Excel icon.

Item Supplier Country Locations per Thread

You can view the item supplier locations per thread:

  • Select a record in the table.

  • Select Actions > Item Supplier Country Locations per Thread. The Item Supplier Country Locations per Thread window appears.

  • View the item supplier locations per thread.

  • Click OK to close the window.

For more information about this window, see the Item Supplier Country Locations per Thread section.

Wrap icon Wrap icon

You can wrap the values in the table column by first clicking the column on which you would like the text to wrap and then using the Wrap icon Wrap icon.


Threads - View Menu and Icons

You can customize the view of the table by using the options in the View Menu.

Table 14-16 Threads - View Menu/Icons and Description

View Menu/Icons Description

Columns

You can manage which of the columns will be shown in the table by clicking the Show All and Manage Columns options.

Detach and Detach icon Detach icon

You can view the tables in the application in a separate window by clicking Detach or by using the Detach icon Detach icon.

Sort

You can sort columns by the following options:

  • Ascending

  • Descending

  • Advanced

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

Query by Example and Query by Example icon Query by Example icon

You can filter the items by one or multiple column values by clicking the Query by Example option or by using the Query by Example icon Query by Example icon.


Audit

The Audit section displays an audit of the processing attempts for a given thread.

Audit - Actions Menu and Icons

Use the Actions Menu and icons to apply actions to the table. You can perform the actions listed below.

Table 14-17 Audit - Actions Menu/Icons and Description

Actions Menu/Icons Description

Export to Excel and Export to Excel icon Export to Excel icon

You can export the records in the table to a Microsoft Excel spreadsheet by selecting Actions > Export to Excel or by using the Export to Excel icon Export to Excel icon.

Wrap icon Wrap icon

You can wrap the values in the table column by first clicking the column on which you would like the text to wrap and then using the Wrap icon Wrap icon.


Audit - View Menu and Icons

You can customize the view of the table by using the options in the View Menu.

Table 14-18 Audit - View Menu/Icons and Description

View Menu/Icons Description

Columns

You can manage which of the columns will be shown in the table by clicking the Show All and Manage Columns options.

Detach and Detach icon Detach icon

You can view the tables in the application in a separate window by clicking Detach or by using the Detach icon Detach icon.

Sort

You can sort columns by the following options:

  • Ascending

  • Descending

  • Advanced

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

Query by Example and Query by Example icon Query by Example icon

You can filter the items by one or multiple column values by clicking the Query by Example option or by using the Query by Example icon Query by Example icon.


Cost Event Toolbar

The toolbar contains the following icons and buttons.

Table 14-19 Cost Event Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon Help icon

You can access the online help for a particular page by clicking the Help icon Help icon.

Save

Click Save to save the entered records.

Save and Close

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

Cancel

Click Cancel to reject all entries and close the window.

Done

If you open the window in view mode, the Done button is displayed.

Click Done to close the window.


Item Supplier Country Locations per Thread

The Item Supplier Country Locations per Thread window displays the item supplier location per thread. The header displays the event ID and event type.

Figure 14-44 Item Supplier Country Locations per Thread

Item Supplier Country Locations per Thread

Item Supplier Locations per Thread - Actions Menu and Icons

Use the Actions Menu and icons to apply actions to the table. You can perform the actions listed below.

Table 14-20 Item Supplier Locations per Thread - Actions Menu/Icons and Description

Actions Menu/Icons Description

Export to Excel and Export to Excel icon Export to Excel icon

You can export the records in the table to a Microsoft Excel spreadsheet by selecting Actions > Export to Excel or by using the Export to Excel icon Export to Excel icon.


Item Supplier Locations per Thread - View Menu and Icons

You can customize the view of the table by using the options in the View Menu.

Table 14-21 Item Supplier Locations per Thread - View Menu/Icons and Description

View Menu/Icons Description

Columns

You can manage which of the columns will be shown in the table by clicking the Show All and Manage Columns options.

Detach and Detach icon Detach icon

You can view the tables in the application in a separate window by clicking Detach or by using the Detach icon Detach icon.

Sort

You can sort columns by the following options:

  • Ascending

  • Descending

  • Advanced

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

Query by Example and Query by Example icon Query by Example icon

You can filter the items by one or multiple column values by clicking the Query by Example option or by using the Query by Example icon Query by Example icon.


Edit a Cost Event

To edit a cost event, follow the steps below.

  1. From the Tasks menu, select Application Administration > Future Cost Events. The Cost Event Search window appears.

  2. Enter or select search criteria as desired to make the search more restrictive.

  3. Click Search. The cost events that match the search criteria are displayed in the Results section.

  4. In the Event column, click the event link, or mark a record and select Actions > Edit, or use the Edit icon Edit icon. The Cost Event window appears.

  5. Edit the records, as necessary.

  6. Then choose one of the following options.

    • Click Save to save your changes.

    • Click Save and Close to save your changes and close the window.

    • Click Cancel to reject all entries and close the window.

Custom Flex Attributes

The Custom Flex Attributes window allows you to create and maintain Custom Flex Attributes. Custom Flex Attributes are used to customize attributes for pre-defined entities in Merchandising. A customer can group attributes which are to be created for an entity using group sets and groups. Once the retailer defines the attribute hierarchy such as entities, group sets and groups, the Admin API can be used to load these hierarchy details into Merchandising. The Custom Flex Attributes window only allows you to create and maintain attributes for an already defined attribute hierarchy.

The Custom Flex Attributes window contains the following sections.

Figure 14-45 Custom Flex Attributes Window

Custom Flex Attributes window

Header

The header displays the following fields.

Table 14-22 Header - Fields and Description

Fields Description

RMS Table

Select the Merchandising table you want to extend from the list.

Group Set

Lists the defined group sets.

Select the group set name from the list.

Customs Extension Table

Displays the custom extension table associated with the selected Merchandising table.

Group Set Active checkbox

Indicates, if the selected group set is active.

Display Attributes button

Queries the details of the entered information.

If you press the Display Attributes button, without selecting an Merchandising table and group set name, all available attributes set up in the system are displayed.


Attributes

In the Attribute section you can maintain attributes.

Attributes - Actions Menu and Icons

Use the Actions Menu and icons to apply actions to the table. You can perform the actions listed below.

Table 14-23 Attributes - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon Add icon

You can add new attributes by selecting Actions > Add or by using the Add icon Add icon.

For more information about how to add new attributes, see the Add Attributes section.

Edit and Edit icon Edit icon

Select Actions > Edit or use the Edit icon Edit icon to edit the selected attribute.

For more information about how to edit an attribute, see the Edit Attributes section.

Delete and Delete icon Delete icon

You can delete attributes:

  • Select a record in the table.

  • Select Actions > Delete or use the Delete icon Delete icon.

  • You are prompted, if you want to delete the record. Select Yes to confirm the prompt.

  • The record is deleted from the table.

Export to Excel and Export to Excel icon Export to Excel icon

You can export the records in the table to a Microsoft Excel spreadsheet by selecting Actions > Export to Excel or by using the Export to Excel icon Export to Excel icon.


Attributes - View Menu and Icons

You can customize the view of the table by using the options in the View Menu.

Table 14-24 Attributes - View Menu/Icons and Description

View Menu/Icons Description

Columns

You can manage which of the columns will be shown in the table by clicking the Show All and Manage Columns options.

Detach and Detach icon Detach icon

You can view the tables in the application in a separate window by clicking Detach or by using the Detach icon Detach icon.

Sort

You can sort columns by the following options:

  • Ascending

  • Descending

  • Advanced

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

Query by Example and Query by Example icon Query by Example icon

You can filter the items by one or multiple column values by clicking the Query by Example option or by using the Query by Example icon Query by Example icon.


Labels

In the Labels section you can view and maintain the labels for a given group/attribute combination. Labels in each desired language can be edited directly in the table.

Labels - Actions Menu and Icons

Use the Actions Menu and icons to apply actions to the table. You can perform the actions listed below.

Table 14-25 Labels- Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon Add icon

You can add new labels by selecting Actions > Add or by using the Add icon Add icon.

For more information about how to add new labels, see the Add Labels section.

Delete and Delete icon Delete icon

You can delete attributes:

  • Select one or multiple records in the table.

  • Select Actions > Delete or use the Delete icon Delete icon.

  • You are prompted, if you want to delete the record(s). Select Yes to confirm the prompt.

  • The record(s) is/are deleted from the table.


Labels - View Menu and Icons

You can customize the view of the table by using the options in the View Menu.

Table 14-26 Labels - View Menu/Icons and Description

View Menu/Icons Description

Columns

You can manage which of the columns will be shown in the table by clicking the Show All and Manage Columns options.

Detach and Detach icon Detach icon

You can view the tables in the application in a separate window by clicking Detach or by using the Detach icon Detach icon.

Sort

You can sort columns by the following options:

  • Ascending

  • Descending

  • Advanced

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

Query by Example and Query by Example icon Query by Example icon

You can filter the items by one or multiple column values by clicking the Query by Example option or by using the Query by Example icon Query by Example icon.


Custom Flex Attributes Toolbar

The toolbar contains the following icons and buttons.

Table 14-27 Custom Flex Attributes Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon Help icon

You can access the online help for a particular page by clicking the Help icon Help icon.

Refresh icon Refresh icon

You can refresh the window by clicking the Refresh icon. All entries are reset and not saved.

View UI button

Opens the test window. The window displays all new attributes in addition to the existing attributes.

Save

Click Save to save the entered records.

Save and Close

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

Save and Edit Another

Click Save and Edit Another to save the entered records and edit additional entries.

This option is only available in Edit mode.

Cancel

Click Cancel to reject all entries and close the window.


Add Attributes

To add a custom flex attribute, follow the steps below.

  1. From the Tasks menu, select Application Administration > Custom Flex Attributes. The Custom Flex Attributes window appears.

  2. In the RMS Table field, select the table you want to extend.

  3. In the Group Set Name, select the group set from the list.

  4. Press the Display Attributes button. All available attributes for the selected Merchandising table and group set are displayed.

  5. In the Attributes section, select Actions > Add, or use the Add icon Add icon. The Add Attribute Definition window appears.

    Figure 14-46 Add Attribute Definition Window

    Add Attribute Definition window
    1. In the Group field, enter, select or search for the group of the attribute. The field contains all group names associated with the selected Merchandising table/group set.

    2. In the View Column Name, enter the view column name.

    3. In the Label field, enter the label in the primary language for the attribute.

    4. In the Display Order field, enter the sequence number to indicate the order in which the attribute should be displayed on the window within the group section.

      The attributes within the group will display in the group's section in the order specified here.

    5. The Maximum Length field, allows you to enter the maximum field length for the data types Varchar and Number.

    6. The Lowest Allowed Value field, allows you to enter the lowest allowed value for the data types Number and Date.

    7. The Highest Allowed Value field, allows you to enter the highest allowed value for the data types Number and Date.

    8. In the Validation Function field, enter the name of the package function to be called to validate the attribute if one has been developed.

    9. In the Data Type field, select the data type from the list.

    10. In the Widget Type field, select the widget type from the list.

    11. In the Record Group field, enter, select or search for the record group.

    12. In the List Item Code Type, enter, select or search for the code type to be used to populate the drop down list when the attribute is defined as a list.

    13. Select the Required checkbox to indicate that the attribute is required for each entity to which the attributes are associated.

    14. Select the Wrap Text checkbox to indicate that soft wrap is enabled for the field.

    15. Select the Enabled checkbox to indicate that the attribute is enabled.

    16. Then select one of the following options.

      • Click OK to add the attribute to the table and close the window.

      • Click OK and Add Another to add additional attributes.

      • Click Cancel to reject all entries and close the window.

Edit Attributes

To edit custom flex attributes, follow the steps below.

  1. From the Tasks menu, select Application Administration > Custom Flex Attributes. The Custom Flex Attributes window appears.

  2. In the RMS Table field, select the table you want to extend.

  3. In the Group Set Name, select the group set from the list.

  4. Press the Display Attributes button. All available attributes for the selected Merchandising table and group set are displayed.

  5. Select a record in the Attribute section.

  6. Then select Actions > Edit, or use the Edit icon Edit icon. The Edit Attributes Definition window appears.

  7. Edit the fields as necessary.

  8. Then choose one of the following options.

    • Select OK to save your changes and close the window.

    • Select Cancel to reject all entries and close the window.

Add Labels

To add a label for an attribute, follow the steps below.

  1. From the Tasks menu, select Application Administration > Custom Flex Attributes. The Custom Flex Attributes window appears.

  2. In the RMS Table field, select the table you want to extend.

  3. In the Group Set Name, select the group set from the list.

  4. Press the Display Attributes button. All available attributes for the selected Merchandising table and group set are displayed.

  5. In the Attribute section, select a record. The corresponding labels for the selected attribute are displayed in the Labels section.

  6. In the Labels section, select Actions > Add, or use the Add icon Add icon. The Add Label window appears.

    Figure 14-47 Add Label Window

    Add Label window
    1. The View Column Name field, is populated, based on the selected attribute.

    2. In the Language field, select the corresponding language from the list.

    3. In the Label field, enter the label.

    4. Then choose one of the following options.

      • Select OK to add the label to the table and close the window.

      • Select OK and Add Another to add additional labels.

      • Select Cancel to reject all entries and close the window.

Custom Flex Attributes Display

The Customs Flex Attributes Display window is dynamically rendered. A single window opens for each group set. The title of the Customs Flex Attributes Display window is dynamically set to the group set name. You can create Custom Flex Attributes for the following entities:

  • Supplier

  • Store

  • Physical/Virtual Warehouse

  • Department

  • Class

  • Subclass

  • Item

  • Item/Location

  • Item/Supplier

  • Item/Supplier/Country

  • Item/Supplier/Country/Location

  • Address

  • ELC Components

  • VAT Codes

  • Purchase Order

  • Purchase Order Details

  • RTV

  • Deals

  • Transfer

  • Partner

  • Cost Changes

  • Diff Types

You can open Customs Flex Attributes Display window in two different ways.

From the calling window, select More Actions > Other Attributes > Group Set Name.

In the table of the calling window, select Actions > Other Attributes > Group Set Name.

The Custom Flex Attributes Display window contains the following sections.

Header

The key values of the entity in the calling window are displayed in the Header of the Custom Flex Attributes Display window. For example, if you access window through the Item widow, the item ID and associated description are displayed in the Header.

Attribute Sections

The Attribute Sections hold the individual attributes for each group.

Custom Flex Attributes Display Toolbar

The toolbar contains the following icons and buttons.

Table 14-28 Custom Flex Attributes Display Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon Help icon

You can access the online help for a particular page by clicking the Help icon Help icon.

Save and Close

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

Cancel

Click Cancel to reject all entries and close the window.

Done

If you open the window in view mode, the Done button is displayed.

Click Done to close the window.