Order Tracking Template

This article provides an overview of the Order Tracking Template and how it functions.

Purpose

The Order Tracking Template is a tool designed to assist users in managing their orders effectively. Users can view existing orders, create new ones, manage in-progress orders, and transition orders to subsequent locations while updating their status.

Tables Used by the Order Tracking Template

The application relies on a Tulip Table, specifically the Order Materials table, to store comprehensive information about the orders. Each record in this table represents a unique order and contains essential details such as a unique ID, product type, and status. Additionally, users can store any other necessary information relevant to the order management process.

Fields of the Order Materials Table

ID: Unique identifier for the order.
Item Master ID (optional field): Link to the Item Master table, defining various product types.
Product Name: Name of the product.
Type: Type of the product.
QTY required: Quantity specified by the order.
QTY complete: Number of products already produced.
Due Date: Deadline for order completion.
Status: Current status of the order.
Location: The product's present location.

App Structure

In the View Active Orders step, users can access a comprehensive view of all existing orders. Selecting a specific order reveals details like the order's current status and the operator's name assigned to it. Users can also create a new order by clicking the Create New Order button or begin working on an existing order by clicking Begin Order.

In the Create New Order step the users need to select a product, enter the quantity, and specify the due date for the new order. Upon clicking the Create Order button, the record is added to the Order Materials table.

Initiating an order automatically changes its status to "In Progress." The required and completed quantities are displayed on the screen. Operators can add completed materials during production. If the completed materials match the required quantity, the application prompts the operator to move the product to the next station.

To advance the order to the next workstation, users must select the next location and update the order's status on the Move Order step. Clicking the Move Order button navigates the user back to the View Active Orders step, allowing them to proceed with the next order.