[MSchappler]

Released – January 31, 2014

What’s New

January 2014 Payroll Update

Includes United States January 1, 2014 tax calculation update.

Includes: Connecticut, Delaware, Illinois, Massachusetts, Michigan, ouri, North Dakota, Oklahoma, Oregon and Vermont.

Additional Views of Transactions for Auditors

Three new scripts have been added to the script library to create views of interest to external auditors.

audit_info_columns.qw_script

This script can be run on any table of NewViews objects (e.g. accounts, journal transactions, ledger postings, etc.). Five new columns are appended to the current table to display:

• Audit Count – a count of the audit items.
• Transaction Id – the database id of the transaction
• Audit Date Created – the date the item was created.
• Audit User Created – the name of the user who created the item.
• Audit Date Last Change – the date of the last change to the item.
• Audit User Last Change – the name of the user who last edited the item.
transaction_all_columns_shallow.qw_script

This script can only be run on the “root” Journal folder. A new window tab is added to explore transaction headers and detail items in the companion window pane. The difference is that the view of both headers and detail items will show the union of all possible posting columns from all types of transactions.

The detail window pane will not respect the type of transaction active in the controlling window pane, and all types of detail items will display using the same column layout as the headers.

transaction_all_columns_deep.qw_script

This script can only be run on the “root” Journal folder. A new window tab is added to explore transaction headers and detail items in the companion window pane. The difference is that the view of headers will show the union of all possible posting columns from all types of transactions.

The detail window pane will respect the type of transaction active in the controlling window pane, and it will switch to the view commonly available for each type of detail items.

Behavior Changes

Prior to this release it was possible to Window>Private Setup an “inner” detail window pane. There is no reason to do this so it is now prohibited.

Also, prior to this release it was possible to Window>Private Setup a folder nested within another folder. For example, you could private setup folder /ACCOUNT/AR/INTERNATIONAL and then private setup folder /ACCOUNT/AR/INTERNATIONAL/USA. In practice it seemed to offer too many opportunities for confusion so it is now prohibited.

Installation now adds a desktop shortcut to run the NewViews workstation.

Problem / Bug Fixes

Couldn’t run database utilities from the command line.

The processing of command line arguments was changed for reasons not related to database utilities but these changes inadvertantly prevented database utilities from processing the command lines properly. This release fixes the problem.

Homing-in on table rows had a problem.

As noted in earler releases, NewViews tables are sorted using a dictionary sort, but when homing in on items as you type, a string sort is more intuitive. This incompatibility between the methods has led to a number problems this version fixes another problem that was actually introduced in the previous release while fixing a previous disconnect between the sort methods.

“can’t read “_options(-titlerows)”: no such element in array”

In some circumstances this error would appear. No error actually occurred and there was no damage to the workstation or application databases, but it was very annoying. This release fixes the problem.

“The workstation has a read-only serial number”

In some cases Print>Account Ledgers>Advanced would report this error and refuse to continue. This release fixes the problem.

NV1_NV2 import failed with a bug.

A minor change elsewhere in NewViews caused NV1_NV2 import to fail. This release fixes the problem.

[Author]

Posts