Go to primary content
Oracle® Retail Merchandising System Oracle Retail Merchandising System User Guide
16.0.22
E88086-01
  Go To Table Of Contents
Contents

Previous
Previous
 
Next
Next
 

2 Foundation Data

The following information describes the foundation data within RMS.

Organizational Hierarchy Overview

The organizational hierarchy allows you to create the relationships that are necessary in order to support the operational structure of a company. You can create a preferred organizational structure to support consolidated reporting at various levels of the company. Also, you can assign responsibility for any level of the hierarchy to a person or persons in order to satisfy internal reporting requirements.

The following default organizational levels are used within RMS:

Company: The highest default organizational and merchandise unit defined in RMS. Only one company can be defined.

Chain: The first level below the company level in the organizational hierarchy. The definition of a chain is based on the needs of the company, but a chain can be used to group various store formats, concepts, and geographical locations within the organization.

Area: The second level below the company level in the organizational hierarchy. The definition of an area is based on the needs of the company, but an area is used typically to define a geographical group within the organization. An area can belong to only one chain.

Region: The third level below the company level in the organizational hierarchy. The definition of a region is based on the needs of the company, but a region can be used to group geographical locations within the organization. A region can belong to only one area.

District: The fourth level below the company level in the organizational hierarchy. The definition of a district is based on the needs of the company, but a district is used typically to group geographical locations within the organization. A district can belong to only one region.

Channel: A channel grouping mechanism for a multi-channel environment. You can associate a channel with a location when you create or edit a store or virtual warehouse.

Organizational Hierarchy Window

The Organizational Hierarchy window allows you to create, edit and view the organizational hierarchy of the company.

To access the Organizational Hierarchy window from the Task menu, select Foundation Data > Locations > Organizational Hierarchy.

The Organizational Hierarchy window contains the following sections.

Figure 2-1 Organizational Hierarchy Window

Organizational Hierarchy window

Hierarchy Structure

The Organizational Hierarchy structure on the left side of the window contains the following buttons.

Table 2-1 Hierarchy Structure - Buttons and Description

Buttons Description

Chain

Displays the available chains in the table.

Area

Displays the available areas in the table.

Region

Displays the available regions in the table.

District

Displays the available districts in the table.

Store

Displays the available stores in the table.

Warehouse

Displays the available warehouse in the table.


Hierarchy Table

The Hierarchy table displays the available entries of the selected hierarchy level. For example, if you select the Chain button, all available chains are displayed in this table.

The table displays the following columns by default.

  • Hierarchy ID, depending on the selected hierarchy button.

  • Name of the hierarchy level, for example, the name of the chain.

  • Next hierarchy level, for example, Area.

    This column contains either the Create or the Details icon.

    If the next level has been created, the Detail icon is displayed. Use the icon to maintain or view the details of the next level.

    If the next level has not been created, the Create icon is displayed. Use the icon to create the next level.

    This column is not available for stores and warehouses.

Hierarchy Table - Actions Menu and Icons

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

Table 2-2 Hierarchy Table - Actions Menu/Icons and Description

Actions Menu/Icons Description

Create and Create icon

You can create a new hierarchy level by selecting Actions > Create or by using the Create icon.

For more information about how to create the individual hierarchy levels, see the following sections:

Edit and Edit icon

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

View and View icon

To view a hierarchy level:

  • Select a hierarchy button. For example, select Chain.

  • Then select a record in the table.

  • Select Actions > View or click the View icon.

  • The window of the selected hierarchy level appears.

  • Click Done to close the window.

Export to Excel and 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.


Hierarchy Table - 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 2-3 Hierarchy Table - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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.


Hierarchy Toolbar

The Toolbar contains the following icons and buttons.

Table 2-4 Toolbar - Icon/Button and Description

Icon/Button Description

Help icon

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

Done

Click Done to close the window.


Creating a Chain

To create a chain, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Locations > Organizational Hierarchy. The Organizational Hierarchy window appears.

  2. Select the Chain button. All available chains are displayed in the table.

  3. In the table, select Actions > Create, or use the Create icon. The Chains window appears.

  4. Then select Actions > Add, or use the Add icon. The Add Chain window appears.

    Figure 2-2 Add Chain Window

    Add Chain window
    1. In the Chains field, enter a unique number. This field is a required field.

    2. In the Chain Name field, enter the name of the chain. This field is a required field.

    3. In the Manager field, enter the name of the manager who is responsible for the chain.

    4. In the Currency field, enter, select or search for the chain's currency code.

    5. Then choose one of the following options.

      • Click OK to save the chain and close the window.

      • Click OK and Add Another to save the current chain and add additional entries.

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

Editing Chains

To edit a chain, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Locations > Organizational Hierarchy. The Organizational Hierarchy window appears.

  2. Select the Chain button. The available chains are displayed in the table.

  3. Select a record in the table.

  4. Then click the chain ID link, or select Actions > Edit, or use the Edit icon. The Chains window appears.

  5. Select a record in the table.

  6. Select Actions > Edit, or use the Edit icon. The Edit Chain window appears.

    1. The Chain field displays the selected chain ID.

    2. Edit the chain name, manager and/or currency, if necessary.

    3. Then choose one of the following options.

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

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

Chains Window

The Chain window allows you to create, edit, view, and delete a chain in the organizational hierarchy. A chain is below the company and above the area in the organizational hierarchy. You can use the chain level to define a variety of store formats, concepts, or geographical groupings.

Figure 2-3 Chains Window

Chains window

Chains - Actions Menu and Icons

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

Table 2-5 Chains - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

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

For more information about how to add new chains, see the Creating a Chain section.

This function is not available in edit mode.

Delete and Delete icon

You can delete chains:

  • Select a record in the table.

  • Select Actions > Delete or use the 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.

Edit and Edit icon

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

For more information about how to edit a chain, see the Editing Chains section.

Export to Excel and 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.

Translate and Translate icon

You can create a translation by selecting Actions > Translate or by using the Translate icon.


Chains - View Menu and Icons

You can customize the view of the table by using the options in the View Menu and icons listed below.

Table 2-6 Chains - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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


Chains Toolbar

The toolbar contains the following icon and buttons.

Table 2-7 Chains Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

You can access the online help for a particular page by clicking the 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.


Creating an Area

To create an Area, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Locations > Organizational Hierarchy. The Organizational Hierarchy window appears.

  2. Select the Area button. All available areas are displayed in the table.

  3. In the table, select Actions > Create, or use the Create icon. The Areas window appears.

  4. Then select Actions > Add, or use the Add icon. The Add Area window appears.

    Figure 2-4 Add Area Window

    Add Area window
    1. In the Area field, enter a unique number. This field is a required field.

    2. In the Name field, enter the name of the area. This field is a required field.

    3. In the Manager field, enter the name of the manager who is responsible for the area.

    4. In the Currency field, enter, select or search for the area's currency code.

    5. In the Chain field, enter, select or search for the chain ID which is associated with the area. This field is a required field.

    6. Then choose one of the following options.

      • Click OK to save the area and close the window.

      • Click OK and Add Another to save the current area and add additional entries.

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

Editing Areas

To edit an area, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Locations > Organizational Hierarchy. The Organizational Hierarchy window appears.

  2. Select the Area button. The available areas are displayed in the table.

  3. Select a record in the table.

  4. Then click the area ID link, or select Actions > Edit, or use the Edit icon. The Areas window appears.

  5. Select a record in the table.

  6. Select Actions > Edit, or use the Edit icon. The Edit Area window appears.

    1. The Area field displays the selected area ID.

    2. Edit the area name, manager, currency and/or chain, if necessary.

    3. Then choose one of the following options.

      • Click OK to add your changes to the table and close the window.

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

Areas Window

The Areas window allows you to create, edit, delete, or view an area in the organizational hierarchy. Area is below chain and above region in the organizational hierarchy. Typically, an area is used to define a geographical grouping within the organization. An area can belong to only one chain within the organizational hierarchy.You can associate location traits with an area. Location traits that are applied to an area are applied automatically to the regions, districts, and stores within the area.

Figure 2-5 Areas Window

Areas window

Areas - Actions Menu and Icons

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

Table 2-8 Areas - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

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

For more information about how to add new areas, see the Creating an Area section.

This function is not available in edit mode.

Delete and Delete icon

You can delete areas:

  • Select a record in the table.

  • Select Actions > Delete or use the 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.

Edit and Edit icon

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

For more information about how to edit an area, see the Editing Areas section.

Export to Excel and 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.

Search and Search icon

You can search for the corresponding chain of an area:

  • Enter, select or search for the chain ID.

  • Press Enter or click the Search icon.

  • The search results are displayed in the table.

Translate and Translate icon

You can create a translation by selecting Actions > Translate or by using the Translate icon.


Areas - View Menu and Icons

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

For more information about the View Menu and icons, see Table 2-6, "Chains - View Menu/Icons and Description".

Areas Toolbar

The toolbar contains the following icon and buttons.

Table 2-9 Areas Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

You can access the online help for a particular page by clicking the 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.


Creating a Region

To create a region, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Locations > Organizational Hierarchy. The Organizational Hierarchy window appears.

  2. Select the Region button. All available regions are displayed in the table.

  3. In the table, select Actions > Create. The Regions window appears.

  4. Then select Actions > Add, or use the Add icon. The Add Region window appears.

    Figure 2-6 Add Region Window

    Add Region window
    1. In the Region field, enter a unique number. This field is a required field.

    2. In the Region Name field, enter the name of the region. This field is a required field.

    3. In the Manager field, enter the name of the manager who is responsible for the region.

    4. In the Currency field, enter, select or search for the region's currency code.

    5. In the Area field, enter, select or search for the area ID which is associated with the region. This field is a required field.

    6. Then choose one of the following options.

      • Click OK to save the region and close the window.

      • Click OK and Add Another to save the current region and add additional entries.

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

Editing Regions

To edit a region, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Locations > Organizational Hierarchy. The Organizational Hierarchy window appears.

  2. Select the Region button. The available regions are displayed in the table.

  3. Select a record in the table.

  4. Then click the region ID link, or select Actions > Edit, or use the Edit icon. The Regions window appears.

  5. Select a record in the table.

  6. Select Actions > Edit, or use the Edit icon. The Edit Region window appears.

    1. The Region field displays the selected region ID.

    2. Edit the region name, manager, currency and/or area, if necessary.

    3. Then choose one of the following options.

      • Click OK to add your changes to the table and close the window.

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

Regions Window

The Regions window allows you to add, edit, delete, and view a region in the organizational hierarchy. A region is below the area and above the district in the organizational hierarchy. Typically, the region is used to define a geographical grouping within the organization.

Figure 2-7 Regions Window

Regions window

Regions - Actions Menu and Icons

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

Table 2-10 Regions - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

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

For more information about how to add a new region, see the Creating a Region section.

This function is not available in edit mode.

Delete and Delete icon

You can delete regions:

  • Select a record in the table.

  • Select Actions > Delete or use the 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.

Edit and Edit icon

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

For more information about how to edit a region, see the Editing Regions section.

Export to Excel and 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.

Search and Search icon

You can search for the corresponding area of a region:

  • Enter, select or search for the regions belonging to the entered area ID.

  • Press Enter or click the Search icon.

  • The search results are displayed in the table.

Translate and Translate icon

You can create a translation by selecting Actions > Translate or by using the Translate icon.


Regions - View Menu and Icons

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

For more information about the View Menu and icons, see Table 2-6, "Chains - View Menu/Icons and Description".

Regions Toolbar

The toolbar contains the following icon and buttons.

Table 2-11 Regions Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

You can access the online help for a particular page by clicking the 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.


Creating a District

To create a district, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Locations > Organizational Hierarchy. The Organizational Hierarchy window appears.

  2. Select the District button. All available districts are displayed in the table.

  3. In the table, select Actions > Create. The Districts window appears.

  4. Then select Actions > Add, or use the Add icon. The Add District window appears.

    Figure 2-8 Add District Window

    Add District window
    1. In the District field, enter a unique number. This field is a required field.

    2. In the District Name field, enter the name of the district. This field is a required field.

    3. In the Manager field, enter the name of the manager who is responsible for the district.

    4. In the Currency field, enter, select or search for the district's currency code.

    5. In the Region field, enter, select or search for the region ID which is associated with the district. This field is a required field.

    6. Then choose one of the following options.

      • Click OK to save the district and close the window.

      • Click OK and Add Another to save the current district and add additional entries.

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

Editing Districts

To edit a district follow the steps below.

  1. From the Tasks menu, select Foundation Data > Locations > Organizational Hierarchy. The Organizational Hierarchy window appears.

  2. Select the District button. The available districts are displayed in the table.

  3. Select a record in the table.

  4. Then click the district ID link, or select Actions > Edit, or use the Edit icon. The Districts window appears.

  5. Select a record in the table.

  6. Select Actions > Edit, or use the Edit icon. The Edit District window appears.

    1. The District field displays the selected region ID.

    2. Edit the district name, manager, currency and/or region, if necessary.

    3. Then choose one of the following options.

      • Click OK to add your changes to the table and close the window.

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

Districts Window

The Districts window allows you to add, edit, delete, and view a district in the organizational hierarchy. A district is below the region and above the store in the organizational hierarchy. Typically, the district is used to define a geographical grouping within the organization.

Figure 2-9 Districts Window

Districts window

Districts - Actions Menu and Icons

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

Table 2-12 Districts - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

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

For more information about how to add a new district, see the Creating a District section.

This function is not available in edit mode.

Delete and Delete icon

You can delete districts:

  • Select a record in the table.

  • Select Actions > Delete or use the 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.

Edit and Edit icon

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

For more information about how to edit a district, see the Editing Districts section.

Export to Excel and 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.

Search and Search icon

You can search for the districts belonging to the entered region:

  • Enter, select or search for the region ID.

  • Press Enter or click the Search icon.

  • The search results are displayed in the table.

Translate and Translate icon

You can create a translation by selecting Actions > Translate or by using the Translate icon.


Districts - View Menu and Icons

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

For more information about the View Menu and icons, see Table 2-6, "Chains - View Menu/Icons and Description".

Districts Toolbar

The toolbar contains the following icon and buttons.

Table 2-13 Districts Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

You can access the online help for a particular page by clicking the 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.


Creating a Store

To create a store, follow the steps listed below.

  1. From the Tasks menu, select Foundation Data > Locations > Organizational Hierarchy. The Organizational Hierarchy window appears.

  2. Select the Store button. All available stores are displayed in the table.

  3. In the table, select Actions > Create, or use the Create icon. The Store window appears.

  4. Enter the necessary information for the store. For more information about the available fields in the Store window, see the Store Window section.

Editing Stores

To edit a store, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Locations > Organizational Hierarchy. The Organizational Hierarchy window appears.

  2. Select the Store button. The available regions are displayed in the table.

  3. Select a record in the table.

  4. Then click the store ID link, or select Actions > Edit, or use the Edit icon. The Store window appears.

  5. Edit the fields, if necessary. For more information about the available fields in the Store window, see the Store Window section.


    Note:

    You cannot edit the Company Store ID, Currency, Org Unit and Transfer Entry. Additionally you cannot select or deselect the Stockholding checkbox in edit mode.

Store Window

The Store window allows you to create, edit, delete, and view a store in the organizational hierarchy. The store is the lowest level of the organizational hierarchy. The store may be defined as the selling entity. The store is crucial because it is the level at which business transactions are processed. A store can belong to only one district within the organizational hierarchy.

You can navigate to other windows in order to set up attributes, the square area of the store's departments, location traits, associations with competitors' stores, activity and delivery schedules, and geocodes.

Figure 2-10 Store Window

Store window

Table 2-14 Store Window - Fields and Description

Fields Description

Store

Select the store type from the list. Possible store types are:

  • Company

  • Franchise

The Store field next to the store type enables.

Enter a unique ID for the store.

This field is a required field.

Store Name

Enter a unique description for the store.

This field is a required field.

Secondary Name

Enter the secondary name for the store.

10 Character Name

Enter up to 10 character abbreviation for the store.

This field is a required field.

3 Character Name

Enter up to 3 character abbreviation for the store.

This field is a required field.

Channel

Enter, select or search for the channel of business to which the store belongs.

This field is a required field.

District

Enter, select or search for the district ID.

This field is a required field.

Transfer Zone

Enter, select or search for the transfer zone.

This field is a required field.

Store Format

Enter, select or search for the store format ID. For example, select Mall.

Currency

Enter, select or search for the currency code.

This field is a required field.

Language

Enter, select or search for the language code for the store.

This field is a required field.

Time Zone

Enter, select or search for the time zone of the store.

This field is a required field.

VAT Region

Enter, select or search for the VAT region code for the store.

This field is a required field.

Org Unit

Enter, select or search for the organizational unit ID.

This field is available if Oracle Financials is integrated.

This field is a required field, if available.

Transfer Entity

Enter, select or search for the transfer entity ID.

Default Warehouse

Enter, select or search for the default warehouse of the store.

This field is only enabled, if you have specified a channel ID.

For Franchise stores, this field is a required field.

Sister Store

Enter, select or search for the store number. This field is used to copy the store's history when defining allocations for new stores.

DUNS Number

Enter the Dun & Bradstreet Data Universal Numbering System (DUNS) number.

The DUNS number is a nine digit code that identifies your store.

DUNS Location Number

Enter the DUNS location number.

The DUNS location number is a four digit code that identifies the locations of your store.

This field is only enabled, if you have entered the DUNS number for your store.

Store Class

The Store Class field is disabled, if you selected the store type Company.

The Store Class field is defaulted to Class X if you selected the store type Franchise.

Select the Store Class from the list. A store is grouped under the class based on the sale or the location.

Store Open Date

Enter the date when the store opens or use the Calendar icon to select a date.

This field is a required field.

Start Order Days

Enter the number of days before the store opens to start ordering merchandise.

Store Close Date

Enter the date when the store closes or use the Calendar icon to select a date.

Stop Order Days

Enter the number of days before the store closes to stop ordering merchandise.

Unique Transaction No. by

Select the store or register for the Unique Transaction Number By from the list.

This field indicates if the transaction number in the store is generated uniquely across store or at each register.

This field is a required field.

Manager

Enter the name of the store manager.

Phone Number

Enter the phone number.

Fax Number

Enter the fax number.

Email Address

Enter the email address.

Mall Name

Enter the mall name, if necessary.

Total Area

Enter the total space of the store.

Selling Area

Enter the selling space available at the store.

Linear Distance

Enter the shelving space available at the store.

Acquired Date

Enter the date when the store has been acquired or use the Calendar icon to select a date.

Remodel Date

Enter the date when the store has been remodeled or use the Calendar icon to select a date.

Integrated Sales checkbox

The Integrated Sales checkbox is selected by default.

You cannot load the sales for that store in ReSa, if the Integrated Sales option is not selected.

Stockholding checkbox

If the store is intended to be stockholding, this option must be selected.

The Stockholding option is selected by default.

Remerchandising checkbox

Select the Remerchandising checkbox, if the store is undergoing a significant remerchandising effort as an indicator to Advanced Inventory Planning (AIP) application.

Customer Order Location checkbox

This option is available if the store type is Company and also for stock holding Franchise Stores. If the option is enabled, the store can be used to source or fulfill customer orders.

Customer

Only enabled, if the store type Franchise has been selected.

Enter, select or search for the customer the franchise store belongs to.


Like Store

The Like Store section of the Store window allows you to create a store with the same assortment of items as another store. Also, you can choose to copy replenishment information, delivery schedules, and dates when closed as well as items on clearance from the existing store to the new store.

  1. In the Store window, expand the Like Store section.

  2. In the Like Store field, enter, select or search for the desired store ID.

  3. In the Information to Copy section, select the desired checkboxes to copy the following information from the selected store:

    • Select the Replenishment Information to copy the replenishment information.

    • Select Delivery Schedule to copy delivery schedules.

    • Select Activity Schedule to copy dates when the store is closed.

    • Select Clearance Items to copy items on clearance to the new store.

Add a Zoning Location to a Store

In the Zoning Location section of the Store window you can associate a store with a retail price and a cost location. To add this information follow the steps below.

  1. In the Store window, expand the Zoning Location section.

  2. In the Pricing Store field, enter, select or search for the pricing store ID.

  3. In the Cost Location field, select the location type from the list.

  4. The field next to the location type enables. Enter, select or search for the cost location ID.

Store Toolbar

The toolbar contains the following icon and buttons.

Table 2-15 Store Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

Translate and Translate icon

You can create a translation by selecting Actions > Translate or by using the Translate icon.

Delete icon

To delete a store:

  • Click the Delete icon.

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

  • The store is deleted.

Address

Opens the Address window.

For more information about how to add an address to a warehouse, see the Addresses Window section.

More Actions

Click More Actions to see a list of additional actions that can be performed in the Store window.

Save and Close

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

Save and Create Another

Click Save and Create Another to save the entered records and add additional entries.

This option is only available, if you create a store.

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.

Done

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

Click Done to close the window.


Walk-through Stores Window

The Walk-through Stores window allows you to define several stores in one location. Each store may operate as a separate entity, however the stores are located in the same physical location. You can associate multiple stores as walk through locations. Walk-through stores can be uploaded into the system, or you can add walk through locations to a store. You must set up the stores and then associate one with another.

Figure 2-11 Walk-through Stores Window

Walk-through Stores window

Walk-through Stores - Actions Menu and Icons

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

Table 2-16 Walk-through Stores Table - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

You can add walk-through stores to a store by selecting Actions > Add or by using the Add icon.

For more information about how to add walk-through stores, see the Adding a Walk-Through Store section.

Delete and Delete icon

You can delete a walk-through store from a store.

  • Select a record in the table.

  • Then select Actions > Delete or use the 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

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.


Walk-through Stores - View Menu and Icons

You can customize the view of the table by using the options in the View Menu and icons listed below.

Table 2-17 Walk-through Stores Table - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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.


Walk-through Stores Toolbar

The toolbar contains the following icons and buttons.

Table 2-18 Walk-through Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

You can access the online help for a particular page by clicking the 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.


Adding a Walk-Through Store

To add walk through stores to a store, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Locations > Organizational Hierarchy. The Organizational Hierarchy window appears.

  2. Select the Store button. The available stores are displayed in the table.

  3. In the Store column, click the store ID link, or mark a record and select Actions > Edit, or use the Edit icon. The Store window appears.

  4. In the Store window, select More Actions > Walk Through. The Walk-through Stores window appears.

  5. Then select Actions > Add or use the Add icon. The Add Walk-through Stores window appears.

  6. In the Store field, enter the store ID.

  7. In the Name field, enter the store name.

  8. Then choose one of the following options.

    • Click OK to save the current store as walk-through store and close the window.

    • Click OK and Add Another to save the current store and add additional entries.

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

  9. In the Walk-through Stores window, 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.

Creating a Warehouse

To create a warehouse, follow the steps listed below.

  1. From the Tasks menu, select Foundation Data > Locations > Organizational Hierarchy. The Organizational Hierarchy window appears.

  2. Select the Warehouse button. All available warehouses are displayed in the table.

  3. In the table, select Actions > Create. The Warehouse window appears.

  4. Enter all the necessary information. For more information about the available fields in the Warehouse window, see the Warehouse Window section.

Editing Warehouses

To edit a warehouse, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Locations > Organizational Hierarchy. The Organizational Hierarchy window appears.

  2. Select the Warehouse button. The available warehouses are displayed in the table.

  3. Select a record in the table.

  4. Then click the warehouse ID link, or select Actions > Edit, or use the Edit icon. The Warehouse window appears.

  5. Edit the fields, if necessary. For more information about the fields in the Warehouse window, see the Warehouse Window section.


    Note:

    You cannot edit the Warehouse ID, Currency, and Primary Virtual Warehouse fields.

Warehouse Window

The Warehouse window allows you to create, edit, delete, and view a warehouse. The warehouse is the entity within RMS that defines the physical storage, cross-dock, or distribution facility in an organization. The warehouse has all of the transaction capability of the store, except for sales and price changes. You can specify at which organizational level a warehouse is reported.

You also have the option to designate a warehouse as a redistribution warehouse. A redistribution warehouse does not actually hold stock and cannot be used as a distribution center. With the existence of a redistribution warehouse, you can create purchase orders before the distribution center is known. Orders must be redistributed to actual warehouses or stores when the locations become known and before the merchandise is shipped.

You can access additional windows in order to set up attributes, activity schedules, and delivery schedules.

Figure 2-12 Warehouse Window

Warehouse window

Table 2-19 Warehouse Window - Fields and Description

Fields Description

Warehouse

Enter a unique ID for the warehouse.

This field is a required field.

Warehouse Name

Enter a unique description for the warehouse.

This field is a required field.

Secondary Name

Enter the secondary name for the warehouse.

Currency

Enter, select or search for the currency code.

This field is a required field.

Reporting Level (Optional)

Select a reporting level from the list.

VAT Region

Enter, select or search for a VAT region for the warehouse.

This field is a required field.

Primary Virtual Warehouse

This field is enabled when at least one virtual warehouse is created.

Enter, select or search for the primary virtual warehouse.

Email

Enter an email address for the warehouse.

Break Pack Warehouse checkbox

Select the checkbox to indicate that the warehouse is capable of distributing less that the supplier case quantity.

Redistribution Warehouse checkbox

Select the checkbox to indicate that the warehouse distributes to other warehouses.

Delivery Policy

Select a delivery policy from the list.

Inbound Handling Days

Enter the number of days that the warehouse requires to receive any item and move the item to the shelf, so that it is ready to be picked.

Next Day indicates that the if a location is closed, the warehouse will deliver on the next day.

Next Valid Delivery Day indicates that the warehouse will wait until the next scheduled delivery day before delivering the item.

DUNS Number

Enter the Dun & Bradstreet Data Universal Numbering System (DUNS) number.

The DUNS number is a nine digit code that identifies your store.

DUNS Location Number

Enter the DUNS location number.

The DUNS location number is a four digit code that identifies the locations of your store.

This field is only enabled, if have entered the DUNS number for your store.

