Version 7.2.03 (16-Feb-2010)
'More4Apps: TW Open PA Periods Only' profile option added to control whether All or only Open PA Periods are allowed

Version 7.2.02 (29-Jan-2010)
Form and calendar positioning enhancements. Scrollbar added to View Requests log and output window
Stop Transaction form defaulting Item Date when on row 10
Clearing Employee on form did not clear the value in the worksheet
Delete old error messages on successful upload
Fix to duplicate conditional formatting problem in Excel 2007
Fix to Item Date problem when no project number on row

Version 7.2.01 (18-Jan-2010)
Prevent non-open PA periods from passing validation for (customer)

Version 7.2.00 (11-Jan-2010)
Upgrade connection to handle non-ascii characters in R12
Fixed problem in transaction multi-select for upload

Version 7.1.03 (22-Dec-2009)
Performance mod for Excel 2007 - removes conditional formatting in range to be uploaded prior to upload

Version 7.1.02 (17-Dec-2009)
Support added for :SYSTEM.CURRENT_FORM form block field

Version 7.1.01 (15-Dec-2009)
Error messages changed to show column letter rather than column number

Version 7.1.00 (19-Nov-2009)
Licence model altered to prevent use of the tool for non-named users except for About form functions

Version 7.0.03 (6-Nov-2009)
Make Line Comment column mandatory for (customer)

Version 7.0.02 (20-Oct-2009)
New option on toolbar to set Single or Multi worksheet operation
Stop Task date validation from running when Task fails validation
Fix for form load error when no Project number exists
Profile option 'More4Apps: TW Block Multi-Sheet option' added to control use of the multi-sheet option
Changed 'Upload All Worksheets' to 'Upload Selected Worksheets'.  Now you have to select the sheets you want to upload
Added View My Requests form

Version 7.0.01 (12-Oct-2009)
Multi-batch select was not working if the user ran the transaction status refresh before loading the multi-batch form

Version 7.0.00 (23-Sep-2009)
New 'All Batches' and 'Selected Batches' options for Submitting and Deleting Multiple Batches
Fix for 'Out of Stack Space' error in Batch control form

Version 6.1.18 (10-Sep-2009)
Added 'Upload All Transactions on All Worksheets' toolbar button and 'Upload_All_Sheets" public macro
This will loop through all non-hidden sheets in the workbook and load all available transactions
Enhanced Range select so you can now load selected Transactions by shift-clicking on any number of Transactions and leaving gaps

Version 6.1.17 (17-Aug-2009)
Stop erroring row when there is no Project Number.  This allows for a total on the Quantity column without causing the row to be validated
Upgraded DFF module and form to current standard
Added support for menu function exclusions at responsibility level
Added workround for Excel 2007 size increase bug

Version 6.1.16 (7-Aug-2009)
Security fix.  Form was allowing Upload/Delete without checking function security. Also Batch form was allowing Delete without checking function security

Version 6.1.15 (4-Aug-2009)
Fix for bug in upload causing last row in block to be written over with the prior line
Updated URLs to match new website

Version 6.1.14 (30-Jun-2009)
Stop buttons from activating on form until form load is finished
Set Project and Task LOVs to first record after search completed if not exact match

Version 6.1.13 (19-May-2009)
Turn off "Upload Only" mode for (customer)

Version 6.1.12 (1-May-2009)
Fix for failure in load for employee based transactions

Version 6.1.11 (24-Apr-2009)
Optimisations added to counter large performance degradation in Excel 2007

Version 6.1.10 (31-Mar-2009)
Changes to customisations for (Customer)
Fix for main form not allowing a close on row 10

Version 6.1.09 (19-Mar-2009)
Batch Control form was failing to Refresh/Delete because column headers were not set before form load
Set "My Batches" to Off for specific customer on opening program

Version 6.1.08 (17-Mar-2009)
Reset mouse pointer on form load
Prevent error from occurring on Event form load after row 100

Version 6.1.07 (27-Feb-2009)
Significant performance upgrade when checking charge controls in Validate mode. Requires package body 1.0.16

Version 6.1.06 (30-Jan-2009)
Upgraded standard connection modules

Version 6.1.05 (24-Dec-2008)
Fixed bug in validation stopping process when Vendor Number column removed

