Table 1053 Line Fee Note on Report Hist.

Base Application, Microsoft.Sales.Reminder

src/Layers/W1/BaseApp/Sales/Reminder/LineFeeNoteonReportHist.Table.al213 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.Reminder;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Sales.Customer;using Microsoft.Sales.Receivables;using System.Globalization;/// <summary>/// Stores history of line fee notes that have been printed on reminder reports for customer ledger entries./// </summary>table 1053 "Line Fee Note on Report Hist."{    Caption = 'Line Fee Note on Report Hist.';    Permissions = TableData "Line Fee Note on Report Hist." = rimd,                  tabledata "Reminder Attachment Text" = R,                  tabledata "Reminder Terms" = R;    DataClassification = CustomerContent;    fields    {        /// <summary>        /// Specifies the customer ledger entry number for which this line fee note was generated.        /// </summary>        field(1; "Cust. Ledger Entry No"; Integer)        {            Caption = 'Cust. Ledger Entry No';            Editable = false;            TableRelation = "Cust. Ledger Entry"."Entry No." where("Entry No." = field("Cust. Ledger Entry No"));        }        /// <summary>        /// Specifies the due date at which this line fee note applies.        /// </summary>        field(2; "Due Date"; Date)        {            Caption = 'Due Date';            Editable = false;        }        /// <summary>        /// Specifies the language code used for this translated line fee note.        /// </summary>        field(3; "Language Code"; Code[10])        {            Caption = 'Language Code';            Editable = false;            NotBlank = true;            TableRelation = Language;        }        /// <summary>        /// Specifies the reminder terms code for which this line fee note was generated.        /// </summary>        field(4; "Reminder Terms Code"; Code[10])        {            Caption = 'Reminder Terms Code';        }        /// <summary>        /// Specifies the reminder level at which this line fee note applies.        /// </summary>        field(5; "Reminder Level No"; Integer)        {            Caption = 'Reminder Level No';        }        /// <summary>        /// Contains the formatted line fee note text that appeared on the reminder report.        /// </summary>        field(6; ReportText; Text[200])        {            Caption = 'ReportText';            Editable = false;            NotBlank = true;        }    }    keys    {        key(Key1; "Cust. Ledger Entry No", "Due Date", "Language Code", "Reminder Terms Code", "Reminder Level No")        {            Clustered = true;        }    }    fieldgroups    {    }    local procedure GetLineFeeNoteOnReport(CustLedgerEntry: Record "Cust. Ledger Entry"; ReminderLevel: Record "Reminder Level"; LineFeeNoteOnReport: Text[150]; DueDate: Date): Text[200]    var        GeneralLedgerSetup: Record "General Ledger Setup";        AdditionalFeePerLine: Decimal;        CurrencyCode: Code[10];        MarginalPerc: Decimal;    begin        CustLedgerEntry.CalcFields("Original Amount");        AdditionalFeePerLine :=          ReminderLevel.GetAdditionalFee(            CustLedgerEntry."Original Amount", CustLedgerEntry."Currency Code", true, CustLedgerEntry."Posting Date");        if AdditionalFeePerLine = 0 then            exit;        if CustLedgerEntry."Currency Code" = '' then begin            GeneralLedgerSetup.Get();            CurrencyCode := GeneralLedgerSetup."LCY Code";        end else            CurrencyCode := CustLedgerEntry."Currency Code";        if CustLedgerEntry."Original Amount" > 0 then            MarginalPerc := Round(AdditionalFeePerLine * 100 / CustLedgerEntry."Original Amount", 0.01);        exit(StrSubstNo(LineFeeNoteOnReport, Format(Round(AdditionalFeePerLine, 0.01), 0, 9), CurrencyCode, DueDate, Format(MarginalPerc, 0, 9)));    end;    local procedure InsertRec(ReminderLevel: Record "Reminder Level"; CustLedgerEntryNo: Integer; DueDate: Date; LanguageCode: Code[10]; LineFeeNoteOnReport: Text[200])    var        LineFeeNoteOnReportHist: Record "Line Fee Note on Report Hist.";    begin        if LineFeeNoteOnReport <> '' then begin            if LineFeeNoteOnReportHist.Get(                CustLedgerEntryNo, DueDate, LanguageCode, ReminderLevel."Reminder Terms Code", ReminderLevel."No.")            then                exit;            LineFeeNoteOnReportHist.Init();            LineFeeNoteOnReportHist."Cust. Ledger Entry No" := CustLedgerEntryNo;            LineFeeNoteOnReportHist."Due Date" := DueDate;            LineFeeNoteOnReportHist."Language Code" := LanguageCode;            LineFeeNoteOnReportHist."Reminder Terms Code" := ReminderLevel."Reminder Terms Code";            LineFeeNoteOnReportHist."Reminder Level No" := ReminderLevel."No.";            LineFeeNoteOnReportHist.ReportText := LineFeeNoteOnReport;            LineFeeNoteOnReportHist.Insert(true);        end;    end;    local procedure InsertAttachmentLineFeeNotesOnReport(CustLedgerEntry: Record "Cust. Ledger Entry"; ReminderTerms: Record "Reminder Terms"; ReminderLevel: Record "Reminder Level"; DueDate: Date)    var        ReminderAttachmentText: Record "Reminder Attachment Text";        ReminderLevelAttachmentText: Record "Reminder Attachment Text";        LineFeeNoteOnReport: Text[200];    begin        if not IsNullGuid(ReminderLevel."Reminder Attachment Text") then begin            ReminderAttachmentText.SetRange(Id, ReminderLevel."Reminder Attachment Text");            if ReminderAttachmentText.FindSet() then                repeat                    if ReminderAttachmentText."Inline Fee Description" <> '' then begin                        LineFeeNoteOnReport :=                            GetLineFeeNoteOnReport(CustLedgerEntry, ReminderLevel, ReminderAttachmentText."Inline Fee Description", DueDate);                        InsertRec(ReminderLevel,                            CustLedgerEntry."Entry No.",                            DueDate,                            ReminderAttachmentText."Language Code",                            LineFeeNoteOnReport);                    end;                until ReminderAttachmentText.Next() = 0;        end;        if IsNullGuid(ReminderTerms."Reminder Attachment Text") then            exit;        ReminderAttachmentText.Reset();        ReminderAttachmentText.SetRange(Id, ReminderTerms."Reminder Attachment Text");        ReminderAttachmentText.SetFilter("Inline Fee Description", '<>%1', '');        if ReminderAttachmentText.FindSet() then            repeat                if IsNullGuid(ReminderLevel."Reminder Attachment Text") or                   not ReminderLevelAttachmentText.Get(                       ReminderLevel."Reminder Attachment Text", ReminderAttachmentText."Language Code")                then begin                    LineFeeNoteOnReport :=                        GetLineFeeNoteOnReport(CustLedgerEntry, ReminderLevel, ReminderAttachmentText."Inline Fee Description", DueDate);                    InsertRec(ReminderLevel,                        CustLedgerEntry."Entry No.",                        DueDate,                        ReminderAttachmentText."Language Code",                        LineFeeNoteOnReport);                end;            until ReminderAttachmentText.Next() = 0;    end;    /// <summary>    /// Saves the line fee note history for the specified customer ledger entry based on reminder terms.    /// </summary>    /// <param name="CustLedgerEntry">The customer ledger entry to save line fee history for.</param>    procedure Save(CustLedgerEntry: Record "Cust. Ledger Entry")    var        Customer: Record Customer;        ReminderTerms: Record "Reminder Terms";        ReminderLevel: Record "Reminder Level";        DueDate: Date;    begin        if not Customer.Get(CustLedgerEntry."Customer No.") then            exit;        if Customer."Reminder Terms Code" = '' then            exit;        ReminderTerms.Get(Customer."Reminder Terms Code");        if not ReminderTerms."Post Add. Fee per Line" then            exit;        ReminderLevel.SetRange("Reminder Terms Code", ReminderTerms.Code);        if ReminderLevel.FindSet() then begin            DueDate := CalcDate(ReminderLevel."Grace Period", CustLedgerEntry."Due Date");            InsertAttachmentLineFeeNotesOnReport(CustLedgerEntry, ReminderTerms, ReminderLevel, DueDate);            while ReminderLevel.Next() <> 0 do begin                DueDate := CalcDate(ReminderLevel."Grace Period", DueDate);                InsertAttachmentLineFeeNotesOnReport(CustLedgerEntry, ReminderTerms, ReminderLevel, DueDate);            end;        end;    end;}