7.5.96 (03-Sep-2025)

Resolved an issue introduced in Microsoft Office update version 2508 that caused a ‘Microsoft Visual C++ Runtime Library - Assertion Failed’ error.

7.5.95 (18-Aug-2025)

Fixed Prevalidate Accounts erroring in 11i

7.5.94 (15-Apr-2025)

Added Default Browser Login option.
Enhanced the Wizard - It will now function using the right-click-menu, without the More4apps ribbon tabs.

7.5.93 (17-Oct-2024)

Internal update.

7.5.92 (16-Oct-2024)

Added Default Browser Login option.

7.5.91 (28-Aug-2024)

Fixed validation issues when using both profile options: "More4Apps: GLW Allow positive values only" and "More4Apps: GLW Allow upload and import of 0 value journal lines".

7.5.90 (08-Aug-2024)

Fixed R11 downloads access.

7.5.89 (07-Jun-2024)

Fixed Account Pre validation using '-' as delimiter.

7.5.88 (05-Dec-2023)

Reverted some code when Wizard is run on a 10g database to prevent login issues.

7.5.87 (28-Nov-2023)

Budget Journals and Encumbrances modes: Removed previously added download only column 'Document Sequence'.

7.5.86 (23-Nov-2023)

Actuals, Budget Journals, Encumbrances modes: Added download only column 'Document Sequence'.

7.5.85 (01-Nov-2023)

Fix for bug where the End-to-End Trace might not return the SQL Statement's execution plan.

7.5.84 (12-Oct-2023)

Added 'More4Apps: GLW Allow upload and import of 0 value journal lines' profile option to allow zero journal lines through.

7.5.83 (29-Sep-2023)

Added 'More4Apps: GLW Enforce Pre-Validation of Accounts' profile option for enforcing Pre-Validation of Accounts when set.

7.5.82 (21-Sep-2023)

Removed caching mechanisms from Line Account validation to improve performance.

7.5.81 (04-Sep-2023)

Internal update.

7.5.80 (18-Aug-2023)

Fixed Budget Amounts Account Name column being assigned to the wrong segment.

7.5.79 (08-Aug-2023)

Fixed error when logging in as French.

7.5.78 (28-Jul-2023)

Extended all forms slightly to make space for two line errors on the status bar.

7.5.77 (07-Jul-2023)

Now only shows Form Reference popup when logging is enabled.

7.5.76 (03-Jul-2023)

Fixed Cross section form reference dependency providing inconsistent validation results.

7.5.75 (23-Jun-2023)

Added Form Reference for Category - HEADER.USER_JE_CATEGORY_NAME, for all associated modes.

7.5.74 (22-Jun-2023)

Fixed LOV never responding issue.

7.5.73 (20-Jun-2023)

Fixed error in SQL for Category Name.

7.5.72 (19-Jun-2023)

Added search control for Category Name column.

7.5.71 (29-May-2023)

Internal update.

7.5.70 (24-May-2023)

Internal update.

7.5.69 (12-May-2023)

Internal update.

7.5.68 (12-May-2023)

Internal update.

7.5.67 (12-May-2023)

Internal update.

7.5.66 (12-May-2023)

Internal update.

7.5.65 (11-Apr-2023)

Internal update.

7.5.64 (06-Mar-2023)

Pre-Validate Accounts set to 'No' now no longer validates Code Combination ID and strictly uploads each account segment. Pre-Validate Accounts set to 'Yes' processes via Code Combination ID.

7.5.63 (01-Feb-2023)

Added 'More4Apps: GLW Create new Group ID per upload' profile option for creating new Group IDs per upload.

7.5.62 (19-Jan-2023)

Setup sheet updates.

7.5.61 (19-Jan-2023)

Fixed an issue that caused large uploads to unexpectedly fail with error.

7.5.60 (12-Dec-2022)

Functional name of GL account segments are now displayed on the forms.
Added 'Sheet filter Batch size' button to the Download ribbon gallery.

7.5.59 (28-Oct-2022)

Internal update.

7.5.58 (03-Oct-2022)

Removed uploading Set of Books ID for R12.

7.5.57 (15-Jul-2022)

Internal update.

7.5.56 (14-Jul-2022)

Fixed bug with Currency Validation in R11 setups.

7.5.55 (13-Jul-2022)

Fixed bug on login associated with 10g databases.

7.5.54 (08-Jul-2022)

Fixed bug in forms where searchable lists were not returning data when searching. This bug introduced in version 7.5.50

7.5.53 (07-Jul-2022)

Fixed Long list LOVs not returning results.

7.5.52 (30-Jun-2022)

Fixed error when validating Currency with invalid Ledger Name.

7.5.51 (28-Jun-2022)

Corrected Currency Valuation based on Ledger Base Currency.

7.5.50 (27-Jun-2022)

Updated profile display names (More4Apps: GLW Allow positive values only, More4apps: GLW Restrict combined Dr/Cr lines).

7.5.49 (13-Jun-2022)

Fixed Period From and To LOV error on template creation for Budget.

7.5.48 (27-May-2022)

Fixed bug where Tax Context value was not being uploaded.

7.5.47 (11-May-2022)

Bug fixes around saving workbooks stored in One Drive.

7.5.46 (09-May-2022)

Fixed Account validation bug which could upload the account segments in the incorrect order.

7.5.45 (09-Feb-2022)

Custom Query updates.

7.5.44 (27-Jan-2022)

Internal update.

7.5.43 (24-Jan-2022)

Added 'More4Apps: GLW Journal Source' profile option for restricting the Source list of values.

7.5.42 (21-Jan-2022)

Fixed bug where valid Category filter parameters was not download correctly on R12.

7.5.41 (21-Jan-2022)

Added Category as download filter across Download form and Download By Sheet.

7.5.40 (11-Jan-2022)

Internal update.

7.5.39 (29-Dec-2021)

Fixed download issue with Conversion Type returning the wrong value type.

7.5.38 (24-Dec-2021)

Currency Conversion columns now correctly derives the base currency from the Ledger Name.

7.5.37 (06-Dec-2021)

Minor supertip labeling adjustments.

7.5.36 (03-Dec-2021)

Multilingual messaging adjustments.

7.5.35 (03-Dec-2021)

