To reconcile accounts receivable accounts

  1. Access Receivables Tie Back Report (AR256).
  2. Run this report monthly to tie out the accounts receivable general ledger account to the detail in the Account Receivable application. The report lists all open receivables by AR code. Items that will not be on the report are: any entries posted directly to the AR account in GL, and payments.

    In the Company tab, use the following guidelines to enter field values:

    Company

    Type the company number. This must be a valid company in AR01 (Company).

    Company Group

    A company group is an optional batch processing parameter that lets you run batch programs for a group of companies instead of just one company at a time. A company group represents one or more general ledger companies.

    Company groups are setup in GL11.1.

    As of Date

    Type a date used for selecting transactions. All transactions that have a general ledger date on or before the date will be included. If left blank, you must select Period End Date in the Audit/Period field.

    Qualify Future Applications

    Select N if you do not have future dated applications and the "as of" date specified is today's date. This reduces processing time dramatically. Select Y if you do have future dated applications and the "as of" date is not today's date.

    Audit Period

    Select which type of tie back report to create based on the date used for selecting transactions.

    • Audit creates a time-independent tie back report based on the date defined in the As of Date field. This option can process more records than the standard, two-periods-ago processing for fully applied transactions and might, therefore, require more time to process.

      Note: If you have an As of Date, this field can be either Audit or blank. Its value determines what data is processed.
    • Period End Date uses the current period ending date defined in the General Ledger application for the As of Date.

    Gain, Loss

    Select Yes to include unrealized gain/loss amounts.

    Non-base currency open items that have been processed by Unrealized Gain Loss Report (AR196) have the unrealized gain/loss amount added to the open amount for general ledger reconciling purposes.

    Currency Display

    Select how to print transaction amounts. between base currency or transaction currency.

  3. In the selection tab, use the following guidelines to enter field values:
    Process Level

    Select a process level.

    Major/Minor Class

    Select a valid major class. If Minor Class field is populated, the Major Class field must also be populated. If the Minor Class field is blank, all valid minor classes for that Major Class will be included.

    Activity

    Select a From and To activity.