Project Transaction Wizard Version

Package Body Version

12.4.65 (15-Apr-2025)

4.1.8 (Minimum 4.1.8)

12.4.65 (15-Apr-2025)

Default Browser Login - Fixed bug where the browser would not navigate away from the homepage. This stopped the login process from completing.

12.4.64 (06-Oct-2024)

Fix for incorrect determination of Open GL Period date range.

12.4.63 (04-Oct-2024)

Added Default Browser Login option.

12.4.62 (08-Apr-2024)

Refresh form Log button error fix.

12.4.61 (03-Apr-2024)

Refresh SQL improved.

12.4.60 (23-Feb-2024)

Fixed color of fields which are green on validation.

12.4.59 (27-Nov-2023)

Fixed issue where an End to End Trace might not return the SQL statement's execution plan.

12.4.58 (06-Sep-2023)

Present login prompt when creating a new sheet from the Template.

12.4.57 (06-Sep-2023)

Internal update.

12.4.56 (27-Apr-2023)

Internal update.

12.4.55 (27-Apr-2023)

Internal update.

12.4.54 (26-Apr-2023)

Fix for Refresh not changing statuses on sheet.

12.4.53 (04-Apr-2023)

Internal update.

12.4.52 (17-Mar-2023)

Fixed an issue that caused large uploads to unexpectedly fail with error "438(Object doesn't support)".
Removed unsecure document links.
Fixed the issue where enabling end to end trace did not generate the trace.

12.4.51 (05-Mar-2023)

Pre-select record in the Batch Control form LOV if it matches the Batch name shown on the sheet.
Removed unused Profile Option 'More4Apps: TW Batch Name Mandatory'.
Added Profile Option 'More4Apps: TW Enforce List My Batches Only checkbox'.
Fix for formulas in Default row 10 overwriting values on Transaction row.
Fix for value in Defaults row rather than formula being written in to Transaction row.

12.4.50 (05-Dec-2022)

Internal update.

12.4.49 (05-Dec-2022)

Internal update.

12.4.48 (17-Nov-2022)

Remove 'Batch List Refreshed' pop-up message after deleting a batch.

12.4.47 (08-Nov-2022)

Remove 'Run Refresh now?' pop-up message after closing batch control form.

12.4.46 (28-Oct-2022)

Added message 'Batch List Refreshed' on Batch Control form.

12.4.45 (19-Oct-2022)

Fix for multi-sheet upload not working.

12.4.44 (05-Oct-2022)

Fix for customisation disabled in prior mode.

12.4.43 (30-Sep-2022)

Fix for client specific customisations not being enabled.

12.4.42 (28-Sep-2022)

Fix for Employee validation error when Employee cache full from search function on form.

12.4.41 (27-Sep-2022)

Allow validation only for named exception users.

12.4.40 (20-Sep-2022)

Fix for Award error if Award number column deleted.

12.4.39 (20-Sep-2022)

Internal update.

12.4.38 (07-Jul-2022)

Fix for failure in upload due to 12.2 patching method change.

12.4.37 (06-Jul-2022)

Internal enhancements.

12.4.36 (30-Jun-2022)

Internal enhancements.

12.4.35 (27-Jun-2022)

Performance improvement - Remove deleted optional columns from upload processing.

12.4.34 (21-Jun-2022)

Batch Header Values form was correcting invalid week ending date error on load when it should have left the error for the user to fix.

12.4.33 (07-Jun-2022)

Internal update.

12.4.32 (26-May-2022)

Fixed ribbon tooltips and spelling issue.

12.4.31 (28-Apr-2022)

Internal update.

12.4.30 (28-Apr-2022)

Internal update.

12.4.29 (20-Apr-2022)

Internal update.

12.4.28 (22-Feb-2022)

Custom Query update with SQL injection fixes.

12.4.27 (02-Feb-2022)

Bug fix - Custom LOV was not providing additional validation during upload for Projects and Tasks.

12.4.26 (03-Dec-2021)

Internal update.

12.4.25 (13-Oct-2021)

Internal update.

12.4.24 (04-Oct-2021)

Bug fix - A formula in row 10 does not copy to the data rows.

12.4.23 (29-Sep-2021)

Allow default value for column 'Quantity'. Require 'Quantity' or 'Denom Raw Cost' column in order process row.
Offer the user to run the Refresh job after Batch Control form closed.

12.4.22 (14-Jun-2021)

Internal update.

12.4.21 (11-Mar-2021)

Fixed issue with uploading Attachments Status.

12.4.20 (08-Mar-2021)

Added error message when login with incorrect host name.

12.4.19 (08-Mar-2021)

Fixed issue where code would blow up randomly.

12.4.18 (04-Mar-2021)

Internal updates.

12.4.17 (04-Mar-2021)

Updated security.

12.4.16 (18-Dec-2020)

Removed a windows API call to stop the anti-malware from killing Excel application.

12.4.15 (02-Dec-2020)

Updated security.

12.4.14 (03-Nov-2020)

Updated security.

12.4.13 (20-Oct-2020)

If Task Number 1.0 is entered in default row, the uploaded values turn to 1.

12.4.12 (12-Oct-2020)

Removed 'Delete Transaction Batch' button from the ribbon.

12.4.11 (02-Oct-2020)

Date form changes when copied from default row. Item date LOV has problems.

12.4.10 (18-Sep-2020)

Fix for losing leading and trailing zeros on strings that look numeric and converting strings that look like dates to dates.