Zoning Location section:

This section is only available, when you create a new warehouse

Cost Location

Select a cost location type from the list. The location ID field enables, enter, select or search for the location.


Warehouse Toolbar

The toolbar contains the following icons and buttons.

Table 2-20 Warehouse Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

Translate and Translate icon

You can create a translation by selecting Actions > Translate or by using the Translate icon.

Delete icon

To delete a warehouse:

  • Click the Delete icon.

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

  • The warehouse is deleted.

Address

Opens the Address window.

For more information about how to add an address to a warehouse, see the Addresses Window section.

Virtual Warehouses

Opens the Virtual Warehouses window.

For more information about how to create a virtual warehouse, see the Virtual Warehouses Window section.

More Actions

Click More Actions to see a list of additional actions that can be performed in the Warehouse window.

Save and Close

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

Save and Create Another

Click Save and Create Another to save the entered records and add additional entries.

This option is only available, if you create a warehouse.

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.

Done

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

Click Done to close the window.


Virtual Warehouses Window

The Virtual Warehouse window allows you to divide a physical warehouse into one or more virtual warehouses. Virtual warehouses are used in a multi-channel environment to track ownership of inventory by channel. You associate each virtual warehouse with a channel. If the virtual warehouse contains a finishing location, you can indicate an additional virtual warehouse within the channel.

Virtual warehouses are considered stockholding locations, while the physical warehouse is considered a non-stockholding location.

Figure 2-13 Virtual Warehouses Window

Virtual Warehouses window

Virtual Warehouses - Actions Menu and Icons

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

Table 2-21 Virtual Warehouses - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

You can add a virtual warehouse to a physical one by selecting Actions > Add or by using the Add icon.

For more information about how to add a virtual warehouse, see the Adding Virtual Warehouses section.

Edit and Edit icon

You can edit a virtual warehouse by selecting Actions > Edit or by using the Edit icon.

For more information about how to edit a virtual warehouse, see the Editing Virtual Warehouses section.

Delete and Delete icon

You can delete a virtual warehouse:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.

Translate and Translate icon

You can create a translation by selecting Actions > Translate or by using the Translate icon.


Virtual Warehouses - 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 2-22 Virtual Warehouses - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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


Virtual Warehouse Toolbar

The toolbar contains the following icons and buttons.

Table 2-23 Virtual Warehouse Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

More Actions

Click More Actions to see a list of additional actions that can be performed in the Virtual Warehouse window.

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.


Adding Virtual Warehouses

To add a virtual warehouse to a physical warehouse, follow the steps below.

  1. From the Tasks menu select Foundation Data > Locations > Organizational Hierarchy. The Organizational Hierarchy window appears.

  2. Select the Warehouse button. The available warehouses are displayed in the table.

  3. Select a record in the table.

  4. Then, select Actions > Edit or use the Edit icon. The Warehouse window appears.

  5. Click the Virtual Warehouse button. The Virtual Warehouses Window appears.

  6. Select Actions > Add or use the Add icon. The Add Virtual Warehouse window appears.

    Figure 2-14 Add Virtual Warehouse Window

    Add Virtual Warehouse window
    1. In the Virtual Warehouse field, enter a unique warehouse ID. This field is a required field.

    2. In the Name field, enter the name of the warehouse. This field is a required field.

    3. In the Secondary Name field, enter the secondary name for the warehouse.

    4. In the Org Entity Type field, select the org entity type from the list. This field is a required field.

    5. In the Transfer Entity field, enter, select or search for the transfer entity. This field is a required field.

    6. In the Org Unit field, enter, select or search for the org unit. This field is a required field.

    7. In the Virtual Warehouse Type field, select a warehouse type from the list. This field is a required field.

    8. In the Channel field, enter, select or search for a channel. This field is a required field.

    9. In the Default Warehouse field, enter, select or search for the warehouse.

    10. In the Pricing Location field, enter, select or search for the pricing location ID. This field is a required field.

    11. In the Rounding Warehouse field, enter select or search for the warehouse.

    12. Select the Stock Holding checkbox to indicate that the warehouse is a stock holding one.


      Note:

      If you select Regular Warehouse as the Org Entity Type, the Stock Holding checkbox is selected and disabled. You cannot deselect this checkbox.

    13. Select the Finisher checkbox to indicate that the warehouse is a finisher location.

    14. Select the Customer Order Location checkbox to indicate that the warehouse is a location where the customer places orders.

    15. Select the Protected checkbox to indicate that the warehouse is affected last in transactions where inventory is removed or affected first in short-shipment type transactions where inventory is being added.

    16. Select the Restricted checkbox to indicate that the virtual warehouses is restricted from receiving stock during an inbound transaction.

    17. Select the Forecast checkbox to indicate that the warehouse should be included in forecast calculations.

    18. Select the Replenishment checkbox to indicate that the virtual warehouse is included in the net inventory calculations for the replenish able warehouse.

    19. In the Warehouse Link field, enter, select or search for the corresponding link.

    20. Then select one of the following options.

      • Click OK to add the current warehouse and close the window.

      • Click OK and Add Another to add the current warehouse and add additional warehouses.

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

Editing Virtual Warehouses

To edit a virtual warehouse to a physical warehouse, follow the steps below.

  1. From the Tasks menu select Foundation Data > Locations > Organizational Hierarchy. The Organizational Hierarchy window appears.

  2. Select the Warehouse button. The available warehouses are displayed in the table.

  3. Select a record in the table.

  4. Select Actions > Edit or use the Edit icon. The Warehouse window appears.

  5. Click the Virtual Warehouses button. The Virtual Warehouses Window appears.

  6. Select a record in the table.

  7. Select Actions > Edit or use the Edit icon. The Edit Virtual Warehouse window appears.

    1. Edit the fields, if necessary.

    2. Then select one of the following options.

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

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

Warehouse Department Parameters Window

The Warehouse Department window allows you to specify investment buy parameters at the warehouse or warehouse/department level. You can set up costs of storage and other parameters for a specific warehouse. Within the warehouse, you can set up several sets of investment buy parameters which are specific for a set of items, such as frozen goods.

Figure 2-15 Warehouse Department Parameters Window

Warehouse Department Parameters window

Warehouse Department Parameters - Actions Menu and Icons

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

Table 2-24 Warehouse Department Parameters - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

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

For more information about how to add parameters, see the Adding Warehouse Department Parameters section.

Edit and Edit icon

You can edit parameters by selecting Actions > Edit or by using the Edit icon.

For more information about how to edit parameters, see the Editing Virtual Warehouses section.

Delete and Delete icon

You can delete parameters:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.


Warehouse Department Parameters - 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 2-25 Warehouse Department Parameters - 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

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

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

Query by Example and 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.


Warehouse Department Parameters Toolbar

The toolbar contains the following icons and buttons.

Table 2-26 Warehouse Department Parameters Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

You can access the online help for a particular page by clicking the 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.


Adding Warehouse Department Parameters

To add warehouse department parameters, follow the steps below.

  1. From the Tasks menu select Foundation Data > Locations > Organizational Hierarchy. The Organizational Hierarchy window appears.

  2. Select the Warehouse button. The available warehouses are displayed in the table.

  3. Select a record in the table.

  4. Select Actions > Edit or use the Edit icon. The Warehouse window appears.

  5. Click the Virtual Warehouse button. The Virtual Warehouses Window appears.

  6. Select More Actions > Warehouse Department Parameters. The Warehouse Department Parameters window appears.

  7. Then, select Actions > Add or use the Add icon. The Add Warehouse Department Parameter window appears.

    Figure 2-16 Add Warehouse Department Parameters Window

    Add Warehouse Department Parameters window
    1. In the Department field, enter, select or search for the department.

    2. In the Storage Cost Measure field, select the cost measure from the list. The Storage Cost UOM field enables.

    3. In the Storage Cost UOM field, enter, select or search for the unit of measure.


      Note:

      This field is disabled, if you select Eaches as a storage cost measure.

    4. In the Weekly Cost of Storage field, enter the weekly cost of storage value.

    5. In the Outside Storage Cost Measure field, select an outside cost measure from the list. The Outside Storage Cost UOM field enables.

    6. In the Outside Storage Cost UOM field, enter, select or search for the unit of measure.

    7. In the Weekly Cost of Outside Storage field, enter the weekly cost of outside storage value.

    8. In the Storage Type field, select the type from the list. This field is a required field.

    9. In the Maximum Weeks of Supply field, enter the number of weeks. This field is a required field.

    10. In the Target ROI field, enter the target ROI (Return of Investment). This field is a required field.

    11. In the Cost of Money field, enter the cost.

    12. Then choose one of the following options.

      • Click OK to save the current parameter and close the window.

      • Click OK and Add Another to save the current parameter and add additional entries.

      • Click Default to save the current parameter and set it as the default value.

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

Editing Warehouse Department Parameters

To edit warehouse department parameters, follow the steps below.

  1. From the Tasks menu select Foundation Data > Locations > Organizational Hierarchy. The Organizational Hierarchy window appears.

  2. Select the Warehouse button. The available warehouses are displayed in the table.

  3. Select a record in the table.

  4. Select Actions > Edit or use the Edit icon. The Warehouse window appears.

  5. Click the Virtual Warehouses button. The Virtual Warehouses Window appears.

  6. Select More Actions > Warehouse Department Parameters. The Warehouse Department Parameters window appears.

  1. Select a record in the table.

  2. Select Actions > Edit or use the Edit icon. The Edit Warehouse Department Parameter window appears. The parameters of the selected record are shown.

    1. Edit the values, if necessary.

    2. Then choose one of the following options.

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

      • Click Default to save the current parameter and set it as default value.

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

Addresses Window

The Addresses window allows you to add, add from existing, edit, delete or view multiple addresses and contact information for either stores, warehouses, suppliers, or partners. You can set up multiple addresses per address type. Each location or vendor that is added requires that a mandatory address is added. Once you have entered a mandatory address, you cannot delete it. However, you can edit the mandatory address to maintain the correct address. Address types are defined as mandatory and/or permanent in the database.

Figure 2-17 Addresses Window

Addresses window

Addresses - Actions Menu and Icons

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

Table 2-27 Addresses - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

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

For more information about how to add addresses, see the Adding an Address section.

Add from Existing and Add from Existing icon

You can create a new address from an existing address by selecting Actions > Add from Existing or by using the Add from Existing icon.

For more information about how to add an address from an existing one, see the Adding an Address from Existing section.

Edit and Edit icon

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

For more information about how to edit an address, see the Editing an Address section.

Delete and Delete icon

You can delete an address:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.

Other Attributes

Select an attribute from the Other Attribute Menu. The Attribute window displaying details of the selected attributes, appears.

For more information about this option, see the Application Administration chapter, section "Custom Flex Attributes Display".

Translate and Translate icon

You can create a translation by selecting Actions > Translate or by using the Translate icon.


Addresses - 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 2-28 Addresses - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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.


Addresses Toolbar

The toolbar contains the following icons and buttons.

Table 2-29 Addresses Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

You can access the online help for a particular page by clicking the 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.


Maintaining Addresses

To maintain addresses, follow the steps below.

Maintaining Addresses for a Store

To maintain an address for a store:

  1. From the Tasks menu, select Foundation Data > Locations > Organizational Hierarchy. The Organizational Hierarchy window appears.

  2. Select the Store button. The available stores are displayed in the table.

  3. In the Store column, click the store ID link, or mark a record and select Actions > Edit, or use the Edit icon. The Store window appears.

  4. Then select More Actions > Address. The Addresses window appears.

Maintaining Addresses for a Warehouse

To maintain an address for a warehouse:

  1. From the Tasks menu, select Foundation Data > Locations > Organizational Hierarchy. The Organizational Hierarchy window appears.

  2. Select the Warehouse button. The available stores are displayed in the table.

  3. In the Warehouse column, click the store ID link, or mark a record and select Actions > Edit, or use the Edit icon. The Warehouse window appears.

  4. Then select More Actions > Address. The Addresses window appears.

Maintaining an Address for a Supplier

To maintain an address for a supplier:

  1. From the Tasks menu, select Foundation Data > Suppliers and Partners > Manage Suppliers. The Supplier Search window appears.

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

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

  4. In the Supplier/Supplier Site column, click the supplier/supplier site ID link, or mark a record and select Actions > Edit, or use the Edit icon. The Supplier/Supplier Site window appears.

  5. Select More Actions > Address. The Addresses window appears.

Maintaining an Address for a Partner

To maintain an address for a partner:

  1. From the Tasks menu, select Foundation Data > Suppliers and Partners > Manage Partners. The Partner Search window appears.

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

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

  4. In the Partner Site column, click the partner ID link, or mark a record and select Actions > Edit, or use the Edit icon. The Partner window appears.

  5. Select More Actions > Address. The Addresses window appears.

Adding an Address

To add an address in the Addresses window:

  1. In the table, select Actions > Add or use the Add icon. The Add Address window appears.

  2. In the Address Type field, select the corresponding type.

  3. The Apply to all Undefined Required Types checkbox, indicates that the current address information is added to each required address type. This checkbox is selected by default.

  4. In the Address information section, enter the following details.

    1. In the Address field, enter the full address. This field is a required field.

    2. In the City field, enter the city in which the store is located. This field is a required field.

    3. In the State field, select a state from the list.

    4. In the Postal Code field, enter the postal code of the store.

    5. In the Country field, enter, select or search for the country. This field is a required field.

    6. Select the Primary Address checkbox to indicate that the current address is a primary address.

  5. In the Contact information section, you can enter the following details.

    1. In the Name field, enter the name of the contact person associated to the store.

    2. In the Phone field, enter the phone number of the contact.

    3. In the Fax field, enter the fax number.

    4. In the Pager field, enter the pager number.

    5. In the Email field, enter the email address.

  6. Then choose one of the following options.

    • Click OK to save the current address and close the window.

    • Click OK and Add Another to save the current address and add additional entries.

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

Adding an Address from Existing

To add a new address from an existing address, follow the steps below.

  1. In the Address window, select a record in the table.

  2. Select Actions > Add from Existing or use the Add from Existing icon. The Add Address window appears.

  3. In the Address Type field, select the corresponding type.

  4. The address and contact fields enable and display the data of the selected address. Change the entries as necessary.


    Note:

    The Primary Address field is disabled.

  5. Then choose one of the following options.

    • Click OK to save the current address and close the window.

    • Click OK and Add Another to save the current address and add additional entries.

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

Editing an Address

To edit an address, follow the steps below.

  1. In the Addresses window, select a record in the table.

  2. Select Actions > Edit or use the Edit icon. The Edit Address window appears.

  3. In the Address Type field shows the type of the selected address. You cannot edit this field.

  4. The address and contact fields display the data of the selected address. Change the entries as necessary.


    Note:

    The Primary Address field is disabled.

  5. Then choose one of the following options.

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

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

Store Location Traits Window

The Store Location Traits window allows you to add, delete, and view location traits. You can group areas, regions, districts, or stores by location traits.

At the store level, location traits can be used as a grouping mechanism when you:

  • Record Attributes for a Store

  • Add Locations to a Location List

Figure 2-18 Store Location Traits Window

Store Location Traits window

Store Location Traits - Actions Menu and Icons

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

Table 2-30 Store Location Traits - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

You can add location traits by selecting Actions > Add or by using the Add icon.

For more information about how to add location traits, see the Adding Store Location Traits section.

Delete and Delete icon

You can delete location traits:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.


Store Location Traits - 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 2-31 Store Location Traits - 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

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

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

Query by Example and 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.


Store Location Traits Toolbar

The toolbar contains the following icons and buttons.

Table 2-32 Store Location Traits Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

You can access the online help for a particular page by clicking the 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.


Adding Store Location Traits

To add a location trait to the store, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Locations > Organizational Hierarchy. The Organizational Hierarchy window appears.

  2. Select the Store button. The available stores are displayed in the table.

  3. In the Store column, click the store ID link, or mark a record and select Actions > Edit, or use the Edit icon. The Store window appears.

  4. In the Store window, select More Actions > Location Traits. The Store Location Traits window appears.

  5. Then select Actions > Add or use the Add icon. The Add Location Trait window appears.

  6. In the Location Trait window. Enter, select or search for the desired location trait ID.

  7. Then choose one of the following options.

    • Click OK to add the location trait and close the window.

    • Click OK and Add Another to save the current record and add additional entries.

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

Location Delivery Schedules Window

The Location Delivery Schedules window allows you to create, edit, and view delivery schedules for items from a supplier or warehouse to stores and warehouses. After you create a delivery schedule, you can define exceptions to the schedule by specifying which items are not to be delivered to the location on a specific delivery day.

When the Use Location Delivery Schedule system parameter is selected, the replenishment feature uses the delivery schedule to calculate lead times for the items at the location. When there is a delivery schedule for a supplier or warehouse at a location, the specified lead times for the item are the minimum amount of time in which a purchase order can be delivered to that location.

When the delivery date of the purchase order does not fall on a delivery day of the supplier or warehouse, the lead time is calculated by taking the minimum lead time and adding additional days to reach the next valid delivery day. In effect, the lead time is extended until the next delivery day of the supplier or warehouse. Extending the lead time increases the number of units required to replenish the item. The lead time is only extended when the replenishment method is Dynamic, Dynamic - Seasonal, Dynamic - Issues, or Floating Point.

The Location Delivery Schedule window contains the following sections.

Figure 2-19 Location Delivery Schedules Window

Location Delivery Schedules window

Location Delivery Schedules Header

The header displays the Source and Destination Location field.

  • In the Source field, select the source type, store or warehouse. Then, enter, select or search for the source ID.

  • In the Destination Location field, select the destination type, store or warehouse. Then, enter, select or search for the destination ID.

When you access the Location Delivery Schedules window from the Warehouse window, the Destination Locations fields are populated with the selected warehouse. The Source fields are blank and enabled. Once you choose a source, the table displays records matching the source and destination locations values.

When you access the Location Delivery Schedules window from the Supplier Site window, the Source fields are populated with the selected supplier site. The Destination Locations fields are blank and enabled. Once you choose a destination, the table displays records for the source and destination values.

Location Delivery Schedules Table

The table displays the available delivery schedules for the selected location.

Location Delivery Schedules Table - Actions Menu and Icons

Use the Actions Menu and icons to apply actions to the Delivery Schedules Table. You can perform the actions listed below.

Table 2-33 Location Delivery Schedules Table - Actions Menu/Icons and Description

Actions Menu/Icons Description

Delete and Delete icon

You can delete delivery schedules from the table.

  • Select an item record in the table.

  • Select Actions > Delete or use the Delete icon.

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

  • The item is deleted from the table.

Manage Schedules button

Opens the Manage Delivery Schedules window.

For more information about how to manage delivery schedules for a location, see the Managing Location Delivery Schedules section.

Export to Excel and 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.


Location Delivery Schedules Table - View Menu and Icons

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

Table 2-34 Delivery Schedules Table - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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


Location Delivery Schedules Toolbar

The Toolbar contains the following icons and buttons.

Table 2-35 Location Delivery Schedules Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

Refresh icon

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

This option is not available, if you enter the window through the Supplier Site window.

Exceptions

Opens the Source Delivery Exceptions window.

For more information about this function, see the Source Delivery Exceptions Window section.

Save and Close

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

Save and Create Another

Select Save and Create Another to save the current record and enter additional records.

This option is not available, if you enter the window through the Supplier Site window.

Cancel

Click Cancel to reject all entries and close the window.


Managing Location Delivery Schedules

To manage location delivery schedules, follow the steps below. You can enter the Location Delivery Schedules window in different ways.

Adding a Delivery Schedule at the Store or Warehouse Level

To add a delivery schedule at the store or warehouse level:

  1. From the Tasks menu, select Foundation Data > Locations > Organizational Hierarchy. The Organizational Hierarchy window appears.

  2. Select the Store/Warehouse button. The available stores/warehouses are displayed in the table.

  3. Select a record in the table.

  4. In the Store/Warehouse column, click the store/warehouse ID link, or mark a record and select Actions > Edit, or use the Edit icon. The Store/Warehouse window appears.

  5. Click More Actions > Delivery Schedules. The Location Delivery Schedules window appears.

    1. Store/Warehouse Level:

      • In the Source fields, select supplier site or warehouse. Then enter, select or search for the source ID.

      • The Destination Locations fields display the information of the selected store/warehouse.

      • To manage delivery schedules, see the Managing Delivery Schedules section.

Adding a Delivery Schedule at the Supplier Level

To add a delivery schedule at the supplier level:

  1. From the Tasks menu, select Foundation Data > Suppliers and Partners > Manage Suppliers. The Supplier Search window appears.

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

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

  4. In the Supplier Site column, click the supplier site ID link, or mark a record and select Actions > Edit, or use the Edit icon. The Supplier Site window appears.

  5. Select More Actions > Delivery Schedule. The Location Delivery Schedules window appears.

    1. Supplier Level:

      • In the Source fields display the information of the selected supplier.

      • The Destination Locations field, select a destination type from the list. Then select the location ID.

      • To manage delivery schedules, see the Managing Delivery Schedules section.

Managing Delivery Schedules

In the Delivery Schedules window, follow the steps below.

  1. In the table, select the Manage Schedules button. The Manage Delivery Schedules window appears.

    Figure 2-20 Manage Delivery Schedules Window

    Manage Delivery Schedules window
  2. The Destination Location fields display the store information.

  3. In the Frequency field, select the desired time span from the list.

  4. In the Start Date field, enter the start date or use the Calendar icon to select a date.

  5. In the Start Time field, enter the starting time of the schedule.

  6. In the End Time field, enter the end time of the schedule.

  7. Select the checkboxes of the desired weekdays of the delivery schedule.

  8. Then choose one of the following options.

    • Click OK to add the current schedule and close the window.

    • Click OK and Manage Another to add the current schedule and add additional entries.

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

Source Delivery Exceptions Window

The Source Delivery Exceptions window allows you to define exceptions to the delivery date of a supplier at a store or warehouse. You specify which items are not to be delivered to the location on a specific delivery date.

The Source Delivery Exceptions Window contains the following sections.

Figure 2-21 Source Delivery Exceptions Window

Source Delivery Exceptions window

Source Delivery Exceptions Table

The table displays the item for which the delivery exception is valid.

Source Delivery Exceptions Table - Actions Menu and Icons

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

Table 2-36 Exceptions Table - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

You can add new exceptions for a delivery schedule by selecting Actions > Add or by using the Add icon.

For more information about how to add new exceptions for a delivery schedule, see the Adding Source Delivery Exceptions section.

Delete and Delete icon

You can delete exceptions from a delivery schedule:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.


Source Delivery Exceptions Table - View Menu and Icons

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

Table 2-37 Exceptions Table - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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.


Source Delivery Exceptions Toolbar

The toolbar contains the following icons and buttons.

Table 2-38 Exceptions Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

You can access the online help for a particular page by clicking the 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.


Adding Source Delivery Exceptions

To add a delivery exception for a supplier to a warehouse or store, follow the steps below. You can enter the Source Delivery Exceptions window in different ways

Navigate: through Store/Warehouse window

  1. From the Tasks menu, select Foundation Data > Locations > Organizational Hierarchy. The Organizational Hierarchy window appears.

  2. Select the Store/Warehouse button. The available stores/warehouses are displayed in the table.

  3. Select a record in the table.

  4. In the Store/Warehouse column, click the store/warehouse ID link, or mark a record and select Actions > Edit, or use the Edit icon. The Store/Warehouse window appears.

  5. Click More Actions > Delivery Schedules. The Location Delivery Schedules window appears.

  6. Click Exceptions. The Source Delivery Exceptions window appears.

Navigate: through Supplier Site window

  1. From the Tasks menu, select Foundation Data > Suppliers and Partners > Manage Suppliers. The Supplier Search window appears.

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

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

  4. In the Supplier Site column, click the supplier site ID link, or mark a record and select Actions > Edit, or use the Edit icon. The Supplier Site window appears.

  5. Select More Actions > Delivery Schedule. The Location Delivery Schedules window appears.

  6. Click Exceptions. The Source Delivery Exceptions window appears.

Adding Exceptions

In the Source Delivery Exceptions window, follow the steps below.

  1. In the table, select Actions > Add, or use the Add icon. The Add Exceptions window appears.

  2. In the Item Type field, select the type, item or item list.

  3. In the Item field, enter select or search for the item.

  4. In the Date field, enter the day on which you do not want the item or item list delivered or use the Calendar icon to select a date.

  5. Then choose one of the following options.

    • Click OK to add the current exception and close the window.

    • Click OK and Add Another to add additional exceptions.

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

Creating Location Lists

To create a location list, follow the steps below.

You can enter the Create Location List window in different ways.

  • From the Tasks menu, select Foundation Data > Locations > Create Location List. The Create Location List window appears.

  • From the Tasks menu, select Foundation Data > Locations > Manage Location Lists. Search for location lists. Then select Actions > Create or use the Create icon. The Create Location List window appears.

  1. Enter the data, as necessary.

    For more information about the available fields in the Location List window, see the Location List Window section.

Location List Window

The Location List window allows you to create, edit, or view basic information about a location list. You can indicate whether the location list is static or dynamic. Dynamic lists can be rebuilt on demand. You can indicate whether a dynamic location list can also be rebuilt by a scheduled batch program. The ID of the user who created the location list and the date on which it was created appear. You can also view the number of locations that make up the location list.

Figure 2-22 Location List Window

Location List window

The Location List window contains the following fields.

Table 2-39 Location List - Fields and Description

Fields Description

Location List

Displays the location list ID and description of the selected list.

Comments

Add comments to the selected location list.

Hierarchy Level:


The name of this field depends on the hierarchy level the location list is associated to.

Chain

Enter, select or search for the chain.

Area

Enter, select or search for the area.

Region

Enter, select or search for the region.

District

Enter, select or search for the district.

Store

Enter, select or search for the store.

Warehouse

Enter, select or search for the warehouse.

Static checkbox

If selected, the location list is static. You can not add additional locations to the list.

If not selected, the location list is dynamic.

