Reconcile Control Accounts for Received but Not Invoiced Goods and Invoiced but Not Received Goods

This instruction explains how you reconcile general ledger control accounts to outstanding amounts for goods that are invoiced but not received (GINR) and goods that are received but not invoiced (GRNI). You do this to ensure that there are no deviations between the control accounts and the open balances.

This is normally done by the financial controller or a similar person at the end of the month as a part of the periodic accounting process.

Outcome

Two lists are printed:

The lists are sorted by the seven dimensions in the accounting string. For each new accounting string, the received goods (or invoices) posted on the accounting string are displayed. For each transaction, the following information is displayed: Accounting date, purchase order number/line number/subnumber/sequence number (to which the received goods (or invoice) refer), costing element, invoiced amount in local amount, received cost amount in local amount, outstanding amount, and amount in the general ledger. Any possible deviations are displayed. Deviations are the difference between the outstanding amount and the amount in the general ledger.

Use the lists to determine whether there are any deviations on any of the accounts. If there are, you must adjust the amounts. This can, for example, be done in any of the following ways:

The following are updated:

Before you start

Not applicable.

Follow These Steps

  1. Select one of the following alternatives:

    • To create a report containing received but not invoiced goods, start 'Purchase Order. Print Rcvd/Not Invoiced' (APS580/E).
    • To create a report containing invoiced but not received goods, start 'Supplier Invoice. Print Invoiced/Not Rcvd' (APS585/E).
  2. On the E panel, enter the accounting date to use when checking for any outstanding amounts.

    All purchase orders/invoices that have an outstanding amount on the entered date, and that are included in the range of accounting identities selected below, will be included in the report.

  3. Select the purchase orders/invoices to include in the report by entering a range of accounting identities, from 1 to 7.

  4. Define whether to use a different date format in the report, if necessary.

    The valid alternatives are YMD=YYMMDD (year, month, day), DMY=DDMMYY (day, month, year), MDY=MMDDYY (month, day, year) and YWD=YYWWD (year, week, weekday).

  5. Select a report layout and enter a report text. Press Enter.

Related topics