To create a new project profitability configuration

To create a new project profitability configuration:

1. Go to Setup > Accounting > Project Profitability.

2. Click New.

3. On the Enter Basic Information page, enter a name and an optional description for your configuration.

4. Click Next.

5. On the Define Rows page, the standard configuration automatically populates the row fields. You can enter new rows and delete or edit the standard configuration to define which items to include in the rows of your report. In the Name field, enter a name for your item group.

6. Click the Edit icon next to the Name field to open the Row popup window.

7. In the Type field, select an item filter and, if applicable, define the filter in the popup window.

   • Items – include or exclude specific items from your report. In the Condition field, select is to include the selected items or is not to exclude the selected items. In the Items field, select the items for this row.

   • Item Types – include all items of a specific type (e.g. non-inventory items). In the Item Types field, select the item types you want included in this row.

   • Individual Expense Categories – include all expenses of a specific category. In the Individual Expense Categories field, select the expense categories you want to include in this row.

   • All Expense Categories – includes all project expense categories.

   • Uncategorized Expenses – include any expenses that do not have items or expense categories.

   Click Set to return to Step 2. Click Add to save your defined row.

   Note:

   Each row can have only one defined type. You may add multiple row definitions to each configuration.

    

8. Repeat the previous step to add rows to your profitability report. When you are finished, click Next.

9. On the Define Columns page, the standard configuration automatically populates the column fields. You can enter new columns and delete or edit the standard configuration to define which accounts to include in the columns of your report. In the Name field, enter a name for your account group.

10. Click the Edit icon next to the Name field to open the Column popup window.

11. In the Transaction Subfilter field, select what kind of transactions to include with this filter—Actual + Committed, Actual, or Committed.

    Actual transactions are completed transactions and have GL impact. Committed transactions are planned transactions and do not yet have GL impact.

12. In the Type field, select an account filter and, if applicable, define the filter in the popup window.

    • Account – include or exclude specific accounts from your report. In the Condition field, select is to include the selected accounts or is not to exclude the selected accounts. In the Accounts field, select the accounts for this column.

    • Account Types – include all accounts of a specific type (e.g. expense). In the Account Types field, select the account types you want included in this column.

    • Time Entry – include all project time entries.

    Click Set to return to Step 3. Click Add to save your defined column.

    Note:

    Each defined column can have multiple account categories. You may add multiple column definitions to each configuration.

     

13. Repeat the previous step to add columns to your profitability report. When you are finished, click Next.

14. On the Define Profitability Calculation page, you select which columns are used to calculate your profitability margin. Select the custom columns to use for your costs and revenue. The information in these columns is used to calculate your profitability for each project.

15. Click Next.

16. On the Reports page, a list of custom reports to be added is populated. In the Summary field, you can update the default names of your custom summary project profitability reports. In the Detail field, you can update the default names of your custom detail project profitability reports.

17. In the Action field, you can choose Create or Do Not Create for each custom report.

18. You can click Finish if you want to stop your configuration without any additional settings or localizations. Click Next to set additional settings or add localizations.

19. On the Settings page, check the box next to any additional transactions you want included in your profitability calculations. Click Finish or Next to add localization information.

    Important:

    If you use the Planned Work feature, checking the Planned Time box can result in duplicate calculation of your committed costs.

     

20. On the Localization page, if you use multiple language, you can enter translations for your terms in your selected language.

21. When you are finished, click Finish.