Listforms provides a broad array of web-based "off-the-shelf" solutions as well as allowing even non-programmers the ability to create there own applications, or to extend existing ones. MIDSTT is an example of a Listforms app that users can freely install and even modify if they desire.
Clients are manufacturing and distribution - this particular implementation is for the food industry and is compliant with all the traceability requirements in that industry.
MIDSTT was developed by Listforms and is based upon their 15 years experience delivery warehouse and production systems to the food and pharma world.
The handling and creation of purchase and sales orders , HACCP, blend tank, manufacturing orders, etc - along with barcode and warehouse management support make this the idea solution for challenging conditions.
MIDSTT is offered free to Listforms subscribers.
MIDSTT clients tend to use part, but not all of the available features. This case study is actually a combination of cases. Major areas covered are :
• Purchasing - Suggests orders and vendors, creates purchase orders, emails vendor the orders, processes receipt with barcoding, suggests putaway location
• Manufacturing - Recipes, formulas. BOMs. work orders, etc. Inventory pick recommendations based up lot age, etc Adjustable manufacturing batch size
• Sales / Shipping - Create sales order, recommends inventory, process shipment, email invoice to customer
• Inventory / Warehouse Management System (WMS) - handles directed putaways, picks, pallets, tanks , etc
• HACCP / QA testing - Any type of question with email alert of upcoming or late reporting
• Traceability - Complete and full one-up / one-back traceability, every point
• Training & Help - Every business has different rules and operation instructions and MIDSTT allows that to be formalized
Client begins the day by running a "Required Purchase Report" that lists the inventory that should be purchased to maintain inventory at required stocking levels (reorder point) and the manufacturing reuirements to meets actual non-shipped sales.
Client creates purchase orders, vendors receive automatically sent emails of the POs, phone calls as needed. Purchases arrive and pre-printed barcodes are attached to incoming inventory and scanned into MIDSTT. Vendor lots , etc are entered. MIDSTT displays QA/ inspection screen as appropriate and adjust lot status as needed. MIDSTT suggests best place to put inventory and records where actually placed - all via a smartphone/tablet scan of the barcode on the item and the location.
Client adjusts or creates recipes in MDISTT and then creates productions batches. MIDSTT suggest picking locations for inventory , then records actual inventory used in production, as well as non-inventoried items. Produced items have a pre-printed barcode attached and scanned in and production items/lots are recorded and MIDSTT suggest putaway location and records actual putaway location.
Sales orders are received online or typed in by client. Orders are released for pick and suggested pick locations are provided. Actual pick items/lots/ location are recorded by a single barcode scan of the item from the smartphone or tablet. Upon shipment, customer is emailed a link to the sales order.
Daily warehouse operations include inventory transfers, consolidations, etc
Barcode labels are created
QA & HACCP testing is done on a continuos basis
Traeability is easily done from once screen and shows complete lot from the time it enteres receiving to leaves in shipping
• Required Purchase Report" suggests inventory to order
• Creation of PO’s (purchase orders)
• Email vendors their POs
• Receive and barcode incoming inventory (putaway rules , etc)
• Provide PO purchase totals for data entry into company’s accounting
Manufacturing and Work Orders
• Create recipes (formulas and assembly instructions)
• Create batch order ( make production run of recipe )
• Create picking order (present quantities and prefered lots and locations to pick)
• Record / update raw ingredients used and finished lots made
• Creation of SO’s (sales/shipping orders)
• Email customers their SOs
• Shipping (pick rules , etc)
• Provide SO purchase totals for data entry into company’s accounting
Safety and Traceability
• Control of inventory use by lot status
• HACCP (Hazard Analysis Critical Control Points)
• Traceability reports
Time , Attendance
• General time for payroll
• Project time apportions
• There are a large array of reports available
• Virtually unlimited additional reports may be added by the user or by Listforms
Ability to extend and add functionality
• Add additional screens via configuration
• Easy links to the company’s private copy of the database
• prints labels , on office printeres and label stock, or other printers
• Scan barcodes with android smartphone / tablets (one time software purchase under $4.00 per device) or bluetooth scanners
Screens automatically update the size and layout to fit the screen of the viewing device
Inventory has a large and expandable paramter set (Items, Families,Lots , Units of Measure, Expiration date, default status, etc)
Lots managment is very strong in MIDSTT, inclusing, status, manufactures lote, recipt date, expiration, lot status, etc
• types : warehouse, bin, pallet/ container, blend tanks
• blend tanks allow lot mixing while maintaing traceability
Open and extendible software source (your can add to and change the software)
Integration is simple with complete access to your mySQL database and trigger support on every screen
Data may be saved for spreadsheet use
MIDSTT provides an incredible amount of functionality and competes well with high end manufacturing, work order management, HACCP, and warehousing systems. It can also be easily extended to offer even more. While MIDSTT provides complete access to the owner’s database, it does not ,’out of the box’ , offer computer -to-computer / program-to-program integration to other systems. MIDSTT's integration to accounting AP (accounts payable) and AR (accounts receivable) is via reports from MIST that are then manually entered into the accounting system as single line entries (only need one data entry line per entire PO).
There are three primary ways the link to the account AR / AP might occur :
Purchasing and receiving is done totally via MIDSTT : A PO is created , MIDSTT links are sent to the vendor, an unlimited number of order lines are received from the vendor - then MIDSTT creates a report with the PO details . The PO totals are entered in AP and the details remain in MIDSTT and are on the printed reports. (each PO has only one line entered into accounting system)
Purchasing is done via accounting system and inventory received via MIDSTT : POs are created in the company’s accounting system and when the purchase arrives the details are entered into MIDSTT. A report with details is created by MIDSTT and the entire details manually entered into the company’s accounting system.
Software is written that links MIDSTT to the company’s accounting system : the company and their agents, have complete access to read and write data. Companies may write their own integration, use a third party, or hire ListForms to write it for them.
Manufacturing, Shipping, and other integrations are similar to the purchasing method.
Printing barcode labels via ListForms :
(see video https://youtu.be/Y7zRJ0n36B4 ) If you have a gmail account , and an office printer you have all you need to make a complete barcode labeling system: all you need for the labels themselves - which can be simple paper or ordinary mailing labels available from any office supply store ( 8 1/2 x 11 sheets 30 labels per page, 2.625 x 1 inch).
If you have a gmail account then you also have free access to Google Drive storage and Google’s office programs. We will use the Google Drive storage latter but for now we will be using Google’s spreadsheets (Google Sheets). With a ‘gmail’ window active, launch this link
and it will bring up a copy of the “ListForms barcode on google sheets”.
This version will be “read only” (because it is OUR copy) so just save your own version by going under the “File” menu, and select “Make a copy”. You can then make changes to the new copy and you will be ready to begin.
The only fields on the worksheets that need to be changed by most users are :
Label prefix - which is the leading character(s) on the front of the barcode
Format leading zeros - how wide will the field be, not including the label prefix
Starting number - the first label number to be printed
For instance if we were printing Lot labels, we might use a Label Prefix of ‘L’. To use a number with a max of 5 leading zeros, use ‘00000’ and to start with number 1 - set the starting number to 1. Then the first label will be ‘L00001’. This setting produces the labels as on worksheet ‘3 Column Barcode’.
If the last lot label we produced was number 500, we would then change the starting number to 501. - which then automatically updates the barcode labels.
To print labels , select the “3 Column Barcode” worksheet tab, then press “Ctrl P” on PC or Android or , “Command P” on Mac. Then select “Current Sheet”, “Actual Size”, and “Portrait” options - then the “Print” button.
Industries with high traceability requirements such as Food , Pharama, Labs, Testing, etc
Effective traceability requires a continuous track from the moment inventory arrives till the moment it leaves the facility, as a whole item or ingredient, or is destroyed. MIST recommends that unique tracking lot numbers be assigned to all incoming material. The manufacturer's original lot and/or manufacturing date is captured and logically linked to the new lot number. The tracking lot is then used for the lifecycle of the inventory . Assigning tracking lot numbers eliminates issues with the same lot being delivered by different carriers and different logistics paths. Tracking lot numbers also eliminate issues with different vendors having the same lot number.
To achieve this, all we have to do is assign the new tracking lot number at the point of receiving and recording the manufacturer's lot number and the delivering vendor. Once captured, MIST keeps track of all the lot data.
As long as the new lot numbers are unique, you may generate them however you like but MIST provides a method for pre-printing these.
Note that we use “licence plate” lot numbers, they are sequential, just like car license plates, and while the lot number itself says nothing about the lot, the data about the lot number is held in the MIST database and will automatically keep and track all associated data about the lot.
MIST handles the tracking :
Operationally, we print out a number of tracking lot labels (using our program and your office mailing labels, or your own method) , and apply them to new item / lots as they are received. By entering the vendor lot and our lot number into MIST the two are logically connected and tracked from this point forward via the new lot.
Pallets are optional , however customers that move a lot of items and/or lots will find them very useful. While there are other advanced features, essentially, pallets simplify the process of moving inventory . You can put as many items as you want on the same pallet (each pallet has its own pallet label) and process the transfer of all the inventory on the same pallet with a single action. So while 10 items on a pallet can be transferred with one action, if the 10 items are NOT on the same pallet requires 10 actions.
MIST warehouses are really “logical” vs physical warehouses. While it is possible to to have logical and physical warehouse to include the same area. We suggest they be considered differently. Where a physical warehouse may include several type of storage (freezers, refrigerators, indoor, outdoor storage) - in general a logical warehouse should only have one type of storage. This distinctions helps later in evaluating inventory “situations” and avoiding misplacement of inventory.