External Document Number in Sales Order

(0) Share

Report

Posted on by P V Sarath

130

When we are not given the external Document No. we should not allow to insert Sales lines in the sales order, I am attaching my code what I have tried but I did not get it and can you share me any example how we can do it.

trigger OnAfterGetCurrRecord()

var

myInt: Integer;

SalesLine: Record "Sales Line";

Value1: Text[20];

Text000: Label 'The external document No. have to be given';

begin

if Rec."External Document No." = '' then

Rec.FieldError("External Document No.", Text000);

end;

All responses (3)

Answers (1)

Verified answer

YUN ZHU 82,945 Super User 2025 Season 1 on at

Like (0)

Report
RE: External Document Number in Sales Order

Hi, please try the following.

tableextension 50109 MyExtension extends "Sales Line" { trigger OnBeforeInsert() var SalesHeader: Record "Sales Header"; Text000: Label 'The external document No. have to be given'; begin if SalesHeader.Get(SalesHeader."Document Type"::Order, Rec."Document No.") then if SalesHeader."External Document No." = '' then Error(Text000); end; }

Thanks.

ZHU
Suggested answer

tanya07 1,636 on at

Like (0)

Report

RE: External Document Number in Sales Order

Hi,

Please follow as below -

[EventSubscriber(ObjectType::Codeunit, 414, 'OnBeforeReleaseSalesDoc', '', false, false)]

local procedure MyProcedure(var SalesHeader: Record "Sales Header")

begin

SalesHeader.TestField(ExtDocNo);

end;

Thanks,

Tanya Kharbanda

Don't forget to help the community by verifying the answer if your question has been answered. It will let others know that the topic has a verified answer.
Suggested answer

MahGah 15,443 on at

Like (0)

Report

RE: External Document Number in Sales Order

Hi

Please see suggestions in this post

community.dynamics.com/.../i-need-to-do-external-document-no-as-mandatory