This feature facilitates, as an option,  recreating reports according to a current or prior System state (this lets you be a quasi time-traveler).  The Palette enables access to the information contained in the System state database table as part of the Main resources view under Database - Source.

The System table tracks the closing and re-opening of Accounting Periods as it relates to posted transactions:

• When transaction data is first posted to the (GL) Summary table, the System state is set to one (1).
• It remains in this state and is not subject to increment until a previously closed accounting period is re-opened through additional data being entered;  the System state is thereafter incremented by 1  only when another transaction document is posted to the reopened period.
• The System state will continue unchanged until the next "period closed - period re-opened (transaction document entered) - and posted" cycle is encountered.

  Please Note:
  When a Transaction Document is first Saved, it receives the System State as it exists at that particular moment in time on a conditional basis; however, when the Transaction is Posted to the GL Summary Table, its System State is overwritten with the System State at time of posting.

The System State should not be confused with the Accounting Period Version number  (see "close and re-open fiscal periods") as shown in the Fiscal Periods window. The System State is equal to the highest Version number. In our example above, this event occurred in Period 96/03. If you would look at the Fiscal Periods window for the above example the Version column would contain the following data for these four Periods:

96/01 = 2
96/02 = 1
96/03 = 3
96/04 = 1

The System table contains one record for each System State, consisting of these fields:

• State: the System State Number (the first record contains 1)
• Date: the Date that this System State was created
• Time: the Time that this System State was created on this Date

Go to:
Index
Table of Contents