Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AR296


AR296 - Activity Report



Run Activity Report (AR296) to print a report of all transactions, cash
application adjustments, non-AR payment transactions, and miscellaneous
distributions
associated with each activity you select for the report.

Payments that do not have an activity or contract value may appear on
the report because of other Project Accounting elements such as an activity
group.


**Processing Effect




- Choose the Activity form tab to select the activities included
in the report.You can select an activity group list, an activity
group, an activity list, or up to six specific activities.
You can also further limit the report to activities that are associated
with a specific account category group, account category type, or account
category. An account category selection is not required.


- Choose the Activity form tab to select the activities included
in the report.You can select an activity group list, an activity
group, an activity list, or up to six specific activities.
You can also further limit the report to activities that are associated
with a specific account category group, account category type, or account
category. An account category selection is not required.



- Choose the Activity form tab to select the activities included
in the report.You can select an activity group list, an activity
group, an activity list, or up to six specific activities.
You can also further limit the report to activities that are associated
with a specific account category group, account category type, or account
category. An account category selection is not required.




- Choose the Transaction tab define a posting date range for
the report and to optionally further limit the report to specific customers
or transactions.You can select a company, a company and customer,
or a customer list.
You can also limit the report to a range of process levels (requires
a company), or a transaction currency.
You can also select a display currency (base or transaction), a report
detail option, and a report sequence.

If the Report Sequence is Activity (A), the sort order will
be by activity, then by currency.  Subtotals are by currency, and by activity
(if currency has not changed).  Report totals are only printed if currency
has not changed across the report.  Page breaking will occur at the lowest
level (currency within activity)
If the Report Sequence is Contract (C), the sort order will
be by contract, then by currency.  Subtotals are by currency, and by contract
(if currency has not changed).  Report totals are only printed if currency
has not changed across the report.  Page breaking will occur at the lowest
level (currency within contract).  This is the default.
If the Report Sequence is Activity Group/Contract (G), the
sort order will be by activity group, then by contract, then by currency.
Subtotals are by currency and by contract (if currency has not changed), and
by activity group (if currency has not changed). Report totals are only
printed
if currency has not changed across the report. Page breaking will occur at
the lowest level (Currency within Contract).
If the Report Sequence is Activity Group/Activity (P), the
sort order will be by activity group, then by activity, then by currency.
 Subtotals are by currency, and by activity (if currency has not changed),
and by activity group (if currency has not changed).  Report totals are only
printed if currency has not changed across the report.  Page breaking will
occur at the lowest level (currency within activity).
If the Report Sequence is Activity/Acct Category (T), the
sort order will be activity, then account category, then currency.  Subtotals
are by currency, and by account category (if currency has not changed), and
by activity (if currency has not changed).  Report totals are only printed
if currency has not changed across the report.  Page breaking will occur at
the lowest level (currency within account category).



- Choose the Transaction tab define a posting date range for
the report and to optionally further limit the report to specific customers
or transactions.You can select a company, a company and customer,
or a customer list.
You can also limit the report to a range of process levels (requires
a company), or a transaction currency.
You can also select a display currency (base or transaction), a report
detail option, and a report sequence.

If the Report Sequence is Activity (A), the sort order will
be by activity, then by currency.  Subtotals are by currency, and by activity
(if currency has not changed).  Report totals are only printed if currency
has not changed across the report.  Page breaking will occur at the lowest
level (currency within activity)
If the Report Sequence is Contract (C), the sort order will
be by contract, then by currency.  Subtotals are by currency, and by contract
(if currency has not changed).  Report totals are only printed if currency
has not changed across the report.  Page breaking will occur at the lowest
level (currency within contract).  This is the default.
If the Report Sequence is Activity Group/Contract (G), the
sort order will be by activity group, then by contract, then by currency.
Subtotals are by currency and by contract (if currency has not changed), and
by activity group (if currency has not changed). Report totals are only
printed
if currency has not changed across the report. Page breaking will occur at
the lowest level (Currency within Contract).
If the Report Sequence is Activity Group/Activity (P), the
sort order will be by activity group, then by activity, then by currency.
 Subtotals are by currency, and by activity (if currency has not changed),
