Sales invoices should be represented by positive
Trans Amount values, while the other transaction
types are negative.
Some of the following assignments employ
the ACL’s Relation and Join features. For detailed
information on the use of these and other commands,
consult ACL’s online Help feature.
1. Open the AR file, Profile the data, and Stratify
on the Trans Amount field. Print the Last
Results window and write an analysis providing
possible explanations for the results obtained.
2. Open the AR file, stratify the file on the
Trans Amount field, and use the expression
builder to create filters that limit the strata to
(a) sales invoice transactions only.
(b) credit note (memo) transactions only.
(c) payment transactions only.
(d) transfer (write-off) transactions.
3. Open the AR file and use the expression
builder to create a filter that screens for invalid
transaction types. Print the results and
comment