Codeunit 97 Blanket Purch. Order to Order

Base Application, Microsoft.Purchases.Document

src/Layers/W1/BaseApp/Purchases/Document/BlanketPurchOrdertoOrder.Codeunit.al481 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.Purchases.Document;using Microsoft.Finance.ReceivablesPayables;using Microsoft.Purchases.Comment;using Microsoft.Purchases.Setup;using Microsoft.Purchases.Vendor;using Microsoft.Utilities;using System.Utilities;codeunit 97 "Blanket Purch. Order to Order"{    TableNo = "Purchase Header";    trigger OnRun()    var        Vend: Record Vendor;        PurchCommentLine: Record "Purch. Comment Line";        PrepmtMgt: Codeunit "Prepayment Mgt.";        RecordLinkManagement: Codeunit "Record Link Management";        PurchCalcDiscByType: Codeunit "Purch - Calc Disc. By Type";        ShouldRedistributeInvoiceAmount: Boolean;        IsHandled: Boolean;    begin        OnBeforeRun(Rec, SkipCommit);        Rec.TestField("Document Type", Rec."Document Type"::"Blanket Order");        ShouldRedistributeInvoiceAmount := PurchCalcDiscByType.ShouldRedistributeInvoiceDiscountAmount(Rec);        Vend.Get(Rec."Buy-from Vendor No.");        Vend.CheckBlockedVendOnDocs(Vend, false);        Rec.ValidatePurchaserOnPurchHeader(Rec, true, false);        Rec.CheckForBlockedLines();        IsHandled := false;        OnRunOnBeforeQtyToReceiveIsZero(Rec, IsHandled, Vend);        if not IsHandled then            if Rec.QtyToReceiveIsZero() then                Error(Text002);        PurchSetup.Get();        CreatePurchHeader(Rec, Vend."Prepayment %");        PurchBlanketOrderLine.Reset();        PurchBlanketOrderLine.SetRange("Document Type", Rec."Document Type");        PurchBlanketOrderLine.SetRange("Document No.", Rec."No.");        OnRunOnAfterPurchBlanketOrderLineSetFilters(PurchBlanketOrderLine);        if PurchBlanketOrderLine.FindSet() then            repeat                IsHandled := false;                OnRunOnBeforePurchBlanketOrderLineLoop(Rec, PurchBlanketOrderLine, IsHandled);                if not IsHandled then                    if (PurchBlanketOrderLine.Type = PurchBlanketOrderLine.Type::" ") or                       (PurchBlanketOrderLine."Qty. to Receive" <> 0)                    then begin                        CalcQuantityOnOrders();                        CheckBlanketOrderLineQuantity();                        PurchOrderLine := PurchBlanketOrderLine;                        OnRunOnAfterInitPurchOrderLineFromBlanketOrderLine(PurchOrderLine, PurchBlanketOrderLine);                        ResetQuantityFields(PurchOrderLine);                        PurchOrderLine."Document Type" := PurchOrderHeader."Document Type";                        PurchOrderLine."Document No." := PurchOrderHeader."No.";                        PurchOrderLine."Blanket Order No." := Rec."No.";                        PurchOrderLine."Blanket Order Line No." := PurchBlanketOrderLine."Line No.";                        if (PurchOrderLine."No." <> '') and (PurchOrderLine.Type <> PurchOrderLine.Type::" ") then begin                            PurchOrderLine.Amount := 0;                            PurchOrderLine."Amount Including VAT" := 0;                            PurchOrderLineValidateQuantity(PurchOrderLine, PurchBlanketOrderLine);                            if PurchBlanketOrderLine."Expected Receipt Date" <> 0D then                                PurchOrderLine.Validate("Expected Receipt Date", PurchBlanketOrderLine."Expected Receipt Date")                            else                                PurchOrderLine.Validate("Order Date", PurchOrderHeader."Order Date");                            UpdatePurchOrderLineDirectUnitCost();                            PurchOrderLineValidateLineDiscountPct(PurchOrderLine, PurchBlanketOrderLine);                            if (PurchOrderLine.Quantity <> 0) and (PurchBlanketOrderLine."Inv. Discount Amount" <> 0) then                                PurchOrderLine.Validate(                                    "Inv. Discount Amount",                                    Round(PurchBlanketOrderLine."Inv. Discount Amount" * (PurchBlanketOrderLine."Qty. to Receive" / PurchBlanketOrderLine.Quantity)));                            PurchBlanketOrderLine.CalcFields("Reserved Qty. (Base)");                            OnRunOnAfterCalcReservedQtyBase(Rec, PurchBlanketOrderLine, PurchOrderHeader, PurchOrderLine);                            if PurchBlanketOrderLine."Reserved Qty. (Base)" <> 0 then                                PurchLineReserve.TransferPurchLineToPurchLine(                                  PurchBlanketOrderLine, PurchOrderLine, -PurchBlanketOrderLine."Qty. to Receive (Base)");                        end;                        if Vend."Prepayment %" <> 0 then                            PurchOrderLine."Prepayment %" := Vend."Prepayment %";                        PrepmtMgt.SetPurchPrepaymentPct(PurchOrderLine, PurchOrderHeader."Posting Date");                        PurchOrderLine.Validate("Prepayment %");                        PurchOrderLine."Shortcut Dimension 1 Code" := PurchBlanketOrderLine."Shortcut Dimension 1 Code";                        PurchOrderLine."Shortcut Dimension 2 Code" := PurchBlanketOrderLine."Shortcut Dimension 2 Code";                        PurchOrderLine."Dimension Set ID" := PurchBlanketOrderLine."Dimension Set ID";                        PurchOrderLine.DefaultDeferralCode();                        RemapAttachedToLineNo(PurchBlanketOrderLine, PurchOrderLine);                        if IsPurchOrderLineToBeInserted(PurchOrderLine) then begin                            OnBeforeInsertPurchOrderLine(PurchOrderLine, PurchOrderHeader, PurchBlanketOrderLine, Rec);                            PurchOrderLine.Insert();                            OnAfterPurchOrderLineInsert(PurchOrderLine, PurchBlanketOrderLine);                        end;                        OnRunOnBeforeCheckModifyPurchBlanketOrderLine(PurchOrderLine, PurchBlanketOrderLine, PurchLine);                        if PurchBlanketOrderLine."Qty. to Receive" <> 0 then begin                            PurchBlanketOrderLine.Validate("Qty. to Receive", 0);                            PurchBlanketOrderLine.Modify();                        end;                        OnRunOnAfterPurchBlanketOrderLineLoop(PurchOrderLine, PurchLine, PurchBlanketOrderLine);                    end;            until PurchBlanketOrderLine.Next() = 0;        OnAfterInsertAllPurchOrderLines(Rec, PurchOrderHeader, SkipCommit);        if PurchSetup."Default Posting Date" = PurchSetup."Default Posting Date"::"No Date" then begin            PurchOrderHeader."Posting Date" := 0D;            PurchOrderHeader.Modify();        end;        if PurchSetup."Copy Comments Blanket to Order" then begin            PurchCommentLine.CopyComments(                PurchCommentLine."Document Type"::"Blanket Order".AsInteger(),                PurchOrderHeader."Document Type".AsInteger(), Rec."No.", PurchOrderHeader."No.");            RecordLinkManagement.CopyLinks(Rec, PurchOrderHeader);        end;        if not (ShouldRedistributeInvoiceAmount or PurchSetup."Calc. Inv. Discount") then            PurchCalcDiscByType.ResetRecalculateInvoiceDisc(PurchOrderHeader);        OnRunOnBeforeCommit(Rec, PurchOrderHeader);        if not SkipCommit then            Commit();        OnAfterRun(Rec, PurchOrderHeader);    end;    var        PurchBlanketOrderLine: Record "Purchase Line";        PurchOrderHeader: Record "Purchase Header";        PurchOrderLine: Record "Purchase Line";        PurchSetup: Record "Purchases & Payables Setup";        PurchLine: Record "Purchase Line";        PurchLineReserve: Codeunit "Purch. Line-Reserve";        QuantityOnOrders: Decimal;        SkipCommit: Boolean;        QuantityCheckErr: Label '%1 of %2 %3 in %4 %5 cannot be more than %6.\%7\%8 - %9 = %6.', Comment = '%1: FIELDCAPTION("Qty. to Receive (Base)"); %2: Field(Type); %3: Field(No.); %4: FIELDCAPTION("Line No."); %5: Field(Line No.); %6: Decimal Qty Difference; %7: Text001; %8: Field(Outstanding Qty. (Base)); %9: Decimal Quantity On Orders';#pragma warning disable AA0074#pragma warning disable AA0470        Text001: Label '%1 - Unposted %1 = Possible %2';#pragma warning restore AA0470        Text002: Label 'There is nothing to create.';#pragma warning restore AA0074    local procedure CalcQuantityOnOrders()    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCalcQuantityOnOrders(PurchBlanketOrderLine, QuantityOnOrders, IsHandled);        if IsHandled then            exit;        PurchLine.SetCurrentKey("Document Type", "Blanket Order No.", "Blanket Order Line No.");        PurchLine.SetRange("Blanket Order No.", PurchBlanketOrderLine."Document No.");        PurchLine.SetRange("Blanket Order Line No.", PurchBlanketOrderLine."Line No.");        OnCalcQuantityOnOrdersOnAfterPurchLineSetFilters(PurchLine);        QuantityOnOrders := 0;        if PurchLine.FindSet() then            repeat                if (PurchLine."Document Type" = PurchLine."Document Type"::"Return Order") or                   ((PurchLine."Document Type" = PurchLine."Document Type"::"Credit Memo") and                    (PurchLine."Return Shipment No." = ''))                then                    QuantityOnOrders := QuantityOnOrders - PurchLine."Outstanding Qty. (Base)"                else                    if (PurchLine."Document Type" = PurchLine."Document Type"::Order) or                       ((PurchLine."Document Type" = PurchLine."Document Type"::Invoice) and                        not PurchLine.IsMatchedToReceiptOrOrder())                    then                        QuantityOnOrders := QuantityOnOrders + PurchLine."Outstanding Qty. (Base)";            until PurchLine.Next() = 0;    end;    local procedure UpdatePurchOrderLineDirectUnitCost()    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeUpdatePurchOrderLineDirectUnitCost(PurchOrderLine, PurchBlanketOrderLine, PurchOrderHeader, IsHandled);        if IsHandled then            exit;        PurchOrderLine.Validate("Direct Unit Cost", PurchBlanketOrderLine."Direct Unit Cost");    end;    local procedure CheckBlanketOrderLineQuantity()    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCheckBlanketOrderLineQuantity(PurchBlanketOrderLine, QuantityOnOrders, IsHandled);        if IsHandled then            exit;        if (Abs(PurchBlanketOrderLine."Qty. to Receive (Base)" + QuantityOnOrders +            PurchBlanketOrderLine."Qty. Received (Base)") >            Abs(PurchBlanketOrderLine."Quantity (Base)")) or           (PurchBlanketOrderLine."Quantity (Base)" * PurchBlanketOrderLine."Outstanding Qty. (Base)" < 0)        then            Error(              QuantityCheckErr,              PurchBlanketOrderLine.FieldCaption("Qty. to Receive (Base)"),              PurchBlanketOrderLine.Type, PurchBlanketOrderLine."No.",              PurchBlanketOrderLine.FieldCaption("Line No."), PurchBlanketOrderLine."Line No.",              PurchBlanketOrderLine."Outstanding Qty. (Base)" - QuantityOnOrders,              StrSubstNo(                Text001,                PurchBlanketOrderLine.FieldCaption("Outstanding Qty. (Base)"),                PurchBlanketOrderLine.FieldCaption("Qty. to Receive (Base)")),              PurchBlanketOrderLine."Outstanding Qty. (Base)", QuantityOnOrders);    end;    local procedure CreatePurchHeader(PurchHeader: Record "Purchase Header"; PrepmtPercent: Decimal)    var        StandardCodesMgt: Codeunit "Standard Codes Mgt.";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCreatePurchHeader(PurchHeader, PrepmtPercent, IsHandled, PurchOrderHeader);        if IsHandled then            exit;        PurchOrderHeader := PurchHeader;        PurchOrderHeader."Document Type" := PurchOrderHeader."Document Type"::Order;        PurchOrderHeader."No. Printed" := 0;        PurchOrderHeader.Status := PurchOrderHeader.Status::Open;        PurchOrderHeader."No." := '';        OnCreatePurchHeaderOnBeforePurchOrderHeaderInitRecord(PurchOrderHeader, PurchHeader);        PurchOrderHeader.InitRecord();        PurchOrderLine.LockTable();        OnBeforeInsertPurchOrderHeader(PurchOrderHeader, PurchHeader);        StandardCodesMgt.SetSkipRecurringLines(true);        PurchOrderHeader.SetStandardCodesMgt(StandardCodesMgt);        PurchOrderHeader.Insert(true);        OnCreatePurchHeaderOnAfterPurchOrderHeaderInsert(PurchHeader, PurchOrderHeader);        if PurchHeader."Order Date" = 0D then            PurchOrderHeader."Order Date" := WorkDate()        else            PurchOrderHeader."Order Date" := PurchHeader."Order Date";        if PurchHeader."Posting Date" <> 0D then            PurchOrderHeader."Posting Date" := PurchHeader."Posting Date";        if PurchOrderHeader."Posting Date" = 0D then            PurchOrderHeader."Posting Date" := WorkDate();        PurchOrderHeader.InitFromPurchHeader(PurchHeader);        PurchOrderHeader.Validate("Posting Date");        PurchOrderHeader."Prepayment %" := PrepmtPercent;        OnBeforePurchOrderHeaderModify(PurchOrderHeader, PurchHeader);        PurchOrderHeader.Modify();    end;    local procedure PurchOrderLineValidateQuantity(var PurchaseOrderLine: Record "Purchase Line"; BlanketOrderPurchLine: Record "Purchase Line")    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforePurchOrderLineValidateQuantity(PurchaseOrderLine, BlanketOrderPurchLine, IsHandled);        if IsHandled then            exit;        PurchaseOrderLine.Validate(Quantity, BlanketOrderPurchLine."Qty. to Receive");    end;    local procedure PurchOrderLineValidateLineDiscountPct(var PurchaseOrderLine: Record "Purchase Line"; BlanketOrderPurchLine: Record "Purchase Line")    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforePurchOrderLineValidateLineDiscountPct(PurchaseOrderLine, BlanketOrderPurchLine, PurchOrderHeader, IsHandled);        if IsHandled then            exit;        PurchOrderLine.Validate("Line Discount %", PurchBlanketOrderLine."Line Discount %");    end;    local procedure ResetQuantityFields(var TempPurchLine: Record "Purchase Line")    begin        TempPurchLine.Quantity := 0;        TempPurchLine."Quantity (Base)" := 0;        TempPurchLine."Qty. Rcd. Not Invoiced" := 0;        TempPurchLine."Quantity Received" := 0;        TempPurchLine."Quantity Invoiced" := 0;        TempPurchLine."Qty. Rcd. Not Invoiced (Base)" := 0;        TempPurchLine."Qty. Received (Base)" := 0;        TempPurchLine."Qty. Invoiced (Base)" := 0;        OnAfterResetQuantityFields(TempPurchLine);    end;    procedure GetPurchOrderHeader(var PurchHeader: Record "Purchase Header")    begin        PurchHeader := PurchOrderHeader;    end;    local procedure IsPurchOrderLineToBeInserted(PurchOrderLine: Record "Purchase Line") Result: Boolean    var        AttachedToPurchaseLine: Record "Purchase Line";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeIsPurchOrderLineToBeInserted(PurchOrderHeader, PurchOrderLine, Result, IsHandled);        if IsHandled then            exit(Result);        if not PurchOrderLine.IsExtendedText() then            exit(true);        exit(          AttachedToPurchaseLine.Get(            PurchOrderLine."Document Type", PurchOrderLine."Document No.", PurchOrderLine."Attached to Line No."));    end;    local procedure RemapAttachedToLineNo(PurchBlanketOrderLine: Record "Purchase Line"; var PurchOrderLine: Record "Purchase Line")    var        ParentPurchaseLine: Record "Purchase Line";    begin        if PurchOrderLine."Attached to Line No." = 0 then            exit;        ParentPurchaseLine.SetCurrentKey("Document Type", "Blanket Order No.", "Blanket Order Line No.");        ParentPurchaseLine.SetLoadFields("Line No.");        ParentPurchaseLine.SetRange("Document Type", PurchOrderLine."Document Type");        ParentPurchaseLine.SetRange("Document No.", PurchOrderLine."Document No.");        ParentPurchaseLine.SetRange("Blanket Order No.", PurchBlanketOrderLine."Document No.");        ParentPurchaseLine.SetRange("Blanket Order Line No.", PurchBlanketOrderLine."Attached to Line No.");        if ParentPurchaseLine.FindFirst() then            PurchOrderLine."Attached to Line No." := ParentPurchaseLine."Line No.";    end;    [IntegrationEvent(false, false)]    local procedure OnAfterPurchOrderLineInsert(var PurchaseLine: Record "Purchase Line"; var BlanketOrderPurchLine: Record "Purchase Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterRun(var PurchaseHeader: Record "Purchase Header"; var PurchOrderHeader: Record "Purchase Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterResetQuantityFields(var TempPurchLine: Record "Purchase Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeRun(var PurchaseHeader: Record "Purchase Header"; var SkipCommit: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCalcQuantityOnOrders(var PurchBlanketOrderLine: Record "Purchase Line"; var QuantityOnOrders: Decimal; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCheckBlanketOrderLineQuantity(var PurchBlanketOrderLine: Record "Purchase Line"; QuantityOnOrders: Decimal; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCreatePurchHeader(var PurchaseHeader: Record "Purchase Header"; PrepmtPercent: Decimal; var IsHandled: Boolean; var OrderPurchaseHeader: Record "Purchase Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInsertPurchOrderHeader(var PurchOrderHeader: Record "Purchase Header"; BlanketOrderPurchHeader: Record "Purchase Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInsertPurchOrderLine(var PurchOrderLine: Record "Purchase Line"; PurchOrderHeader: Record "Purchase Header"; var BlanketOrderPurchLine: Record "Purchase Line"; BlanketOrderPurchHeader: Record "Purchase Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeIsPurchOrderLineToBeInserted(var PurchaseHader: Record "Purchase Header"; PurchaseLine: Record "Purchase Line"; var Result: Boolean; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeUpdatePurchOrderLineDirectUnitCost(var PurchOrderLine: Record "Purchase Line"; PurchBlanketOrderLine: Record "Purchase Line"; PurchOrderHeader: Record "Purchase Header"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterInsertAllPurchOrderLines(BlanketOrderPurchHeader: Record "Purchase Header"; OrderPurchHeader: Record "Purchase Header"; var SkipCommit: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforePurchOrderHeaderModify(var PurchOrderHeader: Record "Purchase Header"; BlanketOrderPurchHeader: Record "Purchase Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforePurchOrderLineValidateQuantity(var PurchOrderLine: Record "Purchase Line"; BlanketOrderPurchLine: Record "Purchase Line"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforePurchOrderLineValidateLineDiscountPct(var PurchaseOrderLine: Record "Purchase Line"; BlanketOrderPurchaseLine: Record "Purchase Line"; PurchaseOrderHeader: Record "Purchase Header"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalcQuantityOnOrdersOnAfterPurchLineSetFilters(var PurchaseLine: Record "Purchase Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCreatePurchHeaderOnBeforePurchOrderHeaderInitRecord(var PurchOrderHeader: Record "Purchase Header"; var PurchHeader: Record "Purchase Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnRunOnAfterPurchBlanketOrderLineLoop(var PurchOrderLine: Record "Purchase Line"; var PurchLine: Record "Purchase Line"; var PurchBlanketOrderLine: Record "Purchase Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnRunOnAfterPurchBlanketOrderLineSetFilters(var PurchBlanketOrderLine: Record "Purchase Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnRunOnAfterInitPurchOrderLineFromBlanketOrderLine(var PurchaseOrderLine: Record "Purchase Line"; var BlanketOrderPurchaseLine: Record "Purchase Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnRunOnAfterCalcReservedQtyBase(var PurchaseBlanketOrder: Record "Purchase Header"; var PurchaseBlanketOrderLine: Record "Purchase Line"; PurchaseOrder: Record "Purchase Header"; var PurchaseOrderLine: Record "Purchase Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnRunOnBeforeCheckModifyPurchBlanketOrderLine(var PurchOrderLine: Record "Purchase Line"; var PurchBlanketOrderLine: Record "Purchase Line"; var PurchLine: Record "Purchase Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCreatePurchHeaderOnAfterPurchOrderHeaderInsert(PurchHeader: Record "Purchase Header"; var PurchOrderHeader: Record "Purchase Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnRunOnBeforeCommit(var PurchaseHeader: Record "Purchase Header"; var PurchHeaderOrder: Record "Purchase Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnRunOnBeforePurchBlanketOrderLineLoop(var PurchaseHeader: Record "Purchase Header"; PurchLineBlanketOrder: Record "Purchase Line"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnRunOnBeforeQtyToReceiveIsZero(var PurchaseHeader: Record "Purchase Header"; var IsHandled: Boolean; var Vendor: Record "Vendor")    begin    end;}