Click for Index
The changes are presented with the most current items at the top of the list.
Version
Wednesday, November 28, 2007
The Edit Receipt option is now fully functional. This can be found on the
RECEIPT-->Edit Data for a Single Receipt
menu. This function is fully documented in the user manual. See this link for details.
Tuesday, November 27, 2007
Quick Reports -- has been modified to allow you to save the results that appear in the grid showing the query to a Microsoft Excel file. This is directly related to what appears in the grid.
The receipt summary screen has been modified to show the account number as well as the reference number. You can control the widths of the display of the columns via settings in the MISCPARMS table (RECEIPT-OPTIONS). If you don't want to show the account # column, just change the width for that column to "0.0". There are 6 settings ... one for each column, with the default values as shown below
RCPT-GRID-LINENUM-WIDTH .08
RCPT-GRID-TRANCODE-WIDTH .12
RCPT-GRID-DESC-WIDTH .2
RCPT-GRID-REFNUM-WIDTH .2
RCPT-GRID-ACCOUNT-WIDTH .2
RCPT-GRID-AMOUNT-WIDTH .16
The values are expressed as a percentage of the available width on the screen display area, and should add to about 100%. If you set one of the numbers to a smaller value (including 0) you should increase one or more of the other values by a similar amount. Likewise, if you increase the width of a column it will be necessary to decrease one or more of the others to eliminate to have to scroll the grid data to the right to in order to see it all.
The system does not check to see if the values are less than or greater than 100% of the width.
Monday, November 19, 2007
The following changes have been made:
The Fee Distribution Calculator on the Maintenance Menu has been modified to support calculation of up to 10 distributions. The earlier version supported only 5 distributions.
We have implemented the ability to do a real-time query to Eden's UB database. This permits you to get the current customer balance without having to export the data from the Eden database and then import into the Quadrant database. This should work at most sites where the Eden UB system is in use...it might take a bit of tweaking if you have a customized version or non-standard tables in Eden.
The VOID function now allows you to limit the ability of lower level cashiers to
prevent them from voiding work done on a different register than they are currently
working on.
See the VOID-SECURITY options information in the user manual for more information
about this new setting.
The cash recap report now shows the register and user department on the summary sections at the top of the report.
The REPORTNAMES table setup has been modified a little bit so you can set up groups of reports to run in batch mode for Daily, Weekly, Monthly and Quarterly periods instead of just a simple Y or No setting. See the REPORT NAMES table documentation in the user manual for more details.
Inquiry functions have been enhanced to allow you to specify that a user must have elevated security to view data posted by users on a register assigned to another department.
Wednesday, October 3, 2007
The SETREGNUM.EXE module has been modified slightly so that it
first checks for an existing REG.xxx file in thec:\program files\quadrant\raswin
directory. If none is found there, it looks in thec:\ras2000 directory
for a REG.xxx file and if it is found there that is the value that is used
unless the user overrides the value manually. You have 30 seconds to do this
before the program terminates automatically. At that point, whatever register
number was selected (or determined via the automatic process described above)
will apply.
Likewise, it also checks for the TESTMODE.xxx file. The TESTMODE.xxx file in the
OLDER versions was placed in thec:\ras2000 directory. In the NEW version, this
is placed in thec:\documents and settings\all users\application data\quadrant
directory (this is a different location from the REG.xxx file). The SETREGNUM
program will automatically create the TESTMODE file if the old one was present.
It also gives you an option to click a 'checkbox' to create one even if it did
not previously exist, or to 'uncheck' the box it you don't want to create one.
This facilitates upgrading from the older version to the new one without
having to manually set the register number. Once this is done, any old
REG.xxx files are deleted from thec:\ras2000 directory so that future updates
will look only in thec:\program files\quadrant\raswin directory. Any earlier
TESTMODE files are also deleted from thec:\ras2000 directory as well.
Sunday, September 30, 2007
A new ICON has been added to the main menu tool bar. This allows you
to click on a 'scales' icon to go directly to the Balance Screen instead
of having to select FILE-->Balance Screen from the menu.
It will be grayed out if the logged in user's security level is too low to perform
the balance screen option. This level is controlled by the SECURITY SETTING
with the key value of "SECURITY-LEVEL-BALANCE". In most cases, the default
level (99) enables users to perform this function.
The BALANCE screen has been modified slightly to permit you
to adjust the font size of the entry and display boxes for the
coins, bills, etc. so that if your screen is not fully displaying
larger amounts you can reduce the size of the font so it fully
displays. The setting is saved in the database, so the next time
you enter the screen it should reset the font size to the last
value you set via the up and down arrows at the bottom left
size of the screen. Tuesday, August 28, 2007 This version implements a minor change to the BALANCE
SCREEN which allows you to pop up a list of available
CASHIER/BALANCE DATE records that are available for recall.
A new command button labeled SEARCH is now on the screen to the
right of the USER ID field . When you click on this button
the program will display a list of all the available records.
These will be in descending order starting with the most recent
dates. When you click on one of the displayed records the
program will retrieve the data for that cashier for that date.
Monday, August 27, 2007 The ADDRESS ENTRY function has been modified slightly to permit
you to force the user to enter an address as opposed to the older
versions in which entry of the address data was optional.
For more information, please read the file called
Address_Entry_Function_Modification.pdf which
can be found in the
directory.
Monday, August 13, 2007 This update implements a new function that allows you to generate an
XML file containing transaction data for a selected accounting date.
Version 1.0.2049
Version 1.0.2046
Version 1.0.2045
FILE--->
Create XML Transaction File for One Date
menu option.
By default, the program will create the file on this path
c:\Documents and Settings\All Users\Application Data\QUADRANT\export\
with a file name formatted as follows:
QUADRANT_EXPORT_yyyymmdd.XML
(yyyymmdd will be the accounting date for all the records in the file.)
The path and file name format are drawn from the database settings (MISCPARMS) calledEXPORT-XML-FILE-PATH andEXPORT-XML-FILE-NAME-PATTERN, respectively. The yyyymmdd value will be the current CALENDAR DATE. You can adjust these both at run-time (which does not change the default values). Alternatively you can access these parms via Table Maintenance and change them to be formatted as you wish. From that point forward, subsequent runs will use the revised values you set. The user logged into the network must have write-access to the designated path/directory in order for the file to be created. The field names in the export file should be self-explanatory in most cases. If you have any questions regarding this information, please let us know. (Note: rcpt_status value 2= completed receipt, status 99 = voided receipt) This change implements two minor changes to the transaction processing
screen.
During the entry of the trancode field, some characters should not be
used as part of the trancode. In the
past, you could enter these characters, but the program would of course
not be able to find a code that contained those characters. The program
now 'filters' these characters out whenever you type them in the trancode
field so that it won't have to waste time looking for an invalid code and
to prevent there from being any possibility of those codes being part of
the trancode you enter.
By default, the program will filter any of these characters from the
trancode field at the time of entry:
; : [ { ] } / \ | ! @ # $ % ^ & ( ) + = . ? ~ ` - _ < > , ' "
The list above will be created and stored in a new MISCPARM setting
calledFILTER-TRANCODE-KEYS. This will be created automatically if it
does not exist the first time it is needed. After that you can adjust
the entry to add or remove characters as needed for your particular
installation requirements. We can see no reason that any of these
characters should ever be part of a trancode, but you might have
a specific need for some of them (e.g., perhaps a period or dash).
The singe and double quote and the COMMA will ALWAYS be excluded as
possibilities, regardless of what you have listed in the
FILTER-TRANCODE-KEYS setting.
The second change relates to the TRANCODE entry field responding
inappropriately if no code was entered and the ENTER key is pressed.
When this happened the program would advance to the next entry field even
if no trancode had been entered. This has been changed so that you must
enter a trancode (or search criteria so the program can find one or more
matches via the search screen) before the enter key will let you leave
the trancode field.
Wednesday, July 25, 2007 A minor change to the Inquiry screen has been made. This permits you to
see payment information on the 'detail' version of the inquiry screen.
This was not previously available. If the 'Show Pmt#1/Ref#' info option
is checked, and the 'DETAILS' option in the SEARCH MODE box is checked,
the program will now display the METHOD and REFERENCE # of the payment (e.g.,
the check number) the program will check the payment data for the receipt
and show this information in the far right column. If the "Show PMT#1/REF#"
box is not checked, it will not be displayed.
A new function has been added to the MAINTENANCE menu. This is called
"Fee Distribution Calculator". It is used to determine the percentages
needed to properly split funds between multiple accounts when you have a
situation that requires this. It then generates the necessary SQL statements
to update the AUTOTRANS TABLE with the required entries and updates the
FIRST trancode on the list of items with the proper AUTO_TRAN_CODE value
so that it will initiate the SPLIT process when it is used. This can save
a lot of time and frustration when setting these items up. Please refer to
the updated user manual, in the section on AUTO TRANSACTIONS table for more
information about this new function. The HELP menu now has an option to play VIDEO clips containing
training sessions for various aspects of the RASWIN program.
We will be providing a number of short (1 to 5 minute) narrated
video captures of the RASWIN program that will help you refresh
your knowledge on how the system is set up and operates
during normal receipt processing activities.
When you export table data using the "File-->Export Table Data" option
from the main menu (which creates a SQL script with the required 'insert'
statements in it), the program also creates a CSV file with the
same data. The first row of the file will have the field names.
The data itself will be comma delimited. String values (e.g.,
text fields) will be surrounded with double quotes (").
Two changes: The CASH RECAP Report now shows the Account Name associated with the
Account Numbers on the 'totals by account' portion of the report.
The specific account name shown is drawn from the 'Account Verify' table
NOT from the TRANCODES table. If no entry is found in the Account Verify
table, the program will display the words 'Account Not Found in Account Verify Table'
instead of a description of the account.
The CASH RECAP Report now shows the entered COMMENT on the detail portion
of the receipts. If no comment was entered there will be nothing shown on the
report.
A few minor documentation changes were made to the user manual.
These have been incorporated into the setup program which is
one the web for download. The program version has not changed in
any way.
Saturday, June 23, 2007 The behavior of the clip-board clearing action on the Payment
entry screen has been modified slightly.
User Defined function keys on the PAYMENT SCREEN were not
operating as intended. This has been corrected. The program now insures that the RELEASE NOTES file
(which you are reading right now) is able to be read
via the HELP-->NOTES--->Release Notes option. It
checks to make sure the reference to the file is inserted
in the NOTES_TEXT table automatically each time the
program is started. If it is not present in the table
it inserts the needed record.
Tuesday, June 19, 2007 The value of the SKIP_DESCRIPTION flag in the trancodes table
was not being read properly if the value of the DESCRIPTION_EDIT_FLAG
setting was set to "checked". The DESCRIPTION_EDIT_FLAG was used
before the separate SKIP flags for SKIP_DESCRIPTION and SKIP_COMMENT
were implemented. It caused the program to jump directly from the
trancode entry field to the Reference Number field. At the request
of several clients the individual SKIP_ flags were implemented
so that each trancode could be defined to work a little bit
differently depending on the specific requirements for each
unique trancode. The logic for the SKIP_DESCRIPTION flag is now
entirely removed from the program as of this version and the
individual SKIP_ flags are used.
The resizing logic on the Balance Screen was not working
properly. As a result, the screen was not fully visible
when you called it up. This has been corrected in this
release.
Monday, June 11, 2007 A bug was present in the code related to sending copies
of receipts to another person via email on the receipt
review screen. This has been corrected in this version.
The UPDATE DATABASE STRUCTURE screen was tweaked so the
text display of the SQL statements being processed adjusted
itself to the full size of the RASWIN window if the
window size was changed by the user.
There was an error in the UPDATE DATABASE STRUCTURE logic
that sometimes caused all the SQL statements that were intended to
be executed to fail to run. This has been corrected.
The payment processing screen logic has been modified to cause
the payment amount entered on the screen to be automatically
placed onto the Windows clipboard any time the field value
changes. This is to facilitate 'pasting' the payment amount
into other programs such as credit card processing applications
where the credit card logic is not fully integrated into the
RASWIN application (PCCHARGE). This is done only on the payment
processing screen. Tuesday, May 29, 2007 The RASWIN can connect to one of three separate databases:
The normal connection, to Production permits is what most RASWIN
workstations will use..this is where your primary database will reside
and where users will post daily transaction.
If you wish to implement a test database for testing or training
purposes, you can do so by creating a copy of the normal production
database and creating an ODBC connection to it. This ODBC must be
called RASWIN_TEST. (The database name can be whatever name you wish
to use, but we recommend RASWINSQL_TEST for consistency and clarity.)
Some users have found that after a long period of use (many years)
the RASWIN production database size will grow to a point where
performance can be affected adversely. Performance degradation of
this type is a function of many factors, including the database size
(which is basically a function of the number of workstations and daily
transaction volume), network design and speed, server speed and load,
etc.
As a general rule however, it never hurts to remove infrequently
accessed older transaction data to a 'history database' which you can
use for occasional inquiries into to this older transaction data.
To connect to a history database, you must use the DSN name RASWIN_HIST.
As with the RASWIN_TEST database the actual database name does not have
to be RASWINSQL_HIST, but we do recommend that name.
In order to give the user the option to connect to either the TEST or
HIST database, you need to create a small data file in the
c:\program files\quadrant\raswin directory which tells the application
that these databases options should be presented to the user when they
log in.
For the TEST database, the file name needs to be TESTMODE.xxx
For the HIST database, the file name needs to be HISTMODE.xxx
The 'xxx' in the file name (extension) needs to be the register number
setting..e.g., for register 001 the file name would be TESTMODE.001,
for register 002 the file name would be TESTMODE.002, etc.
Under some conditions a receipt would not be printed. This was tracked
to the failure of the program to create a 'Quadrant' directory in the
'temp' files directory where the receipt file was supposed to be created.
This problem seems to be resolved now that the program creates the
'Quadrant' directory it needs. This is done automatically when the program
starts if the directory does not already exist. Wednesday, May 2, 2007 The routines that allow you to export and send your tables to Quadrant's
web site via the FILE-->EXPORT TABLE DATA option were not picking up
the correct file name when the FTP upload was being done. The files
were being created correctly, but could not be sent as intended.
This has been corrected. Wednesday, April 11, 2007 The several RASWIN setup programs have been modified to include a
provision to delete some files after the installation process is completed.
There are two files that control the deletion of unneeded or obsolete
files from the RASWIN directories.
Wednesday, April 4, 2007 Changes have been made to the location of some files used by and
created by the RASWIN program. These are done to make the program
compatible with Windows VISTA, which does not like to allow a user
to run with 'administrator' privileges.
Tuesday, April 3, 2007 Sunday, March 25, 2007
Version 1.0.2037
In earlier versions this was not an option for the DETAILS view.
If the PAYMENTS option is selected in the SEARCH MODE Box, the program will
now display the METHOD (as it did before) but will also now display the
REF# info in the far right column. It will do this regardless of whether the
"Show PMT#1/REF#" box is checked or not. The reference # was also previously
displayed on the PAYMENT mode search in the second column. You can search
for the payment reference number ..e.g., a CHECK NUMBER by putting the
desired number in the DESC/REF#/ACCT#/TRANCODE field on the search screen.
Your search criteria can include wild cards ... e.g., if you are searching
for any check CONTAINING the numbers 638 you can use *638*. If you are looking
for a check # starting with 638 but ending in any other numbers, you can use
638*. The check number search function only works in the 'PAYMENTS' search
mode.
Version 1.0.2033
Version 1.0.2030
As time progresses we will be creating videos that cover most aspects
of the system.
Video production is an area which is new to us, so
please bear with us as we learn how to create them and work out the
details to refine the production qualities.
If there is an area you'd like to see covered, please let us know. Our
initial efforts will be centered on the areas that most users have
had questions about over the past few years.
You can optionally also select to create an Excel Spreadsheet
file by checking the box near the bottom of the screen. You must
have Excel installed on your workstation for this function to work, however
no error will happen if you don't have it available.
If you select the option to create the Excel spreadsheet the export
process will take a little bit longer (but not immensely so).
While the Quadrant Systems RASWIN application has no current use for
this data format (either the CSV or XLS format)
some of our clients have requested that CSV file be generated
for various purposes.
At the present time, there is no capability to directly read these
formats into the RASWIN database.
Version 1.0.2028
Version 1.0.2027
Please see the original write-up for
Version 1.0.2020, on June 8th for the change that was
initially made.
This has been modified just a little bit. A new MISCPARM
has been created to let you control whether this happens
or not. It will be found in the PAYMENT OPTIONS table.
The parameter is calledPMT-SAVE-AMOUNT-TO-CLIPBOARD
If it is not found in the MISCPARMS table, it will
be created with a default value of NO.
This will cause the program to work as it did prior to the
modification. If you want it to work as described in the
1.0.2020 version, just set it to YES.Version 1.0.2026
It is still the case that the SKIP_DESCRIPTION value will be
ignored if you have defined edit masks for the CR or DR account
numbers, as opposed to a 'fixed' CR or DR account number.
Version 1.0.2023
Version 1.0.2022
Version 1.0.2020
Version 1.0.2019
Purpose DSN NAME "Standard" Database Name
--------------- -------------- -----------------------------
Production RASWIN RASWINSQL
Test RASWIN_TEST RASWINSQL_TEST
History RASWIN_HIST RASWINSQL_HIST
The contents of the file are not important. When the program sees this
file (or both files) it will give the user the option to connect to
the alternate database[s] in addition to the production database.
We strongly recommend that either of these options NOT be used on
production machines under most conditions, as it is easy for the user
to connect to TEST, for example, and then forget that they have done so. If
they post receipts to the TEST database, they will not be properly
recorded as part of their normal daily transactions and there will be
balance issues to contend with.
It is not possible to post transactions to the HISTORY database as it
is programmatically blocked from accepting new receipts when you connect
via the RASWIN_HIST ODBC DSN name. However, if you use RASWIN as the
ODBC name, but point the connection to a RASWINSQL_HIST database instead
of the normal production database, it would still be possible to post
receipts. You don't want to do this.
Version 1.0.2013
Version 1.0.2012
Version 1.0.2010
The first of these is controlled by Quadrant Systems. It is
located in the
c:\program files\quadrant\raswin\qsi directory
and is calledquadrant_killlist.txt
The second is a file you can create yourself and should be placed
in the
c:\documents and settings\all users\application data\quadrant\user
directory and it should be calleduser_killlist.txt
At the end of each setup step the program will execute a small
program that will read these two files and delete any files specified
in them. Each file must be listed with a complete path and
file name (e.g.,
c:\program files\quadrant\raswin\editpad.exe
not just the file name alone.
The program will not delete ANY files that are not in one of
the two directories list below:
c:\program files\quadrant\raswin
and
c:\documents and settings\all users\application data\quadrant
The files listed in thequadrant_killlist.txt file are ones that are
obsolete and not needed by the RASWIN application.
The files you list in theuser_killlist.txt can be any that you
don't want to have present following a 'standard' installation.
These might include various graphics files, and some extra utility
programs that are not needed for normal use the of the RASWIN
application.
The program will not delete theRASWIN.EXE program file under any circumstances
even if it is listed in either of thekilllist files.Version 1.0.2005
In earlier versions of the RASWIN application we tried to keep
all of the files related to the program in a single location,
which was thec:\ras2000 directory and various sub directories of
c:\ras2000.
In this version, any files that are created as a result of
processing receipts or running reports are stored in the ALL USERS
or the Current User 'Documents and Settings' folders, which are
permitted to be updated by Windows Vista without Administrator level
rights. We expect that there will probably be more changes related to
operating under VISTA, but none of our clients have made
any migrations plans known to us at this time. In any case,
at some sites we have had issues with the design of RASWIN
requiring admin rights under XP, so these changes will resolve them
as well.
The 'downside' to this change is that many of the very simple
schemes we have used in the past for 'synchronizing' files between
RASWIN workstations will either need to be adjusted or will not work
under VISTA. Updates to the RASWIN program will probably required
Administrator level privileges under Vista, so you should be prepared
to either have an Admin level password available or able to get a
quick response from your tech support staff when needed.
The specific directories involved are (typical:)
c:\documents and settings\all users\quadrant\application data\export
This directory is where your export files will be created unless you
have specified an alternate location in the RASWIN EXPORT SETTINGS
table. As noted above, Windows Vista may require that you change
the current location if your access level does not permit direct placement
of files in thec:\ras2000 directory, or other directories where
you don't have access.
c:\documents and settings\all users\application data\quadrant\logfiles
All logfiles will be recorded to this single directory, shared by
all users of the machine.
c:\documents and settings\all users\application data\quadrant\photo_id
If you want to place your custom photo_id files in this location
you can do so. The program will search for photo_id files in
three locations, in this order.
a. The location specified by the setting in the GRAPHICS settings
This can be a shared network drive if you want to have a
single shared photo_id directory.
b. In thec:\documents and settings\all users\application data\quadrant\photo_id
directory.
c. If it is not found in either a or b above, it will look in
thec:\ras2000\photo_id directory.
If no photo ID is found, it will display a picture with the
words 'no photo available'
c:\documents and settings\all users\application data\quadrant\reports
Various RASWIN processes create audit and daily reports. Most of these
are temporary files (e.g., the CASH RECAP) which are generated as
needed then replaced the next time they are run with new data from
the system.
and
c:\Documents and Settings\[user name]\Local Settings\Temp\QUADRANT
This directory stores temporary files created by and deleted by
the RASWIN program during execution. For example, when you create
a receipt, the data is written to a disk file, then displayed
on the screen, and/or sent to the printer. The files in this
directory are purged automatically so no user action is required
as far as maintaining this directory.
Another planned change is to move the complete RASWIN
application from thec:\ras2000 directory to the 'standard'
Windows 'program files' directory. This should be completed
in a couple of weeks.
Version 1.0.2004
Version 1.0.2001