Report 7052 Suggest Sales Price on Wksh.
src/Layers/W1/BaseApp/Sales/Pricing/SuggestSalesPriceonWksh.Report.al570 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.Sales.Pricing;using Microsoft.CRM.Campaign;using Microsoft.Finance.Currency;using Microsoft.Foundation.UOM;using Microsoft.Inventory.Item;using Microsoft.Sales.Customer;using Microsoft.Utilities;/// <summary>/// Suggests sales price worksheet entries based on existing sales prices with optional adjustment factors and currency conversion./// </summary>report 7052 "Suggest Sales Price on Wksh."{ Caption = 'Suggest Sales Price on Wksh.'; ProcessingOnly = true; dataset { dataitem("Sales Price"; "Sales Price") { DataItemTableView = sorting("Item No."); RequestFilterFields = "Sales Type", "Sales Code", "Item No.", "Currency Code", "Starting Date"; trigger OnAfterGetRecord() var IsHandled: Boolean; SkipRecord: Boolean; begin if Item."No." <> "Item No." then begin Item.Get("Item No."); Window.Update(1, "Item No."); end; ReplaceSalesCode := not (("Sales Type" = ToSalesType) and ("Sales Code" = ToSalesCode)); if (ToSalesCode = '') and (ToSalesType <> ToSalesType::"All Customers") then Error(Text002, "Sales Type"); SkipRecord := false; OnSalesPriceOnAfterGetRecordOnAfterCheck("Sales Price", Item, SkipRecord); if SkipRecord then CurrReport.Skip(); Clear(SalesPriceWksh); SalesPriceWksh.Validate("Sales Type", ToSalesType); if not ReplaceSalesCode then SalesPriceWksh.Validate("Sales Code", "Sales Code") else SalesPriceWksh.Validate("Sales Code", ToSalesCode); SalesPriceWksh.Validate("Item No.", "Item No."); SalesPriceWksh."New Unit Price" := "Unit Price"; SalesPriceWksh."Minimum Quantity" := "Minimum Quantity"; if not ReplaceUnitOfMeasure then SalesPriceWksh."Unit of Measure Code" := "Unit of Measure Code" else begin SalesPriceWksh."Unit of Measure Code" := ToUnitOfMeasure.Code; if not (SalesPriceWksh."Unit of Measure Code" in ['', Item."Base Unit of Measure"]) then if not ItemUnitOfMeasure.Get("Item No.", SalesPriceWksh."Unit of Measure Code") then CurrReport.Skip(); SalesPriceWksh."New Unit Price" := SalesPriceWksh."New Unit Price" * UOMMgt.GetQtyPerUnitOfMeasure(Item, SalesPriceWksh."Unit of Measure Code") / UOMMgt.GetQtyPerUnitOfMeasure(Item, "Unit of Measure Code"); end; SalesPriceWksh.Validate("Unit of Measure Code"); SalesPriceWksh.Validate("Variant Code", "Variant Code"); if not ReplaceCurrency then SalesPriceWksh."Currency Code" := "Currency Code" else SalesPriceWksh."Currency Code" := ToCurrency.Code; if not ReplaceStartingDate then begin if not ReplaceEndingDate then SalesPriceWksh.Validate("Starting Date", "Starting Date") end else SalesPriceWksh.Validate("Starting Date", ToStartDate); if not ReplaceEndingDate then begin if not ReplaceStartingDate then SalesPriceWksh.Validate("Ending Date", "Ending Date") end else SalesPriceWksh.Validate("Ending Date", ToEndDate); if "Currency Code" <> SalesPriceWksh."Currency Code" then begin if "Currency Code" <> '' then begin FromCurrency.Get("Currency Code"); FromCurrency.TestField(Code); SalesPriceWksh."New Unit Price" := CurrExchRate.ExchangeAmtFCYToLCY( WorkDate(), "Currency Code", SalesPriceWksh."New Unit Price", CurrExchRate.ExchangeRate( WorkDate(), "Currency Code")); end; if SalesPriceWksh."Currency Code" <> '' then SalesPriceWksh."New Unit Price" := CurrExchRate.ExchangeAmtLCYToFCY( WorkDate(), SalesPriceWksh."Currency Code", SalesPriceWksh."New Unit Price", CurrExchRate.ExchangeRate( WorkDate(), SalesPriceWksh."Currency Code")); end; if SalesPriceWksh."Currency Code" = '' then Currency2.InitRoundingPrecision() else begin Currency2.Get(SalesPriceWksh."Currency Code"); Currency2.TestField("Unit-Amount Rounding Precision"); end; SalesPriceWksh."New Unit Price" := Round(SalesPriceWksh."New Unit Price", Currency2."Unit-Amount Rounding Precision"); IsHandled := false; OnBeforeSetNewUnitPriceAbovePriceLimit(SalesPriceWksh, PriceLowerLimit, IsHandled); if not IsHandled then if SalesPriceWksh."New Unit Price" > PriceLowerLimit then SalesPriceWksh."New Unit Price" := SalesPriceWksh."New Unit Price" * UnitPriceFactor; if RoundingMethod.Code <> '' then begin RoundingMethod."Minimum Amount" := SalesPriceWksh."New Unit Price"; if RoundingMethod.Find('=<') then begin SalesPriceWksh."New Unit Price" := SalesPriceWksh."New Unit Price" + RoundingMethod."Amount Added Before"; if RoundingMethod.Precision > 0 then SalesPriceWksh."New Unit Price" := Round( SalesPriceWksh."New Unit Price", RoundingMethod.Precision, CopyStr('=><', RoundingMethod.Type + 1, 1)); SalesPriceWksh."New Unit Price" := SalesPriceWksh."New Unit Price" + RoundingMethod."Amount Added After"; end; end; if ToSalesType = ToSalesType::"Customer Price Group" then begin SalesPriceWksh."Price Includes VAT" := ToCustPriceGr."Price Includes VAT"; SalesPriceWksh."VAT Bus. Posting Gr. (Price)" := ToCustPriceGr."VAT Bus. Posting Gr. (Price)"; SalesPriceWksh."Allow Invoice Disc." := ToCustPriceGr."Allow Invoice Disc."; SalesPriceWksh."Allow Line Disc." := ToCustPriceGr."Allow Line Disc."; end else begin SalesPriceWksh."Price Includes VAT" := "Price Includes VAT"; SalesPriceWksh."VAT Bus. Posting Gr. (Price)" := "VAT Bus. Posting Gr. (Price)"; SalesPriceWksh."Allow Invoice Disc." := "Allow Invoice Disc."; SalesPriceWksh."Allow Line Disc." := "Allow Line Disc."; end; SalesPriceWksh.CalcCurrentPrice(PriceAlreadyExists); OnBeforeModifyOrInsertSalesPriceWksh( SalesPriceWksh, "Sales Price", UnitPriceFactor, PriceLowerLimit, RoundingMethod, CreateNewPrices); if PriceAlreadyExists or CreateNewPrices then begin TempSalesPriceWksh := SalesPriceWksh; if not TempSalesPriceWksh.Insert() then Error(SalesPriceWkshLineExistsErr, TempSalesPriceWksh.RecordId); SalesPriceWksh2 := SalesPriceWksh; if SalesPriceWksh2.Find('=') then SalesPriceWksh.Modify(true) else SalesPriceWksh.Insert(true); end; end; trigger OnPreDataItem() begin Window.Open(Text001); end; } } requestpage { SaveValues = true; layout { area(content) { group(Options) { Caption = 'Options'; group("Copy to Sales Price Worksheet...") { Caption = 'Copy to Sales Price Worksheet...'; field(SalesType; ToSalesType) { ApplicationArea = Basic, Suite; Caption = 'Sales Type'; ToolTip = 'Specifies the sales type that the sales price agreement will be copied to. To see the existing sales types, click the field.'; trigger OnValidate() begin SalesCodeCtrlEnable := ToSalesType <> ToSalesType::"All Customers"; ToStartDateCtrlEnable := ToSalesType <> ToSalesType::Campaign; ToEndDateCtrlEnable := ToSalesType <> ToSalesType::Campaign; ToSalesCode := ''; ToStartDate := 0D; ToEndDate := 0D; end; } field(SalesCodeCtrl; ToSalesCode) { ApplicationArea = Basic, Suite; Caption = 'Sales Code'; Enabled = SalesCodeCtrlEnable; ToolTip = 'Specifies the code for the sales type that the sales prices will be copied to. To see the existing sales codes, click the field.'; trigger OnLookup(var Text: Text): Boolean var CustList: Page "Customer List"; CustPriceGrList: Page "Customer Price Groups"; CampaignList: Page "Campaign List"; begin case ToSalesType of ToSalesType::Customer: begin CustList.LookupMode := true; CustList.SetRecord(ToCust); if CustList.RunModal() = ACTION::LookupOK then begin CustList.GetRecord(ToCust); ToSalesCode := ToCust."No."; end; end; ToSalesType::"Customer Price Group": begin CustPriceGrList.LookupMode := true; CustPriceGrList.SetRecord(ToCustPriceGr); if CustPriceGrList.RunModal() = ACTION::LookupOK then begin CustPriceGrList.GetRecord(ToCustPriceGr); ToSalesCode := ToCustPriceGr.Code; end; end; ToSalesType::Campaign: begin CampaignList.LookupMode := true; CampaignList.SetRecord(ToCampaign); if CampaignList.RunModal() = ACTION::LookupOK then begin CampaignList.GetRecord(ToCampaign); ToSalesCode := ToCampaign."No."; ToStartDate := ToCampaign."Starting Date"; ToEndDate := ToCampaign."Ending Date"; end; end; end; end; trigger OnValidate() var Customer: Record Customer; CustomerPriceGroup: Record "Customer Price Group"; Campaign: Record Campaign; begin if ToSalesType = ToSalesType::"All Customers" then exit; case ToSalesType of ToSalesType::Customer: Customer.Get(ToSalesCode); ToSalesType::"Customer Price Group": CustomerPriceGroup.Get(ToSalesCode); ToSalesType::Campaign: begin Campaign.Get(ToSalesCode); ToStartDate := Campaign."Starting Date"; ToEndDate := Campaign."Ending Date"; end; end; end; } field(UnitOfMeasureCode; ToUnitOfMeasure.Code) { ApplicationArea = Basic, Suite; Caption = 'Unit of Measure Code'; TableRelation = "Unit of Measure"; ToolTip = 'Specifies the unit of measure that the item is shown in.'; trigger OnValidate() begin if ToUnitOfMeasure.Code <> '' then ToUnitOfMeasure.Find(); end; } field(CurrencyCode; ToCurrency.Code) { ApplicationArea = Basic, Suite; Caption = 'Currency Code'; TableRelation = Currency; ToolTip = 'Specifies the code for the currency that amounts are shown in.'; trigger OnValidate() begin if ToCurrency.Code <> '' then ToCurrency.Find(); end; } field(ToStartDateCtrl; ToStartDate) { ApplicationArea = Basic, Suite; Caption = 'Starting Date'; Enabled = ToStartDateCtrlEnable; ToolTip = 'Specifies the date when the price changes will take effect.'; } field(ToEndDateCtrl; ToEndDate) { ApplicationArea = Basic, Suite; Caption = 'Ending Date'; Enabled = ToEndDateCtrlEnable; ToolTip = 'Specifies the date to which the price changes are valid.'; } } field(OnlyPricesAbove; PriceLowerLimit) { ApplicationArea = Basic, Suite; AutoFormatType = 0; Caption = 'Only Prices Above'; DecimalPlaces = 2 : 5; ToolTip = 'Specifies the code for the sales type that the sales prices will be copied to. To see the existing sales codes, click the field.'; } field(AdjustmentFactor; UnitPriceFactor) { ApplicationArea = Basic, Suite; AutoFormatType = 0; Caption = 'Adjustment Factor'; DecimalPlaces = 0 : 5; MinValue = 0; ToolTip = 'Specifies an adjustment factor to multiply the sales price that you want suggested. By entering an adjustment factor, you can increase or decrease the amounts that are suggested.'; } field(RoundingMethodCtrl; RoundingMethod.Code) { ApplicationArea = Basic, Suite; Caption = 'Rounding Method'; TableRelation = "Rounding Method"; ToolTip = 'Specifies a code for the rounding method that you want applied to prices.'; } field(CreateNewPrices; CreateNewPrices) { ApplicationArea = Basic, Suite; Caption = 'Create New Prices'; ToolTip = 'Specifies if you want the batch job to create new price suggestions (for example, a new combination of currency, sales code and time). Don''t insert a check mark if you only want to adjust existing sales prices.'; } } } } actions { } trigger OnInit() begin ToEndDateCtrlEnable := true; ToStartDateCtrlEnable := true; SalesCodeCtrlEnable := true; end; trigger OnOpenPage() begin if UnitPriceFactor = 0 then begin UnitPriceFactor := 1; ToCustPriceGr.Code := ''; ToUnitOfMeasure.Code := ''; ToCurrency.Code := ''; end; SalesCodeCtrlEnable := true; if ToSalesType = ToSalesType::"All Customers" then SalesCodeCtrlEnable := false; SalesCodeCtrlEnable := ToSalesType <> ToSalesType::"All Customers"; ToStartDateCtrlEnable := ToSalesType <> ToSalesType::Campaign; ToEndDateCtrlEnable := ToSalesType <> ToSalesType::Campaign; end; } labels { } trigger OnPreReport() begin case ToSalesType of ToSalesType::Customer: begin ToCust."No." := ToSalesCode; if ToCust."No." <> '' then ToCust.Find() else begin if not ToCust.Find() then ToCust.Init(); ToSalesCode := ToCust."No."; end; end; ToSalesType::"Customer Price Group": begin ToCustPriceGr.Code := ToSalesCode; if ToCustPriceGr.Code <> '' then ToCustPriceGr.Find() else begin if not ToCustPriceGr.Find() then ToCustPriceGr.Init(); ToSalesCode := ToCustPriceGr.Code; end; end; ToSalesType::Campaign: begin ToCampaign."No." := ToSalesCode; if ToCampaign."No." <> '' then ToCampaign.Find() else begin if not ToCampaign.Find() then ToCampaign.Init(); ToSalesCode := ToCampaign."No."; end; ToStartDate := ToCampaign."Starting Date"; ToEndDate := ToCampaign."Ending Date"; end; end; ReplaceUnitOfMeasure := ToUnitOfMeasure.Code <> ''; ReplaceCurrency := ToCurrency.Code <> ''; ReplaceStartingDate := ToStartDate <> 0D; ReplaceEndingDate := ToEndDate <> 0D; if ReplaceUnitOfMeasure and (ToUnitOfMeasure.Code <> '') then ToUnitOfMeasure.Find(); RoundingMethod.SetRange(Code, RoundingMethod.Code); end; trigger OnPostReport() begin OnAfterPostReport(); end; var SalesPriceWksh2: Record "Sales Price Worksheet"; SalesPriceWksh: Record "Sales Price Worksheet"; TempSalesPriceWksh: Record "Sales Price Worksheet" temporary; ToCust: Record Customer; ToCustPriceGr: Record "Customer Price Group"; ToCampaign: Record Campaign; ToUnitOfMeasure: Record "Unit of Measure"; ItemUnitOfMeasure: Record "Item Unit of Measure"; ToCurrency: Record Currency; FromCurrency: Record Currency; Currency2: Record Currency; CurrExchRate: Record "Currency Exchange Rate"; RoundingMethod: Record "Rounding Method"; Item: Record Item; UOMMgt: Codeunit "Unit of Measure Management"; Window: Dialog; PriceAlreadyExists: Boolean; CreateNewPrices: Boolean; UnitPriceFactor: Decimal; PriceLowerLimit: Decimal; ToSalesType: Enum "Sales Price Type"; ToSalesCode: Code[20]; ToStartDate: Date; ToEndDate: Date; ReplaceSalesCode: Boolean; ReplaceUnitOfMeasure: Boolean; ReplaceCurrency: Boolean; ReplaceStartingDate: Boolean; ReplaceEndingDate: Boolean; SalesCodeCtrlEnable: Boolean; ToStartDateCtrlEnable: Boolean; ToEndDateCtrlEnable: Boolean;#pragma warning disable AA0074#pragma warning disable AA0470 Text001: Label 'Processing items #1##########'; Text002: Label 'Sales Code must be specified when copying from %1 to All Customers.';#pragma warning restore AA0470#pragma warning restore AA0074 SalesPriceWkshLineExistsErr: Label 'There are multiple source lines for the record: %1.', Comment = '%1 = RecordId'; /// <summary> /// Initializes the basic request parameters for suggesting sales prices on the worksheet. /// </summary> /// <param name="NewToSalesType">The target sales type for the suggested prices.</param> /// <param name="NewToSalesCode">The target sales code.</param> /// <param name="NewToStartDate">The starting date for the price validity.</param> /// <param name="NewToEndDate">The ending date for the price validity.</param> /// <param name="NewToCurrCode">The target currency code.</param> /// <param name="NewToUOMCode">The target unit of measure code.</param> /// <param name="NewCreateNewPrices">Specifies whether to create new price entries.</param> procedure InitializeRequest(NewToSalesType: Option Customer,"Customer Price Group",Campaign,"All CUstomers"; NewToSalesCode: Code[20]; NewToStartDate: Date; NewToEndDate: Date; NewToCurrCode: Code[10]; NewToUOMCode: Code[10]; NewCreateNewPrices: Boolean) begin ToSalesType := "Sales Price Type".FromInteger(NewToSalesType); ToSalesCode := NewToSalesCode; ToStartDate := NewToStartDate; ToEndDate := NewToEndDate; ToCurrency.Code := NewToCurrCode; ToUnitOfMeasure.Code := NewToUOMCode; CreateNewPrices := NewCreateNewPrices; end; /// <summary> /// Initializes all request parameters for suggesting sales prices on the worksheet including adjustment options. /// </summary> /// <param name="NewToSalesType">The target sales type for the suggested prices.</param> /// <param name="NewToSalesCode">The target sales code.</param> /// <param name="NewToStartDate">The starting date for the price validity.</param> /// <param name="NewToEndDate">The ending date for the price validity.</param> /// <param name="NewToCurrCode">The target currency code.</param> /// <param name="NewToUOMCode">The target unit of measure code.</param> /// <param name="NewCreateNewPrices">Specifies whether to create new price entries.</param> /// <param name="NewPriceLowerLimit">The minimum price threshold for applying adjustments.</param> /// <param name="NewUnitPriceFactor">The adjustment factor to multiply prices by.</param> /// <param name="NewRoundingMethodCode">The rounding method code to apply to prices.</param> procedure InitializeRequest2(NewToSalesType: Option Customer,"Customer Price Group",Campaign,"All CUstomers"; NewToSalesCode: Code[20]; NewToStartDate: Date; NewToEndDate: Date; NewToCurrCode: Code[10]; NewToUOMCode: Code[10]; NewCreateNewPrices: Boolean; NewPriceLowerLimit: Decimal; NewUnitPriceFactor: Decimal; NewRoundingMethodCode: Code[10]) begin InitializeRequest(NewToSalesType, NewToSalesCode, NewToStartDate, NewToEndDate, NewToCurrCode, NewToUOMCode, NewCreateNewPrices); PriceLowerLimit := NewPriceLowerLimit; UnitPriceFactor := NewUnitPriceFactor; RoundingMethod.Code := NewRoundingMethodCode; end; /// <summary> /// Raises an event after the report has finished processing. /// </summary> [IntegrationEvent(false, false)] local procedure OnAfterPostReport() begin end; /// <summary> /// Raises an event before modifying or inserting a sales price worksheet record. /// </summary> /// <param name="SalesPriceWorksheet">The sales price worksheet record to be modified or inserted.</param> /// <param name="SalesPrice">The source sales price record.</param> /// <param name="UnitPriceFactor">The adjustment factor applied to prices.</param> /// <param name="PriceLowerLimit">The minimum price threshold.</param> /// <param name="RoundingMethod">The rounding method record used for price rounding.</param> /// <param name="CreateNewPrices">Indicates whether new price entries are being created.</param> [IntegrationEvent(false, false)] local procedure OnBeforeModifyOrInsertSalesPriceWksh(var SalesPriceWorksheet: Record "Sales Price Worksheet"; var SalesPrice: Record "Sales Price"; UnitPriceFactor: Decimal; PriceLowerLimit: Decimal; RoundingMethod: Record "Rounding Method"; CreateNewPrices: Boolean) begin end; /// <summary> /// Raises an event before setting the new unit price when it is above the price limit. /// </summary> /// <param name="SalesPriceWorksheet">The sales price worksheet record being processed.</param> /// <param name="PriceLowerLimit">The minimum price threshold.</param> /// <param name="IsHandled">Set to true to skip the default price calculation logic.</param> [IntegrationEvent(false, false)] local procedure OnBeforeSetNewUnitPriceAbovePriceLimit(var SalesPriceWorksheet: Record "Sales Price Worksheet"; PriceLowerLimit: Decimal; var IsHandled: Boolean) begin end; /// <summary> /// Raises an event after checking the sales price record to allow skipping specific records. /// </summary> /// <param name="SalesPrice">The sales price record being processed.</param> /// <param name="Item">The related item record.</param> /// <param name="SkipRecord">Set to true to skip processing this record.</param> [IntegrationEvent(false, false)] local procedure OnSalesPriceOnAfterGetRecordOnAfterCheck(SalesPrice: Record "Sales Price"; Item: Record Item; var SkipRecord: Boolean) begin end;}