Average Historical Sales Report

The Average Historical Sales Report enables you to view the average historical sales order detail records based on item information. The Sales by Sub Section and Branch Plant cluster bar chart enables you to compare the average historical sales for items within the sub section category codes across different branches. You could use another category code associated with the item record. The Sales Percent by Sub Section pie chart enables you to view the average historical percentage of sales by the sub section category code. You could use another category code associated with the item record. The Order Quantity Summary by Sub Section table shows the average historical values for the sub section category code and branch plant that are used in the charts. The Order Sales Quantity by Branch Plant and Sub Section detail table displays all the historical sales order detail records that were used to create the charts sequenced by Branch Plant and sub section category code. The table displays the averages for each Sub Section category code and for each Branch Plant.

This report contains the following components:

  • Sales by Sub Section and Branch Plant (bar graph)

  • Sales Percentage by Sub Section (pie chart)

  • Order Quantity Summary by Sub Section (table)

  • Order Sales Quantity by Branch Plant and Sub Section (table)

The Order Sales Quantity by Branch Plant and Sub Section table component contains drill back functionality as described in the following table:

Functionality

Value

Table column containing drill back link

Item Number

Table columns passed to application

Item Number

Application called

Sales Order Entry (P42101)

Form called

W42101C

Version called

ZJDE0001