18.0.0.0 (12-Jun-2025)

Updated ERP Cloud Toolbox to 18.0.1.0
* Security Update: Updated libraries to the latest patch versions.

Updated ERP Cloud Toolbox to 18.0.4.0
* Fixed an issue that was introduced in version 17.15.0.0 of the ERP Cloud Toolbox Add-in which would cause Excel to crash during long running Uploads/Downloads.

17.26.5.0 (03-Jun-2025)

Events Integrator - Transaction Currency Field: Removed mandatory validator
Events Integrator - Transaction Currency Field: Removed mandatory flag
Project Templates Integrator: Corrected issues with Download Form structure
Updated ERP Cloud Toolbox to 17.14.2.0
- Added functionality so Descriptive Flexfield and Extensible Flexfield(where applicable) form field labels will dynamically change based on the context selected.
- Security Update: Updated libraries to the latest patch versions.

Updated ERP Cloud Toolbox to 17.15.0.0
- Added Functionality to Expand or Collapse all Sections and Fields in the Sheet Builder fo
Cost Adjustments Integrator - Project Number & Task Number Field Validation: Remove requirement when adjustment type is 'Transfer'.

17.25.1.0 (15-May-2025)

Contracts Integrator - Line PO Number Field Download: Fixed data type to be Text instead of Integer.

17.25.0.0 (01-May-2025)

Projects Module: Added a new integrator 'Bill Plan Schedule Overrides integrator'. Added a new integrator 'Revenue Plan Schedule Overrides integrator'.
Amend Contracts Integrator - Version Type & Status Field: Removed download filters as only Current and Active contracts are downloaded.
Amend Contracts Integrator - Contracts Upload Action Field: Column hidden as it is not relevant to invoke actions on the sheet.

17.23.1.3 (21-Mar-2025)

Budgets Integrator - Status Field Upload: Remove validator that stops the value from uploading on Update.
Amend Contracts Integrator - Amend Section: Added new column 'Create New Version'.

17.23.1.1 (20-Mar-2025)

Amend Contracts Integrator - Version Type and Status Field Download: Restrict to Active status and Current contracts.
Amend Contracts Integrator: Close section validation - Fixed issue where fields were not set required when closing.
Amend Contracts Integrator: Conversion from SOAP to REST web services. Added new action 'Close' to close active contracts. Updated Projects reports to 14.13.2.

17.22.0.0 (18-Mar-2025)

Updated ERP Cloud Toolbox to 17.13.0.0

Internal enhancements
Security Update: Updated libraries to the latest patch versions.
Forecasts Integrator - Forecast Generation Source Field: Moved column to Source Details section to be more aligned with the functionality.

17.21.0.0 (20-Feb-2025)

Projects Module - Updated version number
Projects Module - Added new ‘Bill Rate Overrides' Integrator.
Assets and Assignments Integrator - Task Number to assign Field LOV: Updated to be searchable instead of shortlist.
Project Templates Integrator - Team Member Name Field LOV: Team Member Name. Team Members Section: Removed Start Date and End Date. Updated Projects reports to 14.13.0.
Budgets Integrator - Budget Versions Section Upload: Removed Plan Type, Planning Amounts, Status from Update.
Forecasts Integrator - Forecast Versions Section Upload: Removed Plan Type, Planning Amounts, Status from Update.
Project Templates Integrator - Header Section: Added new columns to support Cross-Charge Options. Tasks Section: Added new columns to support Cross-Charge Options. Team Members Section: Added Start and End Date columns. Team Person Number now has a loose dependency on Team Member Name.
Cost Adjustments Integrator - Updated Catalog to 14.12.1
Cost Adjustments Integrator - Updated Catalog to 14.12.0
Cost Adjustments Integrator - Update Account Details Section Validation: Added LOV support to derive the IDs for upload. Updated Projects reports to 14.12.0.
Budgets Integrator - Defer Financial Plan Creation Field Upload: Remove default parameter 'N' from Update.
Cost Adjustments Integrator - Update Account Details Section Validation: Removed LOV support for GL Code Combinations due to performance issues.
Forecasts Integrator - Defer Financial Plan Creation Field Upl oad: Remove default parameter 'N' from Update.

17.20.0.0 (22-Jan-2025)

Projects Module: Updated Projects reports to 14.11.0.
- These reports have incompatibilities with module version 17.18.1.1 (14-Jan-2025) and lower.
- Minimum report version required for this version of the module.

Updated ERP Cloud Toolbox to 17.12.4.0
- Fixed an issue where values being printed from Download could be truncated.
- Security Update: Updated libraries to the latest patch versions.

Assets and Assignments Integrator - Person Number Field LOV: Removed hard dependency on Person Name.
Assets and Assignments Integrator - Person Number Field Validation: Remove dependency to Person Name.
Projects Module - Added new ‘Bill Rate Overrides' Integrator. Upload catalog file, Update minimum BI report version to 14.11.0
Financial Projects Integrator - Person Number Field Validation: Corrected Report Upload Field to Person_Id.

17.18.1.1 (14-Jan-2025)