Updated Download By Sheet supertip label with complete list of columns available to be downloaded by.

7.5.34 (30-Nov-2021)

Added Period as a download selected filter criteria.

7.5.33 (19-Oct-2021)

Example Sheet - Data Adjustments.

7.5.32 (19-Oct-2021)

Column heading comment adjustments for consistency and clarity.

7.5.31 (19-Aug-2021)

Fixed issue on Refresh with incorrect error messaging under certain error status conditions.
Multiple error messages will now correctly return if a Ledger contains multiple error status on Refresh.

7.5.30 (28-Jul-2021)

Updated security.

7.5.29 (06-Jul-2021)

Fixed bug where Source could cause errors on Automatic Import.

7.5.28 (29-Jun-2021)

Automatic import now correctly creates submit import request across all unique sheet data combinations of Ledger Name, Group ID and Source.

7.5.27 (14-Jun-2021)

Fixed messaging bug on mandatory DFF columns.

7.5.26 (09-Jun-2021)

Fixed bug with LOV searching not returning data results to the form controls.

7.5.25 (08-Jun-2021)

Internal bug fixes.

7.5.24 (28-May-2021)

Fixed bugs around when Budget Row ID was removed from the sheet.

7.5.23 (26-May-2021)

Fixed Required validation message against status columns.

7.5.22 (20-May-2021)

Fixed incomplete error message when mandatory columns have been removed from the sheet.

7.5.21 (17-May-2021)

Mad all Status Column columns mandatory. Made Journal Name Mandatory.

7.5.20 (07-May-2021)

Ribbon and supertip adjustments.

7.5.19 (06-May-2021)

Ribbon and supertip adjustments.

7.5.18 (06-May-2021)

Fixed the issue of wrong supertips shown for all three help buttons and wrong label for query log.

7.5.17 (06-May-2021)

Updated ribbon labels and supertips.

7.5.16 (03-May-2021)

Setup sheet modifications.

7.5.15 (13-Apr-0021)

Minor bug fixes.

7.5.14 (12-Apr-2021)

Updated security.

7.5.13 (12-Apr-2021)

Changed Pre-Validate Accounts default selection to be 'No'.

7.5.12 (25-Jan-2021)

Updated Setup Sheet details.

7.5.11 (25-May-2020)

Fixed upload error when Control Total control was removed from the sheet.

7.5.10 (14-May-2020)

Messaging changes around Format Sheet functionality.

7.5.09 (11-May-2020)

Column adjustments regarding columns placed inside incorrect modes.

7.5.08 (11-May-2020)

Example sheet fixes.

7.5.07 (05-May-2020)

Bug fixes.

7.5.06 (02-Mar-2020)

Updated security.

7.5.05 (27-Feb-2020)

Fixed minor formatting issues with new format style.

7.5.04 (20-Feb-2020)

Updated colors for new branding format.

7.5.03 (12-Dec-2019)

Fixed Profile Options being ignored for DFF Substitutions.

7.5.02 (10-Dec-2019)

Updated security.

7.5.01 (11-Nov-2019)

Fixed Download via sheet downloading using unselected sheet data.

7.5.00 (15-Oct-2019)

Firewall compliant encoding added.

7.4.16 (14-Oct-2019)

Updated security.

7.4.15 (10-Oct-2019)

Fixed Download form Clear button not clearing form data.
Removed search controls from Period controls on Budget Amounts Download form.

7.4.14 (10-Oct-2019)

Fixed issue when downloading Budget Amounts via Download form.

7.4.13 (09-Oct-2019)

Fixed error during upload when Automatic Import is chosen.

7.4.12 (26-Sep-2019)

Fixed Control Total Causing error despite being invalid.
Fixed Upload not progressing.

7.4.11 (23-Sep-2019)

Added basic validation to Control Total column.
Fixed Upload ignoring Control Total if 0 and disabling all uploads if one failed.

7.4.10 (17-Sep-2019)

Corrected Unit of measure defaulting.
Fixed Processing form writing "Creating transaction(s) in Oracle” and “Uploading In Progress..." messages during validation.

7.4.09 (16-Sep-2019)

Fixed error in Download form when using Line Number filter.

7.4.08 (11-Sep-2019)

Fixed Stat Quantity SQL error when attempting to upload text.

7.4.07 (03-Sep-2019)

Corrected Setup sheet error.

7.4.06 (02-Sep-2019)

Fixed error when Uploading with invalid amounts.

7.4.05 (30-Aug-2019)

Fixed account rules being ignored for existing accounts.

7.4.04 (21-Aug-2019)

Fixed rounding issue with decimal amounts.

7.4.03 (30-Jul-2019)

Fixed Credit/Debit amounts not being uploaded.

7.4.02 (25-Jul-2019)

Security updated.

7.4.01 (18-Jul-2019)

Fixed performance issue when loading bulk data.

7.4.00 (27-Jun-2019)

Fixed the issue of getting SQL error while downloading Budget Amounts using the Wizard.

7.3.02 (19-Jun-2019)

Fixed the issue of getting SQL error while downloading Actuals and using the download form.

7.3.01 (08-Apr-2019)

Fixed the issue of getting SQL error 1001 while downloading General Ledgers using the Wizard.

7.3.00 (01-Apr-2019)

Implemented new colour scheme and Setup sheet.

7.2.42 (05-Mar-2019)

Fixed the issue of user to force to select the mode after login.

7.2.41 (27-Feb-2019)

Fixed the issue of getting VBA error 91 while uploading Attachments.

7.2.40 (25-Jan-2019)

Fixed the issue of getting VBA error 'Error 6 (Overflow)' while uploading and validating bulk journals.

7.2.39 (09-Nov-2018)

Internal update.

7.2.38 (07-Nov-2018)

Fixed the issue of showing call Header Attachments form on ribbon in Budget Amount mode.

7.2.37 (30-Oct-2018)

Re added missing profile check to Exclude Download Menu function check.

7.2.36 (25-Oct-2018)

Added Profile Options:
- More4Apps: GLW Disable functional security preventing downloads (to exclude function check for Download)
- More4Apps: GLW Disable functional security preventing uploads (to exclude function check for Upload)

7.2.35 (24-Oct-2018)

Internal updates.

