AR115 - EFT Payment Creation
Run AR115 (EFT Payment Creation) to create ACH or non-formatted payments, and
apply payments to eligible open items. Payments are created for each customer
at the customer group/EFT national account level.
AR115 will create one of three types of payment records.
1. A record for funds to be drawn from the customer's account
2. A record for funds to be transmitted to the customer's account if the
customer has a credit balance
3. A prenotification record for a new bank transit number
The payment header and detail records are created with the payment number
consisting of the EFT processing date for the customer.
For all EFT payments, pre-application records are created for the open items
associated with the payment.
For net zero open items and credit balance amounts, a zero check is created.
For the net zero open items payment, the payment is a reference for
applications. For the net credit balance open items zero payment, a debit memo
is created to balance the credit balance, then applications are performed.
AR115 creates a report listing open items cleared by the EFT process, total
deposit and withdrawal amounts, and the net deposit and withdrawal amounts.
Updated Files
ACCOMMIT -
ACCOMMITX -
ARAPPLIED - Application record created for open items.
ARCOMP - Updated with last payment batch number used.
ARCUSTOMER - Used to validate customer.
ARCUSTPER - Used to validate customer transaction period record.
ARDISTRIB - Distribution record created for created memo processing.
AROIHDR - Open item header record created for created memo processing.
AROITEMS - Open item record created for created memo processing, and EFT
status updated.
AROPIVOT -
ARPAYMENT - Payment record created representing funds received and for
application to open items.
ARPROCLEVL - Used flag updated.
ARPYMNTHDR - Payment header record created for batch of payment records.
ARSADJUST - Temporary application adjustment record created.
ARSAPPLIED - Temporary application record created.
ARSUMMARY - Part of process level validation.
ARUDISTRIB -
ARUPMNTHDR -
CBBANKENT - Used as part of cash ledger validation.
CBBANKINST - Used as part of payment code validation.
CBCASHCODE - Used as part of cash code validation.
CBCPYCASH - Used as part of cash ledger validation.
CBDISTRIB - Used as part of cash ledger validation.
CBTRANS - Creates cash ledger transaction record.
CKPOINT - Used for restart purposes.
CUSTDESC - Validates customer description record.
DTCUSTBANK - Validates Bills of Exchange bank accounts.
FTTRANS - EFT transaction record created for open items.
JBOOKHDR - Used in journal book processing.
NATBALANCE - National account balance updated for with payment amount.
TERMS - Used to validate terms code.
TXCODEMAST - Validates tax code flag.
TXCOMPANY - Validates tax code company.
TXTAXCODE - Validates tax codes.
TXTAXTABLE - Validates tax table transaction records.
TXTAXTRAN - Creates tax transaction records for distribution taxable
distribution lines.
Referenced Files
ACACCTCAT -
ACACTGRP -
ACACTIVITY -
APACCRCODE - Used as part of vendor validation.
APCOMPANY - Used as part of vendor validation.
APVENGROUP - Used as part of vendor validation.
ARCODE - Used to validate general ledger accounts receivable code.
ARCUSTGRP - Used to validate customer group.
AROPTR - Used to validate operator.
ARREASON - Validates reason code record.
CBADJUST - Used as part of cash ledger validation.
CBBALANCE - Used as part of cash ledger validation.
CBSTATEMNT -
CBSTMTDTL -
CBUSER - Used as part of cash ledger validation.
CBUSRCLASS - Used as part of cash ledger validation.
CRANALYST - Validates credit analyst code.
CUCONV - Used as part of currency validation.
CURELAT -
CUSTORDER -
FTCUSTNOTE - Used to validate customer notification method.
GLADDRESS - Validates general ledger company information.
GLCHART - Used as part of general ledger account validation.
GLCODES - Used to validate system control.
GLSYSTEM - Used as part of general ledger account validation.
JBKOPCODE - Used in journal book processing.
JBKSYSCODE - Used in journal book processing.
NATACCT - Used to validate national account customer relationship.
OECOMPANY -
SYSTEMCODE -
TXTAXRATE - Validates tax rate.
WFSETUP -
INVOKED Programs
ACCL
API4
ACAC
IFCU
IFSG
IFAC
IFAU
SLSE
SLSU
IFOB
IFRS
IFSC
|
