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

Previous
Previous
 
Next
Next
 

6 Deals

This chapter helps you in understanding Deals supported within RMS.

A deal is a set of one or more agreements that take place between the retailer and a vendor. A vendor can be a supplier, wholesaler, distributor or manufacturer, and from the vendor, the retailer is entitled to receive discounts or rebates for goods that are either purchased or sold. A deal consists of a set of discounts and/or rebates that are negotiated with the vendor and share a common start date.

Deals can cover a specified period of time. For example, a special deal might be set up based on a promotion or have an open-ended timeframe (such as when a retailer might get 5% off on all merchandise ordered from a specific supplier).

After a deal has been successfully negotiated, it needs to be defined within RMS in order to have discounts on purchase orders applied or in order to recover rebates from the supplier. This deal definition is carried out in terms of its components, which include the following: item/locations, thresholds, discounts and funding percentages. Once this setup is complete, the deal can be approved.

Types of Deals

The different types of deals supported within RMS are as follows:

  • Off-invoice deals: This type of a deal is set up between a retailer and a vendor where the retailer is provided a discount on purchase orders raised with the vendor when certain threshold criteria are met by the purchase order. The discount amount gets directly deducted from the cost of the item present in the order, and the retailer is required to pay only the discounted cost. Off-invoice deals are applied when purchase orders with the items on a deal are approved. If a manual cost is entered for the item on the purchase order, deals are not applied to the item unless you request an override of manual costs. Deals that cause the unit cost of an item to be below zero are not applied.

  • Bill Back (BB) deals: This type of a deal is based on an agreement with a supplier or partner over a fixed or variable duration and has one or more components comprising of merchandise items, locations, thresholds and discounts. The deal definition captures the different thresholds that are set up for the items/locations present in the deal and the related discounts that the retailer is eligible to receive on successfully meeting the thresholds. The thresholds can be based on either purchases or receipts. A regular bill back compares each purchase event against the threshold individually, whereas receipts are compared in the aggregated form. All purchases-based bill back deals will generate income on the net cost of the purchase order, after the off-invoice deals have been applied.

  • Rebates: Bill back rebate (BBR) deals are similar to the bill back deals described above, but these aggregate all the events and compare them against the thresholds in the aggregated form. Furthermore, bill back rebate thresholds can be based on sales in addition to purchases or receipts.

  • Vendor Funded Promotion (VFP): In order to reduce outstanding inventory or compete against another retailer during certain periods of the year, a retailer may institute a temporary price reduction by creating a promotion in Oracle Retail Price Management (RPM). To keep profit margins intact, the retailer often negotiates a deal with the supplier wherein the supplier funds part or the entire promotion. This type of vendor funding is created as a VFP within the system. RPM and RMS work together to support this type of deal. VFP can be set up either in RMS or in RPM. Depending on the application in which they are set up, different steps must be followed by you.

  • Vendor Funded Markdowns (VFM): Similar to a VFP, a VFM can be used if a vendor agrees to fund a specific percentage of the markdown. The vendor can support the retailer either by contributing a percentage of the retail price discount for each item on hand or by giving a fixed amount for all the items that still remain in stock. In such scenarios, integration between the regular/clearance price changes (in RPM) and VFM deals (in RMS) is essential.

  • PO Specific Deals: In addition to annual and promotional deals, a supplier might also offer certain deals which are specific to a purchase order. This type of a PO Specific Deal can be set up within RMS using an option that is available in the PO item setup screen. For such a deal, the Deal Timing gets populated with PO Specific, and the order number gets auto-populated. Only a single PO specific deal can be attached to a purchase order, and this will always be applied last in the sequence when calculating the deal totals.

  • Fixed Deals: Fixed deals allow you to capture one-off payments or a series of payments from a vendor to the retailer. This type of deal caters to certain business setups that require the vendor to give the buyer a fixed amount of money in return for advertising their products for promotional reasons, for in-store demonstrations, or for displaying their merchandise in prime shelf space. A fixed deal comes with a defined amount, duration, billing frequency, and invoicing method. There is built-in logic to auto-generate billing requests for such amounts based on the billing frequency.

This chapter outlines the processes involved in setting up and maintaining all of the above types of deals.

This chapter includes the following topics to help you understand and manage deals:

Creating a Deal

The Create Deal window allows you to create and maintain deals with partners or suppliers. Deal partners can be wholesalers, distributors, and manufactures. Within a deal, you create deal components, specify the items and location for each deal component, and define thresholds.

Components are deals or parts of that deal you receive from a supplier. Multiple components can exist in a single deal. After you add the components, you define thresholds to define the quantity or amount that must be purchased or sold to receive the deal.

Finally, you define the items and locations where the deal can be applied. You can choose to include or exclude locations as necessary.

Additionally, you can define the proof of performance (POP) terms and expected deal income. You can define deal income only for bill back and rebate deals. POP terms are defined by the deal vendor that offers the deal. For deals, POP terms can be defined at the deal, deal/component, or deal component/item loc combination. For fixed deals, the POP terms are defined at the deal level.

To create a deal:

  1. From the Tasks menu, select Orders > Deals > Create Deal. The Create Deal window appears.

    Figure 6-1 Create Deal Window

    Surrounding text describes Figure 6-1 .
  2. The deal number is displayed by default.

  3. In the Vendor field, select the vendor type, enter, select or search for the deal vendor.

  4. In the Currency field, enter, select or search for the currency.

  5. In the Timing field, select the timing of deal:

    • Annual: A yearlong deal you have with a deal partner. Only one annual deal can be applied to an item at a time. You close the deal manually when it expires, or the deal is closed automatically when you create another annual deal with the deal partner. On selection of Annual, the Billing Type gets defaulted to Off-invoice, and the field is disabled since this is the only possible type of annual deal.

    • Promotional: A deal that is generally shorter than an annual deal. Multiple an promotional deals can be applied to an item at the same time. The deal closes automatically on the specified end date. Bill Back, Vendor Funded Promotion, Vendor Funded Markdown, and Off-invoice can all be promotional deals.

  6. In the Active Date field, enter the date on which the deal becomes active, or click the calendar icon and select the date.

  7. In the Close Date field, enter the date on which the deal ends, or click the calendar icon and select the date.


    Note:

    This field is not required for annual deals.

  8. In the Billing Type field, select the type of deal being created.


    Note:

    If you select Annual in the Deal Timing field, Off-Invoice is the default for the Billing Type and cannot be changed.

    • Off-Invoice: The deal is reflected as an amount decremented from the cost on the invoice.

    • Bill Back: The deal income amount is invoiced to the supplier after the goods are purchased. A special type of a bill back is a rebate, which can be calculated on sales, purchase orders or receipts.

    • Vendor Funded Promotion: A promotion sponsored by the deal vendor. The deal will close automatically on the end date. Multiple vendor-funded promotional deals can be applied to an item at the same time.

    • Vendor Funded Markdown: A markdown sponsored by the deal vendor. The deal will close automatically on the end date. Multiple vendor-funded markdown deals can be applied to an item at the same time.

  9. In the Threshold Limit Type field, select the type of threshold limit type. This field is not required for VFP and VFM billing type and will be disabled. Certain deal types such as Off-invoice and Bill Backs allow the tracking of the threshold limit in terms of units or an amount.

  10. In the Threshold Limit UOM field, select the UOM. If units are selected as Threshold Limit Type, you also need to define the Unit of Measure (UOM) that the threshold tracks. It will be disabled otherwise. For PO specific deals, if the Transaction Level Discount is set to Y, the threshold limit type is always Amount.

  11. Select the Recalculate Approved Orders check box. This is only applicable to an Off-invoice deal. This indicates whether approved orders should be recalculated based on the current deal parameters and applies only in case of an off invoice deal. If this is checked, any approved order currently in the system that meets the deal criteria is recalculated based on the new deal once it is approved.

  12. Select the Security check box. This indicator is used to implement user based security for the deal that is currently being created. In case this has been set for a deal, the deal details can be viewed or edited only by users who have the same or higher privileges compared to the deal creator.

  13. In the Ref. No. field, enter a number.

  14. In the Comments field, enter any additional comments as necessary.

  15. Click OK to save any changes. The Deal window appears.

  16. Click Cancel to return to the Tasks menu without saving changes.


Note:

You can also create a deal by clicking Create in Actions menu, or by clicking the Create icon Create icon on the Deal Search window.

Creating Purchase Order (PO) Specific Deals

You can also create PO specific deals. To create a PO-Specific Deal, follow the steps listed below.

  1. From the Tasks menu, select Orders > Manage Orders. The Order Search window appears.

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

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

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

  5. In the Orders toolbar, click Details. The Order Details window appears.

  6. In the Order Details toolbar, select More Actions > PO-Specific Deal. The Create Deal window appears.

    For more information about the Create Deal window, see the Creating a Deal section.

  7. In the Threshold Limit Type field, select how the threshold is defined.

  8. Click OK to save any changes. The Deal window appears.

Deal Window

Once a deal is created, the Deal window appears. The Deal window allows you to enter the details about the deal and you can add, edit, delete, export to Excel, view, query by example, detach, save, submit, cancel a deal and so on. You can also navigate to Deal Income, POP, Referenced Promotions, and Deal Date windows to add additional information.

The Deal window includes the following sections:

Figure 6-2 Deal Window

Surrounding text describes Figure 6-2 .

Deal Header

The Deal Header includes the following fields.

Table 6-1 Deal Header - Fields and Description

Fields Description

Title

The title displays Deal ID and Billing Type with a separator between them to the top left of the head container. The Deal Timing and Deal Status is displayed with a separator between them to the top right of the head container.

The possible values for billing type are Off invoice, Bill Back, Bill Back Rebate, Vendor Funded Promotion or Vendor Funded Markdown.

The deal number is populated by default.

The possible values for deal timing are Promotional, Annual, PO specific deals, Vendor Funded Markdown.

Deal Status

The description of the deal status, is displayed as text. If you create a deal the status is Worksheet. For more information on deal status, see the Changing the Status of a Deal section.

Vendor

This field displays the type of vendor, vendor ID, and name.

Currency

This field displays the deal currency.

Threshold Limit Type

This field displays the threshold limit type.

Threshold Limit UOM

This field displays the threshold limit UOM.

Recalculate Approved Orders

This field displays as Yes, if the Recalculate Approved Orders check box is checked in the Create Deal window. This field will display as No, if the Recalculate Approved Orders check box is unchecked in the Create Deal window.

Active Date

This field displays the date on which the deal becomes effective.

Close Date

This field displays the date on which the deal ends.

Security

This field displays if the deal was created with user security.

Ref. No.

Enter the deal reference number.

Order No.

This field displays the order number in case of PO specific deals.

Deal Created in RPM

This field is displayed if the deal was created in RPM.



