Understanding Revenue Recognition Trigger Setup for Service Billing Lines

The system uses triggers to determine if an invoice is sent to the revenue recognition process. Before the system can send a service billing invoice through the trigger process in the JD Edwards EnterpriseOne Accounts Receivable system, the system checks the settings of the Billing Constants in the JD Edwards Contract and Service Billing system. The system sends the invoice to the trigger process if any of the following conditions exist in the Billing Constants:

  • The Journal Generation Control constant is set to Invoice Only.

  • The Journal Generation Control constant is set to Invoice/Revenue without Reconciliation or Invoice/Revenue with Reconciliation. All of the workfile records should be eligible for only invoicing.

  • The Journal Generation Control constant is set to Invoice/Revenue without Reconciliation or Invoice/Revenue with Reconciliation and the Eligibility Override field in Contract Billing Details table (F5202) is set to Invoice Only. All the Non-TM lines (for lump sum and unit price billing lines) are eligible.

Only service billing invoices which are not processed by revenue recognition in the JD Edwards EnterpriseOne Service Billing system are eligible for the revenue recognition process in the JD Edwards Accounts Receivable system.

Note: If the system selects any service billing line (pay item) for the revenue recognition process, the system sends the entire invoice.

To select service billing lines from the JD Edwards EnterpriseOne Contract Billing system for the revenue recognition process, you must define all three triggers (hierarchy, date, and configuration records):

  1. Set up hierarchy by company in the Revenue Recognition Trigger Setup program (P03B420).

    Each organization has different business processes and transaction data that the system uses to determine whether to process an invoice through the recognition process. The system uses specific fields in the transactions to determine whether to submit an invoice to revenue recognition. By setting up the hierarchy by company, you can specify which fields are significant for each company and the order in which the system evaluates the values in the fields.

  2. Set up dates by company in the Revenue Recognition Trigger Setup program (P03B420).

    The system assigns each invoice in the revenue recognition process an eligible for recognition date. The system calculates this date based on the values you enter during recognition date setup and the trigger configuration.

    The system also determines the period comparison date for the invoice based on the values in the date setup. Then, the system compares the eligible for recognition date and the period comparison date and, depending on the value in the Same Period Inclusion check box, sends the invoice to the revenue recognition process.

  3. Set up configuration records by company in the Service Billing Trigger Configuration program (P48032) or the Revenue Recognition Trigger Setup program (P03B420).

    The system matches specific data from each transaction against the values in the trigger configuration records to determine whether it is included in the revenue recognition process.

    The system also checks the Days From Configured Date field on configuration record to determine how many days to use when calculating the eligible for recognition date.

    Note: There are separate trigger configurations for A/R invoices, Sales Order invoices, Contract Billing invoices, and Service Billing invoices.

To review how the system uses the trigger setup to select invoices for revenue recognition, review the revenue recognition trigger process flow:

See Revenue Recognition Trigger Process Flow

The system stores revenue recognition trigger setup information for service billing lines in the following tables:

  • Service Billing Trigger Hierarchy table (F48424)

  • Service Billing Trigger Date table (F48423)

  • Service Billing Trigger Configuration table (F48425)