7.2.34 (23-Oct-2018)

Added Download Function Security.
Removed cell comment 'Mandatory' from Line Number Column from all modes.

7.2.33 (04-Oct-2018)

Fixed the issue of Wizard crashing while opening the Wizard in Excel 2007 version.

7.2.32 (14-Sep-2018)

Fixed the issue of Not Allowing account combination when Pre-Validate Account is set to yes in Budget Journal Mode.

7.2.31 (10-Sep-2018)

Internal updates.

7.2.30 (05-Sep-2018)

Fixed the issue of getting Error message when concurrent program is still running.
Fixed the issue of getting SQL error ORA-01400: cannot insert NULL into ("GL"."GL_BUDGET_INTERFACE"."FISCAL_YEAR") using the old template with Blank Period Year on the template.

7.2.29 (03-Sep-2018)

Fixed the issue getting SQL Error ORA-01400: cannot insert NULL into ("GL"."GL_BUDGET_INTERFACE"."FISCAL_YEAR") when Period Year was blank on the template.

7.2.28 (30-Aug-2018)

Fixed the issue of not allowing Account Combination when Pre-Validate Accounts = Yes'.

7.2.27 (30-Aug-2018)

Fixed the issue of not submitting Automatic Import Journal when Submit Import Journal is Automatic.

7.2.26 (15-Aug-2018)

Fixed the issue of Currency Code list of values not populating while opening the form in Budget Amounts.

7.2.25 (01-Aug-2018)

Updated security and removed requirement for database packages.

7.2.24 (01-Aug-2018)

Fixed the issue of getting VBA 'Error 5 (Invalid procedure call or argument)’ while uploading data using template created with non-mandatory section.

7.2.23 (31-Jul-2018)

Fixed issue of getting Type Mismatch error on the Download form.

7.2.22 (30-Jul-2018)

Fixed issue of getting Type Mismatch error while uploading Actuals Journals and passing invalid date.

7.2.21 (27-Jul-2018)

Corrected the message wording while selecting Download via Sheet and putting cursor above row 10.

7.2.20 (19-Jul-2018)

Fixed issue writing Request ID on the sheet for unprocessed Budget Amounts.
Fixed issue of getting invalid Row ID error while using refresh in Budget Amounts with invalid Row ID on the sheet.

7.2.19 (09-Jul-2018)

Fixed issue of not finding any Code Combinations in Budget Journals mode.

7.2.18 (09-Jul-2018)

Fixed issue of Getting Server error while using Currency Column in download form in Budget Journals mode.

7.2.17 (05-Jul-2018)

Fixed issue of order of Periods List of Values in Actuals, Encumbrance and Budget Journals.

7.2.16 (04-Jul-2018)

Fixed issue of getting server error while using accounts in Budget Journal mode.

7.2.15 (03-Jul-2018)

Fixed issue of getting timeout error while searching Combination Segments in Budget Journals mode.

7.2.14 (02-Jul-2018)

Fixed issue of getting server error while searching Reverse Period in Encumbrance mode.

7.2.13 (02-Jul-2018)

Fixed issue of not requesting Budget Organization Password for second upload.

7.2.12 (26-Jun-2018)

Fixed issue of getting server error while selecting reverse period in Actuals mode.
Fixed the order of periods in Encumbrance mode.

7.2.11 (19-Jun-2018)

Fixed issue of not handling Budget Organization Incorrect Password Entry.

7.2.10 (18-Jun-2018)

Fixed issue of getting VBA error 13 (Type mismatch) while entering Currency details in Actuals mode.

7.2.09 (15-Jun-2018)

Fixed issue of getting server while searching combination segments in Budgets Journal mode.

7.2.08 (15-Jun-2018)

Corrected the message wording of Show Total Amount for Budget Amounts.
Fixed issue of getting server while creating template in Budget Amounts and not passing the Period Year.
Fixed issue of Excel crashing while deleting Amounts from interface in Budget Amount modes.
Fixed issue of getting SQL Server while loading Journal in Budget Journals mode.

7.2.07 (08-Jun-2018)

Fixed issue of getting SQL Server Error 'Invalid Number' while doing bulk upload in Budget Amounts mode.

7.2.06 (08-Jun-2018)

Added Example Sheet for Budget Amounts mode.

7.2.05 (30-May-2018)

Re-corrected the validation message wording for Password protected Budget Organization in R11.

7.2.04 (29-May-2018)

Corrected the Validation Message wording for Password protected Budget Organization in R11.
Removed the 'ALL' Budget Organization from R11 Budget Amounts R11i Form.

7.2.03 (28-May-2018)

Fixed issue of not writing repeated Request ID on sheet column 'Request ID'.

7.2.02 (25-May-2018)

Fixed issue of getting VBA Error 402 while using Refresh Interface Status.
Fixed issue of getting error message "There is a control total violation for this journal" while loading Actuals journal with control total amount.

7.2.01 (23-May-2018)

Fixed the download by sheet. Bug introduced from importing latest common architecture module in version 7.1.37

7.2.00 (21-May-2018)

Fixed issue of getting xml parse error while loading Budget Amounts for the Budget Organization with password in 11i.

7.1.37 (21-May-2018)

Internal fix.

7.1.36 (16-May-2018)

Removed 'ALL' as List of values option from Budget Organization column in 'Concurrent Submit Import' form.

7.1.35 (20-Apr-2018)

Fixed issue of not finding Accounts when Budget organization field is blank on the Download form.
Fixed issue of getting error message 'Account cannot be populated when Account is null' on the Download form.

7.1.34 (19-Apr-2018)

Fixed issue of getting error message 'Total Amount column is missing from the sheet' - when it is on the sheet.

7.1.33 (16-Apr-2018)

Fixed issue of not downloading Budget Amounts using the form using account ranges.

7.1.32 (13-Apr-2018)

Fixed issue of getting VBA error while loading Budget Amounts.

7.1.31 (13-Apr-2018)

Fixed issue of not writing Request ID on the sheet loading Budget Amounts and submit import journal is set to Automatic.

7.1.30 (04-Apr-2018)

Fixed issue of not validating Account based on Budget Organization.
Fixed issue of getting server 'Language US is not currently supported' while logging into instance.

7.1.29 (21-Mar-2018)

