Codeunit 60 Sales-Calc. Discount

Base Application, Microsoft.Sales.Document

src/Layers/W1/BaseApp/Sales/Document/SalesCalcDiscount.Codeunit.al439 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.Document;using Microsoft.Finance.Currency;using Microsoft.Finance.VAT.Calculation;using Microsoft.Sales.Customer;using Microsoft.Sales.Pricing;using Microsoft.Sales.Setup;using Microsoft.Utilities;/// <summary>/// Calculates invoice discounts for sales documents based on customer discount settings./// </summary>codeunit 60 "Sales-Calc. Discount"{    Permissions = tabledata "Sales Header" = rm,                  tabledata "Sales Line" = rm;    TableNo = "Sales Line";    trigger OnRun()    var        IsHandled: Boolean;    begin        SalesLine.Copy(Rec);        TempSalesHeader.Get(Rec."Document Type", Rec."Document No.");        UpdateHeader := true;        IsHandled := false;        OnRunOnBeforeCalculateInvoiceDiscount(SalesLine, TempSalesHeader, TempSalesLine, UpdateHeader, IsHandled);        if not IsHandled then            CalculateInvoiceDiscount(TempSalesHeader, TempSalesLine);        if Rec.Get(SalesLine."Document Type", SalesLine."Document No.", SalesLine."Line No.") then;    end;    var        TempSalesHeader: Record "Sales Header";        SalesLine: Record "Sales Line";        TempSalesLine: Record "Sales Line";        CustInvDisc: Record "Cust. Invoice Disc.";        CustPostingGr: Record "Customer Posting Group";        Currency: Record Currency;        InvDiscBase: Decimal;        ChargeBase: Decimal;        CurrencyDate: Date;        UpdateHeader: Boolean;        CustInvDiscFound: Boolean;#pragma warning disable AA0074        Text000: Label 'Service Charge';#pragma warning restore AA0074    local procedure CalculateInvoiceDiscount(var SalesHeader: Record "Sales Header"; var SalesLine2: Record "Sales Line")    var        TempVATAmountLine: Record "VAT Amount Line" temporary;        SalesSetup: Record "Sales & Receivables Setup";        TempServiceChargeLine: Record "Sales Line" temporary;        SalesCalcDiscountByType: Codeunit "Sales - Calc Discount By Type";        DiscountNotificationMgt: Codeunit "Discount Notification Mgt.";        ShouldGetCustInvDisc: Boolean;        IsHandled: Boolean;    begin        OnBeforeCalculateInvoiceDiscount(SalesHeader, SalesLine2, UpdateHeader);        SalesSetup.Get();        if UpdateHeader then            SalesHeader.Find(); // To ensure we have the latest - otherwise update fails.        IsHandled := false;        OnBeforeCalcSalesDiscount(SalesHeader, IsHandled, SalesLine2, UpdateHeader);        if IsHandled then            exit;        SalesLine.LockTable();        SalesHeader.TestField("Customer Posting Group");        CustPostingGr.Get(SalesHeader."Customer Posting Group");        SalesLine2.Reset();        SalesLine2.SetRange("Document Type", SalesLine."Document Type");        SalesLine2.SetRange("Document No.", SalesLine."Document No.");        SalesLine2.SetRange("System-Created Entry", true);        SalesLine2.SetRange(Type, SalesLine2.Type::"G/L Account");        SalesLine2.SetRange("No.", CustPostingGr."Service Charge Acc.");        SalesLine2.SetLoadFields("Unit Price", "Shipment No.", "Qty. Shipped Not Invoiced");        if SalesLine2.FindSet(true) then            repeat                SalesLine2."Unit Price" := 0;                SalesLine2.Modify();                TempServiceChargeLine := SalesLine2;                TempServiceChargeLine.Insert();            until SalesLine2.Next() = 0;        SalesLine2.Reset();        SalesLine2.SetLoadFields();        SalesLine2.SetRange("Document Type", SalesLine."Document Type");        SalesLine2.SetRange("Document No.", SalesLine."Document No.");        SalesLine2.SetFilter(Type, '<>0');        OnCalculateInvoiceDiscountOnBeforeSalesLine2FindFirst(SalesLine2);        if SalesLine2.FindFirst() then;        SalesLine2.CalcVATAmountLines(0, SalesHeader, SalesLine2, TempVATAmountLine);        InvDiscBase :=          TempVATAmountLine.GetTotalInvDiscBaseAmount(            SalesHeader."Prices Including VAT", SalesHeader."Currency Code");        ChargeBase :=          TempVATAmountLine.GetTotalLineAmount(            SalesHeader."Prices Including VAT", SalesHeader."Currency Code");        if UpdateHeader then            SalesHeader.Modify();        if SalesHeader."Posting Date" = 0D then            CurrencyDate := WorkDate()        else            CurrencyDate := SalesHeader."Posting Date";        CustInvDiscFound := CustInvDisc.GetRecord(SalesHeader."Invoice Disc. Code", SalesHeader."Currency Code", CurrencyDate, ChargeBase);        OnCalculateInvoiceDiscountOnBeforeCheckCustInvDiscServiceCharge(CustInvDisc, SalesHeader, CurrencyDate, ChargeBase, CustInvDiscFound);        if CustInvDiscFound and (CustInvDisc."Service Charge" <> 0) then begin            OnCalculateInvoiceDiscountOnBeforeCurrencyInitialize(CustPostingGr);            Currency.Initialize(SalesHeader."Currency Code");            if not UpdateHeader then                SalesLine2.SetSalesHeader(SalesHeader);            if not TempServiceChargeLine.IsEmpty() then begin                TempServiceChargeLine.FindLast();                SalesLine2.Get(SalesLine."Document Type", SalesLine."Document No.", TempServiceChargeLine."Line No.");                SetSalesLineServiceCharge(SalesHeader, SalesLine2);                SalesLine2.Modify();            end else begin                IsHandled := false;                OnCalculateInvoiceDiscountOnBeforeUpdateSalesLine2(SalesHeader, SalesLine2, UpdateHeader, CustInvDisc, IsHandled);                if not IsHandled then begin                    SalesLine2.Reset();                    SalesLine2.SetRange("Document Type", SalesLine."Document Type");                    SalesLine2.SetRange("Document No.", SalesLine."Document No.");                    SalesLine2.FindLast();                    SalesLine2.Init();                    if not UpdateHeader then                        SalesLine2.SetSalesHeader(SalesHeader);                    SalesLine2."Line No." := SalesLine2."Line No." + 10000;                    SalesLine2."System-Created Entry" := true;                    SalesLine2.Type := SalesLine2.Type::"G/L Account";                    SalesLine2.Validate("No.", CustPostingGr.GetServiceChargeAccount());                    SalesLine2.Description := Text000;                    SalesLine2.Validate(Quantity, 1);                    OnAfterValidateSalesLine2Quantity(SalesHeader, SalesLine2, CustInvDisc);                    if SalesLine2."Document Type" in                        [SalesLine2."Document Type"::"Return Order", SalesLine2."Document Type"::"Credit Memo"]                    then                        SalesLine2.Validate("Return Qty. to Receive", SalesLine2.Quantity)                    else                        SalesLine2.Validate("Qty. to Ship", SalesLine2.Quantity);                    SetSalesLineServiceCharge(SalesHeader, SalesLine2);                    OnCalculateInvoiceDiscountOnBeforeSalesLineInsert(SalesLine2, SalesHeader);                    SalesLine2.Insert();                end;            end;            SalesLine2.CalcVATAmountLines(0, SalesHeader, SalesLine2, TempVATAmountLine);        end else            if TempServiceChargeLine.FindSet(false) then                repeat                    if (TempServiceChargeLine."Shipment No." = '') and (TempServiceChargeLine."Qty. Shipped Not Invoiced" = 0) then begin                        SalesLine2.Get(SalesLine."Document Type", SalesLine."Document No.", TempServiceChargeLine."Line No.");                        IsHandled := false;                        OnCalculateInvoiceDiscountOnBeforeSalesLine2DeleteTrue(UpdateHeader, SalesLine2, IsHandled);                        if not IsHandled then                            SalesLine2.Delete(true);                    end;                until TempServiceChargeLine.Next() = 0;        IsHandled := false;        OnCalculateInvoiceDiscountOnBeforeCustInvDiscRecExists(SalesHeader, SalesLine2, UpdateHeader, InvDiscBase, ChargeBase, TempVATAmountLine, IsHandled);        if IsHandled then            exit;        if CustInvDiscRecExists(SalesHeader."Invoice Disc. Code") then begin            ShouldGetCustInvDisc := InvDiscBase <> ChargeBase;            OnAfterCustInvDiscRecExists(SalesHeader, CustInvDisc, InvDiscBase, ChargeBase, ShouldGetCustInvDisc);            if ShouldGetCustInvDisc then                CustInvDisc.GetRecord(                  SalesHeader."Invoice Disc. Code", SalesHeader."Currency Code", CurrencyDate, InvDiscBase);            DiscountNotificationMgt.NotifyAboutMissingSetup(              SalesSetup.RecordId, SalesHeader."Gen. Bus. Posting Group", SalesLine2."Gen. Prod. Posting Group",              SalesSetup."Discount Posting", SalesSetup."Discount Posting"::"Line Discounts");            UpdateSalesHeaderInvoiceDiscount(SalesHeader, TempVATAmountLine, SalesSetup."Calc. Inv. Disc. per VAT ID");            SalesLine2.SetSalesHeader(SalesHeader);            SalesLine2.UpdateVATOnLines(0, SalesHeader, SalesLine2, TempVATAmountLine);            UpdatePrepmtLineAmount(SalesHeader);        end;        SalesCalcDiscountByType.ResetRecalculateInvoiceDisc(SalesHeader);        OnAfterCalcSalesDiscount(SalesHeader, TempVATAmountLine, SalesLine2);    end;    local procedure UpdateSalesHeaderInvoiceDiscount(var SalesHeader: Record "Sales Header"; var TempVATAmountLine: Record "VAT Amount Line" temporary; CalcInvDiscPerVATID: Boolean)    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeUpdateSalesHeaderInvoiceDiscount(CustInvDisc, SalesHeader, TempVATAmountLine, UpdateHeader, IsHandled);        if IsHandled then            exit;        SalesHeader."Invoice Discount Calculation" := SalesHeader."Invoice Discount Calculation"::"%";        SalesHeader."Invoice Discount Value" := CustInvDisc."Discount %";        if UpdateHeader then            SalesHeader.Modify();        TempVATAmountLine.SetInvoiceDiscountPercent(          CustInvDisc."Discount %", SalesHeader."Currency Code",          SalesHeader."Prices Including VAT", CalcInvDiscPerVATID,          SalesHeader."VAT Base Discount %");    end;    local procedure SetSalesLineServiceCharge(SalesHeader: Record "Sales Header"; var SalesLine: Record "Sales Line")    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeSetSalesLineServiceCharge(SalesHeader, SalesLine, CustInvDisc, IsHandled);        if IsHandled then            exit;        if SalesHeader."Prices Including VAT" then            SalesLine.Validate(                "Unit Price",                Round((1 + SalesLine."VAT %" / 100) * CustInvDisc."Service Charge", Currency."Unit-Amount Rounding Precision"))        else            SalesLine.Validate("Unit Price", CustInvDisc."Service Charge");    end;    /// <summary>    /// Checks whether a customer invoice discount record exists for the specified code.    /// </summary>    /// <param name="InvDiscCode">The invoice discount code to check.</param>    /// <returns>True if a customer invoice discount record exists; otherwise, false.</returns>    procedure CustInvDiscRecExists(InvDiscCode: Code[20]) Result: Boolean    var        CustInvDisc: Record "Cust. Invoice Disc.";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCustInvDiscRecExists(InvDiscCode, Result, IsHandled);        if IsHandled then            exit(Result);        CustInvDisc.SetRange(Code, InvDiscCode);        exit(CustInvDisc.FindFirst());    end;    /// <summary>    /// Calculates invoice discount using the provided sales header without updating it.    /// </summary>    /// <param name="TempSalesHeader">The sales header to use for discount calculation.</param>    /// <param name="TempSalesLine">The sales lines to calculate discounts for.</param>    procedure CalculateWithSalesHeader(var TempSalesHeader: Record "Sales Header"; var TempSalesLine: Record "Sales Line")    var        FilterSalesLine: Record "Sales Line";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCalculateWithSalesHeader(SalesLine, TempSalesHeader, TempSalesLine, UpdateHeader, IsHandled); // <-- NEW EVENT        if IsHandled then            exit;        FilterSalesLine.Copy(TempSalesLine);        SalesLine := TempSalesLine;        UpdateHeader := false;        CalculateInvoiceDiscount(TempSalesHeader, TempSalesLine);        TempSalesLine.Copy(FilterSalesLine);    end;    /// <summary>    /// Calculates and applies invoice discount to a single sales line.    /// </summary>    /// <param name="SalesLineToUpdate">The sales line to calculate and update with invoice discount.</param>    procedure CalculateInvoiceDiscountOnLine(var SalesLineToUpdate: Record "Sales Line")    begin        SalesLine.Copy(SalesLineToUpdate);        TempSalesHeader.Get(SalesLine."Document Type", SalesLine."Document No.");        UpdateHeader := false;        CalculateInvoiceDiscount(TempSalesHeader, SalesLine);        if SalesLineToUpdate.Get(SalesLineToUpdate."Document Type", SalesLineToUpdate."Document No.", SalesLineToUpdate."Line No.") then;    end;    /// <summary>    /// Calculates invoice discount for a sales header if automatic calculation is enabled.    /// </summary>    /// <param name="TempSalesHeader">The sales header to calculate invoice discount for.</param>    procedure CalculateIncDiscForHeader(var TempSalesHeader: Record "Sales Header")    var        SalesSetup: Record "Sales & Receivables Setup";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCalculateIncDiscForHeader(TempSalesHeader, IsHandled, SalesLine, TempSalesLine, UpdateHeader);        if IsHandled then            exit;        SalesSetup.Get();        if not SalesSetup."Calc. Inv. Discount" then            exit;        SalesLine."Document Type" := TempSalesHeader."Document Type";        SalesLine."Document No." := TempSalesHeader."No.";        UpdateHeader := true;        CalculateInvoiceDiscount(TempSalesHeader, TempSalesLine);    end;    /// <summary>    /// Updates prepayment line amounts when invoice discount would exceed remaining non-prepaid amount.    /// </summary>    /// <param name="SalesHeader">The sales header containing lines to update.</param>    procedure UpdatePrepmtLineAmount(SalesHeader: Record "Sales Header")    var        SalesLine: Record "Sales Line";    begin        if (SalesHeader."Invoice Discount Calculation" = SalesHeader."Invoice Discount Calculation"::"%") and           (SalesHeader."Prepayment %" > 0) and (SalesHeader."Invoice Discount Value" > 0) and           (SalesHeader."Invoice Discount Value" + SalesHeader."Prepayment %" >= 100)        then begin            SalesLine.SetRange("Document Type", SalesHeader."Document Type");            SalesLine.SetRange("Document No.", SalesHeader."No.");            SalesLine.SetLoadFields(Type, Quantity, "Unit Price", "Qty. to Invoice", "Prepayment %", "Prepmt. Line Amount", Amount);            if SalesLine.FindSet(true) then                repeat                    if not SalesLine.ZeroAmountLine(0) and (SalesLine."Prepayment %" = SalesHeader."Prepayment %") then begin                        SalesLine."Prepmt. Line Amount" := SalesLine.Amount;                        SalesLine.Modify();                    end;                until SalesLine.Next() = 0;        end;    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCalcSalesDiscount(var SalesHeader: Record "Sales Header"; var IsHandled: Boolean; var SalesLine: Record "Sales Line"; var UpdateHeader: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterCalcSalesDiscount(var SalesHeader: Record "Sales Header"; var TempVATAmountLine: Record "VAT Amount Line" temporary; var SalesLine2: Record "Sales Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterCustInvDiscRecExists(var SalesHeader: Record "Sales Header"; var CustInvDisc: Record "Cust. Invoice Disc."; InvDiscBase: Decimal; ChargeBase: Decimal; var ShouldGetCustInvDisc: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterValidateSalesLine2Quantity(SalesHeader: Record "Sales Header"; var SalesLine: Record "Sales Line"; CustInvoiceDisc: Record "Cust. Invoice Disc.")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCalculateIncDiscForHeader(var TempSalesHeader: Record "Sales Header" temporary; var IsHandled: Boolean; var SalesLine: Record "Sales Line"; var TempSalesLine: Record "Sales Line" temporary; var UpdateHeader: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeSetSalesLineServiceCharge(SalesHeader: Record "Sales Header"; var SalesLine: Record "Sales Line"; CustInvoiceDisc: Record "Cust. Invoice Disc."; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeUpdateSalesHeaderInvoiceDiscount(var CustInvoiceDisc: Record "Cust. Invoice Disc."; var SalesHeader: Record "Sales Header"; var TempVATAmountLine: Record "VAT Amount Line" temporary; var UpdateHeader: Boolean; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalculateInvoiceDiscountOnBeforeCurrencyInitialize(var CustomerPostingGroup: Record "Customer Posting Group")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalculateInvoiceDiscountOnBeforeCheckCustInvDiscServiceCharge(var CustInvoiceDisc: Record "Cust. Invoice Disc."; var SalesHeader: Record "Sales Header"; CurrencyDate: Date; ChargeBase: Decimal; var CustInvDiscFound: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalculateInvoiceDiscountOnBeforeCustInvDiscRecExists(var SalesHeader: Record "Sales Header"; var SalesLine2: Record "Sales Line"; var UpdateHeader: Boolean; var InvDiscBase: Decimal; var ChargeBase: Decimal; var TempVATAmountLine: Record "VAT Amount Line" temporary; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalculateInvoiceDiscountOnBeforeSalesLine2FindFirst(var SalesLine2: Record "Sales Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalculateInvoiceDiscountOnBeforeSalesLineInsert(var SalesLine: Record "Sales Line"; SalesHeader: Record "Sales Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCalculateWithSalesHeader(var SalesLine: Record "Sales Line"; var TempSalesHeader: Record "Sales Header" temporary; var TempSalesLine: Record "Sales Line"; var UpdateHeader: Boolean; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalculateInvoiceDiscountOnBeforeSalesLine2DeleteTrue(UpdateHeader: Boolean; var SalesLine2: Record "Sales Line"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnRunOnBeforeCalculateInvoiceDiscount(var SalesLine: Record "Sales Line"; var TempSalesHeader: Record "Sales Header" temporary; var TempSalesLine: Record "Sales Line" temporary; var UpdateHeader: Boolean; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalculateInvoiceDiscountOnBeforeUpdateSalesLine2(var SalesHeader: Record "Sales Header"; var SalesLine2: Record "Sales Line"; UpdateHeader: Boolean; CustInvDisc: Record "Cust. Invoice Disc."; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCustInvDiscRecExists(InvDiscCode: Code[20]; var Result: Boolean; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCalculateInvoiceDiscount(var SalesHeader: Record "Sales Header"; var SalesLine: Record "Sales Line"; var UpdateHeader: Boolean)    begin    end;}