Inventory management

Purpose

This Article summarizes how the Inventory management application is structured and built.

What purposes does the Inventory Management test serve?

The user can manage and view inventory items in the Inventory management application. The application stores inventory data in a Tulip Table. In the application, the data from this Tulip Table is displayed. The user can also choose to manipulate the data according to the changes on the shop floor.

Table used in inventory management

The Tulip Table used in the application is called Inventory. Each record in the inventory table is an inventory item specified by the name, location, and status of the item. For example, you can have bricks, at the first station, reserved for a project. Each of these records has a QTY field where the user can track how many items are present in the specified location and state.

Fields of Inventory:

• ID: Unique ID of the inventory item created by the concatenation of the name, the location, and the status of the item
• Item: The name of the item
• Area: The area where the item is located
• Location: The exact location in the specified area
• Status: The status of the inventory item. Can be “Available”, “Quarantined” or “Reserved”
• QTY: The quantity of the items

App structure

The Main step of the inventory management application functions as the navigation page of the app. There are six actions you can choose from:

1. Filter inventory items based on ID, Item nem, Location, and Status
2. Create a new inventory item
3. Add items to an existing inventory record
4. Remove items from an existing inventory record
5. Edit the status of some items from an inventory record
6. Move some items to a different location

By clicking the Create inventory item button on the Main step, the app navigates the user to the Create Inventory Item step. In this step, the user needs to fill out all the fields and create a new inventory item by clicking on the Create button.

By clicking the Add QTY button on the Main step, the app navigates the user to the Add QTY step. The user needs to type in the number of additional items and update the table record by clicking on the Add QTY button.

By clicking the Remove QTY button on the Main step, the app navigates the user to the Remove QTY step. The user needs to type in the number of items to remove and update the table record by clicking on the Remove QTY button.

By clicking the Edit status button on the Main step, the app navigates the user to the Edit Status step. The user must specify how many items they want to change their status and what the new status should be. They save the changes by clicking the Edit Status button.

By clicking the Move QTY button on the Main step, the app navigates the user to the Move QTY step. To move items from one location to another, the user must enter how many items they would like to move and specify the new area and location.