AR199 - Period Closing Report

Run AR199 (Period Closing) to close the current period and year for the
Lawson Accounts Receivable system, update record status, and update customer
period statistics. AR199 creates a report indicating the period closed and, if
requested, customers that have a credit balance.

If you selected Yes the Verify Post Date field on the Process form tab of
AR01.1 (Company), all payments, invoices, memos, and applications with a
general ledger date on or before the ending date of the period being closed in
GL01.1 (System Control) must be released and posted through AR190 (Application
Closing). An error message displays if AR199 attempts to process a transaction
that is unreleased or unposted. The error message will note the condition that
produces the error, not the specific record. Run AR233 (Unposted Application
Report) for a listing of unposted applications. Run AR242 (Unreleased
Transaction Report) for a listing of unreleased transactions.

Generally, applications remain unposted if the payment is unreleased, an
adjustment requires review in AR36.1 (Adjustments Exceeded Review), or all
applications require review in AR132 (Application Audit). Upon closing, AR199
updates system control, allowing the general ledger period closing program to
be run. Fully applied open items, payments, credits, and applications that
have been processed by the number of period closings as specified by the value
of the History Update Periods field on the Process form tab of AR01.1 (Company
), become permanently historical. For more information, see the field help for
History Update Periods in AR01.1.

AR199 updates customer statistics differently for period end and year end
closing. A period end closing rolls the high balance, return to maker payments
(RTMs), paid prompts, and invoices paid from the current period to the
previous period; rolls each past period into the preceding period; and deletes
the oldest period. A year end closing rolls each period in the current year's
period billed, chargebacks, credits, write-offs, and paid to last year; moves
any value for the next year to the first period; and moves the year-to-date
Invoice Payment Average (IPA) and Days Beyond Terms (DBT) totals to last year.


Important: When closing the last period of your fiscal year, select the Year
End option along with the period close. AR199 should not be run twice at year
end.






Updated Files

    ARCUSTOMER - The following occurs fields are rolled from 1 to 2, 2 to 3,
                 etc.: high balance, period returns, paid prompt, invoices paid,
                 and collect days. If year end, the following occurs fields are
                 zeroed out: period billing, period chargeback, period credits,
                 period write-offs, and period paid. In addition, the  average
                 invoice payment days for last year is moved to the year before
                 last and the average invoice payment days for this year is
                 moved to last year. This  years average invoice payment days is
                 obtained by dividing the current cash days ( which is the paid
                 amount times the number of days to fully pay the  invoices) by
                 the current cash (which is the paid amount from fully paid
                 transactions). Current cash days and current cash are zeroed
                 out.


    AROITEMS   - Status 8 open items changed to status 9, status 7 to status 8.

    ARPAYMENT  - Status 8 payments changed to status 9, status 7 payments
                 changed to status 8.


    ARSUMMARY  - Period amount 2 moved to period amount 1. If year end report,
                 next year amount moved to current year amount.


    CKPOINT    - Use in program re-start logic.

    GLCODES    - Updates period and year closed fields. Also date range is
                 updated.


    NATBALANCE - Updates high balance for national account balance record.


Referenced Files

    ARAPPLIED  - If the company Verify GL Date Flag = Y, file is checked for
                 unposted applications dated before the period ending date.


    ARCOMP     - Accesses company level information.

    ARDISTRIB  - If company Verify GL Date Flag = Y, file is checked for
                 unposted distributions dated before the period ending date.


    AROIHDR    - Accesses the GL date of the item header record.

    ARPYMNTHDR - If company Verify GL Date Flag = Y, file is checked for
                 unreleased payment header records where the general ledger date
                 is before the period ending date.


    ARRTM      - If company Verify GL Date Flag = Y, file is checked for
                 unreleased RTM records where the general ledger date is before
                 the period end date.


    ARSAPPLIED -

    BLINVHDR   - Accesses invoice header records.

    CUSTDESC   - Accessed for customer name.

    GLADDRESS  - Validates part of company information.

    GLCHART    - Validates general ledger company chart information.

    GLSYSTEM   - Validates general ledger company information.

    REVERSE    - If Verify GL Date Flag = Y, file is checked for reverse
                 records with a reverse flag = Y dated before the period end
                 date.



INVOKED Programs

    IFSG