Note:

The Active Date, Close Date, Security, and Ref. No. fields are editable. However, the remaining fields are displayed based on the information entered in the Create Deal window.

Changing the Status of a Deal

When a deal is added to the system, it must go through a series of checks before it is accessible in the system. Depending on your user role, you may not be able to move the deal to the next status. A deal may be in any of the following statuses:

Table 6-2 Deals Approval Process Status

Status Definition

Worksheet

The deal has been started, but not completed.

Submitted

The deal has been completed and is pending review.

Approved

The deal has been reviewed and has been approved.

Rejected

The deal has been submitted, reviewed, and has been rejected.

Closed

The deal is complete.


Bill Back and Financials

The Bill Back and Financials section gets displayed for VFP, VFM, Bill Back (BB), and Bill Back Rebate (BBR) type deals.

The Bill Back and Financials section includes the following fields.

Table 6-3 Bill Back and Financials - Fields and Description

Fields Description

Deal Reporting Level

The deal reporting level determines the length of the reporting periods that would be created for income generation. The options provided to you depends on the calendar type that is being used in the RMS instance. For a 4-5-4 calendar, this can be Week, Month, or Quarter, while for a Gregorian calendar, only Month or Quarter can be selected. Income is calculated once per reporting period. The reporting level also indicates the maximum frequency at which an invoice is raised against the income accrued by the deal.

Purchase/Sales Based

Select wether the deal will be based on purchase or sales. Bill Back Deals are always based on purchases, while Bill Back Rebate deals can be based on either purchases or sales.

Deal Application Timing

Select the deal application timing. The options for Deal Application Timing depends on whether the deal is purchase or sales based. Purchase-based deals can have this set to the PO approval or receiving timing. Sales-based deals do not have timing specified since they are driven by sales records and are applied only when a sale occurs.

Add Deal Reporting Days

This field is used to capture the number of extra reporting days that should be added to the deal actual forecast data to cater to the late postings of the transactions after the deal close date.

Pack Level Tracking

For receipt-based Bill Back and receipt or sales-based Bill Back Rebate deals, the indicator for tracking the deal at the pack level is enabled. Select this indicator to generate income for purchase orders which involve receiving at the pack level or sales occurring at the pack level. This is enabled only for receipt based bill back and receipt or sales based bill back rebate deals.

Rebates sub section:

Rebate Calculation Type

Select the rebate calculation type from the list. This field determines the method in which the comparison of thresholds is performed against the actual turnover figures. Here the term turnover refers to the total revenue generated for a period across the merchandise hierarchy for which the deal is applicable. This is defaulted to Linear and disabled for a BB deal, while for a BBR, you can set it to Linear or Scalar.

Growth Rebate

A rebate in which the supplier determines the amount of the rebate, based on increased orders over a specified period of time. The Growth Rebate information is available only for Bill Back Rebate deals and is for informational and reporting purposes. Selecting this indicator enables the Historical Period fields and allows a buyer to set up a growth rebate deal by looking up prior receipt or sales values in the data warehouse system. The growth percentage can then be manually applied to these values to come up with thresholds that would be applicable for the current deal.

Historical Period

Start Date

End Date

The start and end dates of the historical period against which growth will be measured for this growth rebate.

Financials sub section:

Bill Back Period

Select the period for how frequently the vendor is billed. This period needs to be at least as large as the reporting period because income calculation is performed only at the end of a reporting period. For the 4-5-4 calendar, the choices for the invoice periods are: Week, Month, Quarter, Half Year or Annual. The same choices apply for Gregorian calendar, except Week. This field remains editable until the first invoice has been raised against the deal.

Billing Vendor

This field indicates the vendor to be billed for the specific deal, which can be different from the vendor specified for the deal in Deal Head. Select the vendor type and enter, select or search for the vendor.

Estimated Next Invoice Date

The estimated date the next invoice is going to be sent to the vendor. Enter the correct date or click the calendar icon and select the correct date. The effective date for raising the invoice will depend on when the financial month is closed. The estimated next invoice date gets populated initially based on the bill back period. It takes the last day of the period that will be invoiced. After the invoicing batch program Vendor Deal Invoicing (vendinvc) runs, this date is updated with a Gregorian week, month, or quarter, or the 4-5-4 week setup based on the calendar configuration in the system. This date can be modified throughout the deal's lifetime, even after approval until the last invoice against the deal has been processed.

Last Invoice Date

This field is updated to hold the last reporting period that was invoiced. Enter the date or click the calendar icon and select the date.

Bill Back Method

This indicates whether invoices raised for this deal are in the form of a credit note or a debit note. The option selected here overwrites the supplier's default setup in ReIM. This field remains editable until the last invoice against the deal has been processed.

Deal Income Calculation

The basis for calculating the amount earned from the deal. Actual will only generate income on real turnover. Pro-rated calculates income based on forecasts and actual turnover and distributing this income over all open periods. For BB and BBR types of deals, you have the option of calculating the deal income based on the actual values earned until the current date, or of using the method of proration on the forecasted amount. However, in case of VFP and VFM, the only option is to calculate based on the actual earned values.

Invoice Processing Logic

Select the method for how invoices will be raised for this deal. You have the following options available in the case of BB and BBR type of deals - Automatic all values, manual all values, automatic positive values, manual positive values only, no invoice processing. For a VFP or VFM type of deal, you only have the options of ’Automatic' and ’Manual' for invoice processing. This field remains editable until the first invoice has been raised against the deal.

Deal Income in Stock Ledger

Select the check box to indicate that deal income accrual should be written to the stock ledger.

Include VAT

Select the check box to indicate that VAT should be included in the invoice information.


Components

On the Deal Components section, you can manage deal component information. Deal components are discounts or rebates included in the deal. When you enter deal component information, you determine the billing type, Threshold Value Type, Deal Class, Cost Apply type, and other parameters about how deal component is calculated. You can also specify that a deal component is a transaction level discount that applies to entire purchase orders rather than individual items.

The component type description can be added for deal component information as well as a defaulting contribution percentage. This contribution percentage will only be used as the default when the deal is attached to RPM and never be updated by RPM. This allows you to add all relevant Vendor Funded Promotion information to the deal and yet allows for the flexibility to define it at a promotion component level.

You can also view Promotions attached to VFP/VFM deals and attach Buy/Get information for Off-invoice deals. For more information on viewing Promotions and adding Buy/Get, see the Promotions and the Adding Buy/Get Item section.


Note:

RMS is the custodian of the invoicing logic and will drive the invoicing functionality.

Components - Actions Menu and Icons

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

Figure 6-3 Components -Actions Menu and Icons

Surrounding text describes Figure 6-3 .

Table 6-4 Components - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon Add icon

You can add a deal component by clicking Add from the Actions menu or by clicking the Add icon Add icon.

For more information on adding a deal component, see the Adding Deal Components section.

Edit and Edit icon Edit icon

You can edit a deal component by clicking Edit from the Actions menu or by clicking the Edit icon Edit icon.

For more information on editing a deal component, see the Editing a Deal Component section.

Delete and Delete icon Delete icon

You can delete a deal component, by clicking Delete from the Actions menu or by clicking the Delete icon Delete icon.

For more information on deleting a deal component, see the Deleting a Deal Component section.

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

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


Table 6-5 Components - More Icons and Description

More Icons Description

Move Up and Down Icon Button Move up and down icon

You can move up and down the components to change the order in which they will be applied while calculating Deal Income by clicking the Move Up and Down Icon button Move up and down 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.


Components - View Menu and Icons

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

Figure 6-4 Components - View Menu and Icons

Surrounding text describes Figure 6-4 .

Table 6-6 Components - View Menu/Icons and Description

View Menu/Icons Description

Columns

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

Detach and Detach icon Detach icon

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

Sort

You can sort columns by the following options:

  • Ascending

  • Descending

  • Advanced

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

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

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


Adding Deal Components

You can add deal components to a deal while creating or editing in the Deal window.

To add deal components:

  1. From the Tasks menu, select Orders > Deals > Create Deal. The Create Deal popup window appears.

  2. Enter the relevant data and click OK to save the changes. The Deal window appears.

  3. In the Deal window, go to the Components section.

  4. Figure 6-5 Components Section

    Surrounding text describes Figure 6-5 .
  5. From the Actions menu, click Add or click the Add icon Add icon. The Add Component window appears.

    Figure 6-6 Add Component Window

    Surrounding text describes Figure 6-6 .
  6. In the Type field, select the component type.

  7. In the Threshold Value Type, select the threshold value type. This field is used to capture the incentive type that would be received on attaining the threshold limit of the deal. The options are amount off per unit, percentage off per unit, get units for fixed price or buy/get free or discounted items.

  8. For an off-invoice deal, in the Deal Class field, select the way in which calculations would be performed in case of multiple deal components. The options are Cumulative, Cascade, or Exclusive.


    Note:

    For a Bill Back, Vendor Funded Promotion, and Vendor Funded Markdown this field will default to Cascade and cannot be changed.

  9. In the Cost Apply Type field, select how the deal component is used to calculate future costs. The options are Net Cost, Net-Net Cost or Dead Net Cost. The details such as Cost Apply Type is defaulted to Net Cost and can be overridden.


    Note:

    The value in this field is defaulted based on the type of deal you selected, but can be changed.

  10. Select the following check boxes:

    • Transaction Level Discount - This check box applies to PO-specific off-invoice deals. If this check box is selected on the screen, the deal component applies to an entire PO, receipt or sale transaction. This field can only be selected if the vendor is a supplier. Because these deals apply to the entire order, items and locations are not added to transaction level deals.

    • Calculate Income From Zero Threshold - This check box is not applicable for off-invoice deals. This indicator is used in cases where the vendor has specified that a minimum threshold needs to be reached before a discount applies and when that threshold is reached, the discount applies against the entire threshold, including the level below the threshold.

    • Deal in Price Cost - This indicator defines whether the deal is to be used in the pricing cost calculation used by RPM to determine the margin on the items linked with the deal.

  11. The Default Contribution % is for VFP only and is used to set the initial default contribution of the vendor towards the promotion when the deal is attached to a promotion or markdown in RPM.

  12. In the Comments field, enter any additional comments as necessary.

  13. Then choose one of the following options.

    • Click OK to add the deal component.

    • Click OK and Add Another to add more deal components.

    • Click Cancel to return to the Deal Window.

Promotions

The Promotions window allows you to view a component of a deal with promotions. You can attach multiple promotions to a deal component. The promotion is set up in the pricing system and can then be attached to the deal component. The promotions that are created in RPM for VFP/VFM type can be viewed in this window.

Buy/Get Item

The Buy/Get Item window is only enabled, if Threshold Value Type selected is Buy/Get free or discounted items for off-invoice deals.

