Global Ledger CU68

This section contains enhancements in Infor CloudSuite Financials for 11.0.68.0.

Period open for Process Retained Earnings action

You can verify whether the retained earnings ledger, by entity, is open for the basis end period. A new action was created to process the retained earnings via journal entry, as some countries require an automated entry to updated retained earnings. The retained earnings entry will sum all the expense account type totals from the income statement. This total is booked into a expense summary system account, and the offset will hit retained earnings. All the revenue account type totals from the income statement are summed. This total is booked into the revenue summary system account, and the offset will hit retained earnings. Verify that each entry is four lines per ledger processed. This must be done before year end close, and run similar to the year end close process.

Program/Business class/Process affected:

  • ReportingBasisYear

Use these steps to test the enhancement:

  1. Sign in as a Controller.
  2. Select Setup > Finance Enterprise Group > Maintenance.
  3. Open a finance enterprise group and select the Reporting Basis tab.
  4. Open the reporting basis for which to process the retained earnings and select the Process Retained Earnings check box.
  5. Click Save.
  6. Two new system accounts are created for revenue summary and expense summary. Open the system account and create the account number for each. A retained earnings ledger is automatically created. This ledger is where the retained earnings entry are placed.

To run retained earnings:

  1. Sign in as a Controller.
  2. Select Processing > Reporting Basis > Reporting Basis.
  3. Select a reporting basis. In the Basis Year Close pane, right-click the basis year and select Process Retained Earnings. You can run the action by a single entity or entity group.

Things to test or expectations:

  1. Verify that the entry totals are what is expected for all ten currencies (Functional, Alternate1, Alternate2, Alternate3, Project, Report1, Report2, Report3, Report4, Report5).

    If there are multiple ledgers, separate entries for each ledger should be created. Run two consecutive retained earnings and verify that the second process does not create any entries. Verify that the entry changes to a Posted status. Verify that the entries include these items:

    • A revenue summary amount
    • A retained earnings amount that offsets the revenue summary
    • An expense summary amount
    • Another retained earnings amount that offsets the expense summary amount. .

    Verify that four lines are standard per ledger

  2. Verify that the retained earnings entry has an error if the retained earnings ledger is not open for entries for the basis end period. If one entity is not open for posting, then an error is returned. No entry is posted until all selected entities are open for posting for the retained earnings ledger.
  3. Check the ledger list when trying to select a ledger. Verify that the correct ledgers are displayed for the entity.

JT-1386273

Move To Deleted list refreshing

The Move to Deleted action in GeneralLedgerJournalControl now runs in the GLTransactionDetailPurge queue instead of the default queue. If any failed job exists in the queue, the Move To Deleted action will not run until the failed job is cleared. The user is prompted for confirmation and the list is refreshed.

Program/Business class/Process affected:

  • IEFINPostUpgradeAction
  • GeneralLedgerJournalControl

Use these steps to test the enhancement:

  1. Perform the action on unreleased GL Journals, with some journals having more than 100 transactions. The action should prompt for confirmation. Click OK and the list should refresh. The journals for selected for deletion should no longer be displayed on the Unreleased tab. The journals should be displayed on the Deleted tab.

JT-1392811

Security rules for GeneralLedgerTotal business class

Security rules were created for the GeneralLedgerTotal business class that include all dimensions.

Program/Business class/Process affected:

  • Usage of Security Groups

Use these steps to test the enhancement:

  1. Search the Totals list for GL totals and note how long it takes to display to give you a baseline.
  2. Use an actor that has the GLController_ST role, but not ApplicationAdministrator_ST.
  3. Use a finance enterprise group that has at least two finance dimensions in use.
  4. Create an accounting entity group if one does not already exist.
  5. Create a security group for the accounting entity group.
  6. Create a security group for the two finance dimensions.
  7. Add the actor to the security groups.
  8. Search the Totals list again and note how long it takes to display.
  9. Verify that the correct records are displayed filtered against the security group definitions.
  10. Note that GL total records that have a blank value displayed in a field that is being filtered.

JT-1393230

Retained earnings journal

A retained earnings automated journal entry is available at year end. All currencies are correctly reflected in the journal entry, not just functional currency. A new action was created to process the retained earnings in the journal entry, as some countries require an automated entry to updated retained earnings. The retained earnings entry calulates a sum for all expense account type totals from the income statement. This total is booked into a expense summary system account, and the offset will hit retained earnings. All the revenue account type totals from the income statement are summed. This total is booked into the revenue summary system account, and the offset will hit retained earnings. Verify that each entry is four lines per ledger processed. This must be done before year end close, and run similar to the year end close process.

Program/Business class/Process affected:

  • GeneralLedgerTotal
  • GeneralLedgerTransaction

Use these steps to test the enhancement:

  1. Sign in as a Controller.
  2. Select Setup > Finance Enterprise Group > Maintenance.
  3. Open a finance enterprise group and select the Reporting Basis tab.
  4. Open the reporting basis for which to process the retained earnings and select the Process Retained Earnings check box.
  5. Click Save.
  6. Two new system accounts are created for revenue summary and expense summary. Open the system account and create the account number for each. A retained earnings ledger is automatically created. This ledger is where the retained earnings entry are placed.

To run retained earnings:

  1. Sign in as a Controller.
  2. Select Processing > Reporting Basis > Reporting Basis.
  3. Select a reporting basis. In the Basis Year Close pane, right-click the basis year and select Process Retained Earnings. You can run the action by a single entity or entity group.

