The GRNI reconciliation process

  1. Close periods

    Usually, reconciliation is performed over a specific fiscal period. Before you start the reconciliation process, use the Close Periods (tfgld1206m000) session to close the Integration period so that no new transactions can be entered.

    However, if you generate and print the reconciliation reports, LN does not check the period status. You can print the reports whenever you wish, independent of the period status.

  2. Print the trial balance

    Use the Print Trial Balance (tfgld3402m000) session to print the trial balance for the for the GRNI ledger accounts that you wish to reconcile, and keep it for reference during the process.

  3. Print a report of the invoices to be received

    To print a report of the expected invoices, you can use one of these sessions:

    • Print Receivable Invoices Up to Period (tfacp1439m000)

      Prints a report of the purchase invoices that you expect to receive, based on the data in the Purchase tables in Procurement.
    • Print Receivable Invoices Specifications (tfacp1432m000)

      Prints a report of the purchase receipts for which you have not yet received invoices, based on the data in the Accounts Payable tables.
  4. Compare the trial balance and the balances on the expected invoices reports

    For the ledger accounts on which the amounts match, you can accept the reconciliation data as described in Step 15, Accept the reconciliation data.

  5. Print the reconciliation data

    Use the Print Reconciliation Data (tfgld4495m000) session to print a reconciliation report. Select the Invoice Accrual 3 reconciliation group, which represents the GRNI business process.

    At this stage in the process, you can print a standard report. Print the subtotals on a high level, for example, by reconciliation element, and select these check boxes:

    • Compare Reconciliation with Finalized General Ledger
    • Suppress Zero Balances

    For more information, refer to To print the reconciliation reports.

    As the GRNI transactions are created for the Purchase Order business objects, you obtain the most useful report if you group the data by business object. Select the Business Object ID check box.

  6. Examine the reports

    If a difference exists, this is printed on the report.

    For the ledger accounts on which no difference exists, you can print the GRNI reconciliation checklist as described in Step 9, Print the GRNI reconciliation checklist.

  7. Rebuild the history

    If a difference exists, you can first rebuild the history of the ledger accounts that you are analyzing.

    Use the Rebuild Opening Balance/History from Transactions (tfgld3203m000) session and select all three check boxes:

    • Opening Balance
    • Rebuild Parent Account History
    • Rebuild Parent Dimension History
  8. Reprint the trial balance and the reconciliation report

    Use the Print Trial Balance (tfgld3402m000) session to reprint the trial balance for the integration ledger accounts of which you rebuilt the history. Use the Print Reconciliation Data (tfgld4495m000) session to regenerate the reconciliation report based on the rebuilt ledger accounts.

    If the reports match, continue at Step 9, Print the GRNI reconciliation checklist. If considerable differences exist between the Operations Management data and the financial data, this must be solved by an expert.

  9. Print the GRNI reconciliation checklist

    Use the Checklist Reconciliation Goods Received Not Invoiced (tfgld4495m200) session to print a report of the financial balances and the logistic balances by transaction date. You can choose to print the report based on the data in the Purchase tables in Procurement or on the Accounts Payable tables. If a difference exists, it is printed on the report.

    For more information, refer to To print the reconciliation reports.

  10. Check the balances on the GRNI reconciliation checklist

    For the transactions for which no differences exist, you can accept the reconciliation data. Continue at Step 15, Accept the Reconciliation Data.

    If important differences exist between the Operations Management data and the data in Financials, this must be solved by an expert.

  11. Analyze the reconciliation data

    You can use the Operations Management - Financial Reconciliation (tfgld4595m000) session to examine the reconciliation data. If you are satisfied that the General Ledger correctly reflects the Operations Management transactions, continue at Step 15, Accept the Reconciliation Data.

  12. Make corrections

    In the Operations Management - Financial Reconciliation (tfgld4595m000) session, you can manually create the corrective transactions for postings that are incorrect. For more information, refer to To create a correction transaction. You can use this type of corrections to solve minor differences in Financials.

  13. Reprint the GRNI reconciliation checklist

    Before you post the correction transactions, you can examine the effect of the correction transactions. In the Checklist Reconciliation Goods Received Not Invoiced (tfgld4495m200) session, select the Include Unposted Reconciliation Corrections check box. Check whether a difference is printed on the report, or compare the report with the trial balance.

  14. Post the reconciliation correction transactions

    If no further corrections are required, use the Post Reconciliation Corrections (tfgld4295m300) session to post the correction transactions to the General Ledger accounts.

  15. Accept the reconciliation data

    Accept the reconciliation data for the ledger accounts for which there are no problems. In the Accept Reconciliation Data (tfgld4295m000) session, select the reconciliation group. Then select the range of ledger accounts for which you want to accept the reconciliation data.