Account History

The Account History Explorer window displays a table of all history information for a specific account based on date range, resolution and representation. The basic columns displayed are explained below, followed by several examples that demonstrate different uses of the History Explorer window.

Perpetual History

The example history below displays Perpetual account balances (i.e. the closing account balance at the end date displayed in the Period Name column).

When the View>Analysis Settings command is issued, on a "History Explorer" of a Total account, the following column setup table is displayed:

The Analysis Settings fields consist of:

Line	Field	Options	Value
1	Tag		Used to select specific types of transactions (e.g. financial, order, budget, etc.).
2	Begin Date	<F3>	Used to specify the start date for the report. The Begin Date can be selected from a calendar by pressing <F3>.
3	End Date	<F3>	Used to specify the last date for the report. The End Date can be selected from a calendar by pressing <F3>.
4	Resolution		Used to determine how many rows are to be displayed. For example, if the row begin date is January 1, 2006 and the row end date is June 30, 2006, a monthly resolution would generate 6 rows. Press <F3> and the box below appears, click with the mouse to select the resolution.
			none year month three_month four_week two_week one_week day	none - no amount rows are displayed. year - each row will be one year. month - each row will be one month. three_month - each row will be one quarter. four_week - each row will be for 28 days. two_week - each row will be for 14 days. one_week - each row will be for seven days. day - each row will be for one day.
5	Representation		Used to control the begin date for each row. In general, Balance Sheet reports are set to perpetual and Income Statements reports are set to periodic representation. Press <F3> and the box below appears, click with the mouse to select the representation.
			perpetual perpetual_from_range_begin periodic	perpetual - displays account balances/quantities on a cumulative basis, starting from date 0.. perpetual_from_range_begin - displays account balances/quantities on a cumulative basis, starting from the date specified in the row begin date field in the row setup table. periodic - displays account balances/quantities generated by transactions in the date range set for each row.
6	Display Order	Used to control the direction of the rows.
		forward	displays the rows from top to bottom in forward chronological order.
		reverse	displays the rows in reverse chronological order.

Periodic History

Below is an example showing the same account history, with the Representation changed to Periodic. In this case the Period Name column displays a begin and end date, and the number displayed is the change to the account in the period.

View Postings for the Active Cell

In the example below, the history table has been restored to expose the table of postings below. Activating a cell in the history table will display the postings that sum to the amount in the cell (in this case a single invoice for $128.81).

Or another cell

Another example should make this perfectly clear. Below, a Total cell is activated and three postings for July 2009 are displayed.

View Quantities

The example below has switched to the INVENTORY account type to demonstrate that a history table can view Quantities Only.

View Amounts

View Quantities & Amounts

History Windows Track the Active Account Cell

A History Window will respect the range of dates set for an account table cell. In the example below, a Multiple Period Analysis for sales account "Computers - Hyperion 645" shows the history for July 2009, with a daily resolution.

And View the Postings

NOTE: Setting up the history window for one type of account does not affect other types of accounts. This enables you to have a customized history window for each type of account.