Page 1191 Create Employee Payment

Base Application, Microsoft.HumanResources.Payables

src/Layers/W1/BaseApp/HumanResources/Payables/CreateEmployeePayment.Page.al367 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.HumanResources.Payables;using Microsoft.Bank.BankAccount;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Journal;using Microsoft.Foundation.Company;using Microsoft.Foundation.NoSeries;using Microsoft.HumanResources.Employee;page 1191 "Create Employee Payment"{    Caption = 'Create Employee Payment';    PageType = StandardDialog;    SaveValues = true;    layout    {        area(content)        {            group(Control6)            {                ShowCaption = false;                field("Batch Name"; JournalBatchName)                {                    ApplicationArea = Basic, Suite;                    Caption = 'Batch Name';                    ShowMandatory = true;                    TableRelation = "Gen. Journal Batch".Name where("Template Type" = const(Payments),                                                                     Recurring = const(false));                    ToolTip = 'Specifies the name of the journal batch.';                    trigger OnValidate()                    var                        GenJournalBatch: Record "Gen. Journal Batch";                    begin                        SetJournalTemplate();                        if JournalTemplateName <> '' then begin                            GenJournalBatch.Get(JournalTemplateName, JournalBatchName);                            SetNextNo(GenJournalBatch."No. Series");                        end;                    end;                }                field("Posting Date"; PostingDate)                {                    ApplicationArea = Basic, Suite;                    Caption = 'Posting Date';                    ShowMandatory = true;                    ToolTip = 'Specifies the entry''s posting date.';                }                field("Starting Document No."; NextDocNo)                {                    ApplicationArea = Basic, Suite;                    Caption = 'Starting Document No.';                    ShowMandatory = true;                    ToolTip = 'Specifies a document number for the journal line.';                    trigger OnValidate()                    begin                        if NextDocNo <> '' then                            if IncStr(NextDocNo) = '' then                                Error(StartingDocumentNoErr);                    end;                }                field("Bank Account"; BalAccountNo)                {                    ApplicationArea = Basic, Suite;                    Caption = 'Bank Account';                    TableRelation = "Bank Account";                    ToolTip = 'Specifies the bank account to which a balancing entry for the journal line will be posted.';                }                field("Payment Type"; BankPaymentType)                {                    ApplicationArea = Basic, Suite;                    Caption = 'Payment Type';                    ToolTip = 'Specifies the code for the payment type to be used for the entry on the payment journal line.';                }            }        }    }    actions    {    }    trigger OnOpenPage()    var        GenJournalBatch: Record "Gen. Journal Batch";    begin        SetJournalTemplate();        if GenJournalBatch.Get(JournalTemplateName, JournalBatchName) then            SetNextNo(GenJournalBatch."No. Series")        else            Clear(JournalBatchName);        PostingDate := WorkDate();    end;    trigger OnQueryClosePage(CloseAction: Action): Boolean    begin        if CloseAction = ACTION::OK then begin            if JournalBatchName = '' then                Error(BatchNumberNotFilledErr);            if Format(PostingDate) = '' then                Error(PostingDateNotFilledErr);            if NextDocNo = '' then                Error(SpecifyStartingDocNumErr);        end;    end;    var        TempEmplPaymentBuffer: Record "Employee Payment Buffer" temporary;        PostingDate: Date;        BalAccountNo: Code[20];        NextDocNo: Code[20];        JournalBatchName: Code[10];        JournalTemplateName: Code[10];        BankPaymentType: Enum "Bank Payment Type";        StartingDocumentNoErr: Label 'Starting Document No.';        BatchNumberNotFilledErr: Label 'You must fill the Batch Name field.';        PostingDateNotFilledErr: Label 'You must fill the Posting Date field.';        SpecifyStartingDocNumErr: Label 'In the Starting Document No. field, specify the first document number to be used.';    procedure GetPostingDate(): Date    begin        exit(PostingDate);    end;    procedure GetBankAccount(): Text    begin        exit(Format(BalAccountNo));    end;    procedure GetBankPaymentType(): Integer    begin        exit(BankPaymentType.AsInteger());    end;    procedure GetBatchNumber(): Code[10]    begin        exit(JournalBatchName);    end;    procedure MakeGenJnlLines(var EmployeeLedgerEntry: Record "Employee Ledger Entry")    begin        TempEmplPaymentBuffer.Reset();        TempEmplPaymentBuffer.DeleteAll();        CopyEmployeeLedgerEntriesToTempEmplPaymentBuffer(EmployeeLedgerEntry);        CopyTempEmpPaymentBuffersToGenJnlLines();    end;    local procedure CopyEmployeeLedgerEntriesToTempEmplPaymentBuffer(var EmployeeLedgerEntry: Record "Employee Ledger Entry")    var        PaymentAmt: Decimal;    begin        if EmployeeLedgerEntry.Find('-') then            repeat                EmployeeLedgerEntry.CalcFields("Remaining Amount");                if (EmployeeLedgerEntry."Applies-to ID" = '') and (EmployeeLedgerEntry."Remaining Amount" < 0) then begin                    TempEmplPaymentBuffer."Employee No." := EmployeeLedgerEntry."Employee No.";                    TempEmplPaymentBuffer."Currency Code" := EmployeeLedgerEntry."Currency Code";                    TempEmplPaymentBuffer."Payment Method Code" := EmployeeLedgerEntry."Payment Method Code";                    TempEmplPaymentBuffer."Creditor No." := EmployeeLedgerEntry."Creditor No.";                    TempEmplPaymentBuffer."Payment Reference" := EmployeeLedgerEntry."Payment Reference";                    TempEmplPaymentBuffer."Exported to Payment File" := EmployeeLedgerEntry."Exported to Payment File";                    TempEmplPaymentBuffer."Dimension Entry No." := 0;                    TempEmplPaymentBuffer."Global Dimension 1 Code" := '';                    TempEmplPaymentBuffer."Global Dimension 2 Code" := '';                    TempEmplPaymentBuffer."Dimension Set ID" := 0;                    TempEmplPaymentBuffer."Employee Ledg. Entry No." := EmployeeLedgerEntry."Entry No.";                    TempEmplPaymentBuffer."Employee Ledg. Entry Doc. Type" := EmployeeLedgerEntry."Document Type";                    OnCopyEmployeeLedgerEntriesToTempEmplPaymentBufferOnAfterAssignTempBufferFields(TempEmplPaymentBuffer, EmployeeLedgerEntry);                    PaymentAmt := -EmployeeLedgerEntry."Remaining Amount";                    TempEmplPaymentBuffer.Reset();                    TempEmplPaymentBuffer.SetRange("Employee No.", EmployeeLedgerEntry."Employee No.");                    if TempEmplPaymentBuffer.Find('-') then begin                        TempEmplPaymentBuffer.Amount := TempEmplPaymentBuffer.Amount + PaymentAmt;                        TempEmplPaymentBuffer.Modify();                    end else begin                        TempEmplPaymentBuffer."Document No." := NextDocNo;                        NextDocNo := IncStr(NextDocNo);                        TempEmplPaymentBuffer.Amount := PaymentAmt;                        TempEmplPaymentBuffer.Insert();                    end;                    EmployeeLedgerEntry."Applies-to ID" := TempEmplPaymentBuffer."Document No.";                    EmployeeLedgerEntry."Amount to Apply" := EmployeeLedgerEntry."Remaining Amount";                    CODEUNIT.Run(CODEUNIT::"Empl. Entry-Edit", EmployeeLedgerEntry);                end;            until EmployeeLedgerEntry.Next() = 0;    end;    local procedure CopyTempEmpPaymentBuffersToGenJnlLines()    var        CompanyInformation: Record "Company Information";        GenJnlLine: Record "Gen. Journal Line";        GenJournalBatch: Record "Gen. Journal Batch";        GenJournalTemplate: Record "Gen. Journal Template";        Employee: Record Employee;        BalAccType: Enum "Gen. Journal Account Type";        LastLineNo: Integer;    begin        GenJnlLine.LockTable();        GenJournalTemplate.Get(JournalTemplateName);        GenJournalBatch.Get(JournalTemplateName, JournalBatchName);        GenJnlLine.SetRange("Journal Template Name", JournalTemplateName);        GenJnlLine.SetRange("Journal Batch Name", JournalBatchName);        if GenJnlLine.FindLast() then begin            LastLineNo := GenJnlLine."Line No.";            GenJnlLine.Init();        end;        TempEmplPaymentBuffer.Reset();        TempEmplPaymentBuffer.SetCurrentKey("Document No.");        TempEmplPaymentBuffer.SetFilter(          "Employee Ledg. Entry Doc. Type", '<>%1&<>%2', TempEmplPaymentBuffer."Employee Ledg. Entry Doc. Type"::Refund,          TempEmplPaymentBuffer."Employee Ledg. Entry Doc. Type"::Payment);        if TempEmplPaymentBuffer.FindSet() then            repeat                GenJnlLine.Init();                GenJnlLine.Validate("Journal Template Name", JournalTemplateName);                GenJnlLine.Validate("Journal Batch Name", JournalBatchName);                LastLineNo := LastLineNo + 10000;                GenJnlLine."Line No." := LastLineNo;                GenJnlLine."Document Type" := GenJnlLine."Document Type"::Payment;                GenJnlLine."Posting No. Series" := GenJournalBatch."Posting No. Series";                GenJnlLine."Document No." := TempEmplPaymentBuffer."Document No.";                GenJnlLine."Account Type" := GenJnlLine."Account Type"::Employee;                GenJnlLine.SetHideValidation(true);                GenJnlLine.Validate("Posting Date", PostingDate);                GenJnlLine.Validate("Account No.", TempEmplPaymentBuffer."Employee No.");                Employee.Get(TempEmplPaymentBuffer."Employee No.");                GenJnlLine."Bal. Account Type" := BalAccType::"Bank Account";                GenJnlLine.Validate("Bal. Account No.", BalAccountNo);                GenJnlLine.Validate("Currency Code", TempEmplPaymentBuffer."Currency Code");                CompanyInformation.Get();                GenJnlLine."Message to Recipient" := CompanyInformation.Name;                GenJnlLine."Bank Payment Type" := BankPaymentType;                GenJnlLine."Applies-to ID" := GenJnlLine."Document No.";                GenJnlLine.Description := CopyStr(Employee.FullName(), 1, MaxStrLen(GenJnlLine.Description));                GenJnlLine."Source Line No." := TempEmplPaymentBuffer."Employee Ledg. Entry No.";                GenJnlLine."Shortcut Dimension 1 Code" := TempEmplPaymentBuffer."Global Dimension 1 Code";                GenJnlLine."Shortcut Dimension 2 Code" := TempEmplPaymentBuffer."Global Dimension 2 Code";                GenJnlLine."Dimension Set ID" := TempEmplPaymentBuffer."Dimension Set ID";                GenJnlLine."Source Code" := GenJournalTemplate."Source Code";                GenJnlLine."Reason Code" := GenJournalBatch."Reason Code";                GenJnlLine.Validate(Amount, TempEmplPaymentBuffer.Amount);                GenJnlLine."Applies-to Doc. Type" := TempEmplPaymentBuffer."Employee Ledg. Entry Doc. Type";                GenJnlLine."Applies-to Doc. No." := TempEmplPaymentBuffer."Employee Ledg. Entry Doc. No.";                GenJnlLine.Validate("Payment Method Code", TempEmplPaymentBuffer."Payment Method Code");                GenJnlLine."Creditor No." := CopyStr(TempEmplPaymentBuffer."Creditor No.", 1, MaxStrLen(GenJnlLine."Creditor No."));                GenJnlLine."Payment Reference" := CopyStr(TempEmplPaymentBuffer."Payment Reference", 1, MaxStrLen(GenJnlLine."Payment Reference"));                GenJnlLine."Exported to Payment File" := TempEmplPaymentBuffer."Exported to Payment File";                GenJnlLine."Applies-to Ext. Doc. No." := TempEmplPaymentBuffer."Applies-to Ext. Doc. No.";                UpdateDimensions(GenJnlLine, TempEmplPaymentBuffer);                GenJnlLine.Insert();            until TempEmplPaymentBuffer.Next() = 0;    end;    local procedure UpdateDimensions(var GenJnlLine: Record "Gen. Journal Line"; TempEmplPaymentBuffer: Record "Employee Payment Buffer" temporary)    var        DimBuf: Record "Dimension Buffer";        TempDimSetEntry: Record "Dimension Set Entry" temporary;        DimVal: Record "Dimension Value";        DimBufMgt: Codeunit "Dimension Buffer Management";        DimMgt: Codeunit DimensionManagement;        NewDimensionID: Integer;        DimSetIDArr: array[10] of Integer;    begin        OnBeforeUpdateDimensions(GenJnlLine, TempEmplPaymentBuffer);        NewDimensionID := GenJnlLine."Dimension Set ID";        DimBuf.Reset();        DimBuf.DeleteAll();        DimBufMgt.GetDimensions(TempEmplPaymentBuffer."Dimension Entry No.", DimBuf);        if DimBuf.FindSet() then            repeat                DimVal.Get(DimBuf."Dimension Code", DimBuf."Dimension Value Code");                TempDimSetEntry."Dimension Code" := DimBuf."Dimension Code";                TempDimSetEntry."Dimension Value Code" := DimBuf."Dimension Value Code";                TempDimSetEntry."Dimension Value ID" := DimVal."Dimension Value ID";                TempDimSetEntry.Insert();            until DimBuf.Next() = 0;        NewDimensionID := DimMgt.GetDimensionSetID(TempDimSetEntry);        GenJnlLine."Dimension Set ID" := NewDimensionID;        GenJnlLine.CreateDimFromDefaultDim(0);        if NewDimensionID <> GenJnlLine."Dimension Set ID" then            AssignCombinedDimensionSetID(GenJnlLine, DimSetIDArr, NewDimensionID);        DimMgt.GetDimensionSet(TempDimSetEntry, GenJnlLine."Dimension Set ID");        DimMgt.UpdateGlobalDimFromDimSetID(GenJnlLine."Dimension Set ID", GenJnlLine."Shortcut Dimension 1 Code",          GenJnlLine."Shortcut Dimension 2 Code");        OnAfterUpdateDimensions(GenJnlLine);    end;    local procedure AssignCombinedDimensionSetID(var GenJournalLine: Record "Gen. Journal Line"; var DimSetIDArr: array[10] of Integer; NewDimensionID: Integer)    var        DimensionManagement: Codeunit DimensionManagement;    begin        DimSetIDArr[1] := GenJournalLine."Dimension Set ID";        DimSetIDArr[2] := NewDimensionID;        GenJournalLine."Dimension Set ID" := DimensionManagement.GetCombinedDimensionSetID(DimSetIDArr, GenJournalLine."Shortcut Dimension 1 Code", GenJournalLine."Shortcut Dimension 2 Code");        OnAfterAssignCombinedDimensionSetID(GenJournalLine, DimSetIDArr);    end;    local procedure SetJournalTemplate()    var        GenJournalTemplate: Record "Gen. Journal Template";    begin        GenJournalTemplate.Reset();        GenJournalTemplate.SetRange(Type, GenJournalTemplate.Type::Payments);        GenJournalTemplate.SetRange(Recurring, false);        if GenJournalTemplate.FindFirst() then            JournalTemplateName := GenJournalTemplate.Name;    end;    local procedure SetNextNo(GenJournalBatchNoSeries: Code[20])    var        GenJournalLine: Record "Gen. Journal Line";        NoSeries: Codeunit "No. Series";    begin        if GenJournalBatchNoSeries = '' then            NextDocNo := ''        else begin            GenJournalLine.SetRange("Journal Template Name", JournalTemplateName);            GenJournalLine.SetRange("Journal Batch Name", JournalBatchName);            if GenJournalLine.FindLast() then                NextDocNo := IncStr(GenJournalLine."Document No.")            else                NextDocNo := NoSeries.PeekNextNo(GenJournalBatchNoSeries, PostingDate);        end;    end;    [IntegrationEvent(false, false)]    local procedure OnAfterUpdateDimensions(var GenJournalLine: Record "Gen. Journal Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterAssignCombinedDimensionSetID(var GenJournalLine: Record "Gen. Journal Line"; DimSetIDArr: array[10] of Integer)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeUpdateDimensions(var GenJournalLine: Record "Gen. Journal Line"; TempEmployeePaymentBuffer: Record "Employee Payment Buffer" temporary)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCopyEmployeeLedgerEntriesToTempEmplPaymentBufferOnAfterAssignTempBufferFields(var TempEmployeePaymentBuffer: Record "Employee Payment Buffer" temporary; EmployeeLedgerEntry: Record "Employee Ledger Entry")    begin    end;}