and by activity group (if currency has not changed).  Report totals are only
printed if currency has not changed across the report.  Page breaking will
occur at the lowest level (currency within activity).
If the Report Sequence is Activity/Acct Category (T), the
sort order will be activity, then account category, then currency.  Subtotals
are by currency, and by account category (if currency has not changed), and
by activity (if currency has not changed).  Report totals are only printed
if currency has not changed across the report.  Page breaking will occur at
the lowest level (currency within account category).




- Choose the Transaction tab define a posting date range for
the report and to optionally further limit the report to specific customers
or transactions.You can select a company, a company and customer,
or a customer list.
You can also limit the report to a range of process levels (requires
a company), or a transaction currency.
You can also select a display currency (base or transaction), a report
detail option, and a report sequence.

If the Report Sequence is Activity (A), the sort order will
be by activity, then by currency.  Subtotals are by currency, and by activity
(if currency has not changed).  Report totals are only printed if currency
has not changed across the report.  Page breaking will occur at the lowest
level (currency within activity)
If the Report Sequence is Contract (C), the sort order will
be by contract, then by currency.  Subtotals are by currency, and by contract
(if currency has not changed).  Report totals are only printed if currency
has not changed across the report.  Page breaking will occur at the lowest
level (currency within contract).  This is the default.
If the Report Sequence is Activity Group/Contract (G), the
sort order will be by activity group, then by contract, then by currency.
Subtotals are by currency and by contract (if currency has not changed), and
by activity group (if currency has not changed). Report totals are only
printed
if currency has not changed across the report. Page breaking will occur at
the lowest level (Currency within Contract).
If the Report Sequence is Activity Group/Activity (P), the
sort order will be by activity group, then by activity, then by currency.
 Subtotals are by currency, and by activity (if currency has not changed),
and by activity group (if currency has not changed).  Report totals are only
printed if currency has not changed across the report.  Page breaking will
occur at the lowest level (currency within activity).
If the Report Sequence is Activity/Acct Category (T), the
sort order will be activity, then account category, then currency.  Subtotals
are by currency, and by account category (if currency has not changed), and
by activity (if currency has not changed).  Report totals are only printed
if currency has not changed across the report.  Page breaking will occur at
the lowest level (currency within account category).




- Choose the Transaction tab define a posting date range for
the report and to optionally further limit the report to specific customers
or transactions.You can select a company, a company and customer,
or a customer list.
You can also limit the report to a range of process levels (requires
a company), or a transaction currency.
You can also select a display currency (base or transaction), a report
detail option, and a report sequence.

If the Report Sequence is Activity (A), the sort order will
be by activity, then by currency.  Subtotals are by currency, and by activity
(if currency has not changed).  Report totals are only printed if currency
has not changed across the report.  Page breaking will occur at the lowest
level (currency within activity)
If the Report Sequence is Contract (C), the sort order will
be by contract, then by currency.  Subtotals are by currency, and by contract
(if currency has not changed).  Report totals are only printed if currency
has not changed across the report.  Page breaking will occur at the lowest
level (currency within contract).  This is the default.
If the Report Sequence is Activity Group/Contract (G), the
sort order will be by activity group, then by contract, then by currency.
Subtotals are by currency and by contract (if currency has not changed), and
by activity group (if currency has not changed). Report totals are only
printed
if currency has not changed across the report. Page breaking will occur at
the lowest level (Currency within Contract).
If the Report Sequence is Activity Group/Activity (P), the
sort order will be by activity group, then by activity, then by currency.
 Subtotals are by currency, and by activity (if currency has not changed),
and by activity group (if currency has not changed).  Report totals are only
printed if currency has not changed across the report.  Page breaking will
occur at the lowest level (currency within activity).
If the Report Sequence is Activity/Acct Category (T), the
sort order will be activity, then account category, then currency.  Subtotals
are by currency, and by account category (if currency has not changed), and
by activity (if currency has not changed).  Report totals are only printed
if currency has not changed across the report.  Page breaking will occur at
the lowest level (currency within account category).





