Customer Order Stop reports
The reports Stopped Orders by Payer and Stop Codes by Payer show the top N values by main attribute. The additional attribute used for color is not considered in the ranking. Dense rank is used; in cases of a tie, the chart might display more categories than the cut-off value.
The measures used in Customer Order Stop reports are sourced from the Sales Orders fact. These measures are analyzed by Planning Date and use the Sum aggregation.
Line and Order Amount by Status
Description: This report shows the line amount and order value measure by customer order line status. In this report, the user can have an overview of the customer order line status and see which status has the highest and smallest line amount or order value.
Measure: Line Amt – Company, Order Value – Company
Chart type: 2 data series grouped column chart
Stopped Orders by Payer
Description: This report shows the top payer based on the line amount measure. This report is filtered by Stopped/Stocked Status = Stopped w/ Stock or Stopped/Stocked Status = Stopped w/o Stock to identify customer orders by payer that are on stop.
Measure: Line Amt – Company
Chart type: 1 data series stacked bar chart
Partition: The Stopped/Stocked Status attribute is used as color to partition the chart.
Stopped Orders With Stock Details
Description: This report shows a detailed analysis of the customer order number and payer on stopped orders with stock, sorted descending by line amount. Additional detailed measures for further analysis are made available in the report. A drill back to M3 functionality is also added in the report. By clicking a specific order number or a specific payer, the user will be taken to the defined M3 screen where they can analyze the order further or make changes directly in M3.
Measure: Line Amt – Company, Order Value – Company, Order Qty
Chart type: Table
Filter information: Data is filtered by Stopped/Stocked Status = Stopped w/ Stock
Drill back to M3: Hyperlink Order Number to OIS120/E, Hyperlink Payer to CRS315/B
Stop Codes by Payer
Description: This report shows the top payer based on the line amount measure. This report is filtered by Stopped/Stocked Status = Stopped w/ Stock or Stopped/Stocked Status = Stopped w/o Stock to identify customer orders by payer that are on stop. The user can also see the different customer order stop codes per warehouse.
Measure: Line Amt – Company
Chart type: 1 data series stacked bar chart
Partition: The Customer Order Stop attribute is used as color to partition the chart.