Financial Projects Integrator - Person Number Field Validation: Corrected Report Upload Field to Person_Id.
Financial Projects Integrator - Person Number Field Validation: Remove dependency to Team Member Name.. Updated Projects reports to 14.10.2

17.18.0.0 (24-Dec-2024)

Person Rates Integrator: Download Source - Primary. Internal update for download report parameters. Updated Projects reports to 14.10.1

17.17.0.0 (20-Dec-2024)

Updated ERP Cloud Toolbox to 17.12.3.0
- Added a new form to view submitted scheduled processes for the current logged in user.
- Fixed an issue where using the [CLEAR] syntax in default row could cause an exception error.
- Fixed an issue where values being printed from the Data Forms to the sheet could be truncated.
- Security Update: Updated libraries to the latest patch versions.

17.16.0.0 (18-Dec-2024)

Projects Module: Added new ‘Cost Rate Overrides' Integrator.

17.15.8.0 (17-Dec-2024)

Project Templates Integrator - Initial Project Status Field LOV: Updated to display correct values. Updated Projects reports to 14.9.0
Cost Adjustments Integrator - Adjustment Type Field LOV: Added new Adjustment Type 'Update Accounts'.
Cost Adjustments Integrator - Update Account Details Section: Added New Raw Cost Credit Account, New Raw Cost Debit Account, New Burden Cost Credit Account, New Burden Cost Debit Account, New Burdened Cost Credit Account & New Burdened Cost Debit Account Fields.
Contracts Integrator - Contract Name Field Validation:
Fixed issue where LOV data could not be uniquely identified. Updated Project reports to 14.8.0

Cost Adjustments Integrator - Person Name Field Validation:
Fixed issue where LOV data could not be uniquely identified. Updated Project reports to 14.8.0

Cost Adjustments Integrator - Person Number Field Validation:
Fixed issue where LOV data coul
Events Integrator - Event Type Field LOV: Restricted LOV to Event Types where End Date is null.
Costs Integrator - Burden Cost Credit Account and Burden Cost Debit Account Fields: Added new columns.

17.15.3.1 (03-Dec-2024)

Cost Rate Overrides Integrator: Hide this integrator
Budgets Integrator - Project Number and Project Name download LOV: Changed REST web service to BI Report.
Budgets Integrator - Planning Resources Section: Added validation to handle duplicate Task Number and Resource Name for the same project budget version.
Budgets Integrator - Project Number Field LOV: Changed REST web service to BI Report.
Updated ERP Cloud Toolbox to 17.11.1.0

Security Update: Updated libraries to the latest patch versions.
Projects Module- Added new ‘Cost Rate Overrides' Integrator.
Costs Integrator - Download Form: Person Name Field - Added dependency on Business Unit

Contracts Integrator - Type, Number, Currency Fields: Changed to searchable LOVs

Budgets Integrator - Budget Versions Section: Default DeferFinancialPlanCreation value to 'N' when uploading budgets.
Forecasts Integrator - Forecast Versions Section: Default DeferFinancialPlanCreation value to 'N' when uploading forecasts.

17.14.6.0 (18-Nov-2024)

Budgets Integrator - Planning Resources Section: Removed search from Planning Resources Upload Action LOV
Budgets Integrator - Planning Resources Section Download: Removed Child-Level Filters due to issue with Oracle REST web service
Financial Projects Integrator - Team Members Section: Updated Team Member Name LOV
Budgets Integrator - The Task Number must be entered when creating or updating Planning Resources
Award Budgets Integrator - Status Field LOV: Excluded the statuses that are not related to Award Budgets .
Budgets Integrator - Status Field LOV: Excluded the statuses that are not related to Budgets.
Updated BI report version to: 14.5.8
Forecasts Integrator - Status Field LOV: Excluded the statuses that are not related to Forecasts.

17.14.0.0 (29-Oct-2024)

Projects Module: Added the following Integrators: Person Rates, Job Rates, Non Labor Rates
Cost Adjustments Integrator - Adjustment Type Field LOV: Added adjustment types Hold Invoice Once, Hold Invoice Until Released, Release Invoice Hold, Hold Revenue Until Released, Release Revenue Hold
Financial Plan Resource Assignments Integrator - Added ITD Actual columns for Quantity, Raw Cost and Burdened Cost.

17.13.3.0 (23-Oct-2024)

Costs Integrator - Additional Information DFF for Processed Costs section: Combined with Additional Information DFF for Unprocessed Costs section to now be called Additional Information DFF for Costs.
Cost Adjustments Integrator: Added read-only column Net Zero Item Flag for download.
Events Integrator: Added columns to support Item-based Events.
Updated ERP Cloud Toolbox to 17.9.1.0
- Security Update: Updated libraries to the latest patch versions.

Contracts Integrator - Line Number Download: Corrected issue with sheet filter not downloading correctly
Contracts Integrator - Line Number Download: Added column as filter criteria to download via sheet or form
Financial Projects Integrator - Team Member Name Validation: Team Member Name BI Report change.

17.12.1.0 (03-Oct-2024)

