The Amount-based Revenue Process (CA_LOAD_GL1)

The Amount-based Revenue process writes revenue to CA_ACCTG_LINE for amount and percent based contract lines that are tied to Percent Complete, Milestone, and Apportionment revenue plans. The process marks the revenue entries with a General Ledger distribution status of N (not distributed). When you run the Amount-based Revenue process, the system scans all revenue plans with a status of Ready or In Progress and picks up all revenue plan events with an event status of Ready or Reversal Initiated, as well as all amendment generated events. The system picks up events in the current or prior accounting periods. Prior accounting periods are included because you may have placed some revenue plans or events on hold in previous periods and are now ready to process them.

Before running the Amount-based Revenue process, the system has already:

  • Applied the appropriate contract line accounting distribution to the revenue plan events.

  • Created the offsetting entry to either contract asset or contract liability.

    You initially establish the contract liability option when setting up your contract product groups. You can override the product group contract liability option on the contract line if you selected the contract liability Override check box on the Contracts Definition - Processing Options page for the associated contracts business unit.

The system performs the previous steps automatically as you create your revenue plans. By having the accounting entries staged before the revenue processes are run, you can view them by using Preview Revenue.

The Amount-based Revenue process then:

  • Picks up the appropriate revenue and offsetting accounting entries previously created for Preview Revenue for the accounting period specified on the run control.

  • Picks up the appropriate amendment event entries and reversal entries for the accounting period specified on the run control.

  • Calls the interunit processor to determine which lines need interunit or intraunit entries created for a selected group of lines with an anchor flag.

    The anchor flag is either the contract liability (DFR) or contract asset row depending upon whether or not you are using contract liability.

  • Converts entries, if needed, from the contract currency to the base currency of the primary ledger of the PeopleSoft General Ledger business unit, and populates the Foreign Amount, Foreign Currency, Base Amount, Base Currency, Exchange Rate, and Exchange Rate Type fields.

    If contract liability is enabled, the process uses the historical exchange rate used for the original contract liability entry.

  • Converts entries, if needed, for interunit processing, from the primary PeopleSoft General Ledger business unit (GLBU) currency used for the balance sheet side of the entry to the primary GLBU currency of the revenue receiving GLBU, and populates the Foreign Amount, Foreign Currency, Base Amount, Base Currency, and Exchange Rate fields.

  • Updates the revenue recognition event status from Ready to In Progress for applicable revenue recognition events.

  • Updates applicable revenue plan statuses from Ready to In Progress.