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

(1) Share

Report

Posted on by Test user

305

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

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Mohana Yadav 61,016 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!
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;

Was this reply helpful? Yes No