Adding Buy/Get Item

To add buy/get item:

  1. Click Buy/Get Item from the Components section. The Buy/Get Item window appears.

    Figure 6-7 Buy/Get Item Window

    Surrounding text describes Figure 6-7 .
  2. The Buy/Get Item window consists of the following three sections:

    • Buy

      • In the Item field, enter or search an item using the search icon. It identifies the item that must be purchased for a quantity threshold-type discount.

    • Threshold Target Quantities

      • In the Item field, enter an item threshold target quantity for the buy item that must be ordered to qualify for the free item.

      • In the Purchase Order field, enter the threshold target quantity for all locations on the purchase order which the buy item is part of. This is the target level that will be used for future calculation of net cost.

      • In the Location field, enter threshold target quantity which is the average targeted purchase level per location on the deal. This value will be used in future cost calculations.

      • Select the Recurring for All Buy Quantity check box. This indicates if the quantity threshold discount is only for the first buy amount purchased (example, for the first ten purchased, get one free), or if a free item will be given for every multiple of the buy amount purchased on the order (example, for every ten purchased, get one free).

    • Get

      • In the Type field, select the Get type from the list. Valid options are free, percent, amount or fixed amount.

      • In the Item field, enter or search for an item using the search icon. This identifies the get item for a quantity threshold-type (buy/get) discount.

      • In the Unit Cost field, enter the amount. This will be enabled if the Get type selected is Free and identifies the unit cost of the threshold free item that will be used in calculating the prorated quantity discount. It will default to the item/supplier cost, but can be modified based on the agreement with the supplier.

      • In the Discount field, enter a value. This will be enabled in case Get type is not 'Free'. It will be percent in case get type is Percent otherwise value.

      • In the Discount Apportion % field, enter a value. This specifies the percentage of the total discount that should be apportioned from the get items unit cost for off invoice deals where buy item is not the same as the get item and Get type is Free. The remaining will be apportioned from the buy item unit cost.

      • In the Threshold Quantity field, enter a value. This identifies the quantity of the identified get item that will be given at the specified get discount if the buy amount of the buy item is purchased.

  3. Click OK to add the buy/get item information.

  4. Click Cancel to return to the Deal window.

Editing a Deal Component

To edit a deal component:

  1. Select the deal component you want to edit.

  2. From the Actions menu, click Edit or click the Edit icon Edit icon.

    The Edit Component window appears.

  3. Edit the enabled fields as necessary.

  4. Click OK to return to Deal window.

  5. Click Save or Save and Close to save the changes.

Deleting a Deal Component

To delete a component:

  1. Select the deal component you want to delete.

  2. From the Actions menu, click Delete or click the Delete icon Delete icon.

    You are prompted to delete the deal component.

  3. Click Yes to confirm deletion.

  4. Click Save or Save and Close to save the changes.

Item/Locations

On the Item/Locations section, you can select the items to which the deal components are applied. You can also specify specific locations for the items. Items and items at specific locations can also be excluded from deal component.

The item/location information is set up per component. This information is shared with RPM and the promotion setup is restricted in RPM based on the information that is pulled in from the component detail if a Vendor Funded Promotional deal is attached to a promotion.

Item/Locations - Actions Menu and Icons

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

Figure 6-8 Item/Locations - Actions Menu and Icons

Surrounding text describes Figure 6-8 .

Table 6-7 Item/Locations - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon Add icon

You can add an item/locations by clicking Add from the Actions menu or by clicking the Add icon Add icon.

For more information on adding an item/location, see the Adding the Item/Locations to a Deal section.

Delete and Delete icon Delete icon

You can delete an item/locations, by clicking Delete from the Actions menu or by clicking the Delete icon Delete icon.

For more information on deleting a deal component, see the Deleting an Item/Location section.

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

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


Item/Locations - View Menu and Icons

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

Figure 6-9 Item/Locations - View Menu and Icons

Surrounding text describes Figure 6-9 .

Table 6-8 Item/Locations - View Menu/Icons and Description

View Menu List Description

Saved Views

Saved views are predefined arrangement of table columns to provide certain specific information by using default and optional columns and is different from the default view. The views available are Merchandise Hierarchy, Organization Hierarchy, and Item Level. For every record you can choose respective saved view to see information related to merchandise hierarchy, organization hierarchy, or item level.

Columns

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

Detach and Detach icon Detach icon

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

Sort

You can sort columns by the following options:

  • Ascending

  • Descending

  • Advanced

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

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

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


Adding the Item/Locations to a Deal

You can add item/locations to a deal component while creating or editing in the Deal window.

To add the item/locations of a deal:

  1. From the Tasks menu, select Orders > Deals > Create Deal. The Create Deal popup window appears.

  2. Enter the relevant data and click OK to save the changes. The Deal window appears.

  3. In the Deal window, go to Item/Locations section.

    Figure 6-10 Item/Locations Section

    Surrounding text describes Figure 6-10 .
  4. From the Actions menu, click Add or click the Add icon Add icon. The Include/Exclude Item/Location window appears

    Figure 6-11 Include/Exclude Item/Location Window

    Surrounding text describes Figure 6-11 .
  5. Select the include or exclude option to determine if the record is being created for inclusion or exclusion.

  6. In the Item section, select the merchandise level from the Merchandise Level list. Choose the appropriate option to add an item by Item or Item List.

  7. In the Location section, select the organizational level from the Organizational Level list. Choose the appropriate option to add location by Store, Warehouse, or by Location List.

  8. Then choose one of the following options.

    • Click OK to add the item/location.

    • Click OK and Add Another to add more item/locations.

    • Click Cancel to return to the Deal Window.

Deleting an Item/Location

To delete an item/location:

  1. Select the item/location you want to delete.

  2. From the Actions menu, click Delete or click the Delete icon Delete icon.

    You are prompted to delete the deal component.

  3. Click Yes to confirm deletion.

  4. Click Cancel to retain the record.

Thresholds

On the Thresholds section, you can specify the lower and upper limits that need to be reached in order to receive the benefits that are defined as part of the current deal. Multiple thresholds or bands can be defined for a deal. If the threshold value type that was defined for the deal component is set to Amount Off, you have the option to select whether the specified amount needs to be applied per unit or as a total value for the entire threshold band. For example, a vendor might offer the retailer a discount of $1 per unit or a total discount of $50 on buying in excess of 100 quantities. Each component added to the deal can be used as the target level around which cost calculations need to take place. You must indicate the threshold band that is to be treated as the targeted level for a deal component. This threshold band is then used for the future cost and pricing cost calculations.

Thresholds - Actions Menu and Icons

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

Figure 6-12 Thresholds - Actions Menu and Icons

Surrounding text describes Figure 6-12 .

Table 6-9 Thresholds - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon Add icon

You can add thresholds by clicking Add from the Actions menu or by clicking the Add icon Add icon.

For more information on adding thresholds, see the Adding the Thresholds of a Deal section.

Edit and Edit icon Edit icon

You can edit thresholds by clicking Edit from the Actions menu or by clicking the Edit icon Edit icon.

For more information on editing thresholds, see the Editing the Threshold of a Deal section.

Delete and Delete icon Delete icon

You can delete thresholds, by clicking Delete from the Actions menu or by clicking the Delete icon Delete icon.

For more information on deleting thresholds, see the Deleting the Threshold section.

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

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


Threshold - View Menu and Icons

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

Figure 6-13 Threshold - View Menu

Surrounding text describes Figure 6-13 .

Table 6-10 Thresholds - View Menu/Icons and Description

View Menu/Icons Description

Currency

You can choose to see the monetary values in the table either in Primary or Deal currency by using this option.

Columns

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

Detach and Detach icon Detach icon

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

Sort

You can sort columns by the following options:

  • Ascending

  • Descending

  • Advanced

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

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

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


Adding the Thresholds of a Deal

You can add thresholds to a deal component while creating or editing in the Deal window.

To add the thresholds of a deal:

  1. From the Tasks menu, select Orders > Deals > Create Deal. The Create Deal popup window appears.

  2. Enter the relevant data and click OK to save the changes. The Deal window appears.

  3. In the Deal window, go to Thresholds section.

    Figure 6-14 Thresholds Section

    Surrounding text describes Figure 6-14 .
  4. From the Actions menu, click Add or click the Add icon Add icon. The Add Threshold window appears.

    Figure 6-15 Add Threshold Window

    Surrounding text describes Figure 6-15 .
  5. In the Lower Limit field, enter the value of the lower limit of the deal component. This is the minimum value that must be met in order to get the specified discount. This value will be either a currency amount or quantity value, depending on the threshold limit type of this deal component.

  6. In the Upper Limit field, enter the value of the upper limit of the deal component. This is the maximum value for which the specified discount will apply. This value will be either a currency amount or quantity value, depending on the threshold limit type of this deal component.

  7. In the Value field, enter the value of the discount that will be given for meeting the specified thresholds for this deal component. This value will be either a currency amount or quantity value, depending on the threshold limit type of this deal component.

  8. In the Total/Unit field, select the total or unit. It indicates if the value for deal components for which the threshold type is amount off is amount off by unit or in total.

  9. Select the Target Level check box. This indicates if a threshold level is the targeted purchase or sales level for a deal component. This indicator will be used for cost calculations.

  10. Click OK to add thresholds. You can add more thresholds by clicking OK and Add Another.

  11. Click Cancel to return to the Thresholds section.

Editing the Threshold of a Deal

To edit the threshold of a deal:

  1. Select the threshold you want to edit.

  2. From the Actions menu, click Edit or click the Edit icon Edit icon.

    The Edit Threshold window appears.

  3. Edit the enabled fields as necessary.

  4. Click OK to return to Deal window.

  5. Click Save or Save and Close to save the changes.

Deleting the Threshold

To delete the threshold:

  1. Select the threshold you want to delete.

  2. From the Actions menu, click Delete or click the Delete icon Delete icon.

    You are prompted to delete the record.

  3. Click Yes to confirm deletion.

  4. Click Save or Save and Close to save the changes.

Threshold Revisions Popup

The threshold revisions popup is visible when revisions exist for a threshold.

To view the threshold revisions popup:

  1. From the Tasks menu, select Orders > Deals > Create Deal. The Create Deal window appears.

  2. Enter the relevant data and click OK to save the changes. The Deal window appears.

  3. In the Deal window, go to Thresholds section and then click Revisions. The Threshold Revisions popup appears.

Figure 6-16 Threshold Revisions Popup

Surrounding text describes Figure 6-16 .

Adding Comments to a Deal

To add comments to a deal:

  1. In the Comments section, enter your comments.

    Figure 6-17 Comments Section

    Surrounding text describes Figure 6-17 .
  2. Click Save to save your changes or click Save and Close to save and close the window.

  3. Click Cancel to discard the changes and close the window.