Private checkbox

This checkbox

Select the checkbox to indicate that the security for a location list is on.

Batch Rebuild checkbox

If selected, the dynamic location list is rebuilt automatically by a scheduled batch program based on the original criteria.

Total Locations

Displays the total number of locations on the selected location list.

Created

Displays the date, when list has been created, and the user, who created the list.

External Ref. No

Displays a reference number, if available.


Location List Toolbar

The Toolbar contains the following icons and buttons.

Table 2-40 Location List Toolbar - Icon/Buttons and Description

Icon/Buttons Description

Help icon

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

Delete icon

You can delete the current location list by selecting the Delete icon.

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

More Actions

Click More Actions to see a list of additional actions that can be performed in the Location List window.

  • Locations

    Opens the Location List Detail window.

    For more information about this function, see the Location List Detail Window section

  • Criteria

    Opens the Location List Criteria window.

    For more information about this function, see the Location List Criteria Window section.

  • Location List Rebuild

    Opens the Location List Rebuild window.

    For more information about how to rebuild a location list, see the Rebuilding Location Lists section.

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.


Location List Detail Window

The Location List Detail window allows you to add, delete, and view the locations that make up a location list.

The Location List Detail window contains the following sections.

Figure 2-23 Location List Detail Window

Location List Detail window

Location List Detail Table

The table displays all the locations making up the location list. The location type, location ID, name and status are displayed by default.

Location List Details Table - Actions Menu and Icons

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

Table 2-41 Location List Details Table - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

You can add locations to the current list, by selecting Actions > Add, or use the Add icon.

For more information about how to create/add a location to the location list, see the Adding Locations to Location Lists section.

Delete and Delete icon

You can delete a location from the location list:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.


Location List Detail Table - View Menu and Icons

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

Table 2-42 Location List Detail - 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

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

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

Query by Example and Query by Example icon

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


Location List Details Toolbar

The Toolbar contains the following icons and buttons.

Table 2-43 Location List Detail Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

Save

Click Save to save the entered records.

Only displayed, if the location list is static.

Save and Close

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

Only displayed, if the location list is static.

Rebuild

Opens the Location List Rebuild window.

Only displayed, if the location list is dynamic.

For more information about how to rebuild a location list, see the Rebuilding Location Lists section.

Rebuild and Close

Rebuilds the current location list and closes the window.

Only displayed, if the location list is dynamic.

For more information about how to rebuild a location list, see the Rebuilding Location Lists section.

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.


Adding Locations to Location Lists

To add a location to the selected location list, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Locations > Manage Location Lists. The Manage Location List window appears.

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

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

  4. Select a record in the Results section.

  5. Then select Actions > Edit, or use the Edit icon. The Location List window appears.

  6. Select More Actions > Locations. The Location List Detail window appears.

  7. Then select Actions > Add or use the Add icon. The Add Location window appears.

    1. In the Type field, enter the location type. For example, select Warehouse.

    2. In the Location field, enter, select or search for the location ID.

    3. Then select one of the following options.

      • Click OK to add the new location and close the window.

      • Click OK and Add Another to add additional entries.

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

Location List Criteria Window

The Location List Criteria window allows you to add, edit, delete and view the criteria by which locations are grouped on a location list. The criteria that you enter become the conditions of a Where clause in a SQL statement. You can test the criteria and view the SQL statement before they are applied to the location list.

The Location List Criteria window contains the following sections.

Figure 2-24 Location List Criteria Window

Location List Criteria window

Location List Criteria Table

The table lists the elements and values of the criteria.

Locations List Criteria Table - Actions Menu and Icons

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

Table 2-44 Location List Criteria Table - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

You can add location criteria to a location list by selecting Actions > Add or by using the Add icon.

For more information about how to add a location criteria to a location list, see the Adding Location List Criteria section.

Edit and Edit icon

You can edit location criteria by selecting Actions > Edit or by using the Edit icon.

For more information about how to edit location criteria, see the Editing Location List Criteria section.

Delete and Delete icon

You can delete location criteria from a location list:

  • Select a record in the table.

  • Select Actions > Delete or use the 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.

Build List and Build List button

After you have made all necessary changes in the table, click Build List to rebuild the location list.

Locations and Locations button

Opens the Location List Detail window to view the individual locations of the list.

For more information about this function, see the Location List Detail Window window.

Test SQL and Test SQL button

Click Test SQL to test the validity of the criteria. A prompt is displayed, if an error occurs.

Export to Excel and 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.


Location List Criteria Table - View Menu and Icons

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

Table 2-45 Location List Criteria Table - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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.


Location List Criteria Toolbar

The Toolbar contains the following icon and buttons.

Table 2-46 Location List Criteria Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

More Actions

Click More Actions to see a list of additional actions that can be performed in the Location List Criteria window.

  • Results of last SQL Test

    Opens the SQL Statement window, displaying the last statement.

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 enter the window in view mode, the Done button is displayed.

Click Done to close the window.


Maintaining Location List Criteria

To maintain location list criteria, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Locations > Manage Location Lists. The Manage Location List window appears.

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

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

  4. Select a record in the Results section.

  5. Then click the location list link, or select Actions > Edit, or the Edit icon. The Location List window appears.

  6. Select More Actions > Criteria. The Location List Criteria window appears.

  7. Update the location list criteria, as necessary.

Adding Location List Criteria

To add location list criteria, follow the steps below.

  1. Go to the Location Type field, in the top right corner of the window. Select a location type.

  2. Then select Actions > Add or use the Add icon. The Add Criteria window appears.

    1. In the Element field, select an element from the list.


      Note:

      If the Element is Cost Zone or Store Grade, you can specify which group (cost zone group or store grade group) the zone or grade is a member of.

    2. In the Comparison field, select a sign from the list.

    3. In the Value field, enter a value.

    4. In the Logic Operation field, select an option from the list.

    5. In the Related Value field, enter, select or search for the value.

    6. Then choose one of the following options.

      • Click OK to add your entries and close the Add Criteria window.

      • Click OK and Add Another to add additional entries.

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

  3. Click the Test SQL button to test, if the entered criteria is valid.


    Note:

    If the location list criteria is not valid, a message is displayed.

  4. Click Build List to rebuild the location list.

  5. Then choose one of the following options.

    • Click Save to save your entries.

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

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

Editing Location List Criteria

To edit location list criteria, follow the steps below.

  1. Select a record in the table.

  2. Then select Actions > Edit or use the Edit icon. The Edit Criteria window appears.

    1. Edit the fields, as necessary.

    2. Then choose one of the following options.

      • Click OK to save your changes and close the Edit Criteria window.

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

  3. Click the Test SQL button to test, if the entered criteria is valid.


    Note:

    If the location list criteria is not valid, a message is displayed.

  4. Click Build List to rebuild the location list.

  5. 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.

Rebuilding Location Lists

To rebuild a location list, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Locations > Manage Location Lists. The Manage Location List window appears.

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

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

  4. Select a record in the Results section.

  5. Then select Actions > Edit, or use the Edit icon. The Location List window appears.

  6. Select More Actions > Location List Rebuild. The Location List Rebuild window appears. The location list details are displayed.

  7. Select the Rebuild Location List checkbox, to rebuild the current list.

  8. Then choose one of the following options.

    • Click Execute and Close to rebuild the selected location list and close the window.

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

Managing Location Lists

The Manage Location Lists option opens the Location List Search window. In the Location List Search window you can perform the following actions.

  • Search for a location list by various search criteria

  • View the entered search results

  • View a location list

  • Create a location list

  • Create a location list from an already existing location list

  • Edit a location list

You can access the Location List Search window from the Task menu, select Foundation Data > Locations > Manage Location Lists. The Location List Search window appears.

The Location List Search window contains the following sections.

Figure 2-25 Location List Search Window

Location List Search window

Searching for a Location List

To search for a location list:

  1. From the Task menu, select Foundation Data > Locations > Manage Location Lists. The Location List Search window appears.

  2. You can search for a location list 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 basic mode.

Searching for a Location List Through the Basic Search Criteria

To search for a location list by using basic search criteria:

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

    Table 2-47 Location List Search - Basic Search Criteria and Description

    Fields Description

    Match option

    Check radio button All or Any.

    All - only location lists matching all entered search criteria are shown.

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

    Location List

    Enter the location list ID.

    Description

    Enter a location list description.

    Type

    Select the location list type, Static or Dynamic, from the list.

    Created Date

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

    Store

    Enter, select or search for the store ID.

    Store Name

    Enter the store name.

    Warehouse

    Enter, select or search for the Warehouse ID.

    Warehouse Name

    Enter the name of warehouse.


  2. Click 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 Personalized Saved Searches window appears.

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

  3. Click Search. The location lists 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 Saved Search".

  6. Click Done to close the window.

Searching for a Location List Through Advanced Search Criteria

To search for a location list by using advanced search criteria:

  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 be equal or not equal to the search result.

  3. Click 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 Personalized Saved Searches window appears.

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

  4. Click Search. The location lists 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 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 location lists. The Results table shows the following columns by default.

  • Location List

  • Description

  • Type

  • Created and Last Rebuild Date

  • Total Locations

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 2-48 Results - Actions Menu/Icons and Description

Actions Menu/Icons Description

Create and Create icon

Select Actions > Create or use the Create icon to create a new location list.

For more details about how to create a location list, see the Creating Location Lists section.

Create from Existing and Create from Existing icon

Select Actions > Create from Existing or use the Create from Existing icon to create a new location list from an existing location list. The Location List window appears.

For more information about this function, see the Creating Location Lists from Existing section.

Edit and Edit icon

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

For more information about how to edit a location list, see the Editing Location Lists section.

View and View icon

To view a location list:

  • Select a record in the Results section.

  • Select Actions > View or click the View icon View icon. The Location List window appears.

Export to Excel and 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.

Mass Change

The Mass Change menu contains the following options:

  • Create Cost Zone Change

    Opens the Change Cost Zones window.

    For more information about changing cost zones, see the Changing Cost Zones section.

  • Change Location Traits

    Opens the Change Location Traits window.

    For more information about changing location traits, see the Changing Location Traits section.


Results - View Menu and Icons

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

Table 2-49 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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


Location List Search Toolbar

The toolbar contains the following icons and buttons.

Table 2-50 Location List Search Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

Done

Click Done to close the window.


Creating Location Lists from Existing

To create a location list from an existing location list, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Locations > Manage Location Lists. The Manage Location List window appears.

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

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

  4. Select a record in the Results section.

  5. Then select Actions > Create from Existing, or use the Create from Existing icon. The Location List window appears. The data of the existing location list is displayed.

  6. Change the fields, if necessary.

    For more information about the available fields in the Location List window, see the Location List Window section.

  7. Then choose one of the following options.

    • Click Save to save the new location list.

    • Click Save and Close to save the new location list and close the window.

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

Editing Location Lists

To edit a location list, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Locations > Manage Location Lists. The Manage Location List window appears.

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

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

  4. Select a record in the Results section.

  5. Then select Actions > Edit, or use the Edit icon. The Location List window appears. The data of the selected location list is displayed.

  6. Change the fields, if necessary.

    For more information about the available fields in the Location List window, see the Location List Window section.

  7. 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.

Changing Cost Zones

The Change Cost Zones window allows you to change the cost zone for all stores and warehouses on a location list.

Figure 2-26 Change Cost Zones Window

Change Cost Zones window

The Changing Cost Zones window contains the following fields.

Table 2-51 Cost Zones - Fields and Description

Fields Description

Location List

This field displays the location list number and description.

Zone Group

Enter, select or search for the current zone group.

This field is a required field.

New Zone

Enter, select or search for the new cost zone.

This field is a required field.


Change Cost Zones Toolbar

The toolbar contains the following icons and buttons.

Table 2-52 Change Cost Zones Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

More Actions

Click More Actions to see a list of additional actions that can be performed in the Change Cost Zones window.

  • Rebuild Location List

    Opens the Location List Rebuild window.

    For more information about how to rebuild location lists, see the Rebuilding Location Lists section.

Save

Click Save to save your changes.

Save and Close

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

Cancel

Click Cancel to reject all entries and close the window.


Mass Update Cost Zones

To update the cost zone for all stores and warehouses on a location list, follow the steps listed below.

  1. From the Tasks menu, select Foundation Data > Locations > Manage Location Lists. The Location List Search window appears.

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

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

  4. Select a record in the Results table.

  5. Then select Actions > Mass Update > Create Cost Zone Change. The Change Cost Zones window appears.

  6. In the Zone Group field, enter, select or search for the group.

  7. In the New Zone field, enter, select or search for the new cost zone.

  8. Then choose one of the following options.

    • Click Save to save the new cost zone.

    • Click Save and Close to a save the new cost zone and close the window.

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

Changing Location Traits

In the Change Location Traits window you can update location traits for a specific location list. The Change Location Traits window contains the following sections.

Figure 2-27 Change Location Traits Window

Change Location Traits window

Change Location Traits Table

In the table add, edit or delete traits of the selected location list.

Change Location Traits Table - Actions Menu and Icons

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

Table 2-53 Change Location Traits Table - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

You can add a location trait to the location list by selecting Actions > Add or by using the Add icon.

For more information about how to add a location trait to the selected location list, see the Adding Location Traits section.

Delete and Delete icon

You can delete a location trait from a location list:

  • Select a record in the table.

  • Select Actions > Delete or use the 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.

Edit and Edit icon

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

For more information about how to edit a trait of a location list, see the Editing Location Traits section.

Export to Excel and 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.


Change Location Traits Table - 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 2-54 Change Location Traits Table - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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.


Change Location Traits Toolbar

The toolbar contains the following icons and buttons.

Table 2-55 Change Location Traits Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

More Actions

Click More Actions to see a list of additional actions that can be performed in the Change Location Traits window.

  • Rebuild Location List

    Opens the Location List Rebuild window.

    For more information about this function, see the Rebuilding Location Lists section.

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.


Mass Update Location Traits

To update the location traits by location list, follow the steps listed below.

  1. From the Tasks menu, select Foundation Data > Locations > Manage Location Lists. The Location List Search window appears.

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

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

  4. Select a record in the Results table.

  5. Then select Actions > Mass Update > Change Location Traits. The Change Location Traits window appears.

  6. Update the traits for the selected location list.

Adding Location Traits

To add a location trait, follow the steps below.

  1. In the Change Location Traits window, select Actions > Edit or use the Edit icon. The Edit Location Trait window appears.

  2. In the Action field, select if you want to Add or Delete the location trait. This field is a required field.


    Note:

    You can also delete a location trait by selecting the Delete icon in the table.

  3. In the Location Trait field, enter, select or search for the location trait. This field is a required field.

  4. Then choose one of the following options.

    • Click OK to add the trait and close the window.

    • Click OK and Add Another to add the current trait and add additional entries.

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

Editing Location Traits

To edit a location trait, follow the steps below.

  1. In the Change Location Traits window, select Actions > Edit or use the Edit icon. The Edit Location Trait window appears.

  2. In the Action field, change the action, if necessary.

  3. In the Location Trait field, enter select or search for another location trait, if necessary.

  4. Then choose one of the following options.

    • Click OK to edit the current trait and close the window.

    • Click OK and Add Another to add the current trait and add additional entries.

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

Cost Zones Window

The Cost Zones window allows you to create, maintain, and view the cost zones for a selected cost zone group. You can categorize stores into zones based on a costing strategy. For each cost zone group, one cost zone is set as the base cost zone. The base cost zone indicates that the price for the item is based on the price of the item in the zone. When a new cost zone group is created, all locations must be added to the group. The locations can exist individually within a group or locations can be grouped into cost zones.

The Cost Zones window contains the following sections.

Figure 2-28 Cost Zones Window

Cost Zones window

Cost Zone Groups

The Cost Zone Groups section allows you to add, delete, or view cost zone groups. A cost zone group is a grouping mechanism that allows you to categorize stores into zones based on a costing strategy. This grouping mechanism is available only when you are tracking Estimate Landed Costs (ELC).

The table displays the zone group, cost level and description by default.

  • Description

    You can edit the Description column directly in the table.

Cost Zone Groups - Actions Menu and Icons

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

Table 2-56 Cost Zone Groups - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

You can add new cost zone groups by selecting Actions > Add or by using the Add icon.

For more information about how to add new cost zone groups, see the Adding Cost Zone Groups section.

Delete and Delete icon

You can delete cost zone groups:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.

Translate and Translate icon

You can create a translation by selecting Actions > Translate or by using the Translate icon.


Cost Zone Groups/Zones/Locations - View Menu and Icons

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

Table 2-57 Cost Zone Groups/Zones/ Locations - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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


Cost Zones

The Cost Zones section allows you to add, delete, and view the cost zones for a selected cost zone group.

The table displays the zone ID, description, locations, currency and base cost checkbox by default.

  • Description

    You can edit the Description column directly in the table.

  • Base Cost

    Select the Base Cost checkbox, to indicate that the price for the item is based on the price of the item in the zone.

Cost Zones - Actions Menu and Icons

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

Table 2-58 Cost Zones - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

You can add new cost zones to a cost zone group by selecting Actions > Add or by using the Add icon.

For more information about how to add a new cost zone to a cost zone group, see the Adding Cost Zones section.

Delete and Delete icon

You can delete cost zones from a cost zone group:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.

Translate and Translate icon

You can create a translation by selecting Actions > Translate or by using the Translate icon.


Cost Zones - View Menu and Icons

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

For more information about the View Menu and icons of the table, see Table 2-57, "Cost Zone Groups/Zones/ Locations - View Menu/Icons and Description"

Cost Zone Locations

The Cost Zone Locations section allows you to add, edit, delete, or view locations in the cost zone. In edit mode, you may add locations to a cost zone or move locations to a different cost zone.

Locations cannot be edited for any cost zone group at the location level because the location is a cost zone group.

The table displays the location type, ID and location name as well as the primary discharge port and port description by default.

  • Primary Discharge Port

    You can edit the primary discharge port for a location directly in the table.

Cost Zone Locations - Actions Menu and Icons

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

Table 2-59 Cost Zone Locations - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

You can add new locations to a cost zone by selecting Actions > Add or by using the Add icon.

For more information about how to add new cost zone locations to a cost zone, see the Adding Cost Zone Locations section.

Edit and Edit icon

Select Actions > Edit or use the Edit icon to edit the selected cost zone location.

For more information about how to edit cost zone locations, see the Editing Cost Zone Locations section.

Delete and Delete icon

You can delete cost zone locations from a cost zone:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.


Cost Zone Locations - View Menu and Icons

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

For more information about the View Menu of the table, see Table 2-57, "Cost Zone Groups/Zones/ Locations - View Menu/Icons and Description"

Cost Zones Toolbar

The Toolbar contains the following icons and buttons.

Table 2-60 Cost Zones Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

You can access the online help for a particular page by clicking the 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.


Maintaining Cost Zones

To maintain Cost Zones, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Locations > Cost Zones. The Cost Zones window appears.

  2. Update the cost zones, as necessary.

Adding Cost Zone Groups

To add cost zone groups, follow the steps listed below.

  1. Open the Cost Zones Group section.

  2. Then select Actions > Add or use the Add icon. The Add Cost Zone Groups window appears.

    Figure 2-29 Add Cost Zone Group Window

    Add Cost Zone Group window
    1. In the Zone Group field, enter a unique zone group ID. This field is a required field.

    2. In the Description field, enter a unique description for the zone group.

    3. In the Cost Level field, select the cost level from the list.

    4. In the Like Group field, enter, select or search for a group to copy the zones and locations of the selected group to the new group.

    5. Then select one of the following options.

      • Click OK to add the new cost zone group and close the window.

      • Click OK and Add Another to add additional cost zone groups.

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

Adding Cost Zones

To add a new cost zone to a cost zone group, follow the steps below.

  1. In the Cost Zones window, select a record in the Cost Zone Groups section.

  2. All the available cost zones for the selected cost zone group are displayed in the Cost Zones section.

  3. In the Cost Zones section, select Actions > Add or use the Add icon. The Add Cost Zone window appears.

    Figure 2-30 Add Cost Zone Window

    Add Cost Zone window
    1. In the Zone field, enter a unique Zone ID.

    2. In the Description field, enter a unique zone description.

    3. In the Currency field, enter, select or search for the currency ID.

    4. Then choose one of the following options.

      • Click OK to add the new cost zone and close the window.

      • Click OK and Add Another to add additional cost zones.

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


Note:

If the cost level of the new cost zone group is Location, a cost zone for each location is created automatically.

You have to add all locations for a new cost zone group. If any location is missing from the group, you will receive a message listing all missing locations when you save your changes in the Cost Zones window.


Adding Cost Zone Locations

To add cost zone locations to a cost zone, follow the steps listed below.

  1. In the Cost Zones window, select a record in the Cost Zones section.

  2. The available locations for the selected cost zone are displayed in the Cost Zone Locations table.

  3. In the Cost Zone Locations table, select Actions > Add or use the Add icon. The Add Cost Zone Locations window appears.

    Figure 2-31 Add Cost Zone Location Window

    Add Cost Zone Location window
    1. In the Location field, select the location type from the list. The field next to the location type enables. Enter, select or search for the location ID.

    2. In the Discharge Port field, select, enter or search for the port.

    3. Then choose one of the following options.

      • Click OK to add the location and close the window.

      • Click OK and Add Another to add additional locations.

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

Editing Cost Zone Locations

To edit a cost zone location, follow the steps listed below.

  1. In the Cost Zones window, select the record you want to edit in the Cost Zone Locations table.

  2. Then select Actions > Edit or use the Edit icon. The Edit Cost Zone Location window appears.

    1. The warehouse/store ID and description of the selected record are displayed.

    2. In the New Zone field, enter, select or search for a new zone, if you want to move the current location to another zone.

    3. In the Discharge Port field, enter, select or search for another port.

    4. Then choose one of the following options.

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

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

Merchandise Hierarchy Window

The Merchandise Hierarchy window allows you to create, edit, and view a member of the selected level of the merchandise hierarchy.

The Merchandise Hierarchy window contains the following sections.

Figure 2-32 Merchandise Hierarchy Window

Merchandise Hierarchy window

Merchandise Hierarchy Structure

The Merchandise Hierarchy structure on the left side of the window contains the following buttons.

Table 2-61 Merchandise Hierarchy Structure - Buttons and Description

Buttons Description

Division

Displays the available divisions in the table.

Group

Displays the available groups in the table.

Department

Displays the available departments in the table.

Class

Displays the available classes in the table.

Subclass

Displays the available subclasses in the table.


Merchandise Hierarchy Table

The Hierarchy table displays the available entries of the selected hierarchy level.

For example, if you select the Division button, all available divisions are displayed in this table.

The table displays the following columns by default.

  • Hierarchy ID, depending on the selected hierarchy button.

  • Name of the hierarchy level, for example, the name of the chain.

  • Next hierarchy level, for example, Group

    This column contains either the Create icon or the Details icon.

    If the next level has been created, the Detail icon is displayed. Use the icon to maintain or view the details of the next level.

    If the next level has not been created, the Create icon is displayed. Use the icon to create the next level.

    This column is not available for subclasses.

Merchandise Hierarchy Table - Actions Menu and Icons

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

Table 2-62 Merchandise Hierarchy Table - Actions Menu/Icons and Description

Actions Menu/Icons Description

Create and Create icon

You can create a new hierarchy level by selecting Actions > Create or by using the Create icon.

For more information about how to create the individual hierarchy levels, see the following sections:

Edit and Edit icon

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

For more information about how to edit a hierarchy level, see the following sections.

View and View icon

To view a hierarchy level:

  • Select a hierarchy button. For example, select Chain.

  • Then select a record in the table.

  • Select Actions > View or click the View icon.

  • The window of the selected hierarchy level appears.

Export to Excel and 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.


Merchandise Hierarchy Table - View Menu and Icons

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

Table 2-63 Merchandise Hierarchy Table - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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.


Merchandise Hierarchy Toolbar

The Toolbar contains the following icons and buttons.

Table 2-64 Merchandise Hierarchy Toolbar - Icon/Button and Description

Icon/Button Description

Help icon

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

Done

Click Done to close the window.


Creating Divisions

To create a division, follow the steps below.

  1. Click the Division button. All available divisions are displayed in the table.

  2. In the table, select Actions > Create, or use the Create icon. The Divisions window appears.

  3. Select Actions > Add, or use the Add icon. The Add Division window appears.

    Figure 2-33 Add Division Window

    Add Division window
    1. In the Division field, enter a unique ID for the division.

    2. In the Name field, enter a name for the division.

    3. In the Total Market Amount field, enter the amount of annual sales that the division is expected to generate in thousands.

    4. In the Buyer Name field, enter, select or search for the buyer ID who is responsible for the division.

    5. In the Merchandiser Name field, enter, select or search for the merchandiser ID who is responsible for the division.

    6. Then choose one of the following options.

      • Click OK to add the division and close the window.

      • Click OK and Add Another to add additional divisions.

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

Editing Divisions

To edit a division, follow the steps below.

  1. Click the Division button. All available divisions are displayed in the table.

  2. Select Actions > Edit, or use the Edit icon. The Divisions window appears.

  3. Select a record in the table.

  4. Then select Actions > Edit, or use the Edit icon. The Edit Division window appears.

    1. The information of the selected division is displayed. Change the values, as necessary. You cannot change the division ID.

    2. Then choose one of the following options.

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

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

Divisions Window

The Divisions window allows you to add, edit, delete and view divisions in the merchandise hierarchy. A division is below the company and above the group in the merchandise hierarchy. Typically, the division is used to signify the type of merchandise that your organization offers, such as hardlines or apparel.

Figure 2-34 Divisions Window

Divisions window

Divisions - Actions Menu and Icons

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

Table 2-65 Divisions - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

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

The Add function is not available, if you are in edit mode.

For more information about how to add a new division, see the Creating Divisions section.

Delete and Delete icon

You can delete chains:

  • Select a record in the table.

  • Select Actions > Delete or use the 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.

Edit and Edit icon

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

