How do Fiscal Periods and Recalculate History Work in Sage Pro 7.4?

Closing periods in Sage Pro 7.4 affect current and history transactions as well as history inquiries differently from prior versions of Sage Pro.

Current and History Transactions
All transactions are stored in current or history tables to optimize performance, but the way transactions are moved to history is handled differently in Sage Pro 7.4.

Versions Prior to Sage Pro 7.4
In versions earlier than Sage Pro 7.4, closing the period for an application moves completed transactions from current to history. Open transactions, however, are copied from current to history.

Sage Pro 7.4 or Newer
With the introduction of the archive feature in Sage Pro 7.4, closing a period for an application module is no longer required to move transactions to history. Users are given the option to archive after closing a module; archiving can also be run as a standalone process. Archiving moves all closed transactions from the current tables to the history tables up to the date given when archiving, and open transactions are left in the current table regardless of the transaction date.

History Inquiries
History Inquiries provides historical information for each period for vendor, customer, and items.

Versions Prior to Sage Pro 7.4
In versions prior to 7.4, each time an application module is closed, the period totals in the history inquiries for vendor, customer, and item would move on to the next period. The process does not use the actual date of the close, and the totals cannot be recalculated for each period once they have been calculated once.

Sage Pro 7.4 or Newer
When closing an application module, Sage Pro gives the option to recalculate the totals used for the 24-month history inquiries for customer and vendor, and 36 months for items. At any time, these totals can also be recalculated and updated manually up to the last fiscal period closed with the recalculate history function in System Recovery found in System Manager (SM). The period’s begin and end dates are defined in the company fiscal calendar in SM. The transaction totals for customer, vendor, and item for each period are calculated by the program by looking at transaction dates and comparing them to the defined periods in the fiscal calendar.

In Sage Pro 7.4, the recalculate history option given at the end of closing the period will only calculate the history up to the period prior to the one being closed (i.e.: If 03/08 has just been closed, recalculate history will only calculate up to 02/08). If the totals need to be updated for the period just closed (03/08 in this example,) the current solution is to run recalculate history manually in SM. More information on this issue can be found in Solution 22544 of the Sage Pro Knowledgebase. This issue has been corrected for Sage Pro version 7.5.

Advancing Fiscal Calendar
To increment the current fiscal period, you must close the General Ledger (GL) application module. New to Sage Pro 7.4, if GL is not installed, an option to advance the current fiscal period is available when closing an application module.