Global Ledger

This section contains enhancements in Financials and Supply Management.

Created an option to allocate any number of dimensions and access weight data from Global Ledger

A new option is available to select summary overrides for three or more dimensions. You can create a single setup for multiple dimension overrides.

The frequency of maintaining allocation lines for each period is minimized so that users can set up dimension overrides and weight address one time and maintain them as required.

You can use the Allocation system to allocate more than one dimension using the Dimension and Weight Data Builder. The weight data is retrieved directly from GLTotal based on the selected Dimension Overrides and Source Address. To use the builder, set the Allocation Line Override Option to Dimension Override and Weight Builder and complete the builder field.

This functionality is a pre-process that is embedded in the Allocation Run process. The retrieval of weight data is generated before the actual calculation of the allocation run.

  1. On the Allocation Control form, create Dimension Override and Weight Data Builder record.
  2. In the builder, select an amount of dimension overrides. Assign a summary or top node to the selected dimension overrides. Click Next.
  3. In the builder, fill-out the dimensions in the Weight Data Source. Click Next.
  4. Save the record.
  5. Create an Allocation and Allocation Line.
  6. Set From or To Mapping Override Option to Multiple Dimension.
  7. Set Override Type to Dimension Override and Weight Builder.
  8. Assign a Dimension Override and Weight Builder.
  9. Run the Allocation.
  10. Verify that the amount is split and allocated.

JR-3266991

Add Required Project boolean to Global Ledger Account

Add the ability to flag an Account as requiring a Project.

Added the Require Project field to Account and added edits on the transaction finance code block to give an error when the require project is true on the account and no project is entered.

  1. Open the FEG and select Account
  2. Open the Account to require project and select the check box for the field Require Project.
  3. Enter a JE to the account without entering a posting project. Save and get error that project is required.

JR-3537732

Add message when Accounting Unit or Finance Dimension 1 control units

The message indicates that Structure Relations are required when selecting Accounting Unit or Finance Dimension 1 unit control.

New message field informing users that Structure Relations with Accounts are required.

  1. Verify that the blue alert message appears when selecting Accounting Unit or Finance Dimension 1 in the unit control field.

JR-3449586

Improve security groups for faster processing

Improve response when inquiring upon General Ledger Transaction, GL Transaction Detail, and GL Procurement Expense records when Security Groups are being used.

Viewing lists for General Ledger Transaction, GL Transaction Detail, and GL Procurement Expense can use all Security Groups, but runs as efficiently.

Before testing, create a large number of General Ledger Transaction, GL Transaction Detail, and GL Procurement Expense record.

  1. Create a Security Group for three types of records
  2. Capture the response time for these:
    • My Reports > Transactions > Finance Transcations tab
    • My Reports > Transactions > Finance Transaction Detail > Detail Transaction tab
    • Supply Management > Purchasing Processing > Departmental Procurement Expenses > Procurement Expense Details
  3. Take updated code
  4. Perform step 2 again and verify that the response time has improved.

JR-3561478

Additional work on Recurring Journal Card View

Update Recurring Journal's description title and Process Period on the cardview to prevent wrapping and include the description in the list title.

The new card view description title is limited to show 20 characters. The Process Period date is shown below the label, to prevent from wrapping. The recurring journal description added to the Recurring Journal Schedule title list.

  1. Verify the card view description title and process period field, and the new list title shows the Recurring Journal, Description - Recurring Journal Schedule.

JR-5091880

Request action for Finance Dimension 6 and Finance Dimension 7

Implemented the new feature Request Action for Finance Dimension 6 and Finance Dimension 7.

  1. Sign in as Application Administratior and select Financials > Global Ledger > Setup > Finance Enterprise Group > Maintenance.
  2. Select a Finance Enterprise Group > Finance Dimension 6 > Structure > Hierarchy
  3. Use the Request New action to create a Finance Dimension 6 and submit for approval.
  4. Sign in as an Approver and approve the record.
  5. Verify that a new Finance Dimension 6 is created.
  6. Use the steps above to test the Finance Dimension 7.
  7. Verify that a new Finance Dimension 7 is created.

JR-3539187

Allow wildcard on Reset All Errors in General Ledger Transaction Interface

A new Reset All Errors for Selected Run Groups action is available where we can use wildcard characters for multiple Run Groups.

Business classes changed:

  • modules
  • GeneralLedger
  • bl
  • Finanace Enterprise Groups.busclass

A new Reset All Errors for Selected Run Groups menu item is added to Transaction Interface.

  1. Sign in as Application Administrator and select Financials > Global Ledger > Processing > Transaction Interface.
  2. Create a few transactions with different Run Groups but with similar names.
  3. Run Interface Transaction for these Run Group so that errors are created.
  4. Select Financials > Global Ledger > Processing > Transaction Interface > Reset All Errors for Selected Run Groups.
  5. Run the action using wildcard characters in the Run Group field.
  6. After the action is completed, ensure the errors are reset for the transaction with similar Run Groups.

JR-3306557

Update list message when data reload refresh is running

The cube status messaging to improve the cube status description.

The cube offline status messaging displays Cube is Unavailable.

Verify the new cube status list message is accurate.

JR-5092338

Improve conditions for security groups for faster processing

Improve response when inquiring upon General Ledger Transaction, GL Transaction Detail, and GL Procurement Expense records when Security Groups are used.

Viewing lists for General Ledger Transaction, GL Transaction Detail, and GL Procurement Expense will potentially use all Security Groups, but will also respond in a reasonable amount of time.

  1. Prior to taking updated code, create a large number of General Ledger Transaction, GL Transaction Detail, and GL Procurement Expense records (several hundred thousand ideally)
  2. For the user under test, create Security Groups for three types of records.
  3. My Reports > Transactions > Finance Transactions > Transactions tab.
  4. My Reports > Transactions > Finance Transaction Detail > Detail Transactions tab.
  5. Supply Management > Purchasing Processing > Departmental Procurement Expenses > Procurement Expense Details and capture the response time.
  6. Take the updated code.
  7. Perform steps 3-5 again and record the response time.
  8. Verify that the response time has improved.

JR-3561478