For more information about how to edit a division, see the Editing Divisions section.

Export to Excel and 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.

Translate and Translate icon

You can create a translation by selecting Actions > Translate or by using the Translate icon.


Divisions - View Menu and Icons

You can customize the view of the table by using the options in the View Menu and icons listed below.

Table 2-66 Divisions - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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


Divisions Toolbar

The toolbar contains the following icon and buttons.

Table 2-67 Divisions Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

You can access the online help for a particular page by clicking the 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.


Creating Groups

To create a group, follow the steps below.

  1. Click the Group button. All available groups are displayed in the table.

  2. In the table, select Actions > Create, or use the Create icon. The Groups window appears.

  3. Select Actions > Add, or use the Add icon. The Add Group window appears.

    Figure 2-35 Add Group Window

    Add Group window
    1. In the Group field, enter a unique ID for the group. This field is a required field.

    2. In the Name field, enter a name for the group. This field is a required field.

    3. In the Division field, enter, select or search for the division ID of the division associated with the group. This field is a required field.

    4. In the Buyer Name field, enter, select or search for the buyer ID who is responsible for the group.

    5. In the Merchandiser Name field, enter, select or search for the merchandiser ID who is responsible for the group.

    6. Then choose one of the following options.

      • Click OK to add the group and close the window.

      • Click OK and Add Another to add additional divisions.

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

Editing Groups

To edit a group, follow the steps below.

  1. Click the Group button. All available groups are displayed in the table.

  2. Select Actions > Edit, or use the Edit icon. The Groups window appears.

  3. Select a record in the table.

  4. Then select Actions > Edit, or use the Edit icon. The Edit Group window appears.

    1. The information of the selected group is displayed. Change the values, as necessary. You cannot change the group ID.

    2. Then choose one of the following options.

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

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

Groups Window

The Groups window allows you to add, edit, delete, and view a group in the merchandise hierarchy. A group is below the division and above the department in the merchandise hierarchy. A group can belong to only one division.

Figure 2-36 Groups Window

Groups window

Groups - Actions Menu and Icons

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

Table 2-68 Groups - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

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

The Add function is not available, if you are in edit mode.

For more information about how to add a new group, see the Creating Groups section.

Edit and Edit icon

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

For more information about how to edit a group, see the Editing Groups section.

Delete and Delete icon

You can delete chains:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.

Search and Search icon

You can search for the corresponding division of a group:

  • Enter, select or search for the chain ID.

  • Press Enter or click the Search icon.

  • The search results are displayed in the table.

Translate and Translate icon

You can create a translation by selecting Actions > Translate or by using the Translate icon.


Groups - View Menu and Icons

You can customize the view of the table by using the options in the View Menu and icons listed below.

Table 2-69 Groups - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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


Groups Toolbar

The toolbar contains the following icon and buttons.

Table 2-70 Groups Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

You can access the online help for a particular page by clicking the 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.


Creating Departments

To create a department, follow the steps below.

  1. Click the Department button. All available departments are displayed in the table.

  2. In the table, select Actions > Create, or use the Create icon. The Department window appears.

  3. Enter the necessary information. For more information about the available fields of the Department window, see the Department Window section.

  4. Then select one of the following options.

    1. Click Save and Close to save the current department and close the window.

    2. Click Save to save the current department.

    3. Click Save and Create Another to create additional departments.

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

Editing Departments

To edit a department, follow the steps below.

  1. Click the Department button. All available departments are displayed in the table.

  2. In the table, select the department you want to edit. The Department window appears.

  3. The information of the selected department is displayed. Change the values, as necessary. You cannot change the department ID and purchase type.

  4. Then choose one of the following options.

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

    2. Click Save to save your changes.

Department Window

The Department window allows you to create, edit, delete, and view a department in the merchandise hierarchy.

Figure 2-37 Department Window

Department window

The Department window contains the following fields.

Table 2-71 Department - Fields and Description

Fields Description

Department

Enter a unique ID for the department.

Enter a name for the department in the field next to the department ID.

These fields are required fields.

You cannot edit the department ID in edit mode.

Group

Enter, select or search for the group ID associated with the department.

This field is a required field.

Profit Calculation Type

Select a profit calculation type from the list. Possible values are:

  • Direct Cost

  • Retail Inventory

This field is a required field.

OTB Calculation Type

Select an OTB calculation type from the list. Possible values are:

  • Direct Cost

  • Retail Inventory

This field is a required field.

Purchase Type

The purchase type indicates the type of merchandise sold in the department.

Select a purchase type from the list. Possible values are:

  • Normal

    The items in the department are ordered, invoiced, and recorded in the stock ledger.

  • Consignment

    The items in the department are ordered, invoiced, and recorded in the stock ledger.

    Accounts receivable and accounts payable are not recorded for this item type. The consignment rate is recorded at the item/supplier level.

  • Concession

    The items in the department are ordered, invoiced, and recorded in the stock ledger.

    Accounts receivable and accounts payable are not recorded for this item type. The concession rate is recorded at the item/supplier level.

This field is a required field.

You cannot change the purchase type in edit mode.

Buyer

Enter, select or search the buyer ID associated with the department.

Merchandiser

Enter, select or search for the merchandiser ID associated with the department.

Markup Calculation Type

Select the markup calculation type.

Markup % of Cost

Enter the markup percent of the cost.

This field is a required field.

You cannot change the value in edit mode.

Markup % of Retail

Enter the markup percent of the retail value.

This field is a required field.

You cannot change the value in edit mode.

Total Market Amount (in Thousands)

Enter the amount of annual sales that the department is expected to generate.

Maximum Average Counter

Enter the maximum average counter.

This field is a required field.

Average Tolerance

Enter the average tolerance value in percent.

This field is a required field.

Include VAT in Retail? checkbox

The Include VAT in Retail checkbox indicates that all prices include VAT in the retail price for all classes in the department.

Clear the check box to indicate that VAT is not included in the retail price at the class level, and is applied at the POS.

The Include VAT in Retail checkbox is only available, if the default tax type is set to SVAT or GTAX.


Department Toolbar

The toolbar contains the following icon and buttons.

Table 2-72 Department Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

Delete icon

You can delete the current department by selecting the Delete icon.

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

More Actions

Click More Actions to see a list of additional actions that can be performed in the Department window.

  • Up Charges

    Opens the Department Up Charges window.

    For more information about this function, see the Department Up Charges Window section

  • VAT Maintenance

    Opens the Department VAT window.

    For more information about this function, see the Department VAT Window section.

  • Merchandise Hierarchy Defaults

    Opens the Merchandise Hierarchy Defaults window.

    For more information about this function, see the Merchandise Hierarchy Defaults Windowsection.

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.


Department Up Charges Window

The Department Up Charge window displays a department's from/to location combinations and associated up charges. Up Charges are incurred when transferring items within the department or within the from and the to locations.


Note:

This window will only be available if the RMS 'Estimated Landed Costs' indicator is set to 'Yes'.

Each Up Charge has a:

  • Calculation Basis of either 'Value' or 'Specific.'

  • Cost Basis of either 'Weighted Average Cost' (when using Average Cost Method) or 'Unit Cost' (when using Standard Cost Method).

Component Rate of:

  • Monetary if Calculation Basis = 'Specific.'

  • Percentage if Calculation Basis = 'Value.'

  • Component Currency.

The Up Charge Group is used to group Up Charge Components together to show a total sum on the Transfer Up Charge window.

The Department Up Charges window contains the following sections.

Figure 2-38 Department Up Charges Window

Department Up Charges window

Locations

The Locations section displays the from and to locations containing expenses for the department.

Locations - Actions Menu and Icons

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

Table 2-73 Locations - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

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

For more information about how to add new locations, see the Adding Locations section.

Delete and Delete icon

You can delete locations:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.


Locations - View Menu and Icons

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

Table 2-74 Locations/Up Charges/Rate Updates - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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.


Up Charges

The Up Charges section displays the details of the charges.

Up Charges - Actions Menu and Icons

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

Table 2-75 Up Charges - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

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

For more information about how to add new up charges, see the Adding Components section.

Edit and Edit icon

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

For more information about how to edit a charge, see the Editing Components section.

Delete and Delete icon

You can delete up charges:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.


Up Charges - View Menu and Icons

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

For more information about the View Menu, see Table 2-74, "Locations/Up Charges/Rate Updates - View Menu/Icons and Description".

Rate Updates

In the Rate Updates section you can apply rate updates to items and transfers and allocations.

Rate Updates - Actions Menu and Icons

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

Table 2-76 Rate Updates - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

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

For more information about how to add rate updates, see the Adding Rate Updates section.

Edit and Edit icon

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

For more information about how to edit a rate update, see the Editing Rate Updates section.

Delete and Delete icon

You can delete rate updates:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.


Rate Updates - View Menu and Icons

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

For more information about the View Menu, see Table 2-74, "Locations/Up Charges/Rate Updates - View Menu/Icons and Description".

Department Up Charges Toolbar

The toolbar contains the following icons and buttons.

Table 2-77 Department Up Charges Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

You can access the online help for a particular page by clicking the 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.


Maintaining Department Up Charges

To maintain department up charges, follow the steps listed in the sections below.

  1. From the Tasks menu, select Foundation Data > Items > Merchandise Hierarchy. The Merchandise Hierarchy window appears.

  2. Click the Department button. The available Departments are displayed in the table.

  3. In the Department column, click the department ID link, or mark a record and select Actions > Edit, or use the Edit icon. The Department window appears.

  4. Select More Actions > Up Charges. The Department Up Charges window appears.

  5. Update the department up charges, as necessary.

Adding Locations

To add locations for up charges, follow the steps listed below.

  1. In the Locations section, select Actions > Add, or use the Add icon. The Add Locations window appears.

    Figure 2-39 Add Locations Window

    Add Locations window
  2. In the From Group Type field, select a group type from the list. This field is a required field.

  3. In the From Group field, enter, select or search for the group ID, if enabled.

  4. In the To Group Type field, select the group type from the list. This field is a required field.

  5. In the To Group field, enter, select or search for the group ID, if enabled.

  6. In the Component field, enter, select or search for the component. This field is a required field.

  7. In the Up Charge Group field, select an up charge group from the list. This field is a required field.

  8. In the Component Rate field, enter the rate. This field is a required field.

  9. In the Per Count field, enter the number of counts.

  10. In the Per Count Unit of Measure, enter, select or search for the UOM.

  11. In the Component Currency field, enter, select or search for the currency.

  12. Then choose one of the following options.

    • Click OK to save the location information and close the window.

    • Click OK and Add Another to add additional location information.

    • Click Cancel to reject all entries and close window.

Adding Components

To add components, follow the steps listed below.

  1. In the Up Charges section, select Actions > Add, or use the Add icon. The Add Component window appears.

    Figure 2-40 Add Component Window

    Add Component window
  2. In the Component field, enter, select or search for the component. This field is a required field.

  3. In the Up Charge Group field, select the group from the list.

  4. In the Component Rate field, enter the rate.

  5. In the Per Count field, enter the number of counts.

  6. In the Per Count Unit of Measure, enter, select or search for the UOM.

  7. In the Component Currency field, enter, select or search for the currency.

  8. Then choose one of the following options.

    • Click OK to save the location information and close the window.

    • Click OK and Add Another to add additional location information.

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

Editing Components

To edit existing components, follow the steps listed below.

  1. In the Up Charges section, select Actions > Edit, or use the Edit icon. The Edit Component window appears.

  2. Edit the fields, as necessary.

  3. Then choose one of the following options.

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

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

Adding Rate Updates

To add rate updates for items and/or transfers and allocations, follow the steps below.

  1. In the Rate Updates section, select Actions > Add, or use the Add icon. The Add Rates window appears.

    Figure 2-41 Add Rate Update Window

    Add Rate Update window
  2. In the Effective Date field, enter the effective date or use the Calendar icon to select a date. This field is a required field.

  3. In the Component Rate field, enter the component rate. This field is a required field.

  4. In the Per Count field, enter the number of counts.

  5. In the Per Count UOM, enter, select or search for the unit of measure.

  6. In the Component Currency field, enter, select or search for the component currency code.

  7. Select the Transfers and Allocations checkbox to apply the rate updates to transfers and allocations.

  8. Select the Items checkbox to apply the rate updates to items.

  9. Then choose one of the following options.

    • Click OK to add the rate updates and close the window.

    • Click OK and Add Another to add additional rate updates.

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

Editing Rate Updates

To edit rate updates for items and/or transfers and allocations, follow the steps below.

  1. In the Rate Updates section, select Actions > Edit, or use the Edit icon. The Edit Rates window appears.

  2. Edit the fields, as necessary.

  3. Then choose one of the following options.

    • Click OK to add the rate updates and close the window.

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

Department VAT Window

The Department VAT window allows you to maintain and view value added tax (VAT) regions and VAT codes that are associated with a department. The VAT regions and VAT codes that are entered at the department level become the default VAT regions and VAT codes for items within the department.

The Department VAT Window contains the following sections.

Figure 2-42 Department VAT Window

Department VAT window

Department VAT Table - Actions Menu and Icons

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

Table 2-78 Department VAT Table - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

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

For more information about how to add new VAT region, see the Adding VAT Regions section

Delete and Delete icon

You can delete VAT regions:

  • Select a record in the table.

  • Select Actions > Delete or use the 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.

Edit and Edit icon

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

For more information about how to edit a VAT region, see the Editing VAT Regions section.

Export to Excel and 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.


Department VAT Table - View Menu and Icons

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

Table 2-79 Department VAT Table - 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

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

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

Query by Example and 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.


Department VAT Toolbar

The toolbar contains the following icons and buttons.

Table 2-80 Department VAT Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

You can access the online help for a particular page by clicking the 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.


Maintaining Department VAT Regions

To maintain Department VAT regions, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Items > Merchandise Hierarchy. The Merchandise Hierarchy window appears.

  2. Click the Department button. The available Departments are displayed in the table.

  3. In the Department column, click the department ID link, or mark a record and select Actions > Edit, or use the Edit icon. The Department window appears.

  4. Select More Actions > VAT Maintenance. The Department VAT window appears.

  5. Update the department VAT regions, as necessary.

Adding VAT Regions

To add VAT regions to the selected department, follow the steps below.

  1. Select Actions > Add, or use the Add icon. The Add VAT Region window appears.

  2. In the VAT Region field, enter, select or search for the desired region. This field is a required field.

  3. In the VAT Type field, select the type from the list. This field is a required field.

  4. In the VAT Code field, enter, select or search for the VAT code.

  5. The Rate(%) and the VAT Code Description are displayed.

  6. Then choose one of the following options.

    • Click OK to add the VAT region and close the window.

    • Click OK and Add Another to add additional VAT regions.

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

Editing VAT Regions

To edit VAT regions for the selected department, follow the steps below.

  1. Select Actions > Edit, or use the Edit icon. The Edit VAT Region window appears.

  2. In the VAT Code field, change the VAT code, as necessary.

  3. Then choose one of the following options.

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

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

Merchandise Hierarchy Defaults Window

The Merchandise Hierarchy Defaults window allows you to make certain item details available and required. These item defaults are based on the department, class, and subclass in which the item resides. The defaults may include a variety of options, such as Harmonized Tariff Schedule (HTS), item attributes, and tickets. You can set up the defaults when creating a department, class, or subclass. For example, you can indicate that items in a selected department cannot be approved unless they have an HTS code. On the other hand, you can make the HTS option unavailable for items in the selected department.

When creating defaults at the department level, you can add information only for the classes and subclasses within that department. For example, if you enter department 1000 and make the default both available and required, every class and subclass within department 1000 inherits the same default settings. If you enter department 2000 and class 3000, every subclass within department 2000 and class 3000 inherits the same default settings.

The Merchandise Hierarch Defaults window contains the following sections.

Figure 2-43 Merchandise Hierarchy Defaults Window

Merchandise Hierarchy Defaults window

Merchandise Hierarchy Defaults Table - Actions Menu and Icons

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

Table 2-81 Merchandise Hierarchy Defaults - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

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

For more information about how to add default information, see the Adding Defaults section.

Delete and Delete icon

You can delete default information for a department:

  • Select a record in the table.

  • Select Actions > Delete or use the 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.

Edit and Edit icon

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

For more information about how to edit default information for a department, see the Editing Defaults section.

Export to Excel and 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.

Copy All button

Use the Copy All button to copy item defaults from one subclass to another.

For more information about this function, see the Copy All section.

This button is only available at the subclass level.


Merchandise Hierarchy Defaults Table - View Menu and Icons

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

Table 2-82 Merchandise Hierarchy Defaults - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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.


Merchandise Hierarchy Defaults Toolbar

The toolbar contains the following icons and buttons.

Table 2-83 Merchandise Hierarchy Defaults Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

You can access the online help for a particular page by clicking the 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.


Maintaining Merchandise Hierarchy Defaults

To maintain merchandise hierarchy defaults, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Items > Merchandise Hierarchy. The Merchandise Hierarchy window appears.

  2. Click the Department/Class/Subclass button. The available departments/classes/subclasses are displayed in the table.

  3. In the Department/Class/Subclass column, click the department ID link, or mark a record and select Actions > Edit, or use the Edit icon. The Department/Class/Subclass window appears.

  4. Select More Actions > Merchandise Hierarchy Defaults. The Merchandise Hierarchy Defaults window appears.

  5. Update the hierarchy default information, as necessary.

Adding Defaults

To add item defaults for the selected hierarchy level, follow the steps below.

  1. In the table, select Actions > Add, or use the Add icon. The Add Merchandise Hierarchy Defaults window appears.

  2. In the Information field, select the default information you want to add.

  3. In the Class field, enter, select or search for the class ID. This field is only enabled, if you add an item default for a department.

  4. In the Subclass field, enter, select or search for the subclass ID. This field is only enabled, if you add an item default for a department.

  5. Indicate, if the information is unavailable or available for the items in the selected department/class/subclass.

  6. Select the Required checkbox to indicate that the information is required for items in the selected department/class/subclass.

  7. Then choose one of the following options.

    • Click OK to add the default information and close the window.

    • Click OK and Add Another to add additional defaults.

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

Editing Defaults

To edit item defaults for the selected hierarchy level, follow the steps below.

  1. In the table, select Actions > Edit, or use the Edit icon. The Edit Merchandise Hierarchy Defaults window appears.

  2. Change the checkboxes, as necessary. All other fields are disabled.

  3. Then choose one of the following options.

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

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

Copy All

To copy all item defaults from one subclass to another, follow the steps below.

  1. In the table, select the Copy All button. The Copy From window appears.

  2. In the Department field, enter, select or search for the department you want to copy from.

  3. In the Class field, enter, select or search for the class ID.

  4. In the Subclass field, enter, select or search for the subclass ID.

  5. Then choose one of the following options.

    • Click OK to copy the item defaults from the selected hierarchy and close the window.

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

Creating Classes

To create a class, follow the steps below.

  1. Click the Class button. The Department field is displayed.

  2. In the Department field, enter, select or search for the department ID.

  3. In the table, select Actions > Create, or use the Create icon. The Classes window appears. The selected department ID and description are displayed in the header.

  4. Select Actions > Add, or use the Add icon. The Add Class window appears.

    Figure 2-44 Add Class Window

    Add Class window
    1. In the Class field, enter a unique ID for the class. This field is a required field.

    2. In the Name field, enter a name for the class. This field is a required field.

    3. Select the Include VAT in Retail checkbox to indicate that the retail price includes VAT.


      Note:

      The Include in VAT Retail checkbox is only displayed, if VAT at the class level is indicated in the RMS system settings.

      If you do not select the checkbox, you indicate that VAT should be applied to the retail price at the point of sale when setting up a store.


    4. Then choose one of the following options.

      • Click OK to add the class and close the window.

      • Click OK and Add Another to add additional classes.

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

Editing Classes

To edit a class, follow the steps below.

  1. Click the Class button. The Department field is displayed.

  2. In the Department field, enter, select or search for the department ID. The classes for the selected department are displayed in the table.

  3. Select Actions > Edit, or use the Edit icon. The Classes window appears.

  4. Select a record in the table.

  5. Then select Actions > Edit, or use the Edit icon. The Edit Class window appears.

    1. The information of the selected class is displayed. Change the values, as necessary. You cannot change the class ID.

    2. Then choose one of the following options.

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

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

Classes Window

The Classes window allows you to add, edit, delete, and view a class in the merchandise hierarchy. A class is below the department and above the subclass in the merchandise hierarchy.

A class can belong to only one department. A class further defines the type of merchandise sold in a department. For example, a department for Men's Shirts might have the classes Casual, Business, and Formal.

When VAT is enabled at the class level in RMS, you can indicate whether the retail price should include the VAT or not. If you choose not to indicate that VAT is included at the class level, then you should indicate to include it at the POS.

Finally, you can associate user defined attributes with a class.

Figure 2-45 Classes

Classes window

Classes - Actions Menu and Icons

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

Table 2-84 Classes - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

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

The Add function is not available, if you are in edit mode.

For more information about how to add a new class, see the Creating Classes section.

Edit and Edit icon

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

For more information about how to edit a class, see the Editing Classes section.

Delete and Delete icon

You can delete classes:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.

Translate and Translate icon

You can create a translation by selecting Actions > Translate or by using the Translate icon.


Classes - View Menu and Icons

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

Table 2-85 Classes - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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


Classes Toolbar

The toolbar contains the following icon and buttons.

Table 2-86 Classes Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

More Actions

Click More Actions to see a list of additional actions that can be performed in the Classes window.

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.


Creating Subclasses

To create a subclass, follow the steps below.

  1. Click the Subclass button. The Department field is displayed.

  2. In the Department field, enter, select or search for the department ID. The Class field enables.

  3. In the Class field, enter, select or search for the class ID. The available subclasses are displayed in the table.

  4. Select Actions > Create, or use the Create icon. The Subclasses window appears. The selected department/class ID and description are displayed in the header.

  5. Select Actions > Add, or use the Add icon. The Add Subclass window appears.

    Figure 2-46 Add Subclass Window

    Add Subclass window
    1. In the Subclass field, enter a unique ID for the subclass. This field is a required field.

    2. In the Name field, enter a name for the subclass. This field is a required field.

    3. Then choose one of the following options.

      • Click OK to add the subclass and close the window.

      • Click OK and Add Another to add additional subclasses.

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

Editing Subclasses

To edit a subclass, follow the steps below.

  1. Click the Subclass button. The Department field is displayed.

  2. In the Department field, enter, select or search for the department ID. The Class field is enabled.

  3. In the Class field, enter, select or search for the Class ID. The available subclasses are displayed in the table.

  4. In the table, select Actions > Edit, or use the Edit icon. The Subclasses window appears.

  5. Select a record in the table.

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

    1. The information of the selected subclass is displayed. Change the values, as necessary. You cannot change the subclass ID.

    2. Then choose one of the following options.

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

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

Subclasses Window

The Subclasses window allows you to add, edit, delete, and view a subclass in the merchandise hierarchy. A subclass is below a class in the merchandise hierarchy. A subclass can belong to only one class. A subclass further defines the type of merchandise sold in a department and class.

You can associate user defined attributes with a subclass.

Figure 2-47 Subclasses Window

Subclasses window

Subclasses - Actions Menu and Icons

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

Table 2-87 Subclasses - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

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

The Add function is not available, if you are in edit mode.

For more information about how to add a new subclass, see the Creating Subclasses section.

Edit and Edit icon

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

For more information about how to edit a subclass, see the Editing Subclasses section.

Delete and Delete icon

You can delete subclasses:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.

Translate and Translate icon

You can create a translation by selecting Actions > Translate or by using the Translate icon.


Subclasses - View Menu and Icons

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

Table 2-88 Subclasses - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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


Subclasses Toolbar

The toolbar contains the following icon and buttons.

Table 2-89 Subclasses Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

More Actions

Click More Actions to see a list of additional actions that can be performed in the Classes window.

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.


Pending Merchandise Hierarchy Search

The Pending Merchandise Hierarchy option opens the Pending Merchandise Hierarchy Search window. In the Pending Merchandise Hierarchy Search window you can perform the following actions.

  • Search for pending hierarchy levels by various search criteria

  • View the entered search results

  • View and edit the action type of the hierarchy level

The Pending Merchandise Hierarchy Search window contains the following sections.

Figure 2-48 Pending Merchandise Hierarchy Search

Pending Merchandise Hierarchy window

Searching for a Pending Merchandise Hierarchy

To search for a pending merchandise hierarchy level:

  1. From the Task menu, select Foundation Data > Items > Pending Merchandise Hierarchy. The Pending Merchandise Hierarchy Search window appears.

  2. You can search for a hierarchy 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.

Searching for a Pending Merchandise Hierarchy Through the Basic Search Criteria

To search for a hierarchy level by using basic search criteria:

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

    Table 2-90 Pending Merchandise Hierarchy Search - Basic Search Criteria and Description

    Fields Description

    Match option

    Check radio button All or Any.

    All - only hierarchy levels matching all entered search criteria are shown.

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

    Action Type

    Select an action type from the list. Possible action types are:

    • Addition

    • Modification

    Effective Date

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

    Division

    Enter, select or search for a division.

    Group

    Enter, select or search for a group.

    Department

    Enter, select or search for a department.

    Class

    Enter, select or search for a class.

    Subclass

    Enter, select or search for a subclass.


  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 Personalized Saved Searches window appears.

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

  3. Click Search. The pending hierarchy levels 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 Saved Search".

  6. Click Done to close the window.

Searching for a Pending Hierarchy Through Advanced Search Criteria

To search for a hierarchy level by using advanced search criteria:

  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 be equal or not equal to 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 Personalized Saved Searches window appears.

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

  4. Click Search. The pending hierarchy levels 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 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 pending merchandise hierarchy levels.

Result - Actions Menu and Icons

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

Table 2-91 Results - Actions Menu/Icons and Description

Actions Menu/Icons Description

Edit and Edit icon

Select Actions > Edit or use the Edit icon to edit the selected merchandise hierarchy level.

