Inventory, production capture, BOM, lots, expirations, and FDA-style traceability.
Configure users and tab access, upload inventory data, and review shared employee and production line lists.
Select an employee from the approved Employee List, then assign username, role, and tabs. Users cannot be created without an employee.
Choose Role = User, then check which tabs this person can open.
Upload one Excel workbook. The app reads these tabs automatically: QBDATA for Item Information, Lot and Expirations for Lot and Expiration File, and Purchase by item detail for Receiving File.
Read-only from shared_apps_data/employee_list/records. Manage employees in the Employee List shared app.
Read-only from shared_apps_data/production_lines/records. Manage production lines in the shared Production Lines app.
Overview of inventory data, production capture, and traceability.
Select how you want to capture the input items used for this production.
Select employee and production line, then type an Item ID. Matching items will appear as you type.
Capture items used. Type the Item ID used, then select the available lot and expiration.
Plan items to produce. Operators can load a scheduled run in Capture Data. Item ID uses the same live search as Capture Data.
Saved captures appear here. Choose whether the date range filters by Captured Day or Production Date.
FG production report. Lists every FG item, including items with zero production. Date filters only affect production totals.
Assign the items each FG or WIP item will use and the ratio of use for each item.
Lists all inventory items with Type of Item = FG, RM, or WIP. BOM? shows Yes when the item already has a Bill Of Materials saved.
Production totals grouped by production line.
Production value grouped by Item ID. Total = Qty Produced × Selling Price.
FDA-style lot traceability. Search by Item ID + Lot Number to see backward trace, forward trace, affected lots, and every input/output transaction.
Capture laboratory results / Certificates of Analysis tied to Item ID + Lot Number. Supports multiple tests per lot, original PDF attachment, automatic Lot Hold/Release, and auto-CAPA on failing results.
Sistema HACCP / Inocuidad Alimentaria. Se guarda en el registro central de CAPA (sharedCapaDeviationData / capa_records) y aparece en la app CAPA + Deviation.