Deal Performance Window

The Deal Performance window allows you to maintain forecasts for a deal, view period by period performance, and compare the actual deal performance against the actual forecasts.

As actuals are accrued, you can view the actual performance of the deal, at the component level, against the forecasted performance of the deal.

Viewing Deal Performance Window

To view deal performance:

  1. From the Tasks menu, select Orders > Deals > Create Deal. The Create Deal window appears.

  2. Enter the relevant data and click OK to save the changes.

    The Deal window appears.

  3. From the More Actions menu, click Deal Income.

    The Deal Performance window appears, which includes Total and Periods section. For more information on Total and Periods, see the Total and the Periods section.

    Figure 6-18 Deal Performance Window

    Surrounding text describes Figure 6-18 .

Deal Performance Header

The Deal Performance Header includes the following fields.

Table 6-11 Deal Header - Fields and Description

Fields Description

Title

The title displays Deal ID to the top left of the head container. The Deal Status and the Currency is displayed with a separator between them to the top right of the head container.

The deal number is populated by default.

Deal Status

The description of the deal status, is displayed as text. If you create a deal the status is Worksheet. For more information on deal status, see the Changing the Status of a Deal section.

Vendor

This field displays the type of vendor, vendor ID, and name.

Reporting Period

The deal reporting level determines the length of the reporting periods that would be created for income generation. The options provided depends on the calendar type that is being used in the RMS instance. For a 4-5-4 calendar, this can be Week, Month, or Quarter, while for a Gregorian calendar, only Month, or Quarter can be selected. Income is calculated once per reporting period. The reporting level also indicates the maximum frequency at which an invoice is raised against the income accrued by the deal. If quarterly processing is chosen, based on the end date for the deal, RMS may change the date of the final reporting period to an end of month date instead, if the end of the quarter is more than a month away, to allow for faster income realization. For example, if the end date of the deal is set for 17-Jan, but the end of the quarter is 30-Mar, RMS changes the last reporting period to 26-Jan, which is the nearest end of month date.

Billing Period

This field displays the time period for which invoice would be raised for the deal.

Turnover Measure

This field displays whether the turnover from the deal would be measured in quantity or value terms.

Activated Date

The activated date is the day from which the deal starts to be applied within the system.

Closed Date

The close date is the last day of the deal. This is required only for promotional deals.

Estimated Next Bill Date

The Estimated next invoice date gets populated initially based on the Bill Back period. It takes the last day of the period that will be invoiced. After the invoicing batch program Vendor Deal Invoicing (vendinvc) runs, this date is updated with a Gregorian week, month, or quarter, or the 4-5-4 week setup based on the calendar configuration in the system. This date can be modified throughout the deal's lifetime, even after approval until the last invoice against the deal has been processed.


Total

The Total section displays the turnover and income values for deal components for all the valid periods. For turnover it has baseline, budget and actual values. It also shows if turnover totals are designated fixed for distribution among periods. For income it shows budget, actual/trend and actual/forecast values. In addition it also shows Budget Growth %, Total Turnover and Actual Monies Earned with respect to total deal to date.

Total - Actions Menu and Icons

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

Figure 6-19 Total - Actions Menu and Icons

Surrounding text describes Figure 6-19 .

Table 6-12 Total - Actions Menu/Icons and Description

Actions Menu/Icons Description

Edit and Edit icon Edit icon

You can edit Turnover and Income Value in this table by clicking Edit from the Actions menu or by clicking the Edit icon Edit icon.

For more information on editing thresholds, see the Editing Total of a Deal Component section.

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

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


Total - View Menu and Icons

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

Figure 6-20 Total - View Menu

Surrounding text describes Figure 6-20 .

Table 6-13 Total - View Menu/Icons and Description

View Menu/Icons Description

Columns

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

Detach and Detach icon Detach icon

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

Sort

You can sort columns by the following options:

  • Ascending

  • Descending

  • Advanced

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

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

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


Editing Total of a Deal Component

To edit total of a deal component:

  1. From the More Actions menu, click Deal Income. The Deal Performance window appears, which includes the Total section.

    Figure 6-21 Total Section Window

    Surrounding text describes Figure 6-21 .
  2. From the Actions menu, click Edit or click the Edit icon Edit icon. The Edit Components Total window appears.

    Figure 6-22 Edit Component Total Window

    Surrounding text describes Figure 6-22 .
  3. In the Baseline field Turnover sub section, enter or edit the previous year's turnover.

  4. In the Budget field Turnover sub section, enter or edit the expected amount of turnover.

  5. In the Actuals/Forecast field Turnover sub section, enter or edit the actuals or forecast amount.

  6. When the budget turnovers are set, select the Fixed check box to the right of the Budget field. Setting the budget Fixed signifies that the total value for the component will remain fixed despite any change in the value specific to any period. Any change will be divided over the other periods. If this is selected than you will not be able to apply growth % over the baseline to populate budget.


    Note:

    Fixed can be checked against Actual/Forecast as well.

  7. In the Target Baseline Growth % field, enter the percentage you expect the baseline to grow.

  8. Click Apply Growth%.

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

  10. Click Cancel to discard the changes and close the window.


Note:

  • For VFP deals RMS does not allow you to enter budgeted or forecasted values, and the deal income is based on the vendor-supplied contribution percentage.

  • Once a deal is approved, you can change only forecast values. Before that Baseline can also be changed.

This applies for both total and periods section.


Periods

The periods table shows the performance data for deal components broken down by deal reporting periods. The period end column displays the end date of the deal reporting period. You can enter or edit budgeted and baseline turnover for a particular period in this table.

Periods - Actions Menu and Icons

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

Figure 6-23 Periods - Actions Menu and Icons

Surrounding text describes Figure 6-23 .

Table 6-14 Periods - Actions Menu/Icons/Buttons and Description

Actions Menu/Icons/Buttons Description

Edit and Edit icon Edit icon

You can edit Turnover and Income values for the period by clicking Edit from the Actions menu or by clicking the Edit icon Edit icon.

For more information on editing periods, see the Editing Periods of a Deal Component section.

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

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

Copy Baseline Turnover to Budget button

The Copy Baseline Turnover to Budget actions button on the periods table toolbar copies the Baseline Turnover to the budget turnover.


Periods - View Menu and Icons

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

Figure 6-24 Periods - View Menu and Icons

Surrounding text describes Figure 6-24 .

Table 6-15 Periods - View Menu/Icons and Description

View Menu List Description

Columns

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

Detach and Detach icon Detach icon

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

Sort

You can sort columns by the following options:

  • Ascending

  • Descending

  • Advanced

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

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

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


Editing Periods of a Deal Component

To edit periods of a deal component:

  1. From the More Actions menu of the Deals window, click Deal Income. The Deal Performance window appears, which includes the Periods section

    Figure 6-25 Periods Section

    Surrounding text describes Figure 6-25 .
  2. From the Actions menu, click Edit or click the Edit icon Edit icon. The Edit Period window appears.

    Figure 6-26 Edit Period Section Window

    Surrounding text describes Figure 6-26 .
  3. In the Baseline field Turnover sub section, enter or edit the previous year's turnover.

  4. In the Budget field Turnover sub section, enter or edit the expected amount of turnover.

  5. In the Actuals/Forecast field Turnover sub section, enter or edit the actuals or forecast amount.

  6. The total check boxes are view only. They would be checked if the totals for them have been checked fixed in the totals table.

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

  8. Click Cancel to discard the changes and close the window.

Deal Toolbar

The toolbar contains the following icons and buttons.

Figure 6-27 Deals Toolbar

Surrounding text describes Figure 6-27 .

Table 6-16 Deal Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon Help icon

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

Expand and Collapse icons Expand and Collapse icon

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

Delete icon Delete icon

You can delete a deal by clicking the Delete icon Delete icon

Status Button

The label of the status button is dynamic and changes based on the current deal status. It is the next logical status. For example - For the deals in worksheet status it will be Submit. Based on the current status, if there are more than one status action is possible than other options can be accessed with drop down button.

For more information on deal status, see the Changing the Status of a Deal section.

More Actions

For more information about the More Actions menu, see theDeal - More Actions Menu and Description section.

Save

Click Save, to save any changes on the deal window and keep the deal window open.

Save and Close

Click Save and Close, to save the changes and exit the window.

Done

Click Done to close the deal window. This button appears only when you access the window in view mode.

Cancel

Click Cancel all entries and close the window.


Deal - More Actions Menu

Use the More Actions menu to navigate to the following windows. The More Actions menu contains the following options.

Figure 6-28 Deal - More Actions Menu

Surrounding text describes Figure 6-28 .

Table 6-17 Deal - More Actions Menu and Description

Action Buttons Description

More Actions

You can navigate to open the following windows by clicking More Actions menu:

You can navigate to the following windows from the More Actions menu:


Proof of Performance

You can access the Proof of Performance window from the Deals window, More Actions > Proof of Performance. You can access Proof of Performance (POP) window at one of the following levels through the POP sub menu:

  • Deal

  • Deal Component

  • Deal Component/Item Loc

The POP window is used to define the performance requirements at the deal level, component level, or at the item/location level. This allows the buyer to identify what needs to be done in order to receive the deal discount, which might be an advertisement, coupon distributions or ’in store' demonstrations of the product. POP terms are used only for informational purposes in RMS.

Viewing/Creating/Editing Proof of Performance Window

You can select the level at which you want to view, create, or edit for Proof of Performance definitions and fulfillment information. The options are: Deal, Deal/Component, Deal Component Item/Loc.

To view/create/edit proof of performance:

  1. From the Tasks menu, select Orders > Deals > Create Deal. The Create Deal window appears.

  2. Enter the relevant data and click OK to save the changes. The Deal window appears.

  3. From the More Actions menu of the Deal window, click Proof of Performance, and then click Deal or Deal Component or Deal Component/Item Loc depending on which level you want to define proof of performance.

    The Proof of Performance window appears, which includes Terms Definition and Fulfillment sections.

    For more information on Terms Definition and Fulfillment, see the Adding Proof of Performance Terms Definition and the Adding Proof of Performance Fulfillment section.

Figure 6-29 Proof of Performance Window

Surrounding text describes Figure 6-29 .

Proof of Performance Header

The Proof of Performance Header includes the following fields.

Table 6-18 Proof of Performance Header - Fields and Description

Fields Description

Title

The title displays Deal ID and Deal Number to the top left of the head container. The Deal Status and the Currency is displayed with a separator between them to the top right of the head container.

The deal number is populated by default.

The supplier number, name, and the reference number are displayed.


Terms Definition

The Terms Definition section is used to define Proof of Performance terms for a given deal at deal, deal component or deal item-loc combination levels. These terms are defined by the deal partner that offers the deal.

