This chapter contains these topics:
Section 31.2, "Creating Preliminary G/L Entries for Revenue,"
Section 31.6, "Reviewing and Posting G/L Entries for Revenue."
To record the unbilled revenue for the current period, you must create General Ledger (G/L) journal entries. The amounts related to these entries appear on your income statements and balance sheets when you complete the revenue recognition process. You can use the recognized revenue amounts for projections and to review the profitability or liability of specific departments in your company.
Working with G/L entries consists of the following tasks:
Creating preliminary G/L entries
Reviewing preliminary G/L entries
Creating final G/L entries
Reviewing and posting G/L entries
JD Edwards World strongly recommends that you create and carefully review preliminary G/L entries before you create the final entries that post to the general ledger. If you post out-of-balance records to the general ledger, you must manually correct these balances.
The following graphic illustrates the revenue recognition process.
From Contract Billing Processing (G52), choose Revenue Recognition
From Revenue Recognition (G4823), choose Journal Generation (P48132)
When you use the revenue recognition and billing process, you recognize revenue before you create invoices. You recognize revenue by creating journal entries for the General Ledger (G/L). You first create preliminary G/L entries.
When you create the entries, the system calculates revenue amounts for fee line pricing types and prints the Revenue Journal Generation report. You can also set processing options to print the Billing Journal Register and to segregate error journals in an error batch.
You must run the Journal Generation program to calculate revenue for fees and create preliminary G/L entries for T&M, component, unit, lump and fee line pricing types.
You should carefully review the Revenue Journal Generation and Billing Journal Register reports to ensure that the preliminary entries are correct so that you do not create final journal entries that create out-of-balance records in the general ledger.
When you run Journal Generation, the system:
Uses data selection and processing options to select Billing Workfile (F4812) transactions to process
Calculates revenue amounts for fee line pricing types and creates transactions in the Billing Workfile for the fees.
Creates journal reclassification entries if the Journal Reclassification Control option is activated in the Billing Constants
Processes the workfile transactions against the Account Derivation Table rules to determine the accounts for the journal entries
Temporarily stores the details for the preliminary G/L entries in the Detail Journal Workfile (F48910).
Prints the Revenue Journal Generation report (R48132) with journal entry detail.
Compresses the detail journal workfile information and temporarily stores it in the Compressed Journal Workfile (F48911).
Prints the Billing Journal Register (R48300) with the compressed information as a summary of the journal entry detail.
Figure 31-2 Revenue Journal Generation - Job
Topic | Description |
---|---|
G/L document types | The system can create seven different types of G/L entries. You can use the following document type codes to determine the origination of your journal entries:
|
Error batch segregation | If you have an error in a batch of journal entries, you do not have to stop processing the journal entries until it is corrected. If you set the processing option for error batch segregation, the system places any journal entries with errors in a separate batch. Then, you can continue processing the batch of journal entries without errors and correct the batch with errors at a later time.
The error batch segregation processing option works as follows:
Note: If you select error batch segregation, the Revenue Journal Generation program requires additional processing time. |
See Also:
Chapter 34, "Set Up System Constants" for more information about using journal reclassification,
Appendix D, "Retrieval Reference Codes" for more information about how the Contract Billing system uses account derivation rules,
After you create preliminary G/L entries, you can review the resulting journals to verify that the account information is correct.
Reviewing journals for G/L entries consists of the following:
Reviewing the batch header and status
Reviewing revenue journal details
JD Edwards World strongly recommends that you create and carefully review preliminary G/L entries before you create the final entries that post to the general ledger. If you post out-of-balance records to the general ledger, you must manually correct these balances.
To review the batch header and status
From Contract Billing Processing (G52), choose Revenue Recognition
From Revenue Recognition (G4823), choose Batch Review (P48221)
On Batch Review
Complete the following field:
User ID
Figure 31-4 Batch Review (User ID) screen
If you place an asterisk is the User ID field, the system displays all batches created by all users regardless of the batch activity status.
To limit the list of batches, complete the following optional fields:
Batch Number
Batch Date From
Batch Date Thru
Batch Status
Current Activity
Review the following fields for a batch:
Batch Number
Total Amount
Current Activity
Batch Status Description
To review revenue journal details
From Contract Billing Processing (G52), choose Workfile Generation
From Workfile Generation (G4822), choose Revisions (P4812)
If you want to review the workfile transaction details for a batch of revenue journals, you must use the Revisions form. You use a processing option to control whether the system displays the Revenue Batch Number field in the upper portion of the form.
When you enter the revenue batch number on the Revisions form, the system displays all transaction information. The system marks transactions in an active revenue batch with an R and displays the revenue batch number in the lower portion of the form. You cannot revise workfile transactions in a revenue batch.
On Revisions
Complete the following field to locate transactions in a revenue batch:
Revenue Batch Number
To limit the display of transactions, complete a combination of the following fields:
Customer Number
BCI Number
Account Number
Employee/Supplier
Contract Number
Equipment Worked
Subledger
Subledger Type
Job Type
Job Step
G/L Date From
G/L Date Thru
Choose Total Amounts For All Records.
You can also re-print the Journal Edit Register (R48300) from the Revenue Recognition menu (G4823) to view the preliminary summarized journal entries. You can use this report to verify the accounting entries.
Due to the complexity and volume of preliminary revenue or costing journal entries in a batch, you cannot revise preliminary detail journal entries. To understand how to correct batches in error, you need to understand the types of errors detected by the system. You can correct errors and reset the error status of a batch, as outlined below.
When you create a batch of preliminary revenue or costing journal entries, the system validates the entries. Any resulting errors are either General Accounting setup errors or Billing system setup errors.
These errors are caused by incorrect setup information in General Accounting (System 09). You can usually correct these errors without having to delete the revenue batch. You can make the necessary corrections in the General Accounting system and re-run the Journal Edit Register. The system edits the preliminary journal entries again, and if the system does not detect errors, the batch status updates and indicates no errors. You can then create final journal entries.
These errors are caused by incorrect setup information in the Billing system (System 48S). These errors require that you delete the batch of preliminary journal entries and make the necessary corrections to setup information in the Service Billing system. You must then re-run Revenue Journal Generation (P48132) to create the preliminary journal entries. Note that each time you run Revenue Journal Generation, the system assigns a new batch number. If the system does not detect errors, the batch status indicates no errors and you can continue processing final journal entries.
Topic | Description |
---|---|
Deleting a batch | To delete a batch, inquire on it in Batch Review on the Revenue Generation menu, then choose the Delete option (Option 9) and press Enter. On the Batch Submission Screen, choose Submit Batch (F6). To verify the batch delete, choose Submit Job (F6). |
From Contract Billing Processing (G52), choose Revenue Recognition
From Revenue Recognition (G4823), choose Create G/L Entries (P48198)
You complete the revenue recognition process by creating and posting journal entries that relate to the transactions. The system stores the final G/L entries in the Account Ledger table. When you create final G/L entries, the system:
Uses the Billing Batch Header (F48011) information to create a batch header in Financials (F0011)
Uses the Compressed Journal Workfile (F48911) transactions to write the final journal entries to the Account Ledger (F0911)
Uses the Detail Journal Workfile (F48910) transactions to update the G/L Link (F48912), if the Create Link (LINK) field is populated in the Account Derivation Table (P48126)
Updates the Payroll History File (F0618) with any payroll reclassification entries, if applicable
Updates the workfile transactions as processed to G/L. If the Eligibiliby Code (ELGC) of the workfile transactions is 2 (revenue and cost only) or 4 (cost only), the system copies the workfile transaction to Billing Workfile - History (F4812H) and deletes it from the Billing Workfile (F4812)
Changes the journal status (JRST) for the related workfile transactions
Deletes the records in the Detail Journal Workfile and the Compressed Journal Workfile
Removes the batch header number for the revenue journals from the Billing Batch Header (F48011)
After you create the final G/L entries, you cannot change or delete the batch of journal information.
On Create G/L Entries
Figure 31-5 Create G/L Entries (Batch Validation) screen
Complete the following field and press Enter:
Batch Number
Choose Submit Batch (F6).
The system displays a message prompting you to verify the batch post submission.
Choose Submit Job (F6).
From Contract Billing Processing (G52), choose Revenue Recognition
From Revenue Recognition (G4823), choose Post G/L Journal
After you create the final G/L entries, you complete the revenue recognition process by reviewing, approving, and posting the journal entries.
The journal review and post programs are the same programs you use in the Accounts Receivable and General Accounting systems.