Things to test or expectations:

  1. Verify that the entry totals are what is expected for all ten currencies (Functional, Alternate1, Alternate2, Alternate3, Project, Report1, Report2, Report3, Report4, Report5). If there are multiple ledgers, separate entry for each ledger should be created. Run two consecutive retained earnings and verify that the second process does not create any entries. Verify that the entry is status is changed to Posted. Verify that the entry includes these items:
    • A revenue summary amount
    • A retained earnings amount that offsets the revenue summary
    • An expense summary amount
    • Another retained earnings amount that offsets the expense summary amount.

    Four lines are standard per ledger.

  2. Verify that the retained earnings entry has an error if the retained earnings ledger is not open for entries for the basis end period. If one entity is not open for posting, then an error is returned. No entry is posted until all selected entities are open for posting for the retained earnings ledger.
  3. Check the ledger list when trying to select a ledger. Verify that the correct ledgers are displayed for the entity.

JT-1393372

Ledger option for retained earnings entry

A ledger option was added when running the retained earnings entry. A new action was created to process the retained earnings via journal entry, as some countries require an automated entry to updated retained earnings. The retained earnings entry will sum all the expense account type totals from the income statement. This total is booked into a expense summary system account, and the offset will hit retained earnings. All the revenue account type totals from the income statement are summed. This total is booked into the revenue summary system account, and the offset will hit retained earnings. Verify that each entry is four lines per ledger processed. This must be done before year end close, and run similar to the year end close process.

Program/Business class/Process affected:

  • GeneralLedgerTotal
  • ReportingBasisYear
  • AccountingEntityHeirarchy

Use these steps to test the enhancement:

  1. Sign in as Controller.
  2. Select Setup > Finance Enterprise Group > Maintenance.
  3. Open a finance enterprise group and select the Reporting Basis tab.
  4. Open the reporting basis for which to process the retained earnings and select the Process Retained Earnings check box.
  5. Click Save.
  6. Two new system accounts are created for revenue summary and expense summary. Open the system account and create the account number for each. A retained earnings ledger is automatically created. This ledger is where the retained earnings entry are placed.

Use these steps to run retained earnings:

  1. Sign in as Controller.
  2. Select Processing > Reporting Basis > Reporting Basis.
  3. Select a reporting basis. In the Basis Year Close pane, right-click the basis year and select Process Retained Earnings. You can run the action by a single entity or entity group.

Things to test or expectations:

  1. Verify that the entry totals are what is expected for all ten currencies (Functional, Alternate1, Alternate2, Alternate3, Project, Report1, Report2, Report3, Report4, Report5). If there are multiple ledgers, verify that a separate entry for each ledger is created. Run two consecutive retained earnings and verify that the second process does not create any entries. Verify that the entry status is Posted. Verify that the entry includes these item:
    • A revenue summary amount
    • A retained earnings amount that offsets the revenue summary
    • An expense summary amount
    • Another retained earnings amount that offsets the expense summary amount

    Four lines are standard per ledger.

  2. Verify that the retained earnings entry contains an error if the retained earnings ledger is not open for entries for the basis end period. If one entity is not open for posting, then an error is returned. No entry is posted until all selected entities are open for posting for the retained earnings ledger.
  3. Check the ledger list when trying to select a ledger. Verify that the correct ledgers are displayed for the entity.

JT-1395269

Income statement memo accounts in average daily balance (ADB)

Income statement memo accounts do not update the undistributed retained earnings balances in average daily balance.

Program/Business class/Process affected:

  • GeneralLedger/bl/GeneralLedgerTransaction.busclass

Use these steps to test the enhancement:

  1. Configure average daily balance. Verify that the Use All Balance Sheet Accounts and Include Undistributed Retained Earnings check boxes are selected.
  2. Create and post GL transactions using an income statement with account type Memo.
  3. Run Daily Balance.
  4. Check the average daily balance report.

If there are existing ADB records for income statement memo account, you must rebuild ADB for URE:

  1. Check the average daily balance report for calculated balances for your income statement memo accounts.
  2. If there are calculated balances, run Rebuild ADB for URE to update the report. All income statement memo accounts are excluded from the report. Otherwise, do not rebuild.

JT-1397112

Mobile Journal Approver role - Journal Entries Approval screens

The Journal Entries Approval screens were changed for the mobile Journal Approval role.

Program/Business class/Process affected:

  • GeneralLedgerJournalControl.busclass

Use these steps to test the enhancement:

  1. Sign in to Infor Go.
  2. Open the inbox.
  3. Open the pending approval JournalControl record.
  4. There has been a redesign of the Mobile Journal approval form. The DerivedAccountingEntityNameID, DerivedJournalID,TransactionDate, AccountingEntity.AlternateCurrency, AlternateDebitAmount, and AlternateCreditAmount fields have been added. An actor was added in the form.
  5. Journal value has been removed from the title.
  6. The AccountDescription field was added to the Transactions panel in PhoneGeneralLedgerTransactionForm.
  7. To test, send various types of journals for approval. Then select My Inbox > Tasks and open the approval form. Verify that the changes have been made.

JT-1383193

Inter Entity Netting Journal should follow the Approval process flow

Code changes were made for InterEntityNetting Journals to follow the Approval process flow

Program/Business class/Process affected:

  • FinanceEnterpriseGroup
  • AccountingEntityGroup
  • AccountingEntity
  • GeneralLedgerJournalControl

Use these steps to test the enhancement:

  1. Two new fields were added on the InterEntityNetting Action form: Approval Required and Approval Code. If Approval Required is selected during the InterEntitytNetting action, verify that the journals that are created go into a Pending Approval state. If the Approval Required check box is cleared, the journals should go to a Posted state.

JT-1389977