Metadata Changes when Enabling Revenue Recognition for PSA

When you enable the Enabling Revenue Recognition for PSA feature in Feature Console, the following fields are created:

Object Field Description
Project Actuals Template Lookup to a template for recognizing revenue on the project. This field is not used by the standard integration which recognizes revenue on source records at Level 2 in the object hierarchy.

Include in Revenue Recognition

Indicates whether or not the project is included for revenue recognition.
Recognized to Date Stores the revenue that has been recognized to date for the project.
Total Projected Revenue The total projected revenue amount.
% Complete The percentage of the project that is complete.
Milestone Actuals Template Lookup to a template for recognizing revenue on the milestone.

Include in Revenue Recognition

Indicates whether or not the milestone is included for revenue recognition.
Recognized to Date Stores the revenue that has been recognized to date for the milestone.
Start Date The milestone's start date.
% Complete The percentage of the milestone that is complete.
Expense Actuals Template Lookup to a template for recognizing revenue on the expense.
Start Date The expense's start date.
% Complete The percentage of the expense that is complete.
Timecard Split Actuals Template Lookup to a template for recognizing revenue on the timecard split.
Bill Rate The timecard split's bill rate.
Resource Name The resource name on the timecard split.
% Complete The percentage of the timecard split that is complete.
Miscellaneous Adjustment Actuals Template Lookup to a template for recognizing revenue on the miscellaneous adjustment.
Include in Revenue Recognition Indicates whether or not the miscellaneous adjustment is included for revenue recognition.
Start Date The miscellaneous adjustment's start date.
% Complete The percentage of the miscellaneous adjustment that is complete.
Recognition Transaction Line Project Lookup to the project associated with this recognition transaction line.
Milestone Lookup to the milestone associated with this recognition transaction line.
Expense Lookup to the expense associated with this recognition transaction line.
Timecard Split Lookup to the timecard split associated with this recognition transaction line.
Miscellaneous Adjustment Lookup to the miscellaneous adjustment associated with this recognition transaction line.

Recognition Settings

This table lists the recognition settings records that are created for the PSA source objects.

 

Project

Milestone

Expense

Timecard Split

Misc. Adjustment

Recognition Settings Name

Project Settings

Milestone Settings

Expense Settings

Timecard Split Settings

Miscellaneous Adjustment Settings

Settings Level

Primary

Level 2

Level 2

Level 2

Level 2

Parent Lookup

blank

pse__Proj__c

pse__Proj__c

pse__Proj__c

pse__Proj__c

Object

pse__Proj__c

pse__Milestone__c

pse__Expense__c

pse__Timecard__c

pse__Miscellaneous_Adjustment__c

Settings Type

Actual

Actual

Actual

Actual

Actual

Value Type

Revenue

Revenue

Revenue

Revenue

Revenue

Reference

pse__Account__c

 

pse__Resource__c

ffrrResourceName__c

 

Description

Name

pse__Description__c

pse__Description__c

Name

Name

Start Date

pse__Start_Date__c

ffrrStartDate__c

ffrrStartDate__c

pse__Start_Date__c

ffrrStartDate__c

End Date

pse__End_Date__c

pse__Target_Date__c

pse__Expense_Date__c

pse__End_Date__c

pse__Effective_Date__c

Total Revenue

ffrrTotalProjectedRevenue__c

pse__Milestone_Amount__c

pse__Billable_Amount__c

pse__Total_Billable_Amount__c

pse__Amount__c

Active Field

pse__Is_Active__c

pse__Approved__c

pse__Submitted__c

pse__Submitted__c

pse__Approved__c

Active Value

TRUE

TRUE

TRUE

TRUE

TRUE

Include Active Value

Include

Include

Include

Include

Include

Currency

CurrencyISO

CurrencyISO

CurrencyISO

CurrencyISO

CurrencyISO

% Complete

ffrrPercentComplete__c

ffrrPercentComplete__c

ffrrPercentComplete__c

ffrrPercentComplete__c

ffrrPercentComplete__c

Completed Field

ffrrIncludeinRevenueRecognition__c

ffrrIncludeinRevenueRecognition__c

pse__Approved__c

pse__Approved__c

ffrrIncludeinRevenueRecognition__c

Completed Value

TRUE

TRUE

TRUE

TRUE

TRUE

Include Completed Value

Include

Include

Include

Include

Include

Total Units

 

pse__Billable_Days_In_Financials__c

 

pse__Total_Hours__c

 

Rate

 

pse__Default_Bill_Rate__c

 

ffrrBillRate__c

 

Revenue Recognized to date Value

ffrrRecognizedToDate__c

ffrrRecognizedToDate__c

     

Income Statement*

9999

9999

9999

9999

9999

Balance Sheet*

9999

9999

9999

9999

9999

Fixed IS GLA Code

TRUE

TRUE

TRUE

TRUE

TRUE

Fixed BS GLA Code

TRUE

TRUE

TRUE

TRUE

TRUE

*Update these fields to use the correct GLA codes for your business.

Recognition Templates

The following recognition templates are created for use with the Level 2 settings records detailed above.

Milestone:

  • Milestone - % Complete
  • Milestone - Deliverable
  • Milestone - Equal Split 445
  • Milestone - Equal Split Days
  • Milestone - Equal Split Months
  • Milestone - Equal Split Months/PP
  • Milestone - Equal Split Months/PP with Actual Days

Expense:

  • Expense - Deliverable

Timecard Split:

  • Timecard Split - Deliverable

Miscellaneous Adjustment:

  • Miscellaneous Adjustment - Deliverable