1. Accounts Receivable Implementation Guide
  2. Understanding the Revenue Recognition Invoice to Account Ledger Program (P03B7116)

Understanding the Revenue Recognition Invoice to Account Ledger Program (P03B7116)

Use the Revenue Recognition Invoice to Account Ledger program (P03B7116) to identify integrity issues for invoices in the revenue recognition process. The system searches for invoices with single and multiple pay items, domestic and foreign invoices, invoices with cost of goods sold (COGS), credit memos, and invoices with VAT (value-added tax).

From the P03B7116 program, you can access the Revenue Recognition program (P03B116) to immediately correct the out-of-balance revenue recognition invoice issues. From the P03B7116 program, you can also access the Batches Out of Balance program (P007032) to search any batch in error that contains revenue recognition invoices.

The P03B7116 program searches for the following integrity errors:

  • For invoices that are ready to be recognized: Invoice amounts are not equal to or are missing Performance Liability Account (PLA) entries in the Account Ledger table (F0911).

  • For invoices with a COGS value that is ready to be recognized: COGS amounts are not equal to or are missing COGS PLA entries in the F0911 table.

  • Recognized revenue amounts are not equal to the G/L entries for the revenue accounts for the invoice, or the entries are missing from the F0911 table.

  • Recognized COGS amounts are not equal to the G/L entries for the COGS accounts for the invoice, or the entries are missing from the F0911 table.

  • Recognized revenue amounts are not equal to the offsetting PLA and PLA adjustment accounts for the invoice in the F0911 table, excluding AE entries.

  • Recognized COGS amounts are not equal to the offsetting COGS PLA and COGS PLA adjustment accounts for the invoice in the F0911 table, excluding AE entries.

  • For invoices with COGS entries: Any invoice where the percent of revenue recognized is not equal to the percent of COGS recognized.

  • Invoices that exist in the Customer Ledger Tag table (F03B11T) with the Revenue Flag set to 1 are missing records in the Revenue Recognition Invoice table (F03B116).