Codeunit 130510 Library - Price Calculation
src/Layers/W1/Tests/ApplicationTestLibrary/LibraryPriceCalculation.Codeunit.al409 lines, Copyright (c) Microsoft Corporation. MIT
/// <summary>/// Provides utility functions for creating and managing price calculation setup and testing various pricing scenarios./// </summary>codeunit 130510 "Library - Price Calculation"{ EventSubscriberInstance = Manual; trigger OnRun() begin end; var LibraryPriceCalculation: Codeunit "Library - Price Calculation"; LibraryRandom: Codeunit "Library - Random"; LibraryUtility: Codeunit "Library - Utility"; LastHandlerId: Enum "Price Calculation Handler"; DefaultPriceListTok: Label 'Default price list.'; procedure AddSetup(var PriceCalculationSetup: Record "Price Calculation Setup"; NewMethod: Enum "Price Calculation Method"; PriceType: Enum "Price Type"; AssetType: Enum "Price Asset Type"; NewImplementation: Enum "Price Calculation Handler"; NewDefault: Boolean): Code[100]; begin PriceCalculationSetup.Init(); PriceCalculationSetup.Method := NewMethod; PriceCalculationSetup.Type := PriceType; PriceCalculationSetup."Asset Type" := AssetType; PriceCalculationSetup.Implementation := NewImplementation; PriceCalculationSetup.Default := NewDefault; PriceCalculationSetup.Enabled := true; PriceCalculationSetup.Insert(true); exit(PriceCalculationSetup.Code) end; procedure FindOrAddSetup(var PriceCalculationSetup: Record "Price Calculation Setup"; NewMethod: Enum "Price Calculation Method"; PriceType: Enum "Price Type"; AssetType: Enum "Price Asset Type"; NewImplementation: Enum "Price Calculation Handler"; NewDefault: Boolean): Code[100]; begin PriceCalculationSetup.SetRange(Method, NewMethod); PriceCalculationSetup.SetRange(Type, PriceType); PriceCalculationSetup.SetRange("Asset Type", AssetType); PriceCalculationSetup.SetRange(Implementation, NewImplementation); if not PriceCalculationSetup.FindFirst() then begin PriceCalculationSetup.Reset(); exit(AddSetup(PriceCalculationSetup, NewMethod, PriceType, AssetType, NewImplementation, NewDefault)); end; PriceCalculationSetup.Reset(); exit(PriceCalculationSetup.Code); end; procedure AddDtldSetup(var DtldPriceCalculationSetup: Record "Dtld. Price Calculation Setup"; PriceType: Enum "Price Type"; AssetType: Enum "Price Asset Type"; AssetNo: code[20]; SourceGroup: Enum "Price Source Group"; SourceNo: Code[20]) begin if DtldPriceCalculationSetup.IsTemporary then DtldPriceCalculationSetup."Line No." += 1 else DtldPriceCalculationSetup."Line No." := 0; DtldPriceCalculationSetup.Type := PriceType; DtldPriceCalculationSetup."Asset Type" := AssetType; DtldPriceCalculationSetup."Asset No." := AssetNo; DtldPriceCalculationSetup.Validate("Source Group", SourceGroup); DtldPriceCalculationSetup."Source No." := SourceNo; DtldPriceCalculationSetup.Enabled := true; DtldPriceCalculationSetup.Insert(true); end; procedure AddDtldSetup(var DtldPriceCalculationSetup: Record "Dtld. Price Calculation Setup"; SetupCode: Code[100]; AssetNo: code[20]; SourceGroup: Enum "Price Source Group"; SourceNo: Code[20]) begin if DtldPriceCalculationSetup.IsTemporary then DtldPriceCalculationSetup."Line No." += 1 else DtldPriceCalculationSetup."Line No." := 0; DtldPriceCalculationSetup.Validate("Setup Code", SetupCode); DtldPriceCalculationSetup."Asset No." := AssetNo; DtldPriceCalculationSetup.Validate("Source Group", SourceGroup); DtldPriceCalculationSetup."Source No." := SourceNo; DtldPriceCalculationSetup.Enabled := true; DtldPriceCalculationSetup.Insert(true); end; procedure DisableSetup(var PriceCalculationSetup: Record "Price Calculation Setup") begin PriceCalculationSetup.Enabled := false; PriceCalculationSetup.Modify(); end; procedure DisableDtldSetup(var DtldPriceCalculationSetup: Record "Dtld. Price Calculation Setup") begin DtldPriceCalculationSetup.Enabled := false; DtldPriceCalculationSetup.Modify(); end; procedure DisableExtendedPriceCalculation() begin // turn off ExtendedPriceCalculationEnabledHandler UnbindSubscription(LibraryPriceCalculation); end; procedure EnableExtendedPriceCalculation() begin // turn on ExtendedPriceCalculationEnabledHandler UnbindSubscription(LibraryPriceCalculation); BindSubscription(LibraryPriceCalculation); end; procedure EnableExtendedPriceCalculation(Enable: Boolean) begin // turn on/off ExtendedPriceCalculationEnabledHandler UnbindSubscription(LibraryPriceCalculation); if Enable then BindSubscription(LibraryPriceCalculation); end; procedure SetupDefaultHandler(NewImplementation: Enum "Price Calculation Handler") xImplementation: Enum "Price Calculation Handler"; var PriceCalculationSetup: Record "Price Calculation Setup"; PriceCalculationMgt: Codeunit "Price Calculation Mgt."; begin if LastHandlerId = NewImplementation then exit; PriceCalculationSetup.SetRange(Default, true); if PriceCalculationSetup.FindFirst() then xImplementation := PriceCalculationSetup.Implementation else xImplementation := NewImplementation; PriceCalculationSetup.Reset(); PriceCalculationSetup.DeleteAll(); PriceCalculationMgt.Run(); PriceCalculationSetup.Modifyall(Default, false); PriceCalculationSetup.SetRange(Implementation, NewImplementation); PriceCalculationSetup.Modifyall(Default, true, true); LastHandlerId := NewImplementation; end; procedure AllowEditingActiveSalesPrice() begin AllowEditingActiveSalesPrice(true); end; local procedure AllowEditingActiveSalesPrice(AllowEditingActivePrice: Boolean) var SalesReceivablesSetup: Record "Sales & Receivables Setup"; begin SalesReceivablesSetup.Get(); SalesReceivablesSetup."Allow Editing Active Price" := AllowEditingActivePrice; SalesReceivablesSetup.Modify(); end; procedure AllowEditingActivePurchPrice() begin AllowEditingActivePurchPrice(true); end; local procedure AllowEditingActivePurchPrice(AllowEditingActivePrice: Boolean) var PurchasesPayablesSetup: Record "Purchases & Payables Setup"; begin PurchasesPayablesSetup.Get(); PurchasesPayablesSetup."Allow Editing Active Price" := AllowEditingActivePrice; PurchasesPayablesSetup.Modify(); end; procedure DisallowEditingActiveSalesPrice() begin AllowEditingActiveSalesPrice(false); end; procedure DisallowEditingActivePurchPrice() begin AllowEditingActivePurchPrice(false); end; local procedure CreateDefaultPriceList(PriceType: Enum "Price Type"; SourceGroup: Enum "Price Source Group"): Code[20] var PriceListHeader: Record "Price List Header"; begin PriceListHeader.Validate("Price Type", PriceType); PriceListHeader.Validate("Source Group", SourceGroup); PriceListHeader.Description := DefaultPriceListTok; case SourceGroup of SourceGroup::Customer: PriceListHeader.Validate("Source Type", PriceListHeader."Source Type"::"All Customers"); SourceGroup::Vendor: PriceListHeader.Validate("Source Type", PriceListHeader."Source Type"::"All Vendors"); SourceGroup::Job: PriceListHeader.Validate("Source Type", PriceListHeader."Source Type"::"All Jobs"); end; PriceListHeader."Allow Updating Defaults" := true; PriceListHeader.Status := "Price Status"::Active; if PriceListHeader.Insert(true) then exit(PriceListHeader.Code); end; procedure SetDefaultPriceList(PriceType: Enum "Price Type"; SourceGroup: Enum "Price Source Group") DefaultPriceListCode: Code[20]; begin case SourceGroup of SourceGroup::Customer: DefaultPriceListCode := DefineSalesDefaultPriceList(); SourceGroup::Vendor: DefaultPriceListCode := DefinePurchDefaultPriceList(); SourceGroup::Job: DefaultPriceListCode := DefineJobDefaultPriceList(PriceType); end end; local procedure DefineJobDefaultPriceList(PriceType: Enum "Price Type") DefaultPriceListCode: Code[20]; var JobsSetup: Record "Jobs Setup"; begin JobsSetup.Get(); DefaultPriceListCode := CreateDefaultPriceList(PriceType, "Price Source Group"::Job); case PriceType of PriceType::Purchase: JobsSetup."Default Purch Price List Code" := DefaultPriceListCode; PriceType::Sale: JobsSetup."Default Sales Price List Code" := DefaultPriceListCode; end; JobsSetup.Modify(); end; local procedure DefinePurchDefaultPriceList() DefaultPriceListCode: Code[20]; var PurchasesPayablesSetup: Record "Purchases & Payables Setup"; begin PurchasesPayablesSetup.Get(); DefaultPriceListCode := CreateDefaultPriceList("Price Type"::Purchase, "Price Source Group"::Vendor); PurchasesPayablesSetup."Default Price List Code" := DefaultPriceListCode; PurchasesPayablesSetup."Allow Editing Active Price" := true; PurchasesPayablesSetup.Modify(); end; local procedure DefineSalesDefaultPriceList() DefaultPriceListCode: Code[20]; var SalesReceivablesSetup: Record "Sales & Receivables Setup"; begin SalesReceivablesSetup.Get(); DefaultPriceListCode := CreateDefaultPriceList("Price Type"::Sale, "Price Source Group"::Customer); SalesReceivablesSetup."Default Price List Code" := DefaultPriceListCode; SalesReceivablesSetup."Allow Editing Active Price" := true; SalesReceivablesSetup.Modify(); exit(SalesReceivablesSetup."Default Price List Code"); end; procedure ClearDefaultPriceList(PriceType: Enum "Price Type"; SourceGroup: Enum "Price Source Group") var JobsSetup: Record "Jobs Setup"; PurchasesPayablesSetup: Record "Purchases & Payables Setup"; SalesReceivablesSetup: Record "Sales & Receivables Setup"; begin case SourceGroup of SourceGroup::Job: begin JobsSetup.Get(); case PriceType of PriceType::Purchase: JobsSetup."Default Purch Price List Code" := ''; PriceType::Sale: JobsSetup."Default Sales Price List Code" := ''; end; JobsSetup.Modify(); end; SourceGroup::Vendor: begin PurchasesPayablesSetup.Get(); PurchasesPayablesSetup."Default Price List Code" := ''; PurchasesPayablesSetup.Modify(); end; SourceGroup::Customer: begin SalesReceivablesSetup.Get(); SalesReceivablesSetup."Default Price List Code" := ''; SalesReceivablesSetup.Modify(); end; end; end; procedure SetUseCustomLookup(NewValue: Boolean) OldValue: Boolean; var SalesReceivablesSetup: Record "Sales & Receivables Setup"; begin SalesReceivablesSetup.Get(); OldValue := SalesReceivablesSetup."Use Customized Lookup"; if OldValue = NewValue then exit; SalesReceivablesSetup."Use Customized Lookup" := NewValue; SalesReceivablesSetup.Modify(); end; procedure SetMethodInSalesSetup() var SalesReceivablesSetup: Record "Sales & Receivables Setup"; begin SalesReceivablesSetup.Get(); SalesReceivablesSetup."Price Calculation Method" := SalesReceivablesSetup."Price Calculation Method"::"Lowest Price"; SalesReceivablesSetup.Modify(); end; procedure SetMethodInPurchSetup() var PurchasesPayablesSetup: Record "Purchases & Payables Setup"; begin PurchasesPayablesSetup.Get(); PurchasesPayablesSetup."Price Calculation Method" := PurchasesPayablesSetup."Price Calculation Method"::"Lowest Price"; PurchasesPayablesSetup.Modify(); end; procedure CreatePriceHeader(var PriceListHeader: Record "Price List Header"; PriceType: Enum "Price Type"; SourceType: Enum "Price Source Type"; SourceNo: code[20]) begin PriceListHeader.Init(); PriceListHeader.Code := LibraryUtility.GenerateGUID(); PriceListHeader.Description := StrSubstNo('%1%2', PriceListHeader.FieldName(Description), PriceListHeader.Code); PriceListHeader."Price Type" := PriceType; PriceListHeader.Validate("Source Type", SourceType); PriceListHeader.Validate("Source No.", SourceNo); PriceListHeader.Insert(true); end; procedure CreatePriceHeader(var PriceListHeader: Record "Price List Header"; PriceType: Enum "Price Type"; SourceType: Enum "Price Source Type"; ParentSourceNo: code[20]; SourceNo: code[20]) begin PriceListHeader.Init(); PriceListHeader.Code := LibraryUtility.GenerateGUID(); PriceListHeader.Description := StrSubstNo('%1%2', PriceListHeader.FieldName(Description), PriceListHeader.Code); PriceListHeader."Price Type" := PriceType; PriceListHeader.Validate("Source Type", SourceType); PriceListHeader.Validate("Parent Source No.", ParentSourceNo); PriceListHeader.Validate("Source No.", SourceNo); PriceListHeader.Insert(true); end; procedure CreatePriceListLine(var PriceListLine: Record "Price List Line"; PriceListHeader: Record "Price List Header"; AmountType: Enum "Price Amount Type"; AssetType: enum "Price Asset Type"; AssetNo: Code[20]) begin CreatePriceListLine( PriceListLine, PriceListHeader.Code, PriceListHeader."Price Type", PriceListHeader."Source Type", PriceListHeader."Parent Source No.", PriceListHeader."Source No.", AmountType, AssetType, AssetNo); end; procedure CreatePriceListLine(var PriceListLine: Record "Price List Line"; PriceListCode: Code[20]; PriceType: Enum "Price Type"; SourceType: Enum "Price Source Type"; SourceNo: Code[20]; AmountType: Enum "Price Amount Type"; AssetType: enum "Price Asset Type"; AssetNo: Code[20]) begin // to skip blank "Parent Source No." CreatePriceListLine( PriceListLine, PriceListCode, PriceType, SourceType, '', SourceNo, AmountType, AssetType, AssetNo); end; procedure CreatePriceListLine(var PriceListLine: Record "Price List Line"; PriceListCode: Code[20]; PriceType: Enum "Price Type"; SourceType: Enum "Price Source Type"; ParentSourceNo: Code[20]; SourceNo: Code[20]; AmountType: Enum "Price Amount Type"; AssetType: enum "Price Asset Type"; AssetNo: Code[20]) begin PriceListLine.Init(); PriceListLine."Line No." := 0; PriceListLine."Price List Code" := PriceListCode; PriceListLine."Price Type" := PriceType; PriceListLine.Validate("Source Type", SourceType); PriceListLine.Validate("Parent Source No.", ParentSourceNo); PriceListLine.Validate("Source No.", SourceNo); PriceListLine.Validate("Asset Type", AssetType); PriceListLine.Validate("Asset No.", AssetNo); PriceListLine.Validate("Amount Type", AmountType); if AmountType in [AmountType::Discount, AmountType::Any] then PriceListLine.Validate("Line Discount %", LibraryRandom.RandDec(100, 2)); if AmountType in [AmountType::Price, AmountType::Any] then case PriceType of PriceType::Sale: PriceListLine.Validate("Unit Price", LibraryRandom.RandDec(1000, 2)); PriceType::Purchase: PriceListLine.Validate("Direct Unit Cost", LibraryRandom.RandDec(1000, 2)); end; PriceListLine.Insert(true); end; procedure CreatePurchDiscountLine(var PriceListLine: Record "Price List Line"; PriceListCode: Code[20]; SourceType: Enum "Price Source Type"; SourceNo: code[20]; AssetType: enum "Price Asset Type"; AssetNo: Code[20]) begin CreatePriceListLine( PriceListLine, PriceListCode, PriceListLine."Price Type"::Purchase, SourceType, SourceNo, PriceListLine."Amount Type"::Discount, AssetType, AssetNo); end; procedure CreatePurchPriceLine(var PriceListLine: Record "Price List Line"; PriceListCode: Code[20]; SourceType: Enum "Price Source Type"; SourceNo: code[20]; AssetType: enum "Price Asset Type"; AssetNo: Code[20]) begin CreatePriceListLine( PriceListLine, PriceListCode, PriceListLine."Price Type"::Purchase, SourceType, SourceNo, PriceListLine."Amount Type"::Price, AssetType, AssetNo); end; procedure CreateSalesDiscountLine(var PriceListLine: Record "Price List Line"; PriceListCode: Code[20]; SourceType: Enum "Price Source Type"; SourceNo: code[20]; AssetType: enum "Price Asset Type"; AssetNo: Code[20]) begin CreatePriceListLine( PriceListLine, PriceListCode, PriceListLine."Price Type"::Sale, SourceType, SourceNo, PriceListLine."Amount Type"::Discount, AssetType, AssetNo); end; procedure CreateSalesPriceLine(var PriceListLine: Record "Price List Line"; PriceListCode: Code[20]; SourceType: Enum "Price Source Type"; SourceNo: code[20]; AssetType: enum "Price Asset Type"; AssetNo: Code[20]) begin CreatePriceListLine( PriceListLine, PriceListCode, PriceListLine."Price Type"::Sale, SourceType, SourceNo, PriceListLine."Amount Type"::Price, AssetType, AssetNo); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Price Calculation Mgt.", 'OnIsExtendedPriceCalculationEnabled', '', false, false)] procedure ExtendedPriceCalculationEnabledHandler(var Result: Boolean); begin Result := true; end;}