Cash Management

This section contains enhancements in Infor Financials and Supply Management.

Reopen transactions after PaymentVoidStopPayUpdate is completed

Added the ability to open a Voided or Stop Paid cash ledger payment, after it was updated by the Payment Void Stop Pay Update process.

Program/Business class/Process affected:

  • CashLedgerPayment
  • CashLedgerTransaction
  • CashLedgerGLDistribution

To test the enhancement:

  1. Void or Stop Pay a Cash Ledger Transaction related to a Cash Ledger Payment.
  2. Run Payment Void Stop Pay Update.
    Note: A new action called Reopen Cash Ledger Payment is on Cash Ledger Transaction. Running this action reverses the void payment distributions. It also puts the Cash Ledger Transaction back to an open status and the Cash Ledger Payment record into a Historical status.

JT-1724155

Sort payment output transactions using cash ledger payment fields

Added the ability to define Sort Options for Cash Ledger Payments on Cash Requirements Result.

Program/Business class/Process affected:

  • CashLedgerPayablesPayment
  • CashRequirementsResult
  • CashRequirementsTemplate

To test the enhancement:

  1. Create a Cash Requirements Result for Cash Ledger Payments.
  2. Add Cash Payment Sort Options to Cash Requirements.
  3. Test that when Electronic Payment Creation or Payment Clearing file Creation is run, the records are numbered in the sort order defined on Cash Requirements.

JT-1667974

New cash management group accounts for transaction currency

Provided the ability to specify payment currency difference gain loss accounts when the Invoice Currency is different than the Payment/Cash Code Currency for Accounts Payable and Cash Ledger payments.

Program/Business class/Process affected:

  • CashManagementGroup (bl/ui)
  • CashLedgerPayment (bl)
  • PayablesInvoicePAyment (bl)

To test the enhancement:

Verify that when the Invoice Currency is different than the Payment/Cash Code Currency for Accounts Payable and Cash Ledger payments, gain loss records are created using the new Currency Difference Gain or Currency Difference Loss account on the Cash Management Group (if populated). If not populated the system will continue to use the current gain loss accounts.

JT-1707179

Fixed issue with positive pay file

Positive Pay ignored valid transactions if there was a failure in the PaymentVoidStopPayUpdate job .

Program/Business class/Process affected:

  • Positive Pay File Creation

To test the enhancement:

Run Positive Pay File Creation with a failed Payment stop void pay update job. The valid transactions must be picked up and reported.

JT-1707084

Require cash ledger transaction validation

Added the ability to edit duplicate cash ledger transaction numbers at the bank account level. This feature is used when multiple cash codes are assigned to the same cash management account.

Program/Business class/Process affected:

  • CashLedgerTransaction
  • CashManagementAccount

To test the enhancement:

  1. Select the Edit Duplicate Transaction Numbers By Account check box on the Cash Management Account.
  2. Verify that you cannot add the same transaction number for the same bank transaction code that exists for another cash code assigned to the same cash management account.

JT-1707076

Added write off function for open cash ledger transactions

Transactions remaining in an Open state can now be changed to a Write Off status. Distributions are created from Cash Management to a specified write off account.

Program/Business class/Process affected:

  • CashLedgerTransaction
  • CashLedgerTransactionError

To test the enhancement:

  1. In the Process Cash Ledger menu, select the Write Off item.
  2. From the Open Transactions list, select an item and choose Write Off Transaction.
  3. After specifying an account and post date, confirm the transaction. Verify distributions are created in the cash account and specified write off account.

JT-1549117

Save historical versions of the Reconciliation Balances Report

Added the ability to save historical versions of the Reconciliation Balances Report. The Save All Versions of Reconciliation Balances Report option is found on the Cash Management Account.

Program/Business class/Process affected:

  • BankStatement (bl/ui)
  • BankStatementHistory (bl/kf/ui)
  • CashManagementAccount (bl/ui)
  • CTMReconcileCashStatement_ST.secclass
  • IEFINCommonViewInformation_ST.secclass
  • ReconciliationReconcileCashStatement_ST.secclass

To test the enhancement:

  1. Select the Save All Versions of Reconciliation Balances Report check box in Cash Management Account.
  2. Verify that the old and current versions of the Reconciliation Balances Report are saved in the detail section for the Reconciliation Balances Report.
    Note: Both versions are saved and can be accessed in the related list. The current version of the report is still attached to the Reconciliation Balances Report list.

For details on exactly what was changed in these files, please see Infor CloudSuite Financials & Supply Management Security Delta document for this update.

JT-1480186