Global Ledger

Cash offsets and edits for allocations

For Fund Accounting, functionality has been added to create cash offset allocation transaction detail lines for allocations designated to requiring cash offsets.

Program/Business class/Process affected:

• Allocation
• AllocationLine
• AllocationsMenu.menu

Use these steps to test the enhancement:

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

• IEFINCommonViewInformation_ST.secclass
• GLBasicSetupAdmin_ST.secclass

Use these steps to test the enhancement:

1. Define the Allocation Fund Accounting Rules to indicate how the cash offset Allocation Transaction Detail records will be created.
2. Create Allocations. On the Allocation, define the cash offset account to use to post the offset detail records.
3. Run the allocations. The fund accounting rules that you defined are used to create the cash offset transactions. If the offset does not pass the cash code fund edit, then the transaction results in an error.

JT-1581170

Display Local Obligation and Cube Obligation Last Refresh and Last Reload Time Stamp

To verify that Cube Obligations and Cube Budget are updated, navigate to Budget Template > Groups > Group Data and view the concern period.

Program/Business class/Process affected:

• /modules/GeneralLedger/bl/BudgetTemplate.busclass
• /modules/GeneralLedger/ui/BudgetTemplate.busclass
• Cube Update Details tab is added on Budget Template page

Use these steps to test the enhancement:

Verify these items in Budget Template page:

1. Verify that the latest cube refresh and correct reload date are displayed during creation.
2. Verify that the existing data, with recorded obligation, is displayed correctly with the correct latest local obligation date, latest cube refresh, and cube reload date.
3. Verify that the existing data, with no recorded obligation, is displayed correctly with latest cube refresh and cube reload date.

JT-1591718

In the budget change order, provide visibility to the remaining budget amount

When performing a change request, where the change must be Balanced, the total remaining budget should be considered for that particular line to ensure that the change is not greater than the remaining balance. This enhancement assists the user in knowing the amount that they can request.

Program/Business class/Process affected:

• /modules/GeneralLedger/bl/BudgetChangeOrderLine.busclass
• /modules/GeneralLedger/ui/BudgetChangeOrderLine.busclass

Use these steps to test the enhancement:

When creating Change Request Line record using Change Request Wizards, verify this information:

i. Total Remaining Budget to display the difference of the Total Budget less the Total Obligations.

ii. New Total Remaining Budget shall be an aggregate of the Total Remaining Budget and Change Request Amount.

iii. Total Remaining Units Amount to display the difference of the Total Units Amount less the Total Units Obligations.

iv. New Total Remaining Units Amount shall be an aggregate of the Total Remaining Units Amount and Change Request Units Amount.

v. "New remaining budget for expense account cannot be less than zero: <new remaining budget>" or "New remaining units amount cannot be less than zero: <new units amount>" will be displayed when an Expense Account new total remaining budget / new total units amount to be less than zero.

vi. Error "New remaining budget for expense account cannot be less than zero: <new remaining budget>" or "New remaining units amount cannot be less than zero: <new units amount>" will be displayed when the change request will cause the new total remaining budget / new total units amount to be less than zero.

vii. Alert message “No existing budget amount” is displayed when change request for a budget data that does not exists for a particular period or when budget data does not have budget amount entered.

viii. Error “No existing budget amount for <Accounting string> <Currency>” when Accounting string and period exists but the currency is different and change request amount is negative.

ix. Alert message “Budget exists for another currency” is displayed when Accounting string and period exists but currency is different change request amount is positive.

x. Error “No existing budget amount for <Accounting string> <Currency>” when doing a 'Quick Change' for an Account string under "From Adjustment" section that does not have a Budget Data.

JT-1454864

[Mobile]: Add Budget Template Tolerance related fields in Budget Template and BudgetEditError screens

Program/Business class/Process affected:

BudgetEditError.busclass

Use this information to test the enhancement:

1. Set Tolerance option in BudgetTemplate as Amount or Percentage
2. Create an Invoice with distributions with over budget amount and release it
3. Sign in as Payables Manager
4. Verify that the Budget Errors tab exists on the Invoice page.
5. On the BudgetEditErrorForm, if Percentage is selected as tolerance, verify that the Tolerance field is replaced with Tolerance Percentage
6. If Amount is selected as tolerance, verify that the Tolerance' field is replaced with Tolerance Amount

JT-1578534

Add ability for GHR to edit General Ledger Accounts before interfacing them

Interfacing GL information from Global Human Resources to Financials and Supply Management

Security changes:

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

FSMValidation_ST (security class)

Use these steps to test the enhancement:

1. From GHR, edit GL transactions before interfacing. For testing, ensure that some of the transactions contain bad data.
2. Verify that errors are displayed on the transactions with bad data in GHR before you run the interface.

JT-1595684

Add the ability to calculate average daily balance by ledger

Added the ability to calculate average daily balance by ledger or by transaction currency code, or both, including income statement accounts.

Program/Business class/Process affected:

• 11.0_post_CU80.faf
• FinanceEnterpriseGroup.busclass
• GeneralLedgerTotal.busclass
• GeneralLedgerTransaction.busclass
• AverageDailyBalanceAccount.busclass
• AverageDailyBalanceAggregate.busclass
• AverageDailyBalanceAmount.busclass
• AverageDailyBalanceTransaction.busclass

JT-1537077

Inter Entity Hub & Spoke function

Inter-Entity journals can now be processed even if there were no transactions for the From Accounting Entity. When the journal is released, a confirmation message is displayed that indicates no transactions exist for the From Entity. You are prompted to proceed with the Release action. The journal status is transitioned to Released, if the applicable.

Before this enhancement, an inter-entity journal got a hard stop at release when no transactions were found for the From Entity.

JT-1581167

UI Changes in ADB to improve usability

Improve Average Daily Balance lists and pages to improve usability.

JT-1600992