18.0.2.0 (12-Jun-2025)

Items Integrator: Fixed the issue of List Price is rounding to the nearest whole dollar when is decimal.
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.16.3.0 (04-Jun-2025)

Item Integrator:
- Removed REST download source
- Added item SOAP download sources
- Fixed issue with Source Subinventory downloading;
- Resolved uploading issue for Expiration Action and Default Grade fields

Updated ERP Cloud Toolbox to 17.15.0.0
- Added Functionality to Expand or Collapse all Sections and Fields in the Sheet Builder form.
- Removed error message that would occur when attempting some Ribbon Actions when the cursor is above row 10.
- Resolved an issue where List of Value Fields on the Data Entry Form would unintentionally default the first value.
- Resolved an issue where the login prompt would incorrectly reappear after users had already logged in.
- Resolved an unexpected error when using the Normalize functionality.
- Resolved an issue where values in Default row 10 would default unexpectedly.
- Security Update: Updated libraries to the latest patch versions.

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.

17.15.1.0 (25-Mar-2025)

Structures Integrator: Fixed issue where the Integrator was unable to uniquely identify Item Information during validation; Updated BI report version to 3.3.1

17.15.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.

17.14.0.0 (23-Jan-2025)

Product Definition Module: Product Definition reports 3.3.0
- These reports are incompatible with module version 17.12.0.0 (20-Dec-2024) or 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.

17.13.2.4 (16-Jan-2025)

Product Definition Module: Updated Product Definition reports to 3.3.0
- These reports are incompatible with previous versions of the module.
- Minimum report version required for this version of the module.

Item Structures Integrator: Yield Field Validation: Added validation to ensure that the number falls within the range of zero to one
Item Relationships Integrator: Change GTIN Download form Party Name LOV to a loose dependency.
Structures Integrator: Added download filters: Component Item Number, Component Change Notice

17.12.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.
Items Integrator: Improve LOV column labelling. Updated Product Definition reports to 3.2.2
Structures Integrator: Added Explode data columns
Structures Integrator - Reference Designator Field: Changed Reference Designator to LOV for Update
Structures Integrator - Components Section Validation: Improved Component validation
Updated ERP Cloud Toolbox to 17.11.1.0

Security Update: Updated libraries to the latest patch versions.
Item Relationships Integrator - Party Name Field LOV: Made LOV searchable on the Data and Download forms.
Item Relationships Integrator - New Party Name Field LOV: Made LOV searchable on the Data form.
Item Relationships Integrator - Trading Partner Item Field LOV: Made LOV searchable on the Data and Download forms and corrected issue where no expected data may be returned.

17.10.4.1 (15-Nov-2024)

Items Integrator - Removed mandatory field validation on Primary UOM, Tracking UOM, Pricing, Item Description, Item Status, Life Cycle Phase

17.10.3.2 (06-Nov-2024)

Item Integratoe - Updated Item Class BI report
Items Integrator: Improve the Lot Control column validation message clarity
Product Definition: Rename constants and message resources files in the fold directory for better clarity

17.10.2.0 (25-Oct-2024)

Items Integrator : Added a New Item Number field to allow for item number to change after creation.

Product Definition:
Updated ERP Cloud Toolbox to 17.9.1.0

Security Update: Updated libraries to the latest patch versions.

17.9.0.0 (03-Oct-2024)

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.
Structures Integrator - Fixed issue where some valid Substitute Components were failing validation.

17.8.0.0 (03-Sep-2024)

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
Product Definition: Added Sheet Designer column descriptions for Items, Item Relationships and Structures integrators.
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

17.6.4.0 (23-Aug-2024)

Items Integrator: Item Attachments, Item Revision Attachments section names were amended to fit More4apps naming standards
Items Integrator: Effectivity Control, Stock Locator Control, Allow Purchasing Doc Descr Update, Purchasing Input Tax Classification Code column names were amended to fit More4apps naming standards
Items Integrator: Invoice Enabled Field Validation: Added validation to ensure that it should be either "No" or blank when the Invoiced field is "No."
Item Structures Integrator: Structure Header DFF Co
Product Definition Module: Fixed an issue where validation could result in the following exceptions: '...KeyNotFoundException: Report column [FIELD_ID] does not exist in [Field Number] fields report. Report Data: ...', 'InvalidOperationException: Field [Field Name] LOV column [DESCRIPTION] does not exist in response. --->...', '...KeyNotFoundException: Report Field(s) [FIELD_ID] not found in Field