Projects Module: Provided better feedback against the Settings form.
Updated ERP Cloud Toolbox to 17.8.0.0
- Added new ‘Edit Existing Sheet’ functionality.
- Fixed an issue where Data forms were being cut off on the right hand side.
- Fixed an issue where using the Search row in the sheet designer would deselect fields.
- Fixed an issue where some settings in the Settings form would not apply when saved.
- Security Update: Updated libraries to the latest patch versions.

17.11.6.0 (19-Sep-2024)

Financial Projects Integrator: Added Project Unit and Project Type download only fields.
Financial Projects Integrator: Added download data type for DFF attributes.
Cost Adjustments Integrator: Added sheet filter for Original Trans Ref field.
Budgets Integrator: Added Planning Options section.
Cost Adjustments Integrator: Added Billing section with Invoice Status and Revenue Status fields.
Financial Projects Integrator - Tasks Section: Display sheet column for 'Task Source Application Code'
Financial Plan Resource Assignments Integrator: Changed Planning Start Date and Planning End Date to be date only fields and correctly download in local timezone.

17.11.1.1 (03-Sep-2024)

Forecasts Integrator - Download via Form: Corrected an error when attempting to search the Resource Name.
Budgets Integrator - Download via Form: Corrected an error when attempting to search the Resource Name.
Updated ERP Cloud Toolbox to 17.7.1.0
- Added functionality to select or deselect all fields in the new Create Sheet Designer.
- Added messaging to notify the user when no download criteria is present when downloading via sheet.
- Fixed an issue where certain dates downloaded would cause an error. These dates will now be printed directly as they exist in the database.
- Fixed an issue where valida
Forecasts Integrator - Download Form: Added LOV search functionality for child-level filter 'Resource Name'.
Budgets Integrator - Planning Resources section: Added child-level filters for Planning Resources on the Download Form
Financial Projects Integrator - Added LOV Search functionality to Task TC Expenditure Cat, Task TC Expenditure Type, Proj TC Expenditure Cat, and Proj TC Expenditure Type
P
Financial Projects Integrator - Download Form: Added LOV search functionality for child-level filters
Cost Adjustments Integrator - Additional Information DFF for Processed Costs: Changed column type to be DFF Attributes
Projects Module: Added Sheet Designer column descriptions for the following integrators - Financial Projects, Planning RBS, Financial Plan Resource Assignments, Costs, Cost Adjustments, Assets and Assignments, Budgets, Forecasts, Award Budgets, Project Temp lates, Contracts, Amend Contracts, and Events
Contracts Integrator - Line Item Name Download: Added column as filter criteria to download via sheet or form
Contracts Integrator - Project Number Download: Added column as filter criteria to download via sheet or form
Contracts Integrator - Associated Projects: Added filter for Project Number List of Values (LOVs) to only return projects that are eligible for contract billing.
Updated ERP Cloud Toolbox to 17.6.4.0

- Added a new interface to search, select and deselect desired sections and fields during sheet creation.
- Swapped the options on the 'Template' Ribbon drop down to have them appear in a more logical ordering.
- Updated list of values controls so when typing to search for a value the typed text would respect case sensitivity.
- Added support for Value Sets t
Projects Module: Added the grouping of Integrators to their specific area within the Product Selection form for easier organization and selection.

17.9.7.0 (23-Aug-2024)

Contracts Integrator: Name Field Validation. Fixed an issue where validation could incorrectly mark rows as invalid, caused by incorrect SQL for handling loose dependencies.
Cost Adjustments Integrator: New Project Name Field Validation. Fixed an issue where validation could incorrectly mark rows as invalid, caused by incorrect SQL for handling loose dependencies.
Planning RBS Integrator: Project
Projects Module: Fixed an issue where validating multiple rows inconsistently marked rows as invalid. Previously, only the first row would be correctly validated, while subsequent rows would incorrectly display the error "[Field Name] does not exist in the List of Values."

Projects Module: Fixed an issue where validation could result in the following exceptions: '...KeyNotFoundException: Report c
Financial Projects Integrator - Fixed issue that caused the following Unhandled Exception: "...Can not add property ProjectName to Newtonsoft.Json.Linq.JObject. Property with the same name already exists on object...."
Forecasts Integrator: Changed the following Download Form fields from LOV to Text:
- Planning Resources Section: Task Name, Task Number

Financial Projects Integrator: Changed the following Download Form fields from LOV to Text:
- Classification Section: ClassCode, ClassCategory
- Team Members Section: Team Member Name
- Tasks Section: Task Name, Task Number, Chargeable, Billable, Capitalizable, P
Financial Projects Integrator: Added the following Ch ild Filters:
- Classification Section: ClassCode, ClassCategory
- Header Section: Project Start Date, Project Finish Date
- Team Members Section: Project Role, Team Member Name
- Tasks Section: Task Name, Task Number, Chargeable, Billable, Capitalizable, Parent Task Number, Task Work Type, Task Service Type, Transaction Start Date, Transaction F
Forecasts Integrator: Added Tasks and Resources download filters

17.9.1.0 (06-Aug-2024)

