Loading
The Trailblazer Community is now read-only Read More
View Agreement Terms Data in the Sales Agreements Table

View Agreement Terms Data in the Sales Agreements Table

The sales agreement table shows the metric values for products or categories across various schedules in the sales agreement. Track specific sales agreement term values by viewing the terms for a metric group or for all schedules. Easily compare metrics for products across various schedules with minimum scrolls. Filter sales agreement data by products or categories, or by time period. Use keyboard shortcuts to quickly navigate through your data and perform key actions.

Required Editions

Available in: Lightning Experience
Available in: Enterprise, Unlimited, and Developer Editions
User Permissions Needed
To view sales agreement terms: Manufacturing Sales Agreements Psl permission set

The sales agreement table includes these features:

  • Frozen Columns: The Product Name, Metric, and Total columns stay visible while you scroll across various schedules in the agreement. This feature ensures that you don’t lose context of the product and metrics, and don’t make data entry errors.
  • Merged Product Name Cells: The cells with the product names are merged so you can easily identify the metrics for each product.
  • Keyboard Shortcuts: You can quickly perform key actions such as editing a cell, saving your changes, and redoing your changes. See Keyboard Actions for Sales Agreement Data.
Note
Note To use the legacy view on a sales agreement’s record page, turn on Legacy View on the Agreement Terms tab. The legacy view does not include the latest performance, usability, and accessibility improvements.

Get an Enhanced View for the Sales Agreement Table

Swiftly track and maintain your sales agreement data by using the enhanced view of the sales agreement table. The enhanced view for the sales agreement table is enabled by default.

The enhanced view comes with these features.

  • Frozen Columns: The Product Name, Metric, and Total columns stay visible while you scroll across various schedules in the agreement. This feature ensures that you don’t lose context of the product and metrics, and don’t make data entry errors.
  • Merged Product Name Cells: The cells with the product names are merged so you can easily identify the metrics for each product.
  • Keyboard Shortcuts: You can quickly perform key actions such as editing a cell, saving your changes, and redoing your changes. See View Agreement Terms Data in the Sales Agreements Table.

If needed, you can switch to the legacy view for sales agreement data. To use the legacy view on a sales agreement’s record page, turn on Legacy View on the Agreement Terms tab. The legacy view for sales agreements doesn’t include the features that come with the enhanced view for sales agreements.

Note
Note We recommend that you use the enhanced view to make the most of the performance, usability, and accessibility enhancements.

Use Display Names for Sales Agreements Products

If key account managers specify display names for products or categories in sales agreements, then the display names are shown in the sales agreement table. If they don't specify display names, then the default names for the products or categories are shown.

Key account managers can add a product multiple times to a sales agreement by giving each instance a unique display name. For duplicate products, they must select one of the product instances as the primary product to be used for actuals calculation.

View Sales Agreement Data for a Metric Group

Use metric groups to view the agreement terms for specific metrics. Your admin can create metric groups that include selected metrics based on your business needs.

To view the data for selected metrics that are part of a metric group on the sales agreement table, select the metric group from the Metric Group field.

For example, to view forecasts specific to the revenue measures that are part of a group, select Revenue Metrics.

View data by metric groups
The data for the default metric group is shown in the sales agreement table. If your admin doesn't specify a default group in the Sales Agreements settings in Setup, the data for the first group in the alphabetically sorted order is shown.

View Sales Agreement Data for All Schedules

The sales agreement table shows the agreement terms for only eight periods, by default. You can choose to view agreement terms for all schedules.

On the Agreement Terms tab of a sales agreement, click Show All Schedules.
The agreement terms for all schedules are shown.

View Attributes for a Sales Agreement Product

Click a product name in sales agreements table and view the attributes, pricing, and other key details of products in sales agreements in a single panel.

Easily track customers' preferred product configurations and differentiate between the same products with different attributes in an agreement. You can also track critical quantity and revenue metrics for products and categories in the panel.

View Revised Sales Agreement Data

