Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AR100


AR100 - EFT Notification Extract

**Form Purpose
Run EFT Notification Extract (AR100) to select open items for
pre-notification or final notification.

**Processing Effect
AR100 also creates EFT audit records, and updates the open item records
status. AR100 will select customers that have an active bank account within
the processing date range.

AR100 selects all new open items with an EFT payment method and a transaction
origin of "R" for pre-notification.

AR100 selects pre-noted open items for final notification if:

- The open item has been pre-noted. Even if customer has a Pre Note option of
No, all open items are pre-noted. They conditionally appear on the
notification form according to the Pre-Note option.

- The open item due date is greater than or equal to the processing start
date and, the due date is less than or equal to the processing end date.

- An EFT action flag indicates that a record was added for this EFT
processing run.

- A postponed open item is now eligible.

AR100 creates transaction audit records for pre-note and final note items.

AR100 creates three print files, one for prenotifications, one for final
notifications, and a banner page.




Updated Files

    AROITEMS   - Invoices, debit memos, and credit memos updated with EFT cycle
                 status flag.

    CBBANKINST - Used as part of payment code validation.

    CKPOINT    - The environment file used for recovery.

    FTTRANS    - Primary record created for EFT extract.


Referenced Files

    ARCOMP     - Validates Accounts Receivable company file.

    ARCUSTGRP  - Used to validate customer group.

    ARCUSTOMER - Used to validate customer.

    AROIHDR    - Used to validate open item header record.

    CUCONV     - Used as part of currency validation.

    CURELAT    -

    CUSTDESC   - Validates customer description record.

    DTCUSTBANK - Validates Bills of Exchange bank accounts.

    FTCUSTGRP  - Used to validate EFT customer grouping.

    GLINTCO    - Used to validate inter company general ledger relationships.

    GLSYSTEM   - Used as part of general ledger account validation.


INVOKED Programs

    IFCU
    IFSG