For more information about how to edit a pending merchandise hierarchy level, see the Editing a Pending Merchandise Hierarchy section.

View and View icon

To view a pending merchandise hierarchy level:

  • Select a record in the Results section.

  • Select Actions > View or click the View icon. The Pending Merchandise Hierarchy window appears.

  • Click Done to close the window.

Export to Excel and 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.


Results - View Menu and Icons

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

Table 2-92 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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


Toolbar

The toolbar contains the following icons and buttons.

Table 2-93 Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

Done

Click Done to close the window.


Pending Merchandise Hierarchy Window

The Pending Merchandise Hierarchy window allows you to maintain movements within the merchandise hierarchy. Movements within the merchandise hierarchy will lead to the eventual reclassification of the items within the reclassified level. When an item is reclassified, sales history, purchase orders, inventory, and planning information is reclassified as well.

Only Level 1 items can be reclassified. Any prepacks, Level 2, or Level 3 items associated with the Level 1 item are also reclassified.

The Pending Merchandise Hierarchy window contains the following fields.

Table 2-94 Pending Merchandise Hierarchy - Fields and Description

Fields Description

Action Type

Displays, if you add or edit a merchandise hierarchy.

Effective Date

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

Hierarchy Level

Displays the hierarchy level.

Hierarchy Level ID and Description

Displays the hierarchy level. Enter a description.

You can create a translation by selecting the Translate icon.

Buyer

Enter, select or search for the buyer.

Total Market Amount

(in Thousands)

Enter the total market amount in thousands.

Merchandiser

Enter, select or search for the merchandiser.

Domain

This field contains the unique number representing the domain. The domain number is used when interfacing data to external systems using domains.

Markup Calculation Type:


% of Cost

Indicates that the markup is calculated as a percentage of the cost.

% of Retail

Indicates that the markup is calculated as a percentage of the Retail value.

Profit Calculation Type:


Direct Cost

Indicates that the profit is calculated by direct cost.

Retail Inventory

Indicates that the profit is calculated by retail inventory.

Open To Buy (OTB) Calculation Type:

Cost

Determines that the OTB is calculated by costs in this hierarchy level.

Retail

Determines that the OTB is calculated by retail value in this hierarchy level.

Purchase Order Type:


Normal Merchandise

Indicates that the items in the department are ordered, invoiced, and recorded in the stock ledger.

Consignment Stock

Indicates that the items in the department are ordered, invoiced, and recorded in the stock ledger. Accounts receivable and accounts payable are not recorded for this item type. The consignment rate is recorded at the item/supplier level.

Concession Stock

Indicates that the items in the department are ordered, invoiced, and recorded in the stock ledger. Accounts receivable and accounts payable are not recorded for this item type. The concession rate is recorded at the item/supplier level.

For Departments the Markup Calculation Type, OTB Calculation Type and Purchase Order Type are not available.

Markup % of Cost

Displays the budgeted markup as percentage of the costs.

Markup % of Retail

Displays the markup in %. When the retailer uses Simple VAT or Global Tax, this value excludes VAT.

Maximum Average Counter

Displays the maximum count of days with acceptable data to include on average for items within the hierarchy type.

Average Tolerance %

Displays a tolerance percentage value which is used as average for items within this value. This value sets a range for appropriate data and constrain outliers.


Pending Merchandise Hierarchy Toolbar

The toolbar contains the following icons and buttons.

Table 2-95 Pending Merchandise Hierarchy Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

You can access the online help for a particular page by clicking the 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.


Editing a Pending Merchandise Hierarchy

To edit the pending merchandise hierarchy, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Items > Pending Merchandise Hierarchy. The Pending Merchandise Hierarchy Search window appears.

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

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

  4. In the Action Type column, click the action link, or mark a record and select Actions > Edit, or use the Edit icon. The Pending Merchandise Hierarchy window appears.

  5. Edit the fields, 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.

Reclassification Window

Reclassification window allows you to move an item or item list from one department/class/subclass to another.

You can determine which item or item list needs to be reclassified, under which department, class, subclass, and the effective date. A batch process reclassifies those items whose effective date is the next day.

The Reclassification window contains the following sections.

Figure 2-49 Reclassifications Window

Reclassifications window

Reclassifications

The Reclassification table lists the reclassification ID, description, date as well as the pending hierarchy level information. In this table you can to add, delete, or view the reclassification events that have not been processed yet.

Reclassification - Actions Menu and Icons

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

Table 2-96 Reclassification - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

You can add new reclassifications for an item or an item list by selecting Actions > Add or by using the Add icon.

For more information about how to add a new reclassification, see the Adding a New Reclassification section.

Delete and Delete icon

You can delete a reclassification:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.

Translate and Translate icon

You can create a translation by selecting Actions > Translate or by using the Translate icon.


Reclassification - View Menu and Icons

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

Table 2-97 Reclassification - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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.

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.


Detail

The Details section lists the item ID, description and current merchandise hierarchy level information.

Detail - Actions Menu and Icons

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

Table 2-98 Reclassification - Actions Menu/Icons and Description

Actions Menu/Icons Description

Delete and Delete icon

You can delete reclassification details:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.

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.


Detail - 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 2-99 Reclassification - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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.

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.


Reclassifications Toolbar

The toolbar contains the following icons and buttons.

Table 2-100 Reclassifications Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

Save

Click Save to save your 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.


Adding a New Reclassification

To add a reclassification, follow the steps below.

  1. From Task Menu, select Foundation Data > Items > Reclassification. The Reclassification window appears.

  2. In the table, select Actions > Add, or use the Add icon. The Add Reclassification window appears.

    Figure 2-50 Add Reclassification Window

    Add Reclassification window
    1. In the Description field, enter a description for the new reclassification event.

    2. In the Reclass Date field, enter the date when the item/item list must be reclassified, or use the Calendar icon to select a date.

    3. Then select, if you want to reclassify an item or item list.

    4. Enter, select or search for the desired item or item list.

    5. Then select the new hierarchy for the item or item list. In the Department field, enter select, or search for the new department.

    6. In the Class field, enter, select or search for the new class.

    7. In the Subclass field, enter, select or search for the new subclass.

    8. Then choose one of the following options.

      • Click OK to save the new reclassification and close the window.

      • Click OK and Add Another to add additional reclassifications.

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

The Effects of Reclassifying Items

When items are moved from one department, class, and subclass combination to another, several other modules can be affected.

  • Sales history: A reclassification event does not rebuild sales history automatically. A reclassification does not affect previously recorded sales history. RMS maintains three levels of rolled up sales history: department, class, and subclass. Optional batch programs are available that can be used to rebuild the rolled up sales history.

  • Stock ledger: Stock ledger transactions are written to move the inventory amount associated with an item from the old department, class, and subclass to the new. Existing stock ledger transactions are not updated to reflect the hierarchy change.

  • Open to buy: Open to buy (OTB) records are updated for all orders that are approved, but have not yet been received.

  • Forecasts: If the reclassified item is forecastable and the new hierarchy values move the item to a new forecast domain, then an indicator is reset for the item at the item/store level. This change indicates to the program responsible for extracting sales history that the next time sales history is extracted from RMS for that item and store combination, all sales history should be extracted. Normally, only the sales history that occurred since the last data export is extracted.

Reclassification Edit Checks

The following check are preformed when you reclassify an item.

Online Edit Checks

The following edit checks are performed as you set up a reclassification event. The event cannot be created if:

  • The item exits in another reclassification event.

  • The item is a consignment department, but the new department is not a consignment. Likewise, if the item is in a department that is not a consignment department, but the new department is a consignment department.

  • One or more items on the reclassification event exist on approved partially received orders.

Batch Processing Edit Checks

Other edit checks that can cause a reclassification event to fail also occur during the batch processing of the event. A reclassification cannot occur if:

  • The item is on a Unit and Value stock count. The items to be counted have already been determined based on the department, class, and subclass specified when the stock count was created. The stock count is scheduled after the effective date of the reclassification event.

  • The item is forecastable, but the new hierarchy values with which the item is associated do not have an associated forecast domain.

  • The new department, class, and subclass contain a required user defined attribute that must be entered at the item level.

  • The new department, class, and subclass contain a user defined attribute that defaults at the item level, but the item does not have this UDA defined.

Item List Window

The Create Item List option opens the Item List window. In the Item List window you can create, edit, and view basic information about an item list.

You can indicate whether the item list is static or dynamic. The ID of the user who created the item list and the date on which it was created are displayed in this window. The number of items that make up the item list are also displayed. You can use this window for mass change or mass creation.

The Item List window contains the following sections.

Figure 2-51 Item List Window

Item List window

Item List Header

The Item List header contains the following fields.

Table 2-101 Item List Header - Fields and Description

Fields Description

Item List

The Item List field displays the generated item list ID.

Enter the item list description in the field next to the item list ID.

Comments

Enter comments for the item list, if necessary.

Static checkbox

Select the Static checkbox to indicate that the item list cannot be rebuilt.

Private checkbox

Select the checkbox to indicate that the user level security for an item list is enabled. Only the user who created the item list can select the list for transactions.

Created

Displays the user who created the list as well as the date the list was created.

Last Rebuild Date

Displays the date of the last rebuild of the item list.


Allowed Hierarchies

The Allowed Hierarchies section displays organizational and merchandising hierarchies from which the items can be part of the item list. This section is only available, if the Data Level Security is enabled.

The table displays the following columns by default.

  • Department ID and name

  • Class ID and name

  • Subclass ID and name

Allowed Hierarchies - Actions Menu and Icons

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

Table 2-102 Allowed Hierarchies - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

You can add a merchandise hierarchy for the item list by selecting Actions > Add or by using the Add icon.

For more information about how to add a merchandise hierarchy for the item list, see the Creating Item Lists section, step 7.

Delete and Delete icon

You can delete cost zone locations from a cost zone:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.


Allowed Hierarchies - View Menu and Icons

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

Table 2-103 Allowed Hierarchies - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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.


Item List Toolbar

The toolbar contains the following icons and buttons.

Table 2-104 Item List Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

Delete icon

Use the Delete icon to delete the current item list.

More Actions

Click More Actions to see a list of additional actions that can be performed in the item list window.

  • Criteria

    Opens the Item List Criteria window.

    For more information about this function, see the Item List Criteria Window section.

  • Items

    Opens the Item List Items window.

    For more information about this function, see the Item List Items Window section.

  • Rebuild

    Opens the Item List Rebuild window.

    For more information about how to rebuild item lists, see the Rebuilding Item Lists section.

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 Create Another

Click Save and Create Another to save the entered records and add additional entries.

This option is only available, if you create an item list.

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.

Done

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

Click Done to close the window.


Creating Item Lists

To create an item list, follow the steps below.

  1. From the Task menu, select Foundation Data > Items > Create Item List. The Item List window appears.

  2. The Item List field displays the generated list ID. Enter the description for the item list in the field next to the item list ID.

  3. In the Comments field, enter comments for the list, if necessary.

  4. Select the Static checkbox, as necessary.


    Note:

    If you create a static item list, you cannot rebuild the list on demand.

  5. Select the Private checkbox to indicate whether the user level security for an item list is enabled or disabled.

    If the user level security is enabled, only the person who created the item list can select the list for transactions.

  6. The Total Items field, lists the total number of items on the item list.

  7. If the Allowed Hierarchy section is enabled. Add a merchandise hierarchy to the item list, for which the list is available.


    Note:

    This section is only available, if the Data Level Security is enabled.

  8. In the Area field, enter, select or search for the organizational value for which you have access.

  9. Then select Actions > Add, or use the Add icon. The Allowed Merchandise Hierarchy window appears.

    1. In the Group Type field, select a group type from the list.

    2. In the Department field, enter, select or search for a department.

    3. In the Class field, enter, select or search for a class.

    4. In the Subclass field, enter, select or search for a subclass.

    5. Then choose one of the following options.

      • Click OK to save the hierarchy and close the window.

      • Click OK and Add Another to add additional merchandise hierarchies.

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

  10. Then add items to the list. Select More Actions > Items. The Item List Items window appears.

    For more information about how to add items to an item list, see the Adding Items to Item Lists, step 6.

  11. Add item criteria to the list, if necessary. Select More Actions > Criteria. The Item List Criteria window appears.

    For more information about how to add item list criteria, see the Adding Item List Criteria section, step 6.

  12. Then choose one of the following options.

    • Click Save and Close to save your entries and close the Item List window.

    • Click Save and Create Another to create additional item lists.

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

Rebuilding Item Lists

To rebuild a location list, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Items > Manage Item Lists. The Item List Search window appears.

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

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

  4. In the Item List column, click the item list ID link, or mark a record and select Actions > Edit, or use the Edit icon. The Item List window appears.

  5. Select More Actions > Rebuild. The Item List Rebuild window appears. The item list details are displayed.

    Figure 2-52 Item List Rebuild Window

    Item List Rebuild window
  6. Then choose one of the following options.

    • Click Execute and Close to rebuild the selected item list and close the window.

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

Item List Criteria Window

The Item List Criteria window allows you to add, delete and view the criteria by which items are grouped on an item list.

The Item List Criteria window contains the following sections.

Figure 2-53 Item List Criteria Window

Item List Criteria window

Item List Criteria Table

The Item List Criteria table displays the already defined criteria.

Item List Criteria - Actions Menu and Icons

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

Table 2-105 Item List Criteria - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

You can add new criteria to the item list by selecting Actions > Add or by using the Add icon.

For more information about how to add new criteria to the item list, see the Adding Item List Criteria section.

Delete and Delete icon

You can delete criteria from the item list:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.

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.


Item List Criteria - View Menu and Icons

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

Table 2-106 Item List Criteria - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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.


Item List Criteria Toolbar

The toolbar contains the following icons and buttons.

Table 2-107 Item List Criteria Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

More Actions

Click More Actions to see a list of additional actions that can be performed in the Warehouse window.

  • Items

    Opens the Item List Items window.

    For more information about this function, see the Adding Items to Item Lists section.

  • Rebuild

    Opens the Item List Rebuild window.

    For more information about how to rebuild item lists, the Rebuilding Item Lists section.

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.


Adding Item List Criteria

To add criteria to an item list, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Items > Manage Item Lists. The Item List Search window appears.

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

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

  4. In the Item List column, click the item list ID link, or mark a record and select Actions > Edit, or use the Edit icon. The Item List window appears.

  5. Select More Actions > Criteria. The Item List Criteria window appears.

  6. Select Actions > Add, or use the Add icon. The Add Criteria window appears.

    Figure 2-54 Add Criteria Window

    Add Criteria window
    1. Select Include/Exclude to indicate that items meeting the criteria should be included/excluded from the item list.

    2. In the Merchandise Type field, select the merchandise type from the list.

    3. In the Department, Class and Subclass field, enter, select or search for the corresponding IDs.

    4. In the Season field, enter, select or search for the season. The Phase field enables.

    5. In the Phase field, enter, select or search for the phase.

    6. In the UDA (User-defined Attributes) field, enter, select or search for the attribute.

    7. In the Supplier Site field, enter, select or search for the supplier site.

    8. In the Diff 1-4 fields, enter, select or search for the desired differentiators.

    9. Use the Calculate Item List Count icon to calculate the total of items matching the selected criteria and how many items are already part of the current item list.

    10. Then choose one of the following options.

      • Click OK to include/exclude the items with the selected criteria to/from the item list and close the window.

      • Click OK and Add Another to include/exclude additional criteria.

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

Item List Items Window

The Item List Items window allows you to maintain and view the item details for an item list. You can add or remove items individually to/from an item list. Item lists may contain any type of items. However, you cannot add items below transaction level to the item list.

The Item List Items window contains the following sections.

Figure 2-55 Item List Items Window

Item List Items window

Item List Items Table

The table displays the items of the selected item list.

Item List Items - Actions Menu and Icons

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

Table 2-108 Item List Items - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

You can add new items to an item list by selecting Actions > Add or by using the Add icon.

For more information about how to add new items to an item list, see the Adding Items to Item Lists section.

Delete and Delete icon

You can delete an item from an item list:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.

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.


Item List Items - View Menu and Icons

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

Table 2-109 Item List Items - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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.


Item List Items Toolbar

The toolbar contains the following icons and buttons.

Table 2-110 Item List Items Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

Criteria

Opens the Item List Criteria window.

For more information about this function, see the Item List Criteria Window section.

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.


Adding Items to Item Lists

To add an item to an item list, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Items > Manage Item Lists. The Item Search List window appears.

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

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

  4. In the Item List column, click the item list ID link, or mark a record and select Actions > Edit, or use the Edit icon. The Item List window appears.

  5. In the table, select More Actions > Items. The Item List Items window appears.

  6. Select Actions > Add, or use the Add icon. The Add Item window appears.

  7. Enter, select or search for the desired item.

  8. Then choose one of the following options.

    • Click OK to add the item to the list and close the window.

    • Click OK and Add Another to add additional items to the list.

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

Managing Item Lists

The Manage Item Lists option opens the Item List Search window. In the Item List Search window you can perform the following actions.

  • Search for an item list by various search criteria

  • View the entered search results

  • View an item list

  • Create an item list

  • Create an item list from an already existing item list

  • Edit an item list

You can access the Item List Search window from the Task menu, select Foundation Data > Items > Manage Item Lists. The Item List Search window appears.

The Item List Search window contains the following sections.

Figure 2-56 Item List Search Window

Item List Search window

Searching for an Item List

To search for an item list:

  1. From the Task menu, select Foundation Data > Item > Manage Item Lists. The Item List Search window appears.

  2. You can search for an item list 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.

Searching for an Item List Through the Basic Search Criteria

To search for an item list by using basic search criteria:

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

    Table 2-111 Item List Search - Basic Search Criteria and Description

    Fields Description

    Match option

    Check radio button All or Any.

    All - only item lists matching all entered search criteria are shown.

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

    Item List

    Enter the item list ID.

    Description

    Enter the item description.

    Type

    Select a type from the list.

    Created Date

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

    Created By

    Select the desired user from the list.

    Item

    Enter or search for an item.

    Item Description

    Enter the item description.


  2. Click 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 Personalized Saved Searches window appears.

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

  3. Click Search. The item lists 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 Saved Search".

  6. Click Done to close the window.

Searching for an Item List Through Advanced Search Criteria

To search for an item list by using advanced search criteria:

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

    Table 2-112 Item List Search - Advanced Search Criteria and Description

    Fields Description

    Item List

    Enter the item list ID.

    Description

    Enter the item description.

    Type

    Select a type from the list.

    Created Date

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

    Created By

    Select the desired user from the list.

    Item

    Enter or search for an item.

    Item Description

    Enter the item description.

    Division

    Enter, select or search for the division.

    Group

    Enter, select or search for the group.

    Department

    Enter, select or search for the department.

    Class

    Enter, select or search for the class.

    Subclass

    Enter select or search for the subclass.


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

  3. Click 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 Personalized Saved Searches window appears.

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

  4. Click Search. The item lists 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 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 item lists. The Results table shows the following columns by default.

  • Item List ID

  • Description

  • Type

  • Total Items

  • Created Date

  • Created By

Result - Actions Menu and Icons

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

Table 2-113 Results - Actions Menu/Icons and Description

Actions Menu/Icons Description

Create and Create icon

Select Actions > Create or use the Create icon to create a new item list.

For more details about how to create an item list, see the Creating Item Lists section.

Create from Existing and Create from Existing icon

To copy from an existing item list:

  • Select Actions > Create from Existing or use the Create from Existing icon. The Item List window appears.

  • The values of the selected item list are displayed. Change the values, as necessary.

    For more information about the available fields in the Item List window, see the Item List Window section.

Edit and Edit icon

To edit an item list:

  • In the Item List column, click the item list link, or mark a record and select Actions > Edit, or use the Edit icon. The Item List window appears.

  • The values of the selected item list are displayed. Change the values, as necessary.

    For more information about the available fields in the Item List window, see the Item List Window section.

View and View icon

To view a item list:

  • Select a record in the Results section.

  • Select Actions > View or click the View icon. The Item List window appears in View mode.

  • Click Done to close the window.

Mass Change

The Mass Change menu contains the following options:

Create

The Create menu contains the following options:

Export to Excel and 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.


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 2-114 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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


Item List Search Toolbar

The toolbar contains the following icons and buttons.

Table 2-115 Item LIst Search Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

Done

Click Done to close the window.


Changing VAT Rates

The Change VAT Rates window allows you to edit a VAT code for multiple items by item list.

  1. From the Tasks menu, select Foundation Data > Items > Manage Item Lists. The Item List Search window appears.

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

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

  4. Select a record in the table.

  5. Then select Actions > Mass Change > VAT Rates. The Change VAT Rates window appears.

    Figure 2-57 Change VAT Rates Window

    Change VAT Rates window
  6. Enter the necessary data.

The window contains the following fields.

Table 2-116 Change VAT Rates - Fields and Description

Fields Description

VAT Region

Enter, select or search for a VAT region ID.

This field is a required field.

Type

Select the desired type from the list.

This field is a required field.

Code

Enter, select or search for the desired VAT code.

This field is a required field.

Active Date

Enter an active date on which the VAT code becomes effective or use the Calendar icon to select a date.

This field is a required field.

Reverse VAT checkbox

Select the checkbox, if the reverse charge VAT is applicable for the item.

Rate %

Displays the VAT in percentage.


Change VAT Rates Toolbar

The toolbar contains the following icons and buttons.

Table 2-117 Change VAT Rates Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

Refresh icon

Use the Refresh icon to clear all fields in the window.

Save and Close

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

Save and Edit Another

Click Save and Edit Another to save the changed records and edit additional VAT rates.

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.


Changing User Defined Attributes

The Change UDAs window allows you to mass update the user defined attributes for all items in an item list.

The Change UDAs window contains the following sections.

Figure 2-58 Change UDAs Window

Change UDAs window

List of Values

This section displays the user defined values for the item list.

List of Values - Actions Menu and Icons

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

Table 2-118 List of Values - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

You can add a new value to the item list by selecting Actions > Add or by using the Add icon.

For more information about how to add new values to the item list, see the Adding User Defined Values section.

Delete and Delete icon

You can delete UDA values from an item list:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.


List of Values - View Menu and Icons

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

Table 2-119 List of Values/Dates/Free Form Text - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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.


Dates

This section contains the user defined dates for the item list.

Dates - Actions Menu and Icons

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

Table 2-120 Dates - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

You can add new dates to the item list by selecting Actions > Add or by using the Add icon.

For more information about how to add new dates to the item list, see the Adding Dates for UDAs section.

Delete and Delete icon

You can delete dates from the item list:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.


Dates - View Menu and Icons

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

For more information about the View menu, see Table 2-119, "List of Values/Dates/Free Form Text - View Menu/Icons and Description"

Free Form Text

The Free Form Text section displays the user defined text for the item list.

Free Form Text - Actions Menu and Icons

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

Table 2-121 Free Form Text - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

You can add new text to the item list by selecting Actions > Add or by using the Add icon.

For more information about how to add new texts to the item list, see the Adding Text for UDAs section.

Delete and Delete icon

You can delete text from the item list:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.

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.


Free Form Text - View Menu and Icons

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

For more information about the View Menu, see Table 2-119, "List of Values/Dates/Free Form Text - View Menu/Icons and Description".

Change UDAs Toolbar

The toolbar contains the following icons and buttons.

Table 2-122 Change UDAs Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

You can access the online help for a particular page by clicking the 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.


Adding User Defined Values

To add, change, or delete UDAs, follow the steps below

  1. From the Tasks menu, select Foundation Data > Items > Manage Item Lists. The Item List Search window appears.

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

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

  4. Select a record in the table.

  5. Then select Actions > Mass Change > User Defined Attributes. The Change UDAs window appears.

  6. In the List of Values section select Actions > Add, or use the Add icon. The Add, Change, or Delete UDA window appears.

    Figure 2-59 Add, Change, or Delete UDA Window

    Add, Change, Delete UDA window
    1. Select one of the following actions

      • Add All

        Adds the attribute to all items of the selected item list.

      • Add Where Not Exists

        Adds the attribute only to items where the attribute does not yet exist.

      • Change

        Changes the attribute for the items on the item list.

      • Delete

        Deletes the attribute from all items on the item list.

    2. In the UDA field, enter, select or search for the desired attribute.

    3. In the UDA Value field, enter, select or search for the value.

    4. Then choose one of the following options.

      • Click OK to update the attribute in the item list.

      • Click OK and Add Another to update the attribute and add additional ones.

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

Adding Dates for UDAs

To add, change or delete dates for user defined attributes, follow the steps below.

  1. In the Dates section, select Actions > Add, or use the Add icon. The Add, Change, or Delete window appears.

    1. Select one of the following actions

      • Add All

        Adds the date to all attributes.

      • Add Where Not Exists

        Adds the date only to attributes where no date yet exists.

      • Change

        Changes the dates for the selected attribute.

      • Delete

        Deletes the date from the selected attribute.

    2. In the UDA field, enter, select or search for the desired attribute.

    3. In the Date field, enter the desired date or use the Calendar icon to select a date.

    4. Then choose one of the following options.

      • Click OK to update the date in the item list.

      • Click OK and Add Another to update the date and add additional ones.

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

Adding Text for UDAs

To add, change, or delete text for user defined attributes, follow the steps below.

  1. In the Free Form Text section, select Actions > Add, or use the Add icon. The Add, Change, or Delete window appears.

    1. Select one of the following actions

      • Add All

        Adds the text to all items on the item list.

      • Add Where Not Exists

        Adds the text only to items on the item list where no text yet exists.

      • Change

        Changes the text for the items on the selected item list.

      • Delete

        Deletes the text from all items of the selected item list.

    2. In the UDA field, enter, select or search for the desired attribute.

    3. In the Text field, enter the desired text.

    4. Then choose one of the following options.

      • Click OK to update the text for the items of the list.

      • Click OK and Add Another to update the text and add additional ones.

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

Changing Seasons

The Change Seasons window allows you to change the seasons and phases for all items in an item list. You can add, change, or delete existing seasons and phases.