12.4.09 (31-Jul-2020)

Refresh button on Batch Control form did not refresh the LOV. Hitting Escape did not close the form.

12.4.08 (24-Jul-2020)

Fix for issues with the multi-sheet loader.

12.4.07 (20-Jul-2020)

Fix for minor form bug when Employee columns are removed.
Fix for upload error when Original Reference column is removed.

12.4.06 (06-Jul-2020)

Fixed - Error appears when clicking the Forms icon on the ribbon and selecting 'Batch Header Settings'.

12.4.05 (02-Jul-2020)

Updated security.

12.4.04 (31-Mar-2020)

Internal update.

12.4.03 (20-Mar-2020)

Fixed issue with Transaction form not able to be closed until all mandatory values have been entered.

12.4.02 (12-Mar-2020)

Internal update.

12.4.01 (11-Mar-2020)

Internal update.

12.4.00 (09-Mar-2020)

Rebranding of logo and new color scheme.

12.3.09 (25-Feb-2020)

Default Row functionality fixed.

12.3.08 (06-Dec-2019)

Updated security.

12.3.07 (16-Oct-2019)

Customization for customer.

12.3.06 (11-Oct-2019)

Enable solution to try and stop the calls being made as SQL injection by firewalls (requires ServletVersion >= 10294 for R12 or Shared Package version >= 50421 for R11 to work).

12.3.05 (13-Sep-2019)

Updated security.

12.3.04 (29-Aug-2019)

Setup menu - Hide at Start-up issue

12.3.03 (16-Aug-2019)

Left aligned all heading columns

12.3.02 (16-Aug-2019)

Added Change Log Sheet

12.3.01 (22-Jul-2019)

Fix for Login form and internal updates - Core menu.

12.3.00 (19-Jun-2019)

Implemented new colour scheme

12.2.61 (30-Apr-2019)

Fixed the issue of getting pop-up message Template123 sheet missing for existing template sheet.

12.2.60 (30-Apr-2019)

Fixed the issue of New Sheet created after deleting Template123 sheet.

12.2.59 (29-Apr-2019)

Fixed the issue of getting VBA error "Error 9 (Subscript out of range)" while creating New Sheet after deleting Template123 sheet.

12.2.58 (29-Apr-2019)

Fixed the issue of getting VBA 'Run-time error '9999' after deleting Template123 sheet from the Wizard.

12.2.57 (18-Apr-2019)

Fixed the issue of Transaction form closing when mandatory values are not entered.

12.2.56 (16-Apr-2019)

Fixed the issue of not clearing sheet values when clicking Cancel button on Transaction form.
Fixed the issue of Business Group value clear after selecting Organization on Transaction form.
Fixed the issue Transaction Wizard allowing to load transaction on Trial Key.

12.2.55 (11-Apr-2019)

Fixed the issue of getting error message "Ther are 31 employees with this Employee Number." for valid employee and uploading transactions.

12.2.54 (07-Mar-2019)

Fusion - Fixed the issue of colour change on form for required columns.

12.2.53 (06-Mar-2019)

Updated security.

12.2.52 (06-Mar-2019)

Fusion - Fixed the issue of getting SQL error while searching employee using the form.
Fixed the issue of not clearing in valid values from the sheet when clicking Cancel.

12.2.51 (26-Feb-2019)

Fusion/Cloud EBS - Added Form Validation for Expenditure item date with Project Start Date and Completion Date.

12.2.50 (07-Jan-2019)

Fix for Subscript out of range error message when caching Employee records.
Fix for incorrectly rejecting Employee. This could occur when there is a duplicated employee name or number in a different business group.

12.2.49 (12-Nov-2018)

Fixed the issue of getting VBA Type mismatch error while deleting transaction using the Transaction form.

12.2.48 (05-Nov-2018)

Fixed the issue of not defaulting 'Employee Name' Preference on the ribbon while opening the Wizard.

12.2.47 (05-Nov-2018)

Fixed the issue of Validate button not working using the Transaction form.

12.2.46 (02-Nov-2018)

Fixed the issue of not printing Wizard error message on correct row while loading Transactions.

12.2.45 (24-Oct-2018)

Updated security.

12.2.44 (08-Oct-2018)

Fixed the issue where the users got the Windows Security Waring with other non-M4A add-ins. Now the workbooks and Add-ins with the customer functions have to have the name starting with "M4A_Custom_Functions" and case insensitive. The error message will be shown if failed to run the M4A customer functions.

12.2.43 (02-Oct-2018)

Fixed issue of Wizard crashing while opening in Excel 2007.

12.2.42 (26-Sep-2018)

Fixed the issue of allowing user to submit/delete transactions using option Delete Batch Transaction and Batch Name is missing from the sheet.
Fixed the issue of not clearing Batch Name and Wk Ending Date after clicking Cancel button on the Batch Header form.

12.2.41 (20-Sep-2018)

Fixed the issue of not allowing user to load transaction when using 'upload all transactions on selected sheets', when the cursor is on above row 10.

12.2.40 (20-Sep-2018)

Fixed the issue of getting VBA Error 1004 while opening on the form on new Sheet and Expenditure ID and Expenditure Item ID are missing from the sheet.
Fixed the issue of not concatenating error message while writing on the sheet internal changes.

12.2.39 (19-Sep-2018)

Fixed the issue of getting overflow 6 error while passing invalid date.

12.2.38 (04-Sep-2018)

Updated security.

12.2.37 (31-Jul-2018)