Fixed issue of getting SQL Error while opening Budget Download form in Budget Amounts mode.

7.1.28 (22-Feb-2018)

Internal updates.

7.1.27 (22-Feb-2018)

Fixed the issue of showing the Budget Organizations in the list of values with disabled user privileges.

7.1.26 (20-Feb-2018)

Fixed the issue of allowing to Upload Journals when Attachment Status/Message column are missing from the sheet.

7.1.25 (14-Feb-2018)

Fixed the issue of getting VBA runtime error 9999 while using refresh Interface Status and Attachment columns are removed from the sheet.

7.1.24 (13-Feb-2018)

Updated Custom Query ribbon.

7.1.23 (02-Feb-2018)

Internal fix.

7.1.22 (25-Jan-2018)

Fixed the issue of not downloading correct Budget Amounts when currency is passed as filter using Download via Sheet parameter.

7.1.21 (15-Jan-2018)

Fixed issue of getting VBA error while loading Budget Amounts into Oracle and Budget have set the 'Require Budget Journals flag to Yes’.

7.1.20 (20-Dec-2017)

Internal fix.

7.1.19 (08-Dec-2017)

Internal fix.

7.1.18 (08-Dec-2017)

Fixed the issue of getting VBA error while creating New template using Manage Template form.

7.1.17 (07-Dec-2017)

Added validation for Budget Name to stop user from loading frozen budgets.

7.1.16 (01-Nov-2017)

Fixed the template message.

7.1.15 (31-Oct-2017)

Corrected the template message if the selected Template Name does not match with the Template Name select on the ribbo.

7.1.14 (31-Oct-2017)

Internal fix.

7.1.13 (10-Oct-2017)

Fixed the issue of Wizard not stopping the download if any of the field value is incorrect on the Download form.

7.1.12 (06-Oct-2017)

Fixed the issue of getting VBA type mismatch error Error 13 (Type Mismatch) error when manually typing in Account and tabbing off field on the download form.
Fixed the issue of not validating and stopping the download if Account From/To is incorrect on the form.
Fixed the issue of not validating if Template name on the ribbon is different with the template name on the sheet.

7.1.11 (04-Oct-2017)

Fixed the issue of getting incorrect Period list while creating Budget Amount template.

7.1.10 (02-Oct-2017)

Fixed the issue of not validating control account while validating journals.

7.1.09 (25-Sep-2017)

Added Debug button to ribbon.

7.1.08 (14-Sep-2017)

Updated latest common architecture modules into the Wizard.

7.1.07 (31-Aug-2017)

Updated Security.

7.1.06 (28-Jul-2017)

Fixed the Download form alignment issue in Actuals, Encumbrance and Budget Journals Mode.
Fixed the issue of getting server error while downloading Journals using the download form by adding missing table gl_je_lines in download SQL.
Fixed the issue of getting server error while downloading journals in R11 by added missing table gl_je_sources in attachment download SQL.

7.1.05 (14-Aug-2017)

Internal fix.

7.1.04 (02-Aug-2017)

Fixed the issue of getting VBA error while using refresh interface status.
Fixed the Budget Amount Form Labels.
Fixed the issue of not changing supertip on Download via sheet for mode Budget Amounts.
Changed the sheet template heading from Journal to Header for All modes.

7.1.03 (25-Jul-2017)

Internal fix.

7.1.02 (18-Jul-2017)

Internal fix.

7.1.01 (17-Jul-2017)

Fixed the issue of getting VBA error '424' while entering Budget Amounts using wizard form.
Fixed the issue of not loading Budget Amounts if Pre-Validate Account is set to Yes and Submit Automatic Journal is Set Automatic.
Fixed the issue of not defaulting Budget Name on the form.

7.1.00 (30-Jun-2017)

Internal fix.

7.0.07 (08-May-2017)

Fixed the issue of not validating Period From and Period To column on the Download form.

7.0.06 (08-May-2017)

Fixed the issue of not listing Period list of values in Alphabetical order.
Fixed the issue of not listing Budget List of Values on the Template Form when Tap out.

7.0.05 (03-May-2017)

Fixed the issue of not validating Period From/Period To column on the Download form.

7.0.04 (02-May-2017)

Fixed the issue of getting VBA error while opening Manage Templates form from General Ledger Budget Amounts setup tab.

7.0.03 (02-May-2017)

Fixed the issue of not downloading corrected Amounts on the sheet if Journals (Budget Amounts) downloaded via sheet.

7.0.02 (01-May-2017)

Updated Security.

7.0.01 (01-May-2017)

Fixed the issue of not populating correct Period List of Values based on Period Year Selection on the Download from.
Fixed the issue of not validating 'Period From' and 'Period To' column on the download Form.
Fixed the issue of getting SQL error while selection 'Period To' as 'ADJ' Period and using the Download form.

7.0.00 (27-Mar-2017)

Added Budgets Amount feature.

6.2.22 (02-Oct-2017)

Fixed the issue of not validating control account while validating journals.

6.2.21 (25-Sep-2017)

Added Debug button to ribbon.

6.2.20 (12-Sep-2017)

Fixed the issue of getting SQL error while validating and uploading journals and submit Journal Import is set to automatic.

6.2.19 (11-Sep-2017)

Fixed the issue of getting SQL error while downloading journals in Budget Journals mode.

6.2.18 (07-Sep-2017)

Fixed the Download form label alignment issues.
Fixed the issue of getting 'Invalid Character Error' while using Download form.

6.2.17 (31-Aug-2017)

Fixed the issue of Journals not downloading in mode 'Budget Journals' mode.
Fixed the issue of not returning Error message on the sheet.

6.2.16 (28-Aug-2016)

Fixed the issue of getting server error while downloading Journals using Download form in R11.
Fixed the issue of getting XML Parse error while downloading journals using download form and entering Line Number as a filter.

6.2.15 (11-Aug-2017)

Internal fix.

6.2.14 (11-Aug-2017)

Fixed the issue of getting VBA Type mismatch error 13 while loading Journals into Oracle in R11.

6.2.13 (17-Jul-2017)

Customer fix.

6.2.12 (26-Jun-2017)

Updated Downloader version.

6.2.11 (03-May-2017)

