Title: Why does my Project Accounting report say "multiple" or show blank for Rates?
This page documents the various reasons that a Project Accounting report (such as the JSR) may display "multiple" or display as blank in the RATE column.
- For any report row that is actually an indirect cost element (and therefore has an indirect rate), the rate that exists on the last day of the current period is determined.
- If you have a single fringe Cost Element, with different rates in different fiscal years, then when you run the report across multiple years the most current rate is displayed in the RATE column.
- When multiple Cost Structures are charged to the same project, the word "multiple” is displayed.
- If a you have multiple fringe Cost Elements added together on a single line of the cost report definition, then the rate field becomes blank.
What’s covered in this document:
The Text "multiple" in the RATE Column of the Project Accounting Report
When multiple Cost Structures are charged to the same project, or if projects are rolled up into the same report, the word "multiple” is displayed. Below are some various scenarios for how multiple Cost Structures appear in reports.
Multiple Cost Elements/Structures for people
If multiple rate structures are applied to different people on the same project, then it is possible that multiple rates for a given indirect may be involved. This may happen either via the default cost structure/element in the Person profile, or via a Cost Element override in an assignment.
Multiple Cost Elements/Structures for projects
Another reason "multiple" can appear in the RATE column is if you have rolled up multiple projects for divisions, and if those projects have different Cost Structures or Cost Elements for which varying indirect rates apply. (In the JSR criteria, the Roll up all selected projects into a single block check box is selected in the REPORTING OPTIONS section.)
Multiple Cost Structures between Labor and Project Profile Cost Structure
If any labor is associated with a Cost Structure that is different from the Project Profile's Cost Structure, "multiple" may appear in the JSR in the RATE column. This is true even if no Expenses are charged to the project.
This can be identified by first ensuring that all labor has been mapped, and then drilling down to see which Cost Structures have been charged against. If any Cost Structure charged is different from the Project Profile's Cost Structure, "multiple" will appear in the main JSR. (Recall that the Project Profile Cost Structure serves solely to map Expenses and not Labor, since Labor follows either the Cost Structure of the Person Profile or of the Person Assignment to the Project.)
Adjustments That Pertain to Other Cost Structures
If any adjustments exist that pertain to more than one Cost Structure, then "multiple" will appear in the main JSR. This is true even if the adjustments net to zero, and if there is only one Cost Structure for existing (correcting) time. This situation may be identified via an Export that shows all adjustments and the Cost Structures that they pertain to.
How to view source of multiple indirect rates
To view the various rate applications or overlapping dates, click on the Actuals link under the LABOR DETAILS or ODC DETAILS in the header of the JSR. This will show you the break out of labor (or expenses) by Cost Element/Structure. You can then view the actual rates at Admin > Setup > Cost Structures > Indirect Cost Rates tab.
Blank Value in the RATE Column of the Project Accounting Report
If there are multiple indirect Cost Elements that are added together on a single line of the JSR, then the RATE column will be blank instead of saying “multiple.” In the screenshot below, Overhead is blank in the RATE column because there is more than one Overhead rate.
*Even if the two Overhead rates are the same, the field will be blank.