Skip to Content
Menu

Easy Inventory Adjustment With QR Code

by
Odoo

105.44

v 15.0 Third Party 1
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Inventory (stock)
Discuss (mail)
Community Apps Dependencies
Lines of code 879
Technical Name eis_inventory_qr_support
LicenseOPL-1
Websitehttp://www.expertpk.com
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Inventory (stock)
Discuss (mail)
Community Apps Dependencies
Lines of code 879
Technical Name eis_inventory_qr_support
LicenseOPL-1
Websitehttp://www.expertpk.com

Easy Inventory Operation

Scan QR Code and do invenotry adjustment - Automate counting, lot name & serial number handling.



Application Details

Let's learn about this app in detail.

Basic Overview
This module extends the module "Inventory Adjustment Barcode Scanner" and add the ability to do inventory operation with QR Code scanning. It also add the ability to automatically handle the lot / serial numbers in quant. 

It support GS1-128 (UCC/EAN-128) GS1-Datamatrix.

It will decode gs1-128 string and extract 4 types of info. '01 or 02': GTIN, '10': LOT, '17': Expiration Date, and '21': Serial No. It will try to search product with GTIN number, it will use product's barcode and default_code field to search for product.

Yes, it will try to find existing quant, if no quant available, it will create new quant, it will create lot / serial number only if product tracking is enable.
Date Version Release Info
Oct 19, 2022 15.0.1.0.1 Initial Release

Installation

Copy all 3 modules into addons folder, restart odoo service, update apps and install the module as usual. Nothning special needed.

Important Information

You should read GS1-128 Parser module's documentation for how to configure your database to interprate QR code in required information properly. GS1-128 Parser module is included.

Extrated Information

This module support / extract 4 key, values from QR Code String.

  1. 01: GTIN [ai = 01, data = 14 digits fixed lenght] Only valid GTIN will work.
  2. 02: GTIN [ai = 02, data = 14 digits fixed lenght] if 01 not found then this will be used. 
  3. 10: Lot Name [ai= 10, data= Variable length string]
  4. 17: Expiration Date [ai=17, data= 6 digit date format]
  5. 21: Serial Number [ai=21, data= variable lenght string]

It will use extracted GTIN as barcode to search product (barcode or default_code field in product). It will use Other 3 values only if product tracking is enabled.

Lot Name: This field will be used to search existing quants having this lot name and this GTIN product. In search quant method, it will not use Expiration Date data. If it failed to find existing quant, it will create new quant for the searched product and it will try to find Lot in existing lots, if it found existing lot, it will use it, otherwise it will create new lot and here it will use Expiration Date in new lot. 

Serial Number: Same as lot name with little difference, Serial number can be assigned to single product only that is why it will be handled this way. You can not count more than one counted quantity with same serial number. You can not create another quant in a location if a product with same serail number aleady exist in another location. Yes it will create new serial number automatically if there is no existing serial number available in system during new quant creation.

Error handling

Scanned barcode will be handled by this module in inventory adjustment screen. App will try to decode it using gs1-128 parser module, if it detect it as qr code, it will handle it, otherwise it will send barocde to eis_inventory_barcode module to handle it as barcode. It will raise a user error if it found an invalid GTIN number in the qr code. Remember that, if there is an invalid GTIN in QR Code, it will not decode it. Hence, you can disable Invalid GTIN check in company setting (please follow the documentation of GS1-Parser module). 

If it detect scanned code as QR Code, it will try to extract 4 information pieces as describe above, it will use GTIN (01 or 02) to search product & quant for product.

it will check if product has tracking enabled or not. If tracking is not enabled, it will send GTIN as barcode to eis_inventory_barcode module and it will also ignore lot number / serial number and expiration date.

In the other hand, if it detect scanned dcode as QR Code but QR code does not have Lot / Serial number in it, it will ignore them and send GTIN as barcode to eis_inventory_barcode app to handle it as plain barcode. 



We can do useful things for our clients

Having 10+ years of experience in Odoo we can provide you best quality services.

Development

Clean, compact and reusable code, tightly integrated with Odoo Framework.

Learn More

Deployment

With highly skilled Linux administrators in team, we cn deploy odoo perfectlly for your company. 

Learn More

Technical Implementation

With a huge experince, our odoo technical team will help you setup your company database perfectlly and seamlessly.

Learn More

Data Migration

We provide data migration service from all major products to odoo.

Learn More

Recomended Products

Phone

  • +92 300 7888120

© 2008 - 2022. All Rights Reserved - Expert IT Solutions

Easy Inventory With QR Code Scanning

Module Installation

  1. Download module and its dependencies and unzip them.
  2. Copy extracted folders to addons directory.
  3. Restart Odoo service (i.e in Ubuntu: sudo systemctl restart odoo-service)
  4. Login to your Odoo instance, activate developer mode and go to Apps menu.
  5. Press ‘Update App List’ button.
  6. Install module from the list of modules.

Configuration

If you want to change <GS> separator (default is ASCII character 29) follow the steps below.
  1. Click on your user name at top right corner.
  2. Click on preferences.
  3. Go to QR Group Separator Tab and enter your custom FNC1 GS and then save.

This module will try to parse QR Code with GS1-128 parser. It will extract following application identifiers.
  1. ‘01’ as GTIN
  2. ‘02’ as GTIN if ‘01’ is not available.
  3. ‘10, Lot Name
  4. ‘17’ Expiration Date
  5. ‘21’ Serial Number

In this list GTIN should be a 14 digit Valid GTIN. It will validate GTIN for check digit. On failuer it will raise error. If you don't want to validate GTIN, You can allow invalid GTIN in company settings.

To allow it, go to settings, users & companies > company. Then edit your desired company and go to ‘Invalid GTIN Allowed’ tab and deselect ‘Only Valid GTIN Allowed’.

Inventory Operation

  1. Go to Inventory > Operation > Inventory Adjustment.
  2. Start scanning the bar-code / QR Code of your product to start counting.
Odoo Proprietary License v1.0

This software and associated files (the "Software") may only be used (executed,
modified, executed after modifications) if you have purchased a valid license
from the authors, typically via Odoo Apps, or if you have received a written
agreement from the authors of the Software (see the COPYRIGHT file).

You may develop Odoo modules that use the Software as a library (typically
by depending on it, importing it and using its resources), but without copying
any source code or material from the Software. You may distribute those
modules under the license of your choice, provided that this license is
compatible with the terms of the Odoo Proprietary License (For example:
LGPL, MIT, or proprietary licenses similar to this one).

It is forbidden to publish, distribute, sublicense, or sell copies of the Software
or modified copies of the Software.

The above copyright notice and this permission notice must be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM,
DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
DEALINGS IN THE SOFTWARE.

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.