Codeunit 1710 Exp. User Feedback Pos. Pay
src/Layers/W1/BaseApp/Bank/PositivePay/ExpUserFeedbackPosPay.Codeunit.al112 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.Bank.PositivePay;using Microsoft.Bank.Check;using System.IO;/// <summary>/// Provides user feedback and audit trail creation for positive pay export operations./// This codeunit manages the creation of tracking records and status updates after successful export processing./// </summary>/// <remarks>/// The Export User Feedback Positive Pay codeunit handles post-export processing including the creation of/// positive pay entry records for audit trail purposes and updating check ledger entries with export tracking/// information. It ensures that all exported check data is properly recorded for compliance and troubleshooting./// The codeunit creates both summary entries and detailed check records to maintain a complete audit trail/// of positive pay file transmissions to banks./// </remarks>codeunit 1710 "Exp. User Feedback Pos. Pay"{ Permissions = TableData "Check Ledger Entry" = rimd, TableData "Positive Pay Entry" = rimd, TableData "Positive Pay Entry Detail" = rimd; TableNo = "Data Exch."; trigger OnRun() var CheckLedgerEntry: Record "Check Ledger Entry"; PositivePayEntry: Record "Positive Pay Entry"; BankAccNo: Code[20]; LastUpdateDateTime: DateTime; begin // Update the CheckLedgerEntry for the Data Exch. Entry No. as exported successfully CheckLedgerEntry.SetRange("Data Exch. Entry No.", Rec."Entry No."); CheckLedgerEntry.SetRange("Positive Pay Exported", false); CheckLedgerEntry.SetFilter( "Entry Status", '%1|%2|>%3', CheckLedgerEntry."Entry Status"::Printed, CheckLedgerEntry."Entry Status"::Posted, CheckLedgerEntry."Entry Status"::"Test Print"); if CheckLedgerEntry.FindFirst() then BankAccNo := CheckLedgerEntry."Bank Account No."; CheckLedgerEntry.ModifyAll("Positive Pay Exported", true, true); // Update the CheckLedgerEntry for the Data Exch. Voided Entry No. for Checks as exported successfully CheckLedgerEntry.SetRange("Data Exch. Entry No."); CheckLedgerEntry.SetRange("Data Exch. Voided Entry No.", Rec."Entry No."); CheckLedgerEntry.SetFilter( "Entry Status", '%1|%2|%3', CheckLedgerEntry."Entry Status"::Voided, CheckLedgerEntry."Entry Status"::"Financially Voided", CheckLedgerEntry."Entry Status"::"Test Print"); // Only populate the BankAcct if there were no open checks found in case there are no voids if BankAccNo = '' then if CheckLedgerEntry.FindFirst() then BankAccNo := CheckLedgerEntry."Bank Account No."; CheckLedgerEntry.ModifyAll("Positive Pay Exported", true, true); if BankAccNo <> '' then LastUpdateDateTime := GetLastUploadDateTime(BankAccNo); // Initialize Pos. Pay Enties PositivePayEntry.Init(); PositivePayEntry.Validate("Bank Account No.", BankAccNo); PositivePayEntry."Last Upload Date" := DT2Date(LastUpdateDateTime); PositivePayEntry."Last Upload Time" := DT2Time(LastUpdateDateTime); // Retrieve the range of exported data and move Pos. Pay Entry Detail tables CreatePosPayEntryDetail(PositivePayEntry, Rec."Entry No.", BankAccNo); Rec.CalcFields("File Content"); PositivePayEntry."Exported File" := Rec."File Content"; PositivePayEntry.Insert(); end; local procedure GetLastUploadDateTime(BankAccNo: Code[20]): DateTime var PositivePayEntry: Record "Positive Pay Entry"; begin // Retrieve the Last Updated Date and Time to set in the new record PositivePayEntry.SetRange("Bank Account No.", BankAccNo); if PositivePayEntry.FindLast() then exit(PositivePayEntry."Upload Date-Time"); end; local procedure CreatePosPayEntryDetail(var PositivePayEntry: Record "Positive Pay Entry"; EntryNo: Integer; BankAccNo: Code[20]) var PositivePayEntryDetail: Record "Positive Pay Entry Detail"; PositivePayDetail: Record "Positive Pay Detail"; begin PositivePayDetail.SetRange("Data Exch. Entry No.", EntryNo); if PositivePayDetail.FindSet() then repeat PositivePayEntryDetail.Init(); PositivePayEntryDetail."Upload Date-Time" := PositivePayEntry."Upload Date-Time"; PositivePayEntryDetail.CopyFromPosPayEntryDetail(PositivePayDetail, BankAccNo); if PositivePayEntryDetail."Document Type" = PositivePayEntryDetail."Document Type"::CHECK then begin PositivePayEntry."Number of Checks" += 1; PositivePayEntry."Check Amount" += PositivePayEntryDetail.Amount; end else begin PositivePayEntry."Number of Voids" += 1; PositivePayEntry."Void Amount" += PositivePayEntryDetail.Amount; end; PositivePayEntry."Number of Uploads" += 1; PositivePayEntryDetail.Insert(); until PositivePayDetail.Next() = 0; end;}