The current version of WMP is composite technology using older iSeries ILERPG software as well as Linux/Java for Reporting. Because the legacy side was written as a standalone overlay application, it is still very effective today and only handles the transaction side with SQL updates back into the underlying transaction system, it does not replicate the inventory management system. The Linux/Java side handles all of the Reporting through Browser based screens which can be severed internally or externally, any where there is a network or internet. The reporting side has user based security which is managed through the administrative function.

Free Open Source

There seems to be enough interest in Warehouse Management Portal (WMP) that we will be accelerating our plans for rewriting it into Java. In the mean time, we have decided to release the source code for the RPGLE version into the open source market. We will be registering a project on source forge for WMP for iSeries/AS400. It will include a JD Edwards version and a VAI System 2000 version. As soon as it is approved we will load up the source code, both the RPGLE and the JAVA Infoportal Reporting portal so you can download, so we should have that on sourceforge before the end of July, 2008.

We have put the documentation here so you can review that:

Note, if you are interested in the WMP portal but are using a different ERP application on your iSeries, download the VAI version. That should be the easiest one to modify.

2nd Derivative Warehouse Management Portal

Reduces Warehouse Management Costs and Complexity by leveraging your existing investment in your Legacy Systems, integrating with your existing ERP system or as part of Randr, Inc.s 2nd Derivative Solution, extending your control into the warehouse:

  • Essential piece of a comprehensive Supply Chain Management system
  • Interactive, radio frequency entry and maintenance.
  • Picking, shipping, and put away management status that has minimal impact on existing on line applications
  • Single Server design
  • Designed to be integrated with your existing ERP system without duplication of functions or data
  • There are 4 modules:
    1. Automated Receiving and Put Away.
    2. Automated Picking, Consolidated Picking, and Inventory Movement,
    3. Physical Inventory/Cycle Counting.
    4. Automated Shipment Validation. Integration into legacy ERP for invoicing, and ASN Files. Available as individual modules or as an integrated warehouse management system.
1) Automated Put Away and Receiving:

  • Radio Frequency Put Away

  • Receive Containers/Purchase Orders to receiving location

  • Validation of pallet configuration (tie and high)

  • Palletizing of put away

  • Suggested put away locations:

    • By Existing locations

    • By Home location

    • By Zone

    • By Customer

  • Ability to create a pick to create full pallets for put away

  • Put away can be split for full pallets and partial pallets

  • Ability to flag specific bins to NOT allow put away.

  • Ability to put away into hold locations, so inventory can not be picked

  • Creation of pallet files and palletizing receipts

  • Generation of bar code labels for pallets (pallet id/license plate)>

  • Radio Frequency scanning of pallet labels, item number or UPC for put away with automatic inventory movement

  • Pass through for customer direct purchase orders with customer pallet configuration

  • Radio Frequency Directed (paperless) put away

  • Put away status via browser

2a) Inventory Movement:

  • Radio Frequency inventory movement

  • Scan item number, pallet id or UPC codes

  • Automated inventory movement

  • Ability to move product that is in a hold bin

2b) Picking:

  • Consolidated pick ticket creation

  • Pick path can be in multiple sequences:

    • Bin sequence

    • Item sequence

    • Size sequence

    • Zone sequence

  • Pallet and rack picks can have different sequence

  • Ability to have multiple pickers on same pick ticket working on the same lines with no duplication

  • Supervisor override for picking, all others must follow directed pick

  • Radio Frequency picking by pallet id, item number or UPC

  • Radio Frequency Directed (paperless) picking which leads the pickers through the warehouse.

  • Picking status via browser for detail and summary information on picks and replenishments.

  • Scan item number, pallet id or UPC codes

  • Expected arrival date on out of stock items

  • Ability to rerun pick ticket for out of stock items when they arrive

  • Automated substitutions for entire quantity of an item or partial quantity, allowing scanning of the substitution Item number

  • Automatically break kits into components pieces for picking

  • Ability to remove a specific line from a consolidated pick ticket

  • Delivery to packing or shipping station report for reconciliation during picking

  • Suggested replenishment of rack locations from partial pallet picks

  • Ability to consolidate a rack pick into one location pick

  • Ability to pull from receiving if on hand is not sufficient

  • Ability to put a bin on hold so you can not pick from that bin

  • Ability to unpick a line

  • Audit trail on all transactions, substitutions and supervisor overrides

