Table 91 User Setup
src/Layers/W1/BaseApp/System/User/UserSetup.Table.al579 lines, Copyright (c) Microsoft Corporation. MIT
namespace System.Security.User;using Microsoft.CRM.Team;using Microsoft.Inventory.Location;using System;using System.Automation;using System.Email;using System.Environment;using System.Environment.Configuration;using System.Security.AccessControl;table 91 "User Setup"{ Caption = 'User Setup'; DrillDownPageID = "User Setup"; LookupPageID = "User Setup"; ReplicateData = true; DataClassification = CustomerContent; fields { field(1; "User ID"; Code[50]) { Caption = 'User ID'; DataClassification = EndUserIdentifiableInformation; NotBlank = true; TableRelation = User."User Name"; ValidateTableRelation = false; trigger OnValidate() var UserSelection: Codeunit "User Selection"; begin UserSelection.ValidateUserName("User ID"); end; } field(2; "Allow Posting From"; Date) { Caption = 'Allow Posting From'; trigger OnValidate() begin CheckAllowedPostingDates(0); if xRec."Allow Posting From" <> Rec."Allow Posting From" then if Rec."Allow Posting From" <> 0D then Evaluate(Rec."Allow Posting From DateFormula", ''); end; } field(3; "Allow Posting To"; Date) { Caption = 'Allow Posting To'; trigger OnValidate() begin CheckAllowedPostingDates(0); if xRec."Allow Posting To" <> Rec."Allow Posting To" then if Rec."Allow Posting To" <> 0D then Evaluate(Rec."Allow Posting To DateFormula", ''); end; } field(4; "Register Time"; Boolean) { Caption = 'Register Time'; } field(5; "Allow Deferral Posting From"; Date) { Caption = 'Allow Deferral Posting From'; trigger OnValidate() begin CheckAllowedDeferralPostingDates(0); end; } field(6; "Allow Deferral Posting To"; Date) { Caption = 'Allow Deferral Posting To'; trigger OnValidate() begin CheckAllowedDeferralPostingDates(0); end; } field(10; "Salespers./Purch. Code"; Code[20]) { Caption = 'Salespers./Purch. Code'; TableRelation = "Salesperson/Purchaser" where(Blocked = const(false)); trigger OnValidate() begin if "Salespers./Purch. Code" <> '' then begin ValidateSalesPersonPurchOnUserSetup(Rec); EnsureUniqueSalesPersonPurchCode(); UpdateSalesPerson(FieldNo("Salespers./Purch. Code")); end; end; } field(11; "Approver ID"; Code[50]) { Caption = 'Approver ID'; DataClassification = EndUserIdentifiableInformation; TableRelation = "User Setup"."User ID"; trigger OnLookup() var UserSetup: Record "User Setup"; begin UserSetup.SetFilter("User ID", '<>%1', "User ID"); if PAGE.RunModal(PAGE::"Approval User Setup", UserSetup) = ACTION::LookupOK then Validate("Approver ID", UserSetup."User ID"); end; trigger OnValidate() begin if "Approver ID" = "User ID" then FieldError("Approver ID"); end; } field(12; "Sales Amount Approval Limit"; Integer) { BlankZero = true; Caption = 'Sales Amount Approval Limit'; trigger OnValidate() begin if "Unlimited Sales Approval" and ("Sales Amount Approval Limit" <> 0) then Error(ConflictingApprovalsErr, FieldCaption("Sales Amount Approval Limit"), FieldCaption("Unlimited Sales Approval")); if "Sales Amount Approval Limit" < 0 then Error(NegativeApprovalLimitErr); end; } field(13; "Purchase Amount Approval Limit"; Integer) { BlankZero = true; Caption = 'Purchase Amount Approval Limit'; trigger OnValidate() begin if "Unlimited Purchase Approval" and ("Purchase Amount Approval Limit" <> 0) then Error(ConflictingApprovalsErr, FieldCaption("Purchase Amount Approval Limit"), FieldCaption("Unlimited Purchase Approval")); if "Purchase Amount Approval Limit" < 0 then Error(NegativeApprovalLimitErr); end; } field(14; "Unlimited Sales Approval"; Boolean) { Caption = 'Unlimited Sales Approval'; trigger OnValidate() begin if "Unlimited Sales Approval" then "Sales Amount Approval Limit" := 0; end; } field(15; "Unlimited Purchase Approval"; Boolean) { Caption = 'Unlimited Purchase Approval'; trigger OnValidate() begin if "Unlimited Purchase Approval" then "Purchase Amount Approval Limit" := 0; end; } field(16; Substitute; Code[50]) { Caption = 'Substitute'; DataClassification = EndUserIdentifiableInformation; TableRelation = "User Setup"."User ID"; trigger OnLookup() var UserSetup: Record "User Setup"; begin UserSetup.SetFilter("User ID", '<>%1', "User ID"); if PAGE.RunModal(PAGE::"Approval User Setup", UserSetup) = ACTION::LookupOK then Validate(Substitute, UserSetup."User ID"); end; trigger OnValidate() begin if Substitute = "User ID" then FieldError(Substitute); end; } field(17; "E-Mail"; Text[100]) { Caption = 'E-Mail'; ExtendedDatatype = EMail; trigger OnValidate() var MailManagement: Codeunit "Mail Management"; begin UpdateSalesPerson(FieldNo("E-Mail")); MailManagement.ValidateEmailAddressField("E-Mail"); end; } field(18; "Phone No."; text[30]) { Caption = 'Phone No.'; DataClassification = CustomerContent; ExtendedDatatype = PhoneNo; trigger OnValidate() var Char: DotNet Char; i: Integer; begin for i := 1 to StrLen("Phone No.") do if Char.IsLetter("Phone No."[i]) then FieldError("Phone No.", PhoneNoCannotContainLettersErr); UpdateSalesPerson(FieldNo("Phone No.")); end; } field(19; "Request Amount Approval Limit"; Integer) { BlankZero = true; Caption = 'Request Amount Approval Limit'; trigger OnValidate() begin if "Unlimited Request Approval" and ("Request Amount Approval Limit" <> 0) then Error(ConflictingApprovalsErr, FieldCaption("Request Amount Approval Limit"), FieldCaption("Unlimited Request Approval")); if "Request Amount Approval Limit" < 0 then Error(NegativeApprovalLimitErr); end; } field(20; "Unlimited Request Approval"; Boolean) { Caption = 'Unlimited Request Approval'; trigger OnValidate() begin if "Unlimited Request Approval" then "Request Amount Approval Limit" := 0; end; } field(21; "Approval Administrator"; Boolean) { Caption = 'Approval Administrator'; trigger OnValidate() var UserSetup: Record "User Setup"; IsHandled: Boolean; begin IsHandled := false; OnBeforeValidateApprovalAdministrator(Rec, IsHandled); if IsHandled then exit; if "Approval Administrator" then begin UserSetup.SetRange("Approval Administrator", true); if not UserSetup.IsEmpty() then FieldError("Approval Administrator"); end; end; } field(22; "Allow VAT Date From"; Date) { Caption = 'Allow VAT Date From'; DataClassification = CustomerContent; trigger OnValidate() begin CheckAllowedVATDates(0); end; } field(23; "Allow VAT Date To"; Date) { Caption = 'Allow VAT Date To'; DataClassification = CustomerContent; trigger OnValidate() begin CheckAllowedVATDates(0); end; } field(31; "License Type"; Option) { CalcFormula = lookup(User."License Type" where("User Name" = field("User ID"))); Caption = 'License Type'; FieldClass = FlowField; OptionMembers = "Full User","Limited User","Device Only User","Windows Group","External User","External Administrator","External Accountant","Application","AAD Group"; OptionCaption = 'Full User,Limited User,Device Only User,Windows Group,External User,External Administrator,External Accountant,Application,Microsoft Entra group'; } field(80; "Sales Invoice Posting Policy"; Enum "Invoice Posting Policy") { Caption = 'Sales Invoice Posting Policy'; } field(90; "Purch. Invoice Posting Policy"; Enum "Invoice Posting Policy") { Caption = 'Purch. Invoice Posting Policy'; } field(950; "Time Sheet Admin."; Boolean) { Caption = 'Time Sheet Admin.'; } field(5600; "Allow FA Posting From"; Date) { Caption = 'Allow FA Posting From'; } field(5601; "Allow FA Posting To"; Date) { Caption = 'Allow FA Posting To'; } field(5700; "Sales Resp. Ctr. Filter"; Code[10]) { Caption = 'Sales Resp. Ctr. Filter'; TableRelation = "Responsibility Center".Code; } field(5701; "Purchase Resp. Ctr. Filter"; Code[10]) { Caption = 'Purchase Resp. Ctr. Filter'; TableRelation = "Responsibility Center"; } field(5900; "Service Resp. Ctr. Filter"; Code[10]) { Caption = 'Service Resp. Ctr. Filter'; TableRelation = "Responsibility Center"; } field(5980; "Service Invoice Posting Policy"; Enum "Invoice Posting Policy") { Caption = 'Service Invoice Posting Policy'; } field(5991; "Allow Posting From DateFormula"; DateFormula) { Caption = 'Allow Posting From Date Formula'; trigger OnValidate() begin if xRec."Allow Posting From DateFormula" <> Rec."Allow Posting From DateFormula" then if Format(Rec."Allow Posting From DateFormula") <> '' then Rec.Validate("Allow Posting From", 0D); end; } field(5992; "Allow Posting To DateFormula"; DateFormula) { Caption = 'Allow Posting To Date Formula'; trigger OnValidate() begin if xRec."Allow Posting To DateFormula" <> Rec."Allow Posting To DateFormula" then if Format(Rec."Allow Posting To DateFormula") <> '' then Rec.Validate("Allow Posting To", 0D); end; } } keys { key(Key1; "User ID") { Clustered = true; } key(Key2; "Salespers./Purch. Code") { } } fieldgroups { fieldgroup(DropDown; "User ID") { } } trigger OnDelete() var NotificationSetup: Record "Notification Setup"; begin NotificationSetup.SetRange("User ID", "User ID"); NotificationSetup.DeleteAll(true); end; trigger OnInsert() begin SetEmailOnRecord(); end; var SalesPersonPurchaser: Record "Salesperson/Purchaser"; UserSetupManagement: Codeunit "User Setup Management";#pragma warning disable AA0470 DuplicateSalesPersonErr: Label 'The %1 Salesperson/Purchaser code is already assigned to another User ID %2.'; ConflictingApprovalsErr: Label 'You cannot have both a %1 and %2. ';#pragma warning restore AA0470 NegativeApprovalLimitErr: Label 'You cannot have approval limits less than zero.'; PrivacyBlockedGenericErr: Label 'Privacy Blocked must not be true for Salesperson / Purchaser %1.', Comment = '%1 = salesperson / purchaser code.'; PhoneNoCannotContainLettersErr: Label 'must not contain letters'; procedure CreateApprovalUserSetup(User: Record User) var UserSetup: Record "User Setup"; ApprovalUserSetup: Record "User Setup"; begin ApprovalUserSetup.Init(); ApprovalUserSetup.Validate("User ID", User."User Name"); ApprovalUserSetup.Validate("Sales Amount Approval Limit", GetDefaultSalesAmountApprovalLimit()); ApprovalUserSetup.Validate("Purchase Amount Approval Limit", GetDefaultPurchaseAmountApprovalLimit()); ApprovalUserSetup.Validate("E-Mail", User."Contact Email"); UserSetup.SetRange("Sales Amount Approval Limit", UserSetup.GetDefaultSalesAmountApprovalLimit()); if UserSetup.FindFirst() then ApprovalUserSetup.Validate("Approver ID", UserSetup."Approver ID"); if ApprovalUserSetup.Insert() then; end; local procedure EnsureUniqueSalesPersonPurchCode() var UserSetup: Record "User Setup"; IsHandled: Boolean; begin IsHandled := false; OnBeforeEnsureUniqueSalesPersonPurchCode(Rec, IsHandled); if IsHandled then exit; UserSetup.SetCurrentKey("Salespers./Purch. Code"); UserSetup.SetRange("Salespers./Purch. Code", "Salespers./Purch. Code"); if UserSetup.FindFirst() then Error(DuplicateSalesPersonErr, "Salespers./Purch. Code", UserSetup."User ID"); end; procedure GetDefaultSalesAmountApprovalLimit(): Integer var UserSetup: Record "User Setup"; DefaultApprovalLimit: Integer; LimitedApprovers: Integer; begin UserSetup.SetRange("Unlimited Sales Approval", false); if UserSetup.FindFirst() then begin DefaultApprovalLimit := UserSetup."Sales Amount Approval Limit"; LimitedApprovers := UserSetup.Count(); UserSetup.SetRange("Sales Amount Approval Limit", DefaultApprovalLimit); if LimitedApprovers = UserSetup.Count then exit(DefaultApprovalLimit); end; // Return 0 if no user setup exists or no default value is found exit(0); end; procedure GetDefaultPurchaseAmountApprovalLimit(): Integer var UserSetup: Record "User Setup"; DefaultApprovalLimit: Integer; LimitedApprovers: Integer; begin UserSetup.SetRange("Unlimited Purchase Approval", false); if UserSetup.FindFirst() then begin DefaultApprovalLimit := UserSetup."Purchase Amount Approval Limit"; LimitedApprovers := UserSetup.Count(); UserSetup.SetRange("Purchase Amount Approval Limit", DefaultApprovalLimit); if LimitedApprovers = UserSetup.Count then exit(DefaultApprovalLimit); end; // Return 0 if no user setup exists or no default value is found exit(0); end; procedure HideExternalUsers() var EnvironmentInfo: Codeunit "Environment Information"; OriginalFilterGroup: Integer; begin if not EnvironmentInfo.IsSaaS() then exit; OriginalFilterGroup := FilterGroup; FilterGroup := 2; CalcFields("License Type"); SetFilter("License Type", '<>%1&<>%2', "License Type"::"External User", "License Type"::"AAD Group"); FilterGroup := OriginalFilterGroup; end; procedure UpdateSalesPerson(FieldNumber: Integer) var SalespersonPurchaser: Record "Salesperson/Purchaser"; xSalespersonPurchaser: Record "Salesperson/Purchaser"; begin if "Salespers./Purch. Code" = '' then exit; if SalespersonPurchaser.Get("Salespers./Purch. Code") then begin xSalespersonPurchaser := SalespersonPurchaser; if FieldNumber in [fieldno("E-Mail"), FieldNo("Salespers./Purch. Code")] then begin SalespersonPurchaser."E-Mail" := CopyStr("E-Mail", 1, MaxStrLen(SalespersonPurchaser."E-Mail")); SalespersonPurchaser."Search E-Mail" := SalespersonPurchaser."E-Mail"; end; if FieldNumber in [fieldno("Phone No."), FieldNo("Salespers./Purch. Code")] then SalespersonPurchaser."Phone No." := "Phone No."; if (SalespersonPurchaser."E-Mail" <> xSalespersonPurchaser."E-Mail") or (SalespersonPurchaser."Search E-Mail" <> xSalespersonPurchaser."Search E-Mail") or (SalespersonPurchaser."Phone No." <> xSalespersonPurchaser."Phone No.") then SalespersonPurchaser.Modify(); end; end; local procedure ValidateSalesPersonPurchOnUserSetup(UserSetup2: Record "User Setup") begin if UserSetup2."Salespers./Purch. Code" <> '' then if SalesPersonPurchaser.Get(UserSetup2."Salespers./Purch. Code") then if SalesPersonPurchaser.VerifySalesPersonPurchaserPrivacyBlocked(SalesPersonPurchaser) then Error(PrivacyBlockedGenericErr, UserSetup2."Salespers./Purch. Code") end; local procedure SetEmailOnRecord() var User: Record User; MailManagement: Codeunit "Mail Management"; UserSetupEmail: Text[100]; begin if "E-Mail" <> '' then exit; if "User ID" = '' then exit; User.SetRange("User Name", "User ID"); if not User.FindFirst() then exit; UserSetupEmail := CopyStr(User."Contact Email", 1, MaxStrLen("E-Mail")); if not MailManagement.CheckValidEmailAddress(UserSetupEmail) then exit; "E-Mail" := UserSetupEmail; end; procedure CheckAllowedVATDates(NotificationType: Option Error,Notification) begin UserSetupManagement.CheckAllowedVATDatesRange("Allow VAT Date From", "Allow VAT Date To", NotificationType, Database::"User Setup"); end; procedure CheckAllowedPostingDates(NotificationType: Option Error,Notification) var AllowedFrom: Date; AllowedTo: Date; begin AllowedFrom := Rec."Allow Posting From"; AllowedTo := Rec."Allow Posting To"; UserSetupManagement.GetDateRange( AllowedFrom, AllowedTo, Rec."Allow Posting From DateFormula", Rec."Allow Posting To DateFormula", Rec.RecordId()); UserSetupManagement.CheckAllowedPostingDatesRange( AllowedFrom, AllowedTo, NotificationType, DATABASE::"User Setup"); end; procedure CheckAllowedDeferralPostingDates(NotificationType: Option Error,Notification) begin UserSetupManagement.CheckAllowedPostingDatesRange( "Allow Deferral Posting From", "Allow Deferral Posting To", NotificationType, DATABASE::"User Setup", FieldCaption("Allow Deferral Posting From"), FieldCaption("Allow Deferral Posting To")); end; [IntegrationEvent(false, false)] local procedure OnBeforeEnsureUniqueSalesPersonPurchCode(var UserSetup: Record "User Setup"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeValidateApprovalAdministrator(var UserSetup: Record "User Setup"; var IsHandled: Boolean) begin end;}