Sorting and filtering

How does it work?

Based on the data values of stock levels, you can filter individual values in the respective columns.

Raw materials:

1. Demand:

• Sort in descending and ascending order.
• The filter above the inventory state - this value indicates that the demand for a particular raw material is more significant than its value in inventory states.
• Above production state - after selecting this filter, it will display data for raw materials whose demand for production exceeds the quantity of raw material allocated for production.
• Above ordered quantity - the demand for a specific raw material is greater than the quantity ordered from suppliers.
• More than zero - displays all values greater than zero.
• Less than zero - displays values less than zero.
• Equal to zero - displays values equal to zero.

2. In stock:

• Sort in descending and ascending order.
• Filter below demand - this value means that the inventory value of raw material is less than the demand resulting from orders.
• Optimal level in inventory - displays raw materials whose inventory level is optimal (#TIP - link to an article about inventory levels).
• Below optimal inventory level - displays raw materials whose inventory level is below the assumed optimal level but has yet to reach the critical level.
• The critical inventory level displays raw materials that have reached or exceeded that level in the inventory.
• More than zero - displays all values greater than zero.
• Less than zero - displays values less than zero.
• Equal to zero - displays values equal to zero.

3. On the shop floor (Note: this is displayed only when multi-warehouse support is enabled):

• Sort in descending and ascending order.
• Below demand - displays raw materials whose value in the Production inventory is less than the demand resulting from orders.
• More than zero - displays all values greater than zero.
• Less than zero - displays values less than zero.
• Equal to zero - displays values equal to zero.

4. Ordered:

• Sort in descending and ascending order.
• Filter below demand - shows raw materials whose order value is less than the demand from product orders.
• More than zero - displays all values greater than zero.
• Less than zero - displays values less than zero.
• Equal to zero - displays values equal to zero.

Products:

1. The sum from orders:

• Sort in descending and ascending order.
• Above inventory state - displays products whose order value to customers is greater than the product value in inventory.
• Above production state - displays products whose order total is greater than the quantity produced in Production.
• More than zero - displays all values greater than zero.
• Less than zero - displays values less than zero.
• Equal to zero - displays values equal to zero.

2. In stock:

• Sort in descending and ascending order.
• Below demand - displays products whose value in inventory is less than the total order value.
• Optimal level in inventory - displays products whose inventory level is optimal.
• Below optimal inventory level - displays products whose inventory level is below the assumed optimal level but has yet to reach the critical level.
• The critical inventory level displays products that have reached or exceeded the essential level for inventory.
• More than zero - displays all values greater than zero.
• Less than zero - displays values less than zero.
• Equal to zero - displays values equal to zero.

3. On the shop floor:

• Sort in descending and ascending order.
• Below demand - shows products whose quantity produced in Production is less than the total quantity required for production resulting from orders.
• More than zero - displays all values greater than zero.
• Less than zero - displays values less than zero.
• Equal to zero - displays values equal to zero.

It may seem like a lot, but it will help you better manage your inventory states and reduce shortages.

High five 🙋‍♀️ - team Prodio!

Prodio is a user-friendly production planning software for small manufacturers.