Top 25 Item-Customers worksheet improvements

The existing worksheet T25 Item-Customers is enhanced to use the new ORDER and HEAD worksheet parameters that are described in the CloudSuite SCP section of this release.

The worksheet layout is changed from a 5x5 layout of top five items by top five locations to an improved layout displaying the top 25 item-location combinations as rows in the pivot table. The worksheet continues to arrange the displayed combinations based on descending value of Forecast Plus Actuals Revenue for the Current Year. Users can switch to Forecast Plus Actuals Units whilst viewing the worksheet.

A new application is added to define the count of item-location combination rows to display:

  • dpls_topx_itemlocation_count - Number of Item-Location combinations for Top x Item-Locations Panel (Max 100). Default Value = 25.

The worksheet uses existing application variables to control the following item level and location level to view, as used by the T20 Items and T20 Customers worksheets:

  • dpls_topx_item_level - Level of Item Hierarchy to use for Top x Items Panel
  • dpls_topx_location_level - Level of Location Hierarchy to use for Top x Locations Panel

The standard worksheet is not included in any multi-panel worksheets but is accessible within the Library (D+) workbook.

This feature is enabled after appending the demand planning template (dpls.zip) for this version. No additional role or privilege is required to access this feature. This feature is accessible to those users with existing access to the worksheet.