Item bars and chartsBeas dashboards > Using the dashboards > Item dashboard > Item bars and charts |
Top
Previous
Next
|
Quantities by sales order This bar graph shows the total item quantity for sales orders. This indicator includes by default the last 12 months as the date range, only items with procurement mode set to Make and only sales orders that have not been canceled.
Quantities by production This bar graph shows the total item quantity for goods issue in production and the total item quantity for goods receipts from production. This indicator includes by default the last 12 months as the date range, only items with procurement mode set to Make and only the entries for goods issue and goods receipts for production that have not been canceled.
Average Unit Price This line graph shows the average item price in goods receipts from production. The average is calculated per month. This indicator includes by default the last 12 months as the date range, only items with procurement mode set to Make and only the entries for goods receipts from production that have not been canceled.
Average cost per unit This line graph shows the average item price in goods receipts from production. The average is calculated using the item manufacturing price for the last 3 months. This indicator includes by default the last 3 months as the data range, only items with procurement mode set to Make and only the entries for goods receipts from production that have not been canceled.
Lot Size This pie chart that shows the percentage of the lot sizes for the good receipts of the item selected. The percentage represents the amount of work orders that have their lot sizes. This indicator includes by default the last 10 work orders, and only items with procurement mode set to Make.
Query for choosing the lot sizes from the last 10 work orders (MSSQL/HANA): Only modify the 10 after the highlighter RowNumber to choose the last n number of work orders. SELECT "Total Quantity",
Example of an item that has four good receipts. One of them has lot size=2, the next one has lot size=300, another one has lot size=10 and the last one has lot size=3. Therefore each of the lot sizes are represented in 25% of the chart.
Example of an item that has lot sizes set to 1 more often (80%) than the rest of its lot sizes, which are 10 and 2. |