Table 5850 Invt. Document Header
src/Layers/W1/BaseApp/Inventory/Document/InvtDocumentHeader.Table.al594 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Inventory.Document;using Microsoft.CRM.Team;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Foundation.AuditCodes;using Microsoft.Foundation.NoSeries;using Microsoft.Inventory.Comment;using Microsoft.Inventory.Location;using Microsoft.Inventory.Setup;using Microsoft.Inventory.Tracking;using Microsoft.Warehouse.Structure;using System.Globalization;table 5850 "Invt. Document Header"{ Caption = 'Item Document Header'; DataCaptionFields = "Document Type", "No."; LookupPageID = "Invt. Document List"; DataClassification = CustomerContent; fields { field(1; "Document Type"; Enum "Invt. Doc. Document Type") { Caption = 'Document Type'; } field(2; "No."; Code[20]) { Caption = 'No.'; ToolTip = 'Specifies the number of the involved entry or record, according to the specified number series.'; trigger OnValidate() begin if "No." <> xRec."No." then begin InvtSetup.Get(); NoSeries.TestManual(GetNoSeriesCode()); "No. Series" := ''; end; end; } field(3; "Posting Description"; Text[100]) { Caption = 'Posting Description'; ToolTip = 'Specifies any text that is entered to accompany the posting, for example for information to auditors.'; } field(5; "Document Date"; Date) { Caption = 'Document Date'; ToolTip = 'Specifies the date when the related document was created.'; trigger OnValidate() begin UpdateItemDocLines(FieldNo("Document Date")); end; } field(6; "Posting Date"; Date) { Caption = 'Posting Date'; ToolTip = 'Specifies the entry''s posting date.'; trigger OnValidate() begin UpdateItemDocLines(FieldNo("Posting Date")); end; } field(7; "Location Code"; Code[10]) { Caption = 'Location Code'; ToolTip = 'Specifies the warehouse or other place where the involved items are handled or stored.'; TableRelation = Location.Code where("Use As In-Transit" = const(false)); trigger OnValidate() begin Location.Get("Location Code"); Location.TestField("Directed Put-away and Pick", false); UpdateItemDocLines(FieldNo("Location Code")); CreateDimFromDefaultDim(); end; } field(8; "Shortcut Dimension 1 Code"; Code[20]) { CaptionClass = '1,2,1'; Caption = 'Shortcut Dimension 1 Code'; ToolTip = 'Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window.'; TableRelation = "Dimension Value".Code where("Global Dimension No." = const(1), Blocked = const(false)); trigger OnValidate() begin Rec.ValidateShortcutDimCode(1, "Shortcut Dimension 1 Code"); end; } field(9; "Shortcut Dimension 2 Code"; Code[20]) { CaptionClass = '1,2,2'; Caption = 'Shortcut Dimension 2 Code'; ToolTip = 'Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window.'; TableRelation = "Dimension Value".Code where("Global Dimension No." = const(2), Blocked = const(false)); trigger OnValidate() begin Rec.ValidateShortcutDimCode(2, "Shortcut Dimension 2 Code"); end; } field(10; "Language Code"; Code[10]) { Caption = 'Language Code'; TableRelation = Language; } field(11; "Salesperson/Purchaser Code"; Code[20]) { Caption = 'Salesperson/Purchaser Code'; ToolTip = 'Specifies the employee purchaser code or salesperson code associated with this document.'; TableRelation = "Salesperson/Purchaser" where(Blocked = const(false)); trigger OnValidate() begin CreateDimFromDefaultDim(); end; } field(12; "Receipt Comment"; Boolean) { CalcFormula = exist("Inventory Comment Line" where("Document Type" = const("Inventory Receipt"), "No." = field("No."))); Caption = 'Receipt Comment'; Editable = false; FieldClass = FlowField; } field(13; "Shipment Comment"; Boolean) { CalcFormula = exist("Inventory Comment Line" where("Document Type" = const("Inventory Shipment"), "No." = field("No."))); Caption = 'Shipment Comment'; Editable = false; FieldClass = FlowField; } field(14; "No. Series"; Code[20]) { Caption = 'No. Series'; Editable = false; TableRelation = "No. Series"; } field(15; "Posting No. Series"; Code[20]) { Caption = 'Posting No. Series'; TableRelation = "No. Series"; trigger OnLookup() begin InvtDocHeader := Rec; InvtSetup.Get(); TestNoSeries(); if NoSeries.LookupRelatedNoSeries(GetPostingNoSeriesCode(), InvtDocHeader."Posting No. Series") then InvtDocHeader.Validate("Posting No. Series"); Rec := InvtDocHeader; end; trigger OnValidate() begin if "Posting No. Series" <> '' then begin InvtSetup.Get(); TestNoSeries(); NoSeries.TestAreRelated(GetPostingNoSeriesCode(), "Posting No. Series"); end; end; } field(16; "External Document No."; Code[35]) { Caption = 'External Document No.'; ToolTip = 'Specifies a document number that refers to the customer''s or vendor''s numbering system.'; } field(17; "Whse. Adj. Bin Code"; Code[20]) { Caption = 'Whse. Adj. Bin Code'; TableRelation = Bin.Code where("Location Code" = field("Location Code")); } field(20; "Posting No."; Code[20]) { Caption = 'Posting No.'; } field(21; Status; Option) { Caption = 'Status'; ToolTip = 'Specifies the status of the item document.'; OptionCaption = 'Open,Released'; OptionMembers = Open,Released; } field(23; "Gen. Bus. Posting Group"; Code[20]) { Caption = 'Gen. Bus. Posting Group'; ToolTip = 'Specifies the vendor''s or customer''s trade type to link transactions made for this business partner with the appropriate general ledger account according to the general posting setup.'; TableRelation = "Gen. Business Posting Group"; trigger OnValidate() begin UpdateItemDocLines(FieldNo("Gen. Bus. Posting Group")); end; } field(27; "No. Printed"; Integer) { Caption = 'No. Printed'; Editable = false; } field(30; Correction; Boolean) { Caption = 'Correction'; ToolTip = 'Specifies the entry as a corrective entry. You can use the field if you need to post a corrective entry to an account.'; trigger OnValidate() begin if Rec.Correction <> xRec.Correction then CheckChangeCorrectionAllowed(); end; } field(31; "Format Region"; Text[80]) { Caption = 'Format Region'; TableRelation = "Language Selection"."Language Tag"; } field(480; "Dimension Set ID"; Integer) { Caption = 'Dimension Set ID'; Editable = false; TableRelation = "Dimension Set Entry"; trigger OnLookup() begin Rec.ShowDocDim(); end; trigger OnValidate() begin DimMgt.UpdateGlobalDimFromDimSetID("Dimension Set ID", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code"); end; } } keys { key(Key1; "Document Type", "No.") { Clustered = true; } } fieldgroups { } trigger OnDelete() var ReservationManagement: Codeunit "Reservation Management"; begin InvtDocLine.SetRange("Document Type", "Document Type"); InvtDocLine.SetRange("Document No.", "No."); if InvtDocLine.Find('-') then begin ReservationManagement.DeleteDocumentReservation( DATABASE::"Invt. Document Line", Rec."Document Type".AsInteger(), "No.", GetHideValidationDialog()); repeat InvtDocLine.SuspendStatusCheck(true); InvtDocLine.Delete(true); until InvtDocLine.Next() = 0; end; end; trigger OnInsert() var begin OnBeforeInsert(Rec, xRec); InvtSetup.Get(); if "No." = '' then begin TestNoSeries(); if NoSeries.AreRelated(GetNoSeriesCode(), xRec."No. Series") then "No. Series" := xRec."No. Series" else "No. Series" := GetNoSeriesCode(); "No." := NoSeries.GetNextNo("No. Series", "Posting Date"); end; InitRecord(); end; trigger OnRename() begin Error(CannotRenameErr, TableCaption); end; var InvtDocHeader: Record "Invt. Document Header"; InvtDocLine: Record "Invt. Document Line"; InvtSetup: Record "Inventory Setup"; Location: Record Location; DimMgt: Codeunit DimensionManagement; NoSeries: Codeunit "No. Series"; HideValidationDialog: Boolean; CannotRenameErr: Label 'You cannot rename a %1.', Comment = '%1 - table caption'; ConfirmDimChangeQst: Label 'You may have changed a dimension.\\Do you want to update the lines?'; DocumentTxt: Label '%1 %2', Locked = true; procedure InitRecord() begin case "Document Type" of "Document Type"::Receipt: if ("No. Series" <> '') and (InvtSetup."Invt. Receipt Nos." = InvtSetup."Posted Invt. Receipt Nos.") then "Posting No. Series" := "No. Series" else if "Posting No. Series" = '' then if NoSeries.IsAutomatic(InvtSetup."Posted Invt. Receipt Nos.") then "Posting No. Series" := InvtSetup."Posted Invt. Receipt Nos."; "Document Type"::Shipment: if ("No. Series" <> '') and (InvtSetup."Invt. Shipment Nos." = InvtSetup."Posted Invt. Shipment Nos.") then "Posting No. Series" := "No. Series" else if "Posting No. Series" = '' then if NoSeries.IsAutomatic(InvtSetup."Posted Invt. Shipment Nos.") then "Posting No. Series" := InvtSetup."Posted Invt. Shipment Nos."; end; "Posting Description" := Format("Document Type") + ' ' + "No."; "Posting Date" := WorkDate(); "Document Date" := "Posting Date"; OnAfterInitRecord(Rec); end; procedure AssistEdit(OldInvtDocHeader: Record "Invt. Document Header"): Boolean begin OnBeforeAssistEdit(Rec, OldInvtDocHeader); InvtSetup.Get(); TestNoSeries(); if NoSeries.LookupRelatedNoSeries(GetNoSeriesCode(), OldInvtDocHeader."No. Series", "No. Series") then begin "No." := NoSeries.GetNextNo("No. Series"); exit(true); end; end; local procedure TestNoSeries() begin case "Document Type" of "Document Type"::Receipt: begin InvtSetup.TestField("Invt. Receipt Nos."); InvtSetup.TestField("Posted Invt. Receipt Nos."); end; "Document Type"::Shipment: begin InvtSetup.TestField("Invt. Shipment Nos."); InvtSetup.TestField("Posted Invt. Shipment Nos."); end; end; end; local procedure GetNoSeriesCode() NoSeriesCode: Code[20] begin case "Document Type" of "Document Type"::Receipt: NoSeriesCode := InvtSetup."Invt. Receipt Nos."; "Document Type"::Shipment: NoSeriesCode := InvtSetup."Invt. Shipment Nos."; end; OnAfterGetNoSeriesCode(Rec, NoSeriesCode); end; local procedure GetPostingNoSeriesCode() PostingNos: Code[20] begin case "Document Type" of "Document Type"::Receipt: PostingNos := InvtSetup."Posted Invt. Receipt Nos."; "Document Type"::Shipment: PostingNos := InvtSetup."Posted Invt. Shipment Nos."; end; OnAfterGetPostingNoSeriesCode(Rec, PostingNos); end; procedure SetHideValidationDialog(NewHideValidationDialog: Boolean) begin HideValidationDialog := NewHideValidationDialog; end; procedure GetHideValidationDialog(): Boolean begin exit(HideValidationDialog); end; procedure DocLinesExist(): Boolean begin InvtDocLine.Reset(); InvtDocLine.SetRange("Document Type", "Document Type"); InvtDocLine.SetRange("Document No.", "No."); exit(not InvtDocLine.IsEmpty()); end; procedure CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]) var SourceCodeSetup: Record "Source Code Setup"; OldDimSetID: Integer; begin SourceCodeSetup.Get(); "Shortcut Dimension 1 Code" := ''; "Shortcut Dimension 2 Code" := ''; OldDimSetID := "Dimension Set ID"; case "Document Type" of "Document Type"::Receipt: "Dimension Set ID" := DimMgt.GetDefaultDimID( DefaultDimSource, SourceCodeSetup."Invt. Receipt", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code", 0, 0); "Document Type"::Shipment: "Dimension Set ID" := DimMgt.GetDefaultDimID( DefaultDimSource, SourceCodeSetup."Invt. Shipment", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code", 0, 0); end; OnCreateDimOnBeforeUpdateLines(Rec, xRec, CurrFieldNo, OldDimSetID, DefaultDimSource); if (OldDimSetID <> "Dimension Set ID") and DocLinesExist() then begin Modify(); UpdateAllLineDim("Dimension Set ID", OldDimSetID); end; OnAfterCreateDim(Rec, DefaultDimSource); end; procedure ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20]) var OldDimSetID: Integer; begin OldDimSetID := "Dimension Set ID"; DimMgt.ValidateShortcutDimValues(FieldNumber, ShortcutDimCode, "Dimension Set ID"); if "No." <> '' then Modify(); if OldDimSetID <> "Dimension Set ID" then begin Modify(); if DocLinesExist() then UpdateAllLineDim("Dimension Set ID", OldDimSetID); end; end; local procedure UpdateItemDocLines(FieldRef: Integer) begin InvtDocLine.LockTable(); InvtDocLine.SetRange("Document Type", "Document Type"); InvtDocLine.SetRange("Document No.", "No."); if InvtDocLine.FindSet(true) then repeat case FieldRef of FieldNo("Location Code"): begin InvtDocLine.SuppressRecalculateDimensions(true); InvtDocLine.Validate("Location Code", "Location Code"); InvtDocLine.Validate("Posting Date", "Posting Date"); InvtDocLine.Validate("Document Date", "Document Date"); end; FieldNo("Posting Date"): InvtDocLine.Validate("Posting Date", "Posting Date"); FieldNo("Document Date"): InvtDocLine.Validate("Document Date", "Document Date"); FieldNo("Gen. Bus. Posting Group"): InvtDocLine.Validate("Gen. Bus. Posting Group", "Gen. Bus. Posting Group"); end; InvtDocLine.Modify(true); until InvtDocLine.Next() = 0; end; procedure ShowDocDim() var OldDimSetID: Integer; begin OldDimSetID := "Dimension Set ID"; "Dimension Set ID" := DimMgt.EditDimensionSet( Rec, "Dimension Set ID", StrSubstNo(DocumentTxt, "Document Type", "No."), "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code"); if OldDimSetID <> "Dimension Set ID" then begin Modify(); if DocLinesExist() then UpdateAllLineDim("Dimension Set ID", OldDimSetID); end; end; local procedure UpdateAllLineDim(NewParentDimSetID: Integer; OldParentDimSetID: Integer) var NewDimSetID: Integer; begin if NewParentDimSetID = OldParentDimSetID then exit; if not HideValidationDialog then if not Confirm(ConfirmDimChangeQst) then exit; InvtDocLine.Reset(); InvtDocLine.SetRange("Document Type", "Document Type"); InvtDocLine.SetRange("Document No.", "No."); InvtDocLine.LockTable(); if InvtDocLine.Find('-') then repeat NewDimSetID := DimMgt.GetDeltaDimSetID(InvtDocLine."Dimension Set ID", NewParentDimSetID, OldParentDimSetID); if InvtDocLine."Dimension Set ID" <> NewDimSetID then begin InvtDocLine."Dimension Set ID" := NewDimSetID; DimMgt.UpdateGlobalDimFromDimSetID( InvtDocLine."Dimension Set ID", InvtDocLine."Shortcut Dimension 1 Code", InvtDocLine."Shortcut Dimension 2 Code"); InvtDocLine.Modify(); end; until InvtDocLine.Next() = 0; end; procedure CreateDimFromDefaultDim() var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]; begin InitDefaultDimensionSources(DefaultDimSource); CreateDim(DefaultDimSource); end; local procedure InitDefaultDimensionSources(var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]) begin DimMgt.AddDimSource(DefaultDimSource, Database::"Salesperson/Purchaser", Rec."Salesperson/Purchaser Code"); DimMgt.AddDimSource(DefaultDimSource, Database::Location, Rec."Location Code"); OnAfterInitDefaultDimensionSources(Rec, DefaultDimSource); end; local procedure CheckChangeCorrectionAllowed() var ReservationEntry: Record "Reservation Entry"; NotAllowedMsg: Label 'Item tracking is defined for some item(s) in the %1 %2.\You must delete the existing item tracking before modifying value of field %3', Comment = '%1 - Document Type, %2 - Document No., %3 - Field caption'; begin if CurrFieldNo <> Rec.FieldNo(Correction) then exit; ReservationEntry.SetCurrentKey("Source ID", "Source Ref. No.", "Source Type", "Source Subtype", "Source Batch Name", "Source Prod. Order Line", "Reservation Status", "Shipment Date", "Expected Receipt Date"); ReservationEntry.SetRange("Source ID", Rec."No."); ReservationEntry.SetRange("Source Type", Database::"Invt. Document Line"); ReservationEntry.SetRange("Source Subtype", Rec."Document Type"); if not ReservationEntry.IsEmpty then Error(NotAllowedMsg, format(Rec."Document Type"), Rec."No.", Rec.FieldCaption(Correction)); end; [IntegrationEvent(false, false)] local procedure OnAfterCreateDim(var InvtDocumentHeader: Record "Invt. Document Header"; DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]) begin end; [IntegrationEvent(false, false)] local procedure OnAfterInitDefaultDimensionSources(var InvtDocumentHeader: Record "Invt. Document Header"; var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]) begin end; [IntegrationEvent(false, false)] local procedure OnAfterInitRecord(var InvtDocumentHeader: Record "Invt. Document Header") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeAssistEdit(var InvtDocumentHeader: Record "Invt. Document Header"; OldInvtDocumentHeader: Record "Invt. Document Header") begin end; [IntegrationEvent(false, false)] local procedure OnAfterGetPostingNoSeriesCode(var InvtDocumentHeader: Record "Invt. Document Header"; var PostingNos: Code[20]) begin end; [IntegrationEvent(false, false)] local procedure OnAfterGetNoSeriesCode(var InvtDocumentHeader: Record "Invt. Document Header"; var NoSeriesCode: Code[20]) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeInsert(var InvtDocumentHeader: Record "Invt. Document Header"; xInvtDocumentHeader: Record "Invt. Document Header") begin end; [IntegrationEvent(false, false)] local procedure OnCreateDimOnBeforeUpdateLines(var InvtDocumentHeader: Record "Invt. Document Header"; xInvtDocumentHeader: Record "Invt. Document Header"; CurrentFieldNo: Integer; OldDimSetID: Integer; DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]) begin end;}