Fixed issue for 64bit excel (crashing after saving changes).

12.2.36 (30-Jul-2018)

Fixed the issue of getting invalid number while uploading transactions with european number format.

12.2.35 (17-Jul-2018)

Packages updated.

12.2.34 (11-Jul-2018)

Renamed the columns 'Resource' and 'Billable/Capitalizable' to 'Non Labor Resource' and 'Billable Capitalizable'.

12.2.33 (10-Jul-2018)

Internal update.

12.2.32 (10-Jul-2018)

Updated security.

12.2.31 (26-Jun-2018)

Fixed the issue where upload failed with the error "ORA-01722 invalid number" when the user set the number format preference as european.

12.2.30 (20-Jun-2018)

Fixed the issue of showing red colour for Valid Business Group List value column on the Transaction form.

12.2.29 (19-Jun-2018)

Fixed the issue of getting VBA Type mismatch error 13 while opening the Transaction form.

12.2.28 (18-Jun-2018)

Fixed the issue of getting SQL while login using the Wizard.
Implemented the new ribbon buttons "Query Log".

12.2.27 (07-Jun-2018)

Internal Update.

12.2.26 (24-May-2018)

Fixed the issue of getting VBA error while loading Transaction using ribbon option 'Upload all Transaction Using Selected Sheet'.

12.2.25 (23-May-2018)

Fixed issue of 'Item Date' not defaulting from Default Value row 10.

12.2.24 (23-May-2018)

Internal fix.

12.2.23 (18-May-2018)

Added profile option 'More4Apps: TW Batch Name Mandatory’ to restrict users from submitting the Transaction Interface Concurrent Program when the Batch Name value is empty on the worksheet.

12.2.22 (15-May-2018)

[Fusion/Cloud EBS] Added form validation for Expenditure item date with Project Start Date and Project Completion Date.
Fixed Attachment issue not defaulting from Default Value row 10.

12.2.21 (24-Apr-2018)

New column Expenditure Item ID added.

12.2.20 (13-Feb-2018)

Internal update.

12.2.19 (29-Dec-2017)

Cloud EBS - Refixed the issue of not allowing user to enter minus sign (-) on Transaction Raw Cost column.

12.2.18 (06-Dec-2017)

Fusion/Cloud EBS - Fixed the issue of not allowing user to enter negative Transaction Raw Cost using the form.

12.2.17 (05-Dec-2017)

Internal fixes.

12.2.16 (05-Dec-2017)

Internal fixes.

12.2.15 (01-Dec-2017)

Added new option 'Debug Mode' on the ribbon.

12.2.14 (01-Dec-2017)

Fixed the TW Ribbon tab disappearing after double clicking on row 10.

12.2.13 (01-Dec-2017)

Internal fixes.

12.2.12 (01-Dec-2017)

Fixed the issue of form opening on Default Row 10.
EBS Version - Added Example Sheet.

12.2.11 (28-Nov-2017)

Fixed the issue of not loading Attachments when refreshing from the sheet.

12.2.10 (27-Nov-2017)

Fixed the issue where refresh was not loading attachments properly. Now refresh will load the attachment for those transactions where status has been changed from Pending to Accepted.

12.2.09 (24-Nov-2017)

Fixed the issue where the color of Status column stays red when the validation was successful.

12.2.08 (24-Nov-2017)

Fixed the issue where only current selected line of attachment was uploaded when uploading all attachments.

12.2.07 (23-Nov-2017)

Fixed the issue when uploading attachment with selecting discontinuous rows, only first or last selected areas were uploaded.
Made the attachment 'Validate' status have the consistent format same as other status columns.
Fixed the issue where some words of the license information were hidden on the About form because of the improper size of the form.

12.2.06 (22-Nov-2017)

Fixed the issue of uploading Attachments from a different row.

12.2.05 (21-Nov-2017)

Fixed the issue of not displaying invalid date on the error message while validating transaction.

12.2.04 (17-Nov-2017)

Fusion - Fixed issue when getting the error message that user has been changed to another user when two user logins at the same time.

12.2.03 (16-Nov-2017)

Internal fixes.

12.2.02 (15-Nov-2017)

Internal fixes.

12.2.01 (15-Nov-2017)

Removed the error message of missing Expenditure ID for clicking 'Ok' button on the form.
Added showing the error message if required attachment columns are missing in the spreadsheet.

12.2.00 (09-Nov-2017)

Added Attachment functionality.

12.1.54 (03-Oct-2017)

Updated security.

12.1.53 (29-Sep-2017)

Fixed the issue of getting Application Defined error while uploading transaction and the Sheet is protected.

12.1.52 (13-Sep-2017)

Fixed the issue of getting SQL error while selecting GL code combination on the Transaction form.

12.1.51 (11-Sep-2017)

Fixed the issue of not defaulting the DFF Context on the form and the sheet.
Fusion - Fixed the issue of getting VBA error 1000 while opening the form and 'Employee' column is missing from the sheet.

12.1.50 (05-Sep-2017)

Internal fixes.

12.1.49 (25-Aug-2017)

Internal fixes.

12.1.48 (22-Aug-2017)

Internal fixes.

12.1.47 (11-Aug-2017)

Fixed the issue of getting VBA error 9 when logging into R11 using the Wizard.

12.1.46 (11-Aug-2017)

Fixed the issue of deleting parent transaction when row with transaction ID is selected.

12.1.45 (10-Aug-2017)

