Report 394 Suggest Employee Payments
src/Layers/W1/BaseApp/HumanResources/Payables/SuggestEmployeePayments.Report.al883 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.Currency;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Journal;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Foundation.Company;using Microsoft.Foundation.NoSeries;using Microsoft.HumanResources.Employee;report 394 "Suggest Employee Payments"{ Caption = 'Suggest Employee Payments'; ProcessingOnly = true; dataset { dataitem(Employee; Employee) { DataItemTableView = sorting("No.") where("Privacy Blocked" = const(false)); RequestFilterFields = "No."; trigger OnAfterGetRecord() begin Clear(EmployeeBalance); CalcFields(Balance); EmployeeBalance := Balance; if StopPayments then CurrReport.Break(); Window.Update(1, "No."); if IncludeEmployee(Employee, EmployeeBalance) then begin GetEmplLedgEntries(true); GetEmplLedgEntries(false); CheckAmounts(); ClearNegative(); end; end; trigger OnPostDataItem() begin if FindSet() then repeat ClearNegative(); until Next() = 0; DimSetEntry.LockTable(); GenJnlLine.LockTable(); GenJnlTemplate.Get(GenJnlLine."Journal Template Name"); GenJnlBatch.Get(GenJnlLine."Journal Template Name", GenJnlLine."Journal Batch Name"); GenJnlLine.SetRange("Journal Template Name", GenJnlLine."Journal Template Name"); GenJnlLine.SetRange("Journal Batch Name", GenJnlLine."Journal Batch Name"); if GenJnlLine.FindLast() then begin LastLineNo := GenJnlLine."Line No."; GenJnlLine.Init(); end; Window2.Open(InsertingJournalLinesMsg); TempPayableEmployeeLedgerEntry.Reset(); MakeGenJnlLines(); TempPayableEmployeeLedgerEntry.Reset(); TempPayableEmployeeLedgerEntry.DeleteAll(); Window2.Close(); Window.Close(); ShowMessage(MessageText); end; trigger OnPreDataItem() begin if PostingDateReq = 0D then Error(PostingDateRequiredErr); BankPmtType := GenJnlLine2."Bank Payment Type"; BalAccType := GenJnlLine2."Bal. Account Type"; BalAccNo := GenJnlLine2."Bal. Account No."; GenJnlLineInserted := false; MessageText := ''; if ((BankPmtType = GenJnlLine2."Bank Payment Type"::" ") or SummarizePerEmpl) and (NextDocNo = '') then Error(StartingDocNoErr); if ((BankPmtType = GenJnlLine2."Bank Payment Type"::"Manual Check") and not SummarizePerEmpl and not DocNoPerLine) then Error(ManualCheckErr); Empl2.CopyFilters(Employee); OriginalAmtAvailable := AmountAvailable; Window.Open(ProcessingEmployeesMsg); SelectedDim.SetRange("User ID", UserId); SelectedDim.SetRange("Object Type", 3); SelectedDim.SetRange("Object ID", REPORT::"Suggest Employee Payments"); SummarizePerDim := SelectedDim.Find('-') and SummarizePerEmpl; NextEntryNo := 1; end; } } requestpage { SaveValues = true; layout { area(content) { group(Options) { Caption = 'Options'; group("Find Payments") { Caption = 'Find Payments'; field("Available Amount (LCY)"; AmountAvailable) { ApplicationArea = Basic, Suite; AutoFormatType = 1; AutoFormatExpression = ''; Caption = 'Available Amount (LCY)'; Importance = Additional; ToolTip = 'Specifies a maximum amount (in LCY) that is available for payments.'; } field(SkipExportedPayments; SkipExportPayments) { ApplicationArea = Basic, Suite; Caption = 'Skip Exported Payments'; Importance = Additional; ToolTip = 'Specifies if you do not want the batch job to insert payment journal lines for documents for which payments have already been exported to a bank file.'; } } group("Summarize Results") { Caption = 'Summarize Results'; field(SummarizePerEmployee; SummarizePerEmpl) { ApplicationArea = Basic, Suite; Caption = 'Summarize per Employee'; ToolTip = 'Specifies if you want the batch job to make one line per employee'; } field(SummarizePerDimText; SummarizePerDimTextReq) { ApplicationArea = Dimensions; Caption = 'By Dimension'; Editable = false; Enabled = SummarizePerDimTextEnable; Importance = Additional; ToolTip = 'Specifies the dimensions that you want the batch job to consider.'; trigger OnAssistEdit() var DimSelectionBuf: Record "Dimension Selection Buffer"; begin DimSelectionBuf.SetDimSelectionMultiple(3, REPORT::"Suggest Employee Payments", SummarizePerDimTextReq); end; } } group("Fill in Journal Lines") { Caption = 'Fill in Journal Lines'; field(PostingDate; PostingDateReq) { ApplicationArea = Basic, Suite; Caption = 'Posting Date'; Importance = Promoted; ToolTip = 'Specifies the date for the posting of this batch job. By default, the working date is entered, but you can change it.'; trigger OnValidate() begin ValidatePostingDate(); end; } field(StartingDocumentNo; NextDocNo) { ApplicationArea = Basic, Suite; Caption = 'Starting Document No.'; ToolTip = 'Specifies the next available number in the number series for the journal batch that is linked to the payment journal. When you run the batch job, this is the document number that appears on the first payment journal line. You can also fill in this field manually.'; trigger OnValidate() begin if NextDocNo <> '' then if IncStr(NextDocNo) = '' then Error(StartingDocumentNoErr); end; } field(NewDocNoPerLine; DocNoPerLine) { ApplicationArea = Basic, Suite; Caption = 'New Doc. No. per Line'; Importance = Additional; ToolTip = 'Specifies if you want the batch job to fill in the payment journal lines with consecutive document numbers, starting with the document number specified in the Starting Document No. field.'; } field(BalAccountType; GenJnlLine2."Bal. Account Type") { ApplicationArea = Basic, Suite; Caption = 'Bal. Account Type'; Importance = Additional; ToolTip = 'Specifies the balancing account type that payments on the payment journal are posted to.'; trigger OnValidate() begin if not (GenJnlLine2."Bal. Account Type" in [GenJnlLine2."Bal. Account Type"::"Bank Account", GenJnlLine2."Bal. Account Type"::"G/L Account"]) then error( BalAccountTypeErr, GenJnlLine2."Bal. Account Type"::"Bank Account", GenJnlLine2."Bal. Account Type"::"G/L Account"); GenJnlLine2."Bal. Account No." := ''; end; } field(BalAccountNo; GenJnlLine2."Bal. Account No.") { ApplicationArea = Basic, Suite; Caption = 'Bal. Account No.'; Importance = Additional; ToolTip = 'Specifies the balancing account number that payments on the payment journal are posted to.'; trigger OnLookup(var Text: Text): Boolean begin case GenJnlLine2."Bal. Account Type" of GenJnlLine2."Bal. Account Type"::"G/L Account": if PAGE.RunModal(0, GLAcc) = ACTION::LookupOK then GenJnlLine2."Bal. Account No." := GLAcc."No."; GenJnlLine2."Bal. Account Type"::Customer, GenJnlLine2."Bal. Account Type"::Vendor, GenJnlLine2."Bal. Account Type"::Employee: Error(AccountTypeErr, GenJnlLine2.FieldCaption("Bal. Account Type")); GenJnlLine2."Bal. Account Type"::"Bank Account": if PAGE.RunModal(0, BankAcc) = ACTION::LookupOK then GenJnlLine2."Bal. Account No." := BankAcc."No."; end; end; trigger OnValidate() begin if GenJnlLine2."Bal. Account No." <> '' then case GenJnlLine2."Bal. Account Type" of GenJnlLine2."Bal. Account Type"::"G/L Account": GLAcc.Get(GenJnlLine2."Bal. Account No."); GenJnlLine2."Bal. Account Type"::Customer, GenJnlLine2."Bal. Account Type"::Vendor, GenJnlLine2."Bal. Account Type"::Employee: Error(AccountTypeErr, GenJnlLine2.FieldCaption("Bal. Account Type")); GenJnlLine2."Bal. Account Type"::"Bank Account": BankAcc.Get(GenJnlLine2."Bal. Account No."); end; end; } field(BankPaymentType; GenJnlLine2."Bank Payment Type") { ApplicationArea = Basic, Suite; Caption = 'Bank Payment Type'; Importance = Additional; ToolTip = 'Specifies the check type to be used, if you use Bank Account as the balancing account type.'; trigger OnValidate() begin if (GenJnlLine2."Bal. Account Type" <> GenJnlLine2."Bal. Account Type"::"Bank Account") and (GenJnlLine2."Bank Payment Type".AsInteger() > 0) then Error(BankPaymentTypeErr); end; } } } } } actions { } trigger OnInit() begin SummarizePerDimTextEnable := true; SkipExportPayments := true; end; trigger OnOpenPage() begin PostingDateReq := WorkDate(); ValidatePostingDate(); SetDefaults(); end; } labels { } trigger OnPostReport() begin Commit(); if not TempEmployeeLedgerEntry.IsEmpty() then if Confirm(UnprocessedEntriesQst) then PAGE.RunModal(0, TempEmployeeLedgerEntry); end; trigger OnPreReport() begin CompanyInformation.Get(); TempEmployeeLedgerEntry.DeleteAll(); ShowPostingDateWarning := false; end; var Empl2: Record Employee; GenJnlTemplate: Record "Gen. Journal Template"; GenJnlBatch: Record "Gen. Journal Batch"; GenJnlLine: Record "Gen. Journal Line"; DimSetEntry: Record "Dimension Set Entry"; GenJnlLine2: Record "Gen. Journal Line"; EmployeeLedgerEntry: Record "Employee Ledger Entry"; GLAcc: Record "G/L Account"; BankAcc: Record "Bank Account"; TempPayableEmployeeLedgerEntry: Record "Payable Employee Ledger Entry" temporary; CompanyInformation: Record "Company Information"; TempEmplPaymentBuffer: Record "Employee Payment Buffer" temporary; TempEmployeePaymentBufferOld: Record "Employee Payment Buffer" temporary; SelectedDim: Record "Selected Dimension"; TempEmployeeLedgerEntry: Record "Employee Ledger Entry" temporary; DimMgt: Codeunit DimensionManagement; DimBufMgt: Codeunit "Dimension Buffer Management"; Window: Dialog; Window2: Dialog; PostingDateReq: Date; NextDocNo: Code[20]; AmountAvailable: Decimal; OriginalAmtAvailable: Decimal; SummarizePerEmpl: Boolean; SummarizePerDim: Boolean; SummarizePerDimTextReq: Text[250]; LastLineNo: Integer; NextEntryNo: Integer; StopPayments: Boolean; DocNoPerLine: Boolean; BankPmtType: Enum "Bank Payment Type"; BalAccType: Enum "Gen. Journal Account Type"; BalAccNo: Code[20]; MessageText: Text; GenJnlLineInserted: Boolean; SummarizePerDimTextEnable: Boolean; ShowPostingDateWarning: Boolean; EmployeeBalance: Decimal; SkipExportPayments: Boolean; PostingDateRequiredErr: Label 'In the Posting Date field, specify the date that will be used as the posting date for the journal entries.'; StartingDocNoErr: Label 'In the Starting Document No. field, specify the first document number to be used.'; ProcessingEmployeesMsg: Label 'Processing employees #1##########', Comment = '#1########## is for the progress dialog. Don''t translate that part of the string'; InsertingJournalLinesMsg: Label 'Inserting payment journal lines #1##########', Comment = '#1########## is for the progress dialog. Don''t translate that part of the string'; AccountTypeErr: Label '%1 must be G/L Account or Bank Account.', Comment = '%1 - balancing account type'; BankPaymentTypeErr: Label 'Bank Payment Type field must be filled only when Bal. Account Type is set to Bank Account.'; BalAccountTypeErr: label 'Balancing account must be %1 or %2.', Comment = '%1 - Bank Account, %2 - G/L Account'; ManualCheckErr: Label 'If bank payment type is set to Manual Check, and you have not selected the Summarize per Employee field,\ then you must select the New Doc. No. per Line.'; EmployeePaymentLinesCreatedTxt: Label 'You have created suggested employee payment lines.'; UnprocessedEntriesQst: Label 'There are one or more entries for which no payment suggestions have been made because the posting dates of the entries are later than the requested posting date. Do you want to see the entries?'; ReplacePostingDateMsg: Label 'For one or more entries, the requested posting date is before the work date.\\These posting dates will use the work date.'; StartingDocumentNoErr: Label 'The value in the Starting Document No. field must have a number so that we can assign the next number in the series.'; UnsupportedCurrencyErr: Label 'The balancing bank account must have local currency.'; procedure SetGenJnlLine(NewGenJnlLine: Record "Gen. Journal Line") begin GenJnlLine := NewGenJnlLine; end; local procedure ValidatePostingDate() var NoSeries: Codeunit "No. Series"; begin GenJnlBatch.Get(GenJnlLine."Journal Template Name", GenJnlLine."Journal Batch Name"); if GenJnlBatch."No. Series" = '' then NextDocNo := '' else NextDocNo := NoSeries.PeekNextNo(GenJnlBatch."No. Series", PostingDateReq); end; procedure InitializeRequest(NewAvailableAmount: Decimal; NewSkipExportedPayments: Boolean; NewPostingDate: Date; NewStartDocNo: Code[20]; NewSummarizePerEmpl: Boolean; BalAccType: Enum "Gen. Journal Account Type"; BalAccNo: Code[20]; BankPmtType: Enum "Bank Payment Type") begin AmountAvailable := NewAvailableAmount; SkipExportPayments := NewSkipExportedPayments; PostingDateReq := NewPostingDate; NextDocNo := NewStartDocNo; SummarizePerEmpl := NewSummarizePerEmpl; GenJnlLine2."Bal. Account Type" := BalAccType; GenJnlLine2."Bal. Account No." := BalAccNo; GenJnlLine2."Bank Payment Type" := BankPmtType; end; local procedure GetEmplLedgEntries(Positive: Boolean) begin EmployeeLedgerEntry.Reset(); EmployeeLedgerEntry.SetCurrentKey("Employee No.", Open, Positive); EmployeeLedgerEntry.SetRange("Employee No.", Employee."No."); EmployeeLedgerEntry.SetRange(Open, true); EmployeeLedgerEntry.SetRange(Positive, Positive); EmployeeLedgerEntry.SetRange("Applies-to ID", ''); if SkipExportPayments then EmployeeLedgerEntry.SetRange("Exported to Payment File", false); EmployeeLedgerEntry.SetFilter("Global Dimension 1 Code", Employee.GetFilter("Global Dimension 1 Filter")); EmployeeLedgerEntry.SetFilter("Global Dimension 2 Code", Employee.GetFilter("Global Dimension 2 Filter")); OnGetEmplLedgEntriesOnAfterSetFilters(EmployeeLedgerEntry, Positive, SkipExportPayments); if EmployeeLedgerEntry.FindSet() then repeat SaveAmount(); until EmployeeLedgerEntry.Next() = 0; end; local procedure SaveAmount() begin GenJnlLine.Init(); GenJnlLine.Validate("Posting Date", PostingDateReq); GenJnlLine."Document Type" := GenJnlLine."Document Type"::Payment; GenJnlLine."Account Type" := GenJnlLine."Account Type"::Employee; Empl2.Get(EmployeeLedgerEntry."Employee No."); GenJnlLine.Description := CopyStr(Empl2.FullName(), 1, MaxStrLen(GenJnlLine.Description)); GenJnlLine."Posting Group" := Empl2."Employee Posting Group"; GenJnlLine."Salespers./Purch. Code" := Empl2."Salespers./Purch. Code"; GenJnlLine.Validate("Bill-to/Pay-to No.", GenJnlLine."Account No."); GenJnlLine.Validate("Sell-to/Buy-from No.", GenJnlLine."Account No."); GenJnlLine."Gen. Posting Type" := GenJnlLine."Gen. Posting Type"::" "; GenJnlLine."Gen. Prod. Posting Group" := ''; GenJnlLine."Gen. Bus. Posting Group" := ''; GenJnlLine."VAT Bus. Posting Group" := ''; GenJnlLine."VAT Prod. Posting Group" := ''; GenJnlLine.Validate("Currency Code", EmployeeLedgerEntry."Currency Code"); EmployeeLedgerEntry.CalcFields("Remaining Amount"); GenJnlLine.Amount := -EmployeeLedgerEntry."Remaining Amount"; GenJnlLine.Validate(Amount); TempPayableEmployeeLedgerEntry."Employee No." := EmployeeLedgerEntry."Employee No."; TempPayableEmployeeLedgerEntry."Entry No." := NextEntryNo; TempPayableEmployeeLedgerEntry."Employee Ledg. Entry No." := EmployeeLedgerEntry."Entry No."; TempPayableEmployeeLedgerEntry.Amount := GenJnlLine.Amount; TempPayableEmployeeLedgerEntry.Positive := (TempPayableEmployeeLedgerEntry.Amount > 0); TempPayableEmployeeLedgerEntry."Currency Code" := EmployeeLedgerEntry."Currency Code"; TempPayableEmployeeLedgerEntry.Insert(); NextEntryNo := NextEntryNo + 1; end; local procedure CheckAmounts() var CurrencyBalance: Decimal; PrevCurrency: Code[10]; begin TempPayableEmployeeLedgerEntry.SetRange("Employee No.", Employee."No."); PrevCurrency := ''; CurrencyBalance := 0; if TempPayableEmployeeLedgerEntry.Find('-') then begin repeat if TempPayableEmployeeLedgerEntry."Currency Code" <> PrevCurrency then begin if CurrencyBalance > 0 then AmountAvailable := AmountAvailable - CurrencyBalance; CurrencyBalance := 0; PrevCurrency := TempPayableEmployeeLedgerEntry."Currency Code"; end; if (OriginalAmtAvailable = 0) or (AmountAvailable >= CurrencyBalance + TempPayableEmployeeLedgerEntry.Amount) then CurrencyBalance := CurrencyBalance + TempPayableEmployeeLedgerEntry.Amount else TempPayableEmployeeLedgerEntry.Delete(); until TempPayableEmployeeLedgerEntry.Next() = 0; if OriginalAmtAvailable > 0 then AmountAvailable := AmountAvailable - CurrencyBalance; if (OriginalAmtAvailable > 0) and (AmountAvailable <= 0) then StopPayments := true; end; TempPayableEmployeeLedgerEntry.Reset(); end; local procedure MakeGenJnlLines() var RemainingAmtAvailable: Decimal; begin TempEmplPaymentBuffer.Reset(); TempEmplPaymentBuffer.DeleteAll(); if BalAccType = BalAccType::"Bank Account" then CheckCurrencies(BalAccType, BalAccNo); if OriginalAmtAvailable <> 0 then begin RemainingAmtAvailable := OriginalAmtAvailable; RemovePaymentsAboveLimit(TempPayableEmployeeLedgerEntry, RemainingAmtAvailable); end; CopyEmployeeLedgerEntriesToTempEmplPaymentBuffer(RemainingAmtAvailable); CopyTempEmpPaymentBuffersToGenJnlLines(); end; local procedure CopyEmployeeLedgerEntriesToTempEmplPaymentBuffer(RemainingAmtAvailable: Decimal) var DimBuf: Record "Dimension Buffer"; NoSeriesBatch: Codeunit "No. Series - Batch"; begin if TempPayableEmployeeLedgerEntry.Find('-') then repeat TempPayableEmployeeLedgerEntry.SetRange("Employee No.", TempPayableEmployeeLedgerEntry."Employee No."); TempPayableEmployeeLedgerEntry.Find('-'); repeat EmployeeLedgerEntry.Get(TempPayableEmployeeLedgerEntry."Employee Ledg. Entry No."); 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"; OnCopyEmployeeLedgerEntriesToTempEmplPaymentBufferOnAfterCopyEmployeeLedgerEntryFields(TempEmplPaymentBuffer, EmployeeLedgerEntry); SetTempEmplPaymentBufferDims(DimBuf); EmployeeLedgerEntry.CalcFields("Remaining Amount"); if SummarizePerEmpl then begin TempEmplPaymentBuffer."Employee Ledg. Entry No." := 0; if TempEmplPaymentBuffer.Find() then begin TempEmplPaymentBuffer.Amount := TempEmplPaymentBuffer.Amount + TempPayableEmployeeLedgerEntry.Amount; TempEmplPaymentBuffer.Modify(); end else begin TempEmplPaymentBuffer."Document No." := NextDocNo; if DocNoPerLine then NextDocNo := NoSeriesBatch.SimulateGetNextNo(GenJnlBatch."No. Series", GenJnlLine."Posting Date", NextDocNo); TempEmplPaymentBuffer.Amount := TempPayableEmployeeLedgerEntry.Amount; Window2.Update(1, EmployeeLedgerEntry."Employee No."); TempEmplPaymentBuffer.Insert(); end; EmployeeLedgerEntry."Applies-to ID" := TempEmplPaymentBuffer."Document No."; end else if not IsEntryAlreadyApplied(GenJnlLine, EmployeeLedgerEntry) then begin TempEmplPaymentBuffer."Employee Ledg. Entry Doc. Type" := EmployeeLedgerEntry."Document Type"; TempEmplPaymentBuffer."Employee Ledg. Entry Doc. No." := EmployeeLedgerEntry."Document No."; TempEmplPaymentBuffer."Global Dimension 1 Code" := EmployeeLedgerEntry."Global Dimension 1 Code"; TempEmplPaymentBuffer."Global Dimension 2 Code" := EmployeeLedgerEntry."Global Dimension 2 Code"; TempEmplPaymentBuffer."Dimension Set ID" := EmployeeLedgerEntry."Dimension Set ID"; TempEmplPaymentBuffer."Employee Ledg. Entry No." := EmployeeLedgerEntry."Entry No."; TempEmplPaymentBuffer.Amount := TempPayableEmployeeLedgerEntry.Amount; Window2.Update(1, EmployeeLedgerEntry."Employee No."); TempEmplPaymentBuffer.Insert(); end; EmployeeLedgerEntry."Amount to Apply" := EmployeeLedgerEntry."Remaining Amount"; CODEUNIT.Run(CODEUNIT::"Empl. Entry-Edit", EmployeeLedgerEntry); TempPayableEmployeeLedgerEntry.Delete(); if OriginalAmtAvailable <> 0 then begin RemainingAmtAvailable := RemainingAmtAvailable - TempPayableEmployeeLedgerEntry.Amount; RemovePaymentsAboveLimit(TempPayableEmployeeLedgerEntry, RemainingAmtAvailable); end; until not TempPayableEmployeeLedgerEntry.FindSet(); TempPayableEmployeeLedgerEntry.DeleteAll(); TempPayableEmployeeLedgerEntry.SetRange("Employee No."); until not TempPayableEmployeeLedgerEntry.Find('-'); end; local procedure CopyTempEmpPaymentBuffersToGenJnlLines() var Employee: Record Employee; NoSeriesBatch: Codeunit "No. Series - Batch"; begin Clear(TempEmployeePaymentBufferOld); 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(); Window2.Update(1, TempEmplPaymentBuffer."Employee No."); LastLineNo := LastLineNo + 10000; GenJnlLine."Line No." := LastLineNo; GenJnlLine."Document Type" := GenJnlLine."Document Type"::Payment; GenJnlLine."Posting No. Series" := GenJnlBatch."Posting No. Series"; if SummarizePerEmpl then GenJnlLine."Document No." := TempEmplPaymentBuffer."Document No." else if DocNoPerLine then begin if TempEmplPaymentBuffer.Amount < 0 then GenJnlLine."Document Type" := GenJnlLine."Document Type"::Refund; GenJnlLine."Document No." := NextDocNo; NextDocNo := NoSeriesBatch.SimulateGetNextNo(GenJnlBatch."No. Series", GenJnlLine."Posting Date", NextDocNo); end else if (TempEmplPaymentBuffer."Employee No." = TempEmployeePaymentBufferOld."Employee No.") and (TempEmplPaymentBuffer."Currency Code" = TempEmployeePaymentBufferOld."Currency Code") then GenJnlLine."Document No." := TempEmployeePaymentBufferOld."Document No." else begin GenJnlLine."Document No." := NextDocNo; NextDocNo := NoSeriesBatch.SimulateGetNextNo(GenJnlBatch."No. Series", GenJnlLine."Posting Date", NextDocNo); TempEmployeePaymentBufferOld := TempEmplPaymentBuffer; TempEmployeePaymentBufferOld."Document No." := GenJnlLine."Document No."; end; GenJnlLine."Account Type" := GenJnlLine."Account Type"::Employee; GenJnlLine.SetHideValidation(true); GenJnlLine.Validate("Posting Date", PostingDateReq); GenJnlLine.Validate("Account No.", TempEmplPaymentBuffer."Employee No."); GenJnlLine.Validate("Recipient Bank Account", TempEmplPaymentBuffer."Employee No."); Employee.Get(TempEmplPaymentBuffer."Employee No."); GenJnlLine."Bal. Account Type" := BalAccType; GenJnlLine.Validate("Bal. Account No.", BalAccNo); GenJnlLine.Validate("Currency Code", TempEmplPaymentBuffer."Currency Code"); GenJnlLine."Message to Recipient" := CompanyInformation.Name; GenJnlLine."Bank Payment Type" := BankPmtType; if SummarizePerEmpl then 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" := GenJnlTemplate."Source Code"; GenJnlLine."Reason Code" := GenJnlBatch."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."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."; OnBeforeUpdateGnlJnlLineDimensionsFromTempBuffer(GenJnlLine, TempEmplPaymentBuffer); UpdateDimensions(GenJnlLine); GenJnlLine.Insert(); GenJnlLineInserted := true; until TempEmplPaymentBuffer.Next() = 0; end; local procedure UpdateDimensions(var GenJnlLine3: Record "Gen. Journal Line") var DimBuf: Record "Dimension Buffer"; TempDimSetEntry: Record "Dimension Set Entry" temporary; TempDimSetEntry2: Record "Dimension Set Entry" temporary; DimVal: Record "Dimension Value"; NewDimensionID: Integer; DimSetIDArr: array[10] of Integer; begin NewDimensionID := GenJnlLine3."Dimension Set ID"; if SummarizePerEmpl then begin 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 ID" := DimVal."Dimension Value ID"; TempDimSetEntry."Dimension Value Code" := DimBuf."Dimension Value Code"; TempDimSetEntry.Insert(); until DimBuf.Next() = 0; NewDimensionID := DimMgt.GetDimensionSetID(TempDimSetEntry); GenJnlLine3."Dimension Set ID" := NewDimensionID; end; GenJnlLine3.CreateDimFromDefaultDim(0); if NewDimensionID <> GenJnlLine3."Dimension Set ID" then begin DimSetIDArr[2] := NewDimensionID; DimSetIDArr[1] := GenJnlLine3."Dimension Set ID"; GenJnlLine3."Dimension Set ID" := DimMgt.GetCombinedDimensionSetID(DimSetIDArr, GenJnlLine3."Shortcut Dimension 1 Code", GenJnlLine3."Shortcut Dimension 2 Code"); end; if SummarizePerEmpl then begin DimMgt.GetDimensionSet(TempDimSetEntry, GenJnlLine3."Dimension Set ID"); if AdjustAgainstSelectedDim(TempDimSetEntry, TempDimSetEntry2) then GenJnlLine3."Dimension Set ID" := DimMgt.GetDimensionSetID(TempDimSetEntry2); DimMgt.UpdateGlobalDimFromDimSetID(GenJnlLine3."Dimension Set ID", GenJnlLine3."Shortcut Dimension 1 Code", GenJnlLine3."Shortcut Dimension 2 Code"); end; OnAfterUpdateDimensions(GenJnlLine, SummarizePerEmpl); end; local procedure ShowMessage(Text: Text) begin if GenJnlLineInserted then begin if ShowPostingDateWarning then Text += ReplacePostingDateMsg; if Text <> '' then Message(Text); end; end; local procedure CheckCurrencies(BalAccType: Enum "Gen. Journal Account Type"; BalAccNo: Code[20]) var BankAcc2: Record "Bank Account"; begin if BalAccType = BalAccType::"Bank Account" then if BalAccNo <> '' then begin BankAcc2.Get(BalAccNo); if BankAcc2."Currency Code" <> '' then Error(UnsupportedCurrencyErr); MessageText := EmployeePaymentLinesCreatedTxt; end; end; local procedure ClearNegative() var TempCurrency: Record Currency temporary; TempPayableEmplLedgEntry2: Record "Payable Employee Ledger Entry" temporary; CurrencyBalance: Decimal; begin Clear(TempPayableEmployeeLedgerEntry); TempPayableEmployeeLedgerEntry.SetRange("Employee No.", Employee."No."); while TempPayableEmployeeLedgerEntry.Next() <> 0 do begin TempCurrency.Code := TempPayableEmployeeLedgerEntry."Currency Code"; CurrencyBalance := 0; if TempCurrency.Insert() then begin TempPayableEmplLedgEntry2 := TempPayableEmployeeLedgerEntry; TempPayableEmplLedgEntry2.SetRange("Currency Code", TempPayableEmployeeLedgerEntry."Currency Code"); repeat CurrencyBalance := CurrencyBalance + TempPayableEmployeeLedgerEntry.Amount until TempPayableEmployeeLedgerEntry.Next() = 0; if CurrencyBalance < 0 then begin TempPayableEmployeeLedgerEntry.DeleteAll(); AmountAvailable += CurrencyBalance; end; TempPayableEmployeeLedgerEntry.SetRange("Currency Code"); TempPayableEmployeeLedgerEntry := TempPayableEmplLedgEntry2; end; end; TempPayableEmployeeLedgerEntry.Reset(); end; local procedure DimCodeIsInDimBuf(DimCode: Code[20]; DimBuf: Record "Dimension Buffer"): Boolean begin DimBuf.Reset(); DimBuf.SetRange("Dimension Code", DimCode); exit(not DimBuf.IsEmpty); end; local procedure RemovePaymentsAboveLimit(var PayableEmplLedgEntry: Record "Payable Employee Ledger Entry"; RemainingAmtAvailable: Decimal) begin PayableEmplLedgEntry.SetFilter(Amount, '>%1', RemainingAmtAvailable); PayableEmplLedgEntry.DeleteAll(); PayableEmplLedgEntry.SetRange(Amount); end; local procedure InsertDimBuf(var DimBuf: Record "Dimension Buffer"; TableID: Integer; EntryNo: Integer; DimCode: Code[20]; DimValue: Code[20]) begin DimBuf.Init(); DimBuf."Table ID" := TableID; DimBuf."Entry No." := EntryNo; DimBuf."Dimension Code" := DimCode; DimBuf."Dimension Value Code" := DimValue; DimBuf.Insert(); end; local procedure AdjustAgainstSelectedDim(var TempDimSetEntry: Record "Dimension Set Entry" temporary; var TempDimSetEntry2: Record "Dimension Set Entry" temporary): Boolean begin if SelectedDim.FindSet() then begin repeat TempDimSetEntry.SetRange("Dimension Code", SelectedDim."Dimension Code"); if TempDimSetEntry.FindFirst() then begin TempDimSetEntry2.TransferFields(TempDimSetEntry, true); TempDimSetEntry2.Insert(); end; until SelectedDim.Next() = 0; exit(true); end; exit(false); end; local procedure SetTempEmplPaymentBufferDims(var DimBuf: Record "Dimension Buffer") var GLSetup: Record "General Ledger Setup"; EntryNo: Integer; begin if SummarizePerDim then begin DimBuf.Reset(); DimBuf.DeleteAll(); if SelectedDim.Find('-') then repeat if DimSetEntry.Get( EmployeeLedgerEntry."Dimension Set ID", SelectedDim."Dimension Code") then InsertDimBuf(DimBuf, DATABASE::"Dimension Buffer", 0, DimSetEntry."Dimension Code", DimSetEntry."Dimension Value Code"); until SelectedDim.Next() = 0; EntryNo := DimBufMgt.FindDimensions(DimBuf); if EntryNo = 0 then EntryNo := DimBufMgt.InsertDimensions(DimBuf); TempEmplPaymentBuffer."Dimension Entry No." := EntryNo; if TempEmplPaymentBuffer."Dimension Entry No." <> 0 then begin GLSetup.Get(); if DimCodeIsInDimBuf(GLSetup."Global Dimension 1 Code", DimBuf) then TempEmplPaymentBuffer."Global Dimension 1 Code" := EmployeeLedgerEntry."Global Dimension 1 Code" else TempEmplPaymentBuffer."Global Dimension 1 Code" := ''; if DimCodeIsInDimBuf(GLSetup."Global Dimension 2 Code", DimBuf) then TempEmplPaymentBuffer."Global Dimension 2 Code" := EmployeeLedgerEntry."Global Dimension 2 Code" else TempEmplPaymentBuffer."Global Dimension 2 Code" := ''; end else begin TempEmplPaymentBuffer."Global Dimension 1 Code" := ''; TempEmplPaymentBuffer."Global Dimension 2 Code" := ''; end; TempEmplPaymentBuffer."Dimension Set ID" := EmployeeLedgerEntry."Dimension Set ID"; end else begin TempEmplPaymentBuffer."Dimension Entry No." := 0; TempEmplPaymentBuffer."Global Dimension 1 Code" := ''; TempEmplPaymentBuffer."Global Dimension 2 Code" := ''; TempEmplPaymentBuffer."Dimension Set ID" := 0; end; end; local procedure IsEntryAlreadyApplied(GenJnlLine3: Record "Gen. Journal Line"; EmplLedgEntry2: Record "Employee Ledger Entry"): Boolean var GenJnlLine4: Record "Gen. Journal Line"; begin GenJnlLine4.SetRange("Journal Template Name", GenJnlLine3."Journal Template Name"); GenJnlLine4.SetRange("Journal Batch Name", GenJnlLine3."Journal Batch Name"); GenJnlLine4.SetRange("Account Type", GenJnlLine4."Account Type"::Employee); GenJnlLine4.SetRange("Account No.", EmplLedgEntry2."Employee No."); GenJnlLine4.SetRange("Applies-to Doc. Type", EmplLedgEntry2."Document Type"); GenJnlLine4.SetRange("Applies-to Doc. No.", EmplLedgEntry2."Document No."); exit(not GenJnlLine4.IsEmpty); end; local procedure SetDefaults() begin GenJnlBatch.Get(GenJnlLine."Journal Template Name", GenJnlLine."Journal Batch Name"); GenJnlLine2."Bal. Account Type" := GenJnlBatch."Bal. Account Type"; GenJnlLine2."Bal. Account No." := GenJnlBatch."Bal. Account No."; end; local procedure IncludeEmployee(Employee: Record Employee; EmployeeBalance: Decimal) Result: Boolean begin Result := EmployeeBalance > 0; OnAfterIncludeEmployee(Employee, EmployeeBalance, Result); end; [IntegrationEvent(false, false)] local procedure OnAfterUpdateDimensions(var GenJournalLine: Record "Gen. Journal Line"; SummarizePerEmpl: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeUpdateGnlJnlLineDimensionsFromTempBuffer(var GenJournalLine: Record "Gen. Journal Line"; TempEmplPaymentBuffer: Record "Employee Payment Buffer" temporary) begin end; [IntegrationEvent(false, false)] local procedure OnCopyEmployeeLedgerEntriesToTempEmplPaymentBufferOnAfterCopyEmployeeLedgerEntryFields(var TempEmplPaymentBuffer: Record "Employee Payment Buffer" temporary; EmployeeLedgerEntry: Record "Employee Ledger Entry") begin end; [IntegrationEvent(false, false)] local procedure OnGetEmplLedgEntriesOnAfterSetFilters(var EmployeeLedgerEntry: Record "Employee Ledger Entry"; Positive: Boolean; SkipExportedPayments: Boolean); begin end; [IntegrationEvent(false, false)] local procedure OnAfterIncludeEmployee(Employee: Record Employee; EmployeeBalance: Decimal; var Result: Boolean) begin end;}