·        Handles multiple warehouse locations

·        Tracking of multiple costs

·        Automated lot tracking

·        LIFO (last in, first out) reporting

·        Weight and broken case quantities handled with the same product number

·        Case and weight tracking

·        Automatic main / sub allocations for product

·        Powerful online inquiries

·        Flexible reporting


The system handles multiple warehouse locations and associated inventories allowing information to be displayed or printed by individual warehouse or all locations combined. With one system you can invoice and ship by warehouse location. If you use 'public' warehousing in various locations you can maintain your inventory balances with their associated lot numbers.


Last cost, and average cost are maintained by warehouse location and are available for displays and reporting. The purchasing system allows you to establish formulas for which cost elements are to be used for the inventory cost and, also a cost which allows markups for ongoing pricing. When a receipt is processed the last cost is updated and a new weighted average cost is calculated. The pricing system allows you to use a pricing based cost and a market cost. You can maintain costs at either 2, 3 or 4 decimal positions.


Quantities maintained in inventory also keep a broken case quantity within the same product number. All quantities displayed or printed always show whole and broken case. Extended cost values include broken case quantities. All our systems were designed for the food industry with weight, full and broken case capability.


FMS tracks both quantity and weight throughout the system for products which are sold by the pound or kilogram. The inventory system retains the actual weight not just the average weight, thus allowing inventory to be tracked and reported and allows displays of weighted products by weight and case quantities.


The system allows you to inventory and purchase under a 'main' product number and set up one or more 'sub' products sold by another unit of measure. The 'sub' products will automatically draw inventory from the 'main' using your established conversion factors, for example, if you bring lettuce in by the case of 24's and sell 24's. You also repack to 12's and 6's with different pricing structures. Another example would be for turnips, cabbage, etc. where you bring them in and sell by standard case weights, or for smaller quantities you can set up a sub where it is sold by the pound even though you purchase by the case (e.g. Bananas).


The new warehousing features of inventory control provide full stock locater options and lot control.

The basics

The purchasing system will produce a receiving document awaiting the receipt of the products from the supplier. This document shows the normal home slot picking location and overflow zone areas. These can be changed at receipt time after putaway if the home slot or zones were moved. For a simple operation this form is used for putaway and the inventory balance for an item is kept as one total regardless of how many slots it is located in. Picking documents can show the same home slot picking slot with the overflow zones. The pickers if they run out of product can refer to overflow zones on the pick document and ask for the home slot to be replenished.

Additional feature options

·        At receiving time you can request pallet labels be printed based on order quantity or actual quantity received. The system will determine the number of labels based on the TI / HI of the pallet.

·        For a more sophisticated approach at receiving time you can call the original purchase order up on the screen and you can confirm the quantities received in whole or by item. Based on existing inventory by slot balances maintained you can request a putaway listing and/or pallet labels which can do the following:

·        If you have an each pick area the number of cases required can be directed there to top it off.

·        The home slot case pick area can be replenished directly. (in both above situations the system will check first if you have any existing stock so FIFO movement is guaranteed).

·        The labels and / or listing will direct the putaway operator to zones. Zones are either a "ready reserve" area above or close to the home picking slot or a bulk area again as close to the home picking slot as possible. Zones are defined and attached to ranges of slot locations and items are assigned zones.

·        The putaway operators will record the slots where they placed the product and then it is returned to be updated on the computer.

·        When quantities are received you have the option to enter the following:

·        A best before date and/or a sell before date. The best before date will default to the receipt date if not entered. You might only want to control certain dated products. FIFO movement is based on best before date.

·        An internal lot number / license plate number.

·        A supplier's or external warehouse lot number.

·        The slot location and quantity for each pallet.

·        A temporary slot number for later putaway or for dock to dock situations.


If you are using the full stock locater system you can choose to use the following:

·        Based on quantities ready to be picked you can choose to produce listings or labels to replenish the pick slots before hand. This can be for each pick and / or case pick areas.

·        This can be for a whole shift or for selected routes or "waves".

·        The setup you have established knows the capacity of the "home" slot whether it be case or each pick. Case and each pick can be combined to the same "home" slot location.

·        When you select a replenishment listing an "image" is kept of the suggested movements. Changes can be made to this "image" and after the actual transfer the system can automatically update the from / to slot movement of quantities.


This function maintains a LIFO (last in, first out) cost and yearend reporting of LIFO based on the unit cost from the last fiscal yearend.


All inventory quantities are up to date the second they are effected. The online inquiries allow immediate access to all inventory information without running a report. Access to all inquiries can be done by product number or by alpha search using any part of the product brand, pack size, or description.

Some of the inquiries include:

·        Period to date displays allow you to scan through all transactions relating to the inventory balance of a product in the sequence they happened. The new quantity on hand for each transaction is displayed. Reference to purchase order number and supplier name is given for receipts, and customer number, name and invoice number are shown for all shipments.

·        Summary browsing allows you to scan through groups of products by brand, size or parts of a product description showing available quantity on hand.

·        Summary screens by product show a complete picture for a product. Quantity on order, allocated, on hand, costs and extended inventory values. Week, period, and year to date quantity summaries of receipts, adjustments, returns and shipments. Past 6 weeks and average movements.

·        Last 52 weeks of shipment quantities and weights by product.

Flexible reporting

Reports are available on demand, daily, weekly and periodically. Some of the reports available are:

·        A one line per product "inventory activity" report lists the opening balance along with total receipts, adjustments, returns, requisitions, shipments as well as closing balance and percentage of inventory turns. Selections can be made for weekly, period, and year to date.

·        An inventory flow of material tracking report will give an opening balance and all the transactions which effected the quantity on hand. Receipts refer to purchase order numbers, and shipments show the invoice number, customer number and name. Details print in the sequence they occurred with the quantity on hand balance at the time. This audit report will aid in tracking down any inventory discrepancy.

·        Inventory transaction reporting by type of transaction showing costs and extended cost values.

·        Flexible selection of inventory movement reporting allows analysis of overstocked and understocked products and calculates the number of weeks supply based on past weeks shipment activity.

·        Minimum/maximum quantity reporting of those products over or under selected quantities.

·        Inventory valuation reporting in summary or detail showing all extended values based on average, last and landed cost.

/ 0 نظر / 40 بازدید