Added missing functionality to Delete Selected Transaction from Oracle.
Updated package version:
Current 4.1.3 09-Mar-16 4.1.6 07-AUG-2017 {Body}
Fixed the issue of rejecting non-cap/bill transactions on cap/bill tasks when Billable/Capitalized value is passed.

12.1.44 (09-Aug-2017)

Fixed the issue of allowing to load transactions into Oracle and they are 'Named User'.

12.1.43 (04-Aug-2017)

Updated Security.

12.1.42 (03-Aug-2017)

Updated Security.

12.1.41 (27-Jul-2017)

Fusion - Fixed the issue of not validating Expenditure Item Date with Task End Date.

12.1.40 (20-Jul-2017)

Updated security.

12.1.39 (20-Jul-2017)

Fixed the issue of not Validating Expenditure Item Date in 'Validate and Upload Only' mode.

12.1.38 (18-Jul-2017)

Updated Security.

12.1.37 (07-Jul-2017)

Updated Security.

12.1.36 (05-Jul-2017)

Updated Security.

12.1.35 (04-Jul-2017)

Updated Security.

12.1.34 (30-Jun-2017)

Updated Security.

12.1.33 (28-Jun-2017)

Updated Security.

12.1.32 (28-Jun-2017)

Updated Security.

12.1.31 (27-Jun-2017)

Fusion - Fixed the issue of not validating Transaction Raw Cost based on currency precision.
Added 4 columns PO_HEADER_ID, PO_LINE_NUM, PO_LINE_ID, PO_NUM into Wizard.

12.1.30 (22-Jun-2017)

Updated Security.

12.1.29 (19-Jun-2017)

Fixed the issue of Validate Only profile not working.

12.1.28 (06-Jun-2017)

Added validation for negative amount in an Accrual Expenditure batch.

12.1.27 (19-May-2017)

Fix for excel messages such as "Sorry, we couldn't find 'P:\e4awand_oracle.xll'. Is it possible it was moved, or renamed or deleted?". This error is caused by the Wizard custom callouts trying to call all open addins in the hope that More4apps custom functions exist.

12.1.26 (16-May-2017)

Fixed the issue of not validating Organization or Employee on the form if they are blank.

12.1.25 (12-May-2017)

Fixed the issue of not allowing user to correct values on the Transaction form.

12.1.24 (11-May-2017)

Fusion – Fixed the issue of not validating Raw Cost Credit Account Column/Raw Cost Debit Account column on the form if Costed Transaction or Accounted Transaction are populated.

12.1.23 (08-May-2017)

Fusion - Added validation for Costed Transaction.

12.1.22 (02-May-2017)

Fixed the issue of getting rejection error 'No Matching Item Found' in R12.2.26 if Transaction are loaded with quantity is equal to zero.

12.1.21 (02-May-2017)

Fusion - Fixed the issue of not validating Batch Name if it is more than 50 Characters while loading Transaction into Oracle.

12.1.20 (02-May-2017)

Updated Security.

12.1.19 (15-Mar-2017)

Reinstated custom callout functionality that was removed in version 11.2.01
Callout function name changed to M4A_Custom_Functions from Custom_Functions.
Customers will have to update their macros to M4A_Custom_Functions for this functionality to work.

12.1.18 (23-Feb-2017)

Fixed the issues where users are being logged in with the wrong language and not able to select a language from the EBS Browser Login page. Overrides the language selected on the Login Page to the user's EBS preferences default language. Caused by an EBS 12.2 framework patch.
Note – Loss of Functionality. This now means users cannot change languages if they want to.

12.1.17 (06-Mar-2017)

Fixed the issue of not loading attachments while doing refresh.

12.1.16 (16-Feb-2017)

Fixed the issue of not loading attachment with error status and if Expenditure ID exists on the sheet.

12.1.15 (15-Feb-2017)

Fixed the issue of loading attachment from the form after using refresh.

12.1.14 (15-Feb-2017)

Fixed the issue of Attachments not loading into Oracle when Expenditure Id exists in the Parent row.
Fixed the issue of Attachments not uploading when Expenditure Id exists in the Parent row.

12.1.13 (07-Feb-2017)

Fix the issue of getting vba error '9999' while using clear status column.

12.1.12 (02-Feb-2017)

Fix the issue of gridline appear on the status and message column while using clear status column.
Fix the issue of clearing the top status column when not selected using clear status column.
Updated Downloader Module version 1.0.71

12.1.11 (27-Jan-2017)

Fixed issue of not clearing status of child attachment rows.

12.1.10 (23-Jan-2017)

Fixed issue of bug introduced in version 12.1.09 loading attachments with no expenditure id.
Reset the cursor on B1 of setup sheet.

12.1.09 (23-Jan-2017)

Fixed issue of not loading all attachments while doing 'Refresh'.

12.1.08 (23-Jan-2017)

Fixed issue of getting error 1004 while loading attachments using upload selected.
Added missing "Clear Status Column" and "Delete Transactions" call to Right Click menu.
Reorder the right click menu of Transaction Wizard Setup.

12.1.07 (20-Jan-2017)

Template124 Sheet: Rename the section "Costed Source only" to Costed Information and "Accounted Sources Only" to "Accounted Information"
Fixed the logo on Setup Sheet.

12.1.06 (19-Jan-2017)

Fixed the issue of getting server error '1004' while doing refresh after import process.
Added missing Attachment calls to right click menu.

12.1.05 (19-Jan-2017)

Updated Security.

12.1.04 (19-Jan-2017)

