Codeunit 20560 Subc. Purch. Factbox Mgmt.
src/Apps/W1/Subcontracting/App/src/Purchase/SubcPurchFactboxMgmt.Codeunit.al687 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.Inventory.Ledger;using Microsoft.Inventory.Transfer;using Microsoft.Manufacturing.Capacity;using Microsoft.Manufacturing.Document;using Microsoft.Purchases.Document;using Microsoft.Purchases.History;using Microsoft.Utilities;using System.Reflection;using System.Text;codeunit 20560 "Subc. Purch. Factbox Mgmt."{ var#if not CLEAN29#pragma warning disable AL0432 SubcFeatureFlagHandler: Codeunit "Subc. Feature Flag Handler";#pragma warning restore AL0432#endif MultipleLbl: Label 'Multiple', MaxLength = 20; NoTransferExistsMsg: Label 'No transfer order exists for this purchase order.'; /// <summary> /// Opens the Purchase Order page for the subcontracting purchase order linked to the given variant record. /// </summary> /// <param name="RecRelatedVariant">A record variant of a related document line (Purchase Line, Transfer Line, ledger entry, etc.).</param> procedure ShowPurchaseOrder(RecRelatedVariant: Variant) var PurchaseHeader: Record "Purchase Header"; PageManagement: Codeunit "Page Management"; PurchOrderNo: Code[20]; PurchOrderLineNo: Integer; begin#if not CLEAN29#pragma warning disable AL0432 if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432 exit;#endif if not GetPurchaseOrderNoByVariant(RecRelatedVariant, PurchOrderNo, PurchOrderLineNo) then exit; PurchaseHeader.Reset(); PurchaseHeader.SetRange("Document Type", PurchaseHeader."Document Type"::Order); PurchaseHeader.SetRange("No.", PurchOrderNo); PageManagement.PageRun(PurchaseHeader); end; /// <summary> /// Returns the number of subcontracting transfer order lines linked to the given variant record. /// </summary> /// <param name="RecRelatedVariant">A record variant of a related document line.</param> /// <returns>The count of matching transfer lines, or 0 if no purchase order is found.</returns> procedure CalcNoOfTransferOrders(RecRelatedVariant: Variant): Integer var TransferLine: Record "Transfer Line"; PurchOrderNo: Code[20]; PurchOrderLineNo: Integer; begin#if not CLEAN29#pragma warning disable AL0432 if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432 exit(0);#endif if not GetPurchaseOrderNoByVariant(RecRelatedVariant, PurchOrderNo, PurchOrderLineNo) then exit(0); TransferLine.SetCurrentKey("Subc. Purch. Order No."); TransferLine.SetRange("Subc. Purch. Order No.", PurchOrderNo); TransferLine.SetRange("Subc. Purch. Order Line No.", PurchOrderLineNo); exit(TransferLine.Count()); end; /// <summary> /// Returns the transfer order document number linked to the given variant record, or 'Multiple' if more than one exists. /// </summary> /// <param name="RecRelatedVariant">A record variant of a related document line.</param> /// <returns>The transfer order document number, 'Multiple' if more than one exists, or an empty string if none.</returns> procedure GetTransferOrderNo(RecRelatedVariant: Variant): Code[20] var TransferLine: Record "Transfer Line"; PurchOrderNo: Code[20]; NoOfTransferOrders: Integer; PurchOrderLineNo: Integer; begin#if not CLEAN29#pragma warning disable AL0432 if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432 exit('');#endif if not GetPurchaseOrderNoByVariant(RecRelatedVariant, PurchOrderNo, PurchOrderLineNo) then exit(''); NoOfTransferOrders := GetNoOfTransferOrders(RecRelatedVariant); case NoOfTransferOrders of 0: exit(''); 1: begin FilterTransferLineToSubcontractorPurchaseOrder(PurchOrderNo, PurchOrderLineNo, TransferLine); TransferLine.SetLoadFields(SystemId); TransferLine.FindFirst(); exit(TransferLine."Document No."); end; else exit(MultipleLbl); end; end; /// <summary> /// Returns the return transfer order document number linked to the given variant record. /// </summary> /// <param name="RecRelatedVariant">A record variant of a related document line.</param> /// <returns>The return transfer order document number, or an empty string if none exists.</returns> procedure GetReturnTransferOrderNo(RecRelatedVariant: Variant): Code[20] var TransferLine: Record "Transfer Line"; PurchOrderNo: Code[20]; PurchOrderLineNo: Integer; begin#if not CLEAN29#pragma warning disable AL0432 if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432 exit('');#endif if not GetPurchaseOrderNoByVariant(RecRelatedVariant, PurchOrderNo, PurchOrderLineNo) then exit(''); TransferLine.SetCurrentKey("Subc. Purch. Order No."); TransferLine.SetRange("Subc. Purch. Order No.", PurchOrderNo); TransferLine.SetRange("Subc. Purch. Order Line No.", PurchOrderLineNo); TransferLine.SetRange("Subc. Return Order", true); TransferLine.SetRange("Derived From Line No.", 0); TransferLine.SetLoadFields(SystemId); if TransferLine.IsEmpty() then exit(''); TransferLine.FindFirst(); exit(TransferLine."Document No."); end; /// <summary> /// Returns the number of distinct transfer orders (by document number) linked to the subcontracting purchase order for the given variant record. /// </summary> /// <param name="RecRelatedVariant">A record variant of a related document line.</param> /// <returns>The count of distinct transfer order header numbers, or 0 if none found.</returns> procedure GetNoOfTransferOrders(RecRelatedVariant: Variant) NoOfTransferOrders: Integer var TransferLine: Record "Transfer Line"; ListOfTransferHeaderNo: List of [Code[20]]; PurchOrderNo: Code[20]; PurchOrderLineNo: Integer; begin#if not CLEAN29#pragma warning disable AL0432 if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432 exit(0);#endif if not GetPurchaseOrderNoByVariant(RecRelatedVariant, PurchOrderNo, PurchOrderLineNo) then exit(0); FilterTransferLineToSubcontractorPurchaseOrder(PurchOrderNo, PurchOrderLineNo, TransferLine); if not TransferLine.FindSet() then exit(0); repeat if not ListOfTransferHeaderNo.Contains(TransferLine."Document No.") then ListOfTransferHeaderNo.Add(TransferLine."Document No."); until TransferLine.Next() = 0; NoOfTransferOrders := ListOfTransferHeaderNo.Count(); exit(NoOfTransferOrders); end; /// <summary> /// Finds the transfer order number linked to the purchase or receipt document in the given variant record. /// </summary> /// <param name="RecRelatedVariant">A record variant of a Purchase Line, Purch. Rcpt. Line, or Purch. Inv. Line.</param> /// <param name="TransferOrderNo">Returns the transfer order document number if found.</param> /// <returns>True if a matching transfer line was found; otherwise false.</returns> procedure GetTransferOrderNoByVariant(RecRelatedVariant: Variant; var TransferOrderNo: Code[20]): Boolean var PurchaseLine: Record "Purchase Line"; PurchInvLine: Record "Purch. Inv. Line"; PurchRcptLine: Record "Purch. Rcpt. Line"; TransferLine: Record "Transfer Line"; DataTypeManagement: Codeunit "Data Type Management"; ResultRecordRef: RecordRef; RecId: RecordId; ProdOperation: Code[10]; ProdOrderNo: Code[20]; PurchOrderNo: Code[20]; ProdOrderLineNo: Integer; begin#if not CLEAN29#pragma warning disable AL0432 if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432 exit(false);#endif if not RecRelatedVariant.IsRecord() then exit(false); DataTypeManagement.GetRecordRef(RecRelatedVariant, ResultRecordRef); RecId := ResultRecordRef.RecordId(); if RecId.TableNo() = 0 then exit(false); case RecId.TableNo() of Database::"Purchase Line": begin ResultRecordRef.SetTable(PurchaseLine); PurchOrderNo := PurchaseLine."Document No."; ProdOrderNo := PurchaseLine."Prod. Order No."; ProdOrderLineNo := PurchaseLine."Prod. Order Line No."; ProdOperation := PurchaseLine."Operation No."; end; Database::"Purch. Rcpt. Line": begin ResultRecordRef.SetTable(PurchRcptLine); PurchOrderNo := PurchRcptLine."Document No."; ProdOrderNo := PurchRcptLine."Prod. Order No."; ProdOrderLineNo := PurchRcptLine."Prod. Order Line No."; ProdOperation := PurchRcptLine."Operation No."; end; Database::"Purch. Inv. Line": begin ResultRecordRef.SetTable(PurchInvLine); PurchOrderNo := PurchInvLine."Document No."; ProdOrderNo := PurchInvLine."Prod. Order No."; ProdOrderLineNo := PurchInvLine."Prod. Order Line No."; ProdOperation := PurchInvLine."Operation No."; end; end; TransferLine.SetCurrentKey("Subc. Purch. Order No.", "Subc. Prod. Order No.", "Subc. Prod. Order Line No.", "Subc. Operation No."); TransferLine.SetRange("Subc. Purch. Order No.", PurchOrderNo); TransferLine.SetRange("Subc. Prod. Order No.", ProdOrderNo); TransferLine.SetRange("Subc. Prod. Order Line No.", ProdOrderLineNo); TransferLine.SetRange("Subc. Operation No.", ProdOperation); if not TransferLine.IsEmpty() then begin TransferLine.SetLoadFields(SystemId); TransferLine.FindFirst(); TransferOrderNo := TransferLine."Document No."; exit(TransferOrderNo <> ''); end; end; /// <summary> /// Shows the transfer order(s) or return transfer order linked to the given variant record. /// </summary> /// <param name="RecRelatedVariant">A record variant of a Prod. Order Component, Purchase Line, or Prod. Order Routing Line.</param> /// <param name="LookUpPage">When true, opens the transfer order page; when false, only populates the temp table.</param> /// <param name="IsReturn">When true, filters to return transfer orders; when false, filters to outbound transfer orders.</param> /// <returns>The number of transfer lines linked to the given record.</returns> procedure ShowTransferOrdersAndReturnOrder(RecRelatedVariant: Variant; LookUpPage: Boolean; IsReturn: Boolean): Integer var ProdOrderComponent: Record "Prod. Order Component"; ProdOrderLine: Record "Prod. Order Line"; ProdOrderRoutingLine: Record "Prod. Order Routing Line"; ProductionOrder: Record "Production Order"; PurchaseLine: Record "Purchase Line"; TransferHeader: Record "Transfer Header"; TransferHeaderToOpen: Record "Transfer Header"; TransferLine: Record "Transfer Line"; DataTypeManagement: Codeunit "Data Type Management"; PageManagement: Codeunit "Page Management"; SelectionFilterMgt: Codeunit SelectionFilterManagement; RecRef: RecordRef; NoOfTransferHeaders: Integer; begin#if not CLEAN29#pragma warning disable AL0432 if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432 exit(0);#endif if not RecRelatedVariant.IsRecord() then exit(0); DataTypeManagement.GetRecordRef(RecRelatedVariant, RecRef); ProductionOrder.SetLoadFields("No.", "Source Type"); case RecRef.Number() of Database::"Prod. Order Component": begin RecRef.SetTable(ProdOrderComponent); if not ProductionOrder.Get(ProdOrderComponent.Status, ProdOrderComponent."Prod. Order No.") then exit(0); if not ProdOrderLine.Get(ProdOrderComponent.Status, ProdOrderComponent."Prod. Order No.", ProdOrderComponent."Prod. Order Line No.") then exit(0); GetProdOrderRtngLineFromProdOrderComp(ProdOrderRoutingLine, ProdOrderComponent); end; Database::"Purchase Line": begin RecRef.SetTable(PurchaseLine); if not ProductionOrder.Get("Production Order Status"::Released, PurchaseLine."Prod. Order No.") then exit(0); GetProdOrderRtngLineFromPurchaseLine(ProdOrderRoutingLine, PurchaseLine); if ProductionOrder."Source Type" <> "Prod. Order Source Type"::Family then if not ProdOrderLine.Get(ProdOrderRoutingLine.Status, PurchaseLine."Prod. Order No.", PurchaseLine."Prod. Order Line No.") then exit(0); end; Database::"Prod. Order Routing Line": begin RecRef.SetTable(ProdOrderRoutingLine); if not ProductionOrder.Get(ProdOrderRoutingLine.Status, ProdOrderRoutingLine."Prod. Order No.") then exit(0); if ProductionOrder."Source Type" <> "Prod. Order Source Type"::Family then if not ProdOrderLine.Get(ProdOrderRoutingLine.Status, ProdOrderRoutingLine."Prod. Order No.", ProdOrderRoutingLine."Routing Reference No.") then exit(0); end; else exit(0); end; TransferLine.SetCurrentKey("Subc. Prod. Order No.", "Subc. Prod. Order Line No.", "Subc. Routing Reference No.", "Subc. Routing No.", "Subc. Operation No."); TransferLine.SetRange("Subc. Prod. Order No.", ProductionOrder."No."); if ProductionOrder."Source Type" <> "Prod. Order Source Type"::Family then begin TransferLine.SetRange("Subc. Prod. Order Line No.", ProdOrderLine."Line No."); TransferLine.SetRange("Subc. Routing Reference No.", ProdOrderLine."Routing Reference No."); end else begin TransferLine.SetRange("Subc. Prod. Order Line No."); TransferLine.SetRange("Subc. Routing Reference No.", ProdOrderRoutingLine."Routing Reference No."); end; TransferLine.SetRange("Subc. Return Order", IsReturn); TransferLine.SetRange("Subc. Routing No.", ProdOrderRoutingLine."Routing No."); TransferLine.SetRange("Subc. Operation No.", ProdOrderRoutingLine."Operation No."); TransferLine.SetRange("Derived From Line No.", 0); if not LookUpPage then exit(TransferLine.Count()); if not TransferLine.IsEmpty() then if TransferLine.FindSet() then repeat if TransferHeader.Get(TransferLine."Document No.") then TransferHeader.Mark(true); until TransferLine.Next() = 0; TransferHeader.MarkedOnly(true); if LookUpPage then begin NoOfTransferHeaders := TransferHeader.Count(); case true of NoOfTransferHeaders = 0: Message(NoTransferExistsMsg); NoOfTransferHeaders = 1: if TransferHeader.FindFirst() then begin TransferHeaderToOpen.Get(TransferHeader."No."); PageManagement.PageRun(TransferHeaderToOpen); end; NoOfTransferHeaders > 1: begin // As we do not expect more than a handful tranfer orders linked to the purchase order, there is no need to // add extra processing if the number of records linked are more than allowed. TransferHeaderToOpen.SetFilter("No.", SelectionFilterMgt.GetSelectionFilterForTransferHeader(TransferHeader)); PageManagement.PageRunList(TransferHeaderToOpen); end; end; end; end; /// <summary> /// Opens the subcontracting transfer order(s) linked to the given production order. /// </summary> /// <param name="ProductionOrder">The production order to show the related subcontracting transfer orders for.</param> procedure ShowTransferOrdersFromProductionOrder(ProductionOrder: Record "Production Order") var TransferHeader: Record "Transfer Header"; TransferHeaderToOpen: Record "Transfer Header"; TransferLine: Record "Transfer Line"; PageManagement: Codeunit "Page Management"; SelectionFilterMgt: Codeunit SelectionFilterManagement; begin#if not CLEAN29#pragma warning disable AL0432 if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432 exit;#endif TransferLine.SetCurrentKey("Subc. Prod. Order No.", "Subc. Prod. Order Line No.", "Subc. Routing Reference No.", "Subc. Routing No.", "Subc. Operation No."); TransferLine.SetRange("Subc. Prod. Order No.", ProductionOrder."No."); TransferLine.SetRange("Derived From Line No.", 0); if TransferLine.FindSet() then repeat if TransferHeader.Get(TransferLine."Document No.") then TransferHeader.Mark(true); until TransferLine.Next() = 0; TransferHeader.MarkedOnly(true); if TransferHeader.IsEmpty() then TransferHeaderToOpen.SetRange("No.", '') else TransferHeaderToOpen.SetFilter("No.", SelectionFilterMgt.GetSelectionFilterForTransferHeader(TransferHeader)); PageManagement.PageRunList(TransferHeaderToOpen); end; /// <summary> /// Opens the subcontracting transfer order(s) linked to the given purchase order. /// </summary> /// <param name="PurchaseHeader">The purchase order to show the related subcontracting transfer orders for.</param> /// <param name="IsReturn">When true, filters to return transfer orders; when false, filters to outbound transfer orders.</param> procedure ShowTransferOrdersFromPurchaseOrder(PurchaseHeader: Record "Purchase Header"; IsReturn: Boolean) var SelectedTransferHeader: Record "Transfer Header"; TransferHeader: Record "Transfer Header"; TransferLine: Record "Transfer Line"; PageManagement: Codeunit "Page Management"; SelectionFilterMgt: Codeunit SelectionFilterManagement; begin#if not CLEAN29#pragma warning disable AL0432 if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432 exit;#endif if IsReturn then begin TransferLine.SetRange("Subc. Purch. Order No.", PurchaseHeader."No."); TransferLine.SetRange("Subc. Return Order", true); TransferLine.SetRange("Derived From Line No.", 0); if TransferLine.FindSet() then repeat if SelectedTransferHeader.Get(TransferLine."Document No.") then SelectedTransferHeader.Mark(true); until TransferLine.Next() = 0; SelectedTransferHeader.MarkedOnly(true); if SelectedTransferHeader.IsEmpty() then TransferHeader.SetRange("No.", '') else TransferHeader.SetFilter("No.", SelectionFilterMgt.GetSelectionFilterForTransferHeader(SelectedTransferHeader)); end else begin TransferHeader.SetRange("Subcontr. Purch. Order No.", PurchaseHeader."No."); TransferHeader.SetRange("Subc. Return Order", IsReturn); end; if TransferHeader.Count() = 1 then begin TransferHeader.FindFirst(); PageManagement.PageRun(TransferHeader); end else PageManagement.PageRunList(TransferHeader); end; /// <summary> /// Returns the number of subcontractor prices matching the given purchase line. /// </summary> /// <param name="PurchaseLine">The purchase line to match subcontractor prices against.</param> /// <returns>The count of matching subcontractor price entries, or 0 if the line is not an item line.</returns> procedure CalcNoOfPurchasePrices(var PurchaseLine: Record "Purchase Line"): Integer begin#if not CLEAN29#pragma warning disable AL0432 if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432 exit(0);#endif if IsItemLine(PurchaseLine) then exit(CountPriceOnPurchItemLine(PurchaseLine)); end; /// <summary> /// Opens the Subcontractor Prices page filtered to the subcontractor prices matching the given purchase line. /// </summary> /// <param name="PurchaseLine">The purchase line used to filter subcontractor prices.</param> procedure ShowSubcontractorPrices(PurchaseLine: Record "Purchase Line") var SubcontractorPrice: Record "Subcontractor Price"; begin#if not CLEAN29#pragma warning disable AL0432 if not SubcFeatureFlagHandler.IsSubcontractingEnabled() then#pragma warning restore AL0432 exit;#endif FilterSubContractorPriceForPurchLine(SubcontractorPrice, PurchaseLine); Page.Run(Page::"Subcontractor Prices", SubcontractorPrice); end; local procedure GetPurchaseOrderNoByVariant(RecRelatedVariant: Variant; var PurchOrderNo: Code[20]; var PurchOrderLineNo: Integer): Boolean var CapacityLedgerEntry: Record "Capacity Ledger Entry"; ItemLedgerEntry: Record "Item Ledger Entry"; ProdOrderComponent: Record "Prod. Order Component"; ProdOrderRoutingLine: Record "Prod. Order Routing Line"; PurchaseLine: Record "Purchase Line"; PurchInvLine: Record "Purch. Inv. Line"; PurchRcptLine: Record "Purch. Rcpt. Line"; TransferLine: Record "Transfer Line"; TransferReceiptLine: Record "Transfer Receipt Line"; TransferShipmentLine: Record "Transfer Shipment Line"; DataTypeManagement: Codeunit "Data Type Management"; ResultRecordRef: RecordRef; RecId: RecordId; begin if not RecRelatedVariant.IsRecord() then exit(false); DataTypeManagement.GetRecordRef(RecRelatedVariant, ResultRecordRef); RecId := ResultRecordRef.RecordId(); if RecId.TableNo() = 0 then exit(false); case RecId.TableNo() of Database::"Purchase Line": begin ResultRecordRef.SetTable(PurchaseLine); PurchOrderNo := PurchaseLine."Document No."; PurchOrderLineNo := PurchaseLine."Line No."; end; Database::"Purch. Rcpt. Line": begin ResultRecordRef.SetTable(PurchRcptLine); PurchOrderNo := PurchRcptLine."Order No."; PurchOrderLineNo := PurchRcptLine."Order Line No."; end; Database::"Purch. Inv. Line": begin ResultRecordRef.SetTable(PurchInvLine); PurchOrderNo := PurchInvLine."Order No."; PurchOrderLineNo := PurchInvLine."Order Line No."; end; Database::"Transfer Line": begin ResultRecordRef.SetTable(TransferLine); PurchOrderNo := TransferLine."Subc. Purch. Order No."; PurchOrderLineNo := TransferLine."Subc. Purch. Order Line No."; end; Database::"Transfer Shipment Line": begin ResultRecordRef.SetTable(TransferShipmentLine); PurchOrderNo := TransferShipmentLine."Subc. Purch. Order No."; PurchOrderLineNo := TransferShipmentLine."Subc. Purch. Order Line No."; end; Database::"Transfer Receipt Line": begin ResultRecordRef.SetTable(TransferReceiptLine); PurchOrderNo := TransferReceiptLine."Subc. Purch. Order No."; PurchOrderLineNo := TransferReceiptLine."Subc. Purch. Order Line No."; end; Database::"Item Ledger Entry": begin ResultRecordRef.SetTable(ItemLedgerEntry); PurchOrderNo := ItemLedgerEntry."Subc. Purch. Order No."; PurchOrderLineNo := ItemLedgerEntry."Subc. Purch. Order Line No."; end; Database::"Capacity Ledger Entry": begin ResultRecordRef.SetTable(CapacityLedgerEntry); PurchOrderNo := CapacityLedgerEntry."Subc. Purch. Order No."; PurchOrderLineNo := CapacityLedgerEntry."Subc. Purch. Order Line No."; end; Database::"Prod. Order Routing Line": begin ResultRecordRef.SetTable(ProdOrderRoutingLine); GetPurchOrderFromProdOrderRtngLine(ProdOrderRoutingLine, PurchOrderNo, PurchOrderLineNo); end; Database::"Prod. Order Component": begin ResultRecordRef.SetTable(ProdOrderComponent); if ProdOrderComponent."Routing Link Code" <> '' then GetPurchOrderFromProdOrderComp(ProdOrderComponent, PurchOrderNo, PurchOrderLineNo); end; end; exit(PurchOrderNo <> ''); end; local procedure GetPurchOrderFromProdOrderRtngLine(ProdOrderRoutingLine: Record "Prod. Order Routing Line"; var PurchOrderNo: Code[20]; var PurchOrderLineNo: Integer) var PurchaseLine: Record "Purchase Line"; begin PurchaseLine.SetCurrentKey("Document Type", Type, "Prod. Order No.", "Prod. Order Line No."); PurchaseLine.SetRange("Document Type", PurchaseLine."Document Type"::Order); PurchaseLine.SetRange("Prod. Order No.", ProdOrderRoutingLine."Prod. Order No."); PurchaseLine.SetRange("Prod. Order Line No.", ProdOrderRoutingLine."Routing Reference No."); if PurchaseLine.IsEmpty() then exit; PurchaseLine.FindFirst(); PurchOrderNo := PurchaseLine."Document No."; PurchOrderLineNo := PurchaseLine."Line No."; end; local procedure GetPurchOrderFromProdOrderComp(ProdOrderComponent: Record "Prod. Order Component"; var PurchOrderNo: Code[20]; var PurchOrderLineNo: Integer) var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; PurchaseLine: Record "Purchase Line"; begin GetProdOrderRtngLineFromProdOrderComp(ProdOrderRoutingLine, ProdOrderComponent); PurchaseLine.SetCurrentKey("Document Type", Type, "Prod. Order No.", "Prod. Order Line No."); PurchaseLine.SetRange("Document Type", PurchaseLine."Document Type"::Order); PurchaseLine.SetRange("Prod. Order No.", ProdOrderComponent."Prod. Order No."); PurchaseLine.SetRange("Prod. Order Line No.", ProdOrderComponent."Prod. Order Line No."); PurchaseLine.SetRange("Operation No.", ProdOrderRoutingLine."Operation No."); if PurchaseLine.IsEmpty() then exit; PurchaseLine.FindFirst(); PurchOrderNo := PurchaseLine."Document No."; PurchOrderLineNo := PurchaseLine."Line No."; end; local procedure GetProdOrderRtngLineFromProdOrderComp(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; ProdOrderComponent: Record "Prod. Order Component") var ProdOrderLine: Record "Prod. Order Line"; begin if not ProdOrderLine.Get(ProdOrderComponent.Status, ProdOrderComponent."Prod. Order No.", ProdOrderComponent."Prod. Order Line No.") then exit; ProdOrderRoutingLine.SetRange(Status, ProdOrderLine.Status); ProdOrderRoutingLine.SetRange("Prod. Order No.", ProdOrderLine."Prod. Order No."); ProdOrderRoutingLine.SetRange("Routing Reference No.", ProdOrderLine."Routing Reference No."); ProdOrderRoutingLine.SetRange("Routing Link Code", ProdOrderComponent."Routing Link Code"); if ProdOrderRoutingLine.IsEmpty() then exit; ProdOrderRoutingLine.FindFirst(); end; local procedure GetProdOrderRtngLineFromPurchaseLine(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; PurchaseLine: Record "Purchase Line") begin ProdOrderRoutingLine.SetCurrentKey(Status, "Prod. Order No.", "Routing Reference No.", "Routing No.", "Operation No."); ProdOrderRoutingLine.SetRange("Prod. Order No.", PurchaseLine."Prod. Order No."); ProdOrderRoutingLine.SetRange("Routing Reference No.", PurchaseLine."Routing Reference No."); ProdOrderRoutingLine.SetRange("Routing No.", PurchaseLine."Routing No."); ProdOrderRoutingLine.SetRange("Operation No.", PurchaseLine."Operation No."); if ProdOrderRoutingLine.IsEmpty() then exit; ProdOrderRoutingLine.FindFirst(); end; local procedure CountPriceOnPurchItemLine(PurchaseLine: Record "Purchase Line"): Decimal var SubcontractorPrice: Record "Subcontractor Price"; begin FilterSubContractorPriceForPurchLine(SubcontractorPrice, PurchaseLine); exit(SubcontractorPrice.Count()); end; local procedure IsItemLine(PurchaseLine: Record "Purchase Line"): Boolean begin if (PurchaseLine.Type <> PurchaseLine.Type::Item) or (PurchaseLine."No." = '') then exit(false); exit(true); end; local procedure FilterSubContractorPriceForPurchLine(var SubcontractorPrice: Record "Subcontractor Price"; PurchaseLine: Record "Purchase Line") begin SubcontractorPrice.SetCurrentKey("Vendor No.", "Item No.", "Work Center No.", "Variant Code", "Unit of Measure Code", "Currency Code"); SubcontractorPrice.SetRange("Vendor No.", PurchaseLine."Buy-from Vendor No."); SubcontractorPrice.SetRange("Item No.", PurchaseLine."No."); SubcontractorPrice.SetRange("Work Center No.", PurchaseLine."Work Center No."); SubcontractorPrice.SetRange("Variant Code", PurchaseLine."Variant Code"); SubcontractorPrice.SetFilter("Unit of Measure Code", '%1|%2', PurchaseLine."Unit of Measure Code", ''); SubcontractorPrice.SetRange("Currency Code", PurchaseLine."Currency Code"); end; local procedure FilterTransferLineToSubcontractorPurchaseOrder(PurchOrderNo: Code[20]; PurchOrderLineNo: Integer; var TransferLine: Record "Transfer Line") begin TransferLine.SetCurrentKey("Subc. Purch. Order No."); TransferLine.SetRange("Subc. Purch. Order No.", PurchOrderNo); TransferLine.SetRange("Subc. Purch. Order Line No.", PurchOrderLineNo); TransferLine.SetRange("Subc. Return Order", false); TransferLine.SetRange("Derived From Line No.", 0); end;}