Forecasts Integrator: Added Tasks and Resources download filters

Updated ERP Cloud Toolbox to 17.5.1.0
- Fixed an issue where text in the Product Selection form was not consistent.
- Fixed an issue where Normalize functionality was incorrectly removing rows.
- Fixed an issue where using number values in an alphanumeric column as download criteria could cause an exception error.
- Lists of values that require a search now shows a 'Search' placeholder text.
- Lists of values with search capabilities will now automatically show the drop-down list once a search has been completed. When no results are returned the drop-down will state no data to display.
- Forms will now show a status bar indicating when a search is being performed or validation is occurring.
- Improved a message that indicates when Settings are not applicable for an Integrator.
- Security Update: Updated libraries to the latest patch versions.

17.8.0.0 (13-Jun-2024)

Projects Module: Added new ‘Forecasts’ Integrator.
Assets and Assignments Integrator: Added KFF Dynamic Insertion functionality for the Asset Key.
Events Integrator - Contract Line Field LOV: Changed to a Searchable List.

17.7.0.2 (07-Jun-2024)

Updated ERP Cloud Toolbox to 17.4.1.0

Fixed an issue where form controls were incorrectly resizing when using a Windows Scaling of 125%+
Fixed an issue where values were being returned and processed in the incorrect format, leading to failed uploads and incorrect download results.
Updated Ribbon descriptions.
Security Update: Updated libraries to the latest patch versions.
Amend Contracts Integrator: 'Type' column as download by sheet filter added.
Contracts Integrator: 'Type' column as download by sheet filter added.
Projects Module: Added new Integrator 'Events'.

17.6.0.0 (20-May-2024)

Amend Contracts Integrator: 'Type' column as download by sheet filter added.
Contracts Integrator: 'Type' column as download by sheet filter added.
Projects Module: Added new Integrator 'Events'.

17.5.4.0 (14-May-2024)

Updated ERP Cloud Toolbox to 17.4.0.0
Fixed an issue where the count of printed results from a download was incorrect.
Security Update: Updated libraries to the latest patch versions.

17.4.4.0 (07-May-2024)

Amend Contracts Integrator - Enabled field 'Type' to be downloaded by sheet

Budgets Integrator - Fixed issue that caused an error when creating a planning resource with multicurrency.

Budgets Integrator - Planning Resources Validation: Added section validator to address duplicate combinations of Task Number and Resource Name on the sheet.

Budgets Integrator: Fixed issue that caused the following API Error: "Applying List binding LOV_ProjectNumber with given set of values leads to no matching row for a row of type :ProjectBudgets..."

Award Budgets Integrator - Fixed issue where Award Number is appearing twice in the Data Entry form and the Download via Form.

Contracts Integrator - Fixed issue that caused an exception error: "System.FormatException: Input string was not in a correct format..." due to incorrect Data Type of customer account number related fields. Changed Data Type to 'Text' for fields Bill to Account Number, Ship to Account Number, Sold to Account Number, BP Bill to Account Number, Line Ship to Account Number.

17.4.2.0 (01-May-2024)

Updated ERP Cloud Toolbox to 17.3.0.0:
- Improved printing speeds when downloading.
- Resolved an issue where selecting an entire Excel column then performing any ribbon action would crash Excel.
- Resolved an issue where selecting multiple cell ranges then opening the Data Forms would cause an error.

Budgets Integrator - Fixed API Error caused by Project Name upload parameter. API Error: "Applying List binding LOV_ProjectNumber with given set of values leads to no matching row for a row of type :ProjectBudgets..."

Budgets Integrator - Removed 'Baseline' secondary action as it no longer works with nested payload due to status 'Processing' that locks the update of a version.

Budgets Integrator - Added section 'Plan Lines DFF'.

Award Budgets integrator - Fixed issue where Download Form was crashing.

Project Templates Integrator - Added section 'Customers'.

Financial Plan Resource Assignments Integrator - Planned Quantity Field: changed Upload Data Type and Download Data Type from Integer to Decimal.

17.2.8.1 (28-Mar-2024)

Cost Adjustments Integrator: Added 'Split' adjustment type.
Budgets Integrator: Fixed 'Baseline' action.
Cost Adjustments Integrator: Added new columns 'Creation Date'. New Project Number, New Project Name and New Task Number are not required when Transferring.
Costs Integrator: Added new fields 'Expenditure Ending Date' and 'Creation Date'.
Contracts Integrator: Line Amount upload parameter fix.
Assets and Assignments Integrator: Project Number LOV includes only Capital Projects.

17.2.2.0 (14-Mar-2024)

Assets & Assignments: Added KFF LOVs for Asset Category, Location and Asset Key. BI reports updated.
Financial Plan Resource Assignments: Changed upload batch size to 10 to make uploads faster. Planning Start and End Date to include time-stamp in the upload to allow update from different time-zones.
Planning RBS: Removed upload parameter for Project Name and Number. Added Project Id upload Parameter.
Projects Module: Download form fix.
Project Templates: Project Unit LOV fixed. BI report updated.
Budgets Integrator: Download form long list of values changed to short list.
Award Budgets Integrator: Download form long list of values changed to short list.

