Case: Use your own custom Item Barcode table
- Dennis Vibæk
- Johannes Sebastian Nielsen
Requirements
Business Central 17
Mobile WMS extension MOB5.24
Case
A customer wishes to start using there own Item Barcode table when scanning Items on the mobile device.
Proposed solution
To implement using your own custom Item Barcode table instead of using the standard Cross Reference table or Item Reference table (BC17) you should use the following two Events.
First you override the GetBarcodeList to collect your own Item Barcodes and then apply you own logic to lookup the Item in your own custom Item Barcode table.
Step 1: Apply values from your own Item Barcode table when returning the list of available item Barcodes to the mobile device.
Using event MobItemReferenceMgt - OnBeforeGetBarcodeList
// [Example]: Add Item Identifiers to _BarcodeList
[EventSubscriber(ObjectType::Codeunit, Codeunit::"MOB Item Reference Mgt.", 'OnBeforeGetBarcodeList', '', true, true)]
local procedure MyOnBeforeGetBarcodeList(_ItemNo: Code[20]; _VariantCode: Code[10]; var _BarcodeListToReturn: Text; var _IsHandled: Boolean)
var
ItemIdentifier: Record "Item Identifier";
begin
// Intentionally do not exit here if _IsHandled but always add ItemIdentifiers to BarcodeList
ItemIdentifier.SetRange("Item No.", _ItemNo);
ItemIdentifier.SetRange("Variant Code", _VariantCode);
if ItemIdentifier.FindSet() then
repeat
if _BarcodeListToReturn = '' then
_BarcodeListToReturn := ItemIdentifier.Code
else
_BarcodeListToReturn += ';' + ItemIdentifier.Code;
until ItemIdentifier.Next() = 0;
_IsHandled := true;
end;
Step 2: Handle the search for an Item in your own Item Barcode table
Using event MobItemReferenceMgt - OnBeforeSearchItemReference
// [Example]: If Item is found by filtering on ItemIdentifiers then do not search through Item References
[EventSubscriber(ObjectType::Codeunit, Codeunit::"MOB Item Reference Mgt.", 'OnBeforeSearchItemReference', '', true, true)]
local procedure MyOnBeforeSearchItemReference(_ScannedBarcode: Code[50]; var _ReturnItemNo: Code[20]; var _ReturnVariantCode: Code[10]; var _IsHandled: Boolean)
var
ItemIdentifier: Record "Item Identifier";
begin
ItemIdentifier.SetRange(code, _ScannedBarcode);
if ItemIdentifier.Findfirst() then begin
_ReturnItemNo := ItemIdentifier."Item No.";
_IsHandled := true;
end;
end;
Test your solution
- Add your own custom Item Barcodes to an Item.
- Open "Locate Item" on the mobile device and scan your custom Item Barcode. Now you should see your Item is found based on the scanned value.
- Create a Pick including you Item with the custom Item Barcode added.
- Select the Pick on the mobile device and scan your custom Item Barcode. Now you should see the pickline containing your item with the custom Item Barcode selected.