Report 20400 Qlty. Create Inspection
src/Apps/W1/Quality Management/app/src/Document/QltyCreateInspection.Report.al403 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.QualityManagement.Document;using Microsoft.Inventory.Tracking;using Microsoft.QualityManagement.AccessControl;using Microsoft.QualityManagement.Configuration.GenerationRule;using Microsoft.QualityManagement.Configuration.SourceConfiguration;using Microsoft.QualityManagement.Configuration.Template;using System.Reflection;using System.Utilities;report 20400 "Qlty. Create Inspection"{ Caption = 'Create Quality Inspection'; ProcessingOnly = true; AccessByPermission = tabledata "Qlty. Inspection Header" = R; UsageCategory = ReportsAndAnalysis; ApplicationArea = QualityManagement; Permissions = tabledata "Qlty. Inspection Header" = Rim, tabledata "Qlty. Inspection Line" = Rim; dataset { dataitem(CurrentProcessing; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); trigger OnAfterGetRecord() begin CreateQltyInspection(); end; } } requestpage { layout { area(Content) { group(Parameters) { Caption = 'Parameters'; field(ChooseQltyInspectionTemplateCode; QltInspectionTemplateToCreate) { ApplicationArea = All; Caption = 'Template Code'; Tooltip = 'Specifies which Quality Inspection Template to create.'; ShowMandatory = true; trigger OnLookup(var Text: Text): Boolean var QltyInspectionTemplateHdr: Record "Qlty. Inspection Template Hdr."; begin if Page.RunModal(0, QltyInspectionTemplateHdr) = Action::LookupOK then QltInspectionTemplateToCreate := QltyInspectionTemplateHdr.Code; end; } field(ChooseSource; SourceTable) { ApplicationArea = All; Caption = 'Source'; ToolTip = 'Specifies a reference to which source should be used.'; ShowMandatory = true; trigger OnLookup(var Text: Text): Boolean var QltyInspectSourceConfigList: Page "Qlty. Ins. Source Config. List"; OldTableNo: Integer; begin if not QltyInspecGenRuleMgmt.EnsureCompatibleGenerationRuleExists(QltInspectionTemplateToCreate) then exit(false); OldTableNo := QltyInspectSourceConfig."From Table No."; QltyInspectSourceConfig.Reset(); QltyInspectSourceConfig.FilterGroup(20); QltyInspectSourceConfig.SetFilter(Code, '<>%1', ''); QltyInspectSourceConfig.SetRange(Enabled, true); QltyInspectSourceConfig.FilterGroup(0); QltyInspecGenRuleMgmt.SetFilterToApplicableTemplates(QltInspectionTemplateToCreate, QltyInspectSourceConfig); QltyInspectSourceConfigList.LookupMode(true); QltyInspectSourceConfigList.SetTableView(QltyInspectSourceConfig); if QltyInspectSourceConfigList.RunModal() = Action::LookupOK then begin QltyInspectSourceConfigList.GetRecord(QltyInspectSourceConfig); SourceTable := QltyInspectSourceConfig.Code; if QltyInspectSourceConfig."From Table No." <> OldTableNo then ClearParameters(); end; end; trigger OnValidate() begin ClearParameters(); end; } field(ChooseTableNo; QltyInspectSourceConfig."From Table No.") { ApplicationArea = All; Caption = 'Table No.'; Tooltip = 'Specifies which table this references.'; Editable = false; Visible = false; Importance = Additional; } field(ChooseGetRecord; Format(Target)) { ApplicationArea = All; Caption = 'Choose Record'; Tooltip = 'Specifies which record you want to create a Quality Inspection for.'; Visible = VisibleGetRecord; ShowMandatory = true; AssistEdit = true; trigger OnAssistEdit() begin AssistEditChooseRecord(); end; } field(ChooseItemNo; TempQltyInspectionHeader."Source Item No.") { ApplicationArea = All; Caption = 'Item No.'; ToolTip = 'Specifies the Item No.'; Editable = false; } field(ChooseLotNo; TempQltyInspectionHeader."Source Lot No.") { ApplicationArea = All; Caption = 'Lot No.'; ToolTip = 'Specifies the Lot No.'; Editable = EditLotNo; Visible = VisibleLotNo; trigger OnAssistEdit() begin TempQltyInspectionHeader.AssistEditLotNo(); end; } field(ChooseSerialNo; TempQltyInspectionHeader."Source Serial No.") { ApplicationArea = All; Caption = 'Serial No.'; ToolTip = 'Specifies the Serial No.'; Editable = EditSerialNo; Visible = VisibleSerialNo; trigger OnAssistEdit() begin TempQltyInspectionHeader.AssistEditSerialNo(); end; } field(ChoosePackageNo; TempQltyInspectionHeader."Source Package No.") { ApplicationArea = All; Caption = 'Package No.'; ToolTip = 'Specifies the Package No.'; Editable = EditPackageNo; Visible = VisiblePackageNo; trigger OnAssistEdit() begin TempQltyInspectionHeader.AssistEditPackageNo(); end; } field(ChooseSourceQuantity; TempQltyInspectionHeader."Source Quantity (Base)") { ApplicationArea = All; Caption = 'Source Quantity (base)'; ToolTip = 'Specifies the quantity used to create the inspection with.'; AutoFormatType = 0; DecimalPlaces = 0 : 5; Editable = EditSourceQuantity; Visible = VisibleSourceQuantity; trigger OnValidate() begin DidChangeSourceQuantity := true; end; } } } } trigger OnInit() begin SetRequestPageControlVisibility(); end; trigger OnQueryClosePage(CloseAction: Action): Boolean var QltInspectionTemplateHdr: Record "Qlty. Inspection Template Hdr."; NullCheckRecordId: RecordId; begin if CloseAction = CloseAction::OK then begin if not QltInspectionTemplateHdr.Get(QltInspectionTemplateToCreate) then Error(NotAValidQltyInspectionTemplateErr, QltInspectionTemplateToCreate); if (NullCheckRecordId = Target) or (Target.TableNo = 0) then Error(PleaseChooseARecordFirstErr); end; end; } var QltyInspectSourceConfig: Record "Qlty. Inspect. Source Config."; TempQltyInspectionHeader: Record "Qlty. Inspection Header" temporary; QltyInspectionCreate: Codeunit "Qlty. Inspection - Create"; QltyInspecGenRuleMgmt: Codeunit "Qlty. Inspec. Gen. Rule Mgmt."; QltyPermissionMgmt: Codeunit "Qlty. Permission Mgmt."; Target: RecordId; TargetRecordRef: RecordRef; QltInspectionTemplateToCreate: Code[20]; VariantForRecordRef: Variant; SourceTable: Code[20]; CustomFilter: Text; VisibleLotNo, VisibleSerialNo, VisiblePackageNo : Boolean; VisibleGetRecord: Boolean; EditLotNo, EditSerialNo, EditPackageNo : Boolean; EditSourceQuantity: Boolean; VisibleSourceQuantity: Boolean; DidChangeSourceQuantity: Boolean; NotAValidQltyInspectionTemplateErr: Label '''%1'' is not a valid Quality Inspection Template. Please re-configure the available Quality Inspection Templates.', Comment = '%1=The template that was expected'; PleaseChooseARecordFirstErr: Label 'Choose which record you want to create a Quality Inspection for, then try again.'; NoLookupPageForSourceTableErr: Label 'The source configuration ''%1'' is mapped to table ''%2'', which has no list or lookup page available. Choose a different Source.', Comment = '%1=Source configuration code, %2=From Table caption'; trigger OnPreReport() var QltyInspectionTemplateHdr: Record "Qlty. Inspection Template Hdr."; begin if not QltyInspectionTemplateHdr.Get(QltInspectionTemplateToCreate) then Error(NotAValidQltyInspectionTemplateErr, QltInspectionTemplateToCreate); end; /// <summary> /// Initializes the preferred inspection template and infers a compatible source configuration for the request page. /// </summary> /// <param name="QltyInspectionTemplateCode">The inspection template code to select by default.</param> procedure InitializeReportParameters(QltyInspectionTemplateCode: Code[20]) var TempCompatibleQltyInspectionGenRule: Record "Qlty. Inspection Gen. Rule" temporary; begin QltInspectionTemplateToCreate := QltyInspectionTemplateCode; OnAfterInitializeCreateInspectionReportParameters(QltInspectionTemplateToCreate, SourceTable, CustomFilter, Target, TargetRecordRef, TempQltyInspectionHeader); if (QltyInspectionTemplateCode <> '') and (SourceTable = '') then begin QltyInspectSourceConfig.Reset(); if QltyInspecGenRuleMgmt.FindAllCompatibleGenerationRules(QltInspectionTemplateToCreate, TempCompatibleQltyInspectionGenRule) then begin QltyInspectSourceConfig.SetRange("To Type", QltyInspectSourceConfig."To Type"::Inspection); QltyInspectSourceConfig.SetRange(Enabled, true); if TempCompatibleQltyInspectionGenRule.FindSet() then repeat QltyInspectSourceConfig.SetRange("From Table No.", TempCompatibleQltyInspectionGenRule."Source Table No."); if QltyInspectSourceConfig.FindFirst() then SourceTable := QltyInspectSourceConfig.Code; until (TempCompatibleQltyInspectionGenRule.Next() = 0) or (SourceTable <> ''); if SourceTable = '' then begin QltyInspectSourceConfig.Reset(); QltyInspecGenRuleMgmt.SetFilterToApplicableTemplates(QltInspectionTemplateToCreate, QltyInspectSourceConfig); QltyInspectSourceConfig.SetRange(Enabled, true); if QltyInspectSourceConfig.FindFirst() then SourceTable := QltyInspectSourceConfig.Code; end; end; end; SetRequestPageControlVisibility(); end; /// <summary> /// Clears the selected source record and its derived filter values. /// </summary> local procedure ClearParameters() begin Clear(TempQltyInspectionHeader); Clear(CustomFilter); Clear(Target); end; /// <summary> /// Clears the record reference and its variant container. /// </summary> local procedure ClearVariables() begin Clear(TargetRecordRef); Clear(VariantForRecordRef); end; /// <summary> /// Makes the item-tracking and source-record controls visible on the request page. /// </summary> local procedure SetRequestPageControlVisibility() begin VisibleLotNo := true; VisibleSerialNo := true; VisiblePackageNo := true; VisibleGetRecord := true; end; /// <summary> /// Creates an inspection for the selected source record with the entered tracking and quantity values. /// </summary> local procedure CreateQltyInspection() var TempTrackingSpecification: Record "Tracking Specification" temporary; NullCheckRecordId: RecordId; Dummy3Variant: Variant; Dummy4Variant: Variant; begin if ((NullCheckRecordId = Target) or (Target.TableNo = 0)) then Error(PleaseChooseARecordFirstErr); TargetRecordRef := Target.GetRecord(); TargetRecordRef.SetRecFilter(); TargetRecordRef.FindFirst(); TempTrackingSpecification."Entry No." := 1; TempTrackingSpecification."Item No." := TempQltyInspectionHeader."Source Item No."; TempTrackingSpecification."Variant Code" := TempQltyInspectionHeader."Source Variant Code"; TempTrackingSpecification."Lot No." := TempQltyInspectionHeader."Source Lot No."; TempTrackingSpecification."Serial No." := TempQltyInspectionHeader."Source Serial No."; TempTrackingSpecification."Package No." := TempQltyInspectionHeader."Source Package No."; if DidChangeSourceQuantity then begin TempTrackingSpecification."Quantity (Base)" := TempQltyInspectionHeader."Source Quantity (Base)"; TempTrackingSpecification."Qty. to Handle (Base)" := TempQltyInspectionHeader."Source Quantity (Base)"; TempTrackingSpecification."Qty. to Handle" := TempQltyInspectionHeader."Source Quantity (Base)"; end; TempTrackingSpecification.Insert(false); QltyInspectionCreate.CreateInspectionWithMultiVariantsAndTemplate(TargetRecordRef, TempTrackingSpecification, Dummy3Variant, Dummy4Variant, true, QltInspectionTemplateToCreate); end; /// <summary> /// Opens the configured source table lookup and derives inspection source values from the selected record. /// </summary> local procedure AssistEditChooseRecord() var TempItemTrackingSetup: Record "Item Tracking Setup" temporary; TableMetadata: Record "Table Metadata"; QltyTraversal: Codeunit "Qlty. Traversal"; LookupPageId: Integer; begin if QltyInspectSourceConfig."From Table No." <> 0 then begin ClearVariables(); TargetRecordRef.Open(QltyInspectSourceConfig."From Table No."); TargetRecordRef.SetView(QltyInspectSourceConfig."From Table Filter"); if TableMetadata.Get(TargetRecordRef.Number) then LookupPageId := TableMetadata.LookupPageID; if LookupPageId = 0 then begin QltyInspectSourceConfig.CalcFields("From Table Caption"); TargetRecordRef.Close(); Error(NoLookupPageForSourceTableErr, QltyInspectSourceConfig.Code, QltyInspectSourceConfig."From Table Caption"); end; VariantForRecordRef := TargetRecordRef; if Page.RunModal(LookupPageId, VariantForRecordRef) = Action::LookupOK then begin ClearParameters(); TargetRecordRef := VariantForRecordRef; Target := TargetRecordRef.RecordId(); TempQltyInspectionHeader.SetIsCreating(true); if not QltyTraversal.ApplySourceFields(TargetRecordRef, TempQltyInspectionHeader, false, false) then Clear(TempQltyInspectionHeader); TempItemTrackingSetup."Lot No. Required" := true; TempItemTrackingSetup."Serial No. Required" := true; TempItemTrackingSetup."Package No. Required" := true; TempQltyInspectionHeader.IsItemTrackingUsed(TempItemTrackingSetup); EditLotNo := TempItemTrackingSetup."Lot No. Required"; EditSerialNo := TempItemTrackingSetup."Serial No. Required"; EditPackageNo := TempItemTrackingSetup."Package No. Required"; end; EditSourceQuantity := QltyPermissionMgmt.CanChangeSourceQuantity(); VisibleSourceQuantity := TempQltyInspectionHeader."Source Quantity (Base)" <> 0; TargetRecordRef.Close(); ClearVariables(); end; end; /// <summary> /// Allows subscribers to change the initial values used by the Create Inspection report. /// </summary> /// <param name="QltyInspectionTemplateCode">The default inspection template code.</param> /// <param name="SourceTable">The default source configuration code.</param> /// <param name="CustomFilter">The default custom source filter.</param> /// <param name="Target">The default source record identifier.</param> /// <param name="TargetRecordRef">The default source record reference.</param> /// <param name="TempQltyInspectionHeader">The temporary inspection header containing default source values.</param> [IntegrationEvent(false, false)] local procedure OnAfterInitializeCreateInspectionReportParameters(var QltyInspectionTemplateCode: Code[20]; var SourceTable: Code[20]; var CustomFilter: Text; var Target: RecordId; var TargetRecordRef: RecordRef; var TempQltyInspectionHeader: Record "Qlty. Inspection Header" temporary) begin end;}