Return to
AuditWare Engine Updates
ENGINE UPDATE 11/7/08
Yesterday's change has been extended to include the subtotals when they
are used in the report.
ENGINE UPDATE 11/7/08
When running a Year To Year Variance Report in Report Master, you are
now given a choice of using either adjusted or per books amounts. This feature
was suggested by Derek Anderson of John C. Pechacek, CPA in Bellville, Texas.
ENGINE UPDATE 11/7/08
A routine associated with the notes to the financial statements was
changed to accommodate the implementation of GASB 45 in the Audit I.S.D. for
Texas School Districts product updated today.
ENGINE UPDATE 11/4/08
A minor change was made in the routine which checks whether the fund
numbers present in the fund level adjustment journal match those in the
associated trial balance (the JOURWRONG criteria was changed).
ENGINE UPDATE 10/12/08
In Report Master, a selection for private purpose trust funds has been
added to the list of available fund types when producing lead schedules. This
change was suggested by Robert Lake of Rutherford, Taylor & Company, PC of
Greenville, Texas.
ENGINE UPDATE 9/29/08
The auditor's report on major programs (for single audits) has been
revised to automate the inclusion of sole proprietor pronouns when appropriate
in the final sentence of the next to last paragraph.
ENGINE UPDATE 9/9/08
The expression of the year in yesterday's update has been changed from
"08" to "2008."
ENGINE UPDATE 9/8/08
AuditWare no longer checks network drives when it is initially loaded.
That process caused some computers to slow down.
ENGINE UPDATE 7/2/08
A fifth line has been added to the internally generated letterhead
optionally used on auditor reports. The change was suggested by Bob Wilkinson of
Wilkinson & Hadley, El Cahon, California.
ENGINE UPDATE 5/29/08
The auditor reports within AuditWare have been reviewed against those
provided in the latest edition of PPC's "Guide to Audits of Local Governments"
and appropriate revisions made to all three letters to bring them into
compliance.
ENGINE UPDATE 4/15/08
It is now possible to print a Major Fund Determination Report for all
eligible funds with one command. From the FieldWork main menu, select Print,
then Major Fund Determination Reports.
ENGINE UPDATE 3/22/08
The SEFA federal schedule has been changed to use a simpler method of
printing, making it easier for the user to make manual changes to the schedule
when necessary. It now uses the same method as employed for individual fund
budget comparison schedules, with a visible print range and use of a "Pages"
setting. The schedule will now accommodate an almost limitless number of pages,
rather than being limited to four as in the past. Also, Three lines of help
regarding the new format now appear at the top (outside of the print range).
Schedules created prior to this change will be automatically changed into the
new format when they are either printed or re-created.
ENGINE UPDATE 2/25/08
A problem with creation of the table of contents has been corrected in
which combining statements of permanent funds were being omitted.
ENGINE UPDATE 2/12/08
When the access menu is loaded from the FieldWork, OfficeWork or
Settings modules, steps are now taken to assure that the file ACCESS2.WK3
is loaded, rather than the file ACCESS2.WK4 when the WK4 file has been
inadvertently created. Two AuditWare clients have had a problem lately with this
issue.
ENGINE UPDATE 1/9/08
1) A change was made to attempt to assure that a client is updated and
all files erased from the AWDATA folder when a client is deactivated.
2) A remote error was corrected which sometimes occurred when changing a fund's
fund type to be an internal service fund using individual fund settings.
ENGINE UPDATE 12/29/07
Yesterday's new feature (see below) now includes the ability to define
the codes in the trial balance, placing the definitions in the scratch pad.
ENGINE UPDATE 12/28/07
The menu for the Control I (Interpret Codes) Quick Key used in a trial
balance now includes an option for viewing a complete definition list of the
account codes in the ORG column of the trial balance except when running the
AuditWare for Local Governments product. When running Audit I.S.D. for Texas
School Districts, this is the Organization code. For AuditWare for California
School Districts this is the Resource code. Only the "View-All" option is
currently available. Later the ability to define the codes in the trial balance
(scratch pad) will be available. A version of the school district product dated
today or later should be installed to have an up-to-date list of these code
definitions.
ENGINE UPDATE 12/27/07
The process of creating the statement of activities has been revised to
properly handle formatting when the top section is considerably shorter than the
bottom (general revenue) section. This change will only affect users of
AuditWare for Local Governments.
ENGINE UPDATE 12/20/07
1) The same change made on 11/28/07 (see below) for the basic financial
statements has now been made for the combining financial statements. This
prevents superfluous lines such as "Beginning fund balance, as restated" from
appearing when there is no prior period adjustment.
2) The setup which provides object code definitions is now more "forgiving" to
users of AuditWare for Local Governments. It will now accept at least one blank
definition in the list. As in the past, it remains advisable to provide
definitions for all object codes on the list.
ENGINE UPDATE 12/14/07
A new setting has been added in the "Exhibit Creation Settings" category
worded "Use combining statement of changes for agency funds?' with a default
setting of No. When presenting a full CAFR this statement is automatically
active but we believe it is not required when only presenting combining
statements. This new setting forces that statement to be active even when the
CAFR setting is set for No. This setting was requested by a user.
ENGINE UPDATE 12/13/07
A problem in the creation of the Schedule of Expenditures of Federal
Awards has been corrected in which the asterisk identifying clustered programs
was sometimes omitted from certain federal programs. Thanks to Cheryl Wakefield
of Hereford, Lynch Sellars & Kirkham, Cleveland, TX for sending us the data
which helped us identify the solution to this problem.
ENGINE UPDATE 12/2/07
A major new feature has been added in support of storing and accessing
AuditWare client "archive" files on a remote computer in a computer network
environment. Actually, it is an improved version of a feature which was a part
of AuditWare prior to 1997, so some long-term AuditWare users may remember it.
It prevents multiple users from opening a client which another network user
already has open. Following are the aspects of this change:
1) A client is "locked" when it is opened by a user and it is "unlocked" when the user either switches to another client or de-activates the client. How this works behind the scenes is that a file named the same as the archive file's name but with a .LCK file extension is placed in the AWBARN folder of the computer being accessed when a client is opened. That file is deleted when it is "unlocked" (the client is closed).
2) The command "De-activate the current client" has been moved to the main "AuditWare Tools" (# 6) menu of the Access Menu from the "Tools seldom used" menu.
3) A new command "Unlock a locked archive file" has been added to the "Perform activities with archive files" menu for situations where the computer which opened the client is no longer connected to the network and for other special situations.
4) A new setting called "Change this computer's identification phrase" has been added to the "FieldWork and Miscellaneous Settings" category of settings. An initial installation of AuditWare has asked for such a phrase (i.e. Paul's laptop, the front office computer, etc.) for several years but now that it will be in use, you may wish to change it to something more appropriate. The phrase is used by the message board when you attempt to open a client already open by another user by identifying which computer already has the client open.
5) The setting "Check network drives when loading AuditWare or client data" has been de-activated since it is no longer needed and it's use slowed down some computers.
6) If you don't have a network or aren't using it with AuditWare, there will be no change in how you load and save data. However, since this change may encourage some who have a network to experiment with using it with AuditWare, here's how to get started: a) Create an AWBARN folder on the network drive (AuditWare need not be installed there); b) Copy the small "awbarn.prn" file from your C:\AWBARN folder to the new folder on the network drive; c) With a client loaded select "Use AuditWare Tools" from the Access Menu, then "Perform activities with archive files," then "Change the drive for archiving client data" and enter the appropriate drive letter. You will be asked if you want to update the new drive with this client's data, to which you normally will answer Yes. You may switch back and forth between the C: drive and the network drive at will. If you are certain all of the archive files on the C: drive are up to date, you may use Windows explorer or My Computer to copy all of the files from the C:\AWBARN folder to the AWBARN folder on the network instead of doing it one client at a time through the AuditWare menu.
7) We are leaving in place for now the practice of AuditWare's automatically de-activating the current client upon exit from AuditWare when the drive for archiving client data is set for a drive other than C:, but will consider removing that feature when this new process has been in use for a few weeks.
ENGINE UPDATE 11/29/07
The datafeed file created by AuditWare for submission by Texas school
districts to the Texas Education Agency has been revised, based on an e-mail
received today from Paul Moreno of the TEA's audit division. The change adds
line 9000, column 31 of the Delinquent Tax Schedule (Exhibit J-1) to the
submission file. That line of Exhibit J-1 reports the portion of line 1000 paid
into Tax Increment Zone under Chapter 311 tax code.
ENGINE UPDATE 11/28/07
Technical changes were made to the exhibit creation process to prevent
superfluous lines from being included on certain financial statements. Such
lines include the line "Beginning fund balance, as restated" on the governmental
operating statement when no prior period adjustment is present, and the line
"Changes in net assets" appearing twice on the proprietary fund operating
statement.
ENGINE UPDATE 11/27/07
Changes were made to the process of copying a file for use with the
ASCII file conversion process associated with the Audit I.S.D. product used in
Texas. Users of the Audit I.S.D. product will also need to install a product
version dated today or later to use this engine version.
ENGINE UPDATE 11/15/07
The auditor's report on internal control and compliance in accordance
with G.A.S. has been revised to correct the spelling of the word "adversely" in
the paragraph which defines a significant deficiency. Thanks to John Arndt of M.
Green & Co., Visalia, CA for catching and reporting this.
ENGINE UPDATE 11/15/07
The auditor's report on internal control and compliance in accordance
with G.A.S. and the questionnaire associated with that letter have been revised.
The paragraph referring to the client's responses to the findings listed in the
schedule of findings and questioned costs previously was activated when the user
answered "Yes" to the question "Were there instances of noncompliance which are
required to be reported...etc.?." With this change a new question has been added
specifically addressing whether the client's responses were reported in the
schedule of findings and questioned costs. If you have already accessed the
questionnaire for a client for this year but want to have this change, you will
need to go to the questionnaire in the FieldWork module, return to the menu and
select "Restore Default." Any current year input in the questionnaire, if any,
will be lost.
Thanks to Caron Ketchie of M. Green and Company, Visalia, CA for catching the need for this change.
ENGINE UPDATE 10/13/07
The auditor's opinion on the financial statements was revised to provide
minor changes in wording to be consistent with the 02/07 version of PPC's "Guide
to Audits of Local Governments." Thanks to David Parkman of Edgin, Parkman,
Fleming and Fleming in Wichita Falls, TX for catching the need for this change.
ENGINE UPDATE 8/12/07
Several suggestions made by attendees at our recent seminar have been
made as follows:
1) You may now print the Individual Fund settings for all of your funds by
selecting that command from the Settings menu.
2) Control N (Negative) has been renamed Control R (Reverse). This quick key
reverses the sign of a dollar amount in the trial balance.
3) SAG1 and SAG2 columns have been added to lead schedules in Report Master when
running the AuditWare for Local Governments product.
ENGINE UPDATE 8/7/07
In the last (8/2/07) Engine update, a phrase within the definition of a
material weakness in the second and third auditor reports was changed to read
"or a combination of control deficiencies" instead of "or a combination
of significant deficiencies" to be consistent with the wording in the
AICPA's summary of SAS 112 on it's web site. However, since the latest version
of these auditor reports on both the AICPA and PPC web sites use the word
"significant", we have changed both of those reports back to the original
wording
ENGINE UPDATE 8/2/07
1) Changes were made to the second and third auditor reports to correct
typos.
2) The government-wide statement of net assets will now handle financial
statement setups in AuditWare for Local Governments which exceed the previous 63
row limit. Also, the statement now "shrinks to fit" on one page when printed.
ENGINE UPDATE 7/6/07
Changes were made to accommodate the addition of the Schedule of Excess
Sick Leave in the AuditWare for California School District product.
ENGINE UPDATE 6/12/07
Changes were made to the second auditor's report to correct typos.
ENGINE UPDATE 6/10/07
When accessing an outdated Questionnaire for the Letters in the
FieldWork module, it is now automatically changed out for the current version.
The current version deals with SAS No.112. Most input in the questionnaire is
lost when the change out occurs.
ENGINE UPDATE 6/9/07
1) The second and third letters (auditor reports) have been
substantially revised to implement SAS No. 112 per the examples provided by PPC
and the AICPA. If you are still working on an audit report for a period prior to
12/31/06 and have not finalized those reports, do NOT install this version yet.
The term "reportable condition" becomes "significant deficiency" and is
redefined and "material weakness" is redefined. See
AuditWare News for more
important information about this change.
2) A newly required schedule called "LEA Organization Structure" has been
activated both in the FieldWork and OfficeWork modules for California school
district audits.
ENGINE UPDATE 6/1/07
The Questionnaire for the Letters has been changed replace the words
"reportable conditions" with "significant deficiencies" in preparation for the
implementation of SAS No. 112.
ENGINE UPDATE 5/20/07
The procedure for creating the Statement of Activities when running
AuditWare for Local Governments has been revised to allow for an unusually tall
financial statement setup (more than the standard 64 rows). When this is the
case AuditWare now shrinks the statement to fit on one page vertically, so if
you have a second, facing page active you may wish to use the setting for
printing both sides on one page.
ENGINE UPDATE 3/20/07
In the unusual situation where one of the basic, fund-level financial
statements exceed 68 rows in length, the process of resetting the print range
and placing the reference to the footnotes at the bottom of the page has been
improved. The routine changed is in the BAMAKE file.
ENGINE UPDATE 3/14/07
1) The process of closing government-wide net income to a
"restricted-for" category has been changed to omit the process when there is no
government-wide net income, rather than when there is no fund-level net income
(see formula in "netline" in the "field" file).
2) The creation of the TEA datafeed submission file for the Schedule of
Delinquent Taxes when using the Audit I.S.D. product has been changed to allow
tax rates to be entered as values, if desired, rather than as text.
ENGINE UPDATE 2/12/07
A technical change was made to the process of creating the basic
financial statements to attempt to prevent a line from being omitted when it has
offsetting amounts in the columns of the statement (the line totals zero).
ENGINE UPDATE 12/12/06
In Report Master, a change was made to the criteria for producing the
year to year variance report for expenditures to include Other Uses as a part of
expenditures instead of Other Resources. Thanks to Karen Milligan of Stephen G.
Gilland, P.C. of bowie, Texas for catching the need for this change and
reporting it to us.
ENGINE UPDATE 11/27/06
1) A technical change was made to the process of creating combining
statements.
2) Also, executing the Control N (Negative) quick key now generates a Yes/No
menu before reversing the sign of the dollar amount where the curser is sitting
when that dollar amount is on row 11 of a trial balance in the FieldWork Module
(when the likely intention of the user is Control M, the letter just to the
right of N).
ENGINE UPDATE 11/26/06
The maximum number of funds which can be processed in connection with
any single combining statement has been increased from 100 to 189.
ENGINE UPDATE 11/23/06
The width of several columns in the FieldWork module, mostly those used
for viewing trial balance data, were widened to accommodate amounts of 100
million or more.
ENGINE UPDATE 11/14/06
This is a change in version date only in connection with a general
mailing of AuditWare on CDs to all users.
ENGINE UPDATE 11/1/06
1) An improvement was made in the process of changing the setting "Is
this a budgeted fund?" to insure that data columns are created for the budget
comparison schedule for that fund.
2) For users of Audit I.S.D., any references to "1997" in the names of funds on
the fund list are now corrected to read "2007".
ENGINE UPDATE 11/1/06
The 10/12/06 Engine update (see below) resulted in a conflict with the
setting which removes italics from the financial exhibits when printing, making
it nonfunctional. This update restores the functionality of that setting.
ENGINE UPDATE 10/18/06
When converting old fund lists into the current year format, AuditWare
now ignores old fund lists which have one or more numbers as column headings.
ENGINE UPDATE 10/16/06
When running AuditWare for California School Districts and establishing
a new fund, fund numbers 96 and 97 may now be used for a governmental activities
fund.
ENGINE UPDATE 10/12/06
All of the letters (auditor reports) now use italics instead of all caps
when referring to publications. Users of AuditWare for California School
Districts will have to download an update to that product to get the Auditor's
Report of State Compliance in the new format.
ENGINE UPDATE 9/29/06
1) When multiple prior period adjustments are made to governmental funds
and these adjustments total to zero, the prior period adjustment line of the
governmental operating statement is no longer omitted. Thanks to Ray Bailey of
Richard P. Loughlin, CPA of Henderson, Texas for bringing up the need for this
change.
2) When a prior period adjustment is made, the associated trial balance is now
automatically saved.
ENGINE UPDATE 9/25/06
The process of creating combining statements for discrete component
units has been revised to add a total column.
ENGINE UPDATE 9/24/06
The ASCII file conversion process has been changed. When converting a
delimited to a non-delimited file, the inclusion of the original budget as a 3rd
dollar amount is now honored when present. This primarily relates to Pentamation
files used for Texas school districts.
ENGINE UPDATE 9/14/06
The print margins were changed for several of the new statistical tables
and an additional alternative table was added to the menu. Also, the new divider
sheet for the statistical section has been moved from being a part of the engine
to being a part of each AuditWare product.
ENGINE UPDATE 9/11/06
A change was made in the process of creating the table of contents which
will affect only one AuditWare user firm.
ENGINE UPDATE 9/5/06
The engine has been updated to accommodate GASB Statement No. 44, which
makes wholesale changes in the statistical section of a CAFR. See today's change
of the AuditWare for Local Governments (ALG) product for more information.
ENGINE UPDATE 8/12/06
Some ranges have been expanded in the columns to accommodate the new
reconciliation lines added to the "lists" in the FieldWork module with the
8/3/06 Engine update.
ENGINE UPDATE 8/4/06
For users of Audit I.S.D. for Texas School Districts, the amount of
accreted interest on capital appreciation bonds required for Exhibit L-1.
Schedule of School First Indicators, is now captured automatically from the
government-wide totals of the trial balance.
ENGINE UPDATE 8/3/06
1) The reconciliation "lists" in the FieldWork module have been expanded
to add 18 new reconciling items, many of which are appropriate for users of
AuditWare for Local Governments. Thanks to Chris Rutledge and Lewis Crain of
Rutledge Crain and Company, P.C., Arlington, TX for suggesting these additions.
2) The printing of a "blank" page, the one that reads "This page left blank
intentionally," now prompts for a page number and will include that page number
when that page is printed by itself (as opposed to with a group of documents).
If the new setting is active to follow various exhibits with a blank page, this
feature is not active.
3) In Report Master when going to the "custom" screen to make entries for
producing a "Custom" lead schedule, the previous entries in the Class column, if
any, are now removed automatically. Thanks to Robert Lake of Rutherford Taylor &
Co., PC, Greenville, TX for this suggestion.
ENGINE UPDATE 8/2/06
This update implements several changes suggested by attendees at our
workshops the week of July 24th. They are as follows:
1) When producing a full CAFR, three schedules reporting general fixed assets
under the old reporting model are now available to report capital assets used in
governmental funds under the new reporting model. These exhibits are inactive by
default, since they are no longer required by the GFOA, so they will need to
activated if they are to be used.
2) In a major change, there is a new setting which allows you to automatically
print a blank page following the exhibit or document of your choosing anywhere
in the audit report.. A "blank" page is one which contains the text "This page
is left blank intentionally." When this setting is used, the old method of
printing this page is de-activated. Select the "Printing, Page Numbers and
Pennies" category of settings to find this new feature.
3) When using the command "Back up a client to another drive" on the Access Menu
and selecting "USB Drive," you are now asked if you want to use the drive letter
currently set or to change it. Thanks to Robert Lake of Rutherford Taylor & Co.,
PC, Greenville, TX for this suggestion.
ENGINE UPDATE 7/15/06
This is a change in date only in connection with a general mailing of
all products on CDs to all AuditWare users on this date.
ENGINE UPDATE 7/11/06
A selection for March 31st has been added to the menu for selecting the
fiscal month-ending when importing a paragraph of the notes.
ENGINE UPDATE 6/1/06
Technical changes were made to the utility for deleting data periods to
assure that the fiscal year digit 6 is associated with the year 2006. A related
reminder message was added to the utility for changing a product's "notion"
format.
ENGINE UPDATE 4/13/06
When running AuditWare for Local Governments, you may now import
paragraphs of the footnotes from clients which have a different fiscal
month-ending than the client you are importing to.
ENGINE UPDATE 2/28/06
A problem regarding the "freezing" of certain documents has been
corrected. Previously, when the final active document was "frozen," the
AuditWare user would get a "File does not exist" error when attempting to create
all documents as a group or when using the Turnkey comand.
ENGINE UPDATE 1/25/06
The wording of the default cash flow statement has been revised to
change "Operating Transfers" to "Transfers" and "Deferred Revenue" to "Unearned
Revenue." These are now the preferred wording of these items by the GFOA for a
CAFR presented for an award. Thanks to Charles Fankhauser of Long Chilton LLP of
Harlingen, Texas for passing this along. The wording of these items within each
AuditWare product (the default financial statement setups) will be changed soon.
ENGINE UPDATE 1/15/06
The maximum number of lines on which formatting numbers may be placed in
financial statement setups for individual funds (budget comparisons) has been
increased from 1000 to 2000 lines. Formatting numbers are those which result in
underlines, double underlines, shading, etc. when the statement is created.
Click
Here for 2005 Engine Changes
Click
Here for 2004 Engine Changes
Click
Here for 2003 Engine Changes
Click
Here for 2002 Engine Changes
Click Here
for 2001 Engine Changes
Click Here for 2000 Engine Changes
Click
Here for 1999 Engine Changes