Page 1702 Deferral Schedule
src/Layers/W1/BaseApp/Finance/Deferral/DeferralSchedule.Page.al360 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.Finance.Deferral;using Microsoft.Finance.GeneralLedger.Journal;using Microsoft.Purchases.Document;using Microsoft.Sales.Document;/// <summary>/// Worksheet page for creating and editing deferral schedules./// Allows users to define how deferred amounts are distributed across accounting periods./// </summary>page 1702 "Deferral Schedule"{ Caption = 'Deferral Schedule'; DataCaptionFields = "Start Date"; DeleteAllowed = false; InsertAllowed = false; LinksAllowed = false; PageType = Worksheet; ShowFilter = false; SourceTable = "Deferral Header"; layout { area(content) { group(Control1) { ShowCaption = false; field("Amount to Defer"; Rec."Amount to Defer") { ApplicationArea = Suite; trigger OnValidate() begin ShowAllocationWarning(Rec.FieldCaption("Amount to Defer")); end; } field("Calc. Method"; Rec."Calc. Method") { ApplicationArea = Suite; trigger OnValidate() begin ShowAllocationWarning(Rec.FieldCaption("Calc. Method")); end; } field("No. of Periods"; Rec."No. of Periods") { ApplicationArea = Suite; trigger OnValidate() begin ShowAllocationWarning(Rec.FieldCaption("No. of Periods")); end; } field(PostingDate; PostingDate) { ApplicationArea = Suite; Caption = 'Posting Date'; Editable = false; ToolTip = 'Specifies the posting date of the source document.'; } field(StartDateCalcMethod; StartDateCalcMethod) { ApplicationArea = Suite; Caption = 'Start Date Calc. Method'; Editable = false; ToolTip = 'Specifies the method used to calculate the start date that is used for calculating deferral amounts.'; } field("Start Date"; Rec."Start Date") { ApplicationArea = Suite; trigger OnValidate() begin ShowAllocationWarning(Rec.FieldCaption("Start Date")); end; } } part(DeferralSheduleSubform; "Deferral Schedule Subform") { ApplicationArea = Suite; SubPageLink = "Deferral Doc. Type" = field("Deferral Doc. Type"), "Gen. Jnl. Template Name" = field("Gen. Jnl. Template Name"), "Gen. Jnl. Batch Name" = field("Gen. Jnl. Batch Name"), "Document Type" = field("Document Type"), "Document No." = field("Document No."), "Line No." = field("Line No."); } } } actions { area(processing) { group("Actions") { Caption = 'Actions'; action(CalculateSchedule) { ApplicationArea = Suite; Caption = 'Calculate Schedule'; Image = CalculateCalendar; ToolTip = 'Calculate the deferral schedule by which revenue or expense amounts will be distributed over multiple accounting periods.'; trigger OnAction() begin Changed := Rec.CalculateSchedule(); end; } } } area(Promoted) { group(Category_Process) { Caption = 'Process'; actionref(CalculateSchedule_Promoted; CalculateSchedule) { } } } } trigger OnDeleteRecord(): Boolean begin Changed := true; end; trigger OnInsertRecord(BelowxRec: Boolean): Boolean begin Changed := true; end; trigger OnModifyRecord(): Boolean begin Changed := true; end; trigger OnOpenPage() begin InitForm(); end; trigger OnQueryClosePage(CloseAction: Action): Boolean var DeferralHeader: Record "Deferral Header"; DeferralLine: Record "Deferral Line"; DeferralUtilities: Codeunit "Deferral Utilities"; EarliestPostingDate: Date; RecCount: Integer; ExpectedCount: Integer; ShowNoofPeriodsError: Boolean; IsHandled: Boolean; begin // Prevent closing of the window if the sum of the periods does not equal the Amount to Defer if DeferralHeader.Get(Rec."Deferral Doc. Type", Rec."Gen. Jnl. Template Name", Rec."Gen. Jnl. Batch Name", Rec."Document Type", Rec."Document No.", Rec."Line No.") then begin Rec.CalcFields("Schedule Line Total"); if Rec."Schedule Line Total" <> DeferralHeader."Amount to Defer" then Error(TotalToDeferErr); end; DeferralLine.SetRange("Deferral Doc. Type", Rec."Deferral Doc. Type"); DeferralLine.SetRange("Gen. Jnl. Template Name", Rec."Gen. Jnl. Template Name"); DeferralLine.SetRange("Gen. Jnl. Batch Name", Rec."Gen. Jnl. Batch Name"); DeferralLine.SetRange("Document Type", Rec."Document Type"); DeferralLine.SetRange("Document No.", Rec."Document No."); DeferralLine.SetRange("Line No.", Rec."Line No."); OnOnQueryClosePageOnAfterDeferralLineSetFilters(Rec, DeferralLine); RecCount := DeferralLine.Count(); ExpectedCount := DeferralUtilities.CalcDeferralNoOfPeriods(Rec."Calc. Method", Rec."No. of Periods", Rec."Start Date"); ShowNoofPeriodsError := ExpectedCount <> RecCount; OnOnQueryClosePageOnAfterCalcShowNoofPeriodsError(Rec, DeferralLine, ShowNoofPeriodsError); if ShowNoofPeriodsError then Rec.FieldError("No. of Periods"); DeferralLine.SetFilter("Posting Date", '>%1', 0D); IsHandled := false; OnOnQueryClosePageOnBeforeCheckEarliestPostingDate(Rec, DeferralLine, IsHandled); if not IsHandled then if DeferralLine.FindFirst() then begin EarliestPostingDate := DeferralLine."Posting Date"; if EarliestPostingDate <> DeferralHeader."Start Date" then Error(PostingDateErr); end; end; var TotalToDeferErr: Label 'The sum of the deferred amounts must be equal to the amount in the Amount to Defer field.'; Changed: Boolean; DisplayDeferralDocType: Enum "Deferral Document Type"; DisplayGenJnlTemplateName: Code[10]; DisplayGenJnlBatchName: Code[10]; DisplayDocumentType: Integer; DisplayDocumentNo: Code[20]; DisplayLineNo: Integer; PostingDateErr: Label 'You cannot specify a posting date that is not equal to the start date.'; PostingDate: Date; StartDateCalcMethod: Text; /// <summary> /// Sets the parameters that identify the source document line for which the deferral schedule is being created. /// </summary> /// <param name="DeferralDocType">Type of source document (Purchase, Sales, or G/L)</param> /// <param name="GenJnlTemplateName">General Journal Template name for G/L deferrals</param> /// <param name="GenJnlBatchName">General Journal Batch name for G/L deferrals</param> /// <param name="DocumentType">Document type ID from the source document</param> /// <param name="DocumentNo">Document number from the source document</param> /// <param name="LineNo">Line number within the source document</param> procedure SetParameter(DeferralDocType: Integer; GenJnlTemplateName: Code[10]; GenJnlBatchName: Code[10]; DocumentType: Integer; DocumentNo: Code[20]; LineNo: Integer) begin DisplayDeferralDocType := Enum::"Deferral Document Type".FromInteger(DeferralDocType); DisplayGenJnlTemplateName := GenJnlTemplateName; DisplayGenJnlBatchName := GenJnlBatchName; DisplayDocumentType := DocumentType; DisplayDocumentNo := DocumentNo; DisplayLineNo := LineNo; end; /// <summary> /// Returns whether the deferral schedule has been modified by the user. /// </summary> /// <returns>True if the schedule or subform has been changed, false otherwise</returns> [Scope('OnPrem')] procedure GetParameter(): Boolean begin exit(Changed or CurrPage.DeferralSheduleSubform.PAGE.GetChanged()) end; /// <summary> /// Initializes the form by loading the deferral header record and setting up display fields. /// Retrieves posting date from the appropriate source document based on deferral type. /// </summary> procedure InitForm() var DeferralTemplate: Record "Deferral Template"; GenJournalLine: Record "Gen. Journal Line"; PurchaseHeader: Record "Purchase Header"; SalesHeader: Record "Sales Header"; IsHandled: Boolean; begin IsHandled := false; OnBeforeInitForm(Rec, DisplayDeferralDocType, DisplayGenJnlTemplateName, DisplayGenJnlBatchName, DisplayDocumentType, DisplayDocumentNo, DisplayLineNo, PostingDate, StartDateCalcMethod, IsHandled); if IsHandled then exit; Rec.Get(DisplayDeferralDocType, DisplayGenJnlTemplateName, DisplayGenJnlBatchName, DisplayDocumentType, DisplayDocumentNo, DisplayLineNo); DeferralTemplate.Get(Rec."Deferral Code"); StartDateCalcMethod := Format(DeferralTemplate."Start Date"); case DisplayDeferralDocType of Rec."Deferral Doc. Type"::"G/L": begin GenJournalLine.Get(DisplayGenJnlTemplateName, DisplayGenJnlBatchName, DisplayLineNo); PostingDate := GenJournalLine."Posting Date"; end; Rec."Deferral Doc. Type"::Sales: begin SalesHeader.Get(DisplayDocumentType, DisplayDocumentNo); PostingDate := SalesHeader."Posting Date"; end; Rec."Deferral Doc. Type"::Purchase: begin PurchaseHeader.Get(DisplayDocumentType, DisplayDocumentNo); PostingDate := PurchaseHeader."Posting Date"; end; end; end; local procedure ShowAllocationWarning(FieldName: Text) var SalesLine: Record "Sales Line"; PurchaseLine: Record "Purchase Line"; GenJournalLine: Record "Gen. Journal Line"; ChangeDeferralScheduleErr: Label 'You can''t change the %1 for the %2 because the document line has the %3 type.', Comment = '%1 = Field Name, %2 = Page Caption, %3 = Line Type'; begin case Rec."Deferral Doc. Type" of Rec."Deferral Doc. Type"::Sales: if SalesLine.Get(Rec."Document Type", Rec."Document No.", Rec."Line No.") then if SalesLine.Type = SalesLine.Type::"Allocation Account" then Error(ChangeDeferralScheduleErr, FieldName, CurrPage.Caption, Format(SalesLine.Type)); Rec."Deferral Doc. Type"::Purchase: if PurchaseLine.Get(Rec."Document Type", Rec."Document No.", Rec."Line No.") then if PurchaseLine.Type = PurchaseLine.Type::"Allocation Account" then Error(ChangeDeferralScheduleErr, FieldName, CurrPage.Caption, Format(PurchaseLine.Type)); Rec."Deferral Doc. Type"::"G/L": if GenJournalLine.Get(Rec."Gen. Jnl. Template Name", Rec."Gen. Jnl. Batch Name", Rec."Line No.") then if (GenJournalLine."Account Type" = GenJournalLine."Account Type"::"Allocation Account") or (GenJournalLine."Bal. Account Type" = GenJournalLine."Bal. Account Type"::"Allocation Account") then Error(ChangeDeferralScheduleErr, FieldName, CurrPage.Caption, Format(GenJournalLine."Account Type")); end; end; /// <summary> /// Integration event raised before initializing the deferral schedule form. /// Enables custom form initialization logic or parameter modification. /// </summary> /// <param name="DeferralHeader">Deferral header record for the schedule</param> /// <param name="DisplayDeferralDocType">Document type for display purposes</param> /// <param name="DisplayGenJnlTemplateName">General journal template name for display</param> /// <param name="DisplayGenJnlBatchName">General journal batch name for display</param> /// <param name="DisplayDocumentType">Document type integer value for display</param> /// <param name="DisplayDocumentNo">Document number for display</param> /// <param name="DisplayLineNo">Line number for display</param> /// <param name="PostingDate">Posting date for the deferral</param> /// <param name="StartDateCalcMethod">Calculation method for start date</param> /// <param name="IsHandled">Set to true to skip standard form initialization</param> /// <remarks> /// Raised from InitForm procedure before standard deferral schedule form setup. /// </remarks> [IntegrationEvent(false, false)] local procedure OnBeforeInitForm(var DeferralHeader: Record "Deferral Header"; DisplayDeferralDocType: Enum "Deferral Document Type"; DisplayGenJnlTemplateName: Code[10]; DisplayGenJnlBatchName: Code[10]; DisplayDocumentType: Integer; DisplayDocumentNo: Code[20]; DisplayLineNo: Integer; var PostingDate: Date; var StartDateCalcMethod: Text; var IsHandled: Boolean) begin end; /// <summary> /// Integration event raised after calculating whether to show number of periods error. /// Enables custom logic for determining period validation error display. /// </summary> /// <param name="DeferralHeader">Deferral header being validated</param> /// <param name="DeferralLine">Deferral line being validated</param> /// <param name="ShowNoofPeriodsError">Whether to show periods error (can be modified by subscribers)</param> /// <remarks> /// Raised from OnQueryClosePage trigger after calculating period validation errors. /// </remarks> [IntegrationEvent(false, false)] local procedure OnOnQueryClosePageOnAfterCalcShowNoofPeriodsError(DeferralHeader: Record "Deferral Header"; DeferralLine: Record "Deferral Line"; var ShowNoofPeriodsError: Boolean) begin end; /// <summary> /// Integration event raised after setting filters on deferral lines during page close validation. /// Enables custom filter modification or additional processing on deferral lines. /// </summary> /// <param name="DeferralHeader">Deferral header context for filtering</param> /// <param name="DeferralLine">Deferral line record with filters applied</param> /// <remarks> /// Raised from OnQueryClosePage trigger after applying standard filters to deferral lines. /// </remarks> [IntegrationEvent(false, false)] local procedure OnOnQueryClosePageOnAfterDeferralLineSetFilters(DeferralHeader: Record "Deferral Header"; var DeferralLine: Record "Deferral Line") begin end; [IntegrationEvent(false, false)] local procedure OnOnQueryClosePageOnBeforeCheckEarliestPostingDate(DeferralHeader: Record "Deferral Header"; var DeferralLine: Record "Deferral Line"; var IsHandled: Boolean) begin end;}