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

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Binesh 7,887 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
luapolemunges 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Binesh,

It worked as I wanted thanks alot

Was this reply helpful? Yes No