Updated ERP Cloud Toolbox to 17.0.2.0
Provided the ability for Module Integrators to now download using criteria at lower sections where applicable. Modules will need to be enhanced to adopt this functionality.
Improved error messaging on download when no results were returned.
Resolved an issue when Global DFFs that contain special characters would cause an error on upload.
Fixed an issue where removing a section that relates to another would cause an error on download.
Security Update: Updated libraries to the latest patch versions.
Budgets Integrator: Changed batched payload to nested payload.
Costs Integrator: 'Transaction Status' List of Values on submit form fix.

16.10.0.1 (17-Jan-2024)

Updated ERP Cloud Toolbox to 16.5.4.0

* Added the ability to restrict access to integrators at the site and or user levels.
* Fixed an issue where Normalising was not applying to all sections.
Project Templates Integrator: Added two columns 'Task Service Type' and 'Task Work Type'.
Financial Projects: Fixed upload parameter for Task Work Type and Task Service Type.
Financial Plan Resource Assignments Integrator: Data type for Planning Start Date and Planning End Date changed to Date Time.
Costs & Cost Adjustments Integrator: Added column 'Project Role'.
Assets & Assignments Integrator: Added columns 'Reverse Flag' and 'Capital Hold Flag'.

16.8.9.0 (04-Dec-2023)

Project Templates Integrator: Added new section Team Members to Project Templates integrator
Financial Plan Resource Assignments Integrator: Removed Task Name upload parameter from 'Resource Assignments' section.
Financial Projects Integrator: Added columns 'Process Cross-Charge Transactions for Labor', 'Labor Transfer Price Schedule', 'Labor TP Fixed Date', 'Process Cross-Charge Transactions for Nonlabor', 'Nonlabor Transfer Price Schedule', 'Nonlabor TP Fixed Date. The minimum BI report version is 14.0.4.

16.7.2.0 (10-Nov-2023)

Projects Module: Settings form fields' name changed.
Financial Projects Integrator: 'Team Member Name' list of values fixed.

16.7.0.0 (06-Nov-2023)

Planning RBS Integrator: Fixed Project Number and Project Name List of value to include Project Templates.
Budgets Integrator: Fixed Project Number List of value to include Project Templates.
Cost Adjustments Integrator: Added Project Name columns and Fixed the Expenditure Type list of value issues.
Financial Resource Assignments Integrator: Renamed 'Plan Lines DFF' to 'Planning Amounts DFF'.
Budgets Integrator: Added planning dates in resource section for budgets integrator.
Costs Integrator: Process Through Expenditure Item Date field is mandatory.
Amend Contracts Integrator: Bug Fixes.

16.5.5.0 (18-Oct-2023)

Amend Contracts Integrator: Bug Fixes.
Contracts Integrator: Removed Risk Code column from sheet.

16.5.4.0 (11-Oct-2023)

Contracts Integrator: Removed Risk Code column from sheet.
Contracts Integrator: Added support for contract class 'Agreements'. Added some columns at header to support contract class 'Agreements'. Added support for Party Contacts DFFs. Added header section Currency Conversion.
Planning RBS Integrator: RBS Name is a mandatory column. Added validation - Either Project Name or Project Number must have a value.
Updated ERP Cloud Toolbox to 16.4.1.0
Enhanced our download feature to reduce the possibility of timeouts.
Projects Module: Added new Integrator 'Amend Contracts'.
Projects Module: Added new Integrator 'Contracts'.
Planning RBS Integrator: Added comment to field Allow Changing Primary Flag.
Project Templates Integrator - 'Work Type' field now has an LOV and can be uploaded.
Planning RBS Integrator - Added field 'Allow Changing Primary Flag'. Set this to 'Yes' to avoid the following error message:
'You can't change the primary planning resource breakdown structure because the project has task assignments and draft progress.'

16.2.0.0 (23-Aug-2023)

Updated ERP Cloud Toolbox to 16.2.0.0

Fixed an issue where the Login form would fail when attempting to log in.

16.1.0.0 (19-Jul-2023)

Financial Plan Resource Assignments: Fixed Resource Name LOV issue in create mode.
Updated ERP Cloud Toolbox to 16.0.1.0

Improved download stability.
Fixed an issue where data forms would add a timestamp to descriptive flexfield date fields.
Fixed an issue where other Excel Add-in ribbon buttons would appear in the More4apps ribbon tab.
Security Update: Updated libraries to the latest patch versions.

15.2.1.0 (03-Jul-2023)

Financial Projects Integrator: Work Type and Task Work Type fields can now be uploaded
Financial Projects Integrator: Added new 'Rec Intercomp and Interproj Inv' field

15.0.0.3 (09-Jun-2023)

Updated ERP Cloud Toolbox to 15.0.3.0
Note, from this version onwards, the BI Report installation method has changed. Please refer to the Installation guide for the updated steps.
Improved error handling when BI Reports are missing.
Added additional functionality to support proxy authentication.
Fixed an issue where the upload of DFF Attributes would fail with the error "Attribute (value) is not a valid value." This was due to the configuration of attribute sequences and their ordering.
Fixed an issue where DFF Date values were downloading with a time-stamp, then failing validation during upload.
Fixed an issue where closing the Invalid Login URL warning window would cause the Add-in to freeze.
Security Update: Updated digital certificates