3) Physical Inventory:

  • Radio Frequency scanning of Item number, pallet id or UPC

  • Audit trail by pallet id and location

  • Scanning of bin locations

  • Cycle count by bin locations

  • Integrates into existing Cycle Counting for inventory update and interface to general ledger

4) Shipment Verification:

  • Shipment verification by individual order

  • Shipment verification by consolidated pick ticket (multiple orders)

  • Simultaneous scanning and verification of multiple orders at once.

  • Radio Frequency or Stationary Scanner.

  • Radio Frequency scanning of item number, pallet id or UPC codes

  • Shipping status via browser by:

  • Consolidated pick ticket

  • By order

  • By Item

  • Automated scanning of substitutions

  • Automated kit handling:

    • Individual components are verified at shipment

    • End item is verified at shipment

  • Automated inventory adjustments created for:

    • Item substitutions

    • Kits components

  • Multiple pallets can be created

  • Multiple people can work on verifying the same order or group of orders

  • Ability to unpack a carton or pallet

  • Ability to combine cartons or pallets

  • Ability to move product from one carton or pallet to another

  • Ability to combine multiple orders on a pallet

  • Pallet and carton labels including combined pallets and cartons

  • Small package option that automatically creates carton to speed up processing

  • Multiple order option that automatically creates pallet to speed up processing

  • Audit reports on picked versus scanned, and scanned versus ordered

  • Ability to assign pallets to a truck for multiple truck shipments

  • Update back into ERP system for quantities shipped and back ordered

  • Ability to update back into ERP system by:

    • Individual sales order

    • By consolidated pick ticket

    • By Truck

  • Consolidated bill of lading, can combine unlimited orders

  • ASN Shipment Files

Warehouse Management (All 3 sections):

  • Browser based Intranet status reporting:

    • Put away summary status

    • Put away detail status by line

    • Picking summary status

    • Picking detail status by line

    • Ability to see picking detail and summary information for invoiced orders

    • Replenishment status

    • Shipping status by consolidated pick ticket

    • Shipping status by sales order

    • Shipping status by item

  • Shipping audit reports:

    • Picked versus scanned,

    • Scanned versus ordered

    • Pallet contents by order and by truck

  • Picking audit report:

  • Delivery to packing or shipping report for reconciliation during picking

  • Customer zones or warehouse zones

  • Multiple bin types:

    • Pallet bins

    • Inner and Master bins (Rack)

    • Each bins

  • Ability to put bin on hold

  • Ability to flag a bin to not allow put away

  • Ability to link bins and items with Zone or Customer

  • Home bin by item for default rack put away

  • Pallet estimation for truck scheduling by weight and cube

  • Consolidated bills of lading, ability to link unlimited number of orders to one consolidated bill of lading

  • Multiple items in a bin

  • Control over stacking pallets by item

  • Integration with existing inventory control and updating and general ledger interface

  • Donations pick for scanning item, bin and quantity

2ndDerivative Supply Chain Portal was specifically designed for servers integrated to the ERP system.

It is designed to run on a Linux Server as part of our 2nd Derivative Solution or integrated with your existing legacy ERP system without duplicating functions and data.

The key points of interface include:

  • Item files

  • Order files

  • Physical inventory or cycle counting

  • Interface to inventory transactions (movement and adjustments)

  • Interface to GL

The application can easily be customized and integrated by your staff or by Randr, Inc.