Version 6.1.04 (19-Oct-2008)
Refresh was behaving strangely after 500 lines
Update to Named User maintenance form to fix form bug appearing on first use

Version 6.1.03 (1-Oct-2008)
Alter Accrual Flag defaulting rule for (customer)

Version 6.1.02 (11-Sep-2008)
Correct inefficient DFF segment validation on upload
Internal improvements to DFF module and form

Version 6.1.01 (4-Sep-2008)
Stop Refresh function from operating on already refreshed transactions

Version 6.1.00 (28-Aug-2008)
Upgrade to About form to accommodate new Activation Key

Version 6.0.13 (20-Aug-2008)
In certain circumstances the tool was loading Project Name and not Project Number

Version 6.0.12 (7-Aug-2008)
Improvements to Named User maintenance form
Changed names of Login options. SSO method is now Standard

Version 6.0.11 (1-Aug-2008)
Minor form improvements to changing Transaction Source and Expenditure Type Class

Version 6.0.10 (31-Jul-2008)
Week end date now defaults to the NEXT week ending date in the LOV
Bug fix in forms where search criteria exactly matches result

Version 6.0.9 (1-Jul-2008)
Start Item Date LOV at current date when no Week Ending Date to save user effort

Version 6.0.8 (25-Jun-2008)
Add Description to LOV for Independant Value Sets in DFF segments

Version 6.0.7 (22-Jun-2008)
Added Expenditure Type Search for customer

Version 6.0.6 (18-Jun-2008)
Stop Refresh from stopping prematurely at 512 rows in certain circumstances

Version 6.0.5 (12-Jun-2008)
Validation added to stop Costed Transaction being loaded without a Raw Cost value
Fix for repeated use of treatment for apostrophe in a string from duplicating the apostrophe
- Main form widened. Project Number shortened
- Copied Quantity to Denon Raw Cost for Costed Sources

Version 6.0.4 (11-Jun-2008)
Fix to wrong proc name used for R12 call

Version 6.0.3 (9-Jun-2008)
changed their mind about the delete function
Batch LOV now shows only the batches with the same name as on the sheet
Accrual defaults to Yes for a particular Batch Source

Version 6.0.2 (3-Jun-2008)
Upload individual/selected transactions disabled for
Delete function disabled for
Any rejection will reject all records in batch for
Added Up/Down button to allow Transaction form to navigate to the next/prior row
Added Task search feature
Project and Task search now works on both Project/Task Number and Name
Week end date now defaults to the last week ending date in the LOV
Custom form added in order to re-order fields for
Key member security added for

Version 6.0.1 (22-May-2008)
Added validation to prevent Accounted transactions without a GL Date from being loaded
Form fix to stop existing Expenditure Type value from clearing on load

Version 6.0.0 (12-May-2008)
Redesigned to use Row 10 for defaults
Removed existing Transaction values from Header section
Separated Batch Header form and Batch Control values into separate forms

Version 5.1.7 (29-Apr-2008)
Minor change to procedure handling apostrophes and non-ascii characters

Version 5.1.6 (24-Apr-2008)
Added "List My Batches Only" checkbox to Batch Header form

Version 5.1.5 (24-Apr-2008)
Client specific customisation - users may not import their own batches
users may not delete transactions created by other users

Version 5.1.4 (31-Mar-2008)
Update for R12 - ORG_ID column in multi-org open interface tables MUST be explicitly populated in R12
Fix for Concurrent program call not working in R12

Version 5.1.3 (12-Mar-2008)
Updated XML module and About form

Version 5.1.2 (10-Mar-2008)
Program was not requiring an Employee or Organization for Miscellaneous Transactions

Version 5.1.1 (23-Jan-2008)
Date error message in main form changed to show a proper date format
Resized browser login window to allow for R12

Version 5.1.0 (22-Jan-2008)
Upgraded for R12 connection, new About, Help, Login, URL setup forms
New links to Release Notes and On-Line documentation

Version 5.0.9 (8-Oct-2007)
Added new techniques to help prevent toolbars locking up
Stop Excel from using scientific number format on downloaded data
For specific Client - stop Employees with no Job on their assignment from being usable

Version 5.0.8 (3-Oct-2007)
Employee validation was not stopping the upload for certain error conditions
Retry added to SQL and Procedure calls