Terms Definition - Actions Menu and Icons

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

Figure 6-30 Terms Definition - Actions Menu and Icons

Surrounding text describes Figure 6-30 .

Table 6-19 Terms Definition - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon Add icon

You can add terms definition by clicking Add from the Actions menu or by clicking the Add icon Add icon.

For more information on adding terms definition, see the Adding Proof of Performance Terms Definition section.

Edit and Edit icon Edit icon

You can edit terms definition by clicking Edit from the Actions menu or by clicking the Edit icon Edit icon.

For more information on editing terms definition, see the Editing Proof of Performance Terms Definition section.

Delete and Delete icon Delete icon

You can delete terms definition, by clicking Delete from the Actions menu or by clicking the Delete icon Delete icon.

For more information on deleting a terms definition, see the Deleting Proof of Performance Terms Definition section.

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

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


Terms Definition - View Menu and Icons

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

Figure 6-31 Terms Definition - View Menu

Surrounding text describes Figure 6-31 .

Table 6-20 Terms Definition - View Menu/Icons and Description

View Menu/Icons Description

Columns

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

Detach and Detach icon Detach icon

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

Sort

You can sort columns by the following options:

  • Ascending

  • Descending

  • Advanced

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

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

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


Adding Proof of Performance Terms Definition

To add terms proof of performance definition:

  1. From the More Actions menu of Deals window, click Proof of Performance, and then click Deal Performance.

    The Proof of Performance window appears, which includes the Terms Definition section.

  2. From the Actions menu, click Add or click the Add icon Add icon. The Add Terms window appears.

    Figure 6-32 Add Terms Window

    Surrounding text describes Figure 6-32 .
  3. In the Type field, select type of performance term.

  4. In the Duration field, enter the duration for the duration type for which the terms will be valid.

  5. In the Duration Type field, select the period of time that you have to comply to the terms of the deal.

  6. In the Deal Ref. Item field, enter the deal reference item or search for and select the deal reference item.

  7. In the Recommended Start and End date fields, enter the vendor's recommended start and end dates or click the calendar icon and select the dates.

  8. In the Planned Start and End date fields, enter the date you intend to start and end complying or click the calendar icon and select the dates.

  9. Then choose one of the following options.

    • Click OK to save the changes and return to Proof of Performance window.

    • Click OK and Add Another to add more terms.

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

Editing Proof of Performance Terms Definition

To edit proof of performance terms definition:

  1. Select the terms definition you want to edit.

  2. From the Actions menu, click Edit or click the Edit icon Edit icon. The Edit Terms window appears.

  3. Edit the enabled fields as necessary.

  4. Click OK to save the changes.

  5. Click Cancel to discard the changes and close the window.

Deleting Proof of Performance Terms Definition

To delete proof of performance terms definition:

  1. Select the terms definition you want to delete.

  2. From the Actions menu, click Delete or click the Delete icon Delete icon.

    You are prompted to delete the proof of performance term.

  3. Click Yes to confirm deletion.

  4. Click No to retain the proof of performance term.

Fulfillment

The fulfillment section is used to record or view proof of performance term fulfillment for a deal.

Fulfillment - Actions Menu and Icons

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

Figure 6-33 Fulfillment - Actions Menu and Icons

Surrounding text describes Figure 6-33 .

Table 6-21 Fulfillment- Actions Menu/Icons and Description

Actions Menu/Icon Description

Add and Add icon Add icon

You can add fulfillments by clicking Add from the Actions menu or by clicking the Add icon Add icon.

For more information on adding fulfillments, see the Adding Proof of Performance Fulfillment section.

Delete and Delete icon Delete icon

You can delete fulfillments, by clicking Delete from the Actions menu or by clicking the Delete icon Delete icon.

For more information on deleting fulfillments, see the Deleting Proof of Performance Fulfillment section.

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

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


Fulfillment - View Menu and Icons

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

Figure 6-34 View Menu

Surrounding text describes Figure 6-34 .

Table 6-22 Fulfillment - View Menu/Icons and Description

View Menu/Icons Description

Columns

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

Detach and Detach icon Detach icon

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

Sort

You can sort columns by the following options:

  • Ascending

  • Descending

  • Advanced

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

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

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


Adding Proof of Performance Fulfillment

To add proof of performance fulfillment:

  1. From the More Actions menu, click Proof of Performance, and then click Deal Performance.

    The Proof of Performance window appears, which includes the Fulfillment section.


    Note:

    Fulfillments are specific to terms. You can add fulfillment only after you have added terms definition.

  2. From the Actions menu, click Add or click the Add icon Add icon. The Add Fulfillment widow. The Add Fulfillment window appears.

    Figure 6-35 Add Fulfillment Window

    Surrounding text describes Figure 6-35 .
  3. In the Promotion field, enter, select or search for a promotion.

  4. In the Dates area:

    • In the Start Date field, enter the start date of the promotion, or click the calendar icon and select a date.

    • In the End Date field, enter the end date of the promotion, or click the calendar icon and select a date.

  5. In the Comments field, enter any additional comments as necessary.

  6. Click OK to add fulfillment. You can add more fulfillment by clicking OK and Add Another.

  7. Click Cancel to close the fulfillment window.

Deleting Proof of Performance Fulfillment

To delete proof of performance fulfillment:

  1. Select the proof of performance you want to delete.

  2. From the Actions menu, click Delete or click the Delete icon Delete icon.

    You are prompted to delete the proof of performance fulfillment.

  3. Click Yes to confirm deletion.

  4. Click Cancel to retain the record.

Referenced Promotions

The Referenced Promotions option opens the Deal Promotions. This window allows you to associate a deal with a promotion. Multiple promotions can be attached to a deal. The promotion is set up in the pricing system and can then be attached to the deal.

Deal Promotions - Actions Menu and Icons

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

Figure 6-36 Deal Promotions - Actions Menu and Icons

Surrounding text describes Figure 6-36 .

Table 6-23 Deal Promotions - Actions Menu/Icons and Description

Actions Menu/Icon Description

Add and Add icon Add icon

You can add deal promotions by clicking Add from the Actions menu or by clicking the Add icon Add icon.

For more information on deal promotions, see the Adding Promotions to a Deal section.

Delete and Delete icon Delete icon

You can delete deal promotions, by clicking Delete from the Actions menu or by clicking the Delete icon Delete icon.

For more information on deal promotions, see the Deleting Deal Promotions section.

Export to Excel icon Export to excel icon

You can save the table to a Microsoft Excel spreadsheet by clicking the Export to Excel option from the Actions menu or by clicking the Export to Excel icon Export to Excel icon.

Wrap icon Wrap icon

You can wrap the values in the table column by using the Wrap icon Wrap icon option.


Deal Promotions - View Menu and Icons

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

Figure 6-37 Deal Promotions - View Menu

Surrounding text describes Figure 6-37 .

Table 6-24 Deal Promotions - View Menu/Icons and Description

View Menu/Icons Description

Columns

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

Detach and Detach icon Detach icon

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

Sort

You can sort columns by the following options:

  • Ascending

  • Descending

  • Advanced

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

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

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


Adding Promotions to a Deal

To add promotions to a deal:

  1. From the More Actions menu, click Referenced Promotions.

    The Deal Promotions window appears.

  2. From the Actions menu, click Add or click the Add icon Add icon. The Add Promotions window appears

    Figure 6-38 Add Promotions Window

    Surrounding text describes Figure 6-38 .
  3. In the Promotion field, enter, select or search for a promotion.

  4. Click OK to save any changes.

  5. You can add more promotions by clicking OK and Add Another.

  6. Click Cancel to discard the changes and close the window.

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

Deleting Deal Promotions

To delete deal promotions:

  1. Select the deal promotions you want to delete.

  2. From the Actions menu, click Delete or click the Delete icon Delete icon.

    You are prompted to delete the record.

  3. Click Yes to confirm deletion.

  4. Click Cancel to retain the record.

Deal Dates

Deal Dates is a view only popup to show the dates related to a deal.

Viewing Deal Dates

To view deal dates:

  1. From the More Actions menu, select Deal Dates. The Deal Dates popup appears.

    Figure 6-39 Deal Dates Popup

    Surrounding text describes Figure 6-39 .
  2. Click OK to close the deal dates popup.

Submitting a Deal

You can submit a deal when a deal is created and the deal is in Worksheet status.

To submit a deal:

  1. From the Tasks menu, select Orders > Deals > Create Deal. The Create Deal window appears.

  2. Click OK to save any changes. The Deal window appears.

  3. In the Components section, select Actions > Add or click the Add icon Add icon.

    The Add Component window appears.


  4. Note:

    You need to enter the required information in the following sections before submitting a deal:
    • Components

    • Item/Locations

    • Thresholds


  5. Enter all the required information and click Submit on the page level toolbar. The deal status changes to Submitted.

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

  7. Click Cancel to discard the changes and close the Deal window.

Approving a Deal

The status of a deal changes as it passes through an approval process. Depending on your user role, you can change the status of a deal. The status can be Worksheet, Submitted, Approved, Rejected, or Closed. A deal is not effective until it is approved.

To approve a deal:

  1. From the Tasks menu, select Orders > Deals > Create Deal. The Create Deal window appears.

  2. Click OK to save any changes. The Deal window appears.

  3. In the Components section, select Actions > Add or click the Add icon Add icon. The Add Component window appears.


  4. Note:

    You need to enter the required information in the following sections before submitting a deal:
    • Components

    • Item/Locations

    • Thresholds


  5. Enter all the required information and click Submit on the page level toolbar. The deal status changes to Submitted.

  6. Click Approve. The status changes to Approved.

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

  8. Click Cancel to discard the changes and close the Deal window.

Managing a Deal

You can access the option to manage deal from the Tasks menu. Managing deals involves performing one or more of the following tasks:

  • Searching for a deal

  • Creating a deal

  • Creating from an existing deal

  • Editing a deal

  • Viewing a deal

On clicking the Manage Deal link by selecting Orders > Deals > Manage Deal, the Deal Search window appears.

In the Deal Search window you can search for deals by specifying various search criteria. You can choose to access deals in the search results in edit or view mode depending on security privileges. There are also options for creating a new deal or creating a new deal from existing.

The Deal Search window includes the following sections:

Figure 6-40 Deal Search Window

Surrounding text describes Figure 6-40 .

Searching for a Deal

To search for a deal:

  1. From the Tasks menu, select Orders > Deals > Manage Deal. The Deal Search window appears.

  2. You can search for a deal by providing search criteria in the search section. The criteria can be provided either in Basic or Advanced mode, depending on the requirement. Basic is the default mode when the search window is entered. Click Advanced to access the search panel in advanced mode. You can return to Basic mode by clicking Basic.

Searching for a Deal Through the Basic Search Criteria