14.2.0.2 (24-May-2023)

Financial Projects Integrator: Team Member Name format for upload is changed to same as download.
Updated Project reports to 14.0.1
Updated ERP Cloud Toolbox to 14.1.2.0

Improved messaging for missing Oracle privileges.
Improved messaging to handle when a session expires.
Security Update: Updated libraries to the latest patch versions.

14.1.0.3 (20-Apr-2023)

Projects Module: Bug Fixes.

14.1.0.2 (18-Apr-2023)

Projects Module: Added new Integrator 'Project Templates';
Financial Projects Integrator: Bug Fixes.

14.0.1.5 (27-Mar-2023)

Financial Projects Integrator: Bug Fixes.

14.0.1.2 (14-Mar-2023)

Financial Projects Integrator: Added columns Burden Schedule at Header and Tasks level.

14.0.0.0 (09-Mar-2023)

Updated ERP Cloud Toolbox to 14.0.3.0

Added a new Machine-level installation option.
Fixed an issue where entering an invalid instance URL in the Login form would cause a circular redirect error.
Security Update: Updated libraries to the latest patch versions.

13.4.1.2 (08-Mar-2023)

Financial Projects Integrator: Removed To and From date validations.
Financial Projects Integrator: Removed upload parameter from the payload for Parent Task Number in update mode. Added Task Manager Person Id hidden column to upload Task Manager Id and removed Task Manager Name from the upload payload.

13.4.1.0 (26-Jan-2023)

Updated ERP Cloud Toolbox to 13.10.0.0

Improved Login browser stability, this also resolves an issue where the browser login window would not appear, or throw a 'Chromium'/'Access is Denied' error exception.

13.3.5.2 (21-Dec-2022)

Financial Projects Integrator: Bug Fix
Financial Projects: Bug Fix
Updated ERP Cloud Toolbox to 13.9.7.0

Added support for NTLM Proxy Authentication
Resolved an issue where upload errors were printing to the wrong rows.
Project Module: Bug fixes

13.3.4.8 (22-Nov-2022)

Projects Module: Bug Fix.

13.3.4.7 (21-Nov-2022)

Projects Module: Implemented Create/Update Records. Added Create and Update Upload Actions. Bug fixes.

Updated ERP Cloud Toolbox to 13.9.4.0

Resolved a login error that occurs when logging in to 22D instances.

13.3.3.0 (07-Nov-2022)

Financial Projects Integrator: Added new section ' Provider Business Units'.
Updated ERP Cloud Toolbox to 13.9.4.0

Resolved a login error that occurs when logging in to 22D instances.
Projects Module: Merged 'Budgets - Period-Phased' and 'Budgets - Non-Phased' into one integrator called 'Budgets'.
Updated ERP Cloud Toolbox to 13.9.3.0
Resolved an issue on login incorrectly prompting for client certificates.
Fixed an issue where incorrect Upload Action values were defaulting into sections where the value was not applicable.
Security Update: Updated libraries to the latest patch

13.3.1.4 (03-Nov-2022)

Projects Module: Merged 'Budgets - Period-Phased' and 'Budgets - Non-Phased' into one integrator called 'Budgets'.
Updated ERP Cloud Toolbox to 13.9.3.0
Resolved an issue on login incorrectly prompting for client certificates.
Fixed an issue where incorrect Upload Action values were defaulting into sections where the value was not applicable.
Security Update: Updated libraries to the latest patch versions.

13.3.0.5 (25-Oct-2022)

Financial Projects Integrator: Legal Entity is Read Only now due to webservice error.
Financial Projects Integrator: Added Person Number LOV in Team Member Section - Fixed issue where Team member name LOV showing multiple records.
Financial Projects Integrator:: Bug Fix

13.3.0.2 (03-Oct-2022)

Financial Projects Integrator: Added new section 'Customers'.

13.2.2.0 (21-Sep-2022)

Updated ERP Cloud Toolbox to 13.9.2.0

Resolved an issue where worksheets would not generate correctly if the Settings Form was previously opened and closed without modifying any values (Only applies to Integrators that use Settings).
Updated Security Certificates
Security Update: Updated libraries to the latest patch versions.
Financial Projects Integrator: Added Delete functionality
Costs Integrator: Added new field Unmatched Negative Trans

13.2.1.4 (07-Sep-2022)

Costs Integrator: Added new field Unmatched Negative Trans
Projects Module: Bug Fixes.
Costs Adjustments Integrator: Added 'Transfer' Adjustment Type.
Updated ERP Cloud Toolbox to 13.9.0.0
Added support for additional Create and Update Upload Actions
Fixed an issue where Normalize formatting would remove rows unexpectedly.
Security Update: Updated libraries to the latest patch versions.

13.2.1.3 (05-Sep-2022)

