Table 5851 Invt. Document Line
src/Layers/W1/BaseApp/Inventory/Document/InvtDocumentLine.Table.al1,321 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.FixedAssets.Depreciation;using Microsoft.FixedAssets.FixedAsset;using Microsoft.FixedAssets.Ledger;using Microsoft.Foundation.AuditCodes;using Microsoft.Foundation.NoSeries;using Microsoft.Foundation.UOM;using Microsoft.Inventory.Availability;using Microsoft.Inventory.Item;using Microsoft.Inventory.Item.Catalog;using Microsoft.Inventory.Journal;using Microsoft.Inventory.Ledger;using Microsoft.Inventory.Location;using Microsoft.Inventory.Tracking;using Microsoft.Pricing.Calculation;using Microsoft.Pricing.PriceList;using Microsoft.Purchases.Setup;using Microsoft.Warehouse.Journal;using Microsoft.Warehouse.Structure;table 5851 "Invt. Document Line"{ Caption = 'Item Document Line'; DrillDownPageID = "Invt. Document Lines"; LookupPageID = "Invt. Document Lines"; DataClassification = CustomerContent; fields { field(1; "Document Type"; Enum "Invt. Doc. Document Type") { Caption = 'Document Type'; ToolTip = 'Specifies the type of the related document.'; } field(2; "Line No."; Integer) { Caption = 'Line No.'; ToolTip = 'Specifies the number of the line.'; } field(3; "Item No."; Code[20]) { Caption = 'Item No.'; ToolTip = 'Specifies the number of the item.'; TableRelation = Item; trigger OnValidate() begin if CurrFieldNo <> 0 then TestStatusOpen(); CheckItemAvailable(FieldNo("Item No.")); ReserveInvtDocLine.VerifyChange(Rec, xRec); CalcFields("Reserved Qty. Inbnd. (Base)"); TestField("Reserved Qty. Inbnd. (Base)", 0); GetInvtDocHeader(); "Posting Date" := InvtDocHeader."Posting Date"; "Document Date" := InvtDocHeader."Document Date"; "Location Code" := InvtDocHeader."Location Code"; "Gen. Bus. Posting Group" := InvtDocHeader."Gen. Bus. Posting Group"; GetItem(); Item.TestField(Blocked, false); Item.TestField("Base Unit of Measure"); Item.TestField(Type, Item.Type::Inventory); Validate(Description, Item.Description); Validate("Gen. Prod. Posting Group", Item."Gen. Prod. Posting Group"); Validate("Inventory Posting Group", Item."Inventory Posting Group"); Validate("Unit Volume", Item."Unit Volume"); Validate("Units per Parcel", Item."Units per Parcel"); "Item Category Code" := Item."Item Category Code"; "Indirect Cost %" := Item."Indirect Cost %"; if "Item No." <> xRec."Item No." then begin "Variant Code" := ''; "Bin Code" := ''; if ("Location Code" <> '') and ("Item No." <> '') then begin GetLocation("Location Code"); if Location."Bin Mandatory" and not Location."Directed Put-away and Pick" then WMSManagement.GetDefaultBin("Item No.", "Variant Code", "Location Code", "Bin Code") end; end; if "Bin Code" <> '' then Validate("Bin Code"); if "Variant Code" <> '' then Validate("Variant Code"); Validate("Unit of Measure Code", Item."Base Unit of Measure"); if "Source Code" = '' then Validate("Source Code", GetSourceCode()); CreateDimFromDefaultDim(Rec.FieldNo("Item No.")); end; } field(4; "Posting Date"; Date) { Caption = 'Posting Date'; } field(5; "Document Date"; Date) { Caption = 'Document Date'; ToolTip = 'Specifies the date when the related document was created.'; trigger OnValidate() begin CheckDateConflict.InvtDocLineCheck(Rec, CurrFieldNo <> 0); // Inbound end; } field(7; "Document No."; Code[20]) { Caption = 'Document No.'; ToolTip = 'Specifies the number of the related document.'; } field(8; Description; Text[100]) { Caption = 'Description'; ToolTip = 'Specifies the description of the item.'; } field(9; "Location Code"; Code[10]) { Caption = 'Location Code'; ToolTip = 'Specifies the warehouse or other place where the involved items are handled or stored.'; TableRelation = Location; trigger OnValidate() begin GetUnitAmount(FieldNo("Location Code")); "Unit Cost" := UnitCost; Validate("Unit Amount"); CheckItemAvailable(FieldNo("Location Code")); if "Location Code" <> xRec."Location Code" then begin "Bin Code" := ''; if ("Location Code" <> '') and ("Item No." <> '') then begin GetLocation("Location Code"); if Location."Bin Mandatory" and not Location."Directed Put-away and Pick" then WMSManagement.GetDefaultBin("Item No.", "Variant Code", "Location Code", "Bin Code"); end; end; ReserveInvtDocLine.VerifyChange(Rec, xRec); if not SkipRecalculateDimensions then CreateDimFromDefaultDim(Rec.FieldNo("Location Code")); end; } field(10; "Inventory Posting Group"; Code[20]) { Caption = 'Inventory Posting Group'; Editable = false; TableRelation = "Inventory Posting Group"; } field(13; Quantity; Decimal) { AutoFormatType = 0; Caption = 'Quantity'; ToolTip = 'Specifies the number of units for this item.'; DecimalPlaces = 0 : 5; trigger OnValidate() begin if CurrFieldNo <> 0 then TestStatusOpen(); if Quantity < 0 then error(CannotBeNegativeErr, FieldCaption(Quantity)); if Quantity > 0 then TestField("Item No."); Quantity := UOMMgt.RoundAndValidateQty(Quantity, "Qty. Rounding Precision", FieldCaption(Quantity)); "Quantity (Base)" := CalcBaseQty(Quantity, FieldCaption(Quantity), FieldCaption("Quantity (Base)")); GetUnitAmount(FieldNo(Quantity)); UpdateAmount(); CheckItemAvailable(FieldNo(Quantity)); ReserveInvtDocLine.VerifyQuantity(Rec, xRec); end; } field(16; "Unit Amount"; Decimal) { AutoFormatType = 2; AutoFormatExpression = ''; Caption = 'Unit Amount'; ToolTip = 'Specifies the price per unit for this item.'; trigger OnValidate() begin UpdateAmount(); if ("Item No." <> '') and ("Document Type" = "Document Type"::Receipt) then if "Indirect Cost %" <> 0 then begin ReadGLSetup(); "Unit Cost" := Round( "Unit Amount" * (1 + "Indirect Cost %" / 100), GLSetup."Unit-Amount Rounding Precision"); Validate("Unit Cost"); end else if CurrFieldNo in [FieldNo("Unit Amount"), FieldNo(Amount)] then begin "Unit Cost" := "Unit Amount"; Validate("Unit Cost"); end; if ("Item No." <> '') and ("Document Type" = "Document Type"::Shipment) then if CurrFieldNo in [FieldNo("Unit Amount"), FieldNo(Amount)] then begin "Unit Cost" := "Unit Amount"; Validate("Unit Cost"); end; end; } field(17; "Unit Cost"; Decimal) { AutoFormatType = 2; AutoFormatExpression = ''; Caption = 'Unit Cost'; ToolTip = 'Specifies the cost of one unit of the item or resource on the line.'; trigger OnValidate() begin TestField("Item No."); RetrieveCosts(); if ("Document Type" = "Document Type"::Receipt) and (Item."Costing Method" = Item."Costing Method"::Standard) then if CurrFieldNo <> FieldNo("Unit Cost") then "Unit Cost" := Round(UnitCost * "Qty. per Unit of Measure", GLSetup."Unit-Amount Rounding Precision") else Error(CannotChangeCostErr, FieldCaption("Unit Cost"), Item."Costing Method"); if CurrFieldNo = FieldNo("Unit Cost") then begin if "Document Type" = "Document Type"::Receipt then begin ReadGLSetup(); "Unit Amount" := Round( "Unit Cost" / (1 + "Indirect Cost %" / 100), GLSetup."Unit-Amount Rounding Precision"); end; if "Document Type" = "Document Type"::Shipment then "Unit Amount" := "Unit Cost"; UpdateAmount(); end; end; } field(18; Amount; Decimal) { AutoFormatType = 1; AutoFormatExpression = ''; Caption = 'Amount'; ToolTip = 'Specifies the transaction amount for this line.'; trigger OnValidate() begin TestField(Quantity); "Unit Amount" := Amount / Quantity; Validate("Unit Amount"); ReadGLSetup(); "Unit Amount" := Round("Unit Amount", GLSetup."Unit-Amount Rounding Precision"); end; } field(23; "Salespers./Purch. Code"; Code[20]) { Caption = 'Salespers./Purch. Code'; TableRelation = "Salesperson/Purchaser" where(Blocked = const(false)); trigger OnValidate() begin CreateDimFromDefaultDim(Rec.FieldNo("Salespers./Purch. Code")); end; } field(26; "Source Code"; Code[10]) { Caption = 'Source Code'; Editable = false; TableRelation = "Source Code"; } field(29; "Applies-to Entry"; Integer) { Caption = 'Applies-to Entry'; ToolTip = 'Specifies if the quantity on the journal line should be applied to an already-posted document.'; trigger OnLookup() begin SelectItemEntry(FieldNo("Applies-to Entry")); end; trigger OnValidate() var ItemLedgEntry: Record "Item Ledger Entry"; begin if "Applies-to Entry" <> 0 then begin ItemLedgEntry.Get("Applies-to Entry"); TestField(Quantity); ItemLedgEntry.TestField(Open, true); "Location Code" := ItemLedgEntry."Location Code"; "Variant Code" := ItemLedgEntry."Variant Code"; "Unit Cost" := CalcUnitCost(ItemLedgEntry."Entry No."); "Unit Amount" := "Unit Cost"; UpdateAmount(); if (ItemLedgEntry."Lot No." <> '') or (ItemLedgEntry."Serial No." <> '') or (ItemLedgEntry."Package No." <> '') then Error(UseItemTrackingLinesErr, FieldCaption("Applies-from Entry")); end else begin RetrieveCosts(); "Unit Cost" := UnitCost; end; end; } field(32; "Item Shpt. Entry No."; Integer) { Caption = 'Item Shpt. Entry No.'; Editable = false; } field(34; "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(35; "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(37; "Indirect Cost %"; Decimal) { AutoFormatType = 0; Caption = 'Indirect Cost %'; ToolTip = 'Specifies the percentage of the item''s last purchase cost that includes indirect costs, such as freight that is associated with the purchase of the item.'; DecimalPlaces = 0 : 5; MinValue = 0; trigger OnValidate() begin TestField("Item No."); TestField("Item Charge No.", ''); GetItem(); if Item."Costing Method" = Item."Costing Method"::Standard then Error(CannotChangeCostErr, FieldCaption("Indirect Cost %"), Item."Costing Method"); "Unit Cost" := Round("Unit Amount" * (1 + "Indirect Cost %" / 100), GLSetup."Unit-Amount Rounding Precision"); end; } field(38; "Gross Weight"; Decimal) { AutoFormatType = 0; Caption = 'Gross Weight'; DecimalPlaces = 0 : 5; } field(39; "Net Weight"; Decimal) { AutoFormatType = 0; Caption = 'Net Weight'; DecimalPlaces = 0 : 5; } field(40; "Units per Parcel"; Decimal) { AutoFormatType = 0; Caption = 'Units per Parcel'; DecimalPlaces = 0 : 5; } field(41; "Unit Volume"; Decimal) { AutoFormatType = 0; Caption = 'Unit Volume'; DecimalPlaces = 0 : 5; } field(42; "Reason Code"; Code[10]) { Caption = 'Reason Code'; ToolTip = 'Specifies the reason code, a supplementary source code that enables you to trace the entry.'; TableRelation = "Reason Code"; } field(55; "Last Item Ledger Entry No."; Integer) { Caption = 'Last Item Ledger Entry No.'; Editable = false; TableRelation = "Item Ledger Entry"; } field(57; "Gen. Bus. Posting Group"; Code[20]) { Caption = 'Gen. Bus. Posting Group'; TableRelation = "Gen. Business Posting Group"; } field(58; "Gen. Prod. Posting Group"; Code[20]) { Caption = 'Gen. Prod. Posting Group'; TableRelation = "Gen. Product Posting Group"; } field(65; "Posting No. Series"; Code[20]) { Caption = 'Posting No. Series'; TableRelation = "No. Series"; } field(72; "Unit Cost (ACY)"; Decimal) { AutoFormatExpression = GetAdditionalReportingCurrencyCode(); AutoFormatType = 2; Caption = 'Unit Cost (ACY)'; Editable = false; } field(480; "Dimension Set ID"; Integer) { Caption = 'Dimension Set ID'; Editable = false; TableRelation = "Dimension Set Entry"; trigger OnLookup() begin Rec.ShowDimensions(); end; trigger OnValidate() begin DimMgt.UpdateGlobalDimFromDimSetID("Dimension Set ID", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code"); end; } field(5402; "Variant Code"; Code[10]) { Caption = 'Variant Code'; ToolTip = 'Specifies the variant of the item on the line.'; TableRelation = "Item Variant".Code where("Item No." = field("Item No.")); trigger OnValidate() var ItemVariant: Record "Item Variant"; begin if Rec."Variant Code" <> '' then begin ItemVariant.SetLoadFields(Description, Blocked); ItemVariant.Get("Item No.", "Variant Code"); ItemVariant.TestField(Blocked, false); Description := ItemVariant.Description; end else begin GetItem(); Rec.Validate(Description, Item.Description); end; if "Variant Code" <> xRec."Variant Code" then begin "Bin Code" := ''; if ("Location Code" <> '') and ("Item No." <> '') then begin GetLocation("Location Code"); if Location."Bin Mandatory" and not Location."Directed Put-away and Pick" then WMSManagement.GetDefaultBin("Item No.", "Variant Code", "Location Code", "Bin Code") end; end; GetUnitAmount(FieldNo("Variant Code")); "Unit Cost" := UnitCost; Validate("Unit Amount"); ReserveInvtDocLine.VerifyChange(Rec, xRec); end; } field(5403; "Bin Code"; Code[20]) { Caption = 'Bin Code'; ToolTip = 'Specifies the bin where the items are picked or put away.'; trigger OnLookup() var BinCode: Code[20]; begin if (("Document Type" = "Document Type"::Shipment) and (Quantity >= 0)) or (("Document Type" = "Document Type"::Receipt) and (Quantity < 0)) then BinCode := WMSManagement.BinContentLookUp("Location Code", "Item No.", "Variant Code", '', "Bin Code") else BinCode := WMSManagement.BinLookUp("Location Code", "Item No.", "Variant Code", ''); if BinCode <> '' then Validate("Bin Code", BinCode); end; trigger OnValidate() begin if ("Bin Code" <> xRec."Bin Code") and ("Bin Code" <> '') then begin if (("Document Type" = "Document Type"::Shipment) and (Quantity >= 0)) or (("Document Type" = "Document Type"::Receipt) and (Quantity < 0)) then WMSManagement.FindBinContent("Location Code", "Bin Code", "Item No.", "Variant Code", '') else WMSManagement.FindBin("Location Code", "Bin Code", ''); TestField("Location Code"); if "Bin Code" <> '' then begin GetLocation("Location Code"); Location.TestField("Bin Mandatory"); Location.TestField("Directed Put-away and Pick", false); GetBin("Location Code", "Bin Code"); TestField("Location Code", Bin."Location Code"); end; end; ReserveInvtDocLine.VerifyChange(Rec, xRec); end; } field(5404; "Qty. per Unit of Measure"; Decimal) { AutoFormatType = 0; Caption = 'Qty. per Unit of Measure'; DecimalPlaces = 0 : 5; Editable = false; InitValue = 1; } field(5405; "Qty. Rounding Precision"; Decimal) { AutoFormatType = 0; Caption = 'Qty. Rounding Precision'; InitValue = 0; DecimalPlaces = 0 : 5; MinValue = 0; MaxValue = 1; Editable = false; } field(5406; "Qty. Rounding Precision (Base)"; Decimal) { AutoFormatType = 0; Caption = 'Qty. Rounding Precision (Base)'; InitValue = 0; DecimalPlaces = 0 : 5; MinValue = 0; MaxValue = 1; Editable = false; } field(5407; "Unit of Measure Code"; Code[10]) { Caption = 'Unit of Measure Code'; ToolTip = 'Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted.'; TableRelation = "Item Unit of Measure".Code where("Item No." = field("Item No.")); trigger OnValidate() begin GetItem(); "Qty. per Unit of Measure" := UOMMgt.GetQtyPerUnitOfMeasure(Item, "Unit of Measure Code"); "Qty. Rounding Precision" := UOMMgt.GetQtyRoundingPrecision(Item, "Unit of Measure Code"); "Qty. Rounding Precision (Base)" := UOMMgt.GetQtyRoundingPrecision(Item, Item."Base Unit of Measure"); ReadGLSetup(); RetrieveCosts(); "Unit Cost" := UnitCost; Validate(Quantity); Validate("Unit Amount"); "Net Weight" := Item."Net Weight" * "Qty. per Unit of Measure"; "Gross Weight" := Item."Gross Weight" * "Qty. per Unit of Measure"; end; } field(5413; "Quantity (Base)"; Decimal) { AutoFormatType = 0; Caption = 'Quantity (Base)'; DecimalPlaces = 0 : 5; trigger OnValidate() begin TestField("Qty. per Unit of Measure", 1); Validate(Quantity, "Quantity (Base)"); end; } field(5470; "Reserved Quantity Inbnd."; Decimal) { AutoFormatType = 0; CalcFormula = sum("Reservation Entry".Quantity where("Source ID" = field("Document No."), "Source Ref. No." = field("Line No."), "Source Type" = const(5851), "Source Subtype" = filter("0" | "3"), "Reservation Status" = const(Reservation))); Caption = 'Reserved Quantity Inbnd.'; ToolTip = 'Specifies the quantity of the item reserved at the transfer-to location.'; DecimalPlaces = 0 : 5; Editable = false; FieldClass = FlowField; } field(5471; "Reserved Quantity Outbnd."; Decimal) { AutoFormatType = 0; CalcFormula = - sum("Reservation Entry".Quantity where("Source ID" = field("Document No."), "Source Ref. No." = field("Line No."), "Source Type" = const(5851), "Source Subtype" = filter("1" | "2"), "Reservation Status" = const(Reservation))); Caption = 'Reserved Quantity Outbnd.'; ToolTip = 'Specifies the quantity of the item reserved at the transfer-from location.'; DecimalPlaces = 0 : 5; Editable = false; FieldClass = FlowField; } field(5472; "Reserved Qty. Inbnd. (Base)"; Decimal) { AutoFormatType = 0; CalcFormula = sum("Reservation Entry"."Quantity (Base)" where("Source ID" = field("Document No."), "Source Ref. No." = field("Line No."), "Source Type" = const(5851), "Source Subtype" = filter("0" | "3"), "Reservation Status" = const(Reservation))); Caption = 'Reserved Qty. Inbnd. (Base)'; DecimalPlaces = 0 : 5; Editable = false; FieldClass = FlowField; } field(5473; "Reserved Qty. Outbnd. (Base)"; Decimal) { AutoFormatType = 0; CalcFormula = - sum("Reservation Entry"."Quantity (Base)" where("Source ID" = field("Document No."), "Source Ref. No." = field("Line No."), "Source Type" = const(5851), "Source Subtype" = filter("1" | "2"), "Reservation Status" = const(Reservation))); Caption = 'Reserved Qty. Outbnd. (Base)'; DecimalPlaces = 0 : 5; Editable = false; FieldClass = FlowField; } field(5704; "Item Category Code"; Code[20]) { Caption = 'Item Category Code'; TableRelation = "Item Category"; } field(5706; "Purchasing Code"; Code[10]) { Caption = 'Purchasing Code'; TableRelation = Purchasing; } field(5725; "Item Reference No."; Code[50]) { AccessByPermission = TableData "Item Reference" = R; Caption = 'Item Reference No.'; ToolTip = 'Specifies a reference to the item number as defined by the item''s barcode.'; ExtendedDatatype = Barcode; trigger OnLookup() begin ItemReferenceManagement.InvtDocumentReferenceNoLookup(Rec); end; trigger OnValidate() var ItemReference: Record "Item Reference"; begin ItemReferenceManagement.ValidateInvtDocumentReferenceNo(Rec, ItemReference, true, CurrFieldNo); end; } field(5726; "Item Reference Unit of Measure"; Code[10]) { AccessByPermission = TableData "Item Reference" = R; Caption = 'Item Reference Unit of Measure'; TableRelation = "Item Unit of Measure".Code where("Item No." = field("Item No.")); } field(5727; "Item Reference Type"; Enum "Item Reference Type") { Caption = 'Item Reference Type'; } field(5728; "Item Reference Type No."; Code[30]) { Caption = 'Item Reference Type No.'; } field(5801; "Item Charge No."; Code[20]) { Caption = 'Item Charge No.'; TableRelation = "Item Charge"; } field(5807; "Applies-from Entry"; Integer) { Caption = 'Applies-from Entry'; ToolTip = 'Specifies the entry number of the Sales Ledger or Purchase Ledger from which the document line was applied.'; MinValue = 0; trigger OnLookup() begin SelectItemEntry(FieldNo("Applies-from Entry")); end; trigger OnValidate() var ItemLedgEntry: Record "Item Ledger Entry"; begin if "Applies-from Entry" <> 0 then begin TestField(Quantity); ItemLedgEntry.Get("Applies-from Entry"); "Location Code" := ItemLedgEntry."Location Code"; "Variant Code" := ItemLedgEntry."Variant Code"; "Unit Cost" := CalcUnitCost(ItemLedgEntry."Entry No."); "Unit Amount" := "Unit Cost"; UpdateAmount(); if ItemLedgEntry.TrackingExists() then Error(UseItemTrackingLinesErr, FieldCaption("Applies-from Entry")); end; end; } field(5811; "Applied Amount"; Decimal) { AutoFormatType = 1; AutoFormatExpression = ''; Caption = 'Applied Amount'; Editable = false; } field(5812; "Update Standard Cost"; Boolean) { Caption = 'Update Standard Cost'; trigger OnValidate() begin GetItem(); Item.TestField("Costing Method", Item."Costing Method"::Standard); end; } field(5813; "Amount (ACY)"; Decimal) { AutoFormatExpression = GetAdditionalReportingCurrencyCode(); AutoFormatType = 1; Caption = 'Amount (ACY)'; } field(5819; "Applies-to Value Entry"; Integer) { Caption = 'Applies-to Value Entry'; } field(12450; "FA No."; Code[20]) { Caption = 'FA No.'; TableRelation = "Fixed Asset"; } field(12451; "FA Entry No."; Integer) { Caption = 'FA Entry No.'; TableRelation = "FA Ledger Entry" where("Entry No." = field("FA Entry No.")); } field(12452; "Depreciation Book Code"; Code[10]) { Caption = 'Depreciation Book Code'; TableRelation = "FA Depreciation Book"."Depreciation Book Code" where("FA No." = field("FA No.")); } } keys { key(Key1; "Document Type", "Document No.", "Line No.") { Clustered = true; } key(Key2; "Location Code") { } key(Key3; "Item No.", "Variant Code") { } key(Key4; "Document Type", "Document No.", "Item No.", "Location Code") { } } fieldgroups { } trigger OnDelete() begin TestStatusOpen(); CalcFields("Reserved Qty. Inbnd. (Base)", "Reserved Qty. Outbnd. (Base)"); TestField("Reserved Qty. Inbnd. (Base)", 0); TestField("Reserved Qty. Outbnd. (Base)", 0); ReserveInvtDocLine.DeleteLine(Rec); end; trigger OnInsert() begin TestStatusOpen(); ReserveInvtDocLine.VerifyQuantity(Rec, xRec); LockTable(); InvtDocHeader."No." := ''; Rec.Validate("Source Code", GetSourceCode()); end; trigger OnModify() begin ReserveInvtDocLine.VerifyChange(Rec, xRec); end; trigger OnRename() begin Error(CannotBeRenamedErr, TableCaption); end; var InvtDocHeader: Record "Invt. Document Header"; Item: Record Item; GLSetup: Record "General Ledger Setup"; SKU: Record "Stockkeeping Unit"; Location: Record Location; Bin: Record Bin; ItemCheckAvail: Codeunit "Item-Check Avail."; ReserveInvtDocLine: Codeunit "Invt. Doc. Line-Reserve"; UOMMgt: Codeunit "Unit of Measure Management"; DimMgt: Codeunit DimensionManagement; WMSManagement: Codeunit "WMS Management"; CheckDateConflict: Codeunit "Reservation-Check Date Confl."; ItemReferenceManagement: Codeunit "Item Reference Management"; Reservation: Page Reservation; GLSetupRead: Boolean; UnitCost: Decimal; StatusCheckSuspended: Boolean; SkipRecalculateDimensions: Boolean; CannotBeNegativeErr: label '%1 cannot be negative.', Comment = '%1 - field caption'; CannotBeRenamedErr: Label '%1 cannot be renamed.', Comment = '%1 - table caption'; CannotChangeCostErr: Label 'You cannot change %1 when Costing Method is %2.', Comment = '%1 - field caption, %2 - costing method value'; UseItemTrackingLinesErr: Label 'You must use page Item Tracking Lines to enter %1, if item tracking is used.', Comment = '%1 - field caption'; CannotReserveAutomaticallyErr: Label 'Quantity %1 in line %2 cannot be reserved automatically.', Comment = '%1 - quantity, %2 - line number'; DocumentLineTxt: Label '%1 %2 %3', Locked = true; protected var GeneralLedgerSetup: Record "General Ledger Setup"; GeneralLedgerSetupRead: Boolean; local procedure GetAdditionalReportingCurrencyCode(): Code[10] begin if not GeneralLedgerSetupRead then begin GeneralLedgerSetup.Get(); GeneralLedgerSetupRead := true; end; exit(GeneralLedgerSetup."Additional Reporting Currency") end; procedure SuppressRecalculateDimensions(RecalculateDimensions: Boolean) begin SkipRecalculateDimensions := RecalculateDimensions; end; procedure EmptyLine(): Boolean begin exit( (Quantity = 0) and ("Item No." = '')); end; local procedure CalcBaseQty(Qty: Decimal; FromFieldName: Text; ToFieldName: Text): Decimal begin TestField("Qty. per Unit of Measure"); exit(UOMMgt.CalcBaseQty( '', '', "Unit of Measure Code", Qty, "Qty. per Unit of Measure", "Qty. Rounding Precision (Base)", FieldCaption("Qty. Rounding Precision"), FromFieldName, ToFieldName)); end; procedure UpdateAmount() begin Amount := Round(Quantity * "Unit Amount"); end; local procedure SelectItemEntry(CurrentFieldNo: Integer) var ItemLedgEntry: Record "Item Ledger Entry"; ItemDocLine2: Record "Invt. Document Line"; begin ItemLedgEntry.SetCurrentKey("Item No.", Open, "Variant Code", Positive, "Location Code", "Entry No."); ItemLedgEntry.SetRange("Item No.", "Item No."); ItemLedgEntry.SetRange(Correction, false); if "Location Code" <> '' then ItemLedgEntry.SetRange("Location Code", "Location Code"); if CurrentFieldNo = FieldNo("Applies-to Entry") then begin ItemLedgEntry.SetRange(Positive, true); ItemLedgEntry.SetRange(Open, true); end else ItemLedgEntry.SetRange(Positive, false); if PAGE.RunModal(PAGE::"Item Ledger Entries", ItemLedgEntry) = ACTION::LookupOK then begin ItemDocLine2 := Rec; if CurrentFieldNo = FieldNo("Applies-to Entry") then ItemDocLine2.Validate("Applies-to Entry", ItemLedgEntry."Entry No.") else ItemDocLine2.Validate("Applies-from Entry", ItemLedgEntry."Entry No."); CheckItemAvailable(CurrentFieldNo); Rec := ItemDocLine2; end; end; procedure CheckItemAvailable(CalledByFieldNo: Integer) begin if (CurrFieldNo = 0) or (CurrFieldNo <> CalledByFieldNo) then // Prevent two checks on quantity exit; if (CurrFieldNo <> 0) and ("Item No." <> '') and (Quantity <> 0) then ItemCheckAvail.InvtDocCheckLine(Rec); end; procedure GetInvtDocHeader() begin TestField("Document No."); if ("Document Type" <> InvtDocHeader."Document Type") or ("Document No." <> InvtDocHeader."No.") then InvtDocHeader.Get(Rec."Document Type", Rec."Document No."); end; procedure IsCorrection(): Boolean begin GetInvtDocHeader(); exit(InvtDocHeader.Correction); end; local procedure GetItem() begin if Item."No." <> "Item No." then Item.Get("Item No."); end; procedure GetUnitAmount(CalledByFieldNo: Integer) begin RetrieveCosts(); "Unit Cost" := UnitCost; case "Document Type" of "Document Type"::Receipt: "Unit Amount" := FindInvtDocLinePrice(CalledByFieldNo); "Document Type"::Shipment: "Unit Amount" := UnitCost * "Qty. per Unit of Measure"; end; OnAfterGetUnitAmount(Rec, UnitCost, CalledByFieldNo); end; local procedure FindInvtDocLinePrice(CalledByFieldNo: Integer): Decimal var ItemJournalLine: Record "Item Journal Line"; begin ItemJournalLine.Init(); ItemJournalLine."Posting Date" := "Posting Date"; ItemJournalLine."Item No." := "Item No."; ItemJournalLine."Variant Code" := "Variant Code"; ItemJournalLine."Location Code" := "Location Code"; ItemJournalLine."Unit of Measure Code" := "Unit of Measure Code"; ItemJournalLine."Qty. per Unit of Measure" := "Qty. per Unit of Measure"; ItemJournalLine."Price Calculation Method" := GetDefaultPriceCalculationMethod(); ItemJournalLine.Quantity := Quantity; case CalledByFieldNo of FieldNo("Variant Code"): CalledByFieldNo := ItemJournalLine.FieldNo("Variant Code"); FieldNo(Quantity): CalledByFieldNo := ItemJournalLine.FieldNo(Quantity); FieldNo("Location Code"): CalledByFieldNo := ItemJournalLine.FieldNo("Location Code"); end; ItemJournalLine.ApplyPrice(Enum::"Price Type"::Purchase, CalledByFieldNo); exit(ItemJournalLine."Unit Amount"); end; local procedure GetDefaultPriceCalculationMethod(): Enum "Price Calculation Method"; var PurchasesPayablesSetup: Record "Purchases & Payables Setup"; begin PurchasesPayablesSetup.Get(); exit(PurchasesPayablesSetup."Price Calculation Method"); end; local procedure TestStatusOpen() begin if StatusCheckSuspended then exit; GetInvtDocHeader(); InvtDocHeader.TestField(Status, InvtDocHeader.Status::Open); end; procedure ShowReservation() begin TestField("Item No."); Clear(Reservation); Reservation.SetReservSource(Rec); Reservation.RunModal(); end; procedure OpenItemTrackingLines() begin ReserveInvtDocLine.CallItemTracking(Rec); OnAfterOpenItemTrackingLines(Rec); end; procedure CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]) var SourceCodeSetup: Record "Source Code Setup"; begin SourceCodeSetup.Get(); "Shortcut Dimension 1 Code" := ''; "Shortcut Dimension 2 Code" := ''; GetInvtDocHeader(); "Dimension Set ID" := DimMgt.GetDefaultDimID( DefaultDimSource, "Source Code", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code", InvtDocHeader."Dimension Set ID", DATABASE::"Invt. Document Header"); DimMgt.UpdateGlobalDimFromDimSetID("Dimension Set ID", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code"); OnAfterCreateDim(Rec, CurrFieldNo, xRec, DefaultDimSource); end; procedure ShowDimensions() begin "Dimension Set ID" := DimMgt.EditDimensionSet("Dimension Set ID", StrSubstNo(DocumentLineTxt, "Document Type", "Document No.", "Line No.")); DimMgt.UpdateGlobalDimFromDimSetID("Dimension Set ID", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code"); end; procedure ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20]) begin DimMgt.ValidateShortcutDimValues(FieldNumber, ShortcutDimCode, "Dimension Set ID"); end; procedure LookupShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20]) begin DimMgt.LookupDimValueCode(FieldNumber, ShortcutDimCode); Rec.ValidateShortcutDimCode(FieldNumber, ShortcutDimCode); end; procedure ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20]) begin DimMgt.GetShortcutDimensions(Rec."Dimension Set ID", ShortcutDimCode); end; local procedure ReadGLSetup() begin if not GLSetupRead then begin GLSetup.Get(); GLSetupRead := true; end; end; local procedure GetSKU(): Boolean begin if (SKU."Location Code" = "Location Code") and (SKU."Item No." = "Item No.") and (SKU."Variant Code" = "Variant Code") then exit(true); if SKU.Get("Location Code", "Item No.", "Variant Code") then exit(true); exit(false); end; local procedure RetrieveCosts() var IsHandled: Boolean; begin IsHandled := false; OnBeforeRetrieveCosts(Rec, UnitCost, IsHandled); if IsHandled then exit; ReadGLSetup(); GetItem(); if GetSKU() then if Item."Base Unit of Measure" <> "Unit of Measure Code" then UnitCost := SKU."Unit Cost" * "Qty. per Unit of Measure" else UnitCost := SKU."Unit Cost" else UnitCost := Item."Unit Cost" * "Qty. per Unit of Measure"; if Item."Costing Method" <> Item."Costing Method"::Standard then UnitCost := Round(UnitCost, GLSetup."Unit-Amount Rounding Precision"); end; local procedure CalcUnitCost(ItemLedgEntryNo: Integer): Decimal var ValueEntry: Record "Value Entry"; begin ValueEntry.Reset(); ValueEntry.SetCurrentKey("Item Ledger Entry No."); ValueEntry.SetRange("Item Ledger Entry No.", ItemLedgEntryNo); ValueEntry.CalcSums("Invoiced Quantity", "Cost Amount (Actual)"); if ValueEntry."Invoiced Quantity" <> 0 then exit(ValueEntry."Cost Amount (Actual)" / ValueEntry."Invoiced Quantity" * "Qty. per Unit of Measure"); exit(0); end; procedure RowID1(): Text[250] var ItemTrackingMgt: Codeunit "Item Tracking Management"; begin exit( ItemTrackingMgt.ComposeRowID(DATABASE::"Invt. Document Line", "Document Type".AsInteger(), "Document No.", '', 0, "Line No.")); end; local procedure GetLocation(LocationCode: Code[10]) begin if LocationCode = '' then Clear(Location) else if Location.Code <> LocationCode then Location.Get(LocationCode); end; local procedure GetBin(LocationCode: Code[10]; BinCode: Code[20]) begin if BinCode = '' then Clear(Bin) else if Bin.Code <> BinCode then Bin.Get(LocationCode, BinCode); end; procedure SuspendStatusCheck(Suspend: Boolean) begin StatusCheckSuspended := Suspend; end; procedure Signed(Value: Decimal): Decimal begin case "Document Type" of "Document Type"::Receipt: exit(Value); "Document Type"::Shipment: exit(-Value); end; end; procedure ReserveFromInventory(var InvtDocLine: Record "Invt. Document Line") var ReservMgt: Codeunit "Reservation Management"; AutoReserv: Boolean; begin if InvtDocLine.FindSet() then repeat InvtDocLine.TestField("Posting Date"); ReservMgt.SetReservSource(InvtDocLine); InvtDocLine.CalcFields("Reserved Qty. Outbnd. (Base)"); ReservMgt.AutoReserveToShip( AutoReserv, '', InvtDocLine."Posting Date", InvtDocLine.Quantity - InvtDocLine."Reserved Quantity Outbnd.", InvtDocLine."Quantity (Base)" - InvtDocLine."Reserved Qty. Outbnd. (Base)"); if not AutoReserv then Error(CannotReserveAutomaticallyErr, InvtDocLine."Quantity (Base)", InvtDocLine."Line No."); until InvtDocLine.Next() = 0; end; procedure GetRemainingQty(var RemainingQty: Decimal; var RemainingQtyBase: Decimal; Direction: Integer) begin case Direction of 1: // Shipment begin CalcFields("Reserved Quantity Outbnd.", "Reserved Qty. Outbnd. (Base)"); RemainingQty := Quantity - Abs("Reserved Quantity Outbnd."); RemainingQtyBase := "Quantity (Base)" - Abs("Reserved Qty. Outbnd. (Base)"); end; 0: // Receipt begin CalcFields("Reserved Quantity Inbnd.", "Reserved Qty. Inbnd. (Base)"); RemainingQty := Quantity - Abs("Reserved Quantity Inbnd."); RemainingQtyBase := "Quantity (Base)" - Abs("Reserved Qty. Inbnd. (Base)"); end; end; end; procedure GetReservationQty(var QtyReserved: Decimal; var QtyReservedBase: Decimal; var QtyToReserve: Decimal; var QtyToReserveBase: Decimal; SourceSubtype: Integer): Decimal begin if SourceSubtype = 0 then begin // Inbound CalcFields("Reserved Quantity Inbnd.", "Reserved Qty. Inbnd. (Base)"); QtyReserved := "Reserved Quantity Inbnd."; QtyReservedBase := "Reserved Qty. Inbnd. (Base)"; QtyToReserve := Quantity; QtyToReserveBase := "Quantity (Base)"; end else begin // Outbound CalcFields("Reserved Quantity Outbnd.", "Reserved Qty. Outbnd. (Base)"); QtyReserved := "Reserved Quantity Outbnd."; QtyReservedBase := "Reserved Qty. Outbnd. (Base)"; QtyToReserve := Quantity; QtyToReserveBase := "Quantity (Base)"; end; exit("Qty. per Unit of Measure"); end; procedure GetSourceCaption(): Text begin exit(StrSubstNo(DocumentLineTxt, "Document No.", "Line No.", "Item No.")); end; procedure FilterReceiptLinesForReservation(ReservationEntry: Record "Reservation Entry"; AvailabilityFilter: Text; Positive: Boolean) begin Reset(); SetCurrentKey("Location Code"); SetRange("Item No.", ReservationEntry."Item No."); SetRange("Variant Code", ReservationEntry."Variant Code"); SetRange("Location Code", ReservationEntry."Location Code"); SetRange("Document Type", "Document Type"::Receipt); SetFilter("Document Date", AvailabilityFilter); if Positive then SetFilter("Quantity (Base)", '>0') else SetFilter("Quantity (Base)", '<0'); OnAfterFilterReceiptLinesForReservation(Rec, ReservationEntry, AvailabilityFilter, Positive); end; procedure FilterShipmentLinesForReservation(ReservationEntry: Record "Reservation Entry"; AvailabilityFilter: Text; Positive: Boolean) begin Reset(); SetCurrentKey("Location Code"); SetRange("Item No.", ReservationEntry."Item No."); SetRange("Variant Code", ReservationEntry."Variant Code"); SetRange("Location Code", ReservationEntry."Location Code"); SetRange("Document Type", "Document Type"::Shipment); SetFilter("Document Date", AvailabilityFilter); if Positive then SetFilter("Quantity (Base)", '<0') else SetFilter("Quantity (Base)", '>0'); OnAfterFilterShipmentLinesForReservation(Rec, ReservationEntry, AvailabilityFilter, Positive); end; procedure ReservEntryExist(): Boolean var ReservEntry: Record "Reservation Entry"; begin ReservEntry.InitSortingAndFilters(false); SetReservationFilters(ReservEntry); exit(not ReservEntry.IsEmpty); end; procedure SetReservationEntry(var ReservEntry: Record "Reservation Entry") begin ReservEntry.SetSource(DATABASE::"Invt. Document Line", "Document Type".AsInteger(), "Document No.", "Line No.", '', 0); ReservEntry.SetItemData("Item No.", Description, "Location Code", "Variant Code", "Qty. per Unit of Measure"); ReservEntry."Expected Receipt Date" := "Document Date"; ReservEntry."Shipment Date" := "Document Date"; end; procedure SetReservationFilters(var ReservEntry: Record "Reservation Entry") begin ReservEntry.SetSourceFilter(DATABASE::"Invt. Document Line", "Document Type".AsInteger(), "Document No.", "Line No.", false); ReservEntry.SetSourceFilter('', 0); end; procedure CreateDimFromDefaultDim(FieldNo: Integer) var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]; begin InitDefaultDimensionSources(DefaultDimSource, FieldNo); CreateDim(DefaultDimSource); end; local procedure InitDefaultDimensionSources(var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]; FieldNo: Integer) begin DimMgt.AddDimSource(DefaultDimSource, Database::Item, Rec."Item No.", FieldNo = Rec.FieldNo("Item No.")); DimMgt.AddDimSource(DefaultDimSource, Database::"Salesperson/Purchaser", Rec."Salespers./Purch. Code", FieldNo = Rec.FieldNo("Salespers./Purch. Code")); DimMgt.AddDimSource(DefaultDimSource, Database::Location, Rec."Location Code", FieldNo = Rec.FieldNo("Location Code")); OnAfterInitDefaultDimensionSources(Rec, DefaultDimSource, FieldNo); end; local procedure GetSourceCode(): Code[10] var SourceCodeSetup: Record "Source Code Setup"; begin SourceCodeSetup.Get(); if "Document Type" = "Document Type"::Receipt then exit(SourceCodeSetup."Invt. Receipt"); if "Document Type" = "Document Type"::Shipment then exit(SourceCodeSetup."Invt. Shipment"); end; [IntegrationEvent(false, false)] local procedure OnAfterInitDefaultDimensionSources(var InvtDocumentLine: Record "Invt. Document Line"; var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]; FieldNo: Integer) begin end; [IntegrationEvent(false, false)] local procedure OnAfterFilterReceiptLinesForReservation(var InvtDocumentLine: Record "Invt. Document Line"; ReservationEntry: Record "Reservation Entry"; AvailabilityFilter: Text; Positive: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnAfterFilterShipmentLinesForReservation(var InvtDocumentLine: Record "Invt. Document Line"; ReservationEntry: Record "Reservation Entry"; AvailabilityFilter: Text; Positive: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeRetrieveCosts(var InvtDocumentLine: Record "Invt. Document Line"; var UnitCost: Decimal; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnAfterGetUnitAmount(var InvtDocumentLine: Record "Invt. Document Line"; var UnitCost: Decimal; CalledByFieldNo: Integer) begin end; [IntegrationEvent(false, false)] local procedure OnAfterOpenItemTrackingLines(var InvtDocumentLine: Record "Invt. Document Line") begin end; [IntegrationEvent(false, false)] local procedure OnAfterCreateDim(var InvtDocumentLine: Record "Invt. Document Line"; CurrentFieldNo: Integer; xInvtDocumentLine: Record "Invt. Document Line"; DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]) begin end;}