Share
Report
28When it enters the loop it should check if a job number already exists or not if exists it should increment like 001 to 002
for example Sell-to Customer No = 1000
job number will be1000-001
if 1000-001 exist the it should increment to 1000-002
code:
for example Sell-to Customer No = 1000
job number will be1000-001
if 1000-001 exist the it should increment to 1000-002
code:
trigger OnAfterValidate()
var
GetNo: Text;
begin
GetNo := '';
Rec.get(rec./No./);
if Rec.FindSet() then
repeat
GetNo := Rec./Sell-to Customer No./ + '-' + IncStr('001');
Rec./No./ := GetNo;
Rec.Rename(GetNo);
until Rec.Next() = 0;
end;
Categories:
All responses (
Answers (
