Welcome to the Exact Product Blog

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

Posts Tagged ‘barcode’

Introducing barcodes on all layouts of Exact Online

Written by Pieter Hamans on . Posted in Exact Online

BARCODES-000

Barcodes are machine-readable representations of data. They are nowadays stuck to virtually every product and with the help of an appropriate device they disclose a price, eligibility for warranty, shipping destination or flight number. Until recent, Exact Online would support only for a few fields on a few layouts to print a barcode. We have now developed the ability to print barcodes for any field on any layout.

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.
 

Benefits:

  • 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.

E-WMS supports HIBC barcode

Written by Michiel Dorjee on . Posted in Exact Globe

Introduction

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.

Description

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 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.

Using barcodes on Exact lay-outs with code39 font

Written by Michiel Dorjee on . Posted in Exact Globe

Introduction

It is possible to print bar codes on Globe layouts, like a production order printout. This enables your employees to scan the order number when using it, especially for production orders this can be a big help. The bar code can be scanned with mobile scan devices (like for E-WMS) but also with a scanner attached to your PC (keyboard wedge scanning), so the order number or item code can be scanned within an application like Exact Globe.

Description

You can use attached bar code font to print bar codes within any Windows program that support truetype fonts, so including Microsoft Office applications, and Exact Globe.

Download the attachment and copy it, using Windows Explorer, to the folder C:\Windows\Fonts (or your own Windows fonts folder). Then it will be automatically installed. After installation this font will be available within windows applcations with the name “cb_Code 39 one”.

In general, when using a CODE39 type bar code, any bar code should start and stop with an asterix ( * ).

In Exact lay-outs, there are two ways to print these bar codes:
1.  calculated fields
2.  database fields with ‘introductory’ and ‘subsequent’ texts

Calculation field

Create a new calculation field in the desired ‘block’, and press ‘Change expression’.

Sample for an item code:

     CONCAT(“*”;trim([Item code]);”*”)

Set the length of the field to the length of the database field + 2.
Then change this field to font type “cb_Code 39 one” and make it rather large, like size 22 or even larger.

Database field

Another method is to place just the database field itself, with prefix and suffix text ‘*’.

‘introductory’ text = *, ‘subsequent’ text = *
alignment database field = place next to previous field without space
alignment introductory text = align right
alignment subsequent text = place next to previous field without space
font type = “cb_code 39 one”

Sample for ‘production order’ field with method ‘database field’:

Possibilities in Excel

Microsoft Excel offers a lot of possibilities to generate bar code lists when using this font. You could generate (a range of) values in Excel, add prefix and suffix to these values, and print the result with this font. This will generate a list of bar codes.


In this sample, following data is used:

  • column A contains the generated or imported data.
  • column B (cell B1) is a formula field:
    English =CONCATENATE(“*”;A1;”*”)
    Dutch =TEKST.SAMENVOEGEN(“*”;A1;”*”)
  • column C is the same as B, but formatted with font “cb_Code 39 one”, size 28 pt.

Make sure to allow some space between the rows, otherwise scanning one particular bar code is more difficult.

Remarks

Adding the prefix/suffix ‘*’ is only mandatory when using this font for CODE39 bar codes. When printing CODE39 bar codes with bar code labelling software like Bartender, the prefix and suffix are automatically added by the software.