The Change Season window contains the following sections.

Figure 2-60 Change Seasons Window

Change Seasons window

Change Seasons Table

The table displays the actions to be performed, the existing seasons and phases to be changed or deleted as well as the new seasons and phases to be added for all items on the item list.

Change Seasons Table - Actions Menu and Icons

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

Table 2-123 Change Seasons Table - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

You can add, change, or delete seasons and phases by selecting Actions > Add or by using the Add icon.

For more information about how to maintain seasons and phases, see the Maintaining Seasons and Phases section.

Delete and Delete icon

You can delete actions:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.


Change Seasons - View Menu and Icons

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

Table 2-124 Change Seasons - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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.


Change Seasons Toolbar

The toolbar contains the following icons and buttons.

Table 2-125 Change Seasons Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

You can access the online help for a particular page by clicking the 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.


Maintaining Seasons and Phases

To maintain seasons and phases for an item list, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Items > Manage Item Lists. The Item Search window appears.

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

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

  4. Select a record in the table.

  5. Then select Actions > Mass Change > Seasons/Phases. The Change Seasons window appears.

Adding Seasons and Phases

To add a season and phase, follow the steps listed below.

  1. Select Actions > Add or use the Add icon. The Add, Change, or Delete Season/Phase window appears.

    Figure 2-61 Add, Change, or Delete Season/Phase Window

    Add, Change, Delete Season/Phase
  2. Select Add.

  3. In the Season field, enter, select or search for the season you want to add.

  4. In the Phase field, enter, select or search for the phase you want to add.

  5. Then choose one of the following options.

    • Click OK to save the changes and close the window.

    • Click OK and Add Another to maintain additional entries.

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

Changing Seasons and Phases

To change a season/phase, follow the steps below.

  1. Select Actions > Add or use the Add icon. The Add, Change, or Delete Season/Phase window appears.

  2. Select Change.

  3. Select a Season/Phase you want to change.

    1. In the Season field, enter, select or search for the season you want to change.

    2. In the Phase field, enter, select or search for the phase.

  4. Then select a new season/phase.

    1. In the Season field, enter, select or search for the season you want to change.

    2. In the Phase field, enter, select or search for the phase.

  5. Then choose one of the following options.

    • Click OK to save the changes and close the window.

    • Click OK and Add Another to maintain additional entries.

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

Deleting Seasons and Phases

To delete a season and phase, follow the steps listed below.

  1. Select Actions > Add or use the Add icon. The Add, Change, or Delete Season/Phase window appears.

  2. Select Delete.

  3. In the Season field, enter, select or search for the season you want to delete.

  4. In the Phase field, enter, select or search for the phase you want to delete.

  5. Then choose one of the following options.

    • Click OK to save the changes and close the window.

    • Click OK and Add Another to maintain additional entries.

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

Differentiator Groups Window

The Differentiator Groups window is used for maintaining differentiator groups. Differentiator groups are used to simplify associating items with multiple differentiators. Differentiator groups can also be assigned to levels of merchandise or organizational hierarchies. You can add, edit, delete or view differentiator groups in this window.

The Differentiator Groups window contains the following sections.

Figure 2-62 Differentiator Groups Window

Differentiator Groups window

Group

The Groups section displays the available differentiator groups.

Groups - Actions Menu and Icons

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

Table 2-126 Groups - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

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

For more information about how to add groups, see the Adding a New Differentiator Group section.

Delete and Delete icon

You can delete differentiator groups:

  • Select a record in the table.

  • Select Actions > Delete or use the 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.

Edit and Edit icon

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

For more information about how to edit a group, see the Editing a Differentiator Group section.

Export to Excel and 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.

Translate and Translate icon

You can create a translation by selecting Actions > Translate or by using the Translate icon.


Groups - View Menu and Icons

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

Table 2-127 Groups/Group 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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.


Group Details

In the Group Details section you can maintain the differentiators that are members of the group and specify their listing order.

Group 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 2-128 Group Details - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

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

For more information about how to add groups, see the Adding Group Details to Differentiator Groups section.

Delete and Delete icon

You can delete differentiator groups:

  • Select a record in the table.

  • Select Actions > Delete or use the 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.

Edit and Edit icon

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

For more information about how to edit a group, see the Editing a Differentiator Group section.

Export to Excel and 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.

Translate and Translate icon

You can create a translation by selecting Actions > Translate or by using the Translate icon.


Group Details - View Menu and Icons

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

For more information about the View Menu, see Groups/Group Details- View Menu/Icons and Description.

Differentiator Groups Toolbar

The toolbar contains the following icons and buttons.

Table 2-129 Differentiator Groups Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

You can access the online help for a particular page by clicking the 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.


Adding a New Differentiator Group

To add a new differentiator group, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Items > Differentiator > Groups. The Differentiator Groups window appears.

  2. In the Groups section, select Actions > Add, or use the Add icon. The Add Group window appears.

    Figure 2-63 Add Group Window

    Add Group window
    1. In the Group field, enter the group name. This is a required field.

    2. In the Group Description field, enter a more detailed description for the group. This is a required field.

    3. In the Type field, enter, select or search for a type ID. This field is a required field.

    4. In the Area field, enter, select or search for an area.

    5. In the Division field, enter, select or search for a division.

    6. Then choose one of the following options.

      • Click OK to add the group and close the window.

      • Click OK and Add Another to add additional groups.

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

Adding Group Details to Differentiator Groups

To add details to differentiator groups, follow the steps below.

  1. In the Group Detail section, select Actions > Add, or use the Add icon. The Add Detail window appears.

  2. In the Sequence field, enter the sequence number for the group detail.


    Note:

    You can also add the sequence number for the group detail, directly in the table.

  3. In the Diff Type Description field, enter, select or search for the diff type description. This field is a required field.

  4. Then choose one of the following options.

    • Click OK to add the detail to the diff group and close the window.

    • Click OK and Add Another to add additional details to the diff group.

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

Editing a Differentiator Group

To edit a diff group, follow the steps listed below.

  1. From the Tasks menu, select Foundation Data > Items > Differentiator > Groups. The Differentiator Groups window appears.

  2. In the Groups section, select Actions > Edit, or use the Edit icon. The Edit Group window appears.

    1. In the Group Description field, change the description for the group, as necessary.

    2. In the Area field, enter, select or search for another area, if necessary.

    3. In the Division field, enter, select or search for another division, if necessary.

    4. Then choose one of the following options.

      • Click OK to edit the group and close the window.

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

Creating Differentiator Ranges

The Create Diff Range option opens the Differentiator Range window. In this window you can create, edit, delete and view ranges of differentiators.

A differentiator range is a list of differentiators that are grouped under one ID. A differentiator range can be used to apply multiple differentiators to an item with less repetition and effort than applying each differentiator ID individually.

The Differentiator Range window contains the following sections.

Figure 2-64 Differentiator Range Window

Differentiator Range window

Range

The Range section contains the following fields.

Table 2-130 Range - Fields and Description

Fields Description

Range

Enter a range.

Translate and Translate icon

You can create a translation by using the Translate icon.

Range Type

Select a range type from the list.

Type 1 - 3

Enter, select or search for a type. You can add up to 3 diff types.

Group

Enter, select or search for groups for diff types 1-3.


Detail

In the Detail section you can add, edit, delete and view diffs of the diff range.


Note:

If you create a new diff range, press Add Details to open this section.

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 2-131 Details - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

You can add new diffs to a diff range by selecting Actions > Add or by using the Add icon.

For more information about how to add diffs to a diff range, see the Adding Diff Group Details section.

Edit and Edit icon

Select Actions > Edit or use the Edit icon to edit the selected diff of a diff range.

For more information about how to edit a diff, see the Editing Diff Group Details section.

Delete and Delete icon

You can delete details for diffs from a diff range:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.


Details - View Menu and Icons

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

Table 2-132 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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.


Differentiator Range Toolbar

The toolbar contains the following icons and buttons.

Table 2-133 Differentiator Range Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

Delete icon

Use the Delete icon to delete the current differentiator range.

Refresh icon

Use the Refresh icon to clear the window.

This icon is only available in Edit mode, when entered through the Manage Range option.

Like Range button

Opens the Like Range Selection window, to create a diff range from an existing range.

  • In the Range field, enter, select or search for the diff range you want to copy from.

  • Click OK. The settings of the selected diff range are applied to the current diff range.

This button is only available, if you create a differentiator range.

Add Details button

Opens the Detail section, to enter the details for the diff range.

For more information about this section, see the Detail section.

This button is only available, if you create a differentiator range.

Save and Close

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

Save

Click Save to save the entered record.

Save and Create Another

Click Save and Create Another to save the entered records and add additional entries.

This option is only available, if you create a differentiator range.

Save and Edit Another

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

This option is only available, in edit mode, when entered through the Manage Range window.

Cancel

Click Cancel to reject all entries and close the window.


Creating a Differentiator Range

To create a diff range, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Items > Differentiators > Create Diff Range. The Differentiator Range window appears.

  2. In the Range Field, enter a range ID and description of the diff range.

  3. In the Range Type field, select a type from the list.


    Note:

    After you have entered the diff range ID, description and type, the Like Range button enables. Use the button to create a diff range from an existing one.

  4. In the Type fields, enter, select or search for the desired diff types you want to include in the range.

  5. In the Group fields, enter, select or search for the desired diff groups you want to include in the range.


    Note:

    Repeat steps 4 - 5 for up to three diff type/group combinations.

    To include diffs in the diff range, see the Adding Diff Group Details section.


  6. Then select one of the following options.

    • Click Save and Close to save the current diff range and close the window.

    • Click Save to save the current diff range.

    • Click Save and Create Another to save the current entry and create additional diff ranges.

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

Adding Diff Group Details

To add a diff to a diff range, follow the steps below.

  1. In the Differentiator Range window, click Add Details to enable the Detail section.

  2. Then select Actions > Add, or use the Add icon. The Add Detail window appears.

    1. In the Differentiator Group field, enter, select or search for a new diff you want to add to the diff range.

    2. In the Ratio/Percentage field, enter the rate/percentage for the selected diff.

    3. Then choose one of the following options.

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

      • Click OK and Add Another to add the current diff and add additional diffs.

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

Editing Diff Group Details

To edit a diff of a diff range, follow the steps below.

  1. In the Differentiator Range window, open the Detail section.

  2. Then select Actions > Edit or use the Edit icon. The Edit Detail window appears.

    1. In the Differentiator Group field(s), enter, select or search for a another diff.

    2. In the Ratio/Percentage field, enter the rate/percentage for the selected diff.

    3. Then choose one of the following options.

      • Click OK to save the changes and close the window.

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

Managing Differentiator Ranges

The Manage Diff Ranges option opens the Manage Range window. In this window you can delete a diff range or add, edit, delete or view diff range details.

To manage a diff range, follow the steps below.

For more information about the available fields and functions in this window, see the Creating Differentiator Ranges section.

  1. From the Tasks menu, select Foundation Data > Items > Differentiators > Manage Diff Ranges. The Manage Range window appears.

  2. In the Range Field, enter, select or search for the diff range ID you want to edit. The diff range description and range type as well as the diff types and groups are displayed.

  3. Change the diff range description, if necessary.

  4. In the Details section, add, edit or delete diff range details, as necessary.


  5. Note:

    To include diffs in the diff range, see the Adding Diff Group Details section.

    To edit diffs of a diff range, see the Editing Diff Group Details section.


  6. Then select one of the following options.

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

    • Click Save to save your changes.

    • Click Save and Edit Another to save the current change and edit additional diff ranges.

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

Differentiator Ratio Window

In the Differentiator Ratio window you can create, edit, or view a differentiator ratio. The differentiator ratio is based on the sales history for an item in the department, class, and subclass. You can select the type of sales (regular, promotional, or clearance) and the time period to include in the calculation of the differentiator ratio in this window. The ratio is calculated by a batch program.

Figure 2-65 Differentiator Ratio Window

Differentiator Ratio window

The Differentiator Ratio window contains the following fields.

Table 2-134 Differentiator Ratio - Fields and Description

Fields Description

Ratio

The ratio ID is generated automatically.

Enter a description for the ratio.

This field is a required field.

Translate icon

You can create a translation by using the Translate icon.

Generated By

Select manual if the diff ratio is calculated manually or system if through a batch program.

If you select Manual, the Like Ratio button is enabled and all the other fields are disabled.

Like Ratio button

Opens the Like Ratio Selection window, to create a diff ratio from an existing ratio.

This button is only available, if you create a differentiator ratio.

Department

Enter, select or search for the department.

This field is a required field.

Class

Enter, select or search for the class.

This field is a required field.

Subclass

Enter, select or search for the subclass.

Group 1 - 3

Enter, select or search for the groups.

Sales Type to Use:

Select the sales type you want to use for the diff ratio.

Regular

Indicates that you want to use regular sales.

Promotional

Indicates that you want to use promotional sales.

Clearance

Indicates that you want to use clearance sales.

Build Time Period:

Select the time period for the diff ratio.

Period Type

Displays the type of period to take the sales history for.

Select the period type from the list.

From

Displays the starting date for the sales history to be used.

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

Back To

Displays the weeks back of sales history to be used.

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

Review Every

Enter the number of weeks.

Last Review Date

Displays the last review date.


Differentiator Ratio Toolbar

The toolbar contains the following icons and buttons.

Table 2-135 Differentiator Ratio Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

Refresh icon

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

Details button

Opens the Differentiator Detail window.

For more information about this function, see the Differentiator Ratio Detail Window section

Save and Close

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

Save and Create Another

Click Save and Create Another to save the entered records and add additional entries.

This option is only available, if you create a new diff ratio.

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.

Done

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

Click Done to close the window.


Creating a Differentiator Ratio

To create a diff ratio, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Items > Differentiators > Create Diff Ratio. The Differentiator Ratio window appears.

  2. In the Ratio field, enter the description of the diff ratio.

  3. In the Generated By area, select System or Manual.

  4. If you select System:

    1. Enter, select or search for the department, class, and subclass.

    2. Enter, select or search for up to three diff groups to be associated with this ratio.

    3. In the Sales Type area, select the types of sales you want to include in the ratio.

    4. In Build Time Period area, select the type of time period. Then enter the dates.

    5. In the Review Every Week(s) field, enter how often the ratio should be reviewed.

  5. If you select Manual:

    1. The Like Ratio button enables, all other fields are disabled.

    2. Select the Like Ratio button. The Select Like Ratio window appears.

    3. In the Ratio field, enter, select or search for the diff ratio you want to copy from.

    4. Then choose:

      • Click OK. The settings of the selected diff ratio are applied to the current diff ratio.

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

Editing a Differentiator Ratio

To edit a diff ratio, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Items > Differentiators > Manage Diff Ratios. The Differentiator Ratio window appears.

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

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

  4. In the Ratio column, click the ratio link, or mark a record and select Actions > Edit, or use the Edit icon. The Differentiator Ratio window appears.

  5. Edit the fields, as necessary.

Differentiator Ratio Detail Window

In the Differentiator Ratio Detail window you can edit and view the results of a differentiator ratio that has been calculated by a batch program. In edit mode, if you select a store that is not yet associated with the current diff ratio, you can base the store's ratios on those for another store. After you select a store or all stores, you can edit the quantity for each diff or diff combination.

The Differentiator Ratio Detail window contains the following sections.

Diff Ratio Detail Table

The table contains the diff IDs and description as well as the quantity.

Diff Ratio Detail Table - Actions Menu and Icons

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

Table 2-136 Diff Ratio Detail Table - Actions Menu/Icons and Description

Actions Menu/Icons Description

Export to Excel and 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.


Diff Ratio Detail Table - View Menu and Icons

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

Table 2-137 Diff Ratio Detail Table - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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.


Diff Ratio Detail Toolbar

The toolbar contains the following icons and buttons.

Table 2-138 Diff Ratio Detail Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

Refresh icon

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

Recalculate icon

Use the Recalculate icon to update the ratios in the Diff Ratio column.

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 changed records and edit additional entries.

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.


Editing Diff Ratio Details

To edit diff ratio details, follow the steps below.

  1. Edit the description, sales types, and review number as necessary.

  2. Click Detail. The Differentiator Ratio Detail window appears.

  3. In the Level field, select if you want to edit the diffs at all stores, or at a specific store. Then enter, select or search for the store ID.

  4. Click Search.

  5. If you select a store that is not yet associated with the diff ratio, you are prompted to add the store using another store as template.

  6. Select Yes to confirm the prompt. The Create Like Store window appears.

  7. In the Store field, enter, select or search for the store.

  8. Then choose one of the following options.

    • Click OK to copy the details and close the window.

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

  9. Edit the quantity of each diff as necessary in the table.

  10. Click the Recalculate icon to update the ratios in the Ratio column.

  11. 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 Save and Edit Another to edit additional diff ratios.

Managing Differentiator Ratios

The Manage Diff Ratios option opens the Differentiator Ratio Search window. In this window you can perform the following actions.

  • Search for diff ratios by various search criteria

  • View the search results

  • View a diff ratio

  • Create a diff ratio

  • Edit diff ratio

You can access the Differentiator Ratio Search window from the Task menu, select Foundation Data > Items > Differentiators > Manage Diff Ratios. The Differentiator Ratio Search window appears.

The Differentiator Ratio Search window contains the following sections.

Figure 2-66 Differentiator Ratio Search Window

Differentiator Ratio Search window

Searching for a Diff Ratio

To search for a diff ratio:

  1. From the Task menu, select Foundation Data > Items > Differentiators > Manage Diff Ratios. The Differentiator Ratio Search window appears.

  2. You can search for a diff ratio 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 basic mode.

Searching for a Diff Ratio Through the Basic Search Criteria

To search for a diff ratio by using basic search criteria:

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

    Table 2-139 Diff Ratio Search - Basic Search Criteria and Description

    Fields Description

    Match option

    Check radio button All or Any.

    All - only diff ratios matching all entered search criteria are shown.

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

    Ratio

    Enter the ratio ID.

    Description

    Enter the ratio description.

    Last Review Date

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

    Department

    Enter, select or search for the department.

    Class

    Enter, select or search for the class.

    Subclass

    Enter, select or search for the subclass.


  2. Click 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 Personalized Saved Searches window appears.

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

  3. Click Search. The diff ratios 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 Saved Search".

  6. Click Done to close the window.

Searching for Diff Ratios Through Advanced Search Criteria

To search for a diff ratio by using advanced search criteria:

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

    Table 2-140 Diff Ratio Search - Advanced Search Criteria and Description

    Fields Description

    Match option

    Check radio button All or Any.

    All - only diff ratios matching all entered search criteria are shown.

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

    Ratio

    Enter the ratio ID.

    Description

    Enter the ratio description.

    Last Review Date

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

    Department

    Enter, select or search for the department.

    Class

    Enter, select or search for the class.

    Subclass

    Enter, select or search for the subclass.

    Division

    Enter, select or search for the division.

    Group

    Enter, select or search for the group.


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

  3. Click 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 Personalized Saved Searches window appears.

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

  4. Click Search. The diff ratios 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 the Personalized Saved Search, see the Common User Interface Controls chapter, section "Personalize 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 window.

  9. Click Done to close the window.

Results

The Results section lists the retrieved diff ratios. The Results table shows the following columns by default.

  • Ratio

  • Description

  • Department and Department Name

  • Class and Class Name

  • Subclass and Subclass Name

  • Last Review Date

Result - Actions Menu and Icons

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

Table 2-141 Results - Actions Menu/Icons and Description

Actions Menu/Icons Description

Create and Create icon

Select Actions > Create or use the Create icon to create a new diff ratio. The Differentiator Ratio window appears.

For more details about how to create a new diff ratio, see the Creating a Differentiator Ratio section.

Edit and Edit icon

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

For more information about how to edit a diff ratio, see the Editing a Differentiator Ratio section.

View and View icon

To view a diff ratio:

  • Select a record in the Results section.

  • Select Actions > View or click the View icon. The Differentiator Ratio window appears.

  • Click Done to close the window.

Export to Excel and 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.


Results - View Menu and Icons

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

Table 2-142 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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


Diff Ratio Search Toolbar

The toolbar contains the following icons and buttons.

Table 2-143 Diff Ratio Search Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

Done

Click Done to close window.


Supplier Management

The supplier management feature allows you to add, edit, and view the following information about suppliers:

  • Multiple contact persons and addresses: You can enter multiple addresses of different types, such as business, invoice, order, postal, remittance, and returned goods.

  • Financial arrangements: You can indicate the payment terms, freight terms, currency, settlement code, and payment method.

  • Inventory management parameters: You can set up a replenishment cycle, order attributes, scaling attributes and constraints, order minimum constraints, and due order processing. You can also indicate whether quality control checking is required and what percentage of the received goods must be checked.

  • Return to vendor (RTV) requirements: You can indicate whether returns are allowed, whether an authorization number is required, the minimum value of a return, the preferred courier, and the handling charge.

  • Required documents: You can select which documents, if any, are required by the supplier.

  • Expense profiles: You can enter the supplier's costs by country or by cost zone.

  • Types of electronic data interchange (EDI) transactions: You can indicate which EDI transactions the supplier can process.

  • Generic attributes: You can indicate which attributes apply to the supplier, such as co-op agreement terms, volume rebate terms, whether a PO is required, or whether items are pre-ticketed.

  • Import attributes: You can enter import-related information such as agent, advising and issuing banks, lading and discharge ports, manufacturer ID, and beneficiary.

  • Invoice matching attributes: You can indicate when debit memos are sent, whether invoices and debit memos are approved automatically, whether the supplier is allowed to charge freight, and whether invoices are pre-paid. (Oracle Retail Invoice Matching must be installed.)

  • Supplier traits: You can select the traits by which you want to group the supplier with other suppliers.

  • Payment types by store: You can select the methods by which the supplier can be paid, such as cash, money order, and by invoice. You can also indicate the payment type by store.

  • Delivery schedules at stores and warehouses: After you create a delivery schedule, you can specify which items are not to be delivered to the location on a specific delivery day.

  • Vendor managed inventory (VMI): Use VMI to allow a supplier to manage the inventory levels of designated product at the warehouse. Inventory data is shared with the supplier, who uses the information to create inbound purchase orders, which will achieve and/or maintain budgeted inventory and service levels in the warehouse.

Supplier/Supplier Site Window

The Supplier/Supplier Site window allows you to create, edit, and view suppliers and supplier sites. Suppliers are vendors that provide your stores and warehouses with merchandise.

Depending on how you enter the window, the label varies.

  • If you enter the window for a parent supplier, the window is labeled Supplier. For more information about how to create a supplier, see the Creating a Supplier section.

  • If you enter the window for another supplier site of a supplier, the window is labeled Supplier Site. For more information about how to create a supplier site, see the Creating a Supplier/Supplier Site section.

You can indicate whether the supplier/supplier site is active or inactive. You can also enter the primary contact, financial, shipping, and payment information.

The Supplier window contains the following sections.

Figure 2-67 Supplier Window

Supplier window

Header

The header contains the following fields.

Table 2-144 Header - Fields and Description

Fields Description

Supplier

The supplier ID is generated automatically.

Enter the supplier name.

This field is a required field.

Payment Terms

Enter, select or search for the supplier's payment terms.

This field is a required field.

Freight Terms

Enter, select or search for the supplier's freight terms.

This field is a required field.

VAT Region

Enter, select or search for the supplier's VAT region.

This field is a required field.

Status

Select, if the current supplier is an active or inactive supplier.

This field is a required field.

Secondary Name

Enter the secondary name for the supplier.

Currency

Enter, select or search for the supplier's currency.

This field is a required field.

Language

Select the supplier's language from the list.


Contact Information

In the Contact Information section enter the name, phone number, email address, fax, telex and pager for the primary contact person at the supplier's location.

Name and Phone are required fields.

Comments

In the Comments section you can enter any comments relevant for the supplier.

Ordering

The Ordering section contains the following fields and checkboxes.

Table 2-145 Ordering - Fields/Checkboxes and Description

Fields/Checkboxes Description

Inventory Management Level

Select an inventory management level from the list.

This field is a required field.

Ship Method

Select a shipping method for the supplier from the list.

Lead Time

Enter the amount of time a supplier needs between receiving an order and having the order ready to ship.

This value will be defaulted to item/supplier relationships.

Delivery Policy

Select a delivery policy from the list.

This field is a required field.

Quantity Level

Select a quantity level from the list to indicate purchase order quantities that are communicated to the supplier in multiples of units (eaches) or cases.

This field is a required field.

DSD checkbox

Select the checkbox to indicate that the supplier can provide direct store deliveries.

Premark checkbox

Select the checkbox to indicate that the supplier will break orders into separate, marked boxes that can be shipped directly to stores.

Bracket Costing checkbox

Select the checkbox to indicate that the supplier uses bracket costing in its pricing.

Back Orders checkbox

Select the checkbox to indicate the supplier accepts back orders.

EDI:


Orders checkbox

Select the checkbox to indicate that the orders are transmitted electronically.

Order Changes checkbox

Select the checkbox to indicate that order changes are transmitted electronically.

Order Acknowledgments checkbox

Select the checkbox to indicate that order acknowledgments are transmitted electronically.


Contracts and Replenishment

The Contracts and Replenishment section contains the following fields and checkboxes.

Table 2-146 Contracts and Replenishment - Fields/Checkboxes and Description

Fields/Checkboxes Description

Scale AIP Orders checkbox

Select the checkbox to indicate that AIP (Advanced Inventory Planning) is allowed to do order scaling.

Order scaling refers to the increase and decrease of the order quantity within constraints to meet purchasing objectives and increase efficiency.

VMI Order Status

Select the VMI order status from the list.

VMI Channel

Enter, select or search for the VMI channel.

EDI Availability checkbox

Select the checkbox to indicate that the supplier processes orders through EDI (Electronic Data Interchange).

EDI Contracts checkbox

Select the checkbox to indicate that the supplier process contracts through EDI.

Auto Contract Approval checkbox

Select the checkbox to indicate that contract orders are created in Approved status.


Receiving