Version 5.0.7 (28-Sep-2007)
Employee search was not adding employees to the list unless Employee AND Org changed

Version 5.0.6 (27-Sep-2007)
Client customisation - wants only open periods to appear in Expenditure Ending Date LOV

Version 5.0.5 (11-Sep-2007)
Suppress 'Accounted Details' tab on form if columns have been removed
Resized SSO Login form window
Handle login error message when no functional currency defined

Version 5.0.4 (29-Aug-2007)
Change Date formatting to use PC's Short Date format
Required to alter Batch Header and Transaction forms to comply with Sysdate to Item Date mod in 5.0.2

Version 5.0.3 (31-Jul-2007)
Fix for minor bug on Accounted Details tab on Transactions form

Version 5.0.2 (20-Jul-2007)
Extended new feature in 5.0.1 to work in the same way with Task Name. This has priority over Task Description
Assignment validation was using Sysdate, not Item Date

Version 5.0.1 (8-Jul-2007)
New feature. If there is no Task Number but there is a value in a 'Task Description' column then the tool will try to derive the Task Number. Works on upload and on load of the Transaction form
The upload will error if the Task description is found to be not unique on the Project

Version 5.0.0 (15-May-2007)
Added support for Single Signon
Tolerate missing port number in login URL (for 8000 default)
Better error handling for invalid URL setup
Added new URL setup test
Added logged in responsibility to About form

Version 4.3.1 (27-Mar-2007)
Fix for non-ASCII characters in new performance technique. Requires M4APS_XML package body 3.0.08

Version 4.3.0 (19-Mar-2007)
Fix for timeout problem caused by Internet Explorer 7

Version 4.2.08 (13-Mar-2007)
Refresh status on Transaction form was being reverted when form closed
Refresh button added to toolbar for consistency with the other M4A tools

Version 4.2.07 (12-Mar-2007)
Fix spelling mistake in bind variable feature in Refresh function

Version 4.2.06 (27-Feb-2007)
Employ bind variables to improve SQL performance for multiple validation calls

Version 4.2.05 (16-Feb-2007)
Stopped program caching all Tasks on a Project during Validation
Validation errors were not making the row status as Rejected

Version 4.2.04 (28-Dec-2006)
10g database was not being detected properly for non-ASCII character handling
Cosmetic improvements to About form

Version 4.2.03 (7-Dec-2006)
Client specific customisation

Version 4.2.02 (27-Nov-2006)
Added full Flexfield form support for Account codes
Cosmetic improvement to all form color schemes and About form design

Version 4.2.01 (18-May-2006)
Fix for issue with apostrophes in Validate Mode

Version 4.2.00 (16-Oct-2006)
Modifed Install to work on Oracle on Demand instances

Version 4.1.13 (5-Sep-2006)
Was loading Business Group even when no Employee selected. 4.1.04 fix was lost

Version 4.1.12 (26-Jul-2006)
Fix to Replace97 procedure for Excel 97 users
Useability improvements to login form
Enhancement to login form to better show HTML error messages
Extended character conversion for 11.5.10CU2 Apache security
Fix for Multiple Employees with the same name not showing all of them in the Employee LOV

Version 4.1.11 (23-May-2006)
Login enhanced to allow non alphanumeric characters in password
Special character handling function added to modXMLHTTP
Space character now handled in password

Version 4.1.10 (31-Mar-2006)
Changed "Currency" on transaction details form to "Amount"

Version 4.1.09 (16-Feb-2006)
Allow transactions to be loaded in Future PA Periods

Version 4.1.08 (12-Jan-2005)
Logout was not clearing Joint Login values

Version 4.1.07 (14-Dec-2005)
Upgrade to allow use as an XLA in custom front-end spreadsheets
Stop login procedure looping if no M4APS_XML package installed

Version 4.1.06 (15-Oct-2005)
Manually entered Batch Name was not being loaded

Version 4.1.05 (6-Oct-2005)
You can now manually enter the Batch Name. If you don't enter a batch name the wizard will populate the spreadsheet and header form with a default batch name
Added search facility to Named User form

Version 4.1.04 (18-Aug-2005)
Restrict Batch name to 10 characters to comply with length contraint prior to 11.5.9
Stopped business group from being loaded if no employee selected

