The Reference Document Number field in the G/L YTD Journal Transaction record when output to spreadsheet was copied as a 6 digit numeric.  It has been changed to a 10 digit numeric to handle distributions from the Purchase Order System, and the 8 digit A/R system. (Jan-14-2011)

Documents may be attached to Journal Entries from the Account Inquiry function by selecting the applicable item from the drop-down menu shown when a given transaction is right-clicked.  If they are Office 2003 Word or Excel documents, they may be viewed.  Now, if they are Office 2007 Word or Excel documents they may now be viewed. (Jan-15-2010)

When a Journal Session is posted, the system inspects each transaction to check that they have valid G/L accounts, and that the Ledger Date falls within the range of Valid Posting dates (as defined by the Period Maintenance function).   If either of these conditions occur, the system is supposed to abort the posting.  The problem was that if dates were outside the Valid Posting Period, the journal session was posted anyway.  The problem has been fixed. (Dec-23-2009)

The option to export data to spreadsheet has been enhanced.  There are up to 8 different types of data that may be output to an Excel spreadsheet.  Each type will now be output to it's own worksheet within the Excel workbook.  (Dec-14-2009)

The option to export data to spreadsheet has been enhanced.  There are up to 5 different types of data that may be output to an Excel spreadsheet.  Each type will now be output to it's own worksheet within the Excel workbook.  (Dec-14-2009)

For those functions that export data to Excel spreadsheets, the following enhancements have been made:

The following applications have been revised accordingly, where applicable (Dec-14-2009) :

When a Balance Sheet was generated  for a period in year J with Comparatives, a problem was fixed.  If fiscal year (J - 2) and (J -1) had not actually had the Year End process executed for them, the Comparative figures reported did not include the Opening Balance amounts of year (J - 1).  The problem has been fixed. (July-29-2009)

A new sub-function is available to the G/L Journal Entry Inquiry function.  When positioned on a Journal Entry in the grid, right-click to display the pop-up menu.  The new pop-up menu item Adjust J-Entry Project Code, provides the opportunity to edit the Sub-Ledger Project Code that had been originally entered.  You may also edit the Memo field associated to the Journal Entry.   All the conditions for entry of the Project Code with the given G/L Account apply. (July-03-2009)

A problem has been identified and fixed when loading distributions from the Fixed Asset and Accounts Receivable subsidiary systems.  For any G/L Account that was flagged to have it's distributions compressed into a single transaction, either by Date or by Period, after the consolidated transaction was written into the G/L transaction session, it' contributing distributions were not being deleted from the subsidiary systems. (May-04-2009)

The generic G/L Account Select Filters screen has been enhanced to now specify as filters, Starting and Ending Sequence Numbers associated to a particular Financial Statement Format Number.   All General Ledger applications that provide this selection screen have been revised so that if a range of sequence numbers are specified, then only those G/L Accounts with F/S Sequence numbers falling within the specified range will be included in the report or display. (April-27-2009)

When selecting to print a range of Entities, all were being printed starting with the starting one specified.  Also, the fields for selecting the starting/ending Entity Codes has been revised so that only the numbers of the entities need be entered.  This problem has been fixed. (April-23-2009)

For systems defined with multiple G/L Companies, (Financial Entities), in all the reports, the Series 5 Company Code and Company Name was not being correctly printed in the legends at the top of each page.  This problem has been fixed. (March-31-2009)