The Receiving section contains the following fields and checkboxes.

Table 2-147 Receiving - Fields/Checkboxes and Description

Fields/Checkboxes Description

QC Required checkbox

Select the checkbox to indicate that goods received from the supplier must be inspected for quality.

QC %

Enter what percentage of the goods must be inspected.

QC Frequency

Enter how often the items will be inspected.

EDI ASN checkbox

Select the checkbox to indicate that the advanced shipping notice (ASN) is transmitted electronically.

Vendor Control Required checkbox

Select the checkbox to indicate that orders from this supplier require vendor control by default.

Vendor Control %

Displays the percentage of items per receipt that are marked for vendor checking.

Vendor Control Frequency

Displays the frequency in which items per receipt are marked for vendor checking.


Invoicing

This section contains the following fields and checkboxes.

Table 2-148 Invoicing - Fields/Checkboxes and Description

Fields/Ceckboxes Description

Settlement Code

Select the settlement code from the list.

This field is a required field.

Payment Method

Select the payment method from the list.

Send Debit Memos

Select how often debit memos should be sent to the supplier.

Receive Invoice

Select where invoices from this supplier are received, either at the store or centrally through corporate accounting.

This field is only enabled, if invoice matching is used.

Pay Invoice

Indicates where invoices from this supplier are paid, either at the store or centrally through corporate accounting. Valid values are S (paid at the store) and C (paid centrally).

This field only displays Store, if ReSA is used to accept payment at the store level. Additionally, the field is only enabled, if invoice matching is used.

Invoice at

Select, if invoice amounts are net or gross values.

Final Match Destination checkbox

Select this checkbox to indicate that the supplier can ship to the final destination as per allocation.

EDI Invoice checkbox

Select the checkbox to indicate that the invoices are transmitted electronically.

Auto-approve Invoices checkbox

Select this checkbox to indicate that the supplier's invoice matches can be automatically approved for payment.

This field is only enabled, if invoice matching is used.

Auto-approve Debit Memos checkbox

Select this checkbox to indicate that debit memos sent to the supplier can be automatically approved on creation.

This field is only enabled, if invoice matching is used.

Allow Supplier to Charge-Freight checkbox

Select this checkbox to indicate that the supplier is allowed to charge freight costs to the client.

This field is only enabled, if invoice matching is used.

Invoices Pre-paid for Supplier checkbox

Select this checkbox to indicate that all invoices for the supplier can be considered pre-paid invoices.

This field is only enabled, if invoice matching is used.

Services Performed Confirmation Required checkbox

Select this checkbox to indicate that all suppliers services, for example shelf stocking, must be confirmed before the invocie can be paid.


Returns

The Returns section contains the following fields and checkboxes.

Table 2-149 Returns - Fields/Checkboxes and Description

Fields/Checkboxes Description

Returns Allowed checkbox

Select the checkbox to indicate that this supplier allows returns.

Authorization Required checkbox

Select the checkbox to indicate that returns must be accompanied by an authorization number when sent back to the vendor.

Maximum Return Amount

Enter the maximum amount allowed for returns.

Courier

Enter the courier for the returns.

Handling %

Enter the handling percentage.


Other Attributes

The Other Attributes section contains the following fields

Table 2-150 Other Attributes - Fields and Description

Fields Description

DUNS Number

Enter the appropriate Dun and Bradstreet codes to identify the supplier.

DUNS Location Number

Enter the appropriate Dun and Bradstreet codes to identify the supplier location.

EDI Sales

Select the EDI Sales from the list.

External Ref. ID

Displays the external reference ID, if available.

Cost Change Variance:


Amount

This field displays the cost change variance as amount.

Percent

This field displays the cost change variance in percent.


Importers/Exporters

In the Importers/Exporters section you can add, edit, delete and view importers/exporters that the supplier uses. This section is only available for supplier sites.

Importers/Exporters - Actions Menu and Icons

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

Table 2-151 Importers/Exporters - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

You can add new importers/exporters for the supplier by selecting Actions > Add or by using the Add icon.

For more information about how to add new importers/exporters, see the Adding Importers/Exporters section.

Delete and Delete icon

You can delete importers/exporters:

  • Select a record in the table.

  • Select Actions > Delete or use the 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.

Edit and Edit icon

Select Actions > Edit or use the Edit icon to edit the selected importer/exporter.

For more information about how to edit an importer/exporter, see the Editing Importers/Exporters section.

Export to Excel and 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.


Importers/Exporters - View Menu and Icons

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

Table 2-152 Importers/Exporters/Routing Locations - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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.


Routing Locations

In the Routing Locations section you can add, edit, delete and view routing locations for the supplier. This section is only available for supplier sites.

Routing Locations - Actions Menu and Icons

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

Table 2-153 Routing Locations - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

You can add new routing locations for the supplier by selecting Actions > Add or by using the Add icon.

For more information about how to add new routing locations, see the Adding Routing Locations section.

Delete and Delete icon

You can delete routing locations:

  • Select a record in the table.

  • Select Actions > Delete or use the 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.

Edit and Edit icon

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

For more information about how to edit a routing location, see the Editing Routing Locations section.

Export to Excel and 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.


Routing Locations - View Menu and Icons

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

For more information about the View Menu and icons, see Importers/Exporters/Routing Locations - View Menu/Icons and Description

Supplier/Supplier Site Toolbar

The toolbar contains the following icons and buttons.

Table 2-154 Supplier Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

Refresh icon

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

Expand and Collapse icons

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

Translate and Translate icon

You can create a translation by selecting Actions > Translate or by using the Translate icon.

More Actions

Click More Actions to see a list of additional actions that can be performed in the Supplier/Supplier Site window.

For more information about the More Actions menu, see the Supplier/Supplier Site - More Actions Menu section.

Save and Close

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

Save and Create Another

Click Save and Create Another to save the entered records and add additional entries.

This option is only available, if you create a new supplier/supplier site.

Save and Edit Another

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

This option is only available, in edit mode.

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.


Supplier/Supplier Site - More Actions Menu

Use the More Actions menu to navigate to the following windows. The More Actions menu contains the following options.

Table 2-155 More Actions Menu - Buttons and Description

Action Buttons Description

More Actions

You can navigate to the following windows by using the More Actions menu.


  • Address

    Opens the Addresses window.

    For more information about this function, see the Addresses Window section.

The menu options below are only available for supplier sites.


  • Inventory Management

    Opens the Supplier Inventory Management window.

    For more information about this function see, the Supplier Inventory Management section.


  • Org Unit

    Opens the Supplier Org Unit window.

    For more information about this function see, the Supplier Org Unit section.


  • Supplier Traits

    Opens the Supplier Traits window.

    For more information about this function see, the Supplier Traits section.


  • Documents

    Opens the Required Documents window.

    For more information about this function see, the Orders chapter, section "Required Documents".


  • Import Attributes

    Opens the Supplier Import Attributes window.

    For more information, see the Supplier Import Attributes section.


  • Expenses

    Opens the Expense Profile window.

    For more information about this function see, the Expense Profiles section.



Creating a Supplier

To create a supplier, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Suppliers and Partners > Create Supplier. The Supplier window appears.

  2. The supplier ID is generated automatically. Enter the necessary information in the individual sections.

    For more information about the available sections of the Supplier window, see the Supplier/Supplier Site Window section.

  3. Then choose one of the following options.

    • Click Save to save the supplier.

    • Click Save and Close to save the supplier and close the window.

    • Click Save and Create Another to save the current supplier and create additional supplier entries.

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


    Note:

    You can also create a supplier in the Supplier Search screen, for more information about this function, see the Creating a Supplier/Supplier Site section.

Adding Importers/Exporters

To add importers/exporters to a supplier site, follow the steps below.

  1. In the Importers/Exporters section, select Actions > Add or use the Add icon. The Add Importer/Exporter window appears.

  2. In the Type field, select if you want to add an importer or exporter. This field is a required field.

  3. In the Importer/Exporter field, enter, select or search for the importer/exporter ID and description. This field is a required field.

  4. Select the Default checkbox to indicate that the current importer/exporter is the supplier's default importer/exporter.

  5. Then choose one of the following options.

    • Click OK to add the importer/exporter and close the window.

    • Click OK and Add Another to add additional importers/exporters.

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

Editing Importers/Exporters

To edit importers/exporters for a supplier site, follow the steps below.

  1. In the Importers/Exporters section, select Actions > Edit or use the Edit icon. The Edit Importer/Exporter window appears.

  2. Change the Type and Importer/Exporter field as well as the Default checkbox, as necessary.

  3. Then choose one of the following options.

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

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

Adding Routing Locations

To add routing locations to a supplier site, follow the steps below.

  1. In the Routing Locations section, select Actions > Add or use the Add icon. The Add Routing Locations window appears.

  2. In the Routing Location field, enter, select or search for the location ID. This field is a required field.

  3. Select the Default checkbox to indicate that the current routing location is the supplier's default routing location.

  4. Then choose one of the following options.

    • Click OK to add the routing location and close the window.

    • Click OK and Add Another to add additional routing locations.

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

Editing Routing Locations

To edit routing locations for a supplier site, follow the steps below.

  1. In the Routing Locations section, select Actions > Edit or use the Edit icon. The Edit Routing Locations window appears.

  2. Change the Routing Location field and Default checkbox, as necessary.

  3. Then choose one of the following options.

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

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

Supplier Import Attributes

The Supplier Import Attributes window allows you to enter import information about a particular supplier. You can track information specific to the supplier, such as:

  • Agent

  • Factory

  • Advising bank

  • Issuing bank

  • Lading port

  • Discharge port

  • Manufacturer ID

  • Additional partner information

  • Beneficiary information

The Supplier Import Attributes window contains the following sections.

Figure 2-68 Supplier Import Attributes Window

Supplier Import Attributes window

Import Attributes

The Import Attributes section contains the following fields.

Table 2-156 Import Attributes - Fields and Description

Fields Description

Agent

Enter, select or search for the agent ID.

Factory

Enter, select or search for the factory ID.

Advising Bank

Enter, select or search for the ID of the advising bank.

Issuing Bank

Enter, select or search for the ID of the issuing bank.

Lading Port

Enter, select or search for the ID of the lading port.

Discharge Port

Enter, select or search for the ID if the discharge port.

Manufacturer

Enter the manufacturer.

Supplier Related to Manufacturer checkbox

Select the checkbox to indicate that the supplier is related to the manufacturer.

Partner

Select a partner type from the list. In the field next to the partner type, enter, select or search for the partner ID.

You can add up to three partners in this window.


Beneficiary Attributes

The Beneficiary Attributes section contains the following fields.

Table 2-157 Beneficiary Attributes - Fields and Description

Fields Description

Beneficiary checkbox

Select the checkbox to indicate that the supplier can be a beneficiary in a Letter of Credit transaction.

With Recourse checkbox

Select the checkbox to indicate that the paying bank will be able to claim refunds from the beneficiary in case the letter of credit documents are not paid by the issuing bank.

Revocable checkbox

Select the checkbox to indicate that the Letter of Credit is revocable.

If the LC is revocable, it can be amended or cancelled by the buyer or buyers bank at any time.

If the LC is not revocable, the buyer as well as seller must approve any changes.

Place of Expiry

Enter, select or search for the place of expiry.

Drafts At

Select the drafts at entry from the list.

Payment Terms

Select the appropriate payment terms from the list.

Variance Percent

Enter the variance in percent.

LC Negotiation Days

Enter the negotiating days for the LC.


Supplier Import Attributes Toolbar

The toolbar contains the following icons and buttons.

Table 2-158 Supplier Import Attributes Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

You can access the online help for a particular page by clicking the 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.


Supplier Inventory Management

The Supplier Inventory Management window allows you to create, maintain, delete and view inventory management information for a supplier site, or for a department and supplier site.

The Supplier Inventory Management window contains the following sections.

Figure 2-69 Supplier Inventory Management Window

Supplier Inventory Management window

Replenishment

The Replenishment section contains the following fields.

Table 2-159 Replenishment - Fields and Description

Fields Description

Order Control

Select how the POs are processed for the supplier from the list.

Review Cycle

Select how often the items are reviewed for replenishment from the list.

Weekdays checkboxes

Select the day on which the items are reviewed.

  • If the review cycle is every day, all days of the week are selected automatically.

  • If the review cycle is every week, select the days of the week the items are reviewed for replenishment. You may select more than one day.

  • If the review cycle is over two or more weeks, select the day of the week.

Single Loc on Order checkbox

Select the checkbox, if only one location can be on an order.


Due Order Processing

The Due Order Processing section contains the following fields.

Table 2-160 Due Order Processing - Fields and Description

Fields Description

Due Order Processing checkbox

Select the checkbox to have due order processing performed for replenishment items from the supplier.

Create Non-Due Orders checkbox

Select the checkbox to have purchase orders created in Worksheet status for items that are not due to be ordered.

Due Order Level

Select the level at which the due order processing is based from the list.

Service Basis

Select the parameter that is used in calculating the stock out level from the list


Investment Buy

The Investment Buy section contains the following fields.

Table 2-161 Investment Buy - Fields and Description

Fields Description

Investment Buy Eligibility

Select the checkbox to enable investment buy attributes.

Order Control

Select how POs are processed for the investment buy orders.


Scaling

The Scaling section contains the following fields.

Table 2-162 Scaling - Fields and Description

Fields Description

Scale Orders to Constraints checkbox

Select the checkbox to enable the scaling constraints area.

Multiple Vehicles checkbox

Select the checkbox to indicate that multiple vehicles may be used when delivering the order.

Scaling Objective

Select whether purchase orders are scaled to the minimum or maximum values of the scaling constraints.

Scaling Level

Select the level at which the scaling is performed.

Primary:

In the Scaling Constraints Primary column, complete the following fields.

Type

Select the primary type of constraint to use when scaling orders.

UOM

If you select Mass or Volume as the primary type, enter, select or search for the unit of measure.

Currency

If you select Amount as the primary type, the currency code is displayed in this field.

Maximum Value

Enter the maximum value of the constraint.

Tolerance

Enter the percentage tolerance for the maximum value of constraint.

Minimum Value

Enter the minimum value of the constraint.

Tolerance

Enter the percentage tolerance for the minimum value of the constraint.

Secondary:

In the Scaling Constraints Secondary column, complete the following fields.

Type

Select the secondary type of constraint to use when scaling orders.

The secondary type cannot be the same as the primary type.

UOM

If you select Mass or Volume as the secondary type, enter, select or search for the unit of measure.

Currency

If you select Amount as the secondary type, the currency code is displayed in this field.

Maximum Value

Enter the maximum value of the constraint.

Tolerance

Enter the percentage tolerance for the maximum value of the constraint.

Minimum Value

Enter the minimum value of the constraint.

Tolerance

Enter the percentage tolerance for the minimum value of the constraint.


Rounding

The Rounding section contains the following fields.

Table 2-163 Rounding - Fields and Description

Fields Description

Rounding Level

Select the level to which quantities should be rounded.

Rounding to Inner Threshold

Enter the percent of the inner needed to round to an additional inner.

Round to Case Threshold

Enter the percent of the case needed to round to an additional case.

Round to Layer Threshold

Enter the percent of the layer needed to round to an additional level.

Round to Pallet Threshold

Enter the percent of the pallet needed to round to an additional pallet.


Supplier Minimums

The Supplier Minimums section contains the following fields.

Table 2-164 Supplier Minimums - Fields and Description

Fields Description

Purge Orders Failing Minimum checkbox

Select the checkbox to create POs that meet the supplier minimum.

Minimum Level

Select the minimum order quantity at which the supplier accepts orders.

Conjunction

When you define two minimum order requirements, select the relationship between the requirements in the Conjunction field.

Minimum 1:

In the Minimum 1 column, complete the following fields.

Type

Select the type for the first minimum order requirement.

UOM

If you select Mass or Volume as the first minimum order requirement type, enter, select or search for the unit of measure

Currency

If you select Amount as the first minimum order requirement type, the currency code is displayed in this field.

Value

Enter the value of the first minimum order requirement for the supplier.

Minimum 2:

In the Minimum 2 column, complete the following fields.

Type

Select the second type for the minimum order requirement.

UOM

If you select Mass or Volume as the first minimum order requirement type, enter, select or search for the unit of measure.

Currency

If you select Amount as the first minimum order requirement type, the currency code is displayed in this field.

Value

Enter the value of the first minimum order requirement of the supplier.


Truck Splitting

The Truck Splitting section contains the following fields.

Table 2-165 Truck Splitting - Fields and Description

Fields Description

Split Orders into Truckloads checkbox

Select the checkbox to enable the truck splitting constraints.

Auto Approve LTL Orders checkbox

Select the checkbox to allow Less than a Truckload (LTL) orders.

Truck Split Method

Select the method of truck splitting used with this supplier.

Constraint 1:

In the Constraint 1 column, complete the following fields.

Type

Select the primary type of constraint to use when splitting orders into truckloads.

UOM

If you select Mass or Volume as the primary type, enter, select or search for the unit of measure.

Value

Enter the value of the constraint.

Tolerance

Enter the percentage tolerance for the maximum value of the constraint.

Constraint 2:

In the Constraint 2 column, complete the following fields.

Type

Select the secondary type of constraint to use when splitting orders into truckloads.

The second constraint type cannot be the same as the first constraint type.

UOM

If you select Mass or Volume as the secondary type, enter, select or search for the unit of measure.

Value

Enter the value of the constraint.

Tolerance

Enter the percentage tolerance for the maximum value of the constraint.


Bracket Constraints

The Bracket Constraints section contains the following fields.

Table 2-166 Bracket Constraints - Fields and Description

Fields Description

Threshold %

Enter the percentage of the bracket value that the order must meet in order to be rounded up to that bracket.

Primary:

In the Primary column, complete the following fields.

Type

Select the type of the primary bracket costing constraint.

UOM

If you select Mass or Volume as the primary type, enter, select or search for the unit of measure.

Secondary:

In the Secondary column, complete the following fields.

Type

Select the type of secondary bracket costing constraints.

UOM

If you select Mass or Volume as the secondary type, enter, select or search for the unit of measure.


Other Attributes

The Other Attributes section contains the following fields.

Table 2-167 Other Attributes - Fields and Description

Fields Description

Pooled Supplier

Enter, select or search for the supplier ID.

Pooled Supplier Site

Enter, select or search for the supplier site ID.

Purchase Type

Select the purchase order type from the list.

Pickup Location

Only enabled, if you select pick-up as purchase type.

Enter the pickup location.


Supplier Inventory Management Toolbar

The toolbar contains the following icons and buttons.

Table 2-168 Supplier Inventory Management Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

Expand and Collapse icons

You can view all the sections and collapse all the sections in the window by clicking the Expand and Collapse icons.

Refresh icon

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

Delete icon

Use the Delete icon to delete the inventory management record of the current supplier site.

More Actions

Click More Actions to see a list of additional actions that can be performed in the Warehouse window.

  • Bracket Costing

    Opens the Supplier Brackets window.

    For more information about this function, see the Supplier Brackets section.

Save and Close

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

Save and Create Another

Click Save and Create Another to save the entered records and add additional entries.

This option is only available, if you create a new inventory management record for a supplier site.

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.

Done

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

Click Done to close the window.


Supplier Brackets

In the Supplier Brackets window, you can add, edit, delete and view primary and secondary bracket values. You can also specify default brackets, or delete the entire bracket structure.

The Supplier Brackets window contains the following sections.

  • Header

    The header displays the following information.

    • Supplier ID and name

    • Pickup checkbox

      Select the checkbox to indicate that the bracket pricing uses pickup prices.

      The pickup price is the price of the goods without shipping costs, as if the goods were picked up at the supplier's location.

    • Threshold amount in percent

  • Supplier Brackets Table

  • Supplier Brackets Toolbar

Figure 2-70 Supplier Brackets Window

Supplier Brackets window

Supplier Brackets Table

In the table you can add, edit, delete and view primary as well as secondary brackets. Additionally you can also set default bracket values.

Supplier Brackets Table - Actions Menu and Icons

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

Table 2-169 Supplier Brackets Table - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

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

For more information about how to add bracket values, see the Adding Bracket Values section.

Delete and Delete icon

You can delete bracket values:

  • Select a record in the table.

  • Select Actions > Delete or use the 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.

Edit and Edit icon

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

For more information about how to edit a bracket value, see the Editing Bracket Values section.

Export to Excel and 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.


Supplier Brackets Table - View Menu and Icons

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

Table 2-170 Supplier Brackets Table - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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.


Supplier Brackets Toolbar

The toolbar contains the following icons and buttons.

Table 2-171 Supplier Brackets Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

Delete icon

Use the Delete icon to delete the entire bracket structure.

Save and Close

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

Save and Create Another

Click Save and Create Another to save the entered records and add additional entries.

This option is only available, if you create a bracket structure for a supplier site.

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.

Done

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

Click Done to close the window.


Adding Bracket Values

To add bracket values for a supplier site, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Suppliers and Partners > Manage Suppliers. The Supplier Search window appears.

  2. Restrict your search to suppliers with enabled Bracket Costing.

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

  4. In the Supplier Site column, click the supplier site ID link, or mark a record and select Actions > Edit, or use the Edit icon. The Supplier Site window appears.

  5. Select More Actions > Inventory Management. The Supplier Inventory Management window appears.

  6. Select More Actions > Bracket Costing. The Supplier Brackets window appears.


    Note:

    The Bracket Costing checkbox must be selected in the Supplier/Supplier Site window in order to access the Supplier Brackets window.

  7. Select Actions > Add, or use the Add icon. The Add Bracket window appears.

    Figure 2-71 Add Bracket Window

    Add Bracket window
    1. In the Primary Bracket Value field, enter the lower value of the primary bracket. This field is a required field.

    2. In the Secondary Bracket Value field, enter the lower value of the secondary bracket, if applicable.

    3. Select the Default checkbox to indicate that the bracket value is a default value for this bracket structure.

    4. Select the Pickup checkbox to indicate that the bracket pricing uses pickup prices. The pickup price is the price of the goods without shipping costs, as if the goods were picked up at the supplier's location.

    5. Then select one of the following options.

      • Click OK to add the bracket value and close the window.

      • Click OK and Add Another to add additional bracket values.

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

Editing Bracket Values

To edit bracket values for a supplier site, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Suppliers and Partners > Manage Suppliers. The Supplier Search window appears.

  2. Restrict your search to suppliers with enabled Bracket Costing.

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

  4. In the Supplier Site column, click the supplier site ID link, or mark a record and select Actions > Edit, or use the Edit icon. The Supplier Site window appears.

  5. Select More Actions > Inventory Management. The Supplier Inventory Management window appears.

  6. Select More Actions > Bracket Costing. The Supplier Brackets window appears.


    Note:

    The Bracket Costing checkbox must be selected in the Supplier/Supplier Site window in order to access the Supplier Brackets window.

  7. Select a record in the table.

  8. Then select Actions > Edit, or use the Edit icon. The Edit Bracket window appears.

    1. In the Primary Bracket Value and Secondary Bracket Value field, edit the values as necessary.

    2. Select/deselect the Default checkbox to indicate that the bracket value is a default value for this bracket structure.

    3. Select/deselect the Pickup checkbox to indicate that the bracket pricing uses pickup prices.

    4. Then choose one of the following options.

      • Click OK to save your changes value and close the window.

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

Supplier Org Unit

In the Supplier Org Unit window you can add, edit, delete and view organizational unit information for the selected supplier site.

The Supplier Org Unit window contains the following sections.

Figure 2-72 Supplier Org Unit Window

Supplier Org Unit window

Supplier Org Unit Table

In the table you can add, edit, delete and view organizational units for the selected supplier site or partner.

Supplier Org Unit Table - Actions Menu and Icons

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

Table 2-172 Supplier Org Unit Table - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

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

For more information about how to add org units, see the Adding Organizational Unit Information for Suppliers section.

Delete and Delete icon

You can delete org units:

  • Select a record in the table.

  • Select Actions > Delete or use the 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.

Edit and Edit icon

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

For more information about how to edit an org unit, see the Editing Organizational Unit Information for Suppliers section.

Export to Excel and 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.


Supplier Org Unit - View Menu and Icons

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

Table 2-173 Supplier Org Unit - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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.


Supplier Org Unit Toolbar

The toolbar contains the following icons and buttons.

Table 2-174 Supplier Org Unit Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

You can access the online help for a particular page by clicking the 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.


Adding Organizational Unit Information for Suppliers

To add organizational unit information for a supplier, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Suppliers and Partners > Manage Suppliers. The Supplier Search window appears.

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

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

  4. In the Supplier Site column, click the supplier site ID link, or mark a record and select Actions > Edit, or use the Edit icon. The Supplier Site window appears.

  5. Select More Actions > Org Unit. The Supplier Org Unit window appears.

  6. Then select Actions > Add, or use the Add icon. The Add Org Unit ID window appears.

    1. In the Org Unit field, enter select or search for the appropriate unit. This field is a required field.

    2. Select the Primary Pay Site to indicate that the current org unit is the primary pay site.

    3. Then choose one of the following options.

      • Click OK to add the org unit and close the window.

      • Click OK and Add Another to add additional org units.

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

Editing Organizational Unit Information for Suppliers

To edit organizational unit information for suppliers, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Suppliers and Partners > Manage Suppliers. The Supplier Search window appears.

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

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

  4. In the Supplier Site column, click the supplier site ID link, or mark a record and select Actions > Edit, or use the Edit icon. The Supplier Site window appears.

  5. Select More Actions > Org Unit. The Supplier Org Unit window appears.

  6. Then select Actions > Edit, or use the Edit icon. The Edit Ord Unit ID window appears.

    1. In the Org Unit field, change the org unit, if necessary.

    2. Select/deselect the Primary Pay Site to indicate that the current org unit is the primary pay site.

    3. Then choose one of the following options.

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

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

Supplier Traits

The Supplier Traits window allows you to add, delete and view supplier traits. After you create supplier traits, you can then associate suppliers with a trait or associate traits with a supplier.