- If the Report Sequence is Activity (A), the sort order will
be by activity, then by currency.  Subtotals are by currency, and by activity
(if currency has not changed).  Report totals are only printed if currency
has not changed across the report.  Page breaking will occur at the lowest
level (currency within activity)


- If the Report Sequence is Contract (C), the sort order will
be by contract, then by currency.  Subtotals are by currency, and by contract
(if currency has not changed).  Report totals are only printed if currency
has not changed across the report.  Page breaking will occur at the lowest
level (currency within contract).  This is the default.


- If the Report Sequence is Activity Group/Contract (G), the
sort order will be by activity group, then by contract, then by currency.
Subtotals are by currency and by contract (if currency has not changed), and
by activity group (if currency has not changed). Report totals are only
printed
if currency has not changed across the report. Page breaking will occur at
the lowest level (Currency within Contract).


- If the Report Sequence is Activity Group/Activity (P), the
sort order will be by activity group, then by activity, then by currency.
 Subtotals are by currency, and by activity (if currency has not changed),
and by activity group (if currency has not changed).  Report totals are only
printed if currency has not changed across the report.  Page breaking will
occur at the lowest level (currency within activity).


- If the Report Sequence is Activity/Acct Category (T), the
sort order will be activity, then account category, then currency.  Subtotals
are by currency, and by account category (if currency has not changed), and
by activity (if currency has not changed).  Report totals are only printed
if currency has not changed across the report.  Page breaking will occur at
the lowest level (currency within account category).





**More Information

 If the currency changes across the report, no report total will be
printed. However, subtotals will be printed if currency has not changed for
that subtotal level. For example:



- Example 1:  The requested
sort is Activity Group/Activity; there are two activities for a given activity
group, and each activity has a specific currency. Results: There
will be currency-specific subtotals for each activity, and no activity group
or report totals.


- Example 1:  The requested
sort is Activity Group/Activity; there are two activities for a given activity
group, and each activity has a specific currency. Results: There
will be currency-specific subtotals for each activity, and no activity group
or report totals.




- Example 2: The requested
sort is Activity; for a single activity, there are transactions with different
currencies.  Results: Within
that activity, there will be currency-specific subtotals, and no activity
or report totals


- Example 2: The requested
sort is Activity; for a single activity, there are transactions with different
currencies.  Results: Within
that activity, there will be currency-specific subtotals, and no activity
or report totals





Updated Files

    CKPOINT    -

    MXLISTHDR  -

    MXLISTMBR  -


Referenced Files

    ACACCTCAT  -

    ACACCTCATX -

    ACACTGRP   -

    ACACTIVITY -

    ACACTMXVAL -

    ACADDLCNTR -

    ACAMCODE   -

    ACASNROLE  -

    ACASSIGN   -

    ACBILL     -

    ACBILLX    -

    ACCATGRP   -

    ACCATGRPX  -

    ACCATMXVAL -

    ACCATSUM   -

    ACCATSUMX  -

    ACCNTRACT  -

    ACCNTRACTX -

    ACCTRCATGX -

    ACGRPMXVAL -

    ACIFACTV   -

    ACROLE     -

    ACSTATUS   -

    ARACPIVOT  -

    ARADJUST   -

    ARAPPLIED  -

    ARCOMP     -

    ARCSTMXVAL -

    ARCUSTGRP  -

    ARCUSTOMER -

    ARDISTRIB  -

    ARPROCLEVL -

    CUCODES    -

    CUCONV     -

    CURELAT    -

    CUSTDESC   -

    GLSYSTEM   -

    GMAWARD    -

    MXCATDEF   -

    MXELEMENT  -

    MXLISTDTL  -

    MXOBJCAT   -

    STRUCTURE  -

    WFSETUP    -


INVOKED Programs

    ACSR
    IFCU
    IFAC
    ACAC
    ACTA
    API4
    IFLU
    IFOB
    IFUP
    IFSG
    SLSE
    SLSU