Tip:
Highlight text to annotate it
X
Exception Report The Exception report tool will extract all
records that fulfil given criteria to a new sheet. Here we have a list of journal postings
from which we will extract all records that have been posted before the journal date,
i.e. Posted Date, is less than, Document Date. We will only extract those journal lines that
are greater than 10,000. The extraction report shows the records where
the document date is after the posted date where the value is over 10,000. The comment
in cell A1 shows the details of the extraction, and comments in columns L and M detail the
criteria tested. You can also use the exception report tool
to extract items that match items stored in your "Specific Dates" lists. Here we can look
for items posted on public holidays by selecting "Posted Date" "equals" Dates, and selecting
our stored public holidays list.