Codeunit 8009 Price Update Management
src/Apps/W1/Subscription Billing/App/Contract Price Update/Codeunits/PriceUpdateManagement.Codeunit.al309 lines, Copyright (c) Microsoft Corporation. MIT
namespace Microsoft.SubscriptionBilling;codeunit 8009 "Price Update Management"{ var LastGroupByValue: Code[20]; LastGroupEntryNo: Integer; internal procedure InitTempTable(var TempContractPriceUpdateLine: Record "Sub. Contr. Price Update Line" temporary; GroupBy: Enum "Contract Billing Grouping") var ContractPriceUpdateLine: Record "Sub. Contr. Price Update Line"; TempContractPriceUpdateLine2: Record "Sub. Contr. Price Update Line" temporary; begin TempContractPriceUpdateLine2.CopyFilters(TempContractPriceUpdateLine); ContractPriceUpdateLine.CopyFilters(TempContractPriceUpdateLine); TempContractPriceUpdateLine.Reset(); TempContractPriceUpdateLine.DeleteAll(false); LastGroupEntryNo := 0; SetKeysForGrouping(ContractPriceUpdateLine, TempContractPriceUpdateLine, GroupBy); if ContractPriceUpdateLine.FindSet() then repeat CreateGroupingLine(TempContractPriceUpdateLine, ContractPriceUpdateLine, GroupBy); TempContractPriceUpdateLine := ContractPriceUpdateLine; TempContractPriceUpdateLine.Indent := 1; TempContractPriceUpdateLine.Insert(false); until ContractPriceUpdateLine.Next() = 0; TempContractPriceUpdateLine.CopyFilters(TempContractPriceUpdateLine2); end; local procedure SetKeysForGrouping(var ContractPriceUpdateLine: Record "Sub. Contr. Price Update Line"; var TempContractPriceUpdateLine: Record "Sub. Contr. Price Update Line" temporary; GroupBy: Enum "Contract Billing Grouping") begin case GroupBy of GroupBy::Contract: begin ContractPriceUpdateLine.SetCurrentKey(Partner, "Subscription Contract No."); TempContractPriceUpdateLine.SetCurrentKey(Partner, "Subscription Contract No."); end; GroupBy::"Contract Partner": begin ContractPriceUpdateLine.SetCurrentKey(Partner, "Partner No."); TempContractPriceUpdateLine.SetCurrentKey(Partner, "Partner No."); end; GroupBy::None: TempContractPriceUpdateLine.SetCurrentKey("Entry No."); end; LastGroupByValue := ''; end; local procedure CreateGroupingLine(var TempContractPriceUpdateLine: Record "Sub. Contr. Price Update Line" temporary; ContractPriceUpdateLine: Record "Sub. Contr. Price Update Line"; GroupBy: Enum "Contract Billing Grouping") begin if GroupingLineShouldBeInserted(ContractPriceUpdateLine, GroupBy) then begin TempContractPriceUpdateLine.Init(); TempContractPriceUpdateLine."Entry No." := LastGroupEntryNo - 1; LastGroupEntryNo := TempContractPriceUpdateLine."Entry No."; TempContractPriceUpdateLine.Partner := ContractPriceUpdateLine.Partner; TempContractPriceUpdateLine."Partner No." := ContractPriceUpdateLine."Partner No."; TempContractPriceUpdateLine."Partner Name" := ContractPriceUpdateLine."Partner Name"; TempContractPriceUpdateLine."Sub. Contract Description" := ContractPriceUpdateLine."Sub. Contract Description"; if GroupBy = GroupBy::Contract then TempContractPriceUpdateLine."Subscription Contract No." := ContractPriceUpdateLine."Subscription Contract No."; TempContractPriceUpdateLine.Indent := 0; TempContractPriceUpdateLine.Insert(false); end; end; local procedure GroupingLineShouldBeInserted(ContractPriceUpdateLine: Record "Sub. Contr. Price Update Line"; GroupBy: Enum "Contract Billing Grouping") InsertLine: Boolean var NewGroupByValue: Code[20]; begin case GroupBy of GroupBy::Contract: NewGroupByValue := ContractPriceUpdateLine."Subscription Contract No."; GroupBy::"Contract Partner": NewGroupByValue := ContractPriceUpdateLine."Partner No."; end; InsertLine := LastGroupByValue <> NewGroupByValue; if InsertLine then LastGroupByValue := NewGroupByValue; end; internal procedure CreatePriceUpdateProposal(PriceUpdateTemplateCode: Code[20]; IncludeServiceCommitmentUpToDate: Date; PerformUpdateOnDate: Date) var PriceUpdateTemplate: Record "Price Update Template"; PriceUpdateProposalCannotBeCreateWithoutTemplateErr: Label 'Price Update Proposals cannot be created without a Price Update Template. Please select a template before.'; ContractPriceUpdate: Interface "Contract Price Update"; begin if PriceUpdateTemplateCode = '' then Error(PriceUpdateProposalCannotBeCreateWithoutTemplateErr); PriceUpdateTemplate.Get(PriceUpdateTemplateCode); ContractPriceUpdate := PriceUpdateTemplate."Price Update Method"; ContractPriceUpdate.SetPriceUpdateParameters(PriceUpdateTemplate, IncludeServiceCommitmentUpToDate, PerformUpdateOnDate); ContractPriceUpdate.ApplyFilterOnServiceCommitments(); ContractPriceUpdate.CreatePriceUpdateProposal(); end; internal procedure TestIncludeServiceCommitmentUpToDate(IncludeServiceCommitmentUpToDate: Date) var NoIncludeContractLinesUpToDateErr: Label 'Please enter the Include Contract Lines up to Date.'; begin if IncludeServiceCommitmentUpToDate = 0D then Error(NoIncludeContractLinesUpToDateErr); end; internal procedure GetAndApplyFiltersOnServiceCommitment(var ServiceCommitment: Record "Subscription Line"; PriceUpdateTemplate: Record "Price Update Template"; IncludeServiceCommitmentUpToDate: Date) var TempServiceCommitment: Record "Subscription Line" temporary; ServiceObjectFilterText: Text; ServiceCommitmentFilterText: Text; ContractFilterText: Text; begin ApplyDefaultFiltering(ServiceCommitment, PriceUpdateTemplate, IncludeServiceCommitmentUpToDate); InitTempServiceCommitmentTable(ServiceCommitment, TempServiceCommitment); if PriceUpdateTemplate."Subscription Contract Filter".HasValue() then ContractFilterText := PriceUpdateTemplate.ReadFilter(PriceUpdateTemplate.FieldNo("Subscription Contract Filter")); if PriceUpdateTemplate."Subscription Filter".HasValue() then ServiceObjectFilterText := PriceUpdateTemplate.ReadFilter(PriceUpdateTemplate.FieldNo("Subscription Filter")); if PriceUpdateTemplate."Subscription Line Filter".HasValue() then ServiceCommitmentFilterText := PriceUpdateTemplate.ReadFilter(PriceUpdateTemplate.FieldNo("Subscription Line Filter")); if ServiceCommitmentFilterText <> '' then begin ServiceCommitment.SetView(ServiceCommitmentFilterText); ApplyDefaultFiltering(ServiceCommitment, PriceUpdateTemplate, IncludeServiceCommitmentUpToDate); FindAndMarkMatchedAndDeleteUnmarkedServiceCommitment(ServiceCommitment, TempServiceCommitment); end; if ServiceObjectFilterText <> '' then begin FilterAndMarkServiceCommitmentOnServiceObject(ServiceCommitment, ServiceObjectFilterText, PriceUpdateTemplate, IncludeServiceCommitmentUpToDate); FindAndMarkMatchedAndDeleteUnmarkedServiceCommitment(ServiceCommitment, TempServiceCommitment); end; if ContractFilterText <> '' then begin FilterAndMarkServiceCommitmentOnContract(ServiceCommitment, ContractFilterText, PriceUpdateTemplate, IncludeServiceCommitmentUpToDate); FindAndMarkMatchedAndDeleteUnmarkedServiceCommitment(ServiceCommitment, TempServiceCommitment); end; MarkServiceCommitmentsFromTempTable(ServiceCommitment, TempServiceCommitment); OnAfterFilterSubscriptionLineOnAfterGetAndApplyFiltersOnSubscriptionLine(ServiceCommitment); end; local procedure ApplyDefaultFiltering(var ServiceCommitment: Record "Subscription Line"; PriceUpdateTemplate: Record "Price Update Template"; IncludeServiceCommitmentUpToDate: Date) begin // The mandatory defaults are set in a separate filter group so that they intersect with the filters // stored on the Price Update Template instead of replacing them field by field. ServiceCommitment.FilterGroup(2); ServiceCommitment.SetRange(Partner, PriceUpdateTemplate.Partner); ServiceCommitment.SetRange("Exclude from Price Update", false); ServiceCommitment.SetRange("Invoicing via", Enum::"Invoicing Via"::Contract); ServiceCommitment.SetFilter("Next Price Update", '<=%1|%2', IncludeServiceCommitmentUpToDate, 0D); ServiceCommitment.SetRange("Planned Sub. Line exists", false); ServiceCommitment.SetRange("Usage Based Billing", false); ServiceCommitment.SetRange(Closed, false); ServiceCommitment.FilterGroup(0); end; // ServiceCommitment must be passed by reference: an AL record parameter passed by value does not // carry the caller's filters, so the temporary table would be seeded from the whole table instead of // from the filtering ApplyDefaultFiltering applied. Proven by // TestSubscriptionLineFilterCannotWidenDefaultFilteringOnNextPriceUpdate. local procedure InitTempServiceCommitmentTable(var ServiceCommitment: Record "Subscription Line"; var TempServiceCommitment: Record "Subscription Line" temporary) begin TempServiceCommitment.Reset(); TempServiceCommitment.DeleteAll(false); if ServiceCommitment.FindSet() then repeat TempServiceCommitment := ServiceCommitment; TempServiceCommitment.Insert(false); until ServiceCommitment.Next() = 0; end; local procedure FindAndMarkMatchedAndDeleteUnmarkedServiceCommitment(var ServiceCommitment: Record "Subscription Line"; var TempServiceCommitment: Record "Subscription Line" temporary) begin if ServiceCommitment.FindSet() then repeat if TempServiceCommitment.Get(ServiceCommitment."Entry No.") then TempServiceCommitment.Mark(true); until ServiceCommitment.Next() = 0; DeleteUnmarkedTempServiceCommitment(TempServiceCommitment); end; local procedure DeleteUnmarkedTempServiceCommitment(var TempServiceCommitment: Record "Subscription Line" temporary) begin if TempServiceCommitment.FindSet() then repeat if not TempServiceCommitment.Mark() then TempServiceCommitment.Delete(false); until TempServiceCommitment.Next() = 0; TempServiceCommitment.Reset(); end; local procedure FilterAndMarkServiceCommitmentOnServiceObject(var ServiceCommitment: Record "Subscription Line"; ServiceObjectFilterText: Text; PriceUpdateTemplate: Record "Price Update Template"; IncludeServiceCommitmentUpToDate: Date) var ServiceObject: Record "Subscription Header"; begin ServiceCommitment.Reset(); ServiceObject.SetView(ServiceObjectFilterText); ServiceObject.SetLoadFields("No."); if ServiceObject.FindSet() then repeat ServiceCommitment.SetRange("Subscription Header No.", ServiceObject."No."); ApplyDefaultFiltering(ServiceCommitment, PriceUpdateTemplate, IncludeServiceCommitmentUpToDate); if ServiceCommitment.FindSet() then repeat ServiceCommitment.Mark(true); until ServiceCommitment.Next() = 0; until ServiceObject.Next() = 0; ServiceCommitment.SetRange("Subscription Header No."); ServiceCommitment.MarkedOnly(true); end; local procedure FilterAndMarkServiceCommitmentOnContract(var ServiceCommitment: Record "Subscription Line"; ContractFilterText: Text; PriceUpdateTemplate: Record "Price Update Template"; IncludeServiceCommitmentUpToDate: Date) var VendorContract: Record "Vendor Subscription Contract"; CustomerContract: Record "Customer Subscription Contract"; begin ServiceCommitment.Reset(); case PriceUpdateTemplate.Partner of "Service Partner"::Customer: begin CustomerContract.SetView(ContractFilterText); if CustomerContract.FindSet() then repeat ApplyContractFilterAndMarkServiceCommitment(ServiceCommitment, CustomerContract."No.", PriceUpdateTemplate, IncludeServiceCommitmentUpToDate) until CustomerContract.Next() = 0; end; "Service Partner"::Vendor: begin VendorContract.SetView(ContractFilterText); if VendorContract.FindSet() then repeat ApplyContractFilterAndMarkServiceCommitment(ServiceCommitment, VendorContract."No.", PriceUpdateTemplate, IncludeServiceCommitmentUpToDate) until VendorContract.Next() = 0; end; end; ServiceCommitment.SetRange(Partner); ServiceCommitment.SetRange("Subscription Contract No."); ServiceCommitment.MarkedOnly(true); end; local procedure ApplyContractFilterAndMarkServiceCommitment(var ServiceCommitment: Record "Subscription Line"; ContractNo: Code[20]; PriceUpdateTemplate: Record "Price Update Template"; IncludeServiceCommitmentUpToDate: Date) begin ServiceCommitment.FilterOnContract(PriceUpdateTemplate.Partner, ContractNo); ApplyDefaultFiltering(ServiceCommitment, PriceUpdateTemplate, IncludeServiceCommitmentUpToDate); if ServiceCommitment.FindSet() then repeat ServiceCommitment.Mark(true); until ServiceCommitment.Next() = 0; end; local procedure MarkServiceCommitmentsFromTempTable(var ServiceCommitment: Record "Subscription Line"; var TempServiceCommitment: Record "Subscription Line" temporary) begin // Reset() also clears the mandatory defaults that ApplyDefaultFiltering sets in filter group 2. // Keep it: the record is handed back to the callers and to the integration event below, and must // not carry filters that GetFilters() does not show them. ServiceCommitment.Reset(); if TempServiceCommitment.FindSet() then repeat ServiceCommitment.Get(TempServiceCommitment."Entry No."); ServiceCommitment.Mark(true); until TempServiceCommitment.Next() = 0; ServiceCommitment.MarkedOnly(true); end; internal procedure DeleteProposal(PriceUpdateTemplateCode: Code[20]) var ContractPriceUpdateLine: Record "Sub. Contr. Price Update Line"; ClearContractPriceUpdateProposalOptionsTxt: Label 'All Price Update Lines, Only current Price Update Template'; ClearContractPriceUpdateProposalQst: Label 'Which Price Update lines(s) should be deleted?'; StrMenuResponse: Integer; begin StrMenuResponse := Dialog.StrMenu(ClearContractPriceUpdateProposalOptionsTxt, 1, ClearContractPriceUpdateProposalQst); case StrMenuResponse of 0: Error(''); 1: ContractPriceUpdateLine.DeleteAll(true); 2: begin ContractPriceUpdateLine.SetRange("Price Update Template Code", PriceUpdateTemplateCode); DeleteContractPriceUpdateLines(ContractPriceUpdateLine); end; end; end; internal procedure DeleteContractPriceUpdateLines(var ContractPriceUpdateLine: Record "Sub. Contr. Price Update Line") begin if not ContractPriceUpdateLine.IsEmpty() then ContractPriceUpdateLine.DeleteAll(true) end; internal procedure PerformPriceUpdate() var ContractPriceUpdateLine: Record "Sub. Contr. Price Update Line"; begin if ContractPriceUpdateLine.FindSet() then repeat Commit(); // Commit before if Codeunit.Run if Codeunit.Run(Codeunit::"Process Price Update", ContractPriceUpdateLine) then ContractPriceUpdateLine.Delete(false); until ContractPriceUpdateLine.Next() = 0; end; [IntegrationEvent(false, false)] local procedure OnAfterFilterSubscriptionLineOnAfterGetAndApplyFiltersOnSubscriptionLine(var SubscriptionLine: Record "Subscription Line") begin end;}