Report 5802 Inventory Valuation - WIP
src/Layers/W1/BaseApp/Manufacturing/Reports/InventoryValuationWIP.Report.al761 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.Inventory.Ledger;using Microsoft.Manufacturing.Document;using System.Utilities;report 5802 "Inventory Valuation - WIP"{ ApplicationArea = Manufacturing; Caption = 'Production Order - WIP'; ToolTip = 'View inventory valuation for selected production orders in your WIP inventory. The report also shows information about the value of consumption, capacity usage and output in WIP. The printed report only shows invoiced amounts, that is, the cost of entries that have been posted as invoiced.'; UsageCategory = ReportsAndAnalysis; DefaultRenderingLayout = Excel; dataset { dataitem("Production Order"; "Production Order") { CalcFields = "Inventory Adjmt. Entry Exists"; DataItemTableView = where(Status = filter(Released ..)); PrintOnlyIfDetail = true; RequestFilterFields = Status, "No."; column(ProdOrderFilter; ProdOrderFilter) { } column(StartDate; StartDateText) { } column(EndDate; EndDate) { } column(AsOfStartDateText; StrSubstNo(Text005, StartDateText)) { } column(AsofEndDate; StrSubstNo(Text005, Format(EndDate))) { } column(No_ProductionOrder; "No.") { IncludeCaption = true; } column(SourceNo_ProductionOrder; "Source No.") { IncludeCaption = true; } column(SrcType_ProductionOrder; "Source Type") { IncludeCaption = true; } column(Desc_ProductionOrder; Description) { IncludeCaption = true; } column(Status_ProductionOrder; Status) { IncludeCaption = true; }#if not CLEAN28 column(CompanyName; COMPANYPROPERTY.DisplayName()) { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '28.0'; } column(TodayFormatted; Format(Today, 0, 4)) { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '28.0'; } column(InventoryValuationWIPCptn; InventoryValuationWIPCptnLbl) { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '28.0'; } column(CurrReportPageNoCaption; CurrReportPageNoCaptionLbl) { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '28.0'; } column(ValueOfCapCaption; ValueOfCapCaptionLbl) { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '28.0'; } column(ValueOfOutputCaption; ValueOfOutputCaptionLbl) { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '28.0'; } column(ValueEntryCostPostedtoGLCaption; ValueEntryCostPostedtoGLCaptionLbl) { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '28.0'; } column(ExpensedWIPCaption; ExpensedWIPCaptionLbl) { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '28.0'; } column(ValueOfMatConsumpCaption; ValueOfMatConsumpCaptionLbl) { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '28.0'; } column(ProductionOrderNoCaption; ProductionOrderNoCaptionLbl) { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '28.0'; } column(ProdOrderStatusCaption; ProdOrderStatusCaptionLbl) { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '28.0'; } column(ProdOrderDescriptionCaption; ProdOrderDescriptionCaptionLbl) { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '28.0'; } column(ProdOrderSourceTypeCaptn; ProdOrderSourceTypeCaptnLbl) { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '28.0'; } column(ProdOrderSourceNoCaption; ProdOrderSourceNoCaptionLbl) { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '28.0'; } column(TotalCaption; TotalCaptionLbl) { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '28.0'; }#endif dataitem("Value Entry"; "Value Entry") { DataItemTableView = sorting("Order Type", "Order No."); column(ValueEntryCostPostedtoGL; TotalValueOfCostPstdToGL) { AutoFormatType = 1; } column(ValueOfOutput; TotalValueOfOutput) { AutoFormatType = 1; } column(ValueOfCap; TotalValueOfCap) { AutoFormatType = 1; } column(ValueOfMatConsump; TotalValueOfMatConsump) { AutoFormatType = 1; } column(ValueOfWIP; TotalValueOfWIP) { AutoFormatType = 1; } column(LastOutput; TotalLastOutput) { } column(AtLastDate; TotalAtLastDate) { } column(LastWIP; TotalLastWIP) { } column(ExpensedWIP; TotalExpensedWIP) { AutoFormatType = 1; } trigger OnAfterGetRecord() var IsHandled: Boolean; FinishedDate: Date; begin CountRecord := CountRecord + 1; LastOutput := 0; AtLastDate := 0; LastWIP := 0; ValueOfWIP := 0; ValueOfMatConsump := 0; ValueOfCap := 0; ValueOfOutput := 0; ValueOfInvOutput1 := 0; ValueOfExpOutput1 := 0; ValueOfExpOutput2 := 0; ValueOfCostPstdToGL := 0; if (CountRecord = LengthRecord) and IsNotWIP() then begin ValueEntryOnPostDataItem(); AtLastDate := NcValueOfWIP + NcValueOfMatConsump + NcValueOfCap + NcValueOfOutput; LastOutput := NcValueOfOutput; LastWIP := NcValueOfWIP; ValueOfCostPstdToGL := NcValueOfCostPstdToGL; NcValueOfWIP := 0; NcValueOfOutput := 0; NcValueOfMatConsump := 0; NcValueOfCap := 0; NcValueOfInvOutput1 := 0; NcValueOfExpOutPut1 := 0; NcValueOfExpOutPut2 := 0; NcValueOfRevalCostAct := 0; NcValueOfRevalCostPstd := 0; NcValueOfCostPstdToGL := 0; end; if not IsNotWIP() then begin if EntryFound then ValueOfCostPstdToGL := "Cost Posted to G/L"; if "Posting Date" < StartDate then begin if "Item Ledger Entry Type" = "Item Ledger Entry Type"::" " then ValueOfWIP := "Cost Amount (Actual)" else ValueOfWIP := -"Cost Amount (Actual)"; if "Item Ledger Entry Type" = "Item Ledger Entry Type"::Output then begin ValueOfExpOutput1 := -"Cost Amount (Expected)"; ValueOfInvOutput1 := -"Cost Amount (Actual)"; ValueOfWIP := ValueOfExpOutput1 + ValueOfInvOutput1; end; if ("Entry Type" = "Entry Type"::Revaluation) and ("Cost Amount (Actual)" <> 0) then ValueOfWIP := 0; end else case "Item Ledger Entry Type" of "Item Ledger Entry Type"::Consumption: if IsProductionCost("Value Entry") then ValueOfMatConsump := -"Cost Amount (Actual)"; "Item Ledger Entry Type"::" ": ValueOfCap := "Cost Amount (Actual)"; "Item Ledger Entry Type"::Output: begin ValueOfExpOutput2 := -"Cost Amount (Expected)"; ValueOfOutput := -("Cost Amount (Actual)" + "Cost Amount (Expected)"); if "Entry Type" = "Entry Type"::Revaluation then ValueOfRevalCostAct += -"Cost Amount (Actual)"; end; end; if not ("Item Ledger Entry Type" = "Item Ledger Entry Type"::" ") then begin "Cost Amount (Actual)" := -"Cost Amount (Actual)"; if IsProductionCost("Value Entry") then begin ValueOfCostPstdToGL := -("Cost Posted to G/L" + "Expected Cost Posted to G/L"); if "Entry Type" = "Entry Type"::Revaluation then ValueOfRevalCostPstd += ValueOfCostPstdToGL; end else ValueOfCostPstdToGL := 0; end else ValueOfCostPstdToGL := "Cost Posted to G/L" + "Expected Cost Posted to G/L"; NcValueOfWIP := NcValueOfWIP + ValueOfWIP; NcValueOfOutput := NcValueOfOutput + ValueOfOutput; NcValueOfMatConsump := NcValueOfMatConsump + ValueOfMatConsump; NcValueOfCap := NcValueOfCap + ValueOfCap; NcValueOfInvOutput1 := NcValueOfInvOutput1 + ValueOfInvOutput1; NcValueOfExpOutPut1 := NcValueOfExpOutPut1 + ValueOfExpOutput1; NcValueOfExpOutPut2 := NcValueOfExpOutPut2 + ValueOfExpOutput2; NcValueOfRevalCostAct := ValueOfRevalCostAct; NcValueOfRevalCostPstd := ValueOfRevalCostPstd; NcValueOfCostPstdToGL := NcValueOfCostPstdToGL + ValueOfCostPstdToGL; ValueOfCostPstdToGL := 0; if ValueEntryIsForNoOutputFinishedLine("Value Entry") then begin OrderExpensedEndingWIP := OrderExpensedEndingWIP + ValueOfWIP + ValueOfMatConsump + ValueOfCap + ValueOfOutput; OrderExpensedOpeningWIP := OrderExpensedOpeningWIP + ValueOfWIP; OrderExpensedConsump := OrderExpensedConsump + ValueOfMatConsump; OrderExpensedCap := OrderExpensedCap + ValueOfCap; end; if CountRecord = LengthRecord then begin ValueEntryOnPostDataItem(); ValueOfCostPstdToGL := NcValueOfCostPstdToGL; AtLastDate := NcValueOfWIP + NcValueOfMatConsump + NcValueOfCap + NcValueOfOutput; LastOutput := NcValueOfOutput; LastWIP := NcValueOfWIP; NcValueOfWIP := 0; NcValueOfOutput := 0; NcValueOfMatConsump := 0; NcValueOfCap := 0; NcValueOfInvOutput1 := 0; NcValueOfExpOutPut1 := 0; NcValueOfExpOutPut2 := 0; NcValueOfRevalCostAct := 0; NcValueOfRevalCostPstd := 0; NcValueOfCostPstdToGL := 0; end; if not ReportHasData then ReportHasData := true; end; IsHandled := false; OnValueEntryOnAfterGetRecordOnBeforeIncrementTotals(ValueOfCostPstdToGL, AtLastDate, IsHandled); if IsHandled then CurrReport.Skip(); TotalValueOfCostPstdToGL := TotalValueOfCostPstdToGL + ValueOfCostPstdToGL; TotalValueOfOutput := TotalValueOfOutput + ValueOfOutput; TotalValueOfCap := TotalValueOfCap + ValueOfCap; TotalValueOfMatConsump := TotalValueOfMatConsump + ValueOfMatConsump; TotalValueOfWIP := TotalValueOfWIP + ValueOfWIP; TotalLastOutput := TotalLastOutput + LastOutput; TotalAtLastDate := TotalAtLastDate + AtLastDate; TotalLastWIP := TotalLastWIP + LastWIP; LastWipSum += ValueOfWIP; ValueOfMatConsumptionSum += ValueOfMatConsump; ValueOfCapSum += ValueOfCap; ValueOfOutputSum += LastOutput; AtLastDateSum += AtLastDate; ValueEntryCostPostedToGLSum += ValueOfCostPstdToGL; if (CountRecord = LengthRecord) and OrderHasNoOutputFinishedLine("Production Order") then begin FinishedDate := "Production Order"."Finished Date"; if (EndDate = 0D) or (FinishedDate <= EndDate) then begin if FinishedDate >= StartDate then begin TotalExpensedWIP := TotalExpensedWIP + OrderExpensedEndingWIP; ExpensedWIPSum := ExpensedWIPSum + OrderExpensedEndingWIP; ValueOfMatConsumptionSum := ValueOfMatConsumptionSum - OrderExpensedConsump; TotalValueOfMatConsump := TotalValueOfMatConsump - OrderExpensedConsump; ValueOfCapSum := ValueOfCapSum - OrderExpensedCap; TotalValueOfCap := TotalValueOfCap - OrderExpensedCap; end else begin LastWipSum := LastWipSum - OrderExpensedOpeningWIP; TotalLastWIP := TotalLastWIP - OrderExpensedOpeningWIP; end; AtLastDateSum := AtLastDateSum - OrderExpensedEndingWIP; TotalAtLastDate := TotalAtLastDate - OrderExpensedEndingWIP; end; end; if (CountRecord <> LengthRecord) or (SkipZeroLines and ((TotalAtLastDate = 0) and (TotalExpensedWIP = 0) and (TotalValueOfCostPstdToGL = 0))) then CurrReport.Skip(); end; trigger OnPostDataItem() begin ValueEntryOnPostDataItem(); end; trigger OnPreDataItem() begin TotalValueOfCostPstdToGL := 0; TotalValueOfOutput := 0; TotalValueOfCap := 0; TotalValueOfMatConsump := 0; TotalValueOfWIP := 0; TotalLastOutput := 0; TotalAtLastDate := 0; TotalLastWIP := 0; TotalExpensedWIP := 0; OrderExpensedEndingWIP := 0; OrderExpensedOpeningWIP := 0; OrderExpensedConsump := 0; OrderExpensedCap := 0; SetRange("Order Type", "Order Type"::Production); SetRange("Order No.", "Production Order"."No."); if EndDate <> 0D then SetRange("Posting Date", 0D, EndDate); ValueOfRevalCostAct := 0; ValueOfRevalCostPstd := 0; LengthRecord := 0; CountRecord := 0; if Find('-') then repeat LengthRecord := LengthRecord + 1; until Next() = 0; end; } trigger OnAfterGetRecord() begin if FinishedProdOrderIsCompletelyInvoiced() then CurrReport.Skip(); EntryFound := ValueEntryExist("Production Order", StartDate, EndDate); end; } dataitem(Totals; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(LatWipSum; LastWipSum) { } column(ValueOfMatConsumptionSum; ValueOfMatConsumptionSum) { } column(ValueOfCapSum; ValueOfCapSum) { } column(ValueOfOutputSum; ValueOfOutputSum) { } column(AtLastDateSum; AtLastDateSum) { } column(ExpensedWIPSum; ExpensedWIPSum) { } column(ValueEntryCostPostedToGLSum; ValueEntryCostPostedToGLSum) { } trigger OnPreDataItem() begin if not ReportHasData then CurrReport.Break(); end; } } requestpage { AboutTitle = 'About Production Order - WIP'; AboutText = 'Details Starting WIP, Consumption, Capacity and Output posted during a period and ending WIP for each Production Order. Use it to report in detail your WIP balance and to Reconcile your WIP to the General Ledger WIP Balance Sheet Account at the end of each period.'; SaveValues = true; layout { area(content) { group(Options) { Caption = 'Options'; field(StartingDate; StartDate) { ApplicationArea = Basic, Suite; Caption = 'Starting Date'; ToolTip = 'Specifies the beginning of the period covered by the inventory valuation report.'; } field(EndingDate; EndDate) { ApplicationArea = Basic, Suite; Caption = 'Ending Date'; ToolTip = 'Specifies the date to which the report or batch job processes information.'; } field(SkipZero; SkipZeroLines) { ApplicationArea = Basic, Suite; Caption = 'Skip Zero Lines'; ToolTip = 'Specifies whether to skip zero lines.'; } // Used to set a report header across multiple languages field(RequestProdOrderFilterHeading; ProdOrderFilterHeading) { ApplicationArea = All; Caption = 'Prod. Order Filter'; ToolTip = 'Specifies the Prod. Order filters applied to this report.'; Visible = false; } field(RequestStartDateHeading; StartDateHeading) { ApplicationArea = All; Caption = 'Start Date'; ToolTip = 'Specifies the Start Date applied to this report as a text value for use in the Excel report header.'; Visible = false; } field(RequestEndDateHeading; EndDateHeading) { ApplicationArea = All; Caption = 'End Date'; ToolTip = 'Specifies the End Date applied to this report as a text value for use in the Excel report header.'; Visible = false; } } } } actions { } trigger OnOpenPage() begin if (StartDate = 0D) and (EndDate = 0D) then EndDate := WorkDate(); end; trigger OnClosePage() begin UpdateRequestPageFilterValues(); end; } rendering { layout(Excel) { Caption = 'Production Order - WIP Excel'; Type = Excel; LayoutFile = '.\Manufacturing\Reports\InventoryValuationWIP.xlsx'; Summary = 'Built in layout for the Production Order - WIP Excel report.'; } layout(Word) { Caption = 'Production Order - WIP Word'; Type = Word; LayoutFile = '.\Manufacturing\Reports\InventoryValuationWIP.docx'; Summary = 'Built in layout for the Production Order - WIP Word report.'; }#if not CLEAN28 layout(RDLC) { Caption = 'Production Order - WIP RDLC (Obsolete)'; Type = RDLC; LayoutFile = '.\Manufacturing\Reports\InventoryValuationWIP.rdlc'; ObsoleteState = Pending; ObsoleteReason = 'The RDLC layout has been replaced by the Excel and Word layouts and will be removed in a future release.'; ObsoleteTag = '28.0'; Summary = 'Built in layout for the Production Order - WIP RDLC (Obsolete) report.'; }#endif } labels { ProdOrderWIPLbl = 'Production Order - WIP'; ProdOrderWipPrintLbl = 'Prod. Order - WIP (Print)', MaxLength = 31, Comment = 'Excel worksheet name.'; ProdOrderWipAnalysisLbl = 'Prod. Order - WIP (Analysis)', MaxLength = 31, Comment = 'Excel worksheet name.'; DataRetrievedLbl = 'Data retrieved:'; TotalLbl = 'Total'; PeriodLbl = 'Period:'; UntilLbl = 'Until:'; AsOfStartDateLbl = 'As of Start Date'; ConsumptionLbl = 'Consumption'; CapacityLbl = 'Capacity'; OutputLbl = 'Output'; AsOfEndDateLbl = 'As of End Date'; CostPostedToGLLbl = 'Cost Posted to G/L'; ExpensedWIPLbl = 'Expensed WIP'; // About the report labels AboutTheReportLbl = 'About the report', MaxLength = 31, Comment = 'Excel worksheet name.'; EnvironmentLbl = 'Environment'; CompanyLbl = 'Company'; UserLbl = 'User'; RunOnLbl = 'Run on'; ReportNameLbl = 'Report name'; DocumentationLbl = 'Documentation'; } trigger OnPreReport() begin UpdateRequestPageFilterValues(); end; var#pragma warning disable AA0074#pragma warning disable AA0470 Text005: Label 'As of %1';#pragma warning restore AA0470#pragma warning restore AA0074 StartDate: Date; EndDate: Date; ProdOrderFilter: Text; ProdOrderFilterHeading: Text; StartDateText: Text[10]; ValueOfWIP: Decimal; ValueOfMatConsump: Decimal; ValueOfCap: Decimal; ValueOfOutput: Decimal; ValueOfExpOutput1: Decimal; ValueOfInvOutput1: Decimal; ValueOfExpOutput2: Decimal; ValueOfRevalCostAct: Decimal; ValueOfRevalCostPstd: Decimal; ValueOfCostPstdToGL: Decimal; NcValueOfWIP: Decimal; NcValueOfOutput: Decimal; NcValueOfMatConsump: Decimal; NcValueOfCap: Decimal; NcValueOfInvOutput1: Decimal; NcValueOfExpOutPut1: Decimal; NcValueOfExpOutPut2: Decimal; NcValueOfRevalCostAct: Decimal; NcValueOfRevalCostPstd: Decimal; NcValueOfCostPstdToGL: Decimal; LastOutput: Decimal; LengthRecord: Integer; CountRecord: Integer; AtLastDate: Decimal; LastWIP: Decimal; TotalValueOfCostPstdToGL: Decimal; TotalValueOfOutput: Decimal; TotalValueOfCap: Decimal; TotalValueOfMatConsump: Decimal; TotalValueOfWIP: Decimal; TotalLastOutput: Decimal; TotalAtLastDate: Decimal; TotalLastWIP: Decimal; TotalExpensedWIP: Decimal; OrderExpensedEndingWIP: Decimal; OrderExpensedOpeningWIP: Decimal; OrderExpensedConsump: Decimal; OrderExpensedCap: Decimal; SkipZeroLines: Boolean; ReportHasData: Boolean; StartDateHeading: Text; EndDateHeading: Text;#if not CLEAN28 InventoryValuationWIPCptnLbl: Label 'Inventory Valuation - WIP'; CurrReportPageNoCaptionLbl: Label 'Page'; ValueOfCapCaptionLbl: Label 'Capacity '; ValueOfOutputCaptionLbl: Label 'Output '; ValueEntryCostPostedtoGLCaptionLbl: Label 'Cost Posted to G/L'; ExpensedWIPCaptionLbl: Label 'Expensed WIP'; ValueOfMatConsumpCaptionLbl: Label 'Consumption '; ProductionOrderNoCaptionLbl: Label 'No.'; ProdOrderStatusCaptionLbl: Label 'Status'; ProdOrderDescriptionCaptionLbl: Label 'Description'; ProdOrderSourceTypeCaptnLbl: Label 'Source Type'; ProdOrderSourceNoCaptionLbl: Label 'Source No.'; TotalCaptionLbl: Label 'Total';#endif EntryFound: Boolean; LastWipSum: Decimal; ValueOfMatConsumptionSum: Decimal; ValueOfCapSum: Decimal; ValueOfOutputSum: Decimal; AtLastDateSum: Decimal; ExpensedWIPSum: Decimal; ValueEntryCostPostedToGLSum: Decimal; local procedure ValueEntryOnPostDataItem() begin if (NcValueOfExpOutPut2 + NcValueOfExpOutPut1) = 0 then begin // if prod. order is invoiced NcValueOfOutput := NcValueOfOutput - NcValueOfRevalCostAct; // take out revalued differnce NcValueOfCostPstdToGL := NcValueOfCostPstdToGL - NcValueOfRevalCostPstd; // take out Cost posted to G/L end; end; local procedure IsNotWIP() Result: Boolean begin if "Value Entry"."Item Ledger Entry Type" = "Value Entry"."Item Ledger Entry Type"::Output then Result := not ("Value Entry"."Entry Type" in ["Value Entry"."Entry Type"::"Direct Cost", "Value Entry"."Entry Type"::Revaluation]) else Result := "Value Entry"."Expected Cost"; OnAfterIsNotWIP("Value Entry", Result); exit(Result); end; local procedure IsProductionCost(ValueEntry: Record "Value Entry"): Boolean begin if (ValueEntry."Entry Type" = ValueEntry."Entry Type"::Revaluation) and (ValueEntry."Item Ledger Entry Type" = ValueEntry."Item Ledger Entry Type"::Consumption) and ("Value Entry"."Item Ledger Entry Quantity" > 0) then exit(false); exit(true); end; local procedure FinishedProdOrderIsCompletelyInvoiced(): Boolean begin if "Production Order".Status <> "Production Order".Status::Finished then exit(false); if "Production Order"."Inventory Adjmt. Entry Exists" then exit(false); exit(not ValueEntryExist("Production Order", StartDate, 99991231D)); end; local procedure OrderHasNoOutputFinishedLine(var ProductionOrder: Record "Production Order"): Boolean var ProdOrderLine: Record "Prod. Order Line"; begin if ProductionOrder.Status <> ProductionOrder.Status::Finished then exit(false); ProdOrderLine.SetLoadFields("Finished Qty. (Base)"); ProdOrderLine.SetRange(Status, ProdOrderLine.Status::Finished); ProdOrderLine.SetRange("Prod. Order No.", ProductionOrder."No."); ProdOrderLine.SetRange("Finished Qty. (Base)", 0); exit(not ProdOrderLine.IsEmpty()); end; local procedure ValueEntryIsForNoOutputFinishedLine(ValueEntry: Record "Value Entry"): Boolean var ProdOrderLine: Record "Prod. Order Line"; begin ProdOrderLine.SetLoadFields("Finished Qty. (Base)"); if not ProdOrderLine.Get(ProdOrderLine.Status::Finished, ValueEntry."Order No.", ValueEntry."Order Line No.") then exit(false); exit(ProdOrderLine."Finished Qty. (Base)" = 0); end; procedure InitializeRequest(NewStartDate: Date; NewEndDate: Date) begin StartDate := NewStartDate; EndDate := NewEndDate; end; local procedure ValueEntryExist(ProductionOrder: Record "Production Order"; StartDate: Date; EndDate: Date): Boolean var ValueEntry: Record "Value Entry"; begin ValueEntry.SetRange("Order Type", ValueEntry."Order Type"::Production); ValueEntry.SetRange("Order No.", ProductionOrder."No."); ValueEntry.SetRange("Posting Date", StartDate, EndDate); exit(not ValueEntry.IsEmpty); end; // Ensures Layout Filter Headings are up to date local procedure UpdateRequestPageFilterValues() begin ProdOrderFilter := "Production Order".GetFilters(); if ProdOrderFilter <> '' then ProdOrderFilterHeading := "Production Order".TableCaption + ': ' + ProdOrderFilter; if (StartDate = 0D) and (EndDate = 0D) then EndDate := WorkDate(); if StartDate in [0D, 00000101D] then StartDateText := '' else StartDateText := Format(StartDate - 1); StartDateHeading := Format(StartDate); EndDateHeading := Format(EndDate); end; [IntegrationEvent(false, false)] local procedure OnValueEntryOnAfterGetRecordOnBeforeIncrementTotals(ValueOfCostPstdToGL: Decimal; AtLastDate: Decimal; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnAfterIsNotWIP(var ValueEntry: Record "Value Entry"; var Result: Boolean) begin end;}