How Do I Limit Revenue on Reimbursable Expenses

If you use revenue method P for a project, you can limit the revenue that is generated from reimbursable expenses.

To do this, you define a revenue method in which revenue is calculated as the lesser amount of these calculations of P:

  • % Complete * Compensation + JTD Reimbursable Expenses

or

  • % Complete * Compensation + Reimbursable Allowance

First define a method that calculates this alternative to P. Then define a method that takes the lesser of P or the alternative method.

To define the method that calculates the alternative to P, complete the following steps:

  1. From the Vision Navigation menu, click Configuration > Accounting > User Defined Revenue.
  2. On the User Defined Revenue form, click Insert.
  3. On the Revenue Methods dialog box, enter the code and the description.
  4. Enter the formula (Percent Complete * Compensation) + Reimb Allowance.
  5. When you finish, click Save.

    The User Defined Methods list shows the new method.

    To define the completed method, that takes the lesser of P or the alternative, complete the following steps.

  6. On the User Defined Revenue dialog box, click Insert.
  7. On the Revenue Methods dialog box, enter the code and description.

    Use this new method to limit revenue on reimbursable expenses.

  8. In the Operators list, click Lesser of.....
  9. In the First Method column, select Method P.
  10. In the Second Method column, select the alternative method.
  11. Click OK.
  12. Click Save.
  13. In the Project Info Center, specify the second method for each project on which to limit revenue that is generated from Reimbursable Expenses.

    Because it uses a mix of % Complete and Reimbursable Expenses, this formula may calculate revenue differently than you might think. But Revenue Generation will recognize the correct amount of revenue after the project is complete.

    As an alternative, you can limit the revenue that is generated from reimbursable expense data by defining a new method that applies the Subject to Max operator to Method P's formula:

    % Complete * Compensation + JTD Reimbursable Expenses [Subject to Max]