Version 4.1.03 (18-Aug-2005)
Use Override to Org Name column where both Organisation and Employee Number used
Fix to Delete function for change in batch naming convention

Version 4.1.02 (9-Aug-2005)
Change display of Batch Header form's batches
New naming convertion for Batches based on UserName + Transaction Source + Sheet Name

Version 4.1.01 (6-Aug-2005)
Fix for minor Form error if Organisation column removed
Support Session ID login validation method

Version 4.1.00 (5-Aug-2005)
Switched XML object from Fixed Reference to Late Binding
Orig transaction reference was incorrectly adding "|" to value - affecting Refresh
Allow Refresh when no batches exist

Version 4.0.19 (2-Aug-2005)
Allow Organisation field to override Employee Organisation
Expired users removed from Named User form
Fix for certain DFF Value sets containing $Profiles$: and IN statements

Version 4.0.18 (27-Jul-2005)
Stop repeated DFF configuration caching when no columns defined

Version 4.0.17 (25-Jun-2005)
Remove Digital Certificate
Added Release Notes link to About form

Version 4.0.16 (22-Jun-2005)
Fix DFF reference field issue

Version 4.0.15 (14-Jun-2005)
Fix bug in frmDFF using A_ValueSet instead of rsFlex array

Version 4.0.14 (2-Jun-2005)
Fix for Ascii characters mixed with Unicode values

Version 4.0.13 (30-May-2005)
Updates to DFF module
Unicode workaround is unavailable for databases prior to 8i

Version 4.0.12 (26-May-2005)
Changes to cope with Unicode characters. Requires XML package body 2.0.45

Version 4.0.11 (9-Apr-2005)
Bug Fix in DFF module

Version 4.0.10 (2-May-2005)
Support Profile Option in DFF Context Reference field
Move Flex sql procedure from server to VBA
Check for Numeric value before exec sql in DFF

Version 4.0.09 (18-Apr-2005)
Sys Link Function Parameter added to validate transaction procedure call

Version 4.0.08 (13-Apr-2005)
DFF Performance Enhancements and add ID column

Version 4.0.07 (31-Mar-2005)
Fix for problem retaining Digital certificate
Login configuration hidden if Setup Toolbar not shown

Version 4.0.06 (15-Mar-2005)
DFF module was not making use of defaults

Version 4.0.05 (14-Mar-2005)
Minor improvement to Employee behavior on both forms

Version 4.0.04 (06-Mar-2005)
Fix for European decimal character not being handled properly

Version 4.0.03 (23-Feb-2005)
Performance improvement to DFF form
Remove Function to Check for non-Ascii characters

Version 4.0.02 (21-Feb-2005)
Fix display context logic

Version 4.0.01 (17-Feb-2005)
Remove Replace97 call for chr(0), Don't display error when context col missing

Version 4.0.00 (09-Feb-2005)
New DFF module added

Version 3.0.10 (05-Feb-2005)
Performance enhancements plus new Permanently Hide option for Setup toolbar
Version 3.0.09 (30-Nov-2004)
Bug fix for Excel error if Organization column in Override section removed

Version 3.0.08 (24-Nov-2004)
Bug fix for person_id column used for validation (which is empty) instead of created_by

Version 3.0.07 (05-Oct-2004)
Further fix for employee number validation - 3.0.06 users please upgrade to this version

Version 3.0.06 (02-Oct-2004)
Bug fix for wrong employee number passed to validation procedure
Stopped call to validation procedure for Upload Only option
Bug fix for failure when Employee Number override column removed

Version 3.0.05 (21-Sep-2004)
Large speed improvement due to Upload caching and transfer of validation to database
Removed requirement for Trusted VB Project

Version 3.0.04 (13-Aug-2004)
Removed Bug in Task validation where no Task or Project end date

Version 3.0.03 (04-Aug-2004)
Made Expenditure Types LOV more efficient and added override for System Linkages
Add Function to Check for non-Ascii characters
Check for duplicated column headings added

Version 3.0.02 (21-Jun-2004)
Switched to different IE API to better handle UTF8 character set

Version 3.0.01 (03-Jun-2004)
Login script change to allow for port numbers larger than integer size limit

