Welcome to the Exact Product Blog

On this blog we will cover stories from all around the Exact ecosystem.

Posts Tagged ‘Pick-IT’

WMS stock keeping units (SKU) functionality in controlled release!

Written by Michiel Dorjee on . Posted in Exact Globe

As per general availability of Exact Globe product update 401, our warehouse management solution (WMS) has been enhanced with stock keeping units (SKU) functionality. This functionality is currently offered in an extended controlled release phase. SKU functionality will become standard within E-WMS Replenishment after controlled release.

SKU management enables you to tag any stock unit in your warehouse with a unique number, a kind of ‘license plate’. Instead of scanning warehouse, location, item, batch number and quantity per individual item, you now only have to scan one unique number. In that way it becomes possible to register and trace complete sets of goods from reception, making your warehousing efficiency improve rapidly. This unique number is generated and the label printed during the stock reception processes.


  • Higher efficiency and accuracy in handling processes.
  • One SKU number results in reduction of errors.
  • FIFO/LIFO picking advice possibilities based on the SKU reception date.
  • The possibility to advice ‘full pallets’ directly from bulk locations instead of picking locations.
  • Enhanced tracing since SKU transaction history remains available.

Check your E-WMS table sizes and clean up old log files

Written by Michiel Dorjee on . Posted in Exact Globe

Regularly we receive back-ups of Exact Globe databases to analyse problems or help speed up support issues. Very often, the size of these databases could be limited by cleaning up historical E-WMS log files.

First you need to know what SQL tables take up most of the space. When executing this SQL script (with thanks to the author mentioned in that script), stored procedure Usp_GetTableSizes will be created. You only need to run this script once per database. After that, you can run the command usp_gettablesizes in a new SQL query window. The output will be a list of tables in the current database, sorted by number of records descending.

When using E-WMS (or ICL, Pick-IT or Central Warehouse) some tables could contain a considerable number of records. These tables could be cleaned up periodically:

  • csPickitErrorReport
    This table contains all messages generated by the E-WMS (or ICL) services and from actions within the control centers. Probably you do not need history for more then, let’s say, 30 days. In that case you could schedule in SQL a query to run each night, like this:  DELETE FROM csPickitErrorReport WHERE syscreated < GETDATE()-30
    That will delete all records older than 30 days. When executing the first time, this can take considerable time !
  • csPickitStatistics
    This table contains a log of all actions performed within control centers and on the hand terminals. You could for instance measure orderpicker productivity from the data in this table. If you do not need this data (or not that old), you can use the same method as decribed above (for csPickitErrorReport) to delete old records periodically.
  • E-WMS ASP session history
    When using E-WMS ASP (Internet Explorer or ERF as client)  each screen and input on the hand terminals is logged into three session log tables. This is to provide insight in hand terminal sessions, or to check what wrong bar code or text was put in. This management screen can be accessed by using the URL http://myserver/myWMS/management (where myserver is your IIS server, and myWMS is your WMS web site name). At this time, this management screen only shows session information from Internet Explorer sessions, not from ERF sessions.When you do not need this session history, you can periodically clean up these session log tables (again saving last 30 days in this sample);
    delete CSPickItWebFormFields from CSPickItWebFormFields c join CSPickItWebRequests b on c.WebRequestID=b.ID join CSPickItWebSessions a on b.WebSessionID=a.ID where a.[DateTime] < GETDATE()-30
    delete CSPickItWebRequests from CSPickItWebRequests b join CSPickItWebSessions a on b.WebSessionID=a.ID where a.[DateTime] < GETDATE()-30
    delete from CSPickItWebSessions where [DateTime] < GETDATE()-30

Pick-IT changes to E-WMS

Written by Michiel Dorjee on . Posted in Exact Globe

As from product Exact Globe update 398 (July 2010) a number of changes considering Pick-IT will be implemented:

  • The name Pick-IT will change into E-WMS!
  • Pick-IT Central Warehouse will be rebranded to E-Intercompany Logistics
  • Pick-IT Sales Transactions will be rebranded to E-Mobile Sales
  • A new module structure will be implemented
  • No separate installation anymore

Pick-IT, Exact’s warehouse management solution has been renamed to E-WMS as from product update 398 to reflect its growing functionality and full integration into Exact Globe as a standard module. One of the functional areas of growth for e-WMS is the addition of SKU management, another one is the addition of directed put-away possibilities. Besides the name change of Pick-IT to E-WMS, Pick-IT Sales Transactions will be named E-Mobile Sales from now on and Central Warehouse will be named E-Intercompany Logistics.


For more detailed information, please read this document

Pick-IT scan code functionality helps you understand better what to pick on the handheld …

Written by Michiel Dorjee on . Posted in Exact Globe

Pick-IT is continuously improving functionality. One of the functionalities which was improved recently is the scan code functionality. The improvements are based on customer feedback.

