Project Ledger CU73

This section contains enhancements in Infor CloudSuite Financials for 11.0.73.0.

Certify Effort on posting project Labor Distribution tab

A Certify Effort Boolean field was added to the posting project labor distribution and effort certification forms and lists. The default value is false. The field was added as a column on the Effort Certification form Certification Required. The projects that are federally sponsored and require effort certification are indicated on the column. The Project Accountant, Project Certifier, and Project Resource roles use the column. A derived field and column is added to the open effort periods list with the column label Certification Required for the period. If any project or assignment effort certification is required, the value is true.

Program/Business class/Process affected:

Project Business Class

Use these steps to test this enhancement:

  1. Validate that the field was added to the ProjectUpload business class and form.

JT-1451488

Table for Finance Dimension 2 funding source Major Category field

The ProjectMajorCategory business class is added to store the Major Category field on Finance Dimension2. A table is added that allows users to load or specify valid major categories. Users can move the existing major category stored on finance dimension 2 to the ProjectMajorCategory business class. Users can select values from a valid list of major categories.

Program/Business class/Process affected:

  • ProjectMajorCategory
  • FinanceDimension2.MajorCategory

Use these steps to test this enhancement:

  1. Open a FinanceDimension2 posting record with type = External Grant. Select the Grant Reporting tab. Valid values are not available for the Major Category field. Setup is accessed by selecting Project Administrator > Project Setup > Major Category.

JT-1453880

Delete processed project assignment labor records with no actual or effort percent

You can delete processed project assignment labor records where no actual or certified effort percent exists. You can delete any assignments that were added after other assignments for the same time span have been processed by labor distribution. You can delete assignments that are not required because labor was never specified for them.

Program/Business class/Process affected:

ProjectAssignmentLabor

Use these steps to test this enhancement:

  1. Delete project assignment labor records. The records should be deleted if ProjectAssignmentLabor records with a status of Process exist with ActualPercent greater than 0. Otherwise, ProjectAssignmentEffort records with a status of Certified must exist with EffortPercent greater than 0.

JT-1455577

Invoiced, recognized, and remaining balance amounts to Finance Dimension 2 posting Funding Source List

These amounts have been added to the Finance Dimension 2 posting Funding Source List:

  • Funded
  • Invoiced
  • Remaining invoice funded balance
  • Recognized
  • Remaining revenue balance
  • Currency

Amounts are persisted on ProjectFundingSource.

Program/Business class/Process affected:

  • Business Class = FinanceDimension2
  • List Name = FinanceDimension2PersonResponsibleFlatList

Use these steps to test this enhancement:

  1. Open the FinanceDimension2 posting list.
  2. Validate that the posting list includes these values on the Finance Dimension 2 posting Funding Source List:
    • Funded
    • Invoiced
    • Remaining invoice funded balance
    • Recognized
    • Remaining revenue balance amounts
    • Currency
  3. Open one of the records and select the Project Contracts tab to display the details by contract. The Add Contract field should be displayed as a hyperlink that drills into the ProjectContract composite form.

JT-1456233

Populating effort from average actual effort percentages

An action has been added to populate effort percentages from average actual percentages. Records are adjusted for any rounding issues to a tenth of a percent by the action. The populate effort percentages action can only be run when the system date is after the effort period end. All labor periods must be processed for the effort period.

Program/Business class/Process affected:

Effort Certification forms

Use these steps to test this enhancement:

  1. Populate the effort percentage using the average actual percentages. Percentages can still be specified manually.
  2. Any rounding adjustments or corrections are made by the action. The rounding adjustment is made to the last record containing a percentage.
  3. The action is available by employee on Effort Certification forms. The action is available as a mass action to update all employee effort for an effort schedule or period.

JT-1464918

Summarizing invoices

You can summarize an invoice by project, account or account category billing override, or resource.

Program/Business class/Process affected:

  • Project Invoicing

A new business class is added to store summarized invoice amounts. The Generate Invoice, Remove Lines, Regenerate Invoice, and Journalize Invoice actions are impacted. Fields are added to ProjectContract and ProjectContractInvoiceLine business class. New standard invoice templates and IDM templates are created. The new template detail is mapped to the ProjectContractInvoiceSummary business class. These are the new templates:

  • SampleProjectSummaryInvoiceTemplate. rtf
  • SampleProjectSummaryInvoiceTemplate.pdf
  • SampleProjectSummaryInvoiceReversalTemplate. rtf
  • SampleProjectSummaryInvoiceReversalTemplate.pdf

Use these steps to test this enhancement:

  1. Select Summarize Invoice on the project contract and select dimension options for the summary.
  2. Attach the new summary invoice format to the project contract for invoice and invoice reversal.
  3. Generate the invoice and validate the Summary Lines tab and view invoice. If the summary is not correct, update the parameters and run the Create Summary Invoice action. Test invoice reversal.

JT-1284081

Add XMApprover type to Project Roles

XM has the requirement for CSF to specify the project expense report approver. This enhancement includes:

  1. Adding ProjectRole.Type = XMApprover.
  2. Adding a constraint on ProjectPersonnel that only a single active project personnel record can exist for each posting project where the ProjectRole.Type = XMApprover.

Program/Business class/Process affected:

  • ProjectRole
  • ProjectPersonnel

Use these steps to test this enhancement:

  1. Create a project role where the role type is XMApprover.
  2. Create a project personnel record for the project where the role is XMApprover.

JT-1286004

Select posting project when running Generate Invoices, Recognize Revenue, and Forecast actions

You can select a posting project on the Generate Invoices, Recognize Revenue, and Forecast Billing and Revenue actions for a project contract. You can run for a single posting project under a project contract.

Program/Business class/Process affected:

  • Generate Invoice
  • Recognize Revenue
  • Forecast Billing and Revenue

Use these steps to test this enhancement:

  1. Run the Generate Invoice, Recognize Revenue, and Forecast Billing and Revenue actions.
  2. Verify that you can select a posting project.
  3. Running the actions for the individual posting project should only update that project.

JT-1463493