Fixed issue of not downloading multiple Journals if download from the sheet.
DownloadRange - Fixed issue when specifying multiple header criteria and multiple rows where no data was downloaded.

6.2.10 (12-Apr-2017)

Fixed error occurring during journal download with Attachments.

6.2.09 (29-Mar-2017)

Fixed issue where not Downloading Journals using 'Download via Sheet' and multiple if multiple filter are selected.

6.2.08 (28-Mar-2017)

Fixed issue of getting SQL Error 'INVALID NUMBER' while downloading journals.

6.2.07 (17-Mar-2017)

Suppress javascript errors on Login

6.2.06 (10-Mar-2017)

Internal fix.

6.2.05 (02-Feb-2017)

Updated Security.

6.2.04 (27-Jan-2017)

Updated Security.

6.2.03 (18-Jan-2017)

Updated Security.

6.2.02 (17-Jan-2017)

Updated Security.

6.2.01 (22-Nov-2016)

Updated Security.

6.2.00 (22-Nov-2016)

Updated Common Architecture to release 2.3

6.1.31 (15-Nov-2016)

Fix the issue of not defaulting the Values on the sheet from Default row 10.

6.1.30 (03-Nov-2016)

Fix the issue of getting server error ' Error 1001 ('NO1' does not exist in row) ' while downloading journals and Line DFF Columns are missing from the sheet.

6.1.29 (31-Oct-2016)

Re-Fix the issue of getting error 'literal does not match format string' on conversion rate column while loading actual journals.

6.1.28 (26-Oct-2016)

Fix the issue of getting error 'literal does not match format string' on conversion rate column while loading actual journals.

6.1.27 (20-Sep-2016)

Updated Downloader.

6.1.26 (20-Sep-2016)

Fix the issue of getting server error on Submit Concurrent Program form while entering 'Select Group's ID'.

6.1.25 (20-Sep-2016)

Fix the issue of getting Error '9999' when uploading actuals into journal and Group ID is null on the sheet.
Updated Security.

6.1.24 (30-Aug-2016)

Imported latest Downloader Module [1.0.58].
Fix the issue of not validating mandatory columns if they are missing from the sheet. Fixed popup message box and mandatory columns being removed.

6.1.23 (16-Aug-2016)

Imported latest Downloader Module.

6.1.22 (14-Jul-2016)

Fix the issue of getting 'EM01 Invalid journal entry category.' after Importing Journals into Oracle.

6.1.21 (14-Jul-2016)

Fix the issue of not finding Journals while doing import process and Import Using Key Flag is Enable for the source.
Fix the issue of not Returning Request ID into sheet for Encumbrance Mode while doing automatic submit process.

6.1.20 (05-Jul-2016)

Added a call to create Profile Options.

6.1.19 (04-Jul-2016)

Fix the issue of getting Error 91 when Effective Date column is missing from the sheet

6.1.18 (04-Jul-2016)

Fix the issue of getting Server Error when required columns are missing from the sheet.

6.1.17 (04-Jul-2016)

Fix the issue of getting Error 91 when Ledger Name column is missing from the sheet.

6.1.16 (04-Jul-2016)

Fix the issue of getting XML error while loading data into oracle with invalid Ledger name and using automatic process for importing journals.

6.1.15 (04-Jul-2016)

Fix the issue of getting error 'Xml error: A name was started with an invalid character' on Budget Download Form in R11 while searching Journal Name.

6.1.14 (01-Jul-2016)

Fix the issue of Incorrect Batch Name (Budget Name) on Download Form in Budget Journals Mode.
Fix the issue of getting Duplicate Batch Name and Journal Name List Of values in Download Form (Actuals, Budget Journals and Encumbrance).

6.1.13 (30-Jun-2016)

Imported latest common messages sheet.
Implemented missing Error handler in InitialiseDownloadColumns of Download (All Modes).

6.1.12 (29-Jun-2016)

Fix the issue of getting 'Error 13 (Type mismatch)' on Login Windows 7.

6.1.11 (29-Jun-2016)

Fix the issue of getting compile error in Windows 7 while logging through Wizard.

6.1.10 (28-Jun-2016)

Fix the issue of not loading DFFs into oracle using Concurrent Submit Program.

6.1.09 (28-Jun-2016)

Fix the issue of not loading 'Reference Date' and 'Reconciliation Reference' into interface table (Oracle).

6.1.08 (11-Jun-2016)

Fix the issue of not loading Stat Quantity column into Oracle.

6.1.07 (27-Jun-2016)

Fix the issue of getting whitespace error while loading journals into Oracle.

6.1.06 (27-Jun-2016)

Fix the issue of getting XML Parse Error while loading journals into oracle R11.
Fix the issue of getting vba automation error when closing the processing form using click.

6.1.05 (24-Jun-2016)

Fix the issue of Import option not working on Submit Concurrent Form.

6.1.04 (24-Jun-2016)

Fix the issue of not showing ribbon supertip Label after login.

6.1.03 (24-Jun-2016)

Remove Start Date/End Date from Submit Concurrent Program form.

6.1.02 (24-Jun-2016)

Fix the issue of getting server while downloading journal using incorrect Date on Download Form.
Fix the issue of getting ‘XML Parse Error' 'Bad Request’ while downloading journal using download from sheet.

6.1.01 (23-Jun-2016)

Fix the issue of not Importing Journals if in 11i.

6.1.00 (22-Jun-2016)

New Mode Budget Journals added to the Wizard.
Updated Security.

6.0.30 (22-Jun-2016)

Reimported the Example-Budget Journals Sheet. Removed "Approval Import Settings" option from the Right Click menu.

6.0.29 (22-Jun-2016)

Re-arrange Wizards in alphabetical order.
Update Wizard with new Example Sheet.

6.0.28 (20-Jun-2016)

Fix the issue of getting xml error while doing submit import process in R11.

6.0.27 (17-Jun-2016)

Imported the latest Downloader Module 1.0.50

6.0.26 (17-Jun-2016)

Fix the issue of getting xml error while doing the refresh. Imported latest WDelete, WRefresh, cmMessages and cmXML, WSection for Session Time out issue.

6.0.25 (13-Jun-2016)

