Sales orders - interim revenue reconciliation

The mapping and posting of the Accounts Receivable open entries allows the reconciliation of sales order interim revenue. This involves the following transactions entered or generated in Invoicing:

  • Sales invoices
  • Manual sales invoices
  • Interest invoices

Posting of interim revenue

  • When the invoice is created and stored in the Non-finalized Transactions (gld102) table, the credit side is posted to the accounts and dimensions defined in the integration mapping scheme for the Sales/Revenues Analysis debit posting. For reconciliation purposes, reconciliation data is logged when the open entry is created.
  • To allow you to use different accounts for different tax codes, the tax code and tax country are available as mapping elements for the ledger and dimension mapping.
  • Accounts Receivable open entries created through Invoicing are posted to the following accounts:

    • Debit

      The Accounts Receivable control account. The dimensions are determined through the integration mapping scheme.
    • Credit

      The accounts and dimensions to which you mapped the debit side of the Sales Order/Revenue Analysis integration document type in the integration mapping scheme.
  • If the sales invoice has lines with different tax codes, multiple lines for interim revenue are created. For a sales invoice, LN calculates and registers the tax amounts based on the net invoice amount aggregated by tax code. Because of this, the Interim Revenue accounts to which sales orders, service orders and so on are mapped must be identical for a specific tax code. LN checks this consistency when you check a mapping scheme.
  • If you want to use other interim revenue accounts for sales orders and service orders, you must define different tax codes for sales and service.
  • For an Accounts Receivable open entry, Invoicing logs the details in the Reconciliation Data (tfgld495) table. This data is logged as follows:

    • Reconciliation group = Interim Revenue 5
    • Business Object = Sales Invoice
    • Business Object ID = sales invoice number (11 positions)
    • Kind of Entry = Sales Invoice.
  • For the new Interim Revenue 5 reconciliation group, the business objects of the debit transactions, such as the sales order or the service order, are linked through a reference link to the business objects of the credit transactions, which consist of the sales invoices.

Reconciliation of manual sales invoices and interest invoicesThe following functionality facilitates the reconciliation for manual sales invoices and interest invoices entered in Invoicing:

  • The revenue postings for manual sales order lines and interest invoice lines are posted through the integration mapping scheme through the following integration document types:

    • Interest Invoice / Revenues Analysis
    • Manual Sales Invoice / Revenues Analysis
  • LN retrieves the sales ledger account from the integration mapping scheme.
  • The Interim Revenue 5 reconciliation group is used for posting sales invoices.
  • The interim revenue on interest invoices is posted as defined for Interest Invoice / Revenues Analysis in the integration mapping scheme.
  • In the Manual Sales Invoice Lines (cisli2125m000) session, you can optionally enter a GL code for the posting of the invoice line.
Note: The default manual sales account for manual sales invoice lines, defined in the Invoicing Parameters (cisli0100m000) session is only used for fixed assets disposal, and it must have an integration with the Fixed Assets module for fixed asset disposal.

To facilitate tax auditing, you can use the Print Tax Transactions for Interim Revenue on Sales Invoices (tfgld1433m000) session to print a report of the revenues and the tax lines in the Finalized Transactions (tfgld106) table.