Codeunit 5702 Dist. Integration

Base Application, Microsoft.Inventory

src/Layers/W1/BaseApp/Inventory/DistIntegration.Codeunit.al294 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;using Microsoft.Foundation.ExtendedText;using Microsoft.Inventory.Item;using Microsoft.Inventory.Item.Catalog;using Microsoft.Purchases.Document;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using Microsoft.Sales.Document;using Microsoft.Utilities;codeunit 5702 "Dist. Integration"{    trigger OnRun()    begin    end;    var        SalesLine: Record "Sales Line";        PurchLine: Record "Purchase Line";        ItemReference: Record "Item Reference";        ItemsNotFoundErr: Label 'There are no items with cross reference %1.', Comment = '%1=Cross-Reference No.';#pragma warning disable AA0074        Text001: Label 'The Quantity per Unit of Measure %1 has changed from %2 to %3 since the sales order was created. Adjust the quantity on the sales order or the unit of measure.', Comment = '%1=Unit of Measure Code,%2=Qty. per Unit of Measure in Sales Line,%3=Qty. per Unit of Measure in Item Unit of Measure';#pragma warning restore AA0074    procedure GetSpecialOrders(var PurchHeader: Record "Purchase Header")    var        SalesHeader: Record "Sales Header";        ItemUnitOfMeasure: Record "Item Unit of Measure";        Vendor: Record Vendor;        NextLineNo: Integer;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeGetSpecialOrders(PurchHeader, IsHandled);        if IsHandled then            exit;        PurchHeader.TestField("Document Type", PurchHeader."Document Type"::Order);        IsHandled := false;        OnGetSpecialOrdersOnBeforeSelectSalesHeader(PurchHeader, SalesHeader, IsHandled);        if not IsHandled then begin            SalesHeader.SetCurrentKey("Document Type", "Sell-to Customer No.");            SalesHeader.SetRange("Document Type", SalesHeader."Document Type"::Order);            SalesHeader.SetRange("Sell-to Customer No.", PurchHeader."Sell-to Customer No.");            if (PAGE.RunModal(PAGE::"Sales List", SalesHeader) <> ACTION::LookupOK) or               (SalesHeader."No." = '')            then                exit;        end;        PurchHeader.LockTable();        OnGetSpecialOrdersOnBeforeTestSalesHeader(SalesHeader);        SalesHeader.TestField("Document Type", SalesHeader."Document Type"::Order);        PurchHeader.TestField(PurchHeader."Sell-to Customer No.", SalesHeader."Sell-to Customer No.");        CheckShipToCode(PurchHeader, SalesHeader);        CheckAddSpecialOrderToAddress(PurchHeader, SalesHeader);        if Vendor.Get(PurchHeader."Buy-from Vendor No.") then            PurchHeader.Validate(PurchHeader."Shipment Method Code", Vendor."Shipment Method Code");        PurchLine.LockTable();        SalesLine.LockTable();        PurchLine.SetRange("Document Type", PurchLine."Document Type"::Order);        PurchLine.SetRange("Document No.", PurchHeader."No.");        if PurchLine.FindLast() then            NextLineNo := PurchLine."Line No." + 10000        else            NextLineNo := 10000;        SalesLine.Reset();        SalesLine.SetRange("Document Type", SalesLine."Document Type"::Order);        SalesLine.SetRange("Document No.", SalesHeader."No.");        SalesLine.SetRange("Special Order", true);        SalesLine.SetFilter("Outstanding Quantity", '<>0');        SalesLine.SetRange(Type, SalesLine.Type::Item);        SalesLine.SetFilter("No.", '<>%1', '');        SalesLine.SetRange("Special Order Purch. Line No.", 0);        OnGetSpecialOrdersOnAfterSalesLineSetFilters(SalesLine, SalesHeader, PurchHeader);        if SalesLine.FindSet() then            repeat                IsHandled := false;                OnGetSpecialOrdersOnBeforeTestSalesLine(SalesLine, PurchHeader, IsHandled);                if not IsHandled then                    if (SalesLine.Type = SalesLine.Type::Item) and                       ItemUnitOfMeasure.Get(SalesLine."No.", SalesLine."Unit of Measure Code")                    then                        if SalesLine."Qty. per Unit of Measure" <> ItemUnitOfMeasure."Qty. per Unit of Measure" then                            Error(Text001,                              SalesLine."Unit of Measure Code", SalesLine."Qty. per Unit of Measure",                              ItemUnitOfMeasure."Qty. per Unit of Measure");                ProcessSalesLine(SalesLine, PurchLine, NextLineNo, PurchHeader);            until SalesLine.Next() = 0        else            Error(ItemsNotFoundErr, SalesHeader."No.");        OnGetSpecialOrdersOnBeforeModifyPurchaseHeader(PurchHeader, SalesHeader);        PurchHeader.Modify();        // Only version check        SalesHeader.Modify(); // Only version check    end;    local procedure CheckShipToCode(var PurchHeader: Record "Purchase Header"; SalesHeader: Record "Sales Header")    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCheckShipToCode(PurchHeader, SalesHeader, IsHandled);        if IsHandled then            exit;        if PurchHeader."Ship-to Code" <> '' then            PurchHeader.TestField("Ship-to Code", SalesHeader."Ship-to Code");    end;    local procedure CheckAddSpecialOrderToAddress(var PurchHeader: Record "Purchase Header"; SalesHeader: Record "Sales Header")    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCheckAddSpecialOrderToAddress(PurchHeader, SalesHeader, IsHandled);        if IsHandled then            exit;        if PurchHeader.SpecialOrderExists(SalesHeader) then begin            PurchHeader.Validate("Location Code", SalesHeader."Location Code");            PurchHeader.AddSpecialOrderToAddress(SalesHeader, true);        end;    end;    local procedure ProcessSalesLine(var SalesLine: Record "Sales Line"; var PurchLine: Record "Purchase Line"; var NextLineNo: Integer; PurchHeader: Record "Purchase Header")    var        PurchLine2: Record "Purchase Line";        CopyDocMgt: Codeunit "Copy Document Mgt.";        TransferExtendedText: Codeunit "Transfer Extended Text";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeProcessSalesLine(SalesLine, IsHandled);        if IsHandled then            exit;        PurchLine.Init();        PurchLine."Document Type" := PurchLine."Document Type"::Order;        PurchLine."Document No." := PurchHeader."No.";        PurchLine."Line No." := NextLineNo;        CopyDocMgt.TransfldsFromSalesToPurchLine(SalesLine, PurchLine);        PurchLine.GetItemTranslation();        PurchLine."Special Order" := true;        PurchLine."Purchasing Code" := SalesLine."Purchasing Code";        PurchLine."Special Order Sales No." := SalesLine."Document No.";        PurchLine."Special Order Sales Line No." := SalesLine."Line No.";        OnBeforeInsertPurchLine(PurchLine, SalesLine);        PurchLine.Insert();        OnAfterInsertPurchLine(PurchLine, SalesLine, NextLineNo);        NextLineNo := NextLineNo + 10000;        SalesLine."Unit Cost (LCY)" := PurchLine."Unit Cost (LCY)";        SalesLine.Validate("Unit Cost (LCY)");        SalesLine."Special Order Purchase No." := PurchLine."Document No.";        SalesLine."Special Order Purch. Line No." := PurchLine."Line No.";        OnBeforeSalesLineModify(SalesLine, PurchLine);        SalesLine.Modify();        OnAfterSalesLineModify(SalesLine, PurchLine);        if TransferExtendedText.PurchCheckIfAnyExtText(PurchLine, false) then begin            TransferExtendedText.InsertPurchExtText(PurchLine);            PurchLine2.SetRange("Document Type", PurchHeader."Document Type");            PurchLine2.SetRange("Document No.", PurchHeader."No.");            if PurchLine2.FindLast() then                NextLineNo := PurchLine2."Line No.";            NextLineNo := NextLineNo + 10000;        end;        OnGetSpecialOrdersOnAfterTransferExtendedText(SalesLine, PurchHeader, NextLineNo);    end;    [EventSubscriber(ObjectType::Table, Database::Item, 'OnAfterDeleteRelatedData', '', false, false)]    local procedure ItemOnAfterDeleteRelatedData(Item: Record Item)    begin        if Item.IsTemporary() then            exit;        ItemReference.SetRange("Item No.", Item."No.");        ItemReference.DeleteAll();    end;    [EventSubscriber(ObjectType::Table, Database::Customer, 'OnAfterDeleteEvent', '', false, false)]    local procedure CustomerOnAfterDelete(var Rec: Record Customer)    begin        if Rec.IsTemporary() then            exit;        ItemReference.SetCurrentKey("Reference Type", "Reference Type No.");        ItemReference.SetRange("Reference Type", ItemReference."Reference Type"::Customer);        ItemReference.SetRange("Reference Type No.", Rec."No.");        ItemReference.DeleteAll();    end;    [EventSubscriber(ObjectType::Table, Database::Vendor, 'OnAfterDeleteEvent', '', false, false)]    local procedure VendorOnAfterDelete(var Rec: Record Vendor)    begin        if Rec.IsTemporary() then            exit;        ItemReference.SetCurrentKey("Reference Type", "Reference Type No.");        ItemReference.SetRange("Reference Type", ItemReference."Reference Type"::Vendor);        ItemReference.SetRange("Reference Type No.", Rec."No.");        ItemReference.DeleteAll();    end;    [IntegrationEvent(false, false)]    local procedure OnAfterInsertPurchLine(var PurchaseLine: Record "Purchase Line"; SalesLine: Record "Sales Line"; var NextLineNo: Integer)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterSalesLineModify(var SalesLine: Record "Sales Line"; PurchaseLine: Record "Purchase Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCheckShipToCode(var PurchaseHeader: Record "Purchase Header"; SalesHeader: Record "Sales Header"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCheckAddSpecialOrderToAddress(var PurchaseHeader: Record "Purchase Header"; SalesHeader: Record "Sales Header"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeGetSpecialOrders(PurchaseHeader: Record "Purchase Header"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInsertPurchLine(var PurchaseLine: Record "Purchase Line"; SalesLine: Record "Sales Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeSalesLineModify(var SalesLine: Record "Sales Line"; PurchaseLine: Record "Purchase Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnGetSpecialOrdersOnAfterSalesLineSetFilters(var SalesLine: Record "Sales Line"; SalesHeader: Record "Sales Header"; var PurchHeader: Record "Purchase Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnGetSpecialOrdersOnAfterTransferExtendedText(SalesLine: Record "Sales Line"; PurchaseHeader: Record "Purchase Header"; var NextLineNo: Integer)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnGetSpecialOrdersOnBeforeSelectSalesHeader(var PurchaseHeader: Record "Purchase Header"; var SalesHeader: Record "Sales Header"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnGetSpecialOrdersOnBeforeTestSalesHeader(SalesHeader: Record "Sales Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnGetSpecialOrdersOnBeforeTestSalesLine(SalesLine: Record "Sales Line"; PurchaseHeader: Record "Purchase Header"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeProcessSalesLine(var SalesLine: Record "Sales Line"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnGetSpecialOrdersOnBeforeModifyPurchaseHeader(var PurchaseHeader: Record "Purchase Header"; var SalesHeader: Record "Sales Header")    begin    end;}