Inventory Control

Barcode or RFID tracking by Quantity, Lot & Quantity or Serial-Tag#


Key Features

FlowTrac can assign a different barcode than your stocking product number. This allows your staff to scan Suppler or Manufacturer labeled barcodes and cross reference right back to the Product number you stock the item under. No longer do you have to “Re-Label” all products to use barcode scanning features.

FlowTrac provides you two Category and Subcategory item fields. These Category names are User definable. You can Search, Find, and Analyze Inventory by Categories. For example you might define Product, Brand, Group, Style, Color, Type, Mfg, etc…)

Track by Quantity, Lot & Quantity, or Serial/Tag Number. Set the Track By field when you add a new Product. Once set FlowTrac, makes sure your staff is required to fill in the necessary information for Picking, Receiving, Transferring, and Auditing Counts. Tracking by Lot or Serial/Tag gives you a complete audit trail of where certain Lots or Serial/Tags have been received, picked, or transferred. If a Lot is found to be an issue, quickly search all transactions of that specific Lot.

Products can be separated by Stock, Non-Stock, or Account Owned. A Non-Stock product will track all transactions of that product but not update Inventory quantities. Non-Stock products are not displayed on the Below Minimum or suggest Re-Order views. All Non-Stock transactions are logged ad can be easily viewed or searched for needed historic information Non-Stock products can be added to a Receive Orders and Received, but the quantities are not updated.
Account Owned Products are products that are owned by another organization. This is typically used for a 3PL warehouse, where the stock is owned by someone else.

The Order/Build field tells FlowTrac whether this item is Ordered from Suppliers (Receive Order Menu) or Built In-House. (Production Order Menu)
If the Product is marked BUILD, then a Bill of Material Button will be enabled. These are items and their quantities that are used in Building the finished Product.
If the Product is marked BUILD, then a Bill of Processes Button will also be enabled. These are Processes (Labor), estimated Run Times that are used in Building the finished Product. Processes can be Labor Types or Work Center names.

FlowTrac does not just keep total quantities. All quantities are stored in specific Bin Locations within your facility. You configured the Warehouse Location and then within each Warehouse, you can setup as many specific Bin Locations as you need. When Products are received into the warehouse, FlowTrac prompts for the location where the product is stored.

You may not have a need for tracking costs of Products, but if you do, we have you covered. The product master can be loaded with a standard cost. During receiving, transferring, adjusting, and picking, FlowTrac stores the last cost, landed last cost, as well as computer average and landed average. These four costs are stored with the transaction historically to give you detail audits on the cost fluctuations of your inventory.

FlowTrac stores the Min and Max on each Product by Warehouse Location You can have one location that is small and stocks less depth, while another location can have larger minimums.
The Below Minimum view  displays any products that have fallen under the minimum on hand, by Warehouse Location. The availability computes Allocated Pick Orders, Production Orders, Receive Orders, as well as the standard Unit of Measure package quantity.

Some software packages do not support multiple warehouse locations while others charge additional fees for each location. FlowTrac provides Multi-Location (warehouse) out of the Box. Virtual locations could be created to support options like TruckA, TruckB, Building A, BuildingB, Damaged, Inspection, or Salvage. Your inventory could still be controlled, but separated from valuable stocking items by transferring those Product’s quantities in to a Virtual Warehouse.

Products are sometimes received, stocked, and picked by different Unit of Measures. You may receive 2 cases of 12, but stock the product by each. FlowTrac can be configured to allow 2 cases of 12 to be recorded as 24 on hand. Products can have multiple unit of measures if necessary. (case, roll, pallet, box, etc…) and each unit of measure has a Factor (number of quantity in the U.O.M.). Defaults for receiving, stocking, and picking can be set to avoid confusion for your staff.

Receive Accounts (Suppliers,Vendors) can be created for each Product before the first order is made. Information entered includes Account (Supplier/Vendor), Preference as Primary or Secondary, Account’s SKU#, Account’s product description, Quoted Cost, Contract Cost and From-To Contract Date.
If not previously created, FlowTrac will auto add new Received Order information about an Account automatically to this file.
Track the “Who – What – When – How” of every Product ordering and receiving.

Picking Accounts (Clients/Customers) can be created for each Product before the first Pick Order is made. Information includes Account(customer), Customer’s SKU#, Customer’s product description.
If not previously created, FlowTrac will auto add new Pick Order information about an Account automatically to this file.
Track the “Who – What – When – How” of every Product Picked.

A single Product can have as many Interchanges (Cross References) as needed. Interchanges can be other Manufacturer SKU#’s, Slang Terms or any other Part Numbers that work the same as the Product You stock. Your picker or receiver no longer has to memorize or look up all the cross references or re-label every box that comes in the building.  Scan barcodes from other companies and let FlowTrac interchange to the Product that you need quickly and easily.

A Kit Template can be created that uses a Master Kit Product Code. A kit can have Kit lines created that include all the Products and their quantity that are used for each of the Master Kit Product. Master Kits can be Built and all the Kit Line Item Products are auto reduced by the number of Master Kits built.

A Product’s Type field can be set to Build, Order, or Both. If set to Build, this enables the a link called Bill Of Material. A Build product can have multiple products and quantity created. This is the material that is used by default when the Build Product is produced.
Production Orders are created to produce a finished Product. The Bill of Material for the finished Product will auto populate the Production Order lines. You will now know what Products and quantities should be Picked to complete the Order and create quantity for the  finished Product.
Bill of Process can also be entered to provide a place for Labor Start and Stop Times to be tracked on a Production Order.

Special Attributes can be created for a Product. These are data fields you can add to the Product for special tracking needs. One Product might require Length, Width, and Height, while another Product might require Weight, Color, Size. Flowtrac will ensure that when that Product is received, the operator is forced to enter the required attributes of the Product. 

Unlimited Notes can be added to a Product record. Notes support not only written text, but allow uploading of all types of picture files and document files. Upload jpg, png, bmp, tiff, etc… pictures. Upload .pdf, .dwg, .xlsx, docx, etc… document file types. Notes can be set to automatically popup to the operator whenever a Product is viewed.

FlowTrac maintains a Detail History of any transaction that effects Inventory quantity. A simple click on the Product activity button, yields date time, user, quantity, type of transaction  (received, picked, transferred, produced, audit, etc…) for every touch to that Product. This history also provides fast drill downs to take you to the original Order or Function that created the History. Drill straight to the original Receive Order or straight into the original Pick Order. All Activity views can be Exported for you to report or analyze in other tools (Excel, Word, etc…).