To search for a deal through the basic search criteria:

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

    Table 6-25 Deal Search - Basic Search Criteria

    Fields Description

    Deal

    Enter the deal ID.

    Deal Type

    Select the deal type. The options are: Annual, Promotional, PO Specific, Vendor Funded Markdown.

    Status

    Select the status of the deal. The options are: Worksheet, Submitted, Approved, Rejected, Closed.

    Billing Type

    Select the type of deal being created. The options are Off Invoice, Bill Back, Bill Back Rebate, Vendor Funded Promotion, Vendor Funded Markdown.

    Vendor Type

    Select the vendor type.

    Vendor

    Enter, select or search for the vendor.

    Active Date

    Enter the date on which the deal becomes active, or click the calendar icon and select the date.

    Close Date

    Enter the date on which the deal ends, or click the calendar icon and select the date.


  2. You can also click the Saved Search drop down to select one of the saved sets of search criteria. Selecting a saved search will populate the criteria section with saved criteria. If the saved search is selected to run automatically then the search will be executed too.

    You can also choose to manage and personalize the saved searches by clicking Personalize in the list. The Personalize Saved Searches window appears.

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

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

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

  5. Click Reset to execute the saved search.

  6. Click Save. to save the current set of search criteria as a Saved Search. The Create Saved Search window appears.

    For information on the Create Saved Search window, see the Common User Interface Controls chapter, section "Create Saved Search".

  7. Click Done to close the window.

Searching for a Deal Through the Advanced Search Criteria

To search for a deal through the advanced search criteria:

  1. Enter or select one or all of the following advanced search criteria.

    Table 6-26 Deals Search - Advanced Search Criteria

    Fields Description

    Deal

    Enter the deal ID.

    Deal Type

    Select the deal type. The options are: Annual, Promotional, PO Specific, Vendor Funded Markdown.

    Status

    Select the status of the deal. The options are: Worksheet, Submitted, Approved, Rejected, Closed.

    Billing Type

    Select the type of deal being created. The options are Off Invoice, Bill Back, Bill Back Rebate, Vendor Funded Promotion, Vendor Funded Markdown.

    Vendor Type

    Select the vendor type.

    Vendor

    Enter, select or search for the vendor.

    Active Date

    Enter the date on which the deal becomes active, or click the calendar icon and select the date.

    Close Date

    Enter the date on which the deal ends, or click the Calendar icon and select the date.

    External Ref. No.

    Enter the external reference number.

    Order No.

    Enter, select or search for the order number.

    Deal Component Type

    Select the deal component type.

    Rebate

    Select Yes if the rebate is included in the deal or select No if the rebate is not included in the deal.

    Promotion

    Enter, select or search for the promotion from the list.

    Division

    Enter the division number, select or search for the division name and number.

    Group

    Enter the group number, select or search for the group name and number from the list.

    Department

    Enter the department number, select or search for the department name and number from the list.

    Class

    Enter the class number, select or search for the class name and number from the list.

    Subclass

    Enter the subclass number, select or search for the subclass name and number from the list.

    Item

    Enter the item number, or search by using the search icon.

    Chain

    Enter the chain number, select or search for the chain name and number from the list.

    Area

    Enter the area number, select or search for area name and number from the list.

    Region

    Enter the region number, select or search for the region name and number from the list.

    District

    Enter the district number, select or search for the district name and number from the list.

    Location

    Enter the location number, select or search for the location name and number from the list.


    Figure 6-41 Search Section in Advanced Search Mode

    Surrounding text describes Figure 6-41 .
  2. To narrow down the search, use the list next to the search fields. For example, determine if the entered value should equal or not equal the search result.

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

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

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

  4. Click Search. The deals 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 Done to close the window.

Results

The Results section lists the retrieved deals.

Results - Actions Menu and Icons

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

Figure 6-42 Results - Actions Menu and Icons

Surrounding text describes Figure 6-42 .

Table 6-27 Results - Actions Menu/Icons and Description

Actions Menu/Icons Description

Create and Create icon Create icon

You can create a deal by clicking Create from the Actions menu or by clicking the Create icon Create icon.

For more information on creating a deal, see the Creating a Deal section.

Create from Existing icon Create from exist icon

You can create from a existing deal by clicking Create from Existing from the Actions menu or by clicking the Create from Existing icon Create from exist icon.

For more information on create from existing deal, see the Creating from an Existing Deal section.

Edit and Edit icon Edit icon

You can edit a deal by clicking Edit from the Actions menu or by clicking the Edit icon Edit icon.

For more information on editing a deal, see the Editing a Deal section.

View and View icon View icon

You can view a deal by clicking View from the Actions menu or by clicking the View icon View icon.

For more information on viewing a deal, see the Viewing a Deal section.

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

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


Results - View Menu and Icons

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

Figure 6-43 Results - View Menu

Surrounding text describes Figure 6-43 .

Table 6-28 Results - View Menu/Icons and Description

View Menu/Icons Description

Columns

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

Detach and Detach icon Detach icon

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

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

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

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


Deal Search Toolbar

The toolbar contains the following icons and buttons.

Table 6-29 Deal Search Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon Help icon

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

Done

Click Done to close the window.


Creating a Deal

To create a deal, follow the steps below.

  1. From the Tasks menu, select Orders > Deals > Manage Deal. The Deal Search window appears.

  2. From the Actions menu, select Create or click the Create icon Create icon. The Create Deal window appears.

    For more information on how to create a deal, see the Creating a Deal section

Creating from an Existing Deal

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

  1. From the Tasks menu, select Orders > Deals > Manage Deal. The Deal Search window appears.

  2. From the Actions menu, select Create from Existing or click the Create from Existing icon Create from exist icon. The Create from Existing window appears.

  1. Figure 6-44 Create From Existing Window

    Surrounding text describes Figure 6-44 .
  2. Click OK to create a deal from an existing deal.

  3. Click Cancel to return to Deal Search window.

Editing a Deal

To edit a deal, follow the steps below.

  1. From the Tasks menu, select Orders > Deals > Manage Deal. The Deal Search window appears.

  2. Select the deal you want to edit.

  3. Select Actions > Edit, or click the Edit icon Edit icon. The Deal window appears in Edit mode.

  4. Make the necessary changes and click Done to save the changes.

Viewing a Deal

To view a deal, follow the steps below.

  1. From the Tasks menu, select Orders > Deals > Manage Deal. The Deal Search window appears.

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

  3. Select the deal you want to view.

  4. Click Done to close the window.

Submitting a Deal

You can submit a deal when a deal is created and the deal is in Worksheet status.

To submit a deal:

  1. From the Tasks menu, select Orders > Deals > Manage Deal. The Deal Search window appears.

  2. In the Status field, select the deal in Worksheet status and click Search.

    The deals that are in Worksheet status are displayed in a table in the Results section.

  3. Select the deal that you wish to submit.

  4. Select Actions > Edit or click the Edit icon Edit icon. The Deal window appears.

  5. Click Submit. The deal status changes to Submitted.

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

  7. Click Cancel to discard the changes and close the window.

Approving a Deal

The status of a deal changes as it passes through an approval process. Depending on your user role, you can change the status of a deal. The status can be Worksheet, Submitted, Approved, Rejected, or Closed. A deal is not effective until it is approved.

To approve a deal:

  1. From the Tasks menu, select Orders > Deals > Manage Deal. The Deal Search window appears.

  2. In the Status field, select the deal in Submitted status and click Search.

    The deals that are in Submitted status are displayed in a table in the Results section.

  3. Select the deal that you wish to approve.

  4. Select Actions > Edit or click the Edit icon Edit icon. The Deal window appears.

  5. Click Approve. The deal status changes to Approved.

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

  7. Click Cancel to return to the Deal Search window.

Rejecting a Deal

To reject a deal:

  1. From the Tasks menu, select Orders > Deals > Manage Deal. The Deal Search window appears.

  2. In the Status field, select the deal in Submitted status and click Search.

    The deals that are in Submitted status are displayed in a table in the Results section.

  3. Select the deal that you wish to reject.

  4. Select Actions > Edit or click the Edit icon Edit icon. The Deal window appears.

  5. Click Reject. The status changes to Reject.

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

  7. Click Cancel to return to the Deal Search window.

Creating a Fixed Deal

The Fixed Deal window allows you to define the following deal specific information:

  • Deal details

  • Merchandise hierarchy against which deal can be claimed

  • Location information at which deal can be claimed

  • Promotion Details against which supplier has negotiated the deal

You can also define the terms and fulfillment that is negotiated with the vendor. This information can be entered through Proof of Performance window which is displayed by clicking the Proof of Performance button on the Fixed Deal window.

With fixed deals, your organization receives payments from vendors in return for mentioning their products in promotions or for displaying their products on prime shelf space. Fixed deal payments can be claimed from the vendor either periodically or all at once.

You can create fixed deals and set up a collection schedule, from which you can make claims against the vendor and receive payments.

Fixed deals are typically created in Active status; however, you can create a fixed deal in Inactive status. For deals with Inactive status claims are put on hold.

The Fixed Deal Report provides you with information about active claims. Claim information for inactive fixed deals is not included in the report.


Note:

You can also create a fixed deal by clicking Create in the Actions menu, or by clicking the Create icon Create icon on the Fixed Deal Search window.

The Fixed Deal window includes the following sections:

Figure 6-45 Fixed Deal Window

Surrounding text describes Figure 6-45 .

Fixed Deal Header

The Fixed Deal Header includes the following fields.

Table 6-30 Fixed Deal Header - Fields and Description

Fields Description

Title

The title displays Fixed Deal ID to the top left of the head container. The Deal Status is displayed to the top right of the head container.

This field contains the deal number by default.

Description

Enter a description of the fixed deal.

Vendor

Select or search for the type of fixed deal vendor.

Type

Select the type of payment.

Amount

Enter the payment amount from the supplier.

Org Unit

Enter, select or search for an organizational ID.

Merchandise

If the deal is associated to the merchandise hierarchy, select the Merchandise check box. For more information on Merchandise Hierarchy, see Merchandise Hierarchy.

Non Merch Code

Enter, select or search for the non merchandise code.

The Non Merch field is required only if the Merchandise check box is not selected.

VAT

If VAT is included in the deal, select the VAT check box.

VAT Code

Enter, select or search for the VAT code to apply to the fixed deal.

Deal Collection section:

Collect

Select how often payment for the fixed deal is collected from the supplier.

If you select Date in the Collect field, the number of collection period is always one.

First Collect Date

Enter the date, or click the calendar icon and select the date. The date of the collection of the first amount decided as part of the fixed deal.

Deal Collection section:

Collect Periods

Enter the number of collection periods.

Last Collect Date

If you enter the date in the First Collect Date field, the Last Collect Date field is displayed by default.

