Report 7051 Suggest Item Price on Wksh.
src/Layers/W1/BaseApp/Sales/Pricing/SuggestItemPriceonWksh.Report.al422 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 prices on the worksheet based on item unit prices with optional adjustment factors and rounding./// </summary>report 7051 "Suggest Item Price on Wksh."{ Caption = 'Suggest Item Price on Wksh.'; ProcessingOnly = true; dataset { dataitem(Item; Item) { DataItemTableView = sorting("No."); RequestFilterFields = "No.", "Vendor No.", "Inventory Posting Group"; trigger OnAfterGetRecord() var CurrentUnitPrice: Decimal; begin Window.Update(1, "No."); SalesPriceWksh.Init(); SalesPriceWksh.Validate("Item No.", Item."No."); if not (SalesPriceWksh."Unit of Measure Code" in [Item."Base Unit of Measure", '']) then if not ItemUnitOfMeasure.Get(SalesPriceWksh."Item No.", SalesPriceWksh."Unit of Measure Code") then CurrReport.Skip(); SalesPriceWksh.Validate("Unit of Measure Code", ToUnitofMeasure.Code); CurrentUnitPrice := Round( CurrExchRate.ExchangeAmtLCYToFCY( WorkDate(), ToCurrency.Code, Item."Unit Price", CurrExchRate.ExchangeRate( WorkDate(), ToCurrency.Code)) * UOMMgt.GetQtyPerUnitOfMeasure(Item, SalesPriceWksh."Unit of Measure Code"), ToCurrency."Unit-Amount Rounding Precision"); if CurrentUnitPrice > PriceLowerLimit then SalesPriceWksh."New Unit Price" := CurrentUnitPrice * UnitPriceFactor; OnBeforeRoundMethod(SalesPriceWksh, Item, ToCurrency, UnitPriceFactor, PriceLowerLimit, CurrentUnitPrice); 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; SalesPriceWksh.CalcCurrentPrice(PriceAlreadyExists); if not PriceAlreadyExists then begin SalesPriceWksh."Current Unit Price" := CurrentUnitPrice; SalesPriceWksh."VAT Bus. Posting Gr. (Price)" := Item."VAT Bus. Posting Gr. (Price)"; end; OnBeforeModifyOrInsertSalesPriceWksh(SalesPriceWksh); if PriceAlreadyExists or CreateNewPrices then begin SalesPriceWksh2 := SalesPriceWksh; if SalesPriceWksh2.Find('=') then SalesPriceWksh.Modify() else SalesPriceWksh.Insert(); end; end; trigger OnPreDataItem() begin Window.Open(Text000); end; } } requestpage { SaveValues = true; layout { area(content) { group(Options) { Caption = 'Options'; group("Copy to Sales Price Worksheet...") { Caption = 'Copy to Sales Price Worksheet...'; field(ToSalesType; ToSalesType) { ApplicationArea = Basic, Suite; Caption = 'Sales Type'; ToolTip = 'Specifies the sales type for the sales price agreement. 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 price agreement will update. 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() begin ToSalesCodeOnAfterValidate(); end; } field("ToUnitofMeasure.Code"; 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.'; } field("ToCurrency.Code"; ToCurrency.Code) { ApplicationArea = Basic, Suite; Caption = 'Currency Code'; TableRelation = Currency; ToolTip = 'Specifies the code for the currency that amounts are shown in.'; } 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(PriceLowerLimit; PriceLowerLimit) { AutoFormatType = 0; ApplicationArea = Basic, Suite; Caption = 'Only Amounts Above'; DecimalPlaces = 2 : 5; ToolTip = 'Specifies the lowest unit price that will be changed. Only prices that are higher than this price will be changed.'; } field(UnitPriceFactor; UnitPriceFactor) { AutoFormatType = 0; ApplicationArea = Basic, Suite; Caption = 'Adjustment Factor'; DecimalPlaces = 0 : 5; MinValue = 0; ToolTip = 'Specifies an adjustment factor to multiply the item price that you want suggested. By entering an adjustment factor, you can increase or decrease the amounts that are suggested.'; } field("RoundingMethod.Code"; 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 UnitPriceFactor := 1; 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 RoundingMethod.SetRange(Code, RoundingMethod.Code); if ToCurrency.Code = '' then ToCurrency.InitRoundingPrecision() else begin ToCurrency.Find(); ToCurrency.TestField("Unit-Amount Rounding Precision"); end; if (ToSalesCode = '') and (ToSalesType <> ToSalesType::"All Customers") then Error(Text002, SalesPrice.FieldCaption("Sales Code")); if ToUnitofMeasure.Code <> '' then ToUnitofMeasure.Find(); SalesPriceWksh.Validate("Sales Type", ToSalesType); SalesPriceWksh.Validate("Sales Code", ToSalesCode); SalesPriceWksh.Validate("Currency Code", ToCurrency.Code); SalesPriceWksh.Validate("Starting Date", ToStartDate); SalesPriceWksh.Validate("Ending Date", ToEndDate); SalesPriceWksh."Unit of Measure Code" := ToUnitofMeasure.Code; case ToSalesType of ToSalesType::Customer: begin ToCust."No." := ToSalesCode; ToCust.Find(); SalesPriceWksh."Price Includes VAT" := ToCust."Prices Including VAT"; SalesPriceWksh."Allow Line Disc." := ToCust."Allow Line Disc."; end; ToSalesType::"Customer Price Group": begin ToCustPriceGr.Code := ToSalesCode; ToCustPriceGr.Find(); SalesPriceWksh."Price Includes VAT" := ToCustPriceGr."Price Includes VAT"; SalesPriceWksh."Allow Line Disc." := ToCustPriceGr."Allow Line Disc."; SalesPriceWksh."Allow Invoice Disc." := ToCustPriceGr."Allow Invoice Disc."; end; end; end; var RoundingMethod: Record "Rounding Method"; SalesPrice: Record "Sales Price"; SalesPriceWksh2: Record "Sales Price Worksheet"; SalesPriceWksh: Record "Sales Price Worksheet"; ToCust: Record Customer; ToCustPriceGr: Record "Customer Price Group"; ToCampaign: Record Campaign; ToCurrency: Record Currency; CurrExchRate: Record "Currency Exchange Rate"; ToUnitofMeasure: Record "Unit of Measure"; ItemUnitOfMeasure: Record "Item Unit of Measure"; UOMMgt: Codeunit "Unit of Measure Management"; Window: Dialog; PriceAlreadyExists: Boolean; CreateNewPrices: Boolean; UnitPriceFactor: Decimal; PriceLowerLimit: Decimal; SalesCodeCtrlEnable: Boolean; ToStartDateCtrlEnable: Boolean; ToEndDateCtrlEnable: Boolean;#pragma warning disable AA0074#pragma warning disable AA0470 Text000: Label 'Processing items #1##########'; Text002: Label '%1 must be specified.';#pragma warning restore AA0470#pragma warning restore AA0074 protected var ToSalesType: Enum "Sales Price Type"; ToSalesCode: Code[20]; ToStartDate: Date; ToEndDate: Date; /// <summary> /// Initializes the basic request parameters for suggesting item 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="NewToStartDateText">The starting date for the price validity.</param> /// <param name="NewToEndDateText">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> procedure InitializeRequest(NewToSalesType: Option; NewToSalesCode: Code[20]; NewToStartDateText: Date; NewToEndDateText: Date; NewToCurrCode: Code[10]; NewToUOMCode: Code[10]) begin ToSalesType := "Sales Price Type".FromInteger(NewToSalesType); ToSalesCode := NewToSalesCode; ToStartDate := NewToStartDateText; ToEndDate := NewToEndDateText; ToCurrency.Code := NewToCurrCode; ToUnitofMeasure.Code := NewToUOMCode; end; local procedure ToSalesCodeOnAfterValidate() begin if ToSalesType = ToSalesType::Campaign then if ToCampaign.Get(ToSalesCode) then begin ToStartDate := ToCampaign."Starting Date"; ToEndDate := ToCampaign."Ending Date"; end else begin ToStartDate := 0D; ToEndDate := 0D; end; end; /// <summary> /// Initializes all request parameters for suggesting item 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="NewToStartDateText">The starting date for the price validity.</param> /// <param name="NewToEndDateText">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="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> /// <param name="NewCreateNewPrices">Specifies whether to create new price entries.</param> procedure InitializeRequest2(NewToSalesType: Option; NewToSalesCode: Code[20]; NewToStartDateText: Date; NewToEndDateText: Date; NewToCurrCode: Code[10]; NewToUOMCode: Code[10]; NewPriceLowerLimit: Decimal; NewUnitPriceFactor: Decimal; NewRoundingMethodCode: Code[10]; NewCreateNewPrices: Boolean) begin InitializeRequest(NewToSalesType, NewToSalesCode, NewToStartDateText, NewToEndDateText, NewToCurrCode, NewToUOMCode); PriceLowerLimit := NewPriceLowerLimit; UnitPriceFactor := NewUnitPriceFactor; RoundingMethod.Code := NewRoundingMethodCode; CreateNewPrices := NewCreateNewPrices; end; /// <summary> /// Raises an event before applying the rounding method to the calculated price. /// </summary> /// <param name="SalesPriceWorksheet">The sales price worksheet record being processed.</param> /// <param name="Item">The item record.</param> /// <param name="ToCurrency">The target currency record.</param> /// <param name="UnitPriceFactor">The adjustment factor applied to prices.</param> /// <param name="PriceLowerLimit">The minimum price threshold.</param> /// <param name="CurrentUnitPrice">The current unit price being calculated.</param> [IntegrationEvent(false, false)] local procedure OnBeforeRoundMethod(var SalesPriceWorksheet: Record "Sales Price Worksheet"; Item: Record Item; ToCurrency: Record Currency; UnitPriceFactor: Decimal; PriceLowerLimit: Decimal; var CurrentUnitPrice: Decimal) 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> [IntegrationEvent(false, false)] local procedure OnBeforeModifyOrInsertSalesPriceWksh(var SalesPriceWorksheet: Record "Sales Price Worksheet") begin end;}