Weigh and Dispense Process Template

Purpose

This app helps users in selecting a work order from a list and choosing the assigned materials required for the take-out activity. During the take-out process, the app captures and stores crucial information like the lot from which the material is consumed and the quantity taken out.

Tables Used

The table used in the application is called (Log) Materials. This tables is used to store Unique, physical lots, serial numbers, and batches.

App Structure

On the Select Batch step, users are presented with two options. They can either create a new batch by clicking on the light blue Create New Batch button, which will take them to the Create New Batch step. The other option is to proceed to the Select Material step by choosing a batch from the table and then clicking on the blue Next button.

On the Select Material step, users need to select an item from the list and then click the Acknowledge and Next button to proceed to the Select Batch/Take Out step. The list only displays materials with a Required status. If all the materials are weighed out, the user can click the Finish button to return to the Select Batch step. However, if not all items have been weighed out, the app prevents this action and notifies the user that not all items have been weighed out.

In the "Select Batch/Take-out" step, users can choose a specific lot from the table from which to consume. If the table is empty, users can add raw materials to the table after filling out all the required information. This can be done by clicking the "Add Raw Material to List" button. The app prevents users from using expired materials and notifies them about the expiration date and time.
After selecting the raw material, users need to enter the take-out quantity and then click on the 'Take-out' button. If the entered value falls within the acceptable range, the app stores the raw material batch ID and take-out quantity in the Materials Log table and links it to the component item.
If the entered value is below the acceptable range, the app stores the raw material batch ID and take-out quantity, and it reduces the required quantity of the component by the taken-out quantity. Users can then select another raw material batch and continue the weighing process.
However, if the entered value exceeds the available quantity of the raw material, the app notifies the user about the limited availability of the raw material.
The user can navigate back to Select Material step and choose the next component for perform the weighing activity by clicking on the Back to Picking Materials button.

The Target Quantity is automatically calculated after the selecting the raw material from the table by dividing the predefined required quantity by the raw material potency value. The acceptable range is set to plus/minus 0.5% of the target quantity.

If the user click on the List Completed button the batch ID disapears from the table on the left and appears the table on the Select Batch step.

From the Select Batch step, users also have the option to proceed to the Create New Batch step. In this step, users can create a new record and add components to a selected batch. To add a component, users need to select a material from the dropdown list and input the target quantity. By clicking the Add Component button, the app generates a record for the component with the provided information and links it to the batch.
Users can continue modifying the component list until they click the List Completed button. Once this button is clicked, the batch ID will no longer appear in the table on the left, and the table on the Select Batch step will be displayed instead.