The number of times the collection date is to be repeated after the First Collect Date. On each collection date an invoice may be raised based on the invoicing options selected for the deal.

Invoice section:

Processing Logic

Select how invoices are created for the fixed deal. The options of creating invoices are: Automatic, Manual, No Invoice Processing depending on the option selected.

Debit Note/Credit Note

Select whether you want to send a Debit or Credit Note request to the supplier.


Merchandise Hierarchy

The merchandise hierarchy allows you to create the relationships that are necessary in order to support the product management structure of a company. You can assign a buyer and merchandiser at the division, group, and department levels of the merchandise hierarchy. You can also link a lower level to the next higher level. For example, you can indicate which group a department belongs to or which division a group belongs to.

The location section appears if you select Merchandise in the Deal header section.

Merchandise Hierarchy - Actions Menu and Icons

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

Figure 6-46 Merchandise Hierarchy - Actions Menu and Icons

Surrounding text describes Figure 6-46 .

Table 6-31 Merchandise Hierarchy - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon Add icon

You can add merchandise hierarchy by clicking Add from the Actions menu or by clicking the Add icon Add icon.

For more information on adding a merchandise hierarchy, see the Adding Merchandise Hierarchy section.

Delete and Delete icon Delete icon

You can delete merchandise hierarchy, by clicking Delete from the Actions menu or by clicking the Delete icon Delete icon.

For more information on deleting a merchandise hierarchy, see the Deleting Merchandise Hierarchy section.

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

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


Merchandise Hierarchy - View Menu and Icons

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

Figure 6-47 Merchandise Hierarchy - View Menu

Surrounding text describes Figure 6-47 .

Table 6-32 Merchandise Hierarchy - View Menu/Icons and Description

View Menu/Icons Description

Columns

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

Detach and Detach icon Detach icon

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

Sort

You can sort columns by the following options:

  • Ascending

  • Descending

  • Advanced

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

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

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


Adding Merchandise Hierarchy

To add merchandise hierarchy:

  1. In the Fixed Deal window, go to Merchandise Hierarchy section.

  2. From the Actions menu, select Add or click the Add icon Add icon. The Add Merchandise Hierarchy window appears.

    Figure 6-48 Add Merchandise Hierarchy Window

    Surrounding text describes Figure 6-48 .
  3. In the Merchandise Level field, click the merchandise level list and select the merchandise level that the deal applies to. This field is a required field.

  4. In the Department field, select or search for the department.

  5. In the Class field, select or search for a class.

  6. In the Subclass field, select or search for a subclass.

  7. Then choose one of the following options.

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

    • Click OK and Add Another to add additional merchandise hierarchies.

    • Click Cancel to discard the changes and close the window.

Deleting Merchandise Hierarchy

To delete merchandise hierarchy:

  1. Select the merchandise hierarchy you want to delete.

  2. From the Actions menu, select Delete or click the Delete icon Delete icon.

    You are prompted to delete the record.

  3. Click Yes to confirm deletion.

  4. Click Cancel to retain the record.

Locations

The Locations section allows you to indicate at which locations the deal is effective.

Locations - Actions Menu and Icons

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

Figure 6-49 Locations - Actions Menu and Icons

Surrounding text describes Figure 6-49 .

Table 6-33 Locations - Actions Menu/Icons and Description

Actions Menu/Icons Description

Create and Create icon Add icon

You can add locations by clicking Create from the Actions menu or by clicking the Create icon Add icon.

For more information on adding locations, see the Creating Locations to a Fixed Deal section.

Delete and Delete icon Delete icon

You can delete locations, by clicking Delete from the Actions menu or by clicking the Delete icon Delete icon.

For more information on deleting locations, see the Deleting Locations section.

Export to Excel icon Export to excel icon

You can save the table to a Microsoft Excel spreadsheet by clicking the Export to Excel option from the Actions menu or by clicking the Export to Excel icon 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.

Figure 6-50 Locations - View Menu

Surrounding text describes Figure 6-50 .

Table 6-34 Locations - View Menu and Description

View Menu/Icons Description

Columns

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

Detach and Detach icon Detach icon

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

Sort

You can sort columns by the following options:

  • Ascending

  • Descending

  • Advanced

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

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

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


Creating Locations to a Fixed Deal

You can create locations when a fixed deal is created in the Fixed Deal window.

To create the locations to a fixed deal:

  1. In the Fixed Deal window, go to Locations section.

  2. From the Actions menu after entering the header details, click Create or click the Create icon Add icon. The Add Locations window appears.

    Figure 6-51 Add Locations Window

    Surrounding text describes Figure 6-51 .
  3. In the Type field, select the location type you want to add to the fixed deal. This field is a required field.

  4. In the Location field, enter, select or search for the location. You can also search for a location through Basic or Advanced search.

  5. In the Ratio field, indicate what percentage of fixed deal the location contributes.

  6. Then choose one of the following options.

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

    • Click OK and Add Another to add additional locations.

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

Deleting Locations

To delete locations:

  1. Select the locations you want to delete.

  2. From the Actions menu, click Delete or click the Delete icon Delete icon.

    You are prompted to delete the locations.

  3. Click Yes to confirm deletion.

  4. Click Cancel to retain the record.

Promotions

The Promotions window allows you to associate a fixed deal with promotions. You can attach multiple promotions to a fixed deal. The promotion is set up in the pricing system and can then be attached to the fixed deal.

Promotions - Actions Menu and Icons

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

Figure 6-52 Promotions - Actions Menu and Icons

Surrounding text describes Figure 6-52 .

Table 6-35 Promotions - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon Add icon

You can add promotions by clicking Add from the Actions menu or by clicking the Add icon Add icon.

For more information on adding promotions, see the Adding Promotions to a Fixed Deal section.

Delete and Delete icon Delete icon

You can delete promotions, by clicking Delete from the Actions menu or by clicking the Delete icon Delete icon.

For more information on deleting promotions, see the Deleting Fixed Deal Promotions section.

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

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


Promotions - View Menu and Icons

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

Figure 6-53 Promotions - View Menu and Icons

Surrounding text describes Figure 6-53 .

Table 6-36 Promotions - View Menu/ Icons and Description

View Menu/Icons Description

Columns

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

Detach and Detach icon Detach icon

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

Sort

You can sort columns by the following options:

  • Ascending

  • Descending

  • Advanced

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

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

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


Adding Promotions to a Fixed Deal

To add promotions to a fixed deal:

  1. In the Fixed Deal window, go to Promotions section.

  2. From the Actions menu, click Add or click the Add icon Add icon. The Add Promotions window appears.

    Figure 6-54 Add Promotions Window

    Surrounding text describes Figure 6-54 .
  3. In the Promotion field, enter, select or search for a promotion. You can also search for promotions through Basic or Advanced search.

  4. Then choose one of the following options.

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

    • Click OK and Add Another to add additional promotions.

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

Deleting Fixed Deal Promotions

To delete fixed deal promotions:

  1. Select the fixed deal promotions you want to delete.

  2. From the Actions menu, click Delete or click the Delete icon Delete icon.

    You are prompted to delete the record.

  3. Click Yes to confirm deletion.

  4. Click Cancel to retain the record.

Fixed Deals Toolbar

The toolbar contains the following icons and buttons.

Figure 6-55 Fixed Deal Toolbar

Surrounding text describes Figure 6-55 .

Table 6-37 Fixed Deal Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon Help icon

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

Delete icon Delete icon

You can delete the fixed deal by clicking the Delete icon Delete icon.

Deactivate Deactivate button button

You can deactivate a fixed deal by clicking the Deactivate button.

Activate Activate button button

You can Activate a fixed deal bu clicking the Activate button.

Proof of Performance POP button button

You can access the Terms Definition and Fulfillment sections by clicking the Proof of Performance button.

For information on Terms Definition and Fulfillment, see the Fixed Deal - Terms Definition and the Fixed Deal - Fulfillment section.

Save button

Click Save to save the created fixed deal.

Save and Close button

Click Save and Close to save the deal an close the Fixed Deal window.

Cancel button

Click Cancel to reject the deal and close the Fixed Deal window.


Fixed Deal - Terms Definition

The Terms Definition section is used to define proof of performance terms for a given fixed deal. These terms are defined by the deal partner that offers the deal.

Fixed Deal Terms Definition - Actions Menu and Icons

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

Figure 6-56 Fixed Deal Terms Definitions - Actions Menu and Icons

Surrounding text describes Figure 6-56 .

Table 6-38 Fixed Deal Terms Definition - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add and Add icon Add icon

You can add terms definition by clicking Add from the Actions menu or by clicking the Add icon Add icon.

For more information on adding terms definition, see the Adding Fixed Deal Terms Definition section.

Edit and Edit icon Edit icon

You can edit terms definition by clicking Edit from the Actions menu or by clicking the Edit icon Edit icon.

For more information on editing terms definition, see the Editing Fixed Deal Proof of Performance Terms Definition section.

Delete and Delete icon Delete icon

You can delete terms definition, by clicking Delete from the Actions menu or by clicking the Delete icon Delete icon.

For more information on deleting terms definition, see the Deleting Fixed Deal Proof of Performance Terms Definition section.

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

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

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.


Fixed Deal Terms Definition - View Menu and Icons

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

Figure 6-57 Fixed Deal Terms Definition - View Menu

Surrounding text describes Figure 6-57 .

Table 6-39 Fixed Deal Terms Definition - View Menu/Icons and Description

View Menu/Icons Description

Columns

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

Detach and Detach icon Detach icon

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

Sort

You can sort columns by the following options:

  • Ascending

  • Descending

  • Advanced

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

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

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


Adding Fixed Deal Terms Definition

To add fixed deal terms definition:

  1. From the Tasks menu, select Orders > Deals > Create Fixed Deal. The Fixed Deal window appears.

  2. Click Proof of Performance.

    The Proof of Performance window appears which includes the Terms Definition and Fulfillment sections.

  3. From the Actions menu, click Add or click the Add icon Add icon. The Add Terms window appears.

    Figure 6-58 Add Terms Window

    Surrounding text describes Figure 6-58 .
  4. In the Type field, select what must be done to comply with the terms of the deal.

  5. In the Duration field, enter the duration for which the terms will be valid.

  6. In the Duration Type field, select the period of time that you have to comply to the terms of the deal.

  7. In the Deal Ref. Item field, enter the deal reference item or search for and select the deal reference item.

  8. In the Recommended Start and End date fields, enter the vendor's recommended start and end dates or click the calendar icon and select the dates.

  9. In the Planned Start and End date fields, enter the date you intend to start and end complying or click the calendar icon and select the dates.

  10. In the Comments field, add a comment if necessary.

  11. Then choose one of the following options.

    • Click OK to the terms and close the window.

    • Click OK and Add Another to add additional terms.

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

