Block double entry of item number in the sales line

(0) Share

Report

Posted on by luapolemunges

Am new in navision development I want to block a user from entering two same item number in the sales line this is because the user can inserts different quantities in the two lines in the same order number and two same item numbers want to have only one item number in the sales line not repeating the items number in the lines.Am using navision 2015.

*This post is locked for comments

All responses (2)

Answers (1)

luapolemunges 5 on at

Like (0)

Report

RE: Block double entry of item number in the sales line

Hi Binesh,

It worked as I wanted thanks alot
Verified answer

Binesh 7,885 on at

Like (0)

Report

RE: Block double entry of item number in the sales line

Hello luapolemunges,

Create a function in codeunit, subscribe this function and write the below code or you can write this code in OnValidate - No. field on sales Line Table

//SalesLine is a record variable of sales line Table 37

SalesLine.RESET;
SalesLine.SETRANGE("Document Type", Rec."Document Type");
SalesLine.SETRANGE("Document No.", Rec."Document No.");
SalesLine.SETRANGE(Type, SalesLine.Type::Item);
SalesLine.SETRANGE("No.", Rec."No.");
IF SalesLine.FINDFIRST THEN
ERROR('%1 item already exist in this order!', Rec."No.");

for reference see attachments.