Report 20505 Subc. Calculate Subcontracts
src/Apps/W1/Subcontracting/App/src/Purchase/SubcCalculateSubcontracts.Report.al373 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.Manufacturing.Subcontracting;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Foundation.UOM;using Microsoft.Inventory.Costing;using Microsoft.Inventory.Item;using Microsoft.Inventory.Item.Catalog;using Microsoft.Inventory.Requisition;using Microsoft.Manufacturing.Document;using Microsoft.Manufacturing.Setup;using Microsoft.Manufacturing.WorkCenter;using Microsoft.Purchases.Document;report 20505 "Subc. Calculate Subcontracts"{ ApplicationArea = Subcontracting; Caption = 'Calculate Subcontracts'; ProcessingOnly = true; dataset { dataitem("Work Center"; "Work Center") { DataItemTableView = sorting("No."); RequestFilterFields = "No.", "Subcontractor No."; dataitem("Prod. Order Routing Line"; "Prod. Order Routing Line") { DataItemLink = "No." = field("No."); DataItemTableView = sorting(Type, "No.") where(Status = const(Released), Type = const("Work Center"), "Routing Status" = filter(< Finished)); RequestFilterFields = "Prod. Order No.", "Starting Date"; trigger OnAfterGetRecord() begin TempProdOrderRoutingLine.Init(); TempProdOrderRoutingLine := "Prod. Order Routing Line"; TempProdOrderRoutingLine.Insert(); end; } trigger OnAfterGetRecord() begin if "Subcontractor No." = '' then CurrReport.Skip(); Window.Update(1, "No."); end; trigger OnPreDataItem() begin TempProdOrderRoutingLine.DeleteAll(); ReqLine.SetRange("Worksheet Template Name", ReqLine."Worksheet Template Name"); ReqLine.SetRange("Journal Batch Name", ReqLine."Journal Batch Name"); ReqLine.DeleteAll(); end; trigger OnPostDataItem() begin CalculateSubContractRequirements(); end; } } requestpage { layout { } actions { } } labels { } trigger OnInitReport() begin#if not CLEAN29#pragma warning disable AL0432 if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432 CurrReport.Quit();#endif MfgSetup.Get(); end; trigger OnPreReport() begin ReqWkshTmpl.Get(ReqLine."Worksheet Template Name"); ReqWkShName.Get(ReqLine."Worksheet Template Name", ReqLine."Journal Batch Name"); ReqLine.SetRange("Worksheet Template Name", ReqLine."Worksheet Template Name"); ReqLine.SetRange("Journal Batch Name", ReqLine."Journal Batch Name"); ReqLine.LockTable(); if ReqLine.FindLast() then ReqLine.Init(); Window.Open(ProcessingWorkCentersLbl + ProcessingOrdersLbl); end; var MfgSetup: Record "Manufacturing Setup"; ReqWkshTmpl: Record "Req. Wksh. Template"; ReqWkShName: Record "Requisition Wksh. Name"; ReqLine: Record "Requisition Line"; ProdOrderLine: Record "Prod. Order Line"; GLSetup: Record "General Ledger Setup"; PurchLine: Record "Purchase Line"; Item: Record Item; TempProdOrderRoutingLine: Record "Prod. Order Routing Line" temporary; MfgCostCalcMgt: Codeunit "Mfg. Cost Calculation Mgt.";#if not CLEAN29#pragma warning disable AL0432 SubcFeatureFlagHandler: Codeunit "Subc. Feature Flag Handler";#pragma warning restore AL0432#endif UOMMgt: Codeunit "Unit of Measure Management"; SubcontractingManagement: Codeunit "Subcontracting Management"; Window: Dialog; BaseQtyToPurch: Decimal; QtyToPurch: Decimal; GLSetupRead: Boolean; ProcessingWorkCentersLbl: Label 'Processing Work Centers #1##########\', Comment = '#1 = current work center number being processed'; ProcessingOrdersLbl: Label 'Processing Orders #2########## ', Comment = '#2 = current order number being processed'; procedure SetWkShLine(NewReqLine: Record "Requisition Line") begin#if not CLEAN29#pragma warning disable AL0432 if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432 exit;#endif ReqLine := NewReqLine; end; local procedure InsertReqWkshLine(ProdOrderRoutingLine: Record "Prod. Order Routing Line") var WorkCenter: Record "Work Center"; IsHandled: Boolean; begin IsHandled := false; if ProdOrderRoutingLine.Type = ProdOrderRoutingLine.Type::"Work Center" then WorkCenter.Get(ProdOrderRoutingLine."No."); OnBeforeInsertReqWkshLine(ProdOrderRoutingLine, WorkCenter, ReqLine, IsHandled, ProdOrderLine); if IsHandled then exit; if ProdOrderRoutingLine.Type = ProdOrderRoutingLine.Type::"Work Center" then SubcontractingManagement.CheckSubcontractingWorkCenter(ProdOrderRoutingLine."No."); ProdOrderLine.CalcFields("Total Exp. Oper. Output (Qty.)"); ReqLine.SetSubcontracting(true); ReqLine.BlockDynamicTracking(true); SubcontractingManagement.CheckProdNotBlockedForOutput(ProdOrderLine."Item No.", ProdOrderLine."Variant Code"); ReqLine.Init(); ReqLine."Line No." := ReqLine."Line No." + 10000; ReqLine.Validate(Type, ReqLine.Type::Item); ReqLine.Validate("No.", ProdOrderLine."Item No."); ReqLine.Validate("Variant Code", ProdOrderLine."Variant Code"); ReqLine.Validate("Unit of Measure Code", ProdOrderLine."Unit of Measure Code"); ReqLine.Validate(Quantity, QtyToPurch); GetGLSetup(); IsHandled := false; OnBeforeValidateUnitCost(ReqLine, WorkCenter, IsHandled, ProdOrderLine, ProdOrderRoutingLine); if not IsHandled then if ReqLine.Quantity <> 0 then begin if WorkCenter."Unit Cost Calculation" = WorkCenter."Unit Cost Calculation"::Units then ReqLine.Validate("Direct Unit Cost", Round( ProdOrderRoutingLine."Direct Unit Cost" * ProdOrderLine."Qty. per Unit of Measure", GLSetup."Unit-Amount Rounding Precision")) else ReqLine.Validate("Direct Unit Cost", Round( (ProdOrderRoutingLine."Expected Operation Cost Amt." - ProdOrderRoutingLine."Expected Capacity Ovhd. Cost") / ProdOrderLine."Total Exp. Oper. Output (Qty.)", GLSetup."Unit-Amount Rounding Precision")); end else ReqLine.Validate("Direct Unit Cost", 0); ReqLine."Qty. per Unit of Measure" := 0; ReqLine."Quantity (Base)" := 0; ReqLine."Qty. Rounding Precision" := ProdOrderLine."Qty. Rounding Precision"; ReqLine."Qty. Rounding Precision (Base)" := ProdOrderLine."Qty. Rounding Precision (Base)"; ReqLine."Prod. Order No." := ProdOrderLine."Prod. Order No."; ReqLine."Prod. Order Line No." := ProdOrderLine."Line No."; ReqLine."Due Date" := ProdOrderRoutingLine."Ending Date"; ReqLine."Requester ID" := CopyStr(UserId(), 1, 50); ReqLine."Location Code" := ProdOrderLine."Location Code"; ReqLine."Bin Code" := ProdOrderLine."Bin Code"; ReqLine."Routing Reference No." := ProdOrderRoutingLine."Routing Reference No."; ReqLine."Routing No." := ProdOrderRoutingLine."Routing No."; ReqLine."Operation No." := ProdOrderRoutingLine."Operation No."; ReqLine."Work Center No." := ProdOrderRoutingLine."Work Center No."; ReqLine.Validate("Vendor No.", WorkCenter."Subcontractor No."); SubcontractingManagement.SetSubcontractingOrderDate(ReqLine, ProdOrderRoutingLine."Starting Date"); ReqLine.Description := ProdOrderRoutingLine.Description; ReqLine."Description 2" := ProdOrderRoutingLine."Description 2"; SetVendorItemNo(); OnAfterTransferProdOrderRoutingLine(ReqLine, ProdOrderRoutingLine); // If purchase order already exist we will change this if possible PurchLine.Reset(); PurchLine.SetCurrentKey("Prod. Order No.", "Prod. Order Line No.", "Routing No.", "Operation No."); PurchLine.SetRange("Prod. Order No.", ProdOrderLine."Prod. Order No."); PurchLine.SetRange("Prod. Order Line No.", ProdOrderLine."Line No."); PurchLine.SetRange("Routing No.", ProdOrderRoutingLine."Routing No."); PurchLine.SetRange("Operation No.", ProdOrderRoutingLine."Operation No."); PurchLine.SetRange("Document Type", PurchLine."Document Type"::Order); PurchLine.SetRange(Type, PurchLine.Type::Item); PurchLine.SetRange("Planning Flexibility", PurchLine."Planning Flexibility"::Unlimited); PurchLine.SetRange("Quantity Received", 0); if PurchLine.FindFirst() then begin ReqLine.Validate(Quantity, ReqLine.Quantity + PurchLine."Outstanding Quantity"); ReqLine."Quantity (Base)" := 0; ReqLine."Replenishment System" := ReqLine."Replenishment System"::Purchase; ReqLine."Ref. Order No." := PurchLine."Document No."; ReqLine."Ref. Order Type" := ReqLine."Ref. Order Type"::Purchase; ReqLine."Ref. Line No." := PurchLine."Line No."; if PurchLine."Expected Receipt Date" = ReqLine."Due Date" then ReqLine."Action Message" := ReqLine."Action Message"::"Change Qty." else ReqLine."Action Message" := ReqLine."Action Message"::"Resched. & Chg. Qty."; ReqLine."Accept Action Message" := true; end else begin ReqLine."Replenishment System" := ReqLine."Replenishment System"::"Prod. Order"; ReqLine."Ref. Order No." := ProdOrderLine."Prod. Order No."; ReqLine."Ref. Order Type" := ReqLine."Ref. Order Type"::"Prod. Order"; ReqLine."Ref. Order Status" := ProdOrderLine.Status; ReqLine."Ref. Line No." := ProdOrderLine."Line No."; ReqLine."Action Message" := ReqLine."Action Message"::New; ReqLine."Accept Action Message" := true; end; if ReqLine."Ref. Order No." <> '' then ReqLine.GetDimFromRefOrderLine(true); OnBeforeReqWkshLineInsert(ReqLine, ProdOrderLine); ReqLine.Insert(); end; local procedure GetGLSetup() begin if not GLSetupRead then GLSetup.Get(); GLSetupRead := true; end; local procedure DeleteRepeatedReqLines(ProdOrderRoutingLine: Record "Prod. Order Routing Line") var RequisitionLine: Record "Requisition Line"; begin RequisitionLine.SetRange(Type, RequisitionLine.Type::Item); RequisitionLine.SetRange("No.", ProdOrderLine."Item No."); RequisitionLine.SetRange("Prod. Order No.", ProdOrderLine."Prod. Order No."); RequisitionLine.SetRange("Prod. Order Line No.", ProdOrderLine."Line No."); RequisitionLine.SetRange("Operation No.", ProdOrderRoutingLine."Operation No."); OnDeleteRepeatedReqLinesOnAfterRequisitionLineSetFilters(RequisitionLine, ProdOrderLine, ProdOrderRoutingLine); RequisitionLine.DeleteAll(true); end; local procedure SetVendorItemNo() var ItemVendor: Record "Item Vendor"; begin if ReqLine."No." = '' then exit; if Item."No." <> ReqLine."No." then begin Item.SetLoadFields("No."); Item.Get(ReqLine."No."); end; ItemVendor.Init(); ItemVendor."Vendor No." := ReqLine."Vendor No."; ItemVendor."Variant Code" := ReqLine."Variant Code"; Item.FindItemVend(ItemVendor, ReqLine."Location Code"); ReqLine.Validate("Vendor Item No.", ItemVendor."Vendor Item No."); OnAfterSetVendorItemNo(ReqLine, ItemVendor, Item); end; local procedure CalculateSubContractRequirements() begin OnProdOrderRoutingLineOnBeforeCalculateSubContractRequirements(TempProdOrderRoutingLine); if TempProdOrderRoutingLine.IsEmpty() then exit; TempProdOrderRoutingLine.SetCurrentKey("Prod. Order No.", "Routing Reference No.", Status, "Routing No.", "Operation No."); if TempProdOrderRoutingLine.FindSet() then repeat Window.Update(2, TempProdOrderRoutingLine."Prod. Order No."); ProdOrderLine.SetCurrentKey(Status, "Prod. Order No.", "Routing No.", "Routing Reference No."); ProdOrderLine.SetRange(Status, TempProdOrderRoutingLine.Status); ProdOrderLine.SetRange("Prod. Order No.", TempProdOrderRoutingLine."Prod. Order No."); ProdOrderLine.SetRange("Routing No.", TempProdOrderRoutingLine."Routing No."); ProdOrderLine.SetRange("Routing Reference No.", TempProdOrderRoutingLine."Routing Reference No."); OnProdOrderRoutingLineOnAfterGetRecordOnAfterProdOrderLineSetFilters(ProdOrderLine, TempProdOrderRoutingLine); if ProdOrderLine.FindSet() then begin DeleteRepeatedReqLines(TempProdOrderRoutingLine); repeat BaseQtyToPurch := MfgCostCalcMgt.CalcQtyAdjdForRoutingScrap( MfgCostCalcMgt.CalcQtyAdjdForBOMScrap( ProdOrderLine."Quantity (Base)", ProdOrderLine."Scrap %"), TempProdOrderRoutingLine."Scrap Factor % (Accumulated)", TempProdOrderRoutingLine."Fixed Scrap Qty. (Accum.)") - (MfgCostCalcMgt.CalcOutputQtyBaseOnPurchOrder(ProdOrderLine, TempProdOrderRoutingLine) + MfgCostCalcMgt.CalcActOutputQtyBase(ProdOrderLine, TempProdOrderRoutingLine)); QtyToPurch := Round(BaseQtyToPurch / ProdOrderLine."Qty. per Unit of Measure", UOMMgt.QtyRndPrecision()); OnAfterCalcQtyToPurch(ProdOrderLine, QtyToPurch); if QtyToPurch > 0 then InsertReqWkshLine(TempProdOrderRoutingLine); until ProdOrderLine.Next() = 0; end; until TempProdOrderRoutingLine.Next() = 0; end; [IntegrationEvent(false, false)] local procedure OnAfterCalcQtyToPurch(ProdOrderLine: Record "Prod. Order Line"; var QtyToPurch: Decimal) begin end; [IntegrationEvent(false, false)] local procedure OnAfterTransferProdOrderRoutingLine(var RequisitionLine: Record "Requisition Line"; ProdOrderRoutingLine: Record "Prod. Order Routing Line") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeInsertReqWkshLine(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; var WorkCenter: Record "Work Center"; var ReqLine: Record "Requisition Line"; var IsHandled: Boolean; ProdOrderLine: Record "Prod. Order Line"); begin end; [IntegrationEvent(false, false)] local procedure OnBeforeValidateUnitCost(var RequisitionLine: Record "Requisition Line"; var WorkCenter: Record "Work Center"; var IsHandled: Boolean; ProdOrderLine: Record "Prod. Order Line"; ProdOrderRoutingLine: Record "Prod. Order Routing Line") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeReqWkshLineInsert(var RequisitionLine: Record "Requisition Line"; ProdOrderLine: Record "Prod. Order Line") begin end; [IntegrationEvent(false, false)] local procedure OnDeleteRepeatedReqLinesOnAfterRequisitionLineSetFilters(var RequisitionLine: Record "Requisition Line"; ProdOrderLine: Record "Prod. Order Line"; ProdOrderRoutingLine: Record "Prod. Order Routing Line") begin end; [IntegrationEvent(false, false)] local procedure OnProdOrderRoutingLineOnAfterGetRecordOnAfterProdOrderLineSetFilters(var ProdOrderLine: Record "Prod. Order Line"; ProdOrderRoutingLine: Record "Prod. Order Routing Line") begin end; [IntegrationEvent(false, false)] local procedure OnAfterSetVendorItemNo(var RequisitionLine: Record "Requisition Line"; ItemVendor: Record "Item Vendor"; Item: Record Item) begin end; [IntegrationEvent(false, false)] local procedure OnProdOrderRoutingLineOnBeforeCalculateSubContractRequirements(var TempProdOrderRoutingLine: Record "Prod. Order Routing Line" temporary) begin end;}