You can also use traits to indicate which of your suppliers have a master supplier. A master supplier is an outside source that provides merchandise to one or more of your suppliers, such as a manufacturer or distributor. You can enter an external ID for the master supplier as well.

The Supplier Traits window contains the following sections.

Supplier Traits Table

In the table you can add, delete and view supplier traits.

Supplier Traits Table - Actions Menu and Icons

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

Table 2-175 Supplier Traits Table- Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

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

For more information about how to add supplier traits, see the Adding Supplier Traits section.

Delete and Delete icon

You can delete supplier traits:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.


Supplier Traits Table - View Menu and Icons

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

Table 2-176 Supplier Traits Table - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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.


Supplier Traits Toolbar

The toolbar contains the following icons and buttons.

Table 2-177 Supplier Traits Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

You can access the online help for a particular page by clicking the 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.


Adding Supplier Traits

To add supplier traits, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Suppliers and Partners > Manage Suppliers. The Supplier Search window appears.

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

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

  4. In the Supplier Site column, click the supplier site ID link, or mark a record and select Actions > Edit, or use the Edit icon. The Supplier Site window appears.

  5. Select More Actions > Supplier Traits. The Supplier Traits window appears.

  6. Then select Actions > Add, or use the Add icon. The Add Supplier Traits window appears.

    1. In the Supplier Trait field, enter, select or search for the supplier trait you want to associate with the supplier.

    2. Select the Master Supplier checkbox to indicate that the current trait is a master supplier trait.

    3. Then choose:

      • Click OK to add the supplier trait and close the window.

      • Click OK and Add Another to add additional supplier traits.

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

Managing a Supplier

The Manage Suppliers option opens the Supplier Search window. In this window you can perform the following actions.

  • Search for suppliers by various search criteria

  • View the search results

  • View supplier information

  • Create supplier information

  • Edit supplier information

  • Edit supplier sites

  • View supplier sites

You can access the Supplier Search window from the Task menu, select Foundation Data > Suppliers and Partners > Manage Suppliers. The Supplier Search window appears.

The Supplier Search window contains the following sections.

Figure 2-73 Supplier Search Window

Supplier Search window

Searching for a Supplier

To search for a supplier:

  1. From the Task menu, select Foundation Data > Suppliers and Partners > Manage Suppliers. The Supplier Search window appears.

  2. You can search for a supplier 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 basic mode.

Searching for a Supplier Through the Basic Search Criteria

To search for a supplier by using basic search criteria:

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

    Table 2-178 Supplier Search - Basic Search Criteria and Description

    Fields Description

    Match option

    Check radio button All or Any.

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

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

    Supplier

    Enter the supplier ID.

    Supplier Name

    Enter the supplier name.

    Supplier Site

    Enter the supplier site ID.

    Supplier Site Name

    Enter the supplier site name.

    Status

    Select the status of the supplier.

    Item

    Enter, select or search for the supplier's items.

    Order

    Enter, select or search for the supplier's orders.


  2. Click 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 Personalized Saved Searches window appears.

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

  3. Click Search. The suppliers 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 Saved Search".

  6. Click Done to close the window.

Searching for a Supplier Through Advanced Search Criteria

To search for a supplier by using advanced search criteria:

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

    Table 2-179 Supplier Search - Advanced Search Criteria and Description

    Fields Description

    Match option

    Check radio button All or Any.

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

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

    Supplier

    Enter the supplier ID.

    Supplier Name

    Enter the supplier name.

    Supplier Site

    Enter the supplier site ID.

    Supplier Site Name

    Enter the supplier site name.

    Status

    Select the status of the supplier.

    Division

    Enter, select or search for the division.

    Group

    Enter, select or search for the group.

    Department

    Enter, select or search for the department.

    Class

    Enter, select or search for the class.

    Subclass

    Enter, select or search for the subclass.

    Item

    Enter, select or search for the supplier's items.

    Order No.

    Enter, select or search for the order number.


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

  3. Click 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 Personalized Saved Searches window appears.

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

  4. Click Search. The suppliers 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 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 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 2-180 Results - Actions Menu/Icons and Description

Actions Menu/Icons Description

Create Supplier and Create Supplier icon

Select Actions > Create Supplier, or use the Create Supplier icon to create a new supplier/supplier site.

For more details about how to create a supplier/supplier site, see the Creating a Supplier/Supplier Site section.

Edit Supplier and Edit Supplier icon

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

For more information about how to edit a supplier, see the Editing a Supplier section.

View Supplier and View Supplier icon

To view a supplier:

  • Select a record in the Results section.

  • Select Actions > View Supplier, or click the View Supplier icon. The Supplier window appears.

  • Click Done to close the window.

Export to Excel and 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.

Edit Supplier Site

The Supplier Site window appears.

You can also click on the supplier site link in the table, to open the Supplier Site window in edit mode.

For more information about how to edit a supplier site, see the Editing a Supplier Site section.

This option is only available, if you select a supplier site in the Results section.

View Supplier Site

To view a supplier site:

  • Select a record in the Results section.

  • Select Actions > View Supplier Site, the Supplier Site window appears.

  • Click Done to close the window.

This section is only available, if you select a supplier site in the Results section.


Results - View Menu and Icons

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

Table 2-181 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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


Supplier Search Toolbar

The toolbar contains the following icons and buttons.

Table 2-182 Supplier Search Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

Done

Click Done to close the window.


Creating a Supplier/Supplier Site

To create a supplier or supplier site in the Supplier Search window, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Suppliers and Partners > Manage Suppliers. The Supplier Search window appears.

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

  3. Click Search. The suppliers/supplier sites that match the search criteria are displayed in the Results section.

  4. Then select Actions > Create Supplier, or use the Create Supplier icon. The Create Supplier window appears.

    1. In the Supplier Level field, select supplier or supplier site from the list. This field is a required field.

    2. In the Supplier field, enter, select or search for the supplier you want to create the site for. If you selected supplier as the supplier level, this field is disabled.

    3. Click OK. The Supplier/Supplier Site window appears.

  5. Enter the necessary information in the individual sections.

    For more information about the available sections of the Supplier/Supplier Site window, see the Supplier/Supplier Site Window section.

  6. Then choose one of the following options.

    • Click Save to save the supplier/supplier site.

    • Click Save and Close to save the supplier/supplier site and close the window.

    • Click Save and Create Another to save the current supplier/supplier site and create additional entries.

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

Editing a Supplier

To edit a supplier, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Suppliers and Partners > Manage Suppliers. The Supplier Search window appears.

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

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

  4. Select a supplier in the Results section.

  5. Then select Actions > Edit Supplier, use the Edit Supplier icon, or click on the supplier link. The Supplier window appears.

  6. Edit the information in the individual sections.

    For more information about the available sections of the Supplier/Supplier Site window, see the Supplier/Supplier Site Window section.

  7. 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 Save and Edit Another to your changes and edit additional suppliers.

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

Editing a Supplier Site

To edit a supplier site, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Suppliers and Partners > Manage Suppliers. The Supplier Search window appears.

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

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

  4. Select a supplier site in the Results section.

  5. Then select Actions > Edit Supplier Site, or click on the supplier site link. The Supplier Site window appears.

  6. Edit the information in the individual sections.

    For more information about the available sections of the Supplier Site window, see the Supplier/Supplier Site Window section.

  7. 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 Save and Edit Another to your changes and edit additional supplier sites

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

Partners Window

The Partner window allows you to create, edit, and view a partner. Partner status may be active or inactive. You can enter the currency, language, status, and primary contact information. Use this window to track the following information for specific types of partners:

Bank partners: Track a line of credit.

Import authority partners: Indicate whether they are the primary import authority for the principal country.

All partners except banks: Track manufacturer ID, principal country, Tax ID, and terms.

In some countries, inventory maintained with a third party must be controlled by the retailer. A retailer may send goods to the external finisher or supplier for finishing the work (such as printing, dyeing, and embroidery) or repair (in case of damaged goods). After the job is done, the finisher or the supplier returns the goods back to the same or a different location. All such movements must be accompanied by a Nota Fiscal.

Auto Receive Stock Indicator: Available only if the partner type is an external finisher.

This flag is used in the two-legged transfer process to indicate, when the warehouse/store ships the stock for the first leg, the system should automatically update the stock at the external finisher. The system will not wait for confirmation from the external finisher, regardless of whether it has received the merchandise or not. If this indicator is unchecked, when the first leg of the transfer is shipped, the system should not update the stock at the external finisher until the external finisher sends across a message that it has received the merchandise.

At the system level, you can determine if partner IDs are unique to all partners or unique to a partner type. If IDs are unique to a partner type, partners with different partner types may have the same ID.

The Partner window contains the following sections.

Figure 2-74 Partner Window

Partner window

Header

The header section contains the following fields.

Table 2-183 Header - Fields and Description

Fields Description

Partner Type

The Partner Type field is labeled according to the created partner, for example, Bank.

The partner ID is generated automatically.

Enter the name of the partner.

This field is a required field.

Secondary Name

Enter a secondary name for the partner, if available.

Principal Country

Enter, select or search for the principal country code of the partner.

This field is a required field.

Currency

Enter, select or search for the partner's currency code.

This field is a required field.

Status

Select the status of the partner from the list.

This field is a required field.

Terms

Enter, select or search for the payment terms.

This field is a required field.

Language

Select the partner's language from the list.

Auto Receive Stock checkbox

Select this checkbox to indicate that the system updates the stock for the external finisher when the 1st leg of the transfer is shipped.

Line of Credit:


Line of Credit

Enter the credit limit.

This field is a required field.

Outstanding

Contains the total amount of credit that the company has used or has charged against in the partner's currency.

Open

Displays the open credit amount.

YTD Line of Credit Placed

Contains the total amount of credit the company has used this year to this date in the partner's currency.

YTD Drawdowns

Contains the year to date payments the bank has made on behalf of the company in the partner's currency.

Contact:


Name

Enter the name of the primary contact at the partner's site.

This field is a required field.

Phone

Enter the phone number of the primary contact.

This field is a required field.

Email/Fax/Telex

Enter additional contact information in the appropriate fields.


Comments

In the Comments section you can enter any comments relevant for the partner, if necessary.

Partner Toolbar

The toolbar contains the following icons and buttons.

Table 2-184 Partner Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

Delete icon

Use the Delete icon to delete the current partner information.

More Actions

Click More Actions to see a list of additional actions that can be performed in the Partner window.

  • Address

    Opens the Addresses window.

    For more information about this function, see the Addresses Window section.

  • Invoicing Attributes

    Opens the Invoicing Attribute window.

    For more information about this function, see the Specifying Invoicing Attributes section.

Save and Close

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

Save and Create Another

Click Save and Create Another to save the entered records and add additional entries.

This option is only available, if you create a new partner.

Save and Edit Another

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

This option is only available, if you are in edit mode.

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.


Creating a Partner

To create a partner, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Items > Suppliers and Partners > Create Partner. The Create Partner window appears.

  2. In the Partner Type field, select the type of partner you want to create.

  3. Click OK. The Partner window appears. The partner ID is generated automatically.

  4. Enter the necessary partner information in the available sections.

    For more information about the available sections of the Partner window, see the Partners Window section.

  5. Then choose one of the following options.

    • Click Save to save the partner information.

    • Click Save and Close to save the partner and close the window.

    • Click Save and Create Another to create additional partners.

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

Editing a Partner

To edit a partner, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Items > Supplier and Partners > Manage Partners. The Partner Search window appears.

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

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

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

  5. Edit the fields as, necessary.

  6. Then choose one of the following options.

    • Click Save to save the partner information.

    • Click Save and Close to save the partner and close the window.

    • Click Save and Edit Another to edit additional partners.

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

Specifying Invoicing Attributes

The Invoicing Attribute window allows you to specify how invoices from the partner are handled. You can indicate where an invoice is received and where an invoice is paid. You can also indicate that the stores must confirm that the service was performed before the invoice from the partner is approved. You can select invoicing attributes for a partner if the Oracle Retail Invoice Matching product is installed.

To specify invoicing attributes for a partner, follow the steps below.

  1. From the Tasks menu, select Foundation Data > Supplier and Partners > Manage Partner. The Partner Search window appears.

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

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

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

  5. Select More Actions > Invoicing Attributes. The Invoicing Attribute window appears.

    1. In the Receive Invoice, field, select where the invoice is received.

    2. In the Pay Invoice field, select where the invoice is paid.

    3. Select the Confirmation Required for Services Performed checkbox, to indicate that the stores must confirm that the service was performed before the invoice from the partner is approved.

    4. Then choose:

      • Click OK to save the invoicing attributes and close the window.

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

Managing Partners

The Manage Partners option opens the Partner Search window. In this window you can perform the following actions.

  • Search for partners by various search criteria

  • View the search results

  • View partner information

  • Create partner information

  • Edit partner information

You can access the Partner Search window from the Task menu, select Foundation Data > Suppliers and Partners > Manage Partners. The Partner Search window appears.

The Partner Search window contains the following sections.

Figure 2-75 Partner Search Window

Partner Search window

Searching for a Partner

To search for a partner:

  1. From the Task menu, select Foundation Data > Suppliers and Partners > Manage Partners. The Partner Search window appears.

  2. You can search for a partner 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 basic mode.

Searching for a Partner Through the Basic Search Criteria

To search for a partner by using basic search criteria:

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

    Table 2-185 Partner Search - Basic Search Criteria and Description

    Fields Description

    Match option

    Check radio button All or Any.

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

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

    Partner Type

    Select the partner type from the list.

    Partner

    Enter, select or search for the partner ID.

    Description

    Enter, select or search for the partner description.

    Status

    Select the status of the supplier.

    Currency

    Enter, select or search for the currency.

    Principal Country

    Enter, select or search for the principal country.

    Manufacturer ID

    Enter, select or search for the manufacturer ID.

    Language

    Enter, select or search for the language.


  2. Click 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 Personalized Saved Searches window appears.

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

  3. Click Search. The partners 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 Saved Search".

  6. Click Done to close the window.

Searching for a Partner Through Advanced Search Criteria

To search for a partner by using advanced search criteria:

  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 be equal or not equal to the search result.

  3. Click 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 Personalized Saved Searches window appears.

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

  4. Click Search. The partners 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 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 partners.

Result - Actions Menu and Icons

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

Table 2-186 Results - Actions Menu/Icons and Description

Actions Menu/Icons Description

Create and Create icon

Select Actions > Create or use the Create icon to create a new partner. The Create Partner window appears.

For more details about how to create a partner, see the Creating a Partner section.

Edit and Edit icon

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

For more information about how to edit a partner, see the Editing a Partner section.

View and View icon

To view a partner:

  • Select a record in the Results section.

  • Select Actions > View or click the View icon. The Partner window appears.

  • Click Done to close the window.

Export to Excel and 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.


Results - View Menu and Icons

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

Table 2-187 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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


Partner Search Toolbar

The toolbar contains the following icons and buttons.

Table 2-188 Partner Search Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

Done

Click Done to close the window.


Expense Profiles

Expense profiles can be defined for suppliers, partners, and/or countries of sourcing. Supplier and country profiles default to items. Partner expense profiles default to PO/items when an item is added to an order.

You can divide supplier and partner expense profiles into Country or Zone level.

  • Country level profiles are for expenses incurred when moving goods from a country of sourcing to the discharge port in the country of import.

  • Zone level profiles are for expenses incurred when moving goods from a discharge port in the country of import to a final destination cost zone.

For a given supplier you may utilize one basic route from the supplier's country to the discharge port, but may have many different routes when moving the goods from the discharge port to the destination.

Additionally, you can change the rate on a cost component in expense profiles and automatically update item expenses and/or PO/item expenses on a designated date.

The Expense Profiles window contains the following sections.

Figure 2-76 Expense Profiles Window

Expense Profiles window

Header

The header section varies depending on, if you create or edit expense profiles for a supplier, partner or a country of sourcing.

  • Supplier Expense Profiles

    The header displays the supplier site ID and name.

    In the Profile Type field, select the type.

    • Select Zone to make changes to the expense profile at the supplier/cost zone level.

    • Select Country to make changes to the expense profile at the supplier/country of sourcing level.

  • Partner Expense Profiles

    The header displays the partner type, ID and name.

    In the Profile Type field, select, the type.

    • Select Zone to make changes to the expense profile at the partner/cost zone level.

    • Select Country to make changes to the expense profile at the partner/country of sourcing level.

  • Country Expense Profiles

    The header displays the profile type country by default.

    In the Country field, select the country you want to create the expense profiles for.

Shipping Routes

In the Shipping Routes section you can add, delete and view shipping routes. Additionally, you can define a shipping route as the default expense profile in this section.

Shipping Routes - Actions Menu and Icons

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

Table 2-189 Shipping Routes - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

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

For more information about how to add shipping routes, see the following sections.

Delete and Delete icon

You can delete shipping routes:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.


Shipping Routes - View Menu and Icons

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

Table 2-190 Shipping Routes/Expenses/Rate Updates - 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

You can view the tables in the application in a separate window by clicking Detach or by using the 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

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.


Expenses

In this section you can add, edit, delete and view expenses for the supplier, partner or a country.

Expenses - Actions Menu and Icons

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

Table 2-191 Expenses - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

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

For more information about how to add expenses, see the Adding Expenses section.

Edit and Edit icon

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

For more information about how to edit an expense component, see the Editing Expenses section.

Delete and Delete icon

You can delete expenses:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.


Expenses - View Menu and Icons

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

For more information about the View Menu, see Table 2-190, "Shipping Routes/Expenses/Rate Updates - View Menu/Icons and Description".

Rate Updates

In the Rate Updates section you can apply rate updates to items and orders.

Rate Updates - Actions Menu and Icons

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

Table 2-192 Rate Updates - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon

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

For more information about how to add rate updates, see the Adding Rate Updates section.

Edit and Edit icon

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

For more information about how to edit a rate update, see the Editing Rate Updates section.

Delete and Delete icon

You can delete rate updates:

  • Select a record in the table.

  • Select Actions > Delete or use the 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

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.


Rate Updates - View Menu and Icons

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

For more information about the View Menu, see Table 2-190, "Shipping Routes/Expenses/Rate Updates - View Menu/Icons and Description".

Expense Profile Toolbar

The toolbar contains the following icons and buttons.

Table 2-193 Expense Profile Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon

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

Refresh icon

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

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 Create Another

Click Save and Create Another to save the entered records and add additional entries.

This option is only available, if you create a new expense profile.

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.

Done

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

Click Done to close the window.


Adding Shipping Routes at Country Level

To add a new shipping route to an expense profile at the country level, follow the steps below.

  1. In the Profile Type field, select Country from the list.

  2. In the Shipping Routes section, select Actions > Add, or use the Add icon. The Add Shipping Route window appears.

  3. In the Origin Country field, enter, select or search for the appropriate country. This field is a required field.

  4. In the Lading Port field, enter, select or search for the lading port.

  5. In the Discharge Port field, enter, select or search for the discharge port.

  6. Select the Base Profile checkbox to indicate that you want to use this shipping route as the default.

  7. Then choose one of the following options.

    • Click OK to add the shipping route and close the window.

    • Click OK and Add Another to add additional shipping routes.

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

Adding Shipping Routes at Zone Level

To add new shipping routes to an expense profile at the zone level, follow the steps below.

  1. In the Profile Type field, select Zone from the list.

  2. In the Shipping Routes section, select Actions > Add, or use the Add icon. The Add Shipping Route window appears.

  3. In the Discharge Port field, enter, select or search for the discharge port. This field is a required field.

  4. In the Zone Group field, enter, select or search for the zone group.

  5. In the Cost Zone field, enter, select or search for the cost zone.

  6. Select the Base Profile checkbox to indicate that you want to use this shipping route as the default.

  7. Then choose one of the following options.

    • Click OK to add the shipping route and close the window.

    • Click OK and Add Another to add additional shipping routes.

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

Adding Shipping Routes to Country Expense Profiles

To add a new shipping route to a country expense profile, follow the steps below.

  1. In the Shipping Routes section, select Actions > Add, or use the Add icon. The Add Shipping Route window appears.

  2. In the Lading Port field, enter, select or search for the lading port.

  3. In the Discharge Port field, enter, select or search for the discharge port. This field is a required field.

  4. Select the Base Profile checkbox to indicate that you want to use this shipping route as the default.

  5. Then choose one of the following options.

    • Click OK to add the shipping route and close the window.

    • Click OK and Add Another to add additional shipping routes.

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

Adding Expenses

To add expenses to the profile follow the steps below.

  1. In the Expense section, select Actions > Add, or use the Add icon. The Add Expense window appears.

  2. In the Component field, enter, select or search for the expense component. This field is a required field.

  3. In the Component Rate field, enter the component rate. This field is a required field.

  4. In the Computation Value Base, enter, select or search for computation value base.

  5. The Calculation Basis field, displays the calculation basis for the expense.

  6. In the Per Count field, enter, select or search for the per count number.

  7. In the Per Count UOM field, enter, select or search for the per count unit of measure. This field is a required field.

  8. In the Component Currency field, enter, select or search for the currency ID. This field is a required field.

  9. In the Component Nomination section, select the status of the expense in relation to the other components.

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

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

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

  10. Then choose one of the following options.

    • Click OK to add the expense and close the window.

    • Click OK and Add Another to add additional expenses.

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

Editing Expenses

To edit expenses to the profile follow the steps below.

  1. In the Expense section, select a record in the table.

  2. Then select Actions > Edit, or use the Edit icon. The Edit Expense window appears. The values of the selected expense are displayed.

  3. Edit the fields, as necessary.

  4. Then choose one of the following options.

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

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

Adding Rate Updates

To add rate updates for items and/or orders, follow the steps below.

  1. In the Rate Updates section, select Actions > Add, or use the Add icon. The Add Rates window appears.

  2. In the Effective Date field, enter the effective date or use the Calendar icon to select a date. This field is a required field.

  3. In the Comp Rate field, enter the component rate. This field is a required field.

  4. In the Component Currency field, enter, select or search for the component currency code.

  5. Select the Item checkbox to apply the rate updates to items.

  6. Select the Order checkbox to apply the rate updates to orders.

  7. Then choose one of the following options.

    • Click OK to add the rate updates and close the window.

    • Click OK and Add Another to add additional rate updates.

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

Editing Rate Updates

To edit rate updates for items and/or orders, follow the steps below.

  1. In the Rate Updates section, select a record in the table.

  2. Then select Actions > Edit, or use the Edit icon. The Edit Rates window appears. The values of the selected rate update are displayed.

  3. Then choose one of the following options.

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

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

Data Download

The Data Download window allows you to view and maintain RMS Foundation Data through a spreadsheet.

  1. You can access the Download Data window from the Task menu, select Foundation Data > Data Loading > Download. The Download Data window appears.

    Figure 2-77 Download Data Window

    Download Data window
  2. In the Template Type field, select the template type from the list.

  3. In the Template field, enter, select or search for the template you want to download.

  4. Then choose one of the following options:

    • Click Download to download the file.

    • Click Revert to clear out the screen inputs.

  5. Click Done to close the Download Data window.

Data Upload

The Upload Data window allows you to upload and maintain RMS Foundation Data through a spreadsheet.

  1. You can access the Upload Data window from the Task menu, select Foundation Data > Data Loading > Upload. The Upload Data window appears.

    Figure 2-78 Upload Data Window

    Upload Data window
  2. In the Template Type field, select the template type from the list.

  3. In the Template field, enter, select or search for the template you want to upload.

  4. The Process Description field displays the default process name with the date and timestamp. You can edit the name of the upload process in this field.

  5. In the Source File field, click the Choose File button to upload the file.

  6. Then choose one of the following options:

    • Click Upload to upload the file. If error occurs during the upload process, you will get a notification.

    • Click Revert to clear out the screen inputs.

  7. Click Done to close the Upload Data window.

Data Loading Status

The Data Loading Status window allows you to view the status of the upload and download processes happening in RMS, so that you can rectify the issues associated with the upload/download process.

The window allows you to drill down to the errors or warnings associated with a selected upload/download request.

You can access the Data Loading Status window from the Task menu, select Foundation Data > Data Loading > Review Status. The Data Loading Status window appears.

The Data Loading Status window contains the following sections.

Figure 2-79 Data Loading Status Window

Data Loading Status window

Table

The table displays the process, process description, file name, template category and type, destination, action date and time, status and the user, who initiated the process.

Table - Actions Menu and Icons

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

Table 2-194 Data Loading Status Table - Actions Menu/Icons and Description

Actions Menu/Icons Description

Delete and Delete icon Delete icon

You can delete a process by using the following steps:

  • 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.

View Issues and View Issues button

To view the warnings and errors associated with a selected upload/download request:

  • Select a record in the table.

  • Select Actions > View Issues or use the View Issues button. The Issues window appears.

  • Click Done to close the window.

Upload to RMS

With this option you can upload the selected process from Staging to RMS.

This option is only enabled for records which have Staging Tables as a destination and do not hold the status ”Processed with Errors”. Additionally, this option is only enabled for Item induction, Cost Change induction and Order induction records.

Download Staged

This option allows you to download the staged records of a process to a spreadsheet.

  • Select a record in the table.

  • Select Actions > Download Staged. The staged record are downloaded to your desktop.

This option is only enabled for Item induction, Cost Change induction and Order induction records.


Data Loading Status - View Menu and Icons

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

Table 2-195 Table Data Loading Status - 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 table 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.


Data Loading Status Toolbar

The toolbar contains the following icons and buttons.

Table 2-196 Data Loading Status 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.

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.


Download Blank Template

The Download Blank Template window allows you to download blank templates which are already present in RMS.

  1. You can access the Download Blank Template window from the Task menu, select Foundation Data > Data Loading > Download Blank Template. The Download Blank Template window appears.

  2. In the Type field, select the template type from the list.

  3. In the Template field, enter, select or search for the template you want to download.

  4. Then choose one of the following options:

    • Click Download to download the file.

    • Click Revert to undo any changes.

  5. Click Done to close the Download Blank Template Data window.