A new Inquiry function has been introduced to the G/L system.  "Sub-Ledger Project Transaction Inquiry" provides a grid screen inquiry of all G/L Journal transactions that have been entered with a Sub-ledger Project code.   Transactions may be displayed for selected Projects, G/L Accounts, or Profit Centers.  Assorted filters may be set limiting the types of Transactions displayed.   The operator may choose to filter transactions for a selected Fiscal Period, or any other user defined date range.   (This inquiry function differs from the G/L Journal Entry function inquiry such that all Sub-Ledger transactions recorded in the past are presented, instead of just up to the past 8 years).         (May 30-2014)

The Standard Journal Transaction Entry routine has been enhanced to now allow for entry and editing of journal entry transactions directly on the screen's grid display.  Also, the Debit and Credit fields have been repositioned so they are on the same row next to each other.   The transaction associated to a row is entered or edited as follows:

The General Journal Transaction Entry routine has been enhanced to now allow for entry and editing of journal entry transactions directly on the screen's grid display.  Also, the Debit and Credit fields have been repositioned so they are on the same row next to each other.   The transaction associated to a row is entered or edited as follows:

A number of enhancements have been made to the General Journal Transaction Entry routine in an attempt to minimize the number of fields that are visited when adding new transactions.   The following enhancements when adding a new transaction have been made:

For most of the reporting functions offered in the G/L system, a generic Account Filtering screen is presented allowing the operator to set various values used as filters for inclusion of specific GL Accounts.   The following enhancements to this screen have been made:

A number of minor enhancements has been done to the Chart-of-Accounts Maintenance routine.  As follows:

For assorted G/L inquiry and reporting functions temporary work files are created and built.  These temporary files will now be deleted when the associated function is exited. (As opposed to when the function is re-selected). (March 03-2014)

The function to maintain the Fiscal Periods has been enhanced to allow for "Restricted Access".  Any user that has been flagged as having "Restricted Access" will not be able to set or clear the check-box indicating that the fiscal year has been closed.  Also, all fields on the "Properties" tab will be disabled. (March 20-2014)

A number of minor enhancements has been done to the Standard Journal Transaction Entry.  As follows:

For assorted G/L inquiry and reporting functions temporary work files are created and built.  These temporary files will now be deleted when the associated function is exited. (As opposed to when the function is re-selected). (March 03-2014)

For the applications listed in the following table, when the bottom of the display window is grabbed by the mouse and re-sized vertically,  the grid will also be re-sized and populated with more rows of information as needed. (March 03-2014)

When viewing G/L Trial Balance Account summary totals grouped by Financial Statement Sequence, the grid screen rows will now be displayed with a white background with the F/S Totaling lines displayed with a light blue background color.  As well, for any grouping or sort, the window may now be dragged to increase in size vertically and the grid will be re-sized and repopulated accordingly. (Feb 14-2014)

A new reporting function has been introduced to the G/L system.   The Period Net Change report presents the Net Change for all G/L Accounts by Fiscal Year, Fiscal Quarter or Fiscal Period starting with an operator selected Year.  The data is presented in a grid display screen, that may be printed as a report, or exported to spreadsheet.  A drill-down function is provided showing the detail transaction for selected period and account. Accounts may be displayed sorted by a number of different criteria, including Financial Statement sequences. (Feb 14-2014)

When exiting after processing a given Standard Session, the system will now transfer control back to the Journal Entry Selection screen so that the operator may choose another session to work with.  Previously, control was transferred back to the G/L Menu. (Jan 14-2014)

The screen presented when the Standard Journal Transaction Entry operation has been enhanced.  Next to the J-Entry Session select drop-down field, a "Lookup" binocular push-button has been added.  Clicking this button will present a list box table displaying each Journal Session along with information about it's totals, last posted, and next scheduled post date.  Double-clicking an entry in this table will cause that session to be selected to be edited and processed. (Jan 14-2014)

When generating Standard Financial Statements, you may now select one of the new F/S Specification Groups to have all the Financial Statements defined to each Specification Set belonging to the Group generated.   You may now also just select multiple Specification Sets in an ad-hoc manner.   All the Financial Statements defined to each Specification Set belonging to those selected are generated. (Dec 18-2013)

