Interim Revenue reconciliation

In Infor LN, reconciliation of interim revenue is not possible. Interim revenue is posted to the following accounts:

• Debit: The account defined for Sales/Revenues Analysis in the integration mapping scheme. This must be an integration account.
• Credit: the Sales acccount defined for the tax code by country. This cannot be an integration account.

In Infor LN SP1, to enable reconciliation of sales order interim revenue, the mapping and posting of the Accounts Receivable open entries was changed. This affects the following transactions entered or generated in Invoicing:

• Sales invoices
• Manual sales invoices
• Interest invoices

Posting of interim revenue

The following changes were made:

• 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 retain the current possibility 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 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 invoices

To enable reconciliation for manual sales invoices and interest invoices entered in Invoicing, in addition, the following changes were made:

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

  • Interest Invoice / Revenues Analysis
  • Manual Sales Invoice / Revenues Analysis
• The sales ledger account defined for the tax code was removed from the Posting Data for Multiple Tax Codes (tfgld0170s000) and the Posting Data for Singular Tax Codes (tfgld0171s000) sessions. LN uses the integration mapping scheme to determine the sales ledger account.
• The existing reconciliation groups for Interim Turnover that are used for posting sales invoices are combined into one new reconciliation group Interim Revenue 5.

• The following ledger accounts are no longer used:

  • The default manual sales account for manual sales invoice lines, defined in the SLI Parameters (cisli1500m000) session. The account is only used for fixed assets disposal, and it must have an integration with the Fixed Assets module for fixed asset disposal. For fixed assets disposal, LN generates the integration transactions described in Interim Revenue for Asset Disposal.
  • The Interest Invoice account defined in the Ledger Accounts by Business Partner Group (tfacr0111m000) session. Instead, 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 Data - Lines (cisli2525m000) session, you can optionally enter a GL code for the posting of the invoice line.