|
|
|
|
Warehouse Module:PICKING THE ORDER
|
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.
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.
CDI 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 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.
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 qty per 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 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".
| 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. | |
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
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. period, and year to date quantity summaries of
receipts, adjustments, returns and shipments.
| |
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.
| Quantity on hand reference listings by product
or slot.
| Optional pre picking list of product picking
slots which might require replenishment.
| Item Movement Analysis Reporting by product .
| Additional reports include; Excessive
Inventory Report, Supplier Short Shipment Report
| All reporting is available by all products or
selections of various categories of products.
| Single or combined warehouse selections.
| Reporting is produced in sequence by product
grouping and categories. | |
With this system you have the ability to take an 'image' of inventory balances and costs prior to a physical inventory and continue regular processing of orders. Counts can be entered after and variances updated.
Counts sheets produced by product grouping or
by slotting sequence before a count
| Cycle counting set up capability
| Automatic inventory adjustments made anytime
| Missing sheet number report
| Costed inventory variance reporting by group
and category
| |
|
|