Created a variable C_GROUP_ID and generate the group id during post login.
Removed "All Group ID" option from Submit Concurrent Program.
Fix the issue of not uploading Currency columns in GL Interface Table.

6.0.24 (13-Jun-2016)

Removed 'No Group ID ' as an option from 'Submit Concurrent Program'.
Fix the issue of not uploading Currency columns into interface (Conversion Rate, Conversion Type).

6.0.23 (13-Jun-2016)

cmUpload:removed the check for processing form open for UploadSelected Attachments and UploadAll Attachments.

6.0.22 (11-Jun-2016)

Fix the issue of RequestID color index changing.

6.0.21 (10-Jun-2016)

Fix the issue of getting Server Error while uploading Journals with different responsibility.

6.0.20 (10-Jun-2016)

Fix the issue of Server Error 'Gl_je_batches.curval' not set in current session for Upload and doing import process.
Fix the issue of not uploading Some Journals with same source and Different GroupID.
Fix the issue of GroupID Column Printing as ID Column and Set the GroupID Column as Mandatory.
Fix the issue of getting Server Error.

6.0.19 (09-Jun-2016)

Fix the issue of Progressbar showing incorrect value while doing refresh.

6.0.18 (07-Jun-2016)

Implemented new options:
- Pre-Validate Accounts
- Submit Import Journal for Performance
Updated the Downloader Module.

6.0.17 (02-May-2016)

Fix the issue of getting 'Runtime Error' when clearing status column on the sheet using ClearStatusColumn.

6.0.16 (02-May-2016)

Fix the issue of not validating Control Column in Budget Journal.
Align form fields based on Sheet for all Modes.

6.0.15 (27-Apr-2016)

Re-fix the issue of not respecting organisation rules.
Implemented control total column functionality for Budget Journals Mode.
Fixed key with dependencies.
Added Control Total column in the form.

6.0.14 (27-Apr-2016)

Fix the Cosmetic issues on the Download form.
Fix the issue of getting whitespace error while uploading journal on R11.

6.0.13 (13-Apr-2016)

Fix the Cosmetic issues on the Download form.
Changed Source as Search Controlled Column.
Imported new cmMessages123 sheet v3.6

6.0.12 (13-Apr-2016)

Fix the issue of not respecting organisation rules.

6.0.11 (13-Apr-2016)

Fix the issue of inconsistent message for Currency Column on the form.
Remove 'R11' from header label.

6.0.10 (12-Apr-2016)

Fix the issue of mandatory message appears on the form.

6.0.9 (11-Apr-2016)

Fix the issue of getting Xml Error while validating Journals.

6.0.09 (11-Apr-2016)

Fix the issue of getting Xml Error while validating Journals.

6.0.08 (11-Apr-2016)

Fix the bug introduced in version 6.0.07 while opening forms in R12. Getting xml Error.

6.0.07 (11-Apr-2016)

Fix the issue of getting xml error while opening the form on R11.
Removed Max rows from Download Form.

6.0.06 (07-Apr-2016)

Fix the issue of getting XML Parse error in R11, using Download form.

6.0.05 (06-Apr-2016)

Fix the issue of getting Server Error while uploading Journals on R11.

6.0.04 (06-Apr-2016)

Fix the issue of getting Server Error while uploading Journals without Currency on the Sheet.
Fix the performance issue of validating and uploading journals.

6.0.03 (06-Apr-2016)

Fix the issue of getting msg 'No Combinations were found. Please enter new criteria'.

6.0.02 (05-Apr-2016)

Fix the issue of getting server while opening form with incorrect values.
Fixed issue with blank date dependencies.
Imported new cmMessagesSheet123.

6.0.01 (01-Apr-2016)

Imported latest message module with new licence fix.

6.0.00 (30-Mar-2016)

Imported latest common code version 2.1

5.0.21 (04-Apr-2016)

Fixed issue of getting server while opening form with incorrect values.
Fixed issue with blank date dependencies.

5.0.20 (01-Apr-2016)

Imported latest common code version 2.1.
Imported latest message module with new licence fix.

5.0.19 (30-Mar-2016)

Fixed issue of not validating Reverse Date if Reverse Journal is set Yes and Enable average balance is set to Yes.

5.0.18 (30-Mar-2016)

Fixed issue of not uploading unbalanced 'STAT' Journals.
Fixed issue of not validating 'Encumbrance' Journals when Currency Code is 'STAT'.

5.0.17 (21-Mar-2016)

Updated Security

5.0.16 (11-Mar-2016)

Fix the issue of getting XML while using Submit Import Form.

5.0.15 (11-Mar-2016)

Fix the issue of Downloading Journals using Download from Sheet with no Criteria Passed.
Fix the issue of clearing previously processed data while Downloading Journals using Download from Sheet with no Criteria Passed.
Fix the issue of Getting Error '9999' while using Submit Import Form.
Updated Security

5.0.14 (10-Mar-2016)

Fix the issue of 'Error: This procedure can only process SELECT statements' while downloading journals in R11.

5.0.13 (09-Mar-2016)

Fix the issue of form opening on default row using forms from ribbon toolbar.
Fix the grammatical on manage templates form.
In cmMessage123 sheet corrected punctuation on Manage Template Message.
Fix the issue of 'Default Rows' Not Printing while creating new Sheet.

5.0.12 (09-Mar-2016)

Corrected form label spellings for all mode.
Corrected the Line USSGL Tax code label on Line Form.
Close the download form if data is download else will keep it open if no data downloaded.
Fix the issue of getting server error while downloading Journals with ledger id as a criteria.

5.0.11 (09-Mar-2016)

Fix the issue of 'To' date message pop up when other parameters are passed in the form.

5.0.10 (07-Mar-2016)

Fix the issue of not validating 'To' Date on the download form if 'To' Date is blank.
Imported New Example Sheet.

5.0.09 (07-Mar-2016)

Fix the issue of getting error '9999' while uploading journals.
Fix the issue of not printing Batch ID and Journal ID in Bold and Italic Format.
Updated the message for Uploading Attachments with common Attachment message while doing refresh.

5.0.08 (29-Feb-2016)

Fix the bug introduced in version 5.0.06 of not uploading journals with line information.

5.0.07 (29-Feb-2016)

Remove Group ID from download.

5.0.06 (29-Feb-2016)

