Contents of the Revenue Generation Form

Use these fields and options to set up and run the revenue generation process.

Field Description
Saved Options You can select a saved search.
Organize Click this option to display the Organize Options dialog box.
Default Click this option to restore the original settings of all options on this form.
Select Specific Project

Use this option to select the projects for which to run the revenue generation process or the projects with percent complete figures that you want to review or update on the Update Overall Percent Completes dialog box.

Use project reporting default terms for WIP @ Billing calculations

Work in progress (WIP) calculations make it possible to calculate accrued revenue for work that is completed but not yet billed.

If you select this option, the revenue generation process calculates revenue for work in progress by using any billing terms for expenses and labor that are specified for a project. If a project has no billing terms specified for expenses and labor, revenue generation uses the usual billing terms that are specified in Project Reporting for regular projects. This option applies to all projects that are selected for the revenue generation processing run. The process also uses project billing terms to calculate WIP revenue for projects that do not show specific labor and expenses amounts on the invoice, such as a project with a contract that specifies a fixed fee or a lump sum.

Replace existing unposted revenue generation journal entry of same file name

Select this option to replace the unposted revenue generation transaction file. This action does not erase archived revenue generation files. When this option is cleared, a message displays to tell you that if you continue, you will overwrite a RevGen transaction file.

To open a revenue generation transaction file, use the Transaction Center.

Post revenue as it is generated (do not create a transaction file)

Revenue data from the revenue generation process displays in reports only after it is posted.

When this check box is cleared, a RevGen transaction file is created when you run the revenue generation process. You must post this journal entry file in Transaction Center > Transaction Posting before you can generate reports that show the revenue.

Select this check box to post revenue as it is generated, without creating a separate transaction file that you manually must post in the Transaction Center. You might want to do this if:

  • You run revenue generation on a project whose data is updated, to make it possible to generate new project reports for the project manager.
  • You want to prove out a project's revenue method. Compare the revenue on a project report to the revenue calculated by revenue generation.

If you select this check box, the Journal Entry File Name field is inactive.

Deltek recommends that you do not use this option unless you know the amount to be posted or you want to use the amount to prove out a revenue method.

If you are licensed to use the PSA module and you have QuickBooks integration enabled, the Post revenue as it is generated (do not create a transaction file) check box does not display. You must post the RevGen transaction file in Transaction Center > Transaction Posting.

Transaction Date
Enter or select the transaction date for the revenue journal entries. This field is only available if both of the following are true:
  • DPS is set up to require that transaction dates fall within the current fiscal year or current fiscal period. The date that you enter must meet that requirement.
  • DPS is not set up to track multiple currencies for your enterprise.
Journal Entry File Name

This field shows the filename for the journal entry file that you create when you run revenue generation. Use this field to edit the usual filename, which has this format:

RevGen[today's date]

The first six letters must be RevGen.

If you use multiple companies, the suffix of the filename identifies the active company.

Field Description
Currency Exchange Date If you use multiple currencies, specify the date to use to calculate the amount that is converted from the project's billing currency to the functional currency of the active company, or for any other currency exchange. Revenue generation calculates revenue in the project's billing currency. To post revenue to the general ledger, it changes this amount to the equivalent amount in the active company's functional currency.

Enter data in this field before you open the Update Overall Percent Completes dialog box. The currency exchange date controls the amounts that are shown in that dialog box.

If DPS is set up to require that transaction dates fall within the current fiscal year or current fiscal period, you can only select Today's Date if the current date meets that requirement. Similarly, if you select Specific Date, the date that you enter must meet that requirement.

Diary This field displays only if you have set up a diary for the fiscal period or fiscal year in which you are entering transactions in the Diary Auto Numbering Options section of the Transaction Settings form in Settings > Accounting > Transactions.

Use this field to select a diary code for the current transaction or the group of transactions if you are processing a group of transactions, such as in a vendor payment run. The diaries are used to generate diary reports that contain a set of sequentially numbered transactions that have been posted to the general ledger during the fiscal year or to specific fiscal periods. You can assign different diaries (that have different diary types) to different types of transactions.

The Diary drop-down list contains three columns. The first column displays the diary code. The second and third columns display the diary type for the diary code and the description of the diary type.

The drop-down list contains all the diaries that you set up on the Diary Auto Numbering Options section in Transactions Settings that have the same fiscal period or fiscal year in which you are entering transactions or that have no fiscal period or year entered for them.

If you have multiple companies in DPS, the Diary field drop-down list includes only the diary codes that are set up for the current company. The list also includes IC - Intercompany Diary to capture intercompany transactions.

You cannot delete a transaction after it has been saved with a diary number. If a transaction is incorrect, you can enter zero amounts for the transaction or enter a reversing transaction.