Global Ledger CU64
Added comments and attachments to Request a New Account action
Provided attachment functionality for Accounts.
Program/Business class/Process affected: Account and Account attachment business classes.
Use these steps to test the new enhancement:
- Verify Create, Update, and Delete of Attachments on Account business class.
- Verify that the Request New Account action allows for a single attachment to be provided.
Security changes
- In GLBasicProcessing_ST, added the following rule:
- AccountAttachment BusinessClass
is accessible
for all actions
unconditionally
- In ReconciliationAuditInquiry_ST, added this rule: AccountAttachment BusinessClass
is accessible
for all inquiries
unconditionally
JT-1337484
Added the ability to calculate ADB for URE account balances
Added the ability to calculate Average Daily Balance for Undistributed Retained Earnings account balances.
Program/Business class/Process affected:
- 11.0_post_CU80.faf
- modules/GeneralLedger/bl/AccountingEntityHierarchy.busclass
- modules/GeneralLedger/bl/FinanceEnterpriseGroup.busclass
- modules/GeneralLedger/bl/GeneralLedgerChartAccount.busclass
- modules/GeneralLedger/bl/GeneralLedgerTransaction.busclass
- modules/GeneralLedger/bl/ReportingBasis.busclass
- modules/GeneralLedger/ui/FinanceEnterpriseGroup.busclass
- modules/ad/bl/ADBAccountMaster.busclass
- modules/ad/bl/ADBAggregateBalance.busclass
- modules/ad/bl/ADBDailyAmount.busclass
- modules/ad/bl/ADBTransaction.busclass
- modules/ad/bl/ResetAverageDailyBalance.bustask
- modules/ad/ui/ResetAverageDailyBalance.bustask (new)
- modules/framework/bl/IEFINPostUpgradeAction.busclass
Use these steps to test the enhancement:
- Check the AverageDailyBalance queue for additional queue mappings.
- With existing ADB processing, on Finance Enterprise Group > Option > select the Include Undistributed Retained Earnings field.
- From Financial Utilities menu, run Reset Average Daily Balance task. On Reset Option select Calculate URE Daily Balance Only. Specify Reporting Basis and Fiscal Year. This task is only accessible to Administrator and Controller roles.
- Check Average Daily Balance report. It should now calculate daily balance for URE within last ADB run date.
- Post additional GL transactions for B/S and I/S accounts. Then run daily balance. Check generated average daily balance report.
- For first ADB processing, no existing ADB records. Enable both all balance sheet accounts and include URE account fields on on Finance Enterprise Group > Option. Run daily balance > check average daily report.
JT-1337819
Average Daily Balance Create Queues
Created new async queue for Average Daily Balance processing
Program/Business class/Process affected: modules/framework/bl/IEFINPostUpgradeAction.busclass
Use these steps to test the enhancement:
- Check new queue AverageDailyBalance on async admin.
- From the Global Ledger Processing menu select Reporting Basis > Run Daily Balance for ADB.
- Check AverageDailyBalance queue, there should be action triggers for ADB.
- From the GL Utilities menu select run Reset Average Daily Balance.
- Check AverageDailyBalance queue, there should be action triggers for ADB.
JT-1351173
[ADB UI Changes] Re-label the utility for Reset Average Daily Balance
Need to relabel ResetAverageDailyBalance.bustask UI according to available rebuild options.
Program/Business class/Process affected:
- modules/GeneralLedger/ui/GeneralLedgerUtilities.menu
- modules/ad/bl/ResetAverageDailyBalance.bustask
- modules/ad/ui/ResetAverageDailyBalance.bustask
Use these steps to test the enhancement:
- From Global Ledger Utilities the menu item for ResetAverageDailyBalance.bustask should now show Rebuild Average Daily Balance instead of Reset Average Daily Balance.
- Open ResetAverageDailyBalance form name should be Rebuild Average Daily
Balance.
Rebuild Option parameter selections should be Reset ADB and Rebuild ADB for URE.
JT-1362629
Provide the ability to generate an actual journal that shows the rolling of retained earnings
Program/Business class/Process affected:
- AccountingEntityHierarchy
- FinanceEnterpriseGroup
- GeneralLedgerJournalControl
- GeneralLedgerTotal
- Ledger
- ReportingBasis
- ReportingBasisYear
- SystemAccount.field
- 11.0_post_CU80.faf
How it works:
A new action is created to process the retained earnings via a 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 and this total will be booked into a newly created Expense Summary system account, and the offset will hit retained earnings. Then it will sum all the revenue account type totals from the Income Statement and this total will be booked into the newly create Revenue Summary system account, and the offset will hit retained earnings. Each entry should be 4 lines per ledger processed. This will need to be done prior to year end close, and run similar to the year end close process.
For Setup:
Sign in as Controller and select Setup > Finance Enterprise Group > Maintenance. Select a Finance Enterprise Group. Go into Reporting Basis. Select Reporting Basis on which you want to process the retained earnings entry. Click on the “Process Retained Earnings” check box. Click Save.
This will create two new System Accounts (Revenue Summary and Expense Summary). Go into the System Account and create the account number for each. Also, a new Retained Earnings ledger will be automatically created. This ledger is where the Retained Earnings entry will be placed.
To Run Retained Earnings:
Sign in as Controller and select Processing > Reporting Basis > Reporting Basis. Select “Reporting Basis” from above. Below, right-click on the Basis Year and select “Process Retained Earnings”. You can run this by a single entity or entity group. If it’s the first time running the Process Retained Earnings for the year selected, so do not select the Changed Totals Only button. This button is for any subsequent runs after the initial entry. Note: We are working to disregard the changed totals only based on enhancement requests that are in process.
Things to test or expectations:
Verify that the entry totals are what is expected. If multiple ledgers, it should create separate entry for each ledger. The entry should go straight to a Posted status. The entry should include a Revenue Summary amount, a Retained Earnings amount (that offsets the Revenue Summary, an Expense Summary amount, and another Retained Earnings amount (that offsets the Expense Summary amount). Four lines should be standard per ledger.
JT-1310187
Added new FD2/ Project Funding posting dimension list
Add new FD2/ Project Funding posting dimension list with person responsible column. Column will display the posting projects parent dimension / summary project person responsible if exists.
This report will assist users with create Grant reports by PI (person responsible).
Program/Business class/Process affected: Project
Test the Posting project list
Dependencies:
Summary posting project person responsible must exist for the person responsible to display.
JT-1347275
Add new fields for grant users SEFA reporting
Grant users require more attributes for SEFA reporting. The user now has the ability to attach new fields, Department and Division, to the funding source which will give them the granularity for the federal reporting.
Program/Business class/Process affected:
FinanceDimension2Department, FinanceDimension2Division, FinanceDimension2Structure, FinanceDimension2Upload, ProjectFundingSourceTemplate, ProjectAccountingSetupPage, ProjectFundingSource, FinanceDimension2, GLAdditionalSetupAdmin_ST, IEIFNCommonViewInformation_ST, ProjetcToCompleteSetup_ST
Use these steps to test the enhancement:
From FinanceDimension2 you can now create and attach a Department and Divisions. They are displayed on the Schedule of Federal Awards list.
JT-1357617