AR251 - Company Aging Report
Run AR251 (Company Aging Report) to create a transaction aging report for a
company. You can run the report for all customers or a single customer within
a company. You can select a major class, minor class, credit analyst, process
level, sales representative, activity, or user-defined field to further define
the report.
The report is created as of the date you specify, which allows an accurate
aging for non-historical transactions at any point. (For more information, see
the note at the end of the form help and the field help for the Audit, Period
field.)
You can define aging periods and options or leave the fields blank to use the
aging options defined for the company in AR01.1 (Company) or, if running the
report for a single customer, the aging options defined for the aging code
assigned to the customer in AR10 (Customer).
The report sorts in company, Report Sequence, customer, transaction due date
or type, and transaction number order. The report lists payments first,
followed by credit memos, invoices, and debit memos, unless a credit memo is
cross referenced to a transaction. Cross referenced credit memos immediately
follow the associated transaction. The report includes customer, report
option, and report totals.
An asterisk (*) prints in the "P" column to indicate a partially applied
transaction. An "F" prints in the "F" column to indicate that a future
application exists for the transaction. Percentages of period total amount
compared to customer total amount appear for the analyst, customer, and
process level report sequence options.
Note: Fully paid and fully applied transactions are not selected once they
have become historical. Applications, transactions, and payments become
historical once they have been processed by AR199 (Period Closing Report)
according to the value of the History Update Periods field in AR01.1
(Company). For more information, see the field help for History Update
Periods on the Process tab in AR01.1.
Updated Files
CKPOINT -
MXLISTHDR -
MXLISTMBR -
Referenced Files
ACACTIVITY -
ACACTMXVAL -
ACAMCODE -
ACASSIGN -
ACCNTRACT -
ACCUSTOMER -
ACLEVEL -
AGINGCODE - Obtains aging information if a single customer is selected.
ARADJUST - Computes open amount of transaction.
ARAPPLIED - Computes open amount of transaction.
ARCOMP - Accesses company information.
ARCUSTGRP - Validates part of company information.
ARCUSTOMER - Validates customer. Access for customer information.
ARCUSTPER - Accesses customer period information.
ARDISPUTE - Accesses dispute information.
ARDRAFTS - Accesses bill of exchange information.
ARITEMAUD - Used for transferred open item logic.
AROIHDR - Accesses open item detail information.
AROITEMS - Accesses open item detail information.
ARPAYMENT - Accesses payment information.
ARPROCLEVL - Validates and sorts transactions by process level.
CRANALYST - Validates and sorts transactions by credit analyst.
CUCODES -
CUCONV - Obtains a currency exchange rate.
CURELAT - Obtains currency relationships.
CUSTDESC - Obtains customer name for printing.
GLADDRESS - Validates part of company information.
GLCHART - Validates general ledger company chart information.
GLSYSTEM - Validates part of company information.
MAJCUSTCL - Validates major class.
MINCUSTCL - Validates minor class.
MXCATDEF -
MXELEMENT -
MXLISTDTL -
MXOBJCAT -
NATACCT - Accesses national account relationships.
NATBALANCE - Obtains national account balance information.
SALESREP - Validates and sorts transactions by sales representative.
WFSETUP -
INVOKED Programs
ACAC
ACCL
IFCU
IFSG
|