The rule for setting up the Chart-of-Accounts is that all accounts with a ZERO Profit Center should be designated as a Framework account.  That is, they should only be used to format the financial statements, and not be used as accounts that can record journal entries against.  The Financial Statements reporting application has been revised so that all accounts with a ZERO Profit Center that are not a Framework account is ignored.  (The problem comes to light if there are VS or VP accounts with a ZERO Profit Center, and a P&L is being generated with columns of Profit Center.  The system can't handle the ZERO profit centers).   (March-25-2009)

The Chart-of-Accounts maintenance routine has been revised to ensure that no G/L Account may be entered with a ZERO profit Center, and be assigned as a VS or  VP account.  The basic rule is that all G/L Accounts that have ZERO profit centers must be Functional Framework accounts.   (March-24-2009)

The function to generate the Financial Statements Formatting report has been enhanced.  It is now possible to specify Starting and Ending Sequence Numbers as filters to limit the G/L Accounts that are listed.   (March-24-2009)

The inquiry and associated report has been enhanced with a number of new features:

You will have to delete any existing GLPROJWRKnnn.DAT and GLPRJQRYWRKnnn.DAT files before executing this revised routine.   (Dec-10-2008)

The flag that was used to identify the G/L Company used for "Consolidation", has been enhanced.  What used to be a check-box is now 3 radio-buttons to identify whether the Company is the "Consolidated" Company, may have it's transactions copied to the Consolidated, or not used in the consolidation process at all.   (Dec-10-2008)

The Company Consolidation function has been enhanced to now be able to handle up to 18 companies at a time. (Dec-10-2008)

Depending on the options chosen, a number of separate Financial Statements may be generated and displayed in the preview grid.  Each Financial is typically separated by a page break.   To make it a little easier to navigate between reports in the preview grid, new push button icons have been introduced beneath the grid on the left.  Clicking these buttons will skip to the prior, or next page break. (Nov-28-2008)

When generating a particular Financial Statement ad-hoc, (from the Financial Statements drop-down menu selecting Profit & Loss Statement, Balance Sheet, P&L Schedules, Balance Sheet Schedules, or Source and Allocation of Funds), a default set of specifications is used.  If you create a Specification Set Numbered 9999, the settings for each of the types of Financial Statements will be used for the ad-hoc generated statements. (Nov-27-2008)

A new function has been introduced to the pop-up menu presented from the Transaction Entry Grid.   You may now Insert a new Standard Transaction at any point in the list of existing transactions.  In the grid, position on the transaction you wish to insert in front of.  Right-click the mouse, and from the pop-up menu, click on the Insert Before item.  All sequence numbers of those transactions higher that the one being inserted will be adjusted accordingly. (Nov-21-2008)

The system will now allow you to enter a Standard Journal Transaction with both the Credit and Debit amounts = ZERO.  This allows you to keep the transaction on file without a journal entry being generated for a particular instance when it is not wanted.  (Oct-15-2008)

The G/L Financial Statements function has been enhanced to offer the capability to automatically send the printed statements to email recipients.  When selected to be printed, the operator may choose to have them emailed to one of the following:

When selected to be sent to the Department or Entity Managers, their respective email addresses must have already been defined in the Department or Entity master record.  When selected to be sent to a particular Email Group, these too must have already been defined.  (Sept-22-2008)

Two new G/L Codes have been introduced to the Series 5 system.  These are Email Recipients, and Email Groups.  An Email Group is used to define a set of Email Recipients.  The Financial Statements function has been enhanced to offer the capability to automatically send the printed statements to Email Groups.  (Sep-22-2008)

When Variances amounts were being displayed for typically Debit types of Accounts, (ie, Expenses), the (..) were not being correctly displayed. If the Variance = Actual - Budget, and is negative, then (..) will not be displayed around the amount.  If the amount is positive, then (..) will be displayed around the amount. (Sep-16-2008)

When selecting a 'Range" of G/L Accounts after processing a report for "ALL" Accounts, the fields were not being initialized correctly.  The problem has been fixed. (Sep-12-2008)

Layouts are defined using a Header record, and a number of Set records.   The Lookup routine was displaying both types of records.  It has been fixed to display only the Header records. (Sep-12-2008)

The following fixes and enhancements have been made to the Financial Statements reporting functions. (Aug-25-2008)

The following fixes and enhancements have been made to the Spreadsheet Layout Maintenance functions. (Aug-25-2008)

Specifications loaded from the old Series 4 system that had Profit Center Entities were not coded correctly.  Series 4 identified them with a code of "Enn".  Series 5 now identifies them as "Pnn" codes.  You must edit each Specification Code that has an Entity defined, and the system will correct them accordingly. (Aug-25-/2008)

The generation of Trial Balances has been enhanced, to allow a date range to be entered. Previously, only a standard accounting period could be selected. (Aug-25-2008)

The General Ledger system now has On-Line Help.  You can access these help files from the application. (Aug-15-2008)

This Inquiry/report analyzes the G/L Journal transactions and accumulated sub-totals by a variety of ways by fiscal periods or fiscal years.  Sub-totalling can be done by Journal Entry Source code, Subsidiary System, Subsidiary System's Entry Batch Code, Transaction Type or G/L Account Type.  The analysis sub-totals may be viewed, printed or output to a spreadsheet. (May-2008)