Fix the issue uploading Journal with no line information.
Fix the issue of not resetting Ledger list of values if source is change in submit form.

5.0.05 (25-Feb-2016)

Fix the issue of getting reverse date column in 'Encumbrance' Mode while creating new sheet.
Fix the issue of not uploading Credit and Debit Columns.

5.0.04 (09-Feb-2016)

Added missing security check for entering General Ledgers.

5.0.03 (03-Feb-2016)

Imported latest common code version 2.1 and Implemented new messages.

5.0.02 (07-Jan-2016)

Fix the issue of Journal Attachments downloading downloaded below the lines.
Fix the issue of not opening Tax Dff form and Line Tax Dff Form.
Fix the issue of getting validated status while uploading attachment using Attachment form.

5.0.01 (06-Jan-2016)

Fix the issue of Journals not getting uploaded with different regional settings.
Fix the issue getting sql error while downloading journal using Group ID (not a Download Column).
Fix the issue of Journal Period and Reverse Period Column type changing to date after downloading journals.

5.0.00 (05-Jan-2016)

Fix the issue of not validating Effective Date Column with incorrect values.
Fix the issue of not validating Invoice Amount (Descriptive Flexfield Column) with incorrect values.
Fix the issue of resetting the Accounting Segments to Code Combination ID.
Fix the issue of USSGL Trx Code column validation.
Imported latest common code version 2.0

3.0.29 (20-Oct-2015)

Fix the issue of Incorrect Reverse Period List of Values in Encumbrance Mode.
Fix the issue of getting error "ER05 This reversal date is not in your database date format." after Journal Import. Reference8 is VARCHAR field and its doesn't respect NLS_DATE_FORMAT settings or Profile:ICX_DATE_FORMAT_MASK.
So we assume oracle is using hardcoded format (DD-MON-YYYY).if Oracle changes this it would cause problems.
Fix the issue of Import Journals form field not validating incorrect values.

3.0.28 (16-Oct-2015)

Fix the issue of not validating Group ID.
Stop unnecessary queries from running while opening the form.
Added Encumbrance as a New Source in Source list of Values.
Added 'Encumbrance' as criteria in List of Values for Source in Values.

3.0.27 (15-Oct-2015)

Fix the bug introduced in version 3.0.26 of getting error on Reverse period not blank when reverse journal is Yes.

3.0.26 (15-Oct-2015)

Fix the Tab order issue on Lines form.
Fix the issue of getting unknown error while uploading journals in 'Encumbrance' mode.

3.0.25 (14-Oct-2015)

Fix the issue of getting unhandled error while uploading journals.

3.0.24 (14-Oct-2015)

Fix the issue of getting error "Reverse Date Column is required if Average Balance are enabled and Reverse Journal is Yes" in Encumbrance Mode.

3.0.23 (14-Oct-2015)

Fix the issue of getting incorrect List of Values & Sorting order for Accrual Reverse Period.

3.0.22 (12-Oct-2015)

Fix the issue of writing error message on the sheet while opening the form and choosing incorrect value and then correct value using Reverse Journal column.
Fix the issue of getting message pop up while uploading "Oops. Item 'C_ENABLE_AVERAGE_BALANCES_FLAG' not cached. Please inform us here at More4Apps".
Fix the error message wording for Reverse Period and Reverse Date Column.
Fix the issue of getting error Conversion Type is required for 'STAT' Currency in Actual Modes.

3.0.21 (08-Oct-2015)

Fix the issue of getting server while opening Journal form and selecting Journal Period in 'Actuals' Mode.

3.0.20 (07-Oct-2015)

Not setting Reverse Period Column is required if Enable Average Balance flag is enabled.

3.0.19 (06-Oct-2015)

Fix for not getting Journal Period list of values based on Journal Ledger and Latest. Encumbrance Year in Encumbrance Mode.

3.0.18 (05-Oct-2015)

Fix the issue of getting compile error while Uploading/Downloading introduced in version.

3.0.17 (02-Oct-2015)

Fix the issue of not getting Error on Reverse Date.
Fix the issue of getting Error 91 while opening the Journal Form (On Reverse Journal Tab) on Encumbrance Mode.
Fix the Design issues on Reverse Journal Tab in Encumbrance mode.
Fix the issue of getting unknown error (introduced in 3.0.15) while uploading normal journals.
Fix the issue of Reverse Period and Reverse Date not working correctly based on Enable Average Journal Flag.

3.0.16 (29-Sep-2015)

Removed Reverse Date Column for Encumbrance Mode from Sheet and Form.
Fix the issue getting SQL error while downloading large Journals and Lines.

3.0.15 (29-Sep-2015)

Moved the Reverse Period above the Reverse Date Column on the Form. Cached the value of Enable Average Balance Flag.
Added a Check for Enable Average balance flag. Populate Reverse Date/Reverse Period based on Enable Average balance flag.

3.0.14 (24-Sep-2015)

Fix the issue of getting XML Parse Error while opening the form.
Fixed the issue of Download form not clearing previous search data.

3.0.13 (22-Sep-2015)

Fix the issue of not updating user response Batch Name/Journal Name while doing refresh.

3.0.12 (11-Mar-2016)

Updated the pop up message based on modes while doing validation.
Fix for getting xml error while logging with different responsibility.
Fix for getting Can't move focus while opening Journal form using Currency Code Column.
Fix for Download form not clearing data for new data.

3.0.11 (17-Sep-2015)

Fix for not clearing previous data on Download form.

3.0.10 (16-Sep-2015)

Fix for not clearing previous error message on Deleting Journals.
Fixed parent message clearing when using set parent status.

3.0.09 (15-Sep-2015)

Fix for not writing error on Journal Section.
Fix for getting error after closing the download form.

3.0.08 (15-Sep-2015)

Fix for getting server error while doing download in Actual mode.

3.0.07 (14-Sep-2015)

Fix the issue error not writing back to the sheet.

3.0.06 (14-Sep-2015)

Fix the issue of getting incorrect message while using incorrect Account Segments.
Fix the tab order of Generate Template Form.
Fix the typo issue for ribbon (Delete from interface) and mode options.

3.0.05 (11-Sep-2015)

Fix for downloading journals for different ledgers.

3.0.04 (09-Sep-2015)

