Mass Updating Revenue Code Percentages

The Revenue Code Percent Mass Revision Entry window lets you update multiple job revenue code % complete at one time. If you are using the Project Manager's Advisor module, you should only see your assigned jobs.

We recommend that you print the Revenue Edit List after committing the revenue code percentages update to verify the changes. If you do not see expenses, verify that cost codes have been assigned to revenue codes. For more information, see Assigning Cost Codes to Revenue Codes.

To mass update revenue codes:

1. In Microsoft Dynamics GP, go to Transactions > Job Cost > Revenue Code Percent Mass Revision Entry. 

   

   The scrolling window does not display records. Select Redisplay to fill the window.

2. Enter the Date and a Description.
3. Select from the following filters to limit the jobs that display, if needed. If no filters are selected, you will see all job revenue codes.
   • Job Number
   • Division
   • Revenue Type
   • Project Number
   • Project Manager
   • Customer Number
   • Show Included Only checkbox - Displays the revenue codes marked for commitment.

4. Select Redisplay. 

   

   Inactive or jobs that are excluded from RPO are not included in the displayed jobs.

5. Select a job to display all revenue codes assigned to that job with their current percentage complete.
6. Mark the 100% checkbox to update the code to 100% complete. The revenue amount will be included in the Revenue GL entry that is created for the job or division during the month end process. (Or enter a percentage amount in the revised field.)
7. Select Print to review the edit list.
8. Select Commit to commit the changes.

If you select Clear, all changes that were entered as well as filters will be cleared.