Cash Management

Cash Allocation Code on Cash Receipt Import

This enhancement allows specifying a Cash Allocation Code on lines for Cash Receipt Import. When a code is specified, the import automatically creates Receipt Detail records for each line, based on the details of that code. This process works the same way as including a code when creating a Receipt Header, or adding codes to an existing header.

Program/Business class/Process affected:

• CashLedgerCashReceiptHeader
• CashLedgerReceiptImport
• 11.0_post_CU80.faf

Use these steps to test the enhancement:

1. Import lines that include Cash Allocation Codes.
2. Confirm that the created Receipt Header has Receipt Details based on the details of the specified codes.

JT-1589793

Cash offsets for journal entries

This functionality in Fund Accounting is used to create the cash offset journals for manually entered journals.

Program/Business class/Process affected:

• GeneralLedgerJournalControl
• GeneralLedgerSetup.menu

Security changes:

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

• IEFINCommonViewInformation_ST.secclass
• GLBasicSetupAdmin_ST.secclass

Use these steps to test the enhancement:

1. Define the General Ledger Fund Accounting Rules to indicate how the cash offset journals will be created.
2. Create a journal and add transactions.
3. Run the Create Cash Offsets action defining the cash GL Account the offsets will be posted to. This will pass the entered journals through the defined fund accounting rules to create the cash offset journals. The journal can then be released which will edit and update cash code fund balances.

JT-1589784

Cash offsets for Imported Journals

This functionality in Fund Accounting is used to create cash offset transactions for imported journals.

Program/Business class/Process affected:

• GLTransactionInterface
• GeneralLedgerSetup.menu

Security changes:

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

• IEFINCommonViewInformation_ST.secclass
• GLBasicSetupAdmin_ST.secclass

Use these steps to test the enhancement:

1. Define the General Ledger Fund Accounting Rules to indicate how the cash offset journals will be created.
2. Create interface records in GLTransactionInterface.
3. Run the Create Cash Offsets action. Select the run group and cash GL Account to which the offsets will be posted. When the Create Cash Offsets action is run, the fund accounting rules are used to create the cash offset journals in the GLTransactionInterface table. You have option to interface the records after the offsets are created or you can interface with the usual process after analyzing the offset records that were created.

JT-1589786

Allow Cash Allocation Code on Cash Ledger Transaction

This enhancement adds a function to dynamically create distribution records by applying a Cash Allocation Code on the Cash Ledger Transaction. If the transaction already has distributions from applying a Cash Allocation Code, you can create more distributions by applying additional cash allocation codes by using the Apply Cash Distribution action.

Program/Business class/Process affected:

• CashLedgerTransaction
• CashLedgerGLDistribution
• 11.0_post_CU80.faf

Use these steps to test the enhancement:

1. Create a Cash Ledger Transaction.
2. Select the Apply Cash Allocation Code check box and specify a Cash Allocation Code and amount. If specifying a code of type Amount, Then specify on the Cash Allocation Code.
3. Click Save and confirm that the appropriate distributions are displayed under Distributions as specified in the code details.
4. When there are distributions, the Apply Additional Cash Allocations action is available. Specify a code and amount, and confirm that appropriate distributions have been created.
5. When there are distributions, the Cash Allocation Code Distribution Delete action is available. Verify that when this action is run and a code is specified, the distributions that were created with that code are deleted. Verify that if a code is not provided, then all distributions that were created with cash allocation codes are deleted.

JT-1589790

Add new Operator field on CB10 CBRECPTHDR

Additional fields were required to store Operator and Date information.

Program/Business class/Process affected:

Cash

To test the enhancement:

Verify that CreatedBy and CreateDate fields are present in CashLedgerCashReceiptHeader. The fields must be automatically populated with the current time and actor during creation.

JT-1586784

Extend cash allocation code digits to 7 (to the right of decimal) for distribution accuracy

Change the number of decimals for the cash allocation code from 3 to 7 to increase the accuracy of the calculations when allocating large amounts.

Program/Business class/Process affected:

• BankStatementLine
• CashAllocationCode
• CashAllocationCodeDetail

To test the enhancement:

1. Verify you are able to enter up to 7 decimals for a percent type allocation code.
2. Verify the amounts are allocated correctly for processes that utilize cash allocation codes.

JT-1582381

LoadBankStatement - Enhancements for TextReference

Done ANZCSV - BankStatement LoadBankStatement - Enhancements for TextReference

Use these steps to test the enhancement:

For setup:

• Enable the receiver for FSM_ION_LoadBankStatement_Inbound.lpd

  Pass the CashManagementGroup in system configuration parameter LoadBankStatement_In_CashManagementGroup

To test the enhancement:

1. Verify that BankStatement and BankStatementLines are created when the BOD is processed.
2. Verify the concatenation of the Particulars, Analysis Code, and Reference data from the Bank Statement BOD xpath:

   BankStatement/BankStatementAccount/AccountEntry/EntryDetail/EntryTransaction/ExternalReferences into the FSM field BankStatementLine.TextReference.

JT-1596907