Editing Fixed Deal Proof of Performance Terms Definition

To edit proof of performance terms definition:

  1. Select the proof of terms definition you want to edit.

  2. From the Actions menu, click Edit or click the Edit icon Edit icon.

    The Edit Terms window appears.

  3. Edit the enabled fields as necessary.

  4. Click OK to save the changes.

Deleting Fixed Deal Proof of Performance Terms Definition

To delete proof of performance terms definition:

  1. Select the proof of performance you want to delete.

  2. From the Actions menu, click Delete or click the Delete icon Delete icon.

    You are prompted to delete the proof of performance term.

  3. Click Yes to confirm deletion.

  4. Click Cancel to retain the record.

Fixed Deal - Fulfillment

The Fixed Deal Fulfillment section is used to record or view proof of performance term fulfillment for a fixed deal.

Recording the fulfillment of these terms is a manual process and no fulfillment is calculated from other merchandising transactions.

An example: A supplier may define a proof of performance stating: "In order to qualify for the deal, the retailer needs to promote the item by displaying it on an end cap for 28 days." You may want to enter the start and end dates of the display period and/or promotion as a proof of performance fulfillment requirement.

Fixed Deal Fulfillment - Actions Menu and Icons

Figure 6-59 Fixed Deal Fulfillment - Actions Menu and Icons

Surrounding text describes Figure 6-59 .

Table 6-40 Fixed Deal Fulfillment - Actions Menu/Icons and Description

Actions Menu/Icon Description

Add and Add icon Add icon

You can add fulfillment by clicking Add from the Actions menu or by clicking the Add icon Add icon.

For more information on adding fulfillment, see the Adding Fixed Deal Proof of Performance Fulfillment section.

Delete and Delete icon Delete icon

You can delete fulfillment, by clicking Delete from the Actions menu or by clicking the Delete icon Delete icon.

For more information on deleting terms definition, see the Deleting Fixed Deal Proof of Performance Fulfillment section.

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

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

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.


Fixed Deal Fulfillment - View Menu and Icons

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

Figure 6-60 Fixed Deal Fulfillment - View Menu

Surrounding text describes Figure 6-60 .

Table 6-41 Fixed Deal Fulfillment - View Menu/Icons and Description

View Menu/Icons Description

Columns

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

Detach and Detach icon Detach icon

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

Sort

You can sort columns by the following options:

  • Ascending

  • Descending

  • Advanced

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

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

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

Query by Example

You can filter the fulfillment by one of multiple column values by clicking the query by example icon Query icon.


Adding Fixed Deal Proof of Performance Fulfillment

To add fixed deal proof of performance fulfillment:

  1. From the Tasks menu, select Orders > Deals > Create Fixed Deal. The Fixed Deal window appears.

  2. Click Proof of Performance.

    The Proof of Performance window appears which includes the Terms Definition and Fulfillment sections.


  3. Note:

    You can add fulfillment only if you add terms definition.

  4. From the Actions menu, click Add or click the Add icon Add icon.

    The Add Fulfillment window appears.

    Figure 6-61 Add Fulfillment Window

    Surrounding text describes Figure 6-61 .
  5. In the Promotion field, enter, select or search for a promotion.

  6. In the Dates area:

    • In the Start Date field, enter the start date of the promotion, or click the calendar icon and select a date.

    • In the End Date field, enter the end date of the promotion, or click the calendar icon and select a date.

  7. Then choose one of the following options.

    • Click OK to the fulfillment and close the window.

    • Click OK and Add Another to add fulfillments.

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

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

Deleting Fixed Deal Proof of Performance Fulfillment

To delete fixed deal proof of performance fulfillment:

  1. Select the proof of performance you want to delete.

  2. From the Actions menu, click Delete or click the Delete icon Delete icon.

    You are prompted to delete the proof of performance fulfillment.

  3. Click Yes to confirm deletion.

  4. Click Cancel to retain the record.

Managing a Fixed Deal

The Manage Fixed Deals option opens the Fixed Deal Search window. Managing a fixed deal involves performing one or more of the following tasks:

  • Searching for a fixed deal

  • Creating a fixed deal

  • Editing a fixed deal

  • Viewing a fixed deal

On clicking the Manage Fixed Deal link by selecting Orders > Deals > Manage Fixed Deal, the Fixed Deal Search window appears.

In the Fixed Deal Search window you can search, add, create, view, export to Excel, query by example, and detach deals. You can also create deals for items on a specific purchase order.

The Fixed Deal Search window includes the following sections:

Figure 6-62 Fixed Deal Search Window

Surrounding text describes Figure 6-62 .

Searching for a Fixed Deal

To search for a fixed deal:

  1. From the Tasks menu, select Orders > Deals > Manage Fixed Deal. The Fixed Deal Search window appears.

  2. You can search a fixed deal by providing search criteria in the search section. The criteria can be provided either Basic or Advanced mode, depending on the requirement. Basic is the default mode when the search window is entered. Click Advanced to access the search panel in advanced mode. You can return to Basic mode by clicking Basic.

Searching For a Fixed Deal Through the Basic Search Criteria

To search for a fixed deal through the basic search criteria:

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

    Table 6-42 Fixed Deal Search - Basic Search Criteria and Description

    Search Field Description

    Match

    You can match your search criteria by selecting All or Any radio button.

    • All - Only deals matching all entered search criteria are shown.

    • Any - Deals matching each entered search criteria are shown.

    Deal

    Enter the deal ID.

    Description

    Enter the description of the deal.

    Deal Type

    This is the reason for the payment and does not drive any functionality. However, it allows the quick grouping of fixed deals for custom reporting. The options are: Cancel Allowance, Allowance Non Performance, Display Allowance, Early Buy Allowance, New Discount, New Warehouse, Lump Sum, New Item Allowance, Slotting Allowance, New Distribution Allowance, Advertising Allowance, Other Allowance, Scan Based Allowance.

    Status

    Select the status of the deal. The options are: Active and Inactive.

    Partner

    Enter, select or search for the type of partner for which you are creating the fixed deal.

    Supplier

    Enter, select or search for the supplier ID for which you want to create a fixed deal.

    First Collect Date

    Enter the date, or click the Calendar icon and select the date.

    Last Collect Date

    Enter the date, or click the Calendar icon and select the date.


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

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

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

  3. Click Search. The fixed deals 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 a Fixed Deal Through the Advanced Search Criteria

To search a fixed deal through the advanced search criteria:

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

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

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

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

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

  4. Click Search. The fixed deals 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 fixed deals.

Results - Actions Menu and Icons

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

Figure 6-63 Results - Actions Menu and Icons

Surrounding text describes Figure 6-63 .

Table 6-43 Results - Actions Menu/Icons and Description

Actions Menu/Icons Description

Create and Create icon Create icon

You can create a fixed deal by clicking Create from the Actions menu or by clicking the Create icon Create icon.

For more information on creating a fixed deal, see the Creating a Fixed Deal section.

Edit and Edit icon Edit icon

You can edit a fixed deal by clicking Edit from the Actions menu or by clicking the Edit icon Edit icon.

For more information on editing a fixed deal, see the Editing a Fixed Deal section.

View and View icon View icon

You can view a fixed deal by clicking View from the Actions menu or by clicking the View icon View icon.

For more information on viewing a fixed deal, see the Viewing a Fixed Deal section.

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

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


Results - View Menu and Icons

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

Figure 6-64 Results - View Menu and Icons

Surrounding text describes Figure 6-64 .

Table 6-44 Manage Fixed Deal Results Section - View Menu and Description

View Menu List Description

Columns

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

Detach and Detach icon Detach icon

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

Sort

You can sort columns by the following options:

  • Ascending

  • Descending

  • Advanced

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

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

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


Fixed Deal Search Toolbar

The toolbar contains the following icons and buttons.

Table 6-45 Fixed Deal Search Toolbar - Icons/Buttons and Description

Icons/Buttons Description

Help icon Help icon

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

Done

Click Done to close the window.


Creating a Fixed Deal

To create a fixed deal:

  1. From the Tasks menu, select Orders > Deals > Manage Fixed Deal. The Fixed Deal Search window appears.

  2. From the Actions menu, select Create or click the Create icon Create icon. The Fixed Deal widow appears.

    Figure 6-65 Fixed Deal Window

    Surrounding text describes Figure 6-65 .

    For more information on how to create a fixed deal, see the Creating a Fixed Deal section.

Editing a Fixed Deal

To edit a Fixed deal:

  1. From the Tasks menu, select Orders > Deals > Manage Fixed Deal. The Fixed Deal Search window appears.

  2. Select the deal you want to edit.

  3. From the Actions menu, select Edit or click the Edit icon Edit icon. The Fixed Deal window appears.

    Figure 6-66 Fixed Deal Window in Edit Mode

    Surrounding text describes Figure 6-66 .
  4. Make the necessary changes and click Save to save the changes.

Viewing a Fixed Deal

To view a fixed deal:

  1. From the Tasks menu, select Orders > Deals > Manage Fixed Deal. The Fixed Deal Search window appears.

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

  3. Select the deal you want to view.

  4. From the Actions menu, select View or click the View icon View icon. The Fixed Deal window appears.

    Figure 6-67 Fixed Deal Window in View Mode

    Surrounding text describes Figure 6-67 .
  5. Click Done to close the window.

Managing a Fixed Deal

To manage a fixed deal use the Actions menu, View menu and icons in the Merchandise Hierarchy section.

You can access the Terms Definition and Fulfillment sections by clicking the Proof of Performance button. For information on Terms Definition and Fulfillment of a fixed deal, see the Fixed Deal - Terms Definition and the Fixed Deal - Fulfillment section.

Merchandise Hierarchy Table - Actions Menu and Icons

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

Figure 6-68 Merchandise Hierarchy Table - Actions Menu and Icons

Surrounding text describes Figure 6-68 .

Table 6-46 Merchandise Hierarchy Table - Actions Menu/Icons and Description

Actions Menu/Icons Description

Add, Create, Add and Create icon Add icon

You can add merchandise hierarchy and create locations by clicking Add or Create from the Actions menu or by clicking the Add or Create icon Add icon.

For more information, see the following sections:

Delete and Delete icon Delete icon

You can delete merchandise hierarchy and locations, by clicking Delete from the Actions menu or by clicking the Delete icon Delete icon.

For more information, see the following sections:

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.


Merchandise Hierarchy Table - View Menu and Icons

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

Figure 6-69 Merchandise Hierarchy Table - View Menu

Surrounding text describes Figure 6-69 .

Table 6-47 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 Detach icon

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

Sort

You can sort columns by the following options:

  • Ascending

  • Descending

  • Advanced

Reorder Columns

You can reorder columns by clicking the Reorder Columns option.

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

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