Cash Management

This section contains enhancements in Infor Financials and Supply Management

Reconciled Tolerance tracking in Cash Ledger

Enhanced the Bank Statement form to include a tab with a list of matched statement lines with the variance. Added a new relationship from BankStatement to BankStatementReconciliation with an instance selection of summary records that are reconciled with a difference (SummaryIncludesReconDiff = true). A list of bank statement reconciliation records with this relationship is available on the new tab.

Use these steps to test the enhancement:

  1. Create a Bank Statement and Bank Statement lines.
  2. Reconcile to transactions with some of them reconciling with a difference.
  3. Verify that the new Matched Records with Variances tab is available on the Bank Statement form.

JR-3259931

No loading in HTML5 and long loading time in Rich Client for EFTExtractOutputFileHeader and PaymentOuputFileHeader

No loading in HTML5 and long loading time in Rich Client for EFTExtractOutputFileHeader and PaymentOuputFileHeader business classes due to high record count and total amount field value.

Added TotalNumberOfRecords and TotalPaymentAmount fields in EFTExtractOutputFileHeader and PaymentOuputFileHeader business classes and updated them while running EFTExtractUpdate and ElectronicPaymentCreation jobs respectively. In UI, replaced derived fields with new fields and with these changes we avoided calculations while opening the record.

Use these steps to test the enhancement:

For EFTExtractUpdate job:

  1. Create Electronic Funds Transfers with different Company & CashCode combinations.
  2. Run the EFTExtractUpdate job with all possible combinations.
  • Company & CashCode
  • Company & CashCodeGroup
  • CompanyGroup & CashCode
  • CompanyGroup & CashCodeGroup

All scenarios should generate EFT Extract Output Files with the correct Count and Total amounts.

For ElectronicPaymentCreation job:

  1. Create Payables Invoices with different possible Bank Transaction Code and CashCode combinations.
  2. Select and Schedule CashRequirements.
  3. Run the ElectronicPaymentCreation job with all possible combinations.
  • PaymentCode & CashCode
  • PaymentCode and CashCodeGroup
  • CombineOutputByAccount
  • All scenarios should generate Payment Output Files with the correct Count and Total amounts.

JR-3260996

Accrual screen to show outstanding Electronic Fund Transfer Transactions in the clearing account at month end

A screen to show all the outstanding Electronic Fund Transfer Transactions that are in the clearing account at the month end was requested. Currently there is no screen available, and the reports are derived manually.

A new list was added to show the open/outstanding Electronic Fund Transfer Transactions that are in the clearing account at the month end.

  1. Sign in as Cash Accountant and select Process Cash Ledger > OpenEFTTransactionsSearch.
  2. Confirm new list has been added
  3. Confirm that Payments in an unreleased or pending approval state are not listed.
  4. For non-canceled payments, confirm that the list will include records that meet these conditions:
    • TransactionDate <= ReportDate and
    • DepositDate not entered or DepositDate >= ReportDate and
    • RejectedDate not entered or RejectedDate >= ReportDate
  5. For canceled EFTs, additional conditions are: TransactionDate > ReportDate and the first CashLedgerGLDistribution.PostDate is <= ReportDate.

JR-3266222