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.
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:
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:
From the Tasks menu, select Orders > Deals > Create Deal. The Create Deal window appears.
The deal number is displayed by default.
In the Vendor field, select the vendor type, enter, select or search for the deal vendor.
In the Currency field, enter, select or search for the currency.
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.
In the Active Date field, enter the date on which the deal becomes active, or click the calendar icon and select the date.
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. |
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.
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.
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.
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.
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.
In the Ref. No. field, enter a number.
In the Comments field, enter any additional comments as necessary.
Click OK to save any changes. The Deal window appears.
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 on the Deal Search window. |
You can also create PO specific deals. To create a PO-Specific Deal, follow the steps listed below.
From the Tasks menu, select Orders > Manage Orders. The Order Search window appears.
Enter or select search criteria as desired to make the search more restrictive.
Click Search. The orders that match the search criteria are displayed in the Results section.
In the Order column, click the order link, or mark a record and select Actions > Edit, or use the Edit icon . The Order window appears.
In the Orders toolbar, click Details. The Order Details window appears.
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.
In the Threshold Limit Type field, select how the threshold is defined.
Click OK to save any changes. The Deal window appears.
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:
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. |
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. |
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. |
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. |
Use the Actions Menu and icons to apply actions to the table. You can perform the actions listed below.
Table 6-4 Components - Actions Menu/Icons and Description
Actions Menu/Icons | Description |
---|---|
Add and Add icon |
You can add a deal component by clicking Add from the Actions menu or by clicking the Add icon . For more information on adding a deal component, see the Adding Deal Components section. |
Edit and Edit icon |
You can edit a deal component by clicking Edit from the Actions menu or by clicking the Edit icon . For more information on editing a deal component, see the Editing a Deal Component section. |
Delete and Delete icon |
You can delete a deal component, by clicking Delete from the Actions menu or by clicking the 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 |
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 . |
Table 6-5 Components - More Icons and Description
More Icons | Description |
---|---|
Move Up and Down Icon Button |
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 . |
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 . |
You can customize the view of the table by using the options in the View Menu.
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 |
You can view the tables in the application in a separate window by clicking Detach or by using the Detach icon . |
Sort |
You can sort columns by the following options:
|
Reorder Columns |
You can reorder columns by clicking the Reorder Columns option. |
Query by Example and Query by Example icon |
You can filter the items by one or multiple column values by clicking the Query by Example option or by using the Query by Example icon . |
You can add deal components to a deal while creating or editing in the Deal window.
To add deal components:
From the Tasks menu, select Orders > Deals > Create Deal. The Create Deal popup window appears.
Enter the relevant data and click OK to save the changes. The Deal window appears.
In the Deal window, go to the Components section.
From the Actions menu, click Add or click the Add icon . The Add Component window appears.
In the Type field, select the component type.
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.
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. |
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. |
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.
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.
In the Comments field, enter any additional comments as necessary.
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.
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.
The Buy/Get Item window is only enabled, if Threshold Value Type selected is Buy/Get free or discounted items for off-invoice deals.
To add buy/get item:
Click Buy/Get Item from the Components section. The Buy/Get Item window appears.
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.
Click OK to add the buy/get item information.
Click Cancel to return to the Deal window.
To edit a deal component:
Select the deal component you want to edit.
From the Actions menu, click Edit or click the Edit icon .
The Edit Component window appears.
Edit the enabled fields as necessary.
Click OK to return to Deal window.
Click Save or Save and Close to save the changes.
To delete a component:
Select the deal component you want to delete.
From the Actions menu, click Delete or click the Delete icon .
You are prompted to delete the deal component.
Click Yes to confirm deletion.
Click Save or Save and Close to save the changes.
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.
Use the Actions Menu and icons to apply actions to the table. You can perform the actions listed below.
Table 6-7 Item/Locations - Actions Menu/Icons and Description
Actions Menu/Icons | Description |
---|---|
Add and Add icon |
You can add an item/locations by clicking Add from the Actions menu or by clicking the Add icon . For more information on adding an item/location, see the Adding the Item/Locations to a Deal section. |
Delete and Delete icon |
You can delete an item/locations, by clicking Delete from the Actions menu or by clicking the 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 |
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 . |
You can customize the view of the table by using the options in the View Menu.
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 |
You can view the tables in the application in a separate window by clicking Detach or by using the Detach icon . |
Sort |
You can sort columns by the following options:
|
Reorder Columns |
You can reorder columns by clicking the Reorder Columns option. |
Query by Example and Query by Example icon |
You can filter the items by one or multiple column values by clicking the Query by Example option or by using the Query by Example icon . |
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:
From the Tasks menu, select Orders > Deals > Create Deal. The Create Deal popup window appears.
Enter the relevant data and click OK to save the changes. The Deal window appears.
In the Deal window, go to Item/Locations section.
From the Actions menu, click Add or click the Add icon . The Include/Exclude Item/Location window appears
Select the include or exclude option to determine if the record is being created for inclusion or exclusion.
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.
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.
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.
To delete an item/location:
Select the item/location you want to delete.
From the Actions menu, click Delete or click the Delete icon .
You are prompted to delete the deal component.
Click Yes to confirm deletion.
Click Cancel to retain the record.
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.
Use the Actions Menu and icons to apply actions to the table. You can perform the actions listed below.
Table 6-9 Thresholds - Actions Menu/Icons and Description
Actions Menu/Icons | Description |
---|---|
Add and Add icon |
You can add thresholds by clicking Add from the Actions menu or by clicking the Add icon . For more information on adding thresholds, see the Adding the Thresholds of a Deal section. |
Edit and Edit icon |
You can edit thresholds by clicking Edit from the Actions menu or by clicking the Edit icon . For more information on editing thresholds, see the Editing the Threshold of a Deal section. |
Delete and Delete icon |
You can delete thresholds, by clicking Delete from the Actions menu or by clicking the Delete icon . For more information on deleting thresholds, see the Deleting the Threshold section. |
Export to Excel and Export to Excel icon |
You can export the records in the table to a Microsoft Excel spreadsheet by selecting Actions > Export to Excel or by using the Export to Excel icon . |
You can customize the view of the table by using the options in the View Menu.
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 |
You can view the tables in the application in a separate window by clicking Detach or by using the Detach icon . |
Sort |
You can sort columns by the following options:
|
Reorder Columns |
You can reorder columns by clicking the Reorder Columns option. |
Query by Example and Query by Example icon |
You can filter the items by one or multiple column values by clicking the Query by Example option or by using the Query by Example icon . |
You can add thresholds to a deal component while creating or editing in the Deal window.
To add the thresholds of a deal:
From the Tasks menu, select Orders > Deals > Create Deal. The Create Deal popup window appears.
Enter the relevant data and click OK to save the changes. The Deal window appears.
In the Deal window, go to Thresholds section.
From the Actions menu, click Add or click the Add icon . The Add Threshold window appears.
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.
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.
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.
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.
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.
Click OK to add thresholds. You can add more thresholds by clicking OK and Add Another.
Click Cancel to return to the Thresholds section.
To edit the threshold of a deal:
Select the threshold you want to edit.
From the Actions menu, click Edit or click the Edit icon .
The Edit Threshold window appears.
Edit the enabled fields as necessary.
Click OK to return to Deal window.
Click Save or Save and Close to save the changes.
To delete the threshold:
Select the threshold you want to delete.
From the Actions menu, click Delete or click the Delete icon .
You are prompted to delete the record.
Click Yes to confirm deletion.
Click Save or Save and Close to save the changes.
The threshold revisions popup is visible when revisions exist for a threshold.
To view the threshold revisions popup:
From the Tasks menu, select Orders > Deals > Create Deal. The Create Deal window appears.
Enter the relevant data and click OK to save the changes. The Deal window appears.
In the Deal window, go to Thresholds section and then click Revisions. The Threshold Revisions popup appears.
To add comments to a deal:
In the Comments section, enter your comments.
Click Save to save your changes or click Save and Close to save and close the window.
Click Cancel to discard the changes and close the 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.
To view deal performance:
From the Tasks menu, select Orders > Deals > Create Deal. The Create Deal window appears.
Enter the relevant data and click OK to save the changes.
The Deal window appears.
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.
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. |
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.
Use the Actions Menu and icons to apply actions to the table. You can perform the actions listed below.
Table 6-12 Total - Actions Menu/Icons and Description
Actions Menu/Icons | Description |
---|---|
Edit and 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 . For more information on editing thresholds, see the Editing Total of a Deal Component section. |
Export to Excel and Export to Excel icon |
You can export the records in the table to a Microsoft Excel spreadsheet by selecting Actions > Export to Excel or by using the Export to Excel icon . |
You can customize the view of the table by using the options in the View Menu.
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 |
You can view the tables in the application in a separate window by clicking Detach or by using the Detach icon . |
Sort |
You can sort columns by the following options:
|
Reorder Columns |
You can reorder columns by clicking the Reorder Columns option. |
Query by Example and Query by Example icon |
You can filter the items by one or multiple column values by clicking the Query by Example option or by using the Query by Example icon . |
To edit total of a deal component:
From the More Actions menu, click Deal Income. The Deal Performance window appears, which includes the Total section.
From the Actions menu, click Edit or click the Edit icon . The Edit Components Total window appears.
In the Baseline field Turnover sub section, enter or edit the previous year's turnover.
In the Budget field Turnover sub section, enter or edit the expected amount of turnover.
In the Actuals/Forecast field Turnover sub section, enter or edit the actuals or forecast amount.
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. |
In the Target Baseline Growth % field, enter the percentage you expect the baseline to grow.
Click Apply Growth%.
Click OK to save any changes and close the window.
Click Cancel to discard the changes and close the window.
Note:
This applies for both total and periods section. |
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.
Use the Actions Menu and icons to apply actions to the table. You can perform the actions listed below.
Table 6-14 Periods - Actions Menu/Icons/Buttons and Description
Actions Menu/Icons/Buttons | Description |
---|---|
Edit and 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 . For more information on editing periods, see the Editing Periods of a Deal Component section. |
Export to Excel and Export to Excel icon |
You can export the records in the table to a Microsoft Excel spreadsheet by selecting Actions > Export to Excel or by using the Export to Excel icon . |
Copy 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. |
You can customize the view of the table by using the options in the View Menu.
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 |
You can view the tables in the application in a separate window by clicking Detach or by using the Detach icon . |
Sort |
You can sort columns by the following options:
|
Reorder Columns |
You can reorder columns by clicking the Reorder Columns option. |
Query by Example and Query by Example icon |
You can filter the items by one or multiple column values by clicking the Query by Example option or by using the Query by Example icon . |
To edit periods of a deal component:
From the More Actions menu of the Deals window, click Deal Income. The Deal Performance window appears, which includes the Periods section
From the Actions menu, click Edit or click the Edit icon . The Edit Period window appears.
In the Baseline field Turnover sub section, enter or edit the previous year's turnover.
In the Budget field Turnover sub section, enter or edit the expected amount of turnover.
In the Actuals/Forecast field Turnover sub section, enter or edit the actuals or forecast amount.
The total check boxes are view only. They would be checked if the totals for them have been checked fixed in the totals table.
Click OK to save any changes and close the window.
Click Cancel to discard the changes and close the window.
The toolbar contains the following icons and buttons.
Table 6-16 Deal Toolbar - Icons/Buttons and Description
Icons/Buttons | Description |
---|---|
Help icon |
You can access online help for a particular page by clicking the Help icon. |
Expand and Collapse icons |
You can expand all the sections and collapse all the sections in the Deal window by clicking the Expand and Collapse icons. |
Delete icon |
You can delete a deal by clicking the 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. |
Use the More Actions menu to navigate to the following windows. The More Actions menu contains the following options.
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:
|
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.
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:
From the Tasks menu, select Orders > Deals > Create Deal. The Create Deal window appears.
Enter the relevant data and click OK to save the changes. The Deal window appears.
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.
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. |
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.
Use the Actions Menu and icons to apply actions to the table. You can perform the actions listed below.
Table 6-19 Terms Definition - Actions Menu/Icons and Description
Actions Menu/Icons | Description |
---|---|
Add and Add icon |
You can add terms definition by clicking Add from the Actions menu or by clicking the Add icon . For more information on adding terms definition, see the Adding Proof of Performance Terms Definition section. |
Edit and Edit icon |
You can edit terms definition by clicking Edit from the Actions menu or by clicking the Edit icon . For more information on editing terms definition, see the Editing Proof of Performance Terms Definition section. |
Delete and Delete icon |
You can delete terms definition, by clicking Delete from the Actions menu or by clicking the 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 |
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 . |
You can customize the view of the table by using the options in the View Menu.
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 |
You can view the tables in the application in a separate window by clicking Detach or by using the Detach icon . |
Sort |
You can sort columns by the following options:
|
Reorder Columns |
You can reorder columns by clicking the Reorder Columns option. |
Query by Example and Query by Example icon |
You can filter the items by one or multiple column values by clicking the Query by Example option or by using the Query by Example icon . |
To add terms proof of performance definition:
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.
From the Actions menu, click Add or click the Add icon . The Add Terms window appears.
In the Type field, select type of performance term.
In the Duration field, enter the duration for the duration type for which the terms will be valid.
In the Duration Type field, select the period of time that you have to comply to the terms of the deal.
In the Deal Ref. Item field, enter the deal reference item or search for and select the deal reference item.
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.
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.
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.
To edit proof of performance terms definition:
Select the terms definition you want to edit.
From the Actions menu, click Edit or click the Edit icon . The Edit Terms window appears.
Edit the enabled fields as necessary.
Click OK to save the changes.
Click Cancel to discard the changes and close the window.
To delete proof of performance terms definition:
Select the terms definition you want to delete.
From the Actions menu, click Delete or click the Delete icon .
You are prompted to delete the proof of performance term.
Click Yes to confirm deletion.
Click No to retain the proof of performance term.
The fulfillment section is used to record or view proof of performance term fulfillment for a deal.
Use the Actions Menu and icons to apply actions to the table. You can perform the actions listed below.
Table 6-21 Fulfillment- Actions Menu/Icons and Description
Actions Menu/Icon | Description |
---|---|
Add and Add icon |
You can add fulfillments by clicking Add from the Actions menu or by clicking the Add icon . For more information on adding fulfillments, see the Adding Proof of Performance Fulfillment section. |
Delete and Delete icon |
You can delete fulfillments, by clicking Delete from the Actions menu or by clicking the Delete icon . For more information on deleting fulfillments, see the Deleting Proof of Performance Fulfillment section. |
Export to Excel and Export to Excel icon |
You can export the records in the table to a Microsoft Excel spreadsheet by selecting Actions > Export to Excel or by using the Export to Excel icon . |
You can customize the view of the table by using the options in the View Menu.
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 |
You can view the tables in the application in a separate window by clicking Detach or by using the Detach icon . |
Sort |
You can sort columns by the following options:
|
Reorder Columns |
You can reorder columns by clicking the Reorder Columns option. |
Query by Example and Query by Example icon |
You can filter the items by one or multiple column values by clicking the Query by Example option or by using the Query by Example icon . |
To add proof of performance fulfillment:
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. |
From the Actions menu, click Add or click the Add icon . The Add Fulfillment widow. The Add Fulfillment window appears.
In the Promotion field, enter, select or search for a promotion.
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.
In the Comments field, enter any additional comments as necessary.
Click OK to add fulfillment. You can add more fulfillment by clicking OK and Add Another.
Click Cancel to close the fulfillment window.
To delete proof of performance fulfillment:
Select the proof of performance you want to delete.
From the Actions menu, click Delete or click the Delete icon .
You are prompted to delete the proof of performance fulfillment.
Click Yes to confirm deletion.
Click Cancel to retain the record.
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.
Use the Actions Menu and icons to apply actions to the table. You can perform the actions listed below.
Table 6-23 Deal Promotions - Actions Menu/Icons and Description
Actions Menu/Icon | Description |
---|---|
Add and Add icon |
You can add deal promotions by clicking Add from the Actions menu or by clicking the Add icon . For more information on deal promotions, see the Adding Promotions to a Deal section. |
Delete and Delete icon |
You can delete deal promotions, by clicking Delete from the Actions menu or by clicking the Delete icon . For more information on deal promotions, see the Deleting Deal Promotions section. |
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 . |
Wrap icon |
You can wrap the values in the table column by using the Wrap icon option. |
You can customize the view of the table by using the options in the View Menu.
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 |
You can view the tables in the application in a separate window by clicking Detach or by using the Detach icon . |
Sort |
You can sort columns by the following options:
|
Reorder Columns |
You can reorder columns by clicking the Reorder Columns option. |
Query by Example and Query by Example icon |
You can filter the items by one or multiple column values by clicking the Query by Example option or by using the Query by Example icon . |
To add promotions to a deal:
From the More Actions menu, click Referenced Promotions.
The Deal Promotions window appears.
From the Actions menu, click Add or click the Add icon . The Add Promotions window appears
In the Promotion field, enter, select or search for a promotion.
Click OK to save any changes.
You can add more promotions by clicking OK and Add Another.
Click Cancel to discard the changes and close the window.
Click Save to save your changes or click Save and Close to save and close the window.
To delete deal promotions:
Select the deal promotions you want to delete.
From the Actions menu, click Delete or click the Delete icon .
You are prompted to delete the record.
Click Yes to confirm deletion.
Click Cancel to retain the record.
Deal Dates is a view only popup to show the dates related to a deal.
You can submit a deal when a deal is created and the deal is in Worksheet status.
To submit a deal:
From the Tasks menu, select Orders > Deals > Create Deal. The Create Deal window appears.
Click OK to save any changes. The Deal window appears.
In the Components section, select Actions > Add or click the Add icon .
The Add Component window appears.
Note: You need to enter the required information in the following sections before submitting a deal:
|
Enter all the required information and click Submit on the page level toolbar. The deal status changes to Submitted.
Click Save to save your changes or click Save and Close to save and close the window.
Click Cancel to discard the changes and close the Deal window.
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:
From the Tasks menu, select Orders > Deals > Create Deal. The Create Deal window appears.
Click OK to save any changes. The Deal window appears.
In the Components section, select Actions > Add or click the Add icon . The Add Component window appears.
Note: You need to enter the required information in the following sections before submitting a deal:
|
Enter all the required information and click Submit on the page level toolbar. The deal status changes to Submitted.
Click Approve. The status changes to Approved.
Click Save to save your changes or click Save and Close to save and close the window.
Click Cancel to discard the changes and close the Deal window.
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:
Search
For more information on the Deal Search window, see the Searching for a Deal section.
To search for a deal:
From the Tasks menu, select Orders > Deals > Manage Deal. The Deal Search window appears.
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.
To search for a deal through the basic search criteria:
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. |
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".
Click Search. The deals that match the search criteria are displayed in the Results section.
Click Search. The deals that match the search criteria are displayed in the Results section.
Click Reset to execute the saved search.
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".
Click Done to close the window.
To search for a deal through the advanced search criteria:
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. |
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.
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".
Click Search. The deals that match the search criteria are displayed in the Results section.
Click Reset to clear the search section and results.
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".
Click Done to close the window.
The Results section lists the retrieved deals.
Use the Actions Menu and icons to apply actions to the Results table. You can perform the actions listed below.
Table 6-27 Results - Actions Menu/Icons and Description
Actions Menu/Icons | Description |
---|---|
Create and Create icon |
You can create a deal by clicking Create from the Actions menu or by clicking the Create icon . For more information on creating a deal, see the Creating a Deal section. |
Create from Existing 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 . For more information on create from existing deal, see the Creating from an Existing Deal section. |
Edit and Edit icon |
You can edit a deal by clicking Edit from the Actions menu or by clicking the Edit icon . For more information on editing a deal, see the Editing a Deal section. |
View and View icon |
You can view a deal by clicking View from the Actions menu or by clicking the View icon . For more information on viewing a deal, see the Viewing a Deal section. |
Export to Excel and Export to Excel icon |
You can export the records in the table to a Microsoft Excel spreadsheet by selecting Actions > Export to Excel or by using the Export to Excel icon . |
You can customize the view of the table by using the options in the View Menu.
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 |
You can view the tables in the application in a separate window by clicking Detach or using the Detach icon . |
Reorder Columns |
You can reorder columns by clicking the Reorder Columns option. |
Query by Example and Query by Example icon |
You can filter the items by one or multiple column values by clicking Query by Example or using the Query by Example icon . |
The toolbar contains the following icons and buttons.
To create a deal, follow the steps below.
From the Tasks menu, select Orders > Deals > Manage Deal. The Deal Search window appears.
From the Actions menu, select Create or click the Create icon . The Create Deal window appears.
For more information on how to create a deal, see the Creating a Deal section
To create a deal from an existing deal, follow the steps below.
From the Tasks menu, select Orders > Deals > Manage Deal. The Deal Search window appears.
From the Actions menu, select Create from Existing or click the Create from Existing icon . The Create from Existing window appears.
Click OK to create a deal from an existing deal.
Click Cancel to return to Deal Search window.
To edit a deal, follow the steps below.
From the Tasks menu, select Orders > Deals > Manage Deal. The Deal Search window appears.
Select the deal you want to edit.
Select Actions > Edit, or click the Edit icon . The Deal window appears in Edit mode.
Make the necessary changes and click Done to save the changes.
To view a deal, follow the steps below.
From the Tasks menu, select Orders > Deals > Manage Deal. The Deal Search window appears.
Enter additional criteria as desired to make the search more restrictive.
Select the deal you want to view.
Click Done to close the window.
You can submit a deal when a deal is created and the deal is in Worksheet status.
To submit a deal:
From the Tasks menu, select Orders > Deals > Manage Deal. The Deal Search window appears.
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.
Select the deal that you wish to submit.
Select Actions > Edit or click the Edit icon . The Deal window appears.
Click Submit. The deal status changes to Submitted.
Click Save to save your changes or click Save and Close to save and close the window.
Click Cancel to discard the changes and close the window.
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:
From the Tasks menu, select Orders > Deals > Manage Deal. The Deal Search window appears.
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.
Select the deal that you wish to approve.
Select Actions > Edit or click the Edit icon . The Deal window appears.
Click Approve. The deal status changes to Approved.
Click Save to save your changes or click Save and Close to save and close the window.
Click Cancel to return to the Deal Search window.
To reject a deal:
From the Tasks menu, select Orders > Deals > Manage Deal. The Deal Search window appears.
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.
Select the deal that you wish to reject.
Select Actions > Edit or click the Edit icon . The Deal window appears.
Click Reject. The status changes to Reject.
Click Save to save your changes or click Save and Close to save and close the window.
Click Cancel to return to the Deal Search window.
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 on the Fixed Deal Search window. |
The Fixed Deal window includes the following sections:
Deal Collection
Invoice
If the deal is associated to the merchandise hierarchy, then the Merchandise Hierarchy section appears.
This section appears if you select Merchandise in the Deal header section.
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. |
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.
Use the Actions Menu and icons to apply actions to the table. You can perform the actions listed below.
Table 6-31 Merchandise Hierarchy - Actions Menu/Icons and Description
Actions Menu/Icons | Description |
---|---|
Add and Add icon |
You can add merchandise hierarchy by clicking Add from the Actions menu or by clicking the Add icon . For more information on adding a merchandise hierarchy, see the Adding Merchandise Hierarchy section. |
Delete and Delete icon |
You can delete merchandise hierarchy, by clicking Delete from the Actions menu or by clicking the Delete icon . For more information on deleting a merchandise hierarchy, see the Deleting Merchandise Hierarchy section. |
Export to Excel and Export to Excel icon |
You can export the records in the table to a Microsoft Excel spreadsheet by selecting Actions > Export to Excel or by using the Export to Excel icon . |
You can customize the view of the table by using the options in the View Menu.
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 |
You can view the tables in the application in a separate window by clicking Detach or by using the Detach icon . |
Sort |
You can sort columns by the following options:
|
Reorder Columns |
You can reorder columns by clicking the Reorder Columns option. |
Query by Example and Query by Example icon |
You can filter the items by one or multiple column values by clicking the Query by Example option or by using the Query by Example icon . |
To add merchandise hierarchy:
In the Fixed Deal window, go to Merchandise Hierarchy section.
From the Actions menu, select Add or click the Add icon . The Add Merchandise Hierarchy window appears.
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.
In the Department field, select or search for the department.
In the Class field, select or search for a class.
In the Subclass field, select or search for a subclass.
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.
To delete merchandise hierarchy:
Select the merchandise hierarchy you want to delete.
From the Actions menu, select Delete or click the Delete icon .
You are prompted to delete the record.
Click Yes to confirm deletion.
Click Cancel to retain the record.
The Locations section allows you to indicate at which locations the deal is effective.
Use the Actions Menu and icons to apply actions to the table. You can perform the actions listed below.
Table 6-33 Locations - Actions Menu/Icons and Description
Actions Menu/Icons | Description |
---|---|
Create and Create icon |
You can add locations by clicking Create from the Actions menu or by clicking the Create icon . For more information on adding locations, see the Creating Locations to a Fixed Deal section. |
Delete and Delete icon |
You can delete locations, by clicking Delete from the Actions menu or by clicking the Delete icon . For more information on deleting locations, see the Deleting Locations section. |
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 . |
You can customize the view of the table by using the options in the View Menu.
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 |
You can view the tables in the application in a separate window by clicking Detach or by using the Detach icon . |
Sort |
You can sort columns by the following options:
|
Reorder Columns |
You can reorder columns by clicking the Reorder Columns option. |
Query by Example and Query by Example icon |
You can filter the items by one or multiple column values by clicking the Query by Example option or by using the Query by Example icon . |
You can create locations when a fixed deal is created in the Fixed Deal window.
To create the locations to a fixed deal:
In the Fixed Deal window, go to Locations section.
From the Actions menu after entering the header details, click Create or click the Create icon . The Add Locations window appears.
In the Type field, select the location type you want to add to the fixed deal. This field is a required field.
In the Location field, enter, select or search for the location. You can also search for a location through Basic or Advanced search.
In the Ratio field, indicate what percentage of fixed deal the location contributes.
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.
To delete locations:
Select the locations you want to delete.
From the Actions menu, click Delete or click the Delete icon .
You are prompted to delete the locations.
Click Yes to confirm deletion.
Click Cancel to retain the record.
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.
Use the Actions Menu and icons to apply actions to the table. You can perform the actions listed below.
Table 6-35 Promotions - Actions Menu/Icons and Description
Actions Menu/Icons | Description |
---|---|
Add and Add icon |
You can add promotions by clicking Add from the Actions menu or by clicking the Add icon . For more information on adding promotions, see the Adding Promotions to a Fixed Deal section. |
Delete and Delete icon |
You can delete promotions, by clicking Delete from the Actions menu or by clicking the Delete icon . For more information on deleting promotions, see the Deleting Fixed Deal Promotions section. |
Export to Excel and Export to Excel icon |
You can export the records in the table to a Microsoft Excel spreadsheet by selecting Actions > Export to Excel or by using the Export to Excel icon . |
You can customize the view of the table by using the options in the View Menu.
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 |
You can view the tables in the application in a separate window by clicking Detach or by using the Detach icon . |
Sort |
You can sort columns by the following options:
|
Reorder Columns |
You can reorder columns by clicking the Reorder Columns option. |
Query by Example and Query by Example icon |
You can filter the items by one or multiple column values by clicking the Query by Example option or by using the Query by Example icon . |
To add promotions to a fixed deal:
In the Fixed Deal window, go to Promotions section.
From the Actions menu, click Add or click the Add icon . The Add Promotions window appears.
In the Promotion field, enter, select or search for a promotion. You can also search for promotions through Basic or Advanced search.
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.
To delete fixed deal promotions:
Select the fixed deal promotions you want to delete.
From the Actions menu, click Delete or click the Delete icon .
You are prompted to delete the record.
Click Yes to confirm deletion.
Click Cancel to retain the record.
The toolbar contains the following icons and buttons.
Table 6-37 Fixed Deal Toolbar - Icons/Buttons and Description
Icons/Buttons | Description |
---|---|
Help icon |
You can access online help for a particular page by clicking the Help icon. |
Delete icon |
You can delete the fixed deal by clicking the Delete icon . |
Deactivate button |
You can deactivate a fixed deal by clicking the Deactivate button. |
Activate button |
You can Activate a fixed deal bu clicking the Activate button. |
Proof of Performance 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. |
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.
Use the Actions Menu and icons to apply actions to the table. You can perform the actions listed below.
Table 6-38 Fixed Deal Terms Definition - Actions Menu/Icons and Description
Actions Menu/Icons | Description |
---|---|
Add and Add icon |
You can add terms definition by clicking Add from the Actions menu or by clicking the Add icon . For more information on adding terms definition, see the Adding Fixed Deal Terms Definition section. |
Edit and Edit icon |
You can edit terms definition by clicking Edit from the Actions menu or by clicking the Edit icon . For more information on editing terms definition, see the Editing Fixed Deal Proof of Performance Terms Definition section. |
Delete and Delete icon |
You can delete terms definition, by clicking Delete from the Actions menu or by clicking the 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 |
You can export the records in the table to a Microsoft Excel spreadsheet by selecting Actions > Export to Excel or by using the Export to Excel icon . |
Wrap icon |
You can wrap the values in the table column by first clicking the column on which you would like the text to wrap and then using the Wrap icon . |
You can customize the view of the table by using the options in the View Menu.
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 |
You can view the tables in the application in a separate window by clicking Detach or by using the Detach icon . |
Sort |
You can sort columns by the following options:
|
Reorder Columns |
You can reorder columns by clicking the Reorder Columns option. |
Query by Example and Query by Example icon |
You can filter the items by one or multiple column values by clicking the Query by Example option or by using the Query by Example icon . |
To add fixed deal terms definition:
From the Tasks menu, select Orders > Deals > Create Fixed Deal. The Fixed Deal window appears.
Click Proof of Performance.
The Proof of Performance window appears which includes the Terms Definition and Fulfillment sections.
From the Actions menu, click Add or click the Add icon . The Add Terms window appears.
In the Type field, select what must be done to comply with the terms of the deal.
In the Duration field, enter the duration for which the terms will be valid.
In the Duration Type field, select the period of time that you have to comply to the terms of the deal.
In the Deal Ref. Item field, enter the deal reference item or search for and select the deal reference item.
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.
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.
In the Comments field, add a comment if necessary.
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.
To edit proof of performance terms definition:
Select the proof of terms definition you want to edit.
From the Actions menu, click Edit or click the Edit icon .
The Edit Terms window appears.
Edit the enabled fields as necessary.
Click OK to save the changes.
To delete proof of performance terms definition:
Select the proof of performance you want to delete.
From the Actions menu, click Delete or click the Delete icon .
You are prompted to delete the proof of performance term.
Click Yes to confirm deletion.
Click Cancel to retain the record.
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.
Table 6-40 Fixed Deal Fulfillment - Actions Menu/Icons and Description
Actions Menu/Icon | Description |
---|---|
Add and Add icon |
You can add fulfillment by clicking Add from the Actions menu or by clicking the Add icon . For more information on adding fulfillment, see the Adding Fixed Deal Proof of Performance Fulfillment section. |
Delete and Delete icon |
You can delete fulfillment, by clicking Delete from the Actions menu or by clicking the 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 |
You can export the records in the table to a Microsoft Excel spreadsheet by selecting Actions > Export to Excel or by using the Export to Excel icon . |
Wrap icon |
You can wrap the values in the table column by first clicking the column on which you would like the text to wrap and then using the Wrap icon . |
You can customize the view of the table by using the options in the View Menu.
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 |
You can view the tables in the application in a separate window by clicking Detach or by using the Detach icon . |
Sort |
You can sort columns by the following options:
|
Reorder Columns |
You can reorder columns by clicking the Reorder Columns option. |
Query by Example and Query by Example icon |
You can filter the items by one or multiple column values by clicking the Query by Example option or by using the Query by Example icon . |
Query by Example |
You can filter the fulfillment by one of multiple column values by clicking the query by example icon . |
To add fixed deal proof of performance fulfillment:
From the Tasks menu, select Orders > Deals > Create Fixed Deal. The Fixed Deal window appears.
Click Proof of Performance.
The Proof of Performance window appears which includes the Terms Definition and Fulfillment sections.
Note: You can add fulfillment only if you add terms definition. |
From the Actions menu, click Add or click the Add icon .
The Add Fulfillment window appears.
In the Promotion field, enter, select or search for a promotion.
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.
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.
Click Save to save your changes or click Save and Close to save and close the window.
To delete fixed deal proof of performance fulfillment:
Select the proof of performance you want to delete.
From the Actions menu, click Delete or click the Delete icon .
You are prompted to delete the proof of performance fulfillment.
Click Yes to confirm deletion.
Click Cancel to retain the record.
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:
Search
For more information on the Fixed Deal Search window, see the Searching for a Fixed Deal section.
To search for a fixed deal:
From the Tasks menu, select Orders > Deals > Manage Fixed Deal. The Fixed Deal Search window appears.
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.
To search for a fixed deal through the basic search criteria:
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.
|
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. |
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".
Click Search. The fixed deals that match the search criteria are displayed in the Results section.
Click Reset to clear the search section and results.
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".
Click Done to close the window.
To search a fixed deal through the advanced search criteria:
To search using advanced search criteria, enter or select one or all of the advanced search criteria.
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.
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".
Click Search. The fixed deals that match the search criteria are displayed in the Results section.
Click Reset to clear the search section and results.
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".
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.
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.
Click Done to close the window.
The Results section lists the retrieved fixed deals.
Use the Actions Menu and icons to apply actions to the Results table. You can perform the actions listed below.
Table 6-43 Results - Actions Menu/Icons and Description
Actions Menu/Icons | Description |
---|---|
Create and Create icon |
You can create a fixed deal by clicking Create from the Actions menu or by clicking the Create icon . For more information on creating a fixed deal, see the Creating a Fixed Deal section. |
Edit and Edit icon |
You can edit a fixed deal by clicking Edit from the Actions menu or by clicking the Edit icon . For more information on editing a fixed deal, see the Editing a Fixed Deal section. |
View and View icon |
You can view a fixed deal by clicking View from the Actions menu or by clicking the 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 |
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 . |
You can customize the view of the table by using the options in the View Menu.
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 |
You can view the tables in the application in a separate window by clicking Detach or using the Detach icon . |
Sort |
You can sort columns by the following options:
|
Reorder Columns |
You can reorder columns by clicking the Reorder Columns option. |
Query by Example and Query by Example icon |
You can filter the items by one or multiple column values by clicking Query by Example or using the Query by Example icon . |
The toolbar contains the following icons and buttons.
To create a fixed deal:
From the Tasks menu, select Orders > Deals > Manage Fixed Deal. The Fixed Deal Search window appears.
From the Actions menu, select Create or click the Create icon . The Fixed Deal widow appears.
For more information on how to create a fixed deal, see the Creating a Fixed Deal section.
To edit a Fixed deal:
From the Tasks menu, select Orders > Deals > Manage Fixed Deal. The Fixed Deal Search window appears.
Select the deal you want to edit.
From the Actions menu, select Edit or click the Edit icon . The Fixed Deal window appears.
Make the necessary changes and click Save to save the changes.
To view a fixed deal:
From the Tasks menu, select Orders > Deals > Manage Fixed Deal. The Fixed Deal Search window appears.
Enter additional criteria as desired to make the search more restrictive.
Select the deal you want to view.
From the Actions menu, select View or click the View icon . The Fixed Deal window appears.
Click Done to close the window.
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.
Use the Actions Menu and icons to apply actions to the Results table. You can perform the actions listed below.
Table 6-46 Merchandise Hierarchy Table - Actions Menu/Icons and Description
Actions Menu/Icons | Description |
---|---|
Add, Create, Add and Create 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 . For more information, see the following sections: |
Delete and Delete icon |
You can delete merchandise hierarchy and locations, by clicking Delete from the Actions menu or by clicking the Delete icon . For more information, see the following sections: |
Export to Excel and Export to Excel icon |
You can export the records in the table to a Microsoft Excel spreadsheet by selecting Actions > Export to Excel or by using the Export to Excel icon . |
You can customize the view of the table by using the options in the View Menu.
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 |
You can view the tables in the application in a separate window by clicking Detach or using the Detach icon . |
Sort |
You can sort columns by the following options:
|
Reorder Columns |
You can reorder columns by clicking the Reorder Columns option. |
Query by Example and Query by Example icon |
You can filter the items by one or multiple column values by clicking Query by Example or using the Query by Example icon . |