Fixed the issue of loading attachments to unrelated to the transactions.
Added 'Expenditure Attachment' Form button call to ribbon toolbar.

12.1.03 (12-Jan-2017)

Fixed the issue of not writing Expenditure ID on the Sheet while doing refresh.
Fixed the issue of Attachments loading to different Expenditure ID.

12.1.02 (11-Jan-2017)

Fixed the issue of not validating 'Expenditure ID' if missing from the sheet and loading attachments using attachment forms.
Fixed the issue of not validating Organisation and Employee if they are missing from the sheet and not 'Usages' Expenditure Type Class.

12.1.01 (30-Dec-2016)

Fixed the issue of getting VBA error while uploading Transaction and Expenditure ID column was missing from the sheet.

12.1.00 (29-Dec-2016)

Added Clear Status column functionality.

12.0.27 (09-Jan-2017)

Changed browser settings to suppress JavaScript errors during login.

12.0.26.7 (09-Mar-2017)

Fixed issue where users are being logged in with the wrong language.
Further Information: In EBS 12.2 a framework patch has stopped us from being able to select a language in the browser login page.
To work around this problem the language for the user is now being set from user's EBS preferences irrespective of what is chosen on the Browser Login page.

12.0.26 (23-Dec-2016)

Updated Security.

12.0.25 (23-Dec-2016)

Updated Security.

12.0.24 (21-Dec-2016)

Fixed the issue of not submitting correct concurrent request in R11.

12.0.23 (19-Dec-2016)

Fixed the issue of getting error 'Could not set the Column Property.Invalid property array index.' while searching alias.

12.0.22 (16-Dec-2016)

Added project privilege (PJB_MANAGE_PROJECT_BILLING_EVENT_DATA) to be passed to the servlet to initialise the session correctly for Fusion.

12.0.21 (15-Dec-2016)

Fixed the issue of 'OK' and 'Cancel' button not enabled while opening form on the Default Row 10 for Fusion.

12.0.20 (15-Dec-2016)

Fixed the issue of getting '…………. template124' as a Batch Name while creating New Sheet for Fusion.
Fixed the issue of writing and error when Quantity column is empty on the sheet.
Fixed the issue of getting SQL error while search Employee and opening the form.

12.0.19 (14-Dec-2016)

Fixed the issue of not validating invalid Organization on the Transaction Wizard Fusion form.
Fixed the issue of not opening DFF form and getting message to create a New Sheet2 for Fusion using call from ribbon toolbar.
Fixed the issue of not opening Transaction Details form in Fusion and getting VBA Error.

12.0.18 (12-Nov-2016)

Fixed the issue of not allowing user to enter Item Date or left while submitting Import and Cost Transactions form for Fusion.

12.0.17 (09-Dec-2016)

Fixed the issue of getting error invalid use of Null while loading the form for Fusion.
Fixed the issue of not populating the GL Date from the sheet.

12.0.16 (25-Nov-2016)

Fixed the issue of getting 'The specified Employee is not valid' error.

12.0.15 (16-Nov-2016)

Implemented new Setup sheet design.

12.0.14 (07-Nov-2016)

Fixed the issue of getting Error while entering Raw Cost Credit Account and Raw Cost Debit Account on the form for Fusion.

12.0.13 (31-Oct-2016)

Implemented new column names for Fusion.

12.0.12 (13-Oct-2016)

Updated Security.

12.0.11 (12-Oct-2016)

Fixed the issue of getting type mismatch error while entering GL Date in the form for Fusion.
Filtered the Document Column on the Control Transactions Batches Form.

11.1.10.1 (27-Jun-2016)

Fixed the issue of getting User Defined Error while loading Transactions.
When running in 'trial mode' (no licence key or expired licence key) and trial limit is exceeded the 'XML Parse Error' form is displayed.
Updated Security.

11.1.10 (05-Apr-2016)

Fix to XML data loader to handle European NLS format.

11.1.09 (31-Mar-2016)

Minor internal change for identifying the Operating Unit.

11.1.08 (09-Mar-2016)

Bug fix

11.1.07 (02-Mar-2016)

Updated Security

11.1.06 (24-Feb-2016)

Fix for minor form bug showing Expenditure Organisation appearing to be invalid

11.1.05 (22-Dec-2015)

Updated Security

11.1.04 (03-Dec-2015)

Fix for fault in sheet pointer in multi-sheet Refresh. Would only refresh two sheets then loop continuously

11.1.03 (16-Nov-2015)

Increased performance of Upload

11.1.02 (22-Oct-2015)

Updated Get CCID issue for key flexfields

11.1.01 (19-Oct-2015)

Changed upload to use XMLTable and recordType rather than dynamic SQL.
Requires package header version 4.1.2 or later.
Requires package body version 4.1.2 or later.
Updated upload_all_transactions package version check to 4.1.2

11.1.00 (07-Oct-2015)

Validate only mode now uploads records temporarily to server for PA validation and Extension call.
Requires package body version 4.1.0 or later.

11.0.13 (10-Sep-2015)

Change to Tasks object to support CBS introduced in 12.2

11.0.12 (16-Apr-2015)

Added hooks for 'Custom Functions' macro functionality

11.0.11 (17-Feb-2015)

Removed use of m4aps_xml.resp_allowed. Added test for HR_CROSS_BUSINESS_GROUP profile option to accommodate Exp Orgs assigned to multiple Business Groups.
Require Business Group where Organisations belong to more than one Business Group.