17.6.0.0 (05-Aug-2024)

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.

Items Integrator - Item Attachment Upload Action field Defaulting: Fixed bug where 'Item Attachment Upload Action' was not being defaulted from 'Item Upload Action' values of 'Create records' or 'Update records'.

Items Integrator - Item Revision Attachment Upload Action field Defaulting: Fixed bug where 'Item Revision Attachment Upload Action' was not being defaulted from 'Item Upload Action' values of 'Create records' and 'Update records'.

17.5.0.0 (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.

17.4.0.0 (15-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.3.0.0 (09-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.

17.0.4.0 (14-Mar-2024)

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.

Product Definition : Added comment on Upload action labels

Items Integrator: Update column names to match current Oracle

Product Definition:
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.

16.6.3.0 (07-Feb-2024)

Product Defnition:
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.

Items Integrator:
Updated Column names to better match Oracle

Product Definition:
Updated BI minimum version from 2.0.0 to 2.0.1
Made defaults from the BI Report language dependent

16.2.0.0 (23-Aug-2023)

Product Defnition:
Updated ERP Cloud Toolbox to 16.2.0.0

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

16.0.2.0 (19-Jul-2023)

Structure Integrators: Fixed the issue of Structure Ref Designator DFF Context not able to download.

Product Definition: 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.

Item Integrator: Removed the Item Number validation like 'You must enter at least 3 characters in the Item Number field '

15.0.4.0 (09-Jun-2023)

Cloud Product Definition Version 15.0.3.0 (09-Jun-2023)

Note, from this version onwards, the BI Report installation method has changed. Please refer to the Installation guide for the updated steps.

Updated ERP Cloud Toolbox to 15.0.3.0
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.

Items Integrator: Changed the field 'Base Model' from text box to searchable list;

14.1.1.0 (08-May-2023)

Product Definition: 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

Item Structures Integrator: Added the functionality to upload and download the Reference Designator Quantity Related flag

14.0.0.0 (08-Mar-2023)

Product Definition:
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.11.1.0 (23-Feb-2023)

Product Definition:
Updated ERP Cloud Toolbox to 13.10.2.0
Security Update: Updated libraries to the latest patch versions.
Fixed an issue where cells that appear blank were being validated.
Fixed an issue where Excel Formulas were being overwritten when using the 'Create/Update records' Upload Actions.
Fixed an issue where Download would not print number values that exceeded 15 characters.

13.11.0.0 (27-Jan-2023)

Product Definition:
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.10.5.0 (09-Dec-2022)

Items Integrator:
Added the functionality to upload and download the Asset Category

Item Relationships Integrator:
The batch size changed from 20 to 10

13.10.4.3 (09-Dec-2022)

Product Definition:
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.

13.10.4.2 (02-Dec-2022)

Item Structures Integrator:
Fixed the form opening issues when there is no data on the sheet

Item Relationships Integrator:
Added Spoke System section

13.9.10.0 (10-Nov-2022)

Product Definition:
Updated ERP Cloud Toolbox to 13.9.4.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.9.9.0 (18-Oct-2022)

Product Definition:
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.
Item Integrator: Updated the error message for copy section columns and Lot Attribute Flag

13.9.8.17 (08-Sep-2022)

Items Integrator:
Added Copy functionality onto Items Integrator

13.9.7.8 (11-Aug-2022)

Item Structures Integrator:
Fixed issues where Structure Name List Of values on the download form showed multiple duplicated entries.
Fixed the download data type mismatch errors on the Structure Change Notice and Component Change Notice fields.

13.9.7.6 (09-Aug-2022)

Product Definition:
Updated ERP Cloud Toolbox to 13.9.1.0
Fixed an issue where date time fields were not printing correctly on download.
Fixed an issue where 'Create records' and 'Update records' upload actions were printing to unexpected sections.

Product Definition:
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.

Fixed an issue where the 'Create records' and 'Update records' upload actions were printing to unexpected sections.
Changed the column comments to meet More4apps standards.

Item Structures Integrator:
Added new download sources 'WhereUsed', 'Implode'and 'Explode'
Added validation to the new download sources to ensure nothing is returned to the sheet when item number is null.

13.9.4.6 (05-Jul-2022)

Item Integrator:
Fixed the issue causing the '[Item Number] The Item Number must be blank for child organization autogenerated ' validation error during upload, when trying to upload Child organization with autogeneration.

Item Relationships Integrator:
Renamed the DFF Attributes column to meet More4apps standards.

13.9.4.0 (22-Jun-2022)

Product Definition:
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.9.3.0 (08-Jun-2022)

Product Definition:
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.

Items Integrator:
Item Status:Fixed issue causing API error during upload; API Error: The value Active Inventory of the attribute ItemStatusValue isn't valid. (EGP-2776160) [EGP:::EGP_CMN_ATTR_INVALID_VALUE] [1 Batched Items(s)].

13.9.2.1 (26-May-2022)

Product Definition:
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
Fixed an issue where Form List of Value Dropdowns would remain after closing the form.
Fixed an issue where Windows Display Scaling settings would cut off button labels.
Added additional functionality to allow for additional Download options in future.

Item Relationships Integrator:
Added the functionality to upload and download the Trading Partner Item Relationship.

13.8.2.0 (11-Apr-2022)

Product Definition:
Updated ERP Cloud Toolbox to 13.4.11.0 with the following changes:
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.

Items integrator:
Fixed issue with the download criteria in the 'Download via Form'.

Item Structures integrator:
Added validation to stop Substitute Component being the same as Component. Used validatorNotEqual. Component is already checked against Header Item

Product Definition:
Updated ERP Cloud Toolbox to 13.4.10.0 with the following changes:
Added support that ensures Read-Only DFF attributes are not overwritten. Please note, this requires updating the Common BI Reports to 1.6.3.
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.

13.7.3.0 (03-Feb-2022)

Product Definition:
Fixed issue where ERP Cloud Toolbox Add-in was not being updated correctly during installation.

13.7.2.0 (28-Jan-2022)

Product Definition:
Corrected version number
Updated ERP Cloud Toolbox to 13.3.2.0 with the following changes:
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.

Items Integrator:
Fixed the issue of Incorrect 'Item Description' List Value in the download form

13.7.1.1 (13-Dec-2021)

Product Definition:
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 initialization due to PAC proxy files being used.
Added support for DFF Subset value sets.

Item Relationships Integrator:
Removed Mandatory for column 'Party Type ' and 'Party Name' in GTIN section; Added Customized validation for Party Name; Added Party Id information in the column 'Party Name'.
Added a Boolean type dependency

Items Integrator:
Enable Global DFF with latest Add-in
Fixed the issue of Category Start Date must be greater than current date validation When deleting

12.18.0.0 (15-Nov-2021)

Product Definition:
Added the new Item Relationships integrator.

Item Structures Integrator:
Removed mandatory requirements from the download form "Item Number From" field.
Removed Upload Action dependence from the Structure Name LOV validation.

12.1.1.0 (23-Sep-2021)

Product Definition:
Updated Add-in 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 initializing value sets.
Fixed download issue where duplicated results would download when using multiple Excel ranges.
DFF attribute controls are now only created for enabled
Cloud Add-in Download Sources Upgrade

Item Structures Integrator:
Reference Designator Form: Enabled the form control for the Description field
Correct DFF Number/Date/DateTime issues in Structure Integrator

Items Integrator:
Changed Revision DFF context name
Fixed the DFF Attributes Number /Date /Datetime issue in Item Integrator with latest Add-in

11.1.0.0 (21-Jul-2021)

Product Definition:
Updated Add-in to 11.1.6.0 with new Copy Active Sheet feature
Hiding form controls when the associated column is not on the sheet
Fix for when child section rows could not be reprocessed when the parent section row has been accepted.

Item Structures Integrator:
Item information now defaults correctly for Create Upload
Fix issue with Item_Name validation
Add Item Descriptions into the Item LOV for All sections (Header, Component, and Substitute).

10.1.1.1 (28-Jun-2021)

Items Integrator:
Position the 'Supply Subinventory' column before 'Supply Locator' column

10.0.13.1 (04-Jun-2021)

Initial Release:
Added Items Integrator
Added Item Structures Integrator