UoM Barcode Functionality

Overview

The Unit of Measurement (UoM) Group feature in SAP Business One allows you to assign different UoMs to an item for sales, purchasing, inventory, and production transactions. This feature ensures that all transactions involving the item are processed correctly according to predefined conversion rules, making inventory management more accurate and efficient.

Setting Up UoM Groups

Item Master Data with UoM Barcode Setup

In the Item Master Data screen, you can configure the UoM groups and their associated barcodes for an item. Here's what you need to do:

1. Access Item Master Data:

   • Go to the Item Master Data screen in SAP Business One.

   • Find the item you want to configure UoM groups for (e.g., Item Code A00002).

2. Assign UoM Groups and Barcodes:

   • Define the UoM groups and their barcodes. For example:

     • UoM Group for “Pieces” → 2345

     • UoM Group for “Box” - Barcode → 2B1234

     • UoM Group for “Palette” - Barcode → 2P1234

   This setup allows the system to recognize the item when any of these barcodes are scanned.

Retrieving Barcodes for UoM Groups

To find barcodes for UoM Groups, use the following SQL query:

SELECT * FROM OBCD T0 WHERE T0.[ItemCode] ='A00002'

Using UoM Groups in Transactions

Important Considerations

When processing documents in SAP Business One, it is crucial to ensure that inventory quantities are managed according to the UoM Group configured in the Item Master Data. This means that inventory should be adjusted based on the UoM conversion rules set up for the item.

Example Configuration for Item Code “A00002”:

• Base UoM: Pieces

• Conversion Rules:

  • 1 Pieces = 1 Pieces

  • 1 Box = 10 Pieces

  • 1 Palette = 100 Pieces

These conversion rules will dictate how inventory quantities are calculated and displayed in transactions.

How UoMs are scanned ?

A UoMs can be scanned using the Barcode configured in the UoM group definition. When we scanned the barcode value 2345 (Pieces), scanner read out the UoMs configuration rule and add add the quantity from the rule on the screen on each successful scanning.

We can even use the barcode for 2P1234 (Palette ) or 2B1234 (Box) while scanning the items over the scanner. Scanner application will do the validation and completed the scanning if Scanned barcode found.

Incase of the wrong scanning of the barcode we might have the error like below.

Multi-UoMs Scanning

Here we are using an Multi-UoMs item A00002 in all the below scenario to explain the process of scanning.

While scanning the Item barcode of we scanned a different barcode of the same items which is not assigned on the document lines items then scanner always prompt with two Option

i) Overwrite UoM to existing line

This option change the original UoM defined on the items level and started counting the qty according to the new UoMs. If the line has any existing qty then scanner convert the existing qty according to the new scanned UoM

ii) Count the scanned UoM to the Existing Scanning

This option do not change the UoM of the existing line items. When user select this option the scanned qty gets converted according to the UoMs defined on the line items.

1. Stock Counting

This document contains the items A00002 as mentioned in the Setting Up UoM Groups section.

Here i have scanned the Item barcode 2B1234 (Box) and upon scanning system Prompted with the following option. Here i have selected the 1st Option

After the selection of the 1st Option following changes are applied on the Items qty and UoMs

i > Item Qty is 1 Box

ii > UoMs changed from Pallet to Box

Now again we scanned the item barcode 2P1234 (Pallet) and select the 2nd option

Once we selected the option 2 upon successful scanning we can see the following changes on the scanner

i > qty from pallet (100) converted in to the Box (10 ) and added to the line. Item Qty becomes 11 Box which was previously 1.

ii > UoMs still Box and does not change

So with each scanning of the UoMs barcode, scanner read the UoMs configuration and process the quantity in the scanner application.

Quantity Calculation over the MultiUoMs Scanning
Scanning sequence and quantity calculation for Item Code “A00002” where the Inital UoM is Pallet with the selection of the option on the scanner-

A) Overwrite UoM to existing line

B) Count the scanned UoM to the Existing Scanning