11.0.10 (18-Dec-2014)

Fixed login issue after session times out

11.0.09 (26-Nov-2014)

Fix for confusing error messages when Resource and Resource Org columns are missing for Usage transactions

11.0.08 (20-Nov-2014)

Fixed issue where screen would go blank during Upload

11.0.07 (27-Aug-2014)

Changes to allow focus to be shifted to another workbook without affecting the upload.
Person Type needs to be added to the form.

11.0.06 (15-Jul-2014)

EBS 12.2 Fix for SQL errors caused by table based validation sets

11.0.05 (05-Jun-2014)

Fixed minor form error when loading Batch Control form
Fix for Invalid date in Transaction form being overwritten on form load

11.0.04 (08-Apr-2014)

Fix for Wk Ending Date not re-initializing on upload when cell cleared

11.0.03 (27-Feb-2014)

Added profile option ‘More4Apps: TW Open GL Periods Only’
Fix for Expenditure Type Class being cleared on form load
Fix for Item date validation not respecting Profile Option controls to restrict to Open GL/PA periods

11.0.02 (03-Dec-2013)

Batch list was not sorted. Now alphabetically sorted. Changed to allow type-ahead to help find batch name
Batch Name field colour is now light red when typed into until the field is tabbed away from

11.0.01 (30-Oct-2013)

Fix for Employee column clearing when loading the form on a Timesheet record

11.0.00 (09-Jul-2013)

Supports Award transactions for the Grants module. Requires package body version 4.0.2

10.2.11 (12-Apr-2013)

Internal mode only. Removed all the h_ variables for consistency reasons. These are redundant now we are using row 10 for what used to be considered header values

10.2.10 (14-Mar-2013)

Updated findRibbonAccessibility module from core code for customer (Bug in Ribbon code when running 64bit versions of Office)

10.2.09 (24-Jan-2013)

Reinstated the Employee Identification Preference drop down as per customer

10.2.07 (08-Jan-2013)

Fix for error when uploading or validating and ‘Project Name’ column has been removed
Fix for bug in Refresh process introduced in 10.2.02

10.2.06 (17-Dec-2012)

Added Person Type

10.2.05 (11-Dec-2012)

Removed handler for compiled_value_attributes flexfield used in table valued value sets as method needs revisiting

10.2.04 (03-Dec-2012)

Generic code updated to 202.9

10.2.03 (29-Nov-2012)

Dialog box was not popping when errors during uploads in Validate Only mode

10.2.02 (20-Nov-2012)

CASE 3906:max(1)(instead of just 1) added to stop ORA-01422: exact fetch returns more than requested number of rows

10.2.01 (19-Nov-2012)

Row 9 check added prior to opening form

10.2.00 (29-Oct-2012)

Added extension package M4APS_TW_EXTENSION.  Can be customised by site to include additional validation or processing

10.1.00 (31-Aug-2012)

Ribbon menu implemented and Generic code updated to version 202

10.0.11 (10-May-2012)

Fixed SQL error on login introduced in 10.0.10

10.0.10 (01-May-2012)

Fixed duplicated TW Setup toolbar on right-click menu

10.0.09 (12-Apr-2012)

Updated to allow for Excel 2010 64 bit version

10.0.08 (29-Feb-2012)

Instance shown on status bar and forms. fix color bug in URL setup and Help forms
Docked toolbars now show title in Excel 2007 and Excel 2010

10.0.07 (20-Jul-2011)

Added ‘Refresh’ button to Batch Control form
Fix Batch Source error occurring when Refreshing Transaction Status

10.0.06 (07-Jul-2011)

Stop ‘Validate only’ mode from re-validating imported Transactions

10.0.05 (20-Jun-2011)

Fix for data entry forms not being centered when using multiple monitors

10.0.04 (06-May-2011)

Updated to connection modules for non-ascii character problem

10.0.03 (28-Apr-2011)

Invalid Type message when using read-only responsibility

10.0.02 (12-Apr-2011)

Fixed Subscript out of Range message in recent DFF module changes

10.0.01 (08-Apr-2011)

Choosing Cancel during upload did not stop the upload

10.0.00 (30-Mar-2011)

Further rationalised Post Login procedures resulting in significant reduction in login time
Added information-only column ‘Project Description’
Fix for unexpected break in feedback values in ‘Validate only’ process
Fix for new high-speed upload and validisation processes introduced in 8.0.00 not retrieving optional information column values. Requires package body ’3.2.2 28-Mar-11′

9.0.07 (21-Feb-2011)

Prevent Refresh from failing with fetch error when Transaction is an accrual and so automatically duplicated/reversed in the next period

9.0.06 (11-Feb-2011)

Prevent purged Interface IDs from being cleared for (Customer)

9.0.05 (27-Jan-2011)

Profile option to block use of multi-sheet option was being read incorrectly

9.0.04 (26-Jan-2011)

Bug fix in Refresh procedure in 9.0.03

9.0.03 (19-Jan-2011)

Further performance improvements to Delete Batch, Refresh, and Upload processes. Bug fix for new 9.0.00 Project and Task error messaging
Made Status language specific for Accepted, Pending, and Rejected Statuses

9.0.02 (10-Dec-2010)

Significant performance improvement to Delete Batch process especially visible on very large batches

9.0.01 (30-Dec-2010)

Large performance improvement to Refresh process
Mod to 9.0.00 for incorrect validation message format
Fix to Delete batch control customisation for (customer)
Widened Batch Control form to show Batch Source in Batch LOV

