Project Ledger

This section contains enhancements in Infor Financials and Supply Management.

Add GLTransactionDetail search that filters by project personnel

Program/Business class/Process affected:

  • Added a new GLTransactionDetail search that is filtered by project personnel.
  • Added a Project Personnel Transaction Detail tab

Use these steps to test the enhancement:

  1. Assign your user as a project personnel to a posting project.
  2. Access the Searches menu.
  3. Select the Project Personnel Transaction Detail tab.
  4. Verify that any projects to which you are the assigned as project personnel are displayed in the top list.
  5. Select a project and verify that any transaction that is posted to the project is displayed in the bottom list.

Dependencies:

Must be using the project personnel feature.

JT-1727089

Add Pending Cost Transfer Tab

Program/Business class/Process affected:

  • Added a Pending Cost TransfersLabor Distribution page.
  • Added a Pending Cost Transfers tab to the By Employee and By Period views on the Labor Distribution page.
  • Added a hyperlink to the Period column on the processed labor distribution tab. Users can click the link to open the processed labor tab and run the redistribute action. tab to the

Use these steps to test the enhancement:

  1. Access the Labor Distribution page.
  2. Verify that the pending cost transfer tabs are displayed.

Dependencies:

Must be a grant accounting labor distribution user.

JT-1725495

Add validation functionality for the Project finance structure

tab to theProvide a more simplified and efficient process to validate project coding than what is currently available with Structure Relations/Valid Pairs. Customers requested an enhancement similar to the S3 Activity Management AC07 Account Assignment functionality. With this functionality, rules were configured based on which GL coding strings are valid for project only or for project and account category.

Program/Business class/Process affected:

  • These new business classes were added:
    • ProjectCodeBlockDimension
    • ProjectStructureValidation
    • ProjectStructureValidationRule
    • StructureValidationDimension
    • ProjectStructureValidation

Use these steps to test the enhancement:

  1. Access a finance enterprise group and add a Project Structure Validation Dimension.
  2. Access the Project Structure Validation form and define the rules for project validation
  3. Enable the rules for Project Structure Validation by running the action to enable them on the FEG.
  4. Go to the GL Journal and enter transactions to verify the validation rules.

JT-1720335

Add Validate Journal Entries actions for projects

Journal transactions are created by the actions for a project by defaulting pieces of the code block from a combination of setup and expense transactions. Currently there is no way to test the combinations before journalizing. Any code block errors result in ES (Error Suspense) entries and require the user to reverse the journal, correct the errors, and journalize again. This enhancement adds new actions to validate journal entries before running the journalize actions.

Program/Business class/Process affected:

  • These new business classes were added:
    • ProjectStructureValidationTest
    • ProjectStructureValidationResult
    • ProjectStructureValidationErrorActions
  • These new actions were added:
    • Validate Labor Journal Entries
    • Validate Indirect Burden Journal Entries
    • Validate Invoice Journal Entries
    • Validate Revenue Journal Entries

Use these steps to test the enhancement:

  1. Run the Generate Invoices action.
  2. Run the Validate Invoice Journal Entries action.
  3. Access the Project Finance Structure Validation Results list. If there are errors, then correct the setup and retest.
  4. Repeat these steps for the Distribute Labor, Generate Indirect Burdens, and Recognize Revenue actions.

JT-1723632

Add journalize group to the filter for Labor Distribution Search

Program/Business class/Process affected:

  • Labor Distribution Search list

Use these steps to test the enhancement:

  1. Sign in as Project Accountant.
  2. Access the Labor Distribution Search page.
  3. Verify that you can filter the search results by journalize group.

Dependencies:

Must be a grant accounting labor distribution user.

JT-1723075

Add selection group to Labor Schedule to provide default initial value to Distribute Labor action

Provided the ability to require that a selection group is entered when running the Distribute Labor action. Users can define a selection group as the default initial value when running the Distribute Labor action. A Process All Transactions check box was also added to the Distribute Labor action. Users are prevented from running the action without selecting a selection group or selecting the check box.

Program/Business class/Process affected:

  • Added a new field to the ProjectLaborSchedule for the default selection group
  • Added a new check box to the Distribute Labor action to process all transactions

Use these steps to test the enhancement:

  1. Add a default selection group to the project labor schedule.
  2. Access the Distribute Labor action.
  3. Select the labor schedule and verify that the default selection group displays as the initial value.
  4. Clear the selection group and verify that an error is displayed that a selection group or the Process All Transactions check box is required.

JT-1729067

Filter the Labor Distribution search to include only employees where a ProjectEmployee record exists

The Labor Distribution search included GlTransactionDetail records for employees without a ProjectEmployee record.

Program/Business class/Process affected:

  • Labor Distribution Search

Use these steps to test the enhancement:

  1. Add GLTransactionInterface records with a resource (employee) for employees that have ProjectEmployee records and for employees that do not.
  2. Run the Interface and Post actions.
  3. Access the Labor Distribution Search page.
  4. Verify that only GLTransactionDetail records for employees who have a ProjectEmployee record are displayed.

Dependencies:

Must be a grant accounting user.

JT-1729637

Add column for fully distributed labor to Processed Labor Distribution

A project assignment is skipped if it starts or ends mid-labor period and the transaction date for the pay wage falls outside of the assignment date range. If the assignment is skipped, then the employee's wages are not fully distributed. Customers require the ability to view labor distributions that are not fully distributed.

Program/Business class/Process affected:

  • Processed labor distribution list

Use these steps to test the enhancement:

  1. Go to the Labor Distribution page.
  2. Verify that a Fully Distributed column is displayed in the Processed Labor Periods list in the By Employee view and the By Period view.
  3. Verify that No is displayed in the column if the Actual % is greater than zero and the transaction amount is zero.
  4. Verify that Yes is displayed in the column if the Actual % is greater than zero and the transaction is not equal to zero.

Dependencies:

Must be a grant accounting labor distribution user.

JT-1723674

Add Funding Source to Project Contract Totals tab

Program/Business class/Process affected:

  • Project contract

Use these steps to test the enhancement:

  1. Open a project contract.
  2. Select the Totals tab.
  3. Verify that the project funding source is displayed in the second column.

JT-1722495

Add currency default to project and project contract setup

Customers are required to enter the currency on the posting project and the project contract setup. A default currency code was added to the project structure. Logic was added to the project and the project contract rules so the default value is used if the currency code is left blank.

Program/Business class/Process affected:

  • Project
  • ProjectContract
  • ProjectUpload

Use these steps to test the enhancement:

  1. Specify a default currency code on the project structure.
  2. Add a posting project and leave currency code blank.
  3. Verify that the default value for the currency code is defaulted.
  4. Repeat the test and specify a currency code.
  5. Verify that the default value is overridden.
  6. Repeat the test for project contract and project upload.

JT-1725492

Set Reset Indirect Burden Status parameter to true for the Reverse Labor Distributions actions

When the Reverse Labor Distribution action is run, the status from the transaction that is being reversed is inherited by the action. If the IDB (indirect burden) calculation has been run, then the status is set to Processed. A Reset Indirect Burden Status check box with a default value of selected was added.

Program/Business class/Process affected:

  • Reverse Labor Distribution action

Use these steps to test the enhancement:

  1. Access the Reverse Labor Distribution action.
  2. Verify that the Reset Indirect Burden Status check box is displayed and selected.

Dependencies:

Must be a grant accounting user.

JT-1730942