You may now created Financial Statement Specification Groups.  For each Group defined, you may select up to 120 Financial Statement Specification Sets.  Then when generating Standard Financial Statements, you may select one of these Groups to have all the Financial Statements defined to each Specification Set belonging to the Group generated.   (Dec 18-2013)

In the past, you have been able to edit the Credit/Debit amounts directly on the grid screen.  However, you were required to select the desired transaction with the mouse or cursor key, which would position on the Debit or the Credit.  After editing, if you positioned to the next transaction, the cursor would position to the Debit or Credit, but on the same field as was previously entered.

You may now just edit a value, then after striking the ENTER key, the cursor will automatically position to the Credit field of the current transaction, or the Debit field of the next transaction.  When ENTER is struck in the Debit field with a non-value amount, the cursor positions to the  Debit field of the next transaction.  When ENTER is struck in the Debit field with a ZERO value, the cursor positions to the Credit field of the current transaction. When ENTER is struck in the Credit field, regardless of value, the cursor positions to the Debit field of the next transaction.   You can also just position from Debit to Credit, or to the next transaction using the ENTER key without making any changes. (July 25-2013)

When generating Financial Statements for a Group of Statement Specifications in a period with the fiscal following a "current" year that has not yet been formally closed, incorrect data was being reported.  The problem has been fixed. (May-30-2013)

The Financial Statement printing routines have been enhanced to allow the user to specify the maximum number of columns that will be output to a page, (when actually printed).  A setting in the G/L Control preferences may be set to a value between 6 and 12.  When printed, the selected Series 5 Printer Queue must have been configured for a font that is small enough to accommodate the chosen number of columns, and the associated printer captured with tight margins and possibly in landscape mode.  To fit 8 columns on the page, output must be printed landscape at 7 point Courier. (May-30-2013)

Due to the high number of transactions that may be recorded in the G/L Journal file, it is recommended to convert/build the GL8YRTRXnn.DAT file into a Vision Version 5 file. (Note that the G/L Upgrade program  will automatically convert this file into a VIsion Version 5 file).   However, it will be necessary to add the applicable variables into the runtime configuration files. (Both the runtime, and where applicable, the config files used by AcuServer and AcuConnect).   Series 5 data files as Vision Version 5 files create two sets of system files.  One set holds the actual records, and the 2nd set the keys used to access the records.  Each set will have multiple volumes created, as needed as the file grows.  Each volume can be a maximum size of 2 giga-bytes.   The use of Vision Version 5 files is necessary when the GL8YRTRXnn.DAT reaches approximately 4 million data records.     (May-06-2013)

A new "Edit" function has been introduced to the General Journal Transaction Entry operation.  Available from the menu-bar's Edit drop-down menu, "Reverse Prior Posted Session", will generate reversing journal entry transactions for a selected Posting Set.  (When Standard or General Journal Transaction Sessions are posted, a Posting Set ID # is assigned to each Journal Entry that is recorded).  When this menu item is selected, a screen is presented where the desired Posting Set-ID may be selected along with options for assigning Ledger Dates and Transactions Dates, and a Memo to the generated reversing transactions.  A "Lookup" function is offered to select the Posting Set to be reversed.  When executed, all transactions associated to the selected Posting Set ID # will be copied as new transactions into the current Transaction Session with Debits recorded as Credits, and Credits recorded as Debits.  To execute this function the operator must have "Full" access rights to the the General Journal Transaction Entry function. (May-06-2013)

The Memo field available to General and Standard Journal Transactions has been increased from 40 characters to 80 characters. (May-06-2013)

When a General Journal Transaction Session or a Standard Journal Transaction Sessions are posted, a Posting Set History record is recoded in the G/L system.  A 9 digit Posting Set ID # is assigned to these history records.  This Set ID # is obtained from a field in the G/L Control Preferences, which is then incremented.  As well, all Journal Entries associated with the Journal Session are recorded with this Posting Set ID #.   (The Posting Set ID # is used to track all Journal Entries that were recorded as entered for a particular J-Entry Session, regardless of the Session Code; keeping in mind that a given J-Entry Session Code could be reused, and for Standards, the same J-Entry Session code is used over and over again). (May-06-2013)