9.0.00 (24-Dec-2010)

Moved validation of Project and Task to server from client. Cuts validation/upload times by 2/3

8.0.01 (03-Dec-2010)

Switch Transaction form focus to last tab when Batch/Transaction Source required
Fix for subscript errors in certain circumstances when columns are hidden

8.0.00 (04-Oct-2010)

Rewrite of upload to improve performance and reduce load on the SGA
This version MUST be accompanied by an upgrade to the Transaction Wizard database package

7.2.06 (02-Sep-2010)

Fix to R12 Orgs form. Was supposed to prevent selection of the current Org. This was not working

7.2.05 (02-Sep-2010)

Protection password form added. Administrators can choose any password for Worksheet Protection

7.2.04 (13-Apr-2010)

Protection message added for Excel 2000 users
Fix for ‘Batch Source ‘ is invalid’ message during Refresh

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

7.2.02 (29-Jan-2010)

Form and calendar positioning enhancements. Scroll bar 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

7.2.01 (18-Jan-2010)

Prevent non-open PA periods from passing validation for (customer)

7.2.00 (11-Jan-2010)

Upgrade connection to handle non-ascii characters in R12
Fixed problem in transaction multi-select for upload

7.1.03 (22-Dec-2009)

Performance mod for Excel 2007 – removes conditional formatting in range to be uploaded prior to upload

7.1.02 (17-Dec-2009)

Support added for :SYSTEM.CURRENT_FORM form block field

7.1.01 (15-Dec-2009)

Error messages changed to show column letter rather than column number

7.1.00 (19-Nov-2009)

Licence model altered to prevent use of the tool for non-named users except for About form functions

7.0.03 (06-Nov-2009)

Make Line Comment column mandatory for (customer)

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

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

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

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

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 work around for Excel 2007 size increase bug

6.1.16 (07-Aug-2009)

Security fix. Form was allowing Upload/Delete without checking function security. Also Batch form was allowing Delete without checking function security