Projects Module: Bug Fixes.
Costs Adjustments Integrator: Added 'Transfer' Adjustment Type.
Updated ERP Cloud Toolbox to 13.9.0.0
Added support for additional Create and Update Upload Actions
Fixed an issue where Normalize formatting would remove rows unexpectedly.
Security Update: Updated libraries to the latest patch versions.
Projects Module: Added new Integrator 'Award Budgets'
Financial Projects Integrator: Added new section 'Project Attachments'
Costs Integrator: Renamed column 'Accrual Batch' to 'Accrual Item'

Updated ERP Cloud Toolbox to 13.8.3.0:
Improved form rendering.
Added Denormalize and Normalize support.
Fixed an issue where using an Integrator after being inactive for an elapsed time would cause a 401 un

13.1.8.3 (18-Jul-2022)

Projects Module: Added new Integrator 'Award Budgets'
Financial Projects Integrator: Added new section 'Project Attachments'
Costs Integrator: Renamed column 'Accrual Batch' to 'Accrual Item'

Updated ERP Cloud Toolbox to 13.8.3.0:
Improved form rendering.
Added Denormalize and Normalize support.
Fixed an issue where using an Integrator after being inactive for an elapsed time would cause a 401 unauthorized error.
Security Update: Updated libraries to the latest patch versions.

13.1.6.10 (09-Jun-2022)

Projects Module: Added new Integrator 'Financial Plan Resource Assignments'.
Costs integrator: Fixed bugs.
Financial Projects Integrator: Added new column 'Proj Allow Cross Charge Flag'.

13.1.5.8 (31-May-2022)

Projects Module: Resolved issue when assigning assets and transaction controls to a duplicate person name.

Updated ERP Cloud Toolbox to 13.7.1.0

Added support to allow Module installations without an internet connection. Please contact More4apps if this is desired as additional files will be required.
Fixed an issue where blank rows were unexpectedly inserted during download.
Security Update: Updated libraries to the latest patch versions.

13.1.5.5 (13-May-2022)

Projects Module:
- Added new Integrator 'Cost Adjustments'
- Removed section 'Adjustments' from the Costs Integrator
- Updated ERP Cloud Toolbox to 13.6.4.0
Fixed an issue where uploading multiple Descriptive Flexfield Contexts in the same section would fail. Note, this requires updating the Common BI Reports to version 1.6.5

13.1.4.12 (29-Apr-2022)

Updated ERP Cloud Toolbox to 13.5.0.0

Added support for required Descriptive Flexfield attributes.
Fixed an issue where large numbers of criteria when downloading via sheet would cause a 404 error.
Fixed an issue where Descriptive Flexfield attributes would not upload or download when various Display Type configurations were used.

13.1.4.11 (13-Apr-2022)

Projects Module: Added new Integrator 'Budgets - Period-Phased'

Costs integrator: Added columns to the sheet

Updated ERP Cloud Toolbox to 13.4.10.0
Added support that ensures Read-Only DFF attributes are not overwritten.
Added the Context Code attribute to the DFF Context lists of values dropdown.
Fixed error on 22A cloud instances where the "Alternate Login" would fail.

Updated ERP Cloud Toolbox to 13.4.11.0
Added support for maximum length validation on Descriptive Flexfields.
Fixed an issue when multiple attachments were uploaded at once. Please note, that this requires updating the Common BI Reports to 1.6.4.
Fixed an issue when characters were being used in numeric Descriptive Flexfield Attributes.

13.1.3.0 (21-Mar-2022)

Costs Integrator: Added 4 Adjustment Types:
Set to capitalizable
Set to noncapitalizable
Set to billable
Set to nonbillable

13.1.2.1 (15-Mar-2022)

Costs Integrator: Bug fix for Billable and Capitalizable Flags

13.1.2.0 (25-Feb-2022)

Financial Projects Integrator: Added a new section ‘Baseline’ to set the Project Plan to Baseline, create a Budget Version and Baseline that budget.

13.1.1.10 (10-Feb-2022)

Financial Projects Integrator: Download form Category LOV fix.

13.1.1.9 (08-Feb-2022)

Updated ERP Cloud Toolbox to 13.3.2.0 with the following changes:
Fixed ESS Refresh exception caused by refreshing a sheet with duplicate identifier values.
Fixed validation exception caused by lists of values with multiple dependent columns causing the query size to exceed the limit.
Integrator caches are now cleared when the Diagnostics is toggled.

Projects Module:
Added 'Budgets - Non-Phased' Integrator

13.0.1.2 (19-Jan-2022)

Financial Projects Integrator: Bug Fix in download form's Team Members BI Report
Financial Projects Integrator: Bug Fix in download form's Team Members BI Report

13.0.1.0 (22-Dec-2021)

Financial Projects Integrator:
Standards Implementation of Project Name/Number Columns.
Bug fixes.

13.0.0.13 (14-Dec-2021)

Updated ERP Cloud Toolbox to 13.0.7.0 with the following changes:
Updated Common BI Reports to 1.6.2 to fix "API Error: Invalid Attribute" error due to the Attribute Table Column Name rather than the Segment Code being used.
Removed unnecessary licensing web service calls to improve security and performance.
Fixed Add-in freezing during initialisation due to PAC proxy files being used.
Added support for DFF Subset value sets.