This operation has been enhanced to offer a new posting option, whereby a J-Entry Session set of transactions must be Approved before it can be posted.  This option is determined by a new property field in the G/L Control Preferences.  When turned on, only those Series 5 Logon Users with appropriate G/L access rights, and a password, will be able to approve a J-Entry Session.  Once approved, only those Series 5 Logon Users with "Full" access rights to the General Journal Transaction Entry function will be able to post the J-Entry Session.   When approving a session for posting, those users with "Approval Privileges",  will be required to enter the correct password.  Note that  Series 5 Logon Users with "Full" access rights, who are NOT granted direct "Approval Privileges" may approve the session by entering the Logon User's code of the person with "Approval Privileges", along with the correct password.  Once a session has been approved, no further adding or editing of transactions are permitted.  However, there is also a new function that may be selected to De-Approve the J-Entry Session from being posted. (May-06-2013)

When adding a new Journal Entry Session, the operator may now strike the F1 function key to automatically assign a numeric code for the J-Entry Session Code.   The number assigned is obtained from a field in the G/L Control Preferences, which is then incremented. (May-06-2013)

When computing ratios using sets of SR-ER accounts and SC-EC accounts, previously, the SR-ER sets of accounts had to sequentially precede any SC-EC sets of accounts.  The system has been enhanced to now handle the case were SR-ER accounts may be located before or after SC-EC sets of accounts.  (The basis upon which the % are computed is tallied from the accounts between SR-ER formats; and the % amounts are computed for accounts between the SC-EC format. It was assumed the Revenues would always precede Expenses in the financial statements.    Also ratios will now be computed and displayed NT and NP - Net Income - accounts.   (Feb-26-2013)

A problem with closing the 7th Year of a G/L system has been identified.  The computation of the "Balance Forward" transaction of Balance Sheet accounts was not including the prior year Opening Balance.  The problem has been fixed. (Nov-05-2012)

The "Drill-Down" function available to the Project Inquiry and Source Inquiry functions has been revised to utilize a grid table, rather than a drop list.  Improved performance and functionality is achieved for systems with higher number of transactions to be displayed. (Oct-22-2012)

The "Drill-Down" function available to the Financial Statements and Trial Balance reporting functions has been revised to utilize a grid table, rather than a drop list.  Improved performance and functionality is achieved for systems with higher number of transactions to be displayed. (Oct-22-2012)

When interfacing distributions from Accounts Payable, if processing transactions for a G/L Account that was flagged to have either Period or Date Compression, the G/L Transaction was being correctly written, but all A/P Distributions that followed were being deleted.  The problem has been fixed. (Aug-28-2012)

The Trial Balance reporting function has been enhanced. When printed or displayed, sorted by any of the Financial Statement Formats or Supporting Schedules Formats,  the totals of those accounts contributing to financial statements' IP and VP totaling account will now be displayed or printed. (July-13-2012)

The field size of Entity Codes has increase from 9(2) to 9(4).  It will now be possible to define up to 10,000 Entity definitions in the General Ledger System.   (Jun-30-2012)

A new Codes Maintenance function titled "Fin Stmt Formats Explorer", has been introduced that provides the ability to edit Financial Statement Layouts using a Windows Explorer "tree" display structure.  The layout for selected Format # Financial Statements, defined in your system, is displayed in a tree.  Right-clicking a node will present pop-up menus that will provide a number of functions to manage the layout of the financial statements.  The following functions may be performed:

VS Sub-Accounts, are displayed as sub-trees to their parent IP and VP accounts.  The different types of accounts are displayed using different coloured graphics. (Jun-25-2012)

The process for the computation of Column Ratios, when chosen, has been revised.  The Chart-of-Accounts Maintenance routines have been revised to support the new SC and EC Financial Statement Format Codes. (Apr-05-2012)

The process for the computation of Column Ratios, when chosen, has been revised.  Previously, the system attempted to compute ratios relative to SS, ST and TT totals, (Section Sub-Totals, Sub-Totals and Totals) as they occurred, for the items that contributed to these totals.  This method has been abandoned and replaced by two new alternative methods.

Columnar Ratios are computed and displayed when the appropriate option is selected from either the Customize Financial Statements options screen, or the Financial Statement Specifications option screen.  Either, or both, of these two new methods may be employed.  However, should a SS or ST account flag for Sub-Total Ratios fall within the range of either an SR/ER or SC/EC Ratio Control Set, the Sub-Total Ratios WILL NOT be computed.   (Apr-05-2012)

A new function has been introduced to the pop-up menu presented from the Transaction Entry Grid.   You may now Insert a new General Journal 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. (Feb-20-2012)

When Financial Statement totals are displayed, the operator could "drill-down", to have the detail journal entries for each account that contributed to the total displayed.  Push buttons were offered to have the detail for the selected account either output as a report, or output to an Excel spreadsheet.  However, only the detail for a single account at-a-time could be output.  The output to report or spreadsheet functions have been enhanced to prompt the operator to see if detail for ALL contributing accounts are to be output; or just the detail for the selected account.   (Feb-20-2012)

The generation of G/L Financial Statements has been enhanced to provide the ability to enter a non-standard fiscal period reporting date range for which totals are accumulated and presented.  Previously, only the standard defined fiscal periods or years could be reported.  Now the operator may enter any  starting and ending dates that fall within the 8 years defined in the system.   (Jan-20-2012)

The option to display the G/L Accounts by Profit Center was not working correctly.  The problem has been fixed.   (Jan-18-2012)

The G/L system has been enhanced to offer the ability to make Inter-Company Transfer Journal Entry transactions.  A new Operations menu function has been introduced to effect the process of entering and posting Journal Entry Sessions of Inter-Company transactions.  The process of entering these transactions is similar to that of entering normal Journal Entries.  Some of the features associated to Inter-Company Transaction entry are as follows:

.

The process of entering Inter-Company transactions for a given company must be established by a setting in the G/L Control Preferences. (Jun-30-2011)

The G/L system has been enhanced to offer the ability to make Inter-Company Transfer Journal Entry transactions.  This feature is established by setting an option in the G/L Control Preferences associated to each G/L Company.  Inter-Company transactions can only be made when specific company--to-company relationships are defined.  Also, default Transfer Accounts may assigned for Cash, Payroll, Expense and Revenue transaction types. (Jun-30-2011)

For those Series 5 G/L functions that offer the ability to choose a reporting period from a drop list box, the period select process has been revised.  Previously, when presented with the list of periods, the action of clicking a particular entry caused the system to regenerate the given report.  This annoying action has been revised so that now the desired period must be double-clicked.  This makes it easier to navigate through the list of possible periods before one is selected. (Apr-14-2011)

The Series 5 G/L system offers the ability to pre-define up to 1,000 different layouts of financial statements.  Each layout may be assigned to one of 6 different Groups.  When Financial Statements are generated, you may choose to generated all those that belong to a given Group.  A problem was identified when generating Financial Statements for a Group that has a specification created for an Account Entity.  After the 1st set of Financials were generated, any of those following that were set up for an Account Entity were not being generated.  The problem has been fixed. (Mar-30-2011)

The use of Account Entities are used to defined filters for G/L Accounts for both Financial Statements and other G/L Reports as a method to produce reports for specific  accounts where the Main portion of the G/L Account Number has specific values.  The use of Account Entities has been enhanced.  Previously, when setting up starting and ending templates it was assumed that only one of the available G/L Main Account Number segments was to be used to create a filter with a start and end number.  (ie., Having a starting XXX-50-XXXXXX-XX and an ending XXX-60-XXXXXX-XX template would allow for only those G/L accounts where the 2nd segment had a  value that falls within 50 - 60).  And for the given filter definition, all other segments should be set as X's.

The system has been enhanced to allow more than one segment, for a given filter set, to be defined. (ie.  Having a starting XXX-50-XXXXXX-04 and an ending XXX-60-XXXXXX-05 template will now allow for those G/L accounts where the 2nd segment has a  value that falls within 50 - 60 and the 4th segment has a value that falls within 04 - 05). (Mar-18-2011)

The different reporting functions offer a generic G/L Accounts Selection Filter screen.  Assorted fields may be set to filter which G/L accounts are reported upon.  When either an Account Entity or a Profit Center Entity was selected, these filters were not being recognized.  The problem has been fixed. (Mar-09-2011)

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)