Report 702 Inventory Posting - Test
src/Layers/W1/BaseApp/Inventory/Reports/InventoryPostingTest.Report.al982 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.Reports;using Microsoft.CRM.Team;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Foundation.NoSeries;using Microsoft.Foundation.Period;using Microsoft.Inventory.Item;using Microsoft.Inventory.Journal;using Microsoft.Inventory.Ledger;using Microsoft.Inventory.Location;using Microsoft.Inventory.Setup;using System.Security.User;using System.Utilities;report 702 "Inventory Posting - Test"{ Caption = 'Inventory Posting - Test'; DefaultRenderingLayout = RDLCLayout; dataset { dataitem("Item Journal Batch"; "Item Journal Batch") { DataItemTableView = sorting("Journal Template Name", Name); RequestFilterFields = "Journal Template Name", Name; column(Item_Journal_Batch_Journal_Template_Name; "Journal Template Name") { } column(Item_Journal_Batch_Name; Name) { } dataitem("Item Journal Line"; "Item Journal Line") { DataItemLink = "Journal Template Name" = field("Journal Template Name"), "Journal Batch Name" = field(Name); DataItemTableView = sorting("Journal Template Name", "Journal Batch Name", "Line No."); RequestFilterFields = "Posting Date"; column(COMPANYNAME; COMPANYPROPERTY.DisplayName()) { } column(Item_Journal_Line__Journal_Template_Name_; "Journal Template Name") { } column(Item_Journal_Line__Journal_Batch_Name_; "Journal Batch Name") { } column(Item_Journal_Line__TABLECAPTION__________ItemJnlLineFilter; TableCaption + ': ' + ItemJnlLineFilter) { } column(ItemJnlLineFilter; ItemJnlLineFilter) { } column(ItemLineEntryType; ItemLineEntryType) { } column(JnlTemplateType; JnlTemplateType) { } column(Item_Journal_Line__Item_Journal_Line___Line_No__; "Line No.") { } column(TotalCostAm1; TotalCostAm1) { } column(TotalCostAm2; TotalCostAm2) { } column(TotalCostAm3; TotalCostAm3) { } column(TotalCostAm4; TotalCostAm4) { } column(TotalCostAm5; TotalCostAm5) { } column(TotalAm1; TotalAm1) { } column(TotalAm2; TotalAm2) { } column(TotalAm3; TotalAm3) { } column(TotalAm4; TotalAm4) { } column(TotalAm5; TotalAm5) { } column(Item_Journal_Line__Posting_Date_; Format("Posting Date")) { } column(Item_Journal_Line__Entry_Type_; "Entry Type") { } column(Item_Journal_Line__Item_No__; "Item No.") { } column(Item_Journal_Line_Description; Description) { } column(Item_Journal_Line_Quantity; Quantity) { } column(Item_Journal_Line__Invoiced_Quantity_; "Invoiced Quantity") { } column(Item_Journal_Line__Unit_Amount_; "Unit Amount") { } column(Item_Journal_Line_Amount; Amount) { } column(CostAmount; CostAmount) { AutoFormatType = 1; } column(Item_Journal_Line__Unit_Cost_; "Unit Cost") { } column(Item_Journal_Line_Quantity_Control68; Quantity) { } column(Item_Journal_Line_Description_Control69; Description) { } column(Item_Journal_Line__Source_No__; "Source No.") { } column(Item_Journal_Line__Item_No___Control71; "Item No.") { } column(Item_Journal_Line__Prod__Order_No__; "Order No.") { } column(Item_Journal_Line__Document_No__; "Document No.") { } column(Item_Journal_Line__Output_Quantity_; OutputQuantity) { } column(Item_Journal_Line__Run_Time_; RunTime) { } column(Item_Journal_Line__Setup_Time_; SetupTime) { } column(Item_Journal_Line_Description_Control59; Description) { } column(Item_Journal_Line__No__; "No.") { } column(Item_Journal_Line_Type; Type) { } column(Item_Journal_Line__Operation_No__; OperationNo) { } column(Item_Journal_Line__Unit_Cost__Control99; "Unit Cost") { } column(Item_Journal_Line__Stop_Code_; StopCode) { } column(Item_Journal_Line__Scrap_Code_; ScrapCode) { } column(Item_Journal_Line__Stop_Time_; StopTime) { } column(NoOfEntries_5_; NoOfEntries[5]) { } column(NoOfEntries_4_; NoOfEntries[4]) { } column(NoOfEntries_3_; NoOfEntries[3]) { } column(NoOfEntries_2_; NoOfEntries[2]) { } column(NoOfEntries_1_; NoOfEntries[1]) { } column(EntryTypeDescription_1_; EntryTypeDescription[1]) { } column(TotalCostAmounts_1_; TotalCostAmounts[1]) { AutoFormatType = 1; } column(EntryTypeDescription_2_; EntryTypeDescription[2]) { } column(TotalCostAmounts_2_; TotalCostAmounts[2]) { AutoFormatType = 1; } column(EntryTypeDescription_3_; EntryTypeDescription[3]) { } column(TotalCostAmounts_3_; TotalCostAmounts[3]) { AutoFormatType = 1; } column(EntryTypeDescription_4_; EntryTypeDescription[4]) { } column(TotalCostAmounts_4_; TotalCostAmounts[4]) { AutoFormatType = 1; } column(EntryTypeDescription_5_; EntryTypeDescription[5]) { } column(TotalCostAmounts_5_; TotalCostAmounts[5]) { AutoFormatType = 1; } column(TotalAmount; TotalAmount) { AutoFormatType = 1; } column(TotalCostAmount; TotalCostAmount) { AutoFormatType = 1; } column(Inventory_Posting___TestCaption; Inventory_Posting___TestCaptionLbl) { } column(CurrReport_PAGENOCaption; CurrReport_PAGENOCaptionLbl) { } column(Item_Journal_Line__Journal_Template_Name_Caption; FieldCaption("Journal Template Name")) { } column(Item_Journal_Line__Journal_Batch_Name_Caption; FieldCaption("Journal Batch Name")) { } column(Item_Journal_Line__Posting_Date_Caption; Item_Journal_Line__Posting_Date_CaptionLbl) { } column(Item_Journal_Line__Entry_Type_Caption; Item_Journal_Line__Entry_Type_CaptionLbl) { } column(Item_Journal_Line__Item_No__Caption; FieldCaption("Item No.")) { } column(Item_Journal_Line_DescriptionCaption; FieldCaption(Description)) { } column(Item_Journal_Line_QuantityCaption; FieldCaption(Quantity)) { } column(Item_Journal_Line__Invoiced_Quantity_Caption; FieldCaption("Invoiced Quantity")) { } column(Item_Journal_Line__Unit_Amount_Caption; FieldCaption("Unit Amount")) { } column(Item_Journal_Line_AmountCaption; FieldCaption(Amount)) { } column(CostAmountCaption; CostAmountCaptionLbl) { } column(Item_Journal_Line__Unit_Cost_Caption; FieldCaption("Unit Cost")) { } column(Item_Journal_Line_Quantity_Control68Caption; FieldCaption(Quantity)) { } column(Item_Journal_Line_Description_Control69Caption; FieldCaption(Description)) { } column(Item_Journal_Line__Source_No__Caption; FieldCaption("Source No.")) { } column(Item_Journal_Line__Item_No___Control71Caption; FieldCaption("Item No.")) { } column(Item_Journal_Line__Prod__Order_No__Caption; FieldCaption("Order No.")) { } column(Item_Journal_Line__Document_No__Caption; FieldCaption("Document No.")) { } column(Item_Journal_Line__Operation_No__Caption; OperationNoCaption) { } column(Item_Journal_Line_TypeCaption; FieldCaption(Type)) { } column(Item_Journal_Line__No__Caption; FieldCaption("No.")) { } column(Item_Journal_Line_Description_Control59Caption; FieldCaption(Description)) { } column(Item_Journal_Line__Setup_Time_Caption; SetupTimeCaption) { } column(Item_Journal_Line__Run_Time_Caption; RunTimeCaption) { } column(Item_Journal_Line__Output_Quantity_Caption; OutputQuantityCaption) { } column(Item_Journal_Line__Unit_Cost__Control99Caption; FieldCaption("Unit Cost")) { } column(Item_Journal_Line__Stop_Time_Caption; StopTimeCaption) { } column(Item_Journal_Line__Scrap_Code_Caption; ScrapCodeCaption) { } column(Item_Journal_Line__Stop_Code_Caption; StopCodeCaption) { } column(TotalAmountCaption; TotalAmountCaptionLbl) { } dataitem(DimensionLoop; "Integer") { DataItemTableView = sorting(Number) where(Number = filter(1 ..)); column(DimText; DimText) { } column(DimensionLoop_Number; Number) { } column(DimensionsCaption; DimensionsCaptionLbl) { } trigger OnAfterGetRecord() begin if Number = 1 then begin if not DimSetEntry.FindSet() then CurrReport.Break(); end else if not Continue then CurrReport.Break(); Clear(DimText); Continue := false; repeat OldDimText := DimText; if DimText = '' then DimText := StrSubstNo('%1 - %2', DimSetEntry."Dimension Code", DimSetEntry."Dimension Value Code") else DimText := StrSubstNo( '%1; %2 - %3', DimText, DimSetEntry."Dimension Code", DimSetEntry."Dimension Value Code"); if StrLen(DimText) > MaxStrLen(OldDimText) then begin DimText := OldDimText; Continue := true; exit; end; until DimSetEntry.Next() = 0; end; trigger OnPreDataItem() begin if not ShowDim then CurrReport.Break(); DimSetEntry.SetRange("Dimension Set ID", "Item Journal Line"."Dimension Set ID"); end; } dataitem(ErrorLoop; "Integer") { DataItemTableView = sorting(Number); column(ErrorText_Number_; ErrorText[Number]) { } column(ErrorText_Number_Caption; ErrorText_Number_CaptionLbl) { } trigger OnPostDataItem() begin ErrorCounter := 0; end; trigger OnPreDataItem() begin SetRange(Number, 1, ErrorCounter); end; } trigger OnAfterGetRecord() var ItemVariant: Record "Item Variant"; ItemJnlLine2: Record "Item Journal Line"; ItemJnlLine3: Record "Item Journal Line"; ItemJnlLine4: Record "Item Journal Line"; UserSetupManagement: Codeunit "User Setup Management"; InvtPeriodEndDate: Date; QtyToPostBase: Decimal; TempErrorText: Text[250]; ItemItemVariantLbl: Label '%1 %2', Comment = '%1 - Item No., %2 - Variant Code'; begin OnBeforeItemJournalLineOnAfterGetRecord("Item Journal Line", ErrorCounter, ErrorText); NoOfEntries["Entry Type".AsInteger() + 1] := 1; CostAmount := "Unit Cost" * Quantity; TotalCostAmounts["Entry Type".AsInteger() + 1] := CostAmount; if "Entry Type" in ["Entry Type"::Purchase, "Entry Type"::"Positive Adjmt.", "Entry Type"::Output] then begin TotalAmount := TotalAmount + Amount; TotalCostAmount := TotalCostAmount + CostAmount; end else begin TotalAmount := TotalAmount - Amount; TotalCostAmount := TotalCostAmount - CostAmount; end; if ("Item No." = '') and (Quantity = 0) then exit; QtyError := false; MakeRecurringTexts("Item Journal Line"); if EmptyLine() then begin if not IsValueEntryForDeletedItem() then AddError(StrSubstNo(Text001, FieldCaption("Item No."))) end else begin if not Item.Get("Item No.") then AddError(StrSubstNo(Text002, Item.TableCaption(), "Item No.")) else if Item.Blocked then AddError(StrSubstNo(Text003, Item.FieldCaption(Blocked), false, Item.TableCaption(), "Item No.")); if "Item Journal Line"."Variant Code" <> '' then begin ItemVariant.SetLoadFields(Blocked); if not ItemVariant.Get("Item Journal Line"."Item No.", "Item Journal Line"."Variant Code") then AddError(StrSubstNo(Text002, ItemVariant.TableCaption(), StrSubstNo(ItemItemVariantLbl, "Item Journal Line"."Item No.", "Item Journal Line"."Variant Code"))) else if ItemVariant.Blocked then AddError(StrSubstNo(Text003, ItemVariant.FieldCaption(Blocked), false, ItemVariant.TableCaption(), StrSubstNo(ItemItemVariantLbl, "Item Journal Line"."Item No.", "Item Journal Line"."Variant Code"))); end; end; CheckRecurringLine("Item Journal Line"); if "Posting Date" = 0D then AddError(StrSubstNo(Text001, FieldCaption("Posting Date"))) else begin if "Posting Date" <> NormalDate("Posting Date") then AddError(StrSubstNo(Text005, FieldCaption("Posting Date"))); if "Item Journal Batch"."No. Series" <> '' then if NoSeries."Date Order" and ("Posting Date" < LastPostingDate) then AddError(Text006); LastPostingDate := "Posting Date"; if not UserSetupManagement.TestAllowedPostingDate("Posting Date", TempErrorText) then AddError(TempErrorText); InvtPeriodEndDate := "Posting Date"; if not InvtPeriod.IsValidDate(InvtPeriodEndDate) then AddError( StrSubstNo( Text007, Format("Posting Date"))) end; if "Document Date" <> 0D then if "Document Date" <> NormalDate("Document Date") then AddError(StrSubstNo(Text005, FieldCaption("Document Date"))); if "Gen. Prod. Posting Group" = '' then AddError(StrSubstNo(Text001, FieldCaption("Gen. Prod. Posting Group"))) else if not GenPostingSetup.Get("Gen. Bus. Posting Group", "Gen. Prod. Posting Group") then AddError( StrSubstNo( Text008, GenPostingSetup.TableCaption(), "Gen. Bus. Posting Group", "Gen. Prod. Posting Group")); if InvtSetup."Location Mandatory" then begin if "Location Code" = '' then AddError(StrSubstNo(Text001, FieldCaption("Location Code"))); if "Entry Type" = "Entry Type"::Transfer then if "New Location Code" = '' then AddError(StrSubstNo(Text001, FieldCaption("New Location Code"))); end; if "Entry Type" in ["Entry Type"::"Positive Adjmt.", "Entry Type"::"Negative Adjmt."] then if "Discount Amount" <> 0 then AddError(StrSubstNo(Text009, FieldCaption("Discount Amount"))); if "Entry Type" = "Entry Type"::Transfer then begin if Amount <> 0 then AddError( StrSubstNo( Text011, FieldCaption(Amount), FieldCaption("Entry Type"), Format("Entry Type"))); if "Discount Amount" <> 0 then AddError( StrSubstNo( Text011, FieldCaption("Discount Amount"), FieldCaption("Entry Type"), Format("Entry Type"))); if Quantity < 0 then AddError( StrSubstNo( Text012, FieldCaption(Quantity), FieldCaption("Entry Type"), Format("Entry Type"))); if Quantity <> "Invoiced Quantity" then AddError( StrSubstNo( Text013, FieldCaption("Invoiced Quantity"), FieldCaption(Quantity), FieldCaption("Entry Type"), Format("Entry Type"))); end; if not "Phys. Inventory" then begin if "Qty. (Calculated)" <> 0 then AddError( StrSubstNo( Text011, FieldCaption("Qty. (Calculated)"), FieldCaption("Phys. Inventory"), Format("Phys. Inventory"))); if "Qty. (Phys. Inventory)" <> 0 then AddError( StrSubstNo( Text011, FieldCaption("Qty. (Phys. Inventory)"), FieldCaption("Phys. Inventory"), Format("Phys. Inventory"))); end else begin if not ("Entry Type" in ["Entry Type"::"Positive Adjmt.", "Entry Type"::"Negative Adjmt."]) then begin ItemJnlLine2."Entry Type" := ItemJnlLine2."Entry Type"::"Positive Adjmt."; ItemJnlLine3."Entry Type" := ItemJnlLine3."Entry Type"::"Negative Adjmt."; AddError( StrSubstNo( Text014, FieldCaption("Entry Type"), Format(ItemJnlLine2."Entry Type"), Format(ItemJnlLine3."Entry Type"), FieldCaption("Phys. Inventory"), true)); end; if ("Entry Type" = "Entry Type"::"Positive Adjmt.") and ("Qty. (Phys. Inventory)" - "Qty. (Calculated)" <> Quantity) then AddError( StrSubstNo( Text015, FieldCaption(Quantity), FieldCaption("Qty. (Phys. Inventory)"), FieldCaption("Qty. (Calculated)"), FieldCaption("Entry Type"), Format("Entry Type"), FieldCaption("Phys. Inventory"), true)); if ("Entry Type" = "Entry Type"::"Negative Adjmt.") and ("Qty. (Calculated)" - "Qty. (Phys. Inventory)" <> Quantity) then AddError( StrSubstNo( Text015, FieldCaption(Quantity), FieldCaption("Qty. (Calculated)"), FieldCaption("Qty. (Phys. Inventory)"), FieldCaption("Entry Type"), Format("Entry Type"), FieldCaption("Phys. Inventory"), true)); end; OnAfterGetRecordOnCheckManufacturing("Item Journal Line", QtyError); if (Quantity = 0) and ("Invoiced Quantity" <> 0) then begin if "Item Shpt. Entry No." = 0 then AddError(StrSubstNo(Text001, FieldCaption("Item Shpt. Entry No."))); end else begin if Quantity <> "Invoiced Quantity" then if ("Invoiced Quantity" <> 0) and not QtyError then begin QtyError := true; AddError(StrSubstNo(Text009, FieldCaption("Invoiced Quantity"))); end; if "Item Shpt. Entry No." <> 0 then AddError(StrSubstNo(Text016, FieldCaption("Item Shpt. Entry No."))); end; if "Item Journal Batch"."No. Series" <> '' then begin if LastDocNo <> '' then if ("Document No." <> LastDocNo) and ("Document No." <> IncStr(LastDocNo)) then AddError(Text017); LastDocNo := "Document No."; end; DimSetEntry.SetRange("Dimension Set ID", "Dimension Set ID"); if not DimMgt.CheckDimIDComb("Dimension Set ID") then AddError(DimMgt.GetDimCombErr()); OnAfterCheckDimension("Item Journal Line", ItemJnlTemplate, QtyError); TableID[1] := DATABASE::Item; No[1] := "Item No."; TableID[2] := DATABASE::"Salesperson/Purchaser"; No[2] := "Salespers./Purch. Code"; CheckDimValuePosting("Item Journal Line"); if (ItemJnlTemplate.Type in [ItemJnlTemplate.GetConsumptionTemplateType(), ItemJnlTemplate.Type::Transfer]) or ((ItemJnlTemplate.Type = ItemJnlTemplate.GetProdOrderTemplateType()) and ("Entry Type" = "Entry Type"::Consumption)) then begin ItemJnlLine4.Reset(); ItemJnlLine4.SetRange("Journal Template Name", "Journal Template Name"); ItemJnlLine4.SetRange("Journal Batch Name", "Journal Batch Name"); ItemJnlLine4.SetRange("Item No.", "Item No."); ItemJnlLine4.SetRange("Location Code", "Location Code"); if ItemJnlLine4.Find('-') then begin QtyToPostBase := 0; repeat QtyToPostBase -= ItemJnlLine4.Signed(ItemJnlLine4."Quantity (Base)") until ItemJnlLine4.Next() = 0; Item.Get("Item No."); if "Location Code" <> '' then Item.SetRange("Location Filter", "Location Code") else Item.SetFilter("Location Filter", '%1', ''); Item.CalcFields(Inventory); OnItemJournalLineOnAfterGetRecordOnAfterCalcItemInventory(Item, "Item Journal Line"); if Item.Inventory - QtyToPostBase < 0 then if "Location Code" <> '' then AddError( StrSubstNo( Text020, Item.TableCaption(), Item."No.", Location.TableCaption(), "Location Code")) else AddError( StrSubstNo( Text021, Item.TableCaption(), Item."No.")); end; end; this.GetLocation("Location Code"); if Location."Bin Mandatory" and ("Bin Code" = '') and not Location."Directed Put-away and Pick" then AddError( StrSubstNo( Text001, FieldCaption("Bin Code"))); if "Entry Type" = "Entry Type"::Transfer then begin this.GetLocation("New Location Code"); if Location."Bin Mandatory" and ("New Bin Code" = '') and not Location."Directed Put-away and Pick" then AddError( StrSubstNo( Text001, FieldCaption("New Bin Code"))); end; JnlTemplateType := ItemJnlTemplate.Type.AsInteger(); ItemLineEntryType := "Entry Type".AsInteger(); case "Entry Type".AsInteger() + 1 of 1: begin TotalAm1 := TotalAm1 + Amount; TotalCostAm1 := TotalCostAm1 + CostAmount; end; 2: begin TotalAm2 := TotalAm2 + Amount; TotalCostAm2 := TotalCostAm2 + CostAmount; end; 3: begin TotalAm3 := TotalAm3 + Amount; TotalCostAm3 := TotalCostAm3 + CostAmount; end; 4: begin TotalAm4 := TotalAm4 + Amount; TotalCostAm4 := TotalCostAm4 + CostAmount; end; 5: begin TotalAm5 := TotalAm5 + Amount; TotalCostAm5 := TotalCostAm5 + CostAmount; end; end; OnAfterGetRecordOnSetmanufacturingFields( "Item Journal Line", OperationNo, OperationNoCaption, OutputQuantity, OutputQuantityCaption, ScrapCode, ScrapCodeCaption, StopCode, StopCodeCaption, RunTime, RunTimeCaption, SetupTime, SetupTimeCaption, StopTime, StopTimeCaption); OnAfterCheckItemJnLLine("Item Journal Line", Item, ErrorCounter, ErrorText); end; trigger OnPreDataItem() begin ItemJnlTemplate.Get("Item Journal Batch"."Journal Template Name"); if ItemJnlTemplate.Recurring then begin if GetFilter("Posting Date") <> '' then AddError(StrSubstNo(Text000, FieldCaption("Posting Date"))); SetRange("Posting Date", 0D, WorkDate()); if GetFilter("Expiration Date") <> '' then AddError( StrSubstNo( Text000, FieldCaption("Expiration Date"))); SetFilter("Expiration Date", '%1 | %2..', 0D, WorkDate()); end; Clear(NoOfEntries); Clear(TotalCostAmounts); if "Item Journal Batch"."No. Series" <> '' then NoSeries.Get("Item Journal Batch"."No. Series"); LastPostingDate := 0D; LastDocNo := ''; end; } trigger OnPreDataItem() begin if "Item Journal Line".GetFilter("Journal Template Name") <> '' then SetFilter("Journal Template Name", "Item Journal Line".GetFilter("Journal Template Name")); if "Item Journal Line".GetFilter("Journal Batch Name") <> '' then SetFilter(Name, "Item Journal Line".GetFilter("Journal Batch Name")); for i := 1 to ArrayLen(EntryTypeDescription) do begin "Item Journal Line"."Entry Type" := "Item Ledger Entry Type".FromInteger(i - 1); EntryTypeDescription[i] := Format("Item Journal Line"."Entry Type"); end; end; } } requestpage { SaveValues = true; layout { area(content) { group(Options) { Caption = 'Options'; field(ShowDim; ShowDim) { ApplicationArea = Dimensions; Caption = 'Show Dimensions'; ToolTip = 'Specifies if you want dimensions information for the journal lines to be included in the report.'; } } } } actions { } } rendering { layout(RDLCLayout) { Type = RDLC; LayoutFile = './Inventory/Reports/InventoryPostingTest.rdlc'; Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.'; } } labels { } trigger OnPreReport() begin ItemJnlLineFilter := "Item Journal Line".GetFilters(); GLSetup.Get(); InvtSetup.Get(); end; var InvtSetup: Record "Inventory Setup"; GLSetup: Record "General Ledger Setup"; AccountingPeriod: Record "Accounting Period"; Item: Record Item; ItemJnlTemplate: Record "Item Journal Template"; GenPostingSetup: Record "General Posting Setup"; NoSeries: Record "No. Series"; DimSetEntry: Record "Dimension Set Entry"; Location: Record Location; InvtPeriod: Record "Inventory Period"; DimMgt: Codeunit DimensionManagement; ItemJnlLineFilter: Text; EntryTypeDescription: array[7] of Text[30]; CostAmount: Decimal; NoOfEntries: array[7] of Decimal; TotalCostAmounts: array[7] of Decimal; TotalAmount: Decimal; TotalCostAmount: Decimal; QtyError: Boolean; ErrorCounter: Integer; ErrorText: array[30] of Text[250]; i: Integer; LastPostingDate: Date; LastDocNo: Code[20]; TableID: array[10] of Integer; JnlTemplateType: Integer; ItemLineEntryType: Integer; No: array[10] of Code[20]; DimText: Text[120]; OldDimText: Text[75]; ShowDim: Boolean; Continue: Boolean; OperationNo: Code[20]; OperationNoCaption: Text; ScrapCode: Code[10]; ScrapCodeCaption: Text; StopCode: Code[10]; StopCodeCaption: Text; OutputQuantity: Decimal; OutputQuantityCaption: Text; RunTime: Decimal; RunTimeCaption: Text; SetupTime: Decimal; SetupTimeCaption: Text; StopTime: Decimal; StopTimeCaption: Text;#pragma warning disable AA0074#pragma warning disable AA0470 Text000: Label '%1 cannot be filtered when you post recurring journals.'; Text001: Label '%1 must be specified.'; Text002: Label '%1 %2 does not exist.'; Text003: Label '%1 must be %2 for %3 %4.'; Text005: Label '%1 must not be a closing date.';#pragma warning restore AA0470 Text006: Label 'The lines are not listed according to Posting Date because they were not entered in that order.';#pragma warning disable AA0470 Text007: Label '%1 is not within your allowed range of posting dates.'; Text008: Label '%1 %2 %3 does not exist.'; Text009: Label '%1 must be 0.'; Text011: Label '%1 must be 0 when %2 is %3.'; Text012: Label '%1 must not be negative when %2 is %3.'; Text013: Label '%1 must have the same value as %2 when %3 is %4.'; Text014: Label '%1 must be %2 or %3 when %4 is %5.'; Text015: Label '%1 must equal %2 - %3 when %4 is %5 and %6 is %7.'; Text016: Label '%1 cannot be specified.';#pragma warning restore AA0470 Text017: Label 'There is a gap in the number series.';#pragma warning disable AA0470 Text020: Label '%1 %2 is not on inventory for %3 %4.'; Text021: Label '%1 %2 is not on inventory.';#pragma warning restore AA0470#pragma warning restore AA0074 TotalAm1: Decimal; TotalAm2: Decimal; TotalAm3: Decimal; TotalAm4: Decimal; TotalAm5: Decimal; TotalCostAm1: Decimal; TotalCostAm2: Decimal; TotalCostAm3: Decimal; TotalCostAm4: Decimal; TotalCostAm5: Decimal; Inventory_Posting___TestCaptionLbl: Label 'Inventory Posting - Test'; CurrReport_PAGENOCaptionLbl: Label 'Page'; Item_Journal_Line__Posting_Date_CaptionLbl: Label 'Posting Date'; Item_Journal_Line__Entry_Type_CaptionLbl: Label 'Entry Type'; CostAmountCaptionLbl: Label 'Cost Amount'; TotalAmountCaptionLbl: Label 'Total'; DimensionsCaptionLbl: Label 'Dimensions'; ErrorText_Number_CaptionLbl: Label 'Warning!'; local procedure CheckRecurringLine(ItemJnlLine2: Record "Item Journal Line") begin if ItemJnlTemplate.Recurring then begin if ItemJnlLine2."Recurring Method" = 0 then AddError(StrSubstNo(Text001, ItemJnlLine2.FieldCaption("Recurring Method"))); if Format(ItemJnlLine2."Recurring Frequency") = '' then AddError(StrSubstNo(Text001, ItemJnlLine2.FieldCaption("Recurring Frequency"))); if ItemJnlLine2."Recurring Method" = ItemJnlLine2."Recurring Method"::Variable then if ItemJnlLine2.Quantity = 0 then AddError(StrSubstNo(Text001, ItemJnlLine2.FieldCaption(Quantity))); end else begin if ItemJnlLine2."Recurring Method" <> 0 then AddError(StrSubstNo(Text016, ItemJnlLine2.FieldCaption("Recurring Method"))); if Format(ItemJnlLine2."Recurring Frequency") <> '' then AddError(StrSubstNo(Text016, ItemJnlLine2.FieldCaption("Recurring Frequency"))); end; end; local procedure MakeRecurringTexts(var ItemJnlLine2: Record "Item Journal Line") begin if (ItemJnlLine2."Posting Date" <> 0D) and (ItemJnlLine2."Item No." <> '') and (ItemJnlLine2."Recurring Method" <> 0) then AccountingPeriod.MakeRecurringTexts(ItemJnlLine2."Posting Date", ItemJnlLine2."Document No.", ItemJnlLine2.Description); end; local procedure CheckDimValuePosting(var ItemJournalLine: Record "Item Journal Line") begin OnBeforeCheckDimValuePosting(TableID, No, ItemJournalLine); if not DimMgt.CheckDimValuePosting(TableID, No, ItemJournalLine."Dimension Set ID") then AddError(DimMgt.GetDimValuePostingErr()); end; procedure AddError(Text: Text[250]) begin ErrorCounter := ErrorCounter + 1; ErrorText[ErrorCounter] := Text; end; local procedure GetLocation(LocationCode: Code[10]) begin if LocationCode = '' then Clear(Location) else if Location.Code <> LocationCode then Location.Get(LocationCode); end; [IntegrationEvent(false, false)] local procedure OnAfterCheckDimension(ItemJournalLine: Record "Item Journal Line"; ItemJnlTemplate: Record "Item Journal Template"; QtyError: Boolean); begin end; [IntegrationEvent(false, false)] local procedure OnAfterCheckItemJnLLine(ItemJournalLine: Record "Item Journal Line"; Item: Record Item; var ErrorCounter: Integer; var ErrorText: array[30] of Text[250]) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeCheckDimValuePosting(var TableID: array[10] of Integer; var No: array[10] of Code[20]; ItemJournalLine: Record "Item Journal Line") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeItemJournalLineOnAfterGetRecord(ItemJournalLine: Record "Item Journal Line"; var ErrorCounter: Integer; var ErrorText: array[30] of Text[250]) begin end; [IntegrationEvent(false, false)] local procedure OnItemJournalLineOnAfterGetRecordOnAfterCalcItemInventory(var Item: Record Item; ItemJournalLine: Record "Item Journal Line") begin end; [InternalEvent(true)] local procedure OnAfterGetRecordOnCheckManufacturing(var ItemJournalLine: Record "Item Journal Line"; var QtyError: Boolean) begin end; [InternalEvent(false)] local procedure OnAfterGetRecordOnSetManufacturingFields( var ItemJournalLine: Record "Item Journal Line"; var OperationNo: Code[20]; var OperationNoCaption: Text; var OutputQuantity: Decimal; var OutputQuantityCaption: Text; var ScrapCode: Code[10]; var ScrapCodeCaption: Text; var StopCode: Code[10]; var StopCodeCaption: Text; var RunTime: Decimal; var RunTimeCaption: Text; var SetupTime: Decimal; var SetupTimeCaption: Text; var StopTime: Decimal; var StopTimeCaption: Text) begin end;}