Financial Projects Integrator:
Added 'Project From' and 'Project To' criteria on the Download Form.
Bug fixes.

13.0.0.11 (09-Dec-2021)

Costs Integrator:
Added Adjustment Type 'Reverse'.

Financial Projects Integrator:
Either Project Number or Name are required in Update mode.
Added Project Number From/To fields on download form.
Added Source Template Name field on download form.

13.0.0.7 (25-Nov-2021)

Updated ERP Cloud Toolbox to 13.0.3.0 with the following changes:
Fixed issue where DFF attributes could not be found during validation when the context code was different from the context display name.
Added SSO URL not found message to indicate that the base instance URL must be used.
Fixed issue where table based DFF attributes would not upload and download correctly.

Updated ERP Cloud Toolbox to 13.0.2.0 with the following changes:
Fixed license exception when downloading with a large number of results.

Updated ERP Cloud Toolbox to 13.0.1.0 with the following changes:
Fixed issue where DFF attribute field controls were not being displayed on section forms.
Fixed issue where validation LOV caches were being lost when re-uploading data.

Updated ERP Cloud Toolbox to 13.0.0.0 with the following changes:
Updated target framework to .NET 4.8 Framework, installation setup process will install the framework as required.
Added Gateway Timeout Error message prompt during download via form/sheet to handle download timeouts.
Fixed a download form issue where numeric values would cause web service errors when %25 was entered.
Updated Oracle REST Batch message to include the amount of rows being uploaded.
Changed the ESS Concurrent Form title from Submit to Import.
Added processing message for ESS Refreshing.
Fixed exception caused by a DFF attribute name having the same web service parameter name as another field.

12.0.4.9 (18-Nov-2021)

Financial Projects Integrator:
Added 'Source Template Name' and 'Category' filter on Download form.
Bug fixes.

12.0.4.1 (12-Nov-2021)

Financial Projects Integrator:
Class Category Field LOV - Fixed issue where Category is not assigned to all the Project Types.

12.0.3.6 (05-Nov-2021)

Updated ERP Cloud Toolbox to 12.4.1.0 with the following changes:
Added Azure AD Conditional Access Support for SSO.
Fixed ESS Import Submission Form date formatting issue causing the import program to fail with a date format error.
Diagnostics now logs SSO information to a separate log file with the suffix .browser.
Updated ERP Cloud Toolbox to 12.4.1.0 with the following changes:
Added Azure AD Conditional Access Support for SSO.
Fixed ESS Import Submission Form date formatting issue causing the import program to fail with a date format error.
Diagnostics now logs SSO information to a separate log file with the suffix .browser.

12.0.3.3 (04-Nov-2021)

Costs Integrator:
Implemented download sources for Processed Costs into the existing Costs integrator.
Added ESS submit Form to Import Costs.
Bug fixes.

12.0.2.0 (06-Oct-2021)

Updated ERP Cloud Toolbox to 12.0.3.0 with the following fixes:
Added localisation support based on the Oracle Default Language preference.
Updated Common BI Reports to 1.6.1 to support REST Framework localisation.
Fixed issue when uploading DFF integer values would return a precision error.
Fixed issue when opening the About form when not registered. On cancelling the registration form the About form would show and cause an exception.
Fixed issue where the registration form cancellation would allow a process to continue.
Fixed issue where the expiration date displayed after registration was in ISO8601 date format.
Fixed 'Verifying Module Licensing' processing form message.
Fixed issue where DFF attribute number columns could not be uploaded when a value set was applied.
Fixed issue where a section with two associated DFFs can cause a duplicate column issue due to setup.

12.0.0.5 (23-Sep-2021)

Updated ERP Cloud Toolbox to 12.0.3.0 to fix Download Via Sheet cartesian results when multiple sheet criteria across different columns were used.
Fixed exception that occurred when initialising value sets.
Fixed download issue where duplicated results would download when using multiple Excel ranges.
DFF attribute controls are now only created for enabled attributes in Oracle.
Upgraded cloud Add-in to allow for Download Sources to be implemented
Projects Module: Added language compliance across all the integrators supporting BI reports and defaulting values.

11.1.2.16 (03-Sep-2021)

Projects Module:
Added new Integrator 'Assets and Assignments'

11.0.0.0 (21-Jul-2021)

Financial Projects Integrator:
Added Transaction Control Section - Project and Tasks Level

10.4.0.3 (28-Jun-2021)

Financial Projects Integrator:
Added Team Member and Role fields in Download Form

10.1.5.1 (18-Jun-2021)

Projects Module:
Added new Integrator 'Costs'

9.0.6.0 (28-Apr-2021)

Financial Projects Integrator:
Task Number Field - Fixed issue where newly created Task Number was giving error on the form when updating.
Added FID, User Guide and Release Notes URLs

9.0.3.0 (15-Apr-2021)

Projects Module:
Added new Integrator 'Financial Projects'