Codeunit 8055 Sub. Contracts Item Management

Subscription Billing, Microsoft.SubscriptionBilling

src/Apps/W1/Subscription Billing/App/Base/Codeunits/SubContractsItemManagement.Codeunit.al402 lines, Copyright (c) Microsoft Corporation. MIT

namespace Microsoft.SubscriptionBilling;using Microsoft.Inventory.BOM;using Microsoft.Inventory.Item;using Microsoft.Inventory.Item.Attribute;using Microsoft.Inventory.Item.Catalog;using Microsoft.Pricing.Calculation;using Microsoft.Pricing.PriceList;using Microsoft.Purchases.Document;using Microsoft.Purchases.Posting;using Microsoft.Sales.Customer;using Microsoft.Sales.Document;codeunit 8055 "Sub. Contracts Item Management"{    SingleInstance = true;    [EventSubscriber(ObjectType::Table, Database::Item, OnAfterValidateEvent, Type, false, false)]    local procedure ItemOnAfterValidateType(var Rec: Record Item)    begin        if Rec."Subscription Option" in [Enum::"Item Service Commitment Type"::"Service Commitment Item", Enum::"Item Service Commitment Type"::"Invoicing Item"] then            if Rec.Type <> Rec.Type::"Non-Inventory" then                Error(                    NonInventoryTypeErr,                    Rec.Type,                    Enum::"Item Service Commitment Type"::"Sales without Service Commitment",                    Enum::"Item Service Commitment Type"::"Sales with Service Commitment",                    Rec.FieldCaption("Subscription Option"));    end;    [EventSubscriber(ObjectType::Table, Database::"Sales Line", OnBeforeValidateEvent, "No.", false, false)]    local procedure SalesLineOnBeforeValidateNo(var Rec: Record "Sales Line")    begin        if Rec.Type = Rec.Type::Item then begin            if not Rec.IsLineAttachedToBillingLine() then                PreventBillingItem(Rec."No.");            //Subscription Item can only be used in either of three cases:            //Quote for purposes of creating Sales Subscription Lines            //Order for purposes of creating Sales Subscription Lines            //Contract Invoice for billing purposes            if not Rec.IsSalesDocumentTypeWithServiceCommitments() and (not Rec.IsLineAttachedToBillingLine()) then                PreventServiceCommitmentItem(Rec."No.");        end;    end;    [EventSubscriber(ObjectType::Table, Database::"Purchase Line", OnBeforeValidateEvent, "No.", false, false)]    local procedure PurchaseLineOnBeforeValidateEvent(var Rec: Record "Purchase Line")    begin        if Rec.Type = Rec.Type::Item then            if not Rec.IsLineAttachedToBillingLine() then                PreventBillingItem(Rec."No.");    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Purch.-Post", OnBeforePostPurchLine, '', false, false)]    local procedure OnBeforePostPurchLine(var PurchLine: Record "Purchase Line")    var        Item: Record Item;        LinkToContractRequiredErr: Label 'Subscription Items and Invoicing items require a link to a contract line before they can be posted.';    begin        if PurchLine."Document Type" <> Enum::"Purchase Document Type"::Invoice then            exit;        if PurchLine.Type <> PurchLine.Type::Item then            exit;        if PurchLine.IsLineAttachedToBillingLine() then            exit;        if not Item.Get(PurchLine."No.") then            exit;        if Item."Subscription Option" in ["Item Service Commitment Type"::"Invoicing Item", "Item Service Commitment Type"::"Service Commitment Item"] then            Error(LinkToContractRequiredErr);    end;    [EventSubscriber(ObjectType::Table, Database::"BOM Component", OnBeforeValidateEvent, "No.", false, false)]    local procedure BOMComponentOnAfterValidateNo(var Rec: Record "BOM Component")    begin        if Rec.Type = Rec.Type::Item then            PreventBillingItem(Rec."No.");    end;    local procedure PreventServiceCommitmentItem(ItemNo: Code[20])    begin        if AllowInsertOfInvoicingItem then            exit;        if IsServiceCommitmentItem(ItemNo) then            Error(ServiceCommitmentItemErr);    end;    local procedure PreventBillingItem(ItemNo: Code[20])    var        Item: Record Item;    begin        if not GetItem(ItemNo, Item) then            exit;        if AllowInsertOfInvoicingItem then            exit;        if Item."Subscription Option" = Enum::"Item Service Commitment Type"::"Invoicing Item" then            Error(InvoicingItemErr);    end;    local procedure GetItem(ItemNo: Code[20]; var Item: Record Item): Boolean    begin        if ItemNo = '' then            exit(false);        if not Item.Get(ItemNo) then            exit(false);        exit(true);    end;    procedure IsServiceCommitmentItem(ItemNo: Code[20]): Boolean    var        Item: Record Item;    begin        if not GetItem(ItemNo, Item) then            exit(false);        exit(Item."Subscription Option" = "Item Service Commitment Type"::"Service Commitment Item");    end;    internal procedure IsItemWithServiceCommitments(ItemNo: Code[20]): Boolean    var        Item: Record Item;    begin        if not GetItem(ItemNo, Item) then            exit(false);        exit(            (Item."Subscription Option" in             ["Item Service Commitment Type"::"Sales with Service Commitment",              "Item Service Commitment Type"::"Service Commitment Item"]));    end;    procedure GetSalesPriceForItem(var UnitPrice: Decimal; ItemNo: Code[20]; Quantity: Decimal; CurrencyCode: Code[10]; SellToCustomerNo: Code[20]; BillToCustomerNo: Code[20])    var        TempSalesLine: Record "Sales Line" temporary;        TempSalesHeader: Record "Sales Header" temporary;    begin        //Currently BillToCustomer is not taken into consideration for price calculation        UnitPrice := 0;        if (SellToCustomerNo = '') or (ItemNo = '') then            exit;        CreateTempSalesHeader(TempSalesHeader, TempSalesHeader."Document Type"::Order, SellToCustomerNo, SellToCustomerNo, 0D, CurrencyCode);        CreateTempSalesLine(TempSalesLine, TempSalesHeader, "Service Object Type"::Item, ItemNo, Quantity, 0D, '', '');        UnitPrice := CalculateUnitPrice(TempSalesHeader, TempSalesLine);    end;    internal procedure CreateTempSalesHeader(var TempSalesHeader: Record "Sales Header" temporary; DocumentType: Enum "Sales Document Type"; SellToCustomerNo: Code[20]; BillToCustomerNo: Code[20]; OrderDate: Date; CurrencyCode: Code[10])    begin        TempSalesHeader.SetHideValidationDialog(true);        TempSalesHeader.Init();        TempSalesHeader.Validate("Document Type", DocumentType);        TempSalesHeader.Validate(Status, TempSalesHeader.Status::Open);        TempSalesHeader.InitRecord();        if SellToCustomerNo <> '' then            TempSalesHeader.Validate("Sell-to Customer No.", SellToCustomerNo);        if BillToCustomerNo <> '' then            TempSalesHeader.Validate("Bill-to Customer No.", BillToCustomerNo);        TempSalesHeader.Validate("Currency Code", CurrencyCode);        TempSalesHeader."Order Date" := OrderDate;    end;    internal procedure CreateTempSalesLine(var TempSalesLine: Record "Sales Line" temporary; var TempSalesHeader: Record "Sales Header" temporary; ServiceObject: Record "Subscription Header"; OrderDate: Date)    begin        CreateTempSalesLine(TempSalesLine, TempSalesHeader, ServiceObject.Type, ServiceObject."Source No.", ServiceObject.Quantity, OrderDate, ServiceObject."Variant Code", ServiceObject."Unit of Measure");    end;    internal procedure CreateTempSalesLine(var TempSalesLine: Record "Sales Line" temporary; var TempSalesHeader: Record "Sales Header" temporary; ServiceObjectType: enum "Service Object Type"; SourceNo: Code[20]; Quantity: Decimal; OrderDate: Date; VariantCode: Code[10]; UnitOfMeasureCode: Code[10])    begin        TempSalesLine.Init();        TempSalesLine.SetHideValidationDialog(true);        TempSalesLine.SuspendStatusCheck(true);        TempSalesLine.Validate("Document Type", TempSalesHeader."Document Type");        TempSalesLine."Document No." := TempSalesHeader."No.";        case ServiceObjectType of            ServiceObjectType::Item:                TempSalesLine.Type := TempSalesLine.Type::Item;            ServiceObjectType::"G/L Account":                TempSalesLine.Type := TempSalesLine.Type::"G/L Account";        end;        TempSalesLine."Sell-to Customer No." := TempSalesHeader."Sell-to Customer No.";        TempSalesLine."Bill-to Customer No." := TempSalesHeader."Bill-to Customer No.";        TempSalesLine."Customer Price Group" := TempSalesHeader."Customer Price Group";        TempSalesLine."VAT Bus. Posting Group" := TempSalesHeader."VAT Bus. Posting Group";        TempSalesLine."No." := SourceNo;        TempSalesLine.Quantity := Quantity;        TempSalesLine."Currency Code" := TempSalesHeader."Currency Code";        TempSalesLine."Variant Code" := VariantCode;        TempSalesLine."Unit of Measure Code" := UnitOfMeasureCode;        TempSalesLine."Qty. per Unit of Measure" := GetQtyPerUnitOfMeasure(ServiceObjectType, SourceNo, UnitOfMeasureCode);        if OrderDate <> 0D then            TempSalesLine."Posting Date" := OrderDate; //Field is empty in the temp table and affects whether the correct sales price will be picked. Field has to be forced either it will use WorkDate    end;    local procedure GetQtyPerUnitOfMeasure(ServiceObjectType: Enum "Service Object Type"; SourceNo: Code[20]; UnitOfMeasureCode: Code[10]): Decimal    var        ItemUnitOfMeasure: Record "Item Unit of Measure";    begin        if (ServiceObjectType <> ServiceObjectType::Item) or (UnitOfMeasureCode = '') then            exit(1);        if not ItemUnitOfMeasure.Get(SourceNo, UnitOfMeasureCode) then            exit(1);        if ItemUnitOfMeasure."Qty. per Unit of Measure" = 0 then            exit(1);        exit(ItemUnitOfMeasure."Qty. per Unit of Measure");    end;    procedure CalculateUnitPrice(var TempSalesHeader: Record "Sales Header" temporary; var TempSalesLine: Record "Sales Line" temporary): Decimal    var        PriceCalculation: Interface "Price Calculation";    begin        TempSalesLine.GetPriceCalculationHandler("Price Type"::Sale, TempSalesHeader, PriceCalculation);        TempSalesLine.ApplyDiscount(PriceCalculation);        TempSalesLine.ApplyPrice(TempSalesLine.FieldNo("No."), PriceCalculation);        exit(TempSalesLine."Unit Price");    end;    procedure CalculateUnitCost(ItemNo: Code[20]): Decimal    var        Item: Record Item;    begin        if ItemNo = '' then            exit(0);        Item.Get(ItemNo);        exit(Item."Unit Cost");    end;    internal procedure CreateTempPurchaseHeader(var TempPurchaseHeader: Record "Purchase Header" temporary; DocumentType: Enum "Purchase Document Type"; PayToVendorNo: Code[20]; OrderDate: Date; CurrencyCode: Code[10])    begin        TempPurchaseHeader.SetHideValidationDialog(true);        TempPurchaseHeader.Init();        TempPurchaseHeader.Validate("Document Type", DocumentType);        TempPurchaseHeader.Validate(Status, TempPurchaseHeader.Status::Open);        TempPurchaseHeader.InitRecord();        if PayToVendorNo <> '' then            TempPurchaseHeader.Validate("Pay-to Vendor No.", PayToVendorNo);        TempPurchaseHeader.Validate("Currency Code", CurrencyCode);        TempPurchaseHeader."Order Date" := OrderDate;    end;    internal procedure CreateTempPurchaseLine(var TempPurchaseLine: Record "Purchase Line" temporary; var TempPurchaseHeader: Record "Purchase Header" temporary; ServiceObject: Record "Subscription Header"; OrderDate: Date)    begin        CreateTempPurchaseLine(TempPurchaseLine, TempPurchaseHeader, ServiceObject.Type, ServiceObject."Source No.", ServiceObject.Quantity, OrderDate, ServiceObject."Variant Code", ServiceObject."Unit of Measure");    end;    internal procedure CreateTempPurchaseLine(var TempPurchaseLine: Record "Purchase Line" temporary; var TempPurchaseHeader: Record "Purchase Header" temporary; ServiceObjectType: enum "Service Object Type"; SourceNo: Code[20]; Quantity: Decimal; OrderDate: Date; VariantCode: Code[10]; UnitOfMeasureCode: Code[10])    begin        TempPurchaseLine.Init();        TempPurchaseLine.SuspendStatusCheck(true);        TempPurchaseLine.Validate("Document Type", TempPurchaseHeader."Document Type");        TempPurchaseLine."Document No." := TempPurchaseHeader."No.";        case ServiceObjectType of            ServiceObjectType::Item:                TempPurchaseLine.Type := TempPurchaseLine.Type::Item;            ServiceObjectType::"G/L Account":                TempPurchaseLine.Type := TempPurchaseLine.Type::"G/L Account";        end;        TempPurchaseLine."Pay-to Vendor No." := TempPurchaseHeader."Pay-to Vendor No.";        TempPurchaseLine."Buy-from Vendor No." := TempPurchaseHeader."Buy-from Vendor No.";        TempPurchaseLine."VAT Bus. Posting Group" := TempPurchaseHeader."VAT Bus. Posting Group";        TempPurchaseLine."No." := SourceNo;        TempPurchaseLine.Quantity := Quantity;        TempPurchaseLine."Currency Code" := TempPurchaseHeader."Currency Code";        TempPurchaseLine."Variant Code" := VariantCode;        TempPurchaseLine."Unit of Measure Code" := UnitOfMeasureCode;        TempPurchaseLine."Qty. per Unit of Measure" := GetQtyPerUnitOfMeasure(ServiceObjectType, SourceNo, UnitOfMeasureCode);        if OrderDate <> 0D then            TempPurchaseLine."Expected Receipt Date" := OrderDate;    end;    procedure CalculateDirectUnitCost(var TempPurchaseHeader: Record "Purchase Header" temporary; var TempPurchaseLine: Record "Purchase Line" temporary): Decimal    var        PriceCalculation: Interface "Price Calculation";        Line: Variant;    begin        TempPurchaseLine.GetPriceCalculationHandler(TempPurchaseHeader, PriceCalculation);        PriceCalculation.ApplyDiscount();        PriceCalculation.ApplyPrice(TempPurchaseLine.FieldNo("No."));        PriceCalculation.GetLine(Line);        TempPurchaseLine := Line;        exit(TempPurchaseLine."Direct Unit Cost");    end;    [EventSubscriber(ObjectType::Table, Database::"Price List Line", OnAfterValidateEvent, "Allow Invoice Disc.", false, false)]    local procedure ErrorIfAllowInvoiceDiscountForPriceListLineForServiceCommitmentItem(var Rec: Record "Price List Line")    var        Item: Record Item;    begin        if Rec."Price Type" <> Rec."Price Type"::Sale then            exit;        if Rec."Asset Type" <> Rec."Asset Type"::Item then            exit;        if Rec."Allow Invoice Disc." then            if Item.Get(Rec."Asset No.") then                if Item.IsServiceCommitmentItem() then                    Error(Item.GetDoNotAllowInvoiceDiscountForServiceCommitmentItemErrorText());    end;    [EventSubscriber(ObjectType::Table, Database::"Price List Line", OnAfterCopyFromForPriceAsset, '', false, false)]    local procedure DisableInvoiceDiscountForServiceCommitmentItemAfterPriceAssetAssigned(var PriceListLine: Record "Price List Line")    begin        DisableInvoiceDiscountForServiceCommitmentItem(PriceListLine);    end;    [EventSubscriber(ObjectType::Table, Database::"Price List Line", OnAfterValidateEvent, "Amount Type", false, false)]    local procedure DisableInvoiceDiscountForServiceCommitmentItemAfterChangingAmountType(var Rec: Record "Price List Line")    begin        DisableInvoiceDiscountForServiceCommitmentItem(Rec);    end;    [EventSubscriber(ObjectType::Table, Database::"Item Attribute Value Selection", OnInsertRecordOnBeforeItemAttrValueSelectionInsert, '', false, false)]    local procedure CopyPrimaryFieldValueFromItemAttribute(var ItemAttributeValueSelection: Record "Item Attribute Value Selection"; TempItemAttributeValue: Record "Item Attribute Value" temporary)    begin        ItemAttributeValueSelection.Primary := TempItemAttributeValue.Primary;    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Catalog Item Management", OnDelNonStockItemOnAfterCheckRelations, '', false, false)]    local procedure PreventDeletionOfSubscriptionItemOnDelNonStockItem(var Item: Record Item; var ShouldExit: Boolean)    begin        if Item."Subscription Option" in            ["Item Service Commitment Type"::"Service Commitment Item",             "Item Service Commitment Type"::"Invoicing Item"]        then            ShouldExit := true;    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Catalog Item Management", OnAfterCreateNewItem, '', false, false)]    local procedure InsertItemServiceCommPackAfterCreateNewItem(var Item: Record Item; NonstockItem: Record "Nonstock Item"; var NewItem: Record Item)    begin        InsertItemServCommPackFromItemTemplServCommPack(Item, NonstockItem."Item Templ. Code");    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Item Templ. Mgt.", OnAfterCreateItemFromTemplate, '', false, false)]    local procedure InsertItemServiceCommPackAfterCreateItemFromTemplate(var Item: Record Item; ItemTempl: Record "Item Templ.")    begin        InsertItemServCommPackFromItemTemplServCommPack(Item, ItemTempl.Code);    end;    local procedure InsertItemServCommPackFromItemTemplServCommPack(Item: Record Item; ItemTemplCode: Code[20])    var        ItemTemplServCommPackage: Record "Item Templ. Sub. Package";    begin        ItemTemplServCommPackage.SetRange("Item Template Code", ItemTemplCode);        if ItemTemplServCommPackage.FindSet() then            repeat                InsertItemServiceCommitmentPackage(Item, ItemTemplServCommPackage.Code, ItemTemplServCommPackage.Standard);            until ItemTemplServCommPackage.Next() = 0;    end;    internal procedure InsertItemServiceCommitmentPackage(Item: Record Item; PackageCode: Code[20]; Standard: Boolean)    var        ItemServCommitmentPackage: Record "Item Subscription Package";        ServiceCommitmentPackage: Record "Subscription Package";    begin        if not ItemServCommitmentPackage.Get(Item."No.", PackageCode) then begin            ServiceCommitmentPackage.Get(PackageCode);            ItemServCommitmentPackage.Init();            ItemServCommitmentPackage."Item No." := Item."No.";            ItemServCommitmentPackage.Code := PackageCode;            ItemServCommitmentPackage.Standard := Standard;            ItemServCommitmentPackage.ErrorIfInvoicingItemIsNotServiceCommitmentItemForDiscount(PackageCode);            ItemServCommitmentPackage.Validate("Price Group", ServiceCommitmentPackage."Price Group");            ItemServCommitmentPackage.Insert(true);        end    end;    local procedure DisableInvoiceDiscountForServiceCommitmentItem(var PriceListLine: Record "Price List Line")    var        Item: Record Item;    begin        if Item.Get(PriceListLine."Asset No.") then            if Item.IsServiceCommitmentItem() then                PriceListLine."Allow Invoice Disc." := Item."Allow Invoice Disc.";    end;    procedure GetItemTranslation(ItemNo: Code[20]; VariantCode: Code[10]; CustomerNo: Code[20]): Text[100]    var        Item: Record Item;        ItemTranslation: Record "Item Translation";        Customer: Record Customer;    begin        if ItemNo = '' then            exit('');        if Customer.Get(CustomerNo) then            if ItemTranslation.Get(ItemNo, VariantCode, Customer."Language Code") then                exit(ItemTranslation.Description);        Item.Get(ItemNo);        exit(Item.Description);    end;    procedure SetAllowInsertOfInvoicingItem(NewAllowInsertOfInvoicingItem: Boolean)    begin        AllowInsertOfInvoicingItem := NewAllowInsertOfInvoicingItem;    end;    var        AllowInsertOfInvoicingItem: Boolean;        NonInventoryTypeErr: Label 'The value "%1" can only be set if either "%2" or "%3" is selected in the field "%4".', Comment = '%1=Item Type, %2=Sales without Service Commitment, %3=Sales with Service Commitment, %4=Subscription Option';        InvoicingItemErr: Label 'Items that are marked as Invoicing Item may not be used here. Please choose another item.';        ServiceCommitmentItemErr: Label 'Items that are marked as Subscription Item may not be used here. Please choose another item.';}