A scan code represents a quantity of sales units in a specific package. One item can have several scan codes.

An example:

Item A is sold per kilo. In the warehouse, Item A has two different packages; a one-kilo package and a box containing 8 kilo’s.  A sales order for 20 kilo has to be picked.

In System/Pick-IT/ Scancodes you can maintain scan codes with a specific quantity and package description for the selected item and supplier.

When entering a scan code on the handheld the quantity for the item will be automatically shown as quantity packages. The quantity will be prefilled and also the quantity for the items left (to be picked) is shown.

On the handheld scan or enter the scan code 

The total item quantity is re-calculated to total packages (2 boxes) quantity and the quantity left (4 kilo)

When entering the quantity  all quantity details are recalculated and you can continue with the picking flow.

The scan code functionality is now available in all Pick-IT processes.  

Note:  the setting ‘scan code’ at module level needs to be set to ‘scan code’.

This scan code functionality is available from product update 396.

E-WMS improves EAN128 bar code scanning

Written by Michiel Dorjee on . Posted in Exact Globe

Companies using different types of bar codes in their warehouse (for example ‘simple’ CODE39 for warehouse location or item bar codes, and EAN128 bar codes for serial/batch items) could encounter the problem that a non-EAN128 bar code would be treated and decoded as an EAN128 bar code. That would lead to undesired messages like ‘item not found’. This is because when scanning a bar code, the software could not tell the difference when scanning a CODE39 bar code or an EAN128 bar code.

Sample of a CODE39  bar code and an EAN128 bar code:



From product update 399, E-WMS will support ‘Bar Code Indentifier’. This is a setting on hand terminals whichs add an extra character as prefix to each scan, where a unique character will be put in for each type of bar code. For example, when scanning an EAN128 bar code, the scanner will put a “K” in front of the scanned text, where the character “B” would be added when scanning a CODE39 bar code. So now E-WMS knows when to start EAN128 decoding !

You can read more about Bar Code Indentifier in document E-WMS – Code Identifier.

E-WMS supports HIBC barcode

Written by Michiel Dorjee on . Posted in Exact Globe


The HIBC (Health Industry Bar Coding) barcode is more and more used. E-WMS is used by a number of companies that do business with Health Industry companies. Therefore, the HIBC should be supported.

With E-WMS on the handheld we already support Code39 and EAN128 barcode in different ways (like scan combination, SSCC).

HIBC uses logic to combine item code, batch number, serial number, end date and quantity values in one text string. After scanning the code, it should be split to the different entities.


Scanning a barcode is basically no more than filling the ‘keyboard buffer’, the scan head of a scanning device just translates a barcode. An HIBC barcode looks like a complicated barcode, but it just a row of digits. Only the meaning and format of the digits is decided by international rules, so any party in a logistic chain can use the barcode.

Below some examples with explanation of the text in the barcode

+J006476704   (LOT or Batch Number)

+$$051101815734Q   (Quantity / Date End / Batch Number)

+E186F122810/09293820285000FT  (Supplier LIC / ProductID|ItemCode)


There can be more elements in the barcode then we use in E-WMS. In E-WMS we support the following elements;

–    Item Code

–    Serial Number

–    Batch Number

–    Quantity

–    End Date

Note:  The HIBC functionality can be used mixed with code39 and/or EAN128. We strongly suggest using scanner Code Settings at E-MWS handheld settings. For more information about this check the E-WMS documentation on the Exact portal.

This HIBC code functionality is available from product update 399.

Pick-IT; A new look!

Written by Michiel Dorjee on . Posted in Exact Globe

Pick-ITt has been helping customers organize the logistic processes for years. While technical and functional improvements have taken place ever since its creation, the look and feel of the scanner has only been updated once in the past, when moving to an ASP front end.

The ASP software has recently been polished with an extra layer called Exact Remote Forms, or ERF for short, providing the second improvement of the GUI. It enables the ASP pages to be rendered outside a web browser with all consequences due.

The interface is no longer depending on restrictions of the various available browsers. Several features have been implemented that would not have been possible on a browser based interface. Foremost among those is advanced scrolling functionality. In stead of having to handle narrow scrollbars, the user may simply move the information around with his finger. The information scrolls along. A navigation box in the top left indicates the size of the total panel and small arrows indicate that there is some information off the screen, as shown below. The absence of scroll bars saves pixels on the already small scanner screens.

ERF dramatically increases customizability of the interface. A user with access to the configuration files can change colors, layout, button icons, fonts and font size and logos to their heart’s desire. The default skin (right) and a custom skin (left) are shown below, to give an idea of the possibilities


Not only does this customizability provide us the means to create a well designed interface, it involves the customer in its looks as well. You want the buttons in a different color? Now you can easily do so!