How to find/check if item is already exist in business central

(1) Share

Report

Posted on by Nil@@m

247

Hi Guys,

I want do the customization :

Giving an error on the item reference table if a barcode is entered but already exists on another item?
Is any way to do this.

For example:
I have open Item 0000005 ,then I click on Item reference action.It will open item reference page.
On that page ,I have enter the Reference type as ::Barcode & enter reference no:1234.Then,
I have open Item 0000006 ,then I click on Item reference action.It will open item reference page.
On that page ,I have enter the Reference type as ::Barcode & again enter same reference no:1234
Now that time it shows an error message: 'The Reference no is already exist for another item,

below is the 1st Item

Below is the 2nd Item

All responses (1)

Answers (0)

Suggested answer

Mohana Yadav 60,250 Super User 2025 Season 1 on at

Like (1)

Report
How to find/check if item is already exist in business central

You can change as per your requirements.

[EventSubscriber(ObjectType::Table, Database::"Item Reference", 'OnBeforeValidateEvent', "Reference No.", false, false)] local procedure ItemReferenceOnBeforeValidateEvent(var Rec: Record "Item Reference"; var xRec: Record "Item Reference"; CurrFieldNo: Integer) var ItemReference: Record "Item Reference"; begin if Rec."Reference No." <> '' then begin ItemReference.SetRange("Reference Type", Rec."Reference Type"); ItemReference.SetRange("Reference No.", Rec."Reference No."); if not ItemReference.IsEmpty() then Error('Item Reference already exists.'); end; end;