Inventory Management

Our Inventory solutions track by Quantity, Lot & Quantity or Serial-Tag#. Bin Locations can be configure to handle Your full Warehouse Management requirements. Scan products into a Container or Pallet and then Barcode the Container for fast and easy scan movement.


Key Features

FlowTrac can assign a different barcode than your stocking product number. This allows your staff to scan Suppler or Manufacture 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 Generic Categories and SUB-Categories. You can Categorize Your Products in up to Four Categories and Sub-Categories. 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 Number. Set the Track By field when you add a New Product to your Inventory Master File. 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 gives you a complete Audit Trail of where certain Lots or Serials where shipped and or purchased. If a Lot is found to be an issue, quickly search all places that specific Lot has been shipped or transferred to.

Products can be separated by Stock , Non-Stock, or Account Owned. A Non-Stock Product will not be Automatic Ordered and can be eliminated from default Searches. Flagging a product as Non-Stock, will hold all the historic information for look ups , but not clutter your default searches. Non-Stock products can be added to a Receive Orders and Received, but the Quantities are not kept. All transactions are recorded but quantity on hand is maintained at zero.
Account Owned Products are Product 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. (Work 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 be enabled. These are Processes, 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 defined the General 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 on 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 maintains less depth, while another location can support higher minimums and therefore quantity on hands..
The Below Minimum grid will display in an instant,  any Products that have fallen under the minimum on hand. The availability takes into accounts any Allocated Pick Orders in process as well as Open Receive orders that have already been Ordered.
If you BUILD finished Products through the FlowTrac Work Order Menu, the Below Minimum will also take into account the Product Quantities needed to meet Work Order needs.

Some software packages do not support multiple locations while others charge additional fees for each location. FlowTrac provides Multi-Location (warehouse) Out of the Box. You can simple add locations on the fly as they are needed. You could define virtual locations for DAMAGED, or INSPECTION, or SALVAGE. Your inventory quantities could still be controlled, but separated from valuable stocking items by transferring those Products 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 each, so you want the software to Post that as 24 on hand. FlowTrac allows by Product for You to define the U.O.M. type (case, roll, pallet, box, etc…) and set the Factor (number of quantity in the U.O.M.). Defaults for receiving and stocking and picking can be set to avoid confusion fro your staff.

Receive Accounts can be defined for each Product before the first Order is made. the Supplier (account) is selected, Supplier’s SKU#, Supplier’s description, Quoted Cost, Contract Cost and From-To Contract Date.
If not defined  ahead of time, FlowTrac will auto add new Received Order information about a Supplier automatically to this file.
You are just a click away from knowing the “Who – What – When – How” of every Product receiving.

Picking Accounts can be defined for each Product before the first Order is made. the Customer (account) is selected, Customer’s SKU#, Customer’s description may be entered.
If not defined  ahead of time, FlowTrac will auto add new Picked Order information about a Customer automatically to this file.
You are just a click away from knowing the “Who – What – When – How” of every Product Picking.

A single Product can have as many Interchanges 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. You 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. FlowTrac can scan and find or type and find the Product that you need quickly and easily using the powerful Interchange function.

A Kit Template can be defined that uses an Master Kit Product Code and creates all the Products and their Quantities 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 can be marked as a BUILD type of Product.  This will enable a button called Bill Of Material in the Product Master screen. This is where you would enter the Products that are used in Building One of the Finished Products and the Quantity to be used by Default.
Work Orders allow you to Create a Work Order to Build a Finished Product. The Bill of Material for the Finished Product will Auto populate the Work Order. You will now know what Products and Quantities should be Picked to Complete the Work Order and create a Finished Product.
Bill of Process can also be entered to provide a place for Labor Start and Stop Times to be tracked on a Work Order.

You can define Your own special Attributes 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, your staff are forced to enter the required attributes of the product. 

Unlimited Notes can be added to an specific Asset record. Notes support not only written text, but ability to load all types of picture files and document files. Upload jpg, png, bmp, tiff, etc… pictures. Uploadu00a0 .pdf, .dwg, .xlxs, docx, etc… document file types. Notes can be set to automatically popup to the operator whenever an Asset is viewed.

FlowTrac maintains a Detail History of the any transaction that effect Inventory quantities. One button click on the Product Master File Activity button, yields date time, user, quantity, type of transaction  (received, picked, transferred, produced/assembled, etc…) for every touch to your Inventory Product. This history also provides Drill Down clicks to take you straight to the Transaction and Function that created the History. Drill straight to the original Receive Order or straight into the original Pick Order. Activity can be one clicked Exported for you to use Any other Tool (Excel, Word, etc…) that you would like to analyze this information.