6.1.15 (04-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

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

6.1.13 (19-May-2009)

Turn off “Upload Only” mode for (customer)

6.1.12 (01-May-2009)

Fix for failure in load for employee based transactions

6.1.11 (24-Apr-2009)

Optimisations added to counter large performance degradation in Excel 2007

6.1.10 (31-Mar-2009)

Changes to customisations for (Customer)
Fix for main form not allowing a close on row 10

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

6.1.08 (17-Mar-2009)

Reset mouse pointer on form load
Prevent error from occurring on Event form load after row 100

6.1.07 (27-Feb-2009)

Significant performance upgrade when checking charge controls in Validate mode. Requires package body 1.0.16

6.1.06 (30-Jan-2009)

Upgraded standard connection modules

6.1.05 (24-Dec-2008)

Fixed bug in validation stopping process when Vendor Number column removed

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

6.1.03 (01-Oct-2008)

Alter Accrual Flag defaulting rule for (customer)

6.1.02 (11-Sep-2008)

Correct inefficient DFF segment validation on upload
Internal improvements to DFF module and form

6.1.01 (04-Sep-2008)

Stop Refresh function from operating on already refreshed transactions

6.1.00 (28-Aug-2008)

Upgrade to About form to accommodate new Activation Key

6.0.13 (20-Aug-2008)

In certain circumstances the tool was loading Project Name and not Project Number

6.0.12 (07-Aug-2008)

Improvements to Named User maintenance form
Changed names of Login options. SSO method is now Standard

6.0.11 (01-Aug-2008)

Minor form improvements to changing Transaction Source and Expenditure Type Class

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

6.0.9 (01-Jul-2008)

Start Item Date LOV at current date when no Week Ending Date to save user effort

6.0.8 (25-Jun-2008)

Add Description to LOV for Independent Value Sets in DFF segments

6.0.7 (22-Jun-2008)

Added Expenditure Type Search for customer

6.0.6 (18-Jun-2008)

Stop Refresh from stopping prematurely at 512 rows in certain circumstances

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

6.0.4 (11-Jun-2008)

Fix to wrong proc name used for R12 call

6.0.3 (09-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

6.0.2 (03-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

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

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

5.1.7 (29-Apr-2008)

Minor change to procedure handling apostrophes and non-ascii characters

5.1.6 (24-Apr-2008)

Added “List My Batches Only” checkbox to Batch Header form

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

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

5.1.3 (12-Mar-2008)

Updated XML module and About form

5.1.2 (10-Mar-2008)

Program was not requiring an Employee or Organization for Miscellaneous Transactions

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

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

5.0.9 (08-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

5.0.8 (03-Oct-2007)

Employee validation was not stopping the upload for certain error conditions
Retry added to SQL and Procedure calls

5.0.7 (28-Sep-2007)

Employee search was not adding employees to the list unless Employee AND Org changed

5.0.6 (27-Sep-2007)

Client customisation – wants only open periods to appear in Expenditure Ending Date LOV

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

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

5.0.3 (31-Jul-2007)

Fix for minor bug on Accounted Details tab on Transactions form

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

5.0.1 (08-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

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

4.3.1 (27-Mar-2007)

Fix for non-ASCII characters in new performance technique. Requires M4APS_XML package body 3.0.08

4.3.0 (19-Mar-2007)

Fix for timeout problem caused by Internet Explorer 7

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

4.2.07 (12-Mar-2007)

Fix spelling mistake in bind variable feature in Refresh function

4.2.06 (27-Feb-2007)

Employ bind variables to improve SQL performance for multiple validation calls

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

4.2.04 (28-Dec-2006)

10g database was not being detected properly for non-ASCII character handling
Cosmetic improvements to About form

4.2.03 (07-Dec-2006)

Client specific customisation

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

4.2.01 (18-Oct-2006)

Fix for issue with apostrophes in Validate Mode

4.2.00 (16-Oct-2006)

Modified Install to work on Oracle on Demand instances<

4.1.13 (05-Sep-2006)

Was loading Business Group even when no Employee selected. 4.1.04 fix was lost

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

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

4.1.10 (31-Mar-2006)

Changed “Currency” on transaction details form to “Amount”

4.1.09 (16-Feb-2006)

Allow transactions to be loaded in Future PA Periods

4.1.08 (12-Jan-2006)

Logout was not clearing Joint Login values

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

4.1.06 (15-Oct-2005)

Manually entered Batch Name was not being loaded

4.1.05 (06-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

4.1.04 (18-Aug-2005)

Restrict Batch name to 10 characters to comply with length constraint prior to 11.5.9
Stopped business group from being loaded if no employee selected

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

4.1.02 (09-Aug-2005)

Change display of Batch Header form’s batches
New naming conversion for Batches based on UserName + Transaction Source + Sheet Name

4.1.01 (06-Aug-2005)

Fix for minor Form error if Organisation column removed
Support Session ID login validation method

4.1.00 (05-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

4.0.19 (02-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

4.0.18 (27-Jul-2005)

Stop repeated DFF configuration caching when no columns defined

4.0.17 (25-Jun-2005)

Remove Digital Certificate
Added Release Notes link to About form

4.0.16 (22-Jun-2005)

Fix DFF reference field issue

4.0.15 (14-Jun-2005)

Fix bug in frmDFF using A_ValueSet instead of rsFlex array

4.0.14 (02-Jun-2005)

Fix for Ascii characters mixed with Unicode values

4.0.13 (30-May-2005)

Updates to DFF module
Unicode workaround is unavailable for databases prior to 8i

4.0.12 (26-May-2005)

Changes to cope with Unicode characters. Requires XML package body 2.0.45

4.0.11 (09-Apr-2005)

Bug Fix in DFF module

4.0.10 (02-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

4.0.09 (18-Apr-2005)

Sys Link Function Parameter added to validate transaction procedure call

4.0.08 (13-Apr-2005)

DFF Performance Enhancements and add ID column

4.0.07 (31-Mar-2005)

Fix for problem retaining Digital certificate
Login configuration hidden if Setup Toolbar not shown

4.0.06 (15-Mar-2005)

DFF module was not making use of defaults

4.0.05 (14-Mar-2005)

Minor improvement to Employee behavior on both forms

4.0.04 (06-Mar-2005)

Fix for European decimal character not being handled properly

4.0.03 (23-Feb-2005)

Performance improvement to DFF form
Remove Function to Check for non-Ascii characters

4.0.02 (21-Feb-2005)

Fix display context logic

4.0.01 (17-Feb-2005)

Remove Replace97 call for chr(0), Don’t display error when context col missing

4.0.00 (09-Feb-2005)

New DFF module added

3.0.10 (05-Feb-2005)

Performance enhancements plus new Permanently Hide option for Setup toolbar

3.0.09 (30-Nov-2004)

Bug fix for Excel error if Organization column in Override section removed

3.0.08 (24-Nov-2004)

Bug fix for person_id column used for validation (which is empty) instead of created_by

3.0.07 (05-Oct-2004)

Further fix for employee number validation – 3.0.06 users please upgrade to this 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

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

3.0.04 (13-Aug-2004)

Removed Bug in Task validation where no Task or Project end date

3.0.03 (04-Aug-2004)

Made Expenditure Types LOV more efficient and added override for System Linkage
Add Function to Check for non-Ascii characters
Check for duplicated column headings added

3.0.02 (21-Jun-2004)

Switched to different IE API to better handle UTF8 character set

3.0.01 (03-Jun-2004)

Login script change to allow for port numbers larger than integer size limit

3.0.00 (31-May-2004)

Converted to Web/XML connection technology

2.0.17 (03-May-2004)

Accrual Flag was not being adequately validated

2.0.16 (23-Mar-2004)

Improvements to Business Group handling

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<

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

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

2.0.12 (04-Dec-2003)

One more Integer to Long change to cope with capacity problem

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

2.0.10 (21-Nov-2003)

Changed Integers to Longs to cope with capacity problem

2.0.09 (19-Nov-2003)

Enhance About form and password expiry feature
Respect end-dates of Responsibility and Responsibility Assignment

2.0.08 (04-Nov-2003)

Test added for database user’s password expiry

2.0.07 (22-Oct-2003)

Cosmetic form and date format changes. Added sample sheets

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

2.0.05 (02-Sep-2003)

Stopped re-validating already validated transactions when bulk uploading

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

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

2.0.02 (18-Aug-2003)

Modified Refresh function to include Expenditures imported then purged from the interface

2.0.01 (02-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

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

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

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

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

1.3.05 (28-Apr-2003)

Bug Fix – To resolve date conversion error for foreign languages

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

1.3.03 (10-Apr-2003)

New toolbar option to logout

1.3.02 (24-Mar-2003)

Bug Fix – To return the CCID and not the actual Concatenated Segments for Code Combination columns

1.3.01 (01-Mar-2003)

Code moved to DLL. Release moved to 1.3