Version 3.0.00 (31-May-2004)
Converted to Web/XML connection technology

Version 2.0.17 (03-May-2004)
Accrual Flag was not being adequately validated

Version 2.0.16 (23-Mar-2004)
Improvements to Business Group handling

Version 2.0.15 (26-Feb-2004)
Added public code to enable double-click in external workbooks
New button on Setup toolbar allows show/hide of Template sheet
Added ability to select a range of Transactions to upload
Minor improvement to Login form

Version 2.0.14 (08-Jan-2004)
Bug Fix. Validation of NLResource and Org were stopping at 15000 in array
Stopped upload loop from attempting to go past bottom of worksheet = 65536 lines

Version 2.0.13 (22-Dec-2003)
Fix for Emp Number mode not selecting correct Person ID for Multiple Emp Numbers.
Setting cell colour for Upload/Validation operations

Version 2.0.12 (04-Dec-2003)
One more Integer to Long change to cope with capacity problem.

Version 2.0.11 (01-Dec-2003)
Added detailed progress messages for APPS grant step.
Improvement to Projects/Tasks LOVs to include Cross Charge Projects and Tasks.

Version 2.0.10 (21-Nov-2003)
Changed Integers to Longs to cope with capacity problem.

Version 2.0.09 (19-Nov-2003)
Enhance About form and password expiry feature.
Respect end-dates of Responsibility and Responsibility Assignment.

Version 2.0.08 (4-Nov-2003)
Test added for database user's password expiry.

Version 2.0.07 (22-Oct-2003)
Cosmetic form and date format changes. Added sample sheets.

Version 2.0.06 (19-Sep-2003)
Allowed change in Project number to keep same Task number if such a Task number exists.
If no matching Task number exist - LOV starts blank.

Version 2.0.05 (02-Sep-2003)
Stopped re-validating already validated transactions when bulk uploading.

Version 2.0.04 (28-Aug-2003)
Minor cosmetic change to Unit of Measure shown on Transaction Entry form. Now retrieves Unit of Measure from Lookup setting instead of Expenditure type.

Version 2.0.03 (20-Aug-2003)
Fixed bug in TRX Import for resubmitted batches - Was causing Concurrent Program to fail.
Some changes to Refresh feature.
Can now purge "Accepted" batches.

Version 2.0.02 (18-Aug-2003)
Modified Refresh function to include Expenditures imported then purged from the interface.

Version 2.0.01 (2-Aug-2003)
Due to ongoing issues with the VB libraries especially with Excel 97, these have been systematically removed from our products, removing the requirement to run the installation script on every PC required to use the software.
Discovered a bug whereby the upload would not operate if the Vendor column was removed.
Discovered a potential bug in the Resource LOV for Usages.

Version 1.3.09 (30-Jul-2003)
Tested for 11.5.9 (PA.K). Flexgrid removed, also logos from VBA forms. Minor changes to Array caching and Login form.

Version 1.3.08 (16-Jun-2003)
Bug fix. Except if Header form was loaded first, an incomplete list of Expenditure Types was loaded and cached. Only affected R11i and certain Expenditure Type Classes.

Version 1.3.07 (26-May-2003)
Enhancement to date fields and Forms. Sheet now in General format for dates then Custom dd-mmm-yyyy format after form and upload operations.

Version 1.3.06 (15-May-2003)
Enhancement - Allow 6 months minimum of past dates in form LOVs. PA allows expenditure items to be entered for closed PA Periods.
Enhancement - Include day in Transaction Date LOV in Details form
Enhancement - Reverse sort order for dates in both Header and Details forms

Version 1.3.05 (28-Apr-2003)
Bug Fix - To resolve date conversion error for foreign languages.

Version 1.3.04 (11-Apr-2003)
Improved Error Message handling - now stored in the sheet from validate routine
Removed compulsory validation for "Upload only"
Fixed Bug - Switching from Employee Name to Employee Number crashed the program for version 1.3

Version 1.3.03 (10-Apr-2003)
New toolbar option to logout.

Version 1.3.02 (24-Mar-2003)
Bug Fix - To return the CCID and not the actual Concatenated Segments for Code Combination columns.

Version 1.3.01 (01-Mar-2003)
Code moved to DLL. Release moved to 1.3