After you add or update the products or categories in an activated sales agreement, view the agreement terms for all items, items with edits, and recently added items. Switch the views on the Agreement Terms tab.

  1. On the Agreement Terms tab of an updated product-based sales agreement, choose one of these options.
    • All Products
    • Products with Edits
    • Recently Added Products
    The views of a sales agreement's terms.
    The agreement terms grid shows the metrics for the selected products.
  2. On the Agreement Terms tab of an updated category-based sales agreement, choose one of these options.
    • All Categories
    • Categories with Edits
    • Recently Added Categories
    The agreement terms grid shows the metrics for the selected categories.

View Adjustments in Sales Agreement Values

After setting up tracking for sales agreement adjustments, you can view the previous and updated values, user details, and any adjustment notes when users modify metric values in the Agreement Terms grid or through mass update processes.

  1. On a sales agreement’s record page, click Agreement Terms.
  2. Click Change in Value icon in a cell.
    The icon indicates that the value in the cell has been modified. In the popover, you can view the previous and updated values, along with the User ID, date and time of each adjustment, and any adjustment notes.

Get an Expanded View of Sales Agreement Data

Get a larger, focused view into the agreement terms of a sales agreement by opening the terms on a separate window.

On a sales agreement’s record page, on the Agreement Terms tab, click Expand icon.
The agreement terms appear on a separate window with the data for all schedules.

Filter Sales Agreement Data

Filter the agreement terms in the sales agreement table to quickly locate specific products, schedules, or metrics. You can apply multiple filter conditions to narrow results by product-related attributes, schedules, and time periods.

  1. On a sales agreement’s record page, on the Agreement Terms tab, click Filter icon.
  2. To filter agreement terms by product-related fields, such as products or other product attributes, search for and select the required values. You can also filter using any field from Sales Agreement Product Schedules, including custom fields.
  3. To filter agreement terms by schedules, select one or more schedules to display only the relevant periods in the agreement terms grid.
  4. To filter agreement terms by time period, select an option.
    Option Description
    Range Shows the forecast for a specified range.
    Set Periods Shows the forecast for up to eight selected periods.

    When no specific time period filter is applied, the system automatically defaults to the Current Period.

  5. Apply the filter.
Example
Example Example: An account manager for a manufacturing company wants to review the performance of specific products and metrics for the upcoming quarter. The agreement includes products such as Industrial Drills and Compact Saws, with tracked metrics including Planned Quantity and Sales Price.
Filter By Output
Product Category: Power Tools Shows only Industrial Drills. All products in other categories, such as Hand Tools, are hidden.
Metric: Sales Price Shows only the Sales Price rows for each product. Quantity based metrics are hidden.
Schedules: Jan, Feb, Mar Shows only the data for the first three months of the year.
Time Period: Current Periods Shows data for the current month and the subsequent 7 months.
Note
Note If you are in the Legacy View, the features such as filtering by product-related fields, schedules, and time periods are not available.

The sales agreement table can display up to 20 product lines per page, allowing users to review and update large agreements more efficiently with fewer page loads. If you are in the Legacy View, this feature is not available, and only 5 product lines per page are shown.

Keyboard Actions for Sales Agreement Data

Navigate through your sales agreement data and quickly perform key actions by using your keyboard. Use shortcuts to save changes, undo changes, edit a cell, and so on. To use keyboard actions, you must use the enhanced view for sales agreements.

Review the list of keyboard commands for the actions that you can perform on the sales agreement data.

Action Command
Save your changes

Ctrl + S (Windows/Linux)

Cmd + S (macOS)

Undo your changes

Ctrl + Z (Windows/Linux)

Cmd + Z (macOS)

Redo your changes

Ctrl + Y (Windows/Linux)

Cmd + Shift + Z (macOS)

Cycle actions on the Agreement Terms tab

Tab or Tab + Shift (Windows/Linux)

Tab or Tab + Shift (macOS)

Edit a cell

Enter (Windows/Linux)

Return (macOS)

Stop editing a cell or exit the expanded view

Escape (Windows/Linux)

Escape (macOS)

Move to the cell above

Arrow key ↑ (Windows/Linux)

Arrow key ↑ (macOS)

Move to the cell below

Arrow key ↓ (Windows/Linux)

Arrow key ↓ (macOS)

Move to the next cell

Arrow key → (Windows/Linux)

Arrow key → (macOS)

Move to the previous cell

Arrow key ← (Windows/Linux)

Arrow key ← (macOS)

 
Loading
Salesforce Help | Article