Fix for deleting journals with 'Accepted Status'.

3.0.03 (09-Sep-2015)

Fix for not deleting Error Journals.

3.0.02 (09-Sep-2015)

Fix for Sql error while downloading journals.
Fix for downloading Encumbrance Journal in Actual mode.

3.0.01 (08-Sep-2015)

Added Encumbrance Journal feature

3.0.00 (27-Jul-2015)

Updated Core Code from 210 to 212

2.1.03 (03-Aug-2015)

Fix the position of Submit Import form by adding positionform to open it on centre. Change the Design of submit import Form

2.1.02 (31-Jul-2015)

Rearranged the right click menu and corrected wordings of right click menu for Customize Fields and Customize LOVs

2.1.01 (27-Jul-2015)

Fix the Attachment upload issue by Checking ID and status on the sheet

2.1.00 (27-Jul-2015)

Imported Core Code 212 to fix the 11i xml Diagnostic error
Fix the attachment upload issue by creating separate Attachment implementation

2.0.43 (27-Jul-2015)

Added a Check for Attachments sections in InitialiseColumns to fix attachment section not found error

2.0.42 (27-Jul-2015)

Fix the attachments upload issue. Removed separate call for Journal and Line form

2.0.41 (27-Jul-2015)

Imported new Attachment Code to fix the Attachment download issue
In Ribbon toolbar separated call for Journal and Line form

2.0.40 (23-Jul-2015)

Updated Download Wizard Modules

2.0.39 (23-Jul-2015)

Removed extra validation for Conversion Date (Exchange Date) used to restrict the download to fix the upload issue

2.0.38 (22-Jul-2015)

Activated processing form for performing download using form and Download selected from the sheet. Corrected Queries spelling under 'Downloader' Ribbon toolbar

2.0.37 (17-Jul-2015)

Fixed error "Only one top level element is allowed in an XML document." caused by the downloader initializing during login
Fixed download issue for currency conversion date column

2.0.36 (15-Jul-2015)

Rewrote the DeleteJournal function to handle 'IN' statement in SQL Query.
In DeleteJournal added check for user to confirm delete journal and lines from interface table
In DeleteJournal function change the wording of msg after completing delete journal lines to " 4 Journal Lines " and " 1 Journal Line"
Added new functionality "Clear Status Column" to clear the status columns on the sheet

2.0.35 (13-Jul-2015)

Rewrote the DeleteJournal function to stop user from deleting single line or single journal. Commented out setWarningMessage in GLWRefresh module to display warning message

2.0.34 (06-Jul-2015)

Imported the new fndBlocklist (25th June 2015 update)

2.0.33 (01-Jul-2015)

In GLWRefresh created a function setWarningMessage to Display warning message 'WU01' if Journal is out of Balance

2.0.32 (23-Jun-2015)

Corrected the message 'Please put cursor on line 10 or below' by changing the line number to 11

2.0.31 (19-Jun-2015)

In DeleteJournal set the bisAccepted to vbFalse if upload status is 'PENDING'

2.0.30 (19-Jun-2015)

Rewrote the Deletejournal Function and a check to ignore 'ACCEPTED' Status
Rename the 'Delete' button ribbon to 'Delete from Interface’

2.0.29 (17-Jun-2015)

Excel 2003: Removed styles using ClearWorkbookStyles module to fix the error

2.0.28 (17-Jun-2015)

Removed call SetMethodOption in CreateProductMenuToolbar to fix the compile error excel 2003

2.0.27 (16-Jun-2015)

In GLWMenuToolbar Create_ToolBars added CreateDWMenuToolbar to create the download wizard toolbar

2.0.26 (16-Jun-2015)

In ValidatorGLWControl Changed the condition to compare effective date with start date and end date by adding '=' to the fix the account validation

2.0.25 (12-Jun-2015)

Fix the compile error for Excel 2003. Moved Public Validate_Option As String form GLWRibbon to GLWmenutoolbar

2.0.24 (12-Jun-2015)

In DeleteJournal added check for id columns to fix the error

2.0.23 (11-Jun-2015)

Changed the logical operator in the validator to fix the issue of not validating accounts for Effective Date

2.0.22 (10-Jun-2015)

Changed the column type of Group ID to handle large variables

2.0.21 (08-Jun-2015)

Fixed the issue of Currency Column erroring while opening the form

2.0.20 (08-Jun-2015)

Fixed the incorrect Balance Type list of values error while opening the form by setting the column width in form properties

2.0.19 (29-May-2015)

Fixed issue if the effective date is blank when opening the form

2.0.18 (29-May-2015)

Fixed issue of exchange rate erroring after selecting exchange type, exchange date and Currency Code

2.0.17 (14-May-2015)

Fixed issue of Ledger ID by passing it as bind parameter

2.0.16 (12-May-2015)

Fixed issue of Group ID not validating while uploading

2.0.15 (08-May-2015)

Removed the Static parameters from the SQL Query

2.0.14 (08-May-2015)

Fixed issue of white space in 11.5.9

2.0.13 (05-May-2015)

Fixed issue of validating accounts on the form

2.0.12 (05-May-2015)

Fixed issue of Effective Date not defaulting for future period

2.0.11 (05-May-2015)

Fixed issue of account segments not validating if the segments are outside effective date

2.0.10 (04-May-2015)

Fixed issue of GL code validation

2.0.09 (30-Apr-2015)

Effective date defaulting from Period fix

2.0.08 (30-Apr-2015)

Fixed Period Type cached value blank in 11.5.9

2.0.07 (30-Apr-2015)

Fixed alias issue while doing Journal Uploads to resolve XML Tag issue

2.0.06 (30-Apr-2015)

Fixed type mismatch error in DW Query when logging in

2.0.05 (24-Apr-2015)

Removed the comment 'Please enter new criteria.' in GL Combinations

2.0.04 (24-Apr-2015)

Reverse Period and Reverse Date. Case validation fix

2.0.03 (23-Apr-2015)

Download SQL aliases applied to resolve tag issue

2.0.02 (23-Apr-2015)

Fixed Exchange Date issue while Creating Journals

2.0.01 (20-Apr-2015)

Updated Downloader files

2.0.0 (16-Apr-2015)

Initial public release