3.2.44 (25-Feb-2025)

Fixed the issue of Item Number contains false delimeter.
Item mode: Fixed the list of value issue and downloading issue when Base Model is KFF.

3.2.43 (25-Feb-2025)

Enhanced the Wizard - It will now function using the right-click-menu, without the More4apps ribbon tabs.

3.2.42 (06-Jan-2025)

Fixed bug where the Wizard would not function and displayed the following message after login 'The earliest version allowed of Item Extension Wizard is x.xx.x This version is x.xx.x. Please contact your administrator'.

3.2.41 (13-Dec-2024)

Added fix for Error: ORA-06550 PLS-00172: string literal too long.

3.2.40 (27-Nov-2024)

Item Mode: Fixed the type mismatch error message when Minimum Order Quantity is Blank.

3.2.40 (27-Nov-2024)

Item Mode: Fixed the type mismatch error message when Minimum Order Quantity is Blank.

3.2.39 (13-Nov-2024)

Cross Reference: Fixed the issue of Column [Cross Ref Context] has unresolved substitutions.

3.2.38 (08-Oct-2024)

Added Default Browser Login option.

3.2.37 (15-Aug-2024)

Added [BLANK] upload values for Expense Account and Encumbrance Account.

3.2.36 (07-Aug-2024)

Improved download performance of Categories section.
Added User item Type as download by sheet filter.

3.2.35 (02-Jul-2024)

Internal update.

3.2.34 (28-May-2024)

Internal update.

3.2.33 (28-May-2024)

Items mode: Removed Default Material Status column from default templates.

3.2.32 (16-Apr-2024)

Internal update.

3.2.31 (18-Mar-2024)

Added the new optimiser hint - opt_estimate; Added Dynamic Sampling hint specifically to the Item in Master Org query during Item Number validation.

3.2.30 (15-Mar-2024)

Transaction Default mode: Fixed the color changes issue after uploading.

3.2.29 (14-Mar-2024)

Organisation and Description Language Translation modes: Fixed the color not changing after uploading.

3.2.28 (05-Mar-2024)

Fixed error with templating when trying to copy immediately after editing by sheet.

3.2.27 (28-Feb-2024)

Internal update.

3.2.26 (27-Feb-2024)

Made Item 'Category Set' LOV searchable on download form.

3.2.25 (26-Feb-2024)

Made Item 'Category Set' LOV searchable on data form.

3.2.24 (05-Feb-2024)

Internal update.

3.2.23 (05-Feb-2024)

Improved downloading performance.

3.2.22 (16-Jan-2024)

Fixed the Item Context form reference issue.

3.2.21 (16-Jan-2024)

Item mode: Fixed the issue of process id query performance.

3.2.20 (08-Dec-2023)

Items mode: Made 'Locator' LOV searchable.
Transaction Defaults mode: Made 'Subinventory' and 'Locator' LOVs searchable.

3.2.19 (22-Nov-2023)

Specification mode: Made the Action column mandatory.

3.2.18 (22-Nov-2023)

Internal update.

3.2.17 (21-Nov-2023)

Internal update.

3.2.16 (20-Nov-2023)

Internal update.

3.2.15 (16-Nov-2023)

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

3.2.14 (06-Nov-2023)

Item mode: Added column Grade Control and Default Grade in R12 and above.

3.2.13 (13-Oct-2023)

Maintain Categories mode: Fixed the form references issue.

3.2.12 (10-Oct-2023)

Internal update.

3.2.11 (10-Oct-2023)

Added new digital signature.

3.2.10 (13-Sep-2023)

Fixed the incorrect validation and updating when stockable flag is No and Inventory flag is empty.

3.2.09 (11-Sep-2023)

Internal update.

3.2.08 (06-Sep-2023)

Cross Reference mode: Added function INV_INVIDITEM_XREF.

3.2.07 (06-Sep-2023)

Cross Reference mode: Fixed the function required issues.

3.2.06 (22-Aug-2023)

Internal update.

3.2.05 (16-Aug-2023)

Internal update.

3.2.04 (15-Aug-2023)

Internal update.

3.2.03 (15-Aug-2023)

Internal update.

3.2.02 (15-Aug-2023)

Cross Reference mode: Updated error message.

3.2.01 (01-Aug-2023)

Maintain Categories mode: Fixed Run-time error.

3.2.00 (25-Jul-2023)

Tidied up the dependence between Copy from item and columns: Copy Categories and copy Catalog.

3.1.99 (12-Jul-2023)

Item mode: Fixed the download source defaulting issues.

3.1.98 (12-Jul-2023)

Updated error message when extension package not installed, but profile is on.

3.1.97 (12-Jul-2023)

Internal update.

3.1.96 (07-Jul-2023)

Updated extension package installing file.

3.1.95 (04-Jul-2023)

Added the IEW Cross Reference extension package into the Item Wizard Extension Package, and added the extension package into Item Wizard Cross Reference mode.
Added the additional extension package into the About form.
Merged the IW extension package and item number auto generation into one extension package, and added the extension packages features into IW Cross Reference mode.
Set up the additional extension package information in the About form.

3.1.94 (27-Jun-2023)

Internal enhancement.

3.1.93 (20-Jun-2023)

Fixed unable to update logo issues in Template123.

3.1.92 (13-Jun-2023)

Item mode: Added field 'Level of IB Tracking'.

3.1.91 (12-Jun-2023)

Internal update.

3.1.90 (12-Jun-2023)

Internal update.

3.1.89 (09-Jun-2023)

Internal update.

3.1.88 (24-May-2023)

Internal update.

3.1.87 (12-May-2023)

Item mode: Improved the refresh performance.

3.1.86 (08-May-2023)

Internal update.

3.1.85 (08-May-2023)

Fixed the global DFF validation error while the DFF Attributes not in Global DFF.

3.1.84 (08-May-2023)

Internal update.

3.1.83 (05-May-2023)

Fixed the item search issues in Item Relationships download form.

3.1.82 (03-May-2023)

Item Relationships mode: Fixed the performance issues while searching relation item.
Fixed download non related item records issues.

3.1.81 (02-May-2023)

Item Relationships mode: Added mode. Added patch needed.
Item mode: Fixed the downloading issue when organization code starts from '000'.

3.1.80 (17-Apr-2023)

Item Relationships mode: In special folder fixed the download issues.

3.1.79 (05-Apr-2023)

Related Item mode: Added DFF upload.
Updated the item related mode name to the Item Relationships.

3.1.78 (05-Apr-2023)

Removed the Global Attribute 20-30 on the record sheet.

3.1.77 (05-Apr-2023)

Item mode: Fixed the context DFF form reference issue.

3.1.76 (05-Apr-2023)

Item mode: Fixed the form reference issues.

3.1.75 (16-Mar-2023)

Internal update.

3.1.74 (03-Mar-2023)

Internal update.

3.1.73 (24-Jan-2023)

Item mode: Fixed the overflow issue while downloading more than 32k.

3.1.72 (17-Jan-2023)

Fixed issue 'API Error: More4apps Item Wizard: Due to an Oracle API limitation, updating duplicate GTIN Cross Refer3ences are not supported while deleting GTIN in Cross Ref mode.'

3.1.71 (05-Jan-2023)

Internal update.

3.1.70 (21-Dec-2022)

Fixed error 'Invalid Number' while updating the Supply Locator to Null.

3.1.69 (14-Dec-2022)

Internal update.

3.1.68 (08-Dec-2022)

Fixed issue with error message - Error 91 (Object variable or with block variable not set) in procedure BuildSectionForm of Module cmRSInitialise Form.

3.1.67 (08-Dec-2022)

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

3.1.66 (08-Dec-2022)

Fixed the issues concurrent submission window SQL error in 11i.

3.1.65 (05-Dec-2022)

Item mode: Fixed the user item type form references issue.

3.1.64 (05-Dec-2022)

Item mode: Fixed issue Item type form references.

3.1.63 (14-Nov-2022)

Internal update.

3.1.62 (07-Nov-2022)

Cross Reference mode: Fixed the issue of not able to find the item with the error message [Item Number] Unable to find a match for the value you entered'.

3.1.61 (14-Oct-2022)

Item mode: Fixed the Item Status defaulting issue when the row doesn't have data.

3.1.60 (13-Oct-2022)

Added validation for Copy From Item while updating an Item.

3.1.59 (13-Oct-2022)

Add Copy Category and Copy Catelog to Item Wizard C3.

3.1.58 (13-Oct-2022)

Internal update.

3.1.57 (13-Sep-2022)

Internal update.

3.1.56 (13-Sep-2022)

Specification mode: Added function required.

3.1.55 (13-Sep-2022)

Specification mode: Swap the order of Item Number and Specification Name.

3.1.54 (12-Sep-2022)

Specification mode: Fixed issue with child section processing, when parent section fails.

3.1.53 (12-Sep-2022)

Specification mode: Fixed issue with child section processing, when parent section fails.

3.1.52 (12-Sep-2022)

Specification mode: Fixed issue with item specification status error while adding child section.

3.1.51 (08-Sep-2022)

Item mode: Fixed issue with trial data setting.

3.1.50 (07-Sep-2022)

Updating Licencing Modules.

3.1.49 (05-Sep-2022)

Internal update.

3.1.48 (05-Sep-2022)

Specification mode: Fixed the issue with incorrect validation for the text type spec element.

3.1.47 (01-Sep-2022)

Specification mode: Added text comparison for the limit columns.

3.1.46 (01-Sep-2022)

Specifications mode: Fixed the issue of Limit columns types.
Fixed the Accept issue of status of Spec Element section when it errors.

3.1.45 (31-Aug-2022)

Fixed the issue of spec element status updated to Accept when using spec reference features.

3.1.44 (31-Aug-2022)

Specifications mode: Fixed the issue with deleting parents section validation.

3.1.43 (30-Aug-2022)

Specifications mode: Added DFF setting.

3.1.42 (30-Aug-2022)

Specifications to move from IEW to IW.

3.1.41 (24-Aug-2022)

Item mode: Fixed the issue with error message - Column [Item Context] has unresolved substitutions:[:MTL_SYSTEM_ITEMS.ORGANIZATION_ID].

3.1.40 (15-Aug-2022)

Fixed the Organization code limit to 1000 in all Download forms.

3.1.39 (15-Aug-2022)

Org Assignment mode: Fixed the issue of org code column as a drop-down LOV with limits.

3.1.38 (12-Aug-2022)

Item mode: Fixed the issue where there is 1000 limit on the LOV cache for Org code.

3.1.37 (03-Aug-2022)

Internal update.

3.1.36 (08-Jul-2022)

Internal update.

3.1.35 (17-Jun-2022)

Item mode: Added the all revision to the Download setting form.

3.1.34 (17-Jun-2022)

Cross Reference mode: Fixed the form download SQL error for organization column.
Fixed the Explode ribbon issue.

3.1.33 (16-Jun-2022)

Cross Reference mode: Removed Create All and Update All from the Cross Ref Upload Action.

3.1.32 (16-Jun-2022)

Cross Reference mode: Fixed the issue of error message like Item Number unable to uniquely identify value from SQL.

3.1.31 (14-Jun-2022)

Cross Reference mode: Added cross reference DFF updating feature.

3.1.30 (07-Jun-2022)

Item mode: Fixed the SQL error when downloading via sheet

3.1.29 (02-Jun-2022)

Cross Reference mode: Fixed error message type.

3.1.28 (27-May-2022)

Cross Reference mode: Fixed the issue with Download button disappearing from the top ribbon.

3.1.27 (27-May-2022)

Added 'Cross Reference' mode to the Wizard.

3.1.26 (23-May-2022)

Updated the error message when item is not transactable item.

3.1.25 (20-May-2022)

Transaction mode: Fixed issue when uploading a non 'Transactable' item the API fails with error.

3.1.24 (20-May-2022)

Description Translations mode: Fixed issue when opening Download form.

3.1.23 (17-May-2022)

Internal update.

3.1.22 (06-May-2022)

Items mode: Fixed updating issues caused by the form references issue.

3.1.21 (06-May-2022)

Fixed the issue with not being able to download with All Columns.

3.1.20 (03-May-2022)

Updated the core to the latest version to fix the type on the ribbon.

3.1.19 (28-Apr-2022)

Item mode: Fixed the incorrect value for Contract Duration Period.

3.1.18 (20-Apr-2022)

UDA mode: Fixed error message - Item does not exist within the column record sheet after changing Item Name to Item Number.

3.1.17 (11-Apr-2022)

Transactions Default mode: Added security function

3.1.16 (08-Apr-2022)

Fix for One Drive saving issue by removing code from the on_save event.

3.1.15 (05-Apr-2022)

UDA mode: Change the name of Item to Item Number.

3.1.14 (04-Apr-2022)

Internal update.

3.1.13 (11-Mar-2022)

Fixed the issues with Category not KFF.

3.1.12 (10-Mar-2022)

Fixed the issue with BLANK value in the Buyer and Receipt Routing columns.

3.1.11 (03-Mar-2022)

Fixed download opening issues.

3.1.10 (03-Mar-2022)

Update the field name to 'Include Inactive Org Records' in Item Download form.

3.1.09 (03-Mar-2022)

Fixed the issue with the Download source LOV not defaulting to 'Item'.

3.1.08 (08-Feb-2022)

UDA and Org Assignment modes: Fixed the issue for receiving error message: "ORGDEF'."DISABLE_DATE": invalid identifier.

3.1.07 (20-Jan-2022)

Custom Query update with SQL injection fixes.

3.1.06 (18-Jan-2022)

Internal update.

3.1.05 (12-Jan-2022)

Fixed the issue when creating a new sheet.

3.1.04 (12-Jan-2022)

Fixed issue with Request Entity too Large when download large amounts of data.

3.1.03 (07-Jan-2022)

Added an option to include/exclude inactive org while downloading 'Download via Sheet'. Only download items with active organization.
Download via form - Adding another flag 'Include Inactive records'. By default it will be No, which means only download item with Active organization. If it is Yes, it will download items with active and inactive organization.

3.1.02 (20-Dec-2021)

Item mode: Fixed the type mismatch issue.

3.1.01 (29-Nov-2021)

Fixed the issue with description required when creating a child org.

3.1.00 (24-Nov-2021)

Fixed the issue with revision Effective Date Time missing.

3.0.99 (22-Nov-2021)

Fixed the issue with not being able to update Revision in 11i when Template_Name doesn't exist in the revision interface table. Fixed the issue with download from revision interface.

3.0.98 (08-Nov-2021)

Fixed issue with being able to update language translation in child Org.

3.0.97 (06-Oct-2021)

Internal update.

3.0.96 (24-Sep-2021)

Org Assignment mode: Fixed issue after added column IDs.

3.0.95 (24-Sep-2021)

Fixed the issue with Upload Column IDs missing when updated to the latest common.

3.0.94 (23-Sep-2021)

Fixed DFF default override issues.

3.0.93 (06-Sep-2021)

Internal update.

3.0.92 (02-Sep-2021)

Fixed download SQL issues for all columns.

3.0.91 (25-Aug-2021)

Fixed the list value of Receipt Date Action column.

3.0.90 (23-Aug-2021)

Removed external link.

3.0.89 (20-Aug-2021)

Added the Transaction Default Mode (API) onto the IW common 3.

3.0.88 (12-Aug-2021)

Fixed the issue of master/child control validation when primary UOM is not in the sheet.

3.0.87 (05-Aug-2021)

Internal enhancement.

3.0.86 (22-Jul-2021)

Fixed the DFF downloading issue with organization_id form reference setting.

3.0.85 (22-Jul-2021)

Added DFF Substitution for ":STARTUP_INFO.CONTEXT_ORGANIZATION_ID" from the Organization column.

3.0.84 (08-Jul-2021)

Fixed the Description column missing in the sheet when updating.

3.0.83 (04-Jun-2021)

Fixed the process set id issue.

3.0.82 (27-May-2021)

Fixed the issue of wrong validation message for Supply Locator.

3.0.81 (18-May-2021)

Fixed the issue of not being able to update the Container Type and Minimum Fill Percent.

3.0.80 (13-May-2021)

Fixed the issue when Template and Copy from are not in the sheet.

3.0.79 (10-May-2021)

Fixed the issue of download Global Attribute 11-20.

3.0.78 (05-May-2021)

Fixed the issue of process set id searchable issues in Item mode.

3.0.77 (05-May-2021)

Hide the Global Attributes 10 and 20 by default.

3.0.76 (05-May-2021)

Fixed the Global Attributes 11-20 issues in 11i.

3.0.75 (29-Apr-2021)

Added DFF Substitution for ":STARTUP_INFO.CONTEXT_ORG_CODE" from the Organization column.

3.0.74 (16-Apr-2021)

Fixed issue with primary UOM required when template or copy from Item is used.

3.0.73 (12-Apr-2021)

Fixed error 'Invalid character 194'.

3.0.72 (07-Apr-2021)

Internal enhancement.

3.0.71 (16-Mar-2021)

Fixed the issue with Primary UOM.

3.0.70 (12-Mar-2021)

Fixed UDA DFF form issues.

3.0.69 (12-Mar-2021)

Internal enhancement.

3.0.68 (12-Mar-2021)

Internal enhancement.

3.0.67 (12-Mar-2021)

Updated security.

3.0.66 (04-Mar-2021)

Fixed the issue of downloading language in a loop.

3.0.65 (23-Feb-2021)

Internal enhancement.

3.0.64 (23-Feb-2021)

Internal enhancement.

3.0.63 (23-Feb-2021)

Fixed the [BLANK] functionality issue for Starting Lot Number.

3.0.62 (23-Feb-2021)

Fixed the issue with [BLANK] functionality in R12.

3.0.61 (23-Feb-2021)

Fixed the blank issue for the Subinventory column.

3.0.60 (22-Feb-2021)

Internal enhancement.

3.0.59 (22-Feb-2021)

[BLANK] functionality does not work for Default Lot Status.

3.0.58 (22-Feb-2021)

Fixed the issue with concurrent program layout design.

3.0.57 (19-Feb-2021)

Fixed the issue with not checking the minimum product package.

3.0.56 (17-Feb-2021)

Internal enhancement.

3.0.55 (16-Feb-2021)

Internal enhancement.

3.0.54 (28-Jan-2021)

Fixed the issue where getting 400 (Bad Request) error during login.

3.0.53 (22-Jan-2021)

Internal enhancement.

3.0.52 (08-Jan-2021)

Fixed the issue with Blank in decimal type.

3.0.51 (29-Dec-2020)

Fixed the issue with being unable to update the number to null in DB 12.1. version.

3.0.50 (21-Dec-2020)

Removed the UDA ID.

3.0.49 (21-Dec-2020)

Fixed issue with UOM Conversion.

3.0.48 (02-Dec-2020)

Internal enhancement.

3.0.47 (11-Nov-2020)

Fixed the issue with download all Revisions.

3.0.46 (27-Oct-2020)

Fixed the issue of not being able to download from interface and also issue with Service Request LOV when users don't have Product hub.

3.0.45 (22-Oct-2020)

Fixed the issue of defaulting Description when updating.

3.0.44 (14-Oct-2020)

Fixed the issue of being able to download Service Request.

3.0.43 (07-Oct-2020)

Fixed issue while Create ALL the description is not required.

3.0.42 (06-Oct-2020)

Fixed issue when updating item, the description is required.

3.0.41 (06-Oct-2020)

Internal enhancement.

3.0.40 (21-Sep-2020)

Item Mode - Fixed the download order issues.

3.0.39 (16-Sep-2020)

Fixed the issue of being able to download locator control.

3.0.38 (15-Sep-2020)

Fixed the issue of the interface trigger not running.

3.0.37 (09-Sep-2020)

Added the download by UDA group.

3.0.36 (03-Sep-2020)

Updated security.

3.0.35 (06-Aug-2020)

UDA Mode - Removed the UDA Item ID column.

3.0.34 (06-Aug-2020)

Fixed the overflow error due to long type.

3.0.33 (28-Jul-2020)

Fixed the Blank issue for Default Shipping Organization.

3.0.32 (28-Jul-2020)

Fixed the issue with Default Shipping Organization while it starts from 0.

3.0.31 (28-Jul-2020)

Internal fix.

3.0.30 (28-Jul-2020)

Fixed the layout with Default Shipping Organization.

3.0.29 (27-Jul-2020)

Fixed the tab order by moving Web Service onto the tab after the Web option. Fixed the issue with LOVs of default Shipping Organization. Fixed the download issue with Default Shipping Organization. Fixed the issue with validation of ATP Components and Assemble to Order.

3.0.28 (27-Jul-2020)

Fixed the issue of Container type validation while container item is Yes.

3.0.27 (24-Jul-2020)

Fixed the issue with Fixed Order Quantity updating.

3.0.26 (20-Jul-2020)

Fixed issue with UDA Default Value, allowed the extension package information added on.

3.0.25 (16-Jul-2020)

Fixed issue of not being able to download Item Organization level UDA.

3.0.24 (15-Jul-2020)

UDA mode: Fixed the issue with incorrect error message while child section is errored.

3.0.23 (10-Jul-2020)

Internal enhancement.

3.0.22 (08-Jul-2020)

Fixed the issue with Fixed Order Quantity.

3.0.21 (08-Jul-2020)

Fixed the issue with Trial version updating limited to 0 records.

3.0.20 (01-Jul-2020)

Fixed the issue with Item status while using Copy Item form.

3.0.19 (29-Jun-2020)

Fixed issue with Category Set while creating all.

3.0.18 (29-Jun-2020)

Fixed issue with Item Status while using Item template.

3.0.17 (29-Jun-2020)

Fixed issue with the concurrent submission form.

3.0.16 (26-Jun-2020)

Fixed issue with the concurrent program submission form.

3.0.15 (25-Jun-2020)

Fixed the issue with Organization Code not an option in the concurrent submission form.

3.0.14 (18-Jun-2020)

Fixed the issue with invalid character 194 after login.

3.0.13 (12-Jun-2020)

Fixed the issue of LOV in New Category attributes.

3.0.12 (10-Jun-2020)

Internal enhancement.

3.0.11 (10-Jun-2020)

Modified the error message for delete category set.

3.0.10 (10-Jun-2020)

Added the Delete category features onto Item mode.

3.0.09 (08-Jun-2020)

Fixed the issue of list of value of serial generation control. Fixed the issue of Expiration Action list of value. Fixed the issue of validation on dependence of Serial Generation control and Serial status.

3.0.08 (05-Jun-2020)

Fixed the issue of list values of default lot status, default material status and default serial status.

3.0.07 (03-Jun-2020)

Fixed the issue of Max and Min validation for columns required.

3.0.06 (04-May-2020)

Internal enhancement.

3.0.05 (23-Apr-2020)

Updated the CMS message worksheet to the latest version.

3.0.04 (14-Apr-2020)

Fixed the issue of downloading with Organization Code and Description.

3.0.03 (14-Apr-2020)

Fixed the issue of Expense Account when it is Revenue. Fixed the issue of List of Default Material Status.

3.0.02 (09-Apr-2020)

Fixed the issue of List of Expense Account in Item mode.

3.0.01 (08-Apr-2020)

Fixed the issue of error like 'An invalid character' while using auto number generator.

3.0.0 (24-Mar-2020)

Major upgrade:
- Rebranding of logo and color scheme.
- Customize Logo and Store Password added to Setup ribbon.
- New Modes added: Organization Assignment, Description Translations, Maintain Categories, UDA Items.
- Provided multiple download source.
- Provided new Wizard ribbon and Normalization features.
- Improved Performance.
- Validation expanded.
- Ability to now ‘Clear Status Columns and IDs’ or just ‘Clear Status Columns’.

2.0.90 (17-Mar-2020)

Org Assignment, UDA and Translation modes: Fixed issue with Item Number type.

2.0.89 (13-Mar-2020)

Modified the template column comments.

2.0.88 (06-Mar-2020)

IDA mode: Fixed issue of not being able to update/download.

2.0.87 (20-Feb-2020)

Internal enhancement.

2.0.86 (11-Feb-2020)

Organization Assignment mode: Added the Assign Action column.

2.0.85 (11-Feb-2020)

Internal enhancement.

2.0.84 (10-Feb-2020)

Fixed issue of missing checking concurrent program submission.

2.0.83 (10-Feb-2020)

UDA mode: Added the comments.

2.0.82 (06-Feb-2020)

Translation, Categories and Organization Assignment modes: Fixed issue of color disappearing while clearing the status and ID.

2.0.81 (24-Jan-2020)

Item mode: Added the auto generated comments onto the Item.

2.0.80 (24-Jan-2020)

Added the comments onto all modes. Modified the Item mode download sql.

2.0.79 (20-Jan-2020)

Fixed - Downloading child organization item description details in different language.

2.0.78 (15-Jan-2020)

Fixed - Not being able to refresh status.

2.0.77 (15-Jan-2020)

Fixed - UDA in R12, uploading UDA in 11i.

2.0.76 (12-Jan-2020)

Fixed issue while creating an item with child org.

2.0.75 (06-Jan-2020)

Updated security.

2.0.74 (03-Jan-2020)

Fixed - Downloading null data for the Create Fixed Asset.

2.0.73 (03-Jan-2020)

Fixed - Element Name is required when section action is blank. Issues when Revision and revision label is blank, while Revision upload column is not blank.

2.0.72 (23-Dec-2019)

Updated the refesh Revision status after running the concurrent process.

2.0.71 (23-Dec-2019)

Fixed the issue of creating item when conflict with default revision setting.

2.0.70 (20-Dec-2019)

Fixed the issue of updating Revision. Fixed the issue of incorrect validation message for creating a new Category.

2.0.69 (19-Dec-2019)

Fixed the issue of download from interface table when both parent section org and item are same.

2.0.68 (18-Dec-2019)

Fixed the issue of not able to download the Revision data while adding a new revision to an existing item.

2.0.67 (12-Dec-2019)

Fixed the issue of upload item onto interface when Item Upload action is blank.

2.0.66 (12-Dec-2019)

Fixed the issue of New Category column validation. Fixed the issue of non value in the Revision, Catalog and Category section when action is 'Create All'.

2.0.65 (11-Dec-2019)

Fixed the issue of Revision not being in the Revision form. Fixed the issue of Category section while creating with New Category data. Fixed the issue of Create All in the section Item Catalog.

2.0.64 (04-Dec-2019)

Fixed the issue of not being able to add a revision to an existing item. Fixed the issue of validation of section Upload Action. Added the warning message to the Category section and Revision section. Fixed the issue of not being able to download the revision interface data if the related parents section data exists in the parent interface table.

2.0.63 (29-Nov-2019)

Internal enhancement.

2.0.62 (27-Nov-2019)

Fixed the issue of last updated by not being updated.

2.0.61 (27-Nov-2019)

Org Assignment mode: Fixed the issue of not including last update by column.

2.0.60 (26-Nov-2019)

Fixed the issue of downloading Master Org in Assign section.

2.0.59 (26-Nov-2019)

Org Assignment mode: Fixed the issue of ID not being meaningful to users.

2.0.58 (25-Nov-2019)

Organization Assignment mode: Fixed the issue of not being able to download non_assigned organization.

2.0.57 (23-Nov-2019)

Added the download source of Organization Assignment. Added download filter like Org, Item Number and Created.

2.0.56 (21-Nov-2019)

Fixed the SQL errors when download combination is with Item and Language value.

2.0.55 (21-Nov-2019)

Fixed the issue of category status refresh being wrong.

2.0.54 (21-Nov-2019)

Fixed the download all revision issues when revision effective date is in the future.

2.0.53 (19-Nov-2019)

Fixed the issue of downloading item with Hold days.

2.0.52 (19-Nov-2019)

Fixed the issue when Item section failed and child section being updated.

2.0.51 (19-Nov-2019)

Fixed the issue with 'Clear Status and ID columns'.

2.0.50 (18-Nov-2019)

Fixed the issue with View the Attachment.

2.0.49 (18-Nov-2019)

Fixed the issue of dependence between ATP Components and Pick Components.

2.0.48 (18-Nov-2019)

Fixed the issue of not able to update Expense Account.

2.0.47 (18-Nov-2019)

Fixed the issue of Download/Uploading Unit of issues attributes.

2.0.46 (13-Nov-2019)

Fixed the issue of updating the Revision section message.

2.0.45 (08-Nov-2019)

Fixed the issue of Download via Sheet which contains Revision section.

2.0.44 (08-Nov-2019)

Fixed the issues of Base Model attribute type and value.

2.0.43 (07-Nov-2019)

Fixed the issues of processing unit Type showing error when outside processing item has value of Yes.

2.0.42 (05-Nov-2019)

Fixed the issue of download the section data from Item, Category and Revision. Fixed the issue of download SQL error when using Download via Form.

2.0.41 (05-Nov-2019)

Fixed the issue of Download All Revision SQL error.

2.0.40 (04-Nov-2019)

Fixed the issue with non value of Category Set.

2.0.39 (04-Nov-2019)

Fixed the issues of updating error message when upload action is blank.

2.0.38 (04-Nov-2019)

Fixed the issues of Duplicated Entry for Category set.

2.0.37 (01-Nov-2019)

Fixed the issue of long digits written back onto the sheet.

2.0.36 (31-Oct-2019)

Fixed the issue of download with the combination of Item section and Category section. Tidy up the record sheet Item section download record sheet set up.

2.0.35 (30-Oct-2019)

Fixed the issues of download with Item section and Category section.

2.0.34 (30-Oct-2019)

Fixed the issues of Download via Form with Category range.

2.0.33 (30-Oct-2019)

Fixed the issues of Category Set ID.

2.0.32 (30-Oct-2019)

Fixed the issues of duplicated entry in Category.

2.0.31 (29-Oct-2019)

Fixed the issues of Category value not in the list.

2.0.30 (29-Oct-2019)

Item mode: Fixed the issues of each section refresh ID name on the sheet.

2.0.29 (29-Oct-2019)

Fixed the issues of Element sequence in the Catalog section.

2.0.28 (25-Oct-2019)

Fixed the bug of not refreshing Categories section correctly.

2.0.27 (14-Oct-2019)

Fixed the issue of Each not in the LOV list.

2.0.26 (14-Oct-2019)

Changed the column widths for Primary UOM LOV fields.

2.0.25 (27-Sep-2019)

Fixed the issue of concurrent refresh, refreshing wrongly for error records for Item section.

2.0.24 (20-Sep-2019)

Fixed the issue of refreshing all the records on the sheet.

2.0.23 (13-Sep-2019)

Fixed the issue of Action columns require a value where nothing is done in Categories section.

2.0.22 (13-Sep-2019)

Fixed the bug of unable to identify value from SQL for Descripton.

2.0.21 (13-Sep-2019)

Fixed the issue of structure name list of value.

2.0.20 (13-Sep-2019)

Interface mode: Fixed the issues of not downloading Hold Days.

2.0.19 (12-Sep-2019)

Fixed the issues of not able to update the Hold Days, Added a whole number for Hold Days.
Fixed the issue of error message like DEFAULT_LOT_STATUS_ID issues.

2.0.18 (05-Sep-2019)

Fixed the issue of Invoice Rule List of value.

2.0.17 (05-Sep-2019)

Internal enhancement.

2.0.16 (04-Sep-2019)

Fixed the issue of Hold Days Attribute missing on the sheet.

2.0.15 (04-Sep-2019)

Fixed the issue of the download the current revision by default.

2.0.14 (28-Aug-2019)

Fixed the issue of the Buyer field value limited to 1000 values. Fixed the issues of Service Contract Template list value.

2.0.13 (21-Aug-2019)

Fixed the error like 'Property From SQL must NOT have FROM clause' when refresh the Status.

2.0.12 (08-Aug-2019)

Internal enhancements.

2.0.11 (29-Apr-2019)

Internal enhancements.

2.0.10 (10-Apr-2019)

Updated link on Setup page.

2.0.09 (10-Apr-2019)

Updated Wizard colors.

2.0.08 (27-Dec-2018)

Items Mode - Added time functionality when filtering using the Creation Date. Fixed Download error when downloading via interface with DFFs on the sheet. Fixed error when logging into a instance where the concurrent program was missing the 'Gather Stats' parameter.

2.0.07 (14-Dec-2018)

All Modes - Changed LOV order on the Download form.

2.0.06 (07-Dec-2018)

All Modes - Changed Upload column names from 'Item Upload Mode' to 'Item Upload Action'.

2.0.05 (29-Nov-2018)

Translations mode: Fixed error when attempting to update descriptions on an Item that does not exist.

2.0.04 (21-Nov-2018)

Items - Fixed error when attempting to click the parameters button twice on the submit concurrent program form.
UDA Items - Changed column names from 'Item Ext Group' to 'Item UDA Group'.

2.0.03 (20-Nov-2018)

Description Translations - Fixed error when descriptions had single quotes in it.

2.0.02 (20-Nov-2018)

Items mode: Fixed Enforce Ship to LOV as was returning no records.

2.0.01 (16-Nov-2018)

Added functionality to copy out of Display only controls on the form.

2.0.00 (14-Nov-2018)

Conversion to Common3

1.8.68 (08-Apr-2019)

Custom Query Updated to version 1.1.14

1.8.67 (08-Apr-2019)

Fixed error where 'Show Toolbars' in the macros list was being duplicated.

1.8.66 (08-Apr-2019)

Fixed error where 'Reinstall Profile Options' was not showing in the macros list.

1.8.65 (04-Apr-2019)

Changed spelling of 'License' to 'Licence' on the Setup sheet.

1.8.64 (03-Apr-2019)

Fixed Child Lot Enabled column as was incorrectly being set to invalid.
Added checks when attempting to use Wizard functions above row 10.
Fixed errors when selecting the wizard logo then trying to use Download via Sheet.
Mandatory columns now cannot be unselected in the Customize Fields form.

1.8.63 (02-Apr-2019)

Fixed error when Deleting the Template123 sheet.
Fixed Download form error when the Wizard logo is selected.
Made the Description column required.

1.8.62 (02-Apr-2019)

Added the 'Logging' to right-click menu.

1.8.61 (01-Apr-2019)

Fixed the issue where Debug Mode was not shown in the right-click menu.

1.8.60 (01-Apr-2019)

Added Logging button to enable writing query log. Added Help buttons to enable a quick link to the documentation.
Added 'Allow Popups' option in the login form to allow the popups dialogs required by login.
Added new debug option "End To End Trace Unlimited Size".

1.8.59 (01-Apr-2019)

Made the Item Process Status, Item Messages and Item Interface ID columns mandatory.

1.8.58 (27-Mar-2019)

Fixed Download via Sheet error as was incorrectly showing 'Please enter some criteria before downloading from sheet.' message.

1.8.57 (15-Mar-2019)

Fixed error when searching for an Item when the Upload option was Update.

1.8.56 (04-Mar-2019)

Fixed errors where Number columns were getting rounded.

1.8.55 (28-Feb-2019)

Fixed error where the Minimum Order Quantity and Maximum Order Quantity columns were getting rounded.

1.8.54 (11-Jan-2019)

Fixed error when using the Copy From Item as the Long Description would not get copied over.

1.8.53 (14-Dec-2018)

Fixed error when attempting to upload with invalid organizations.

1.8.52 (18-Oct-2018)

Fixed upload error when using the BLANK functionality on the MRP Forecast Control column.

1.8.51 (11-Oct-2018)

Updated security.

1.8.50 (24-Sep-2018)

Fixed error when attempting a Copy From Item using an Item with a large number of Categories.

1.8.49 (20-Sep-2018)

Fixed error where 'Stockable is dependent on the column(s): Inventory Item.' message was popping up when both 'Stockable' and 'Inventory Item' did not have a value.

1.8.48 (19-Sep-2018)

Fixed error when attempting a Copy From Item using an Item with a large number of Catalogs.

1.8.47 (18-Sep-2018)

Fixed error where Demand Time Fence Days was incorrectly being set to invalid.

1.8.46 (13-Sep-2018)

Removed Starting Lot Prefix Defaulting from the Organization Parameters.

1.8.45 (05-Sep-2018)

Fixed error where Check Material Shortage was being set to invalid when Transactable does not have a value.

1.8.44 (04-Sep-2018)

Updated security.

1.8.43 (16-Aug-2018)

Internal enhancement.

1.8.42 (14-Aug-2018)

Fixed the Base Model Attribute. Changed from a text field to a searchable list of values. Also fixed the upload and download and provided [BLANK] functionality.

1.8.41 (24-Jul-2018)

Fixed upload error when attempting to update the 'Create Configured Item, BOM'.

1.8.40 (27-Jun-2018)

Fixed error when trying to apply an Invalid Item Template in the form.

1.8.39 (19-Jun-2018)

Fixed error as the processing form was being set to red when uploading blank rows.

1.8.38 (05-Jun-2018)

Updated security.

1.8.37 (30-Apr-2018)

Fixed error where the Progress bar can read incorrectly when doing an Upload Selected.

1.8.36 (24-Apr-2018)

Fixed error where uploading with multiple selected ranges required the user to manually close the Processing form.

1.8.35 (09-Apr-2018)

Fixed error where the Tax Code would not download in R12.

1.8.34 (04-Apr-2018)

Updated security.

1.8.33 (21-Mar-2018)

Fixed error when searching for an Account when no Organization has been entered.

1.8.32 (20-Mar-2018)

Added LOV's to the Overreceipt Action and Receipt Date Action fields as was missing.

1.8.31 (26-Feb-2018)

Changed Organization Code SQL as was incorrect in some situations.

1.8.30 (13-Feb-2018)

Internal enhancement.

1.8.29 (01-Apr-2019)

Added 'Expiration Action Code' and 'Expiration Action Interval' columns.

1.8.28 (08-Feb-2018)

Download via sheet now Downloads the latest revision by default.
Added download form option 'Download all Revisions' so the user can download all revisions if need be.

1.8.27 (08-Feb-2018)

Changed width column name from 'Unit Width' to 'Width'.

1.8.26 (06-Feb-2018)

Fixed the issue where the users received an e4awand_oracles.xll error when opening the Wizard.

1.8.25 (01-Dec-2017)

Changed pop up message when attempting to add categories to an already existing item.

1.8.24 (20-Nov-2017)

Fixed "The TEMPLATE_ID or TEMPLATE_NAME specified is not a valid template" error when using a template and loading catalogs.

1.8.23 (14-Nov-2017)

Fixed error with the Clear Status Columns functionality when no data is on the sheet.

1.8.22 (13-Nov-2017)

Fixed error when assigning Templates with Primary or Secondary UOM's to Items.

1.8.21 (10-Nov-2017)

Fixed error where the Long Description column was not appearing in the Customize Fields form.

1.8.20 (10-Nov-2017)

Fixed DFF error as Independent Value sets were not being populated correctly.

1.8.19 (08-Nov-2017)

Fixed error with the Secondary UOM column as was not bringing back the correct list of values.

1.8.18 (01-Nov-2017)

Implemented Vendor Managed columns.

1.8.17 (31-Oct-2017)

Added functionality to the Clear Status Columns so it now clears the Process Set.
Fixed error where the Default lot status should be required if Lot Status Enabled is Yes.
Changed the name of the Field Outside Processing UOM Type to Outside Processing Unit Type.
Fixed error where the Outside Processing Unit Type is required when Outside Processing Item is Yes.

1.8.16 (27-Oct-2017)

Added Default UOM column when using Secondary UOM's.

1.8.15 (03-Oct-2017)

Changed to allow 0 for Fixed Days Supply attribute.

1.8.14 (21-Sep-2017)

Fixed error where the Category was uploading the wrong ID causing a Concurrent Program error.

1.8.13 (20-Sep-2017)

Updated security.

1.8.12 (08-Sep-2017)

Fixed download error where "No C_ITEM found in this range to download" message was popping up for every line if the criteria was incorrect.

1.8.11 (23-Aug-2017)

Fixed error where the Internal Orders Enabled column was disabled on the form.

1.8.10 (15-Aug-2017)

Fixed DFF error as was uploading the Values and not the IDs for a Translatable Independent Value Set.

1.8.09 (14-Aug-2017)

Fixed DFF functionality as was not handling Translatable Independent Value Sets.

1.8.08 (14-Aug-2017)

Updated security.

1.8.07 (04-Aug-2017)

Fixed error where the progress form was not locking the spreadsheet.
Made the LOV for the Primary UOM larger.

1.8.06 (21-Jul-2017)

Internal enhancement.

1.8.05 (17-Jul-2017)

Fixed error when the user's value had capital letters as it would say they were being set to invalid incorrectly.

1.8.04 (10-Jul-2017)

Internal enhancement.

1.8.03 (03-Apr-2017)

Updated security.

1.8.02 (26-Jun-2017)

Increased max row limit on the Buyer and Purchasing Tax Code columns.

1.8.01 (22-Jun-2017)

Internal enhancement.

1.8.00 (16-Jun-2017)

Rounded version to 1.8.00 for release.

1.7.19 (16-Jun-2017)

Fixed error where the Revision Effective Date was missing from the customize fields form.

1.7.18 (16-Jun-2017)

Fixed error with the Child Lot Starting Number as was erroring with no error message.

1.7.17 (14-Jun-2017)

Added Catalog Description Default column as the Description Default value was being cleared out when updating Catalogs.

1.7.16 (12-Jun-2017)

Added validation to the when uploading attachments using the 'M4A Copy From Item' attachment category in Create mode.
Added fix so that columns made mandatory in the Customize Fields form will now error if not on the sheet.

1.7.15 (07-Jun-2017)

Added checks to make sure the Item, Organization and Item Description are on the sheet.
Added check to make sure that the derive child organizations functionality is only used on row 10 or below.
Added check to make sure the Attachment Status is on the sheet before uploading Attachments.
Added fix so that the Download via Interface functionality now downloads the Interface Transaction ID.

1.7.14 (26-May-2017)

Fixed upload error when creating revisions with a label of four characters long.

1.7.13 (19-May-2017)

Fixed 'The order of Revisions for an Item must occur in both chronological (EFFECTIVITY_DATE) and alphabetical (REVISION) order.' error when updating revisions.

1.7.12 (18-May-2017)

Fixed overflow error when downloading large amounts of data.

1.7.11 (05-May-2017)

Internal enhancements.

1.7.10 (05-May-2017)

Fixed error with DFF dates when an invalid date was used.
Fixed error when uploading Categories if it had a single quote.

1.7.09 (04-May-2017)

Minor bug fix.

1.7.08 (04-May-2017)

Minor bug fix.

1.7.07 (03-May-2017)

Fixed error with the Child Lot Starting Number when Lot Control was not on the sheet.

1.7.06 (01-May-2017)

Fixed error with the Upload as was causing Parent/Child conflicts.

1.7.05 (24-Apr-2017)

Fixed error with the Starting Serial Number as was dependent on the wrong value.
Fixed error with the Lot Divisible column as would be set to invalid and then disabled.
Fixed error with the Revision Control column as was being set to invalid and then cleared out.

1.7.04 (24-Apr-2017)

Fixed error where warning message boxes were popping up when changing the Organization.

1.7.03 (21-Apr-2017)

Fixed UOM error when updating an Item as was attempting to upload the UOM Description.

1.7.02 (19-Apr-2017)

Added 'Do you wish to process attachments?' message prompt when refreshing the sheet with attachments.

1.7.01 (12-Apr-2017)

Internal enhancements.

1.7.00 (12-Apr-2017)

Fixed error when creating a sheet then closing the Wizard as was crashing after receiving 'The picture is too large and will be truncated.'

1.6.99 (03-Apr-2017)

Fixed error when no volume update. Unit volume now accepts NULL and/or zero.

1.6.98 (03-Apr-2017)

Updated Security.

1.6.97 (14-Mar-2017)

Fixed error when removing Global DFF Context off the sheet.
Added button on the user form to navigate to the Global DFF's.
Fixed error where the DFF wouldn’t update when trying to change Contexts.

1.6.96 (13-Mar-2017)

Implemented Global DFF functionality.

1.6.95 (10-Mar-2017)

Internal enhancements.

1.6.94 (09-Mar-2017)

Added fix as only 1000 Supply SubInventories were being displayed in the list of values.

1.6.93 (06-Mar-2017)

Fixed upload error when updating the Lot Control field.

1.6.92 (07-Feb-2017)

Internal enhancements.

1.6.91 (07-Feb-2017)

Internal enhancements.

1.6.90 (24-Feb-2017)

Internal enhancements.

1.6.89 (23-Feb-2017)

Added search functionality to the planner field.

1.6.88 (22-Feb-2017)

Fixed error when uploading Revisions when the Revision Control field is controlled at Master Level.

1.6.87 (22-Feb-2017)

Implemented Planner and Buyer fields on the Download form.

1.6.86 (17-Feb-2017)

Fixed upload error with the Planned Inventory Point column as was causing the concurrent program to error.

1.6.85 (13-Feb-2017)

Fixed error with the Source Organization LOV as was not returning results correctly.

1.6.84 (13-Feb-2017)

Fixed error with download as was not downloading records correctly.

1.6.83 (10-Feb-2017)

Fixed error where the Assemble To Order field was defaulting to 'Yes'.

1.6.82 (08-Feb-2017)

Added the ability to download based on the Planning Time Fence, Demand Time Fence, Release Time Fence, Planning Time Fence Days, Demand Time Fence Days, Release Time Fence Days columns when downloading via the sheet.

1.6.81 (07-Feb-2017)

Internal enhancements.

1.6.80 (16-Dec-2016)

Implemented Catalog Element Sequence field.

1.6.79 (19-Oct-2016)

Fixed issue where the DFF values were not being set to null when using the [BLANK] functionality.

1.6.78 (14-Oct-2016)

Internal enhancements.

1.6.77 (14-Oct-2016)

Added ability to search for a Primary UOM based on the UOM Description rather than the UOM Code.

1.6.76 (12-Oct-2016)

Added fix as only 1000 UOM's were being displayed in the List of Values.

1.6.75 (07-Oct-2016)

Fixed error where checkboxes in oracle were not downloading a value when being null.

1.6.74 (06-Oct-2016)

Fixed SQL error when putting in an invalid Org and trying to validate.
Modified the Locator Control SQL as was bringing back incorrect values.
Changed wording on the Customize Fields form from 'Max columns reached. Please restrict your selection' to 'Maximum number of columns (254) has been reached. A new sheet has been created with this many columns. To include other columns, please restrict your selection.'
Fixed error where a message was saying that you cannot update the Sub Element even though the value was blank.
Fixed validation for the Min/Max Order quantities as the Minimum cannot be greater than the Maximum.

1.6.73 (04-Sep-2016)

Modified the Download for the Child Lot Prefix and Child Lot Starting Number as these were downloading the wrong values.

1.6.72 (27-Sep-2016)

Modified the Attachment Upload so that it prints Results to the sheet (eg 'ACCEPTED). Also now displays processing form when uploading all attachments.

1.6.71 (15-Sep-2016)

Fixed error where the Concurrent Program was erroring saying that values weren’t the same between the Child Org and Master Org.

1.6.70 (07-Sep-2016)

Added checks as 'Child Lot Enabled', 'Child Lot Generation', 'Child Lot Prefix', 'Child Lot Starting Number', 'Child Lot Format Validation', 'Copy Lot Attributes' columns are not available in 11i .

1.6.69 (05-Sep-2016)

Fixed error where the Primary UOM was being incorrectly set to invalid.

1.6.68 (05-Sep-2016)

Imported latest Downloader Modules.

1.6.67 (26-Aug-2016)

Internal enhancements.

1.6.66 (23-Aug-2016)

Internal enhancements.

1.6.65 (23-Aug-2016)

Internal enhancements.

1.6.64 (22-Aug-2016)

Internal enhancements.

1.6.63 (22-Aug-2016)

Fixed issue where non printable characters were getting uploaded on the item Description column.

1.6.62 (15-Aug-2016)

Fixed download issue where the Downloader Add-in Profiles were not getting installed.

1.6.61 (11-Aug-2016)

Internal enhancements.

1.6.60 (02-Aug-2016)

Changed the Invoice Tax Code SQL if we are in R12 as was bringing back an incorrect list of values.

1.6.59 (15-Jul-2016)

Enhanced Flexfield validation. In some cases will stop the wrong Code Combination IDs from being returned.
Now checks to see if the Account is postable when validating a GL Code Combination.

1.6.58 (24-Jun-2016)

Fixed Download Error with the DFF's where the DFF column has a form substitution.

1.6.57 (08-Jun-2016)

Fixed SQL error with the Tax Code.

1.6.56 (08-Jun-2016)

Fixed issue with the Template validator as this was defaulting incorrect values.

1.6.55 (08-Jun-2016)

Fixed issue with the Template validator as this wasn’t defaulting every field correctly.

1.6.54 (08-Jun-2016)

Changed Upload SQL as was unable to update the Revision label.

1.6.53 (03-Jun-2016)

Changed the Purchase Tax Code SQL if we are in R12 as was bringing back an incorrect list of values.

1.6.52 (02-Jun-2016)

Added Child Lot Starting number validation as this is dependent on the Child Lot Prefix, Child Lot Enabled and Lot Control columns.
Internal Enhancements.

1.6.51 (01-Jun-2016)

Fixed download issue as the Process Costing Enabled and the Process Quality Enabled columns were downloading incorrectly.
Modified blanking functionality as was putting in the fields when using [BLANK].

1.6.50 (27-May-2016)

Fixed error as the BOM Effectivity Control was not downloading.
Added validation to the Material Sub Element and Material Cost as you are unable to update these.
Internal Enhancements.

1.6.49 (23-May-2016)

Updated Security.

1.6.48 (11-May-2016)

Updated UOM to fix UOM discarding issues.

1.6.47 (22-Apr-2016)

Added support for Unit of Issue.

1.6.46 (22-Apr-2016)

Added validation for leading and trailing spaces in item numbers to not be allowed.

1.6.45 (19-Apr-2016)

Fixed Organisations not populating for Process Manufacturing Responsibility in 11i.

1.6.44 (30-Mar-2016)

Fixed Organisations not populating for Process Manufacturing Responsibility.

1.6.43 (18-Mar-2016)

Updated Security.

1.6.42 (03-Mar-2016)

Updated Security.

1.6.41 (12-Feb-2016)

Fixed issue with Download, two columns (Contract Item Class and Contract Item Class) had been conflicting with aliases.
Added validation for Child Lot Starting number to allow nulls and 0 values.
Modified to ignore Child Lot starting Number when Child Lot enabled is not enabled.
Modified Blanking functionality for Catelog Element Value to insert a blank rather than '!'.

1.6.40 (27-Jan-2016)

Updated Security.

1.6.39 (05-Jan-2016)

Changed New Category column to require a Category Set before being able to search.

1.6.38 (24-Dec-2015)

Modified to handle revision control when creating items.

1.6.37 (24-Dec-2015)

Changed Error message for Inventory, Stockable and Transactable columns.
Changed duplicate column error message to only occur once on initialisation. Also fixed so stated column is proper case not all upper case.

1.6.36 (22-Dec-2015)

Updated Security

1.6.35 (09-Dec-2015)

Updated check to see if the item has any stock on hand if updating the 'Revision Control' field

1.6.34 (08-Dec-2015)

Added check to see if the item has any stock on hand if updating the 'Revision Control' field

1.6.33 (01-Dec-2015)

Modified search for Categories

1.6.32 (01-Dec-2015)

Added error messaging for Categories and Locators.
Added error messaging for categories were erroring but no messages were being brought back.

1.6.31.7 (16-Mar-2017)

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

1.6.31 (25-Nov-2015)

Applied a fix to download Items when previously if an item was created without the category columns then attempted to download in a sheet with them it would not retrieve data

1.6.30 (25-Nov-2015)

Updated Security.
Added support for Excel 2013 Bug for when data disappears when tabbing on a new sheet.

1.6.29 (25-Nov-2015)

Cleaned for Release

1.6.28 (24-Nov-2015)

Fixed Spelling Errors for select column names.
Changed order of the Right Click Menu to show Item Wizard - Item Wizard Setup - Downloader.
Added Code to Populate Debug Upload Ribbon Option on Open.

1.6.27 (17-Nov-2015)

Added support for Setting the Lot Divisible Flag

1.6.26 (18-Nov-2015)

Added Profile Option to restrict the user to only Update Items

1.6.25 (05-Nov-2015)

Copy From Item functionality – Issue fix

1.6.24 (04-Nov-2015)

Made changes to Copy Item Functionality to work with 12.2 environments

1.6.23 (05-Nov-2015)

Added Debug Upload Option to the Ribbon

1.6.22 (30-Nov-2015)

Updated to Core 212

1.6.21 (30-Nov-2015)

Added provision to derive data in create mode to exclude original selection of data, Update includes original data selection in derivation.
Modified printing when in Create mode.

1.6.20 (24-Sep-2015)

Added Validation for Unit Volumes

1.6.19 (23-Sep-2015)

Added Download Wizard

1.6.18 (21-Sep-2015)

Sped up the Login Process
Added MainMultiCaller Code to speed up Checking function security of responsibility

1.6.17 (18-Sep-2015)

Fixed scenario when Process Set was not on the sheet causing an un-handled error to the user

1.6.16 (18-Sep-2015)

Fixed DFF to handle more than 1000 DFF Contexts

1.6.15 (03-Sep-2015)

Optimized caching of Organizations on start up to handle extremely large quantities of organisations, ie over 1000.
Added search controls for Organizations in the User form and Download form for faster searching.

1.6.14 (03-Sep-2015)

Assign Mode removed

1.6.13 (27-Aug-2015)

Added Derive Child Org Functionality

1.6.12 (25-Aug-2015)

Updated Wizard Refresh Status messages

1.6.11 (27-Jul-2015)

Fixed Attachment form issues when opening form due to missing columns

1.6.10 (21-Jul-2015)

Updated caching of orgs, setting of the cached org list collection was lost in version 1.6.08 so added it back in

1.6.09 (16-Jul-2015)

Modified Refresh to handle error messages longer than 250 characters

1.6.08 (14-Jul-2015)

Optimized caching of organizations

1.6.07 (01-Jul-2015)

Modified Validation for Default Material Status’s

1.6.06 (30-Jun-2015)

Modified Download form to correctly show Organizations based on user responsibility

1.6.05 (24-Jun-2015)

Modified Assign mode error messaging due to false error messages being shown

1.6.04 (12-Jun-2015)

Enabled Multi Org assignment for blank spaces in org list, using Trim() function

1.6.03 (12-Jun-2015)

Mode to disable Org assignment validator when in Create or Update, only needed when in Mode Assign

1.6.02 (12-Jun-2015)

Made control for Multi Org Assignment wider in the form

1.6.01 (11-Jun-2015)

Completed Multi ORg Assignment, now can assign an item to multiple orgs in one load, requires a valid Master Item, Item ID, UOM and a string of Organizations

1.6.00 (15-May-2015)

Added in Organization Assignment Section to make assigning to child organizations easier

1.5.26 (06-May-2015)

Changed source org SQL to use Concatenated_Segments instead of Inventory_item_id

1.5.25 (24-Feb-2015)

Added a check into Validation for Supplier Locators when using dynamic uploads, errors if the value does not contain a valid locator

1.5.24 (02-Mar-2015)

Use the ctl.value instead of ctl.text when setting a combobox to retain the spreadsheet case.
Changed the UOM validation to ensure correct values for example EA, Ea, ea.

1.5.23 (24-Feb-2015)

Modified ValidatorMinMax to allow Null for the minimum quantity columns even when there are maximum values present
Removed the Trace Options from the download form

1.5.22 (19-Feb-2015)

Modified attMod, the Category LOV was being cached and not reinitializing when swapping environments without closing excel, due to an isEmpty check, which has been removed

1.5.21 (18-Feb-2015)

Modified Property Get returnSQL to fix ReturnSQL error in Download from Interface.
Needed to split the key from the alias because we were using the same for the validatecolumn and the validateSQL.

1.5.20 (17-Feb-2015)

Modified Record sheet dependency for Lot Control Enabled, previously was not enabling or disabling the control when the Lot Controlled status was chosen

1.5.19 (16-Feb-2015)

Added CopyFromItem functionality so that the Primary UOM was not being defaulted when specifying an item to copy from as previous
Fixed Lot Status enabled dependency.
Fixed drec in procedure DownloadInterface for process set if and interface id on Download from interface, aliases were causing issues when looping through the entity list for download.

1.5.18 (13-Feb-2015)

Added check on Default Material Status in case the column is not available in the users database version, some R12 environments were erroring when on a low database version

1.5.17 (12-Feb-2015)

Modified Module ValidatorDefaultMaterialStatus for when Lot and Serial enabled weren’t on the sheet as it was erroring
*WIP Download fails in some R12 environments

1.5.16 (11-Feb-2015)

Modified Module ValidatorDefaultMaterialStatus

1.5.15 (10-Feb-2015)

Modified Module Upload, Procedure: Add Item to fix copy from item functionality as was currently not functional

1.5.14 (10-Feb-2015)

Modified ValidatorDefaultMaterialStatus, as we were hitting an error 9999 so changed values to compare correct data types

1.5.13 (10-Feb-2015)

Fixed Refresh where delimiters ie "\" were causing the category status to stay as PENDING, now resolved

1.5.12 (09-Feb-2015)

Completed Default Material Status Column Enhancement

1.5.11 (27-Jan-2015)

WIP Added Default Material Status.
Added ValidatorDefaultMaterialStatus to cater for validation as well to ensure the Default material status LOV populates correctly based on Serial and Lot controls.

1.5.10 (15-Jan-2015)

Was getting frmInitialiseTab.Userform_Activate Runtime 9999 error when setting the wizard columns. Changed xName in module Initialise to "A2:A343" as it was reading incorrect records form the record sheet

1.5.09 (14-Jan-2015)

Fixed issue "Type Mismatch" error when loading attachments when Sequence and Title are not on the sheet. Added in attMod to check for sheet column existence for both columns

1.5.08 (24-Dec-2014)

Changed CreateProductMenuToolbar to create Show/Hide Login information button independently from the right click menu as it was disappearing in Excel 2003

1.5.07 (22-Dec-2014)

Added support for child/lot support (record sheet update only)

1.5.06 (16-Dec-2014)

Changed procedure frmFlex.cmdCombinations_Click. Removed alias from segments in the select parent of the sql. If the segments had the same alias you would get an: ORA-00918: column ambiguously defined
Added central error handler
Changed procedure frmFlex.CheckRestriction. All columns that have dependence are now restricted (long list searchs)
Previously the decision was to base the child on the parent’s restricted setting. This caused longer dependent lists to be truncated

1.5.05 (09-Dec-2014)

Modified ValidatorMinMax due to Error 13 occuring when a non-numeric character was entered

1.5.04 (09-Dec-2014)

Added a check on double-click for Wizard responsibilities. When no access is allowed then form was not initialising load then erroring

1.5.03 (08-Dec-2014)

Modified the Item From and To text boxes in the Download Form to be larger.
Made the columns in the Template field in the Main Item form wider.
Added in check on IsMasterorg when loading a responsibility with no Category access, to stop erroring occurring.
Modified ValidatorMinMax for when validating Minimum Quantity field to allow Null in the minimum when maximum is specified.

1.5.02 (05-Dec-2014)

Added in Download Selected a way to cache previous From and Where SQL then overwrite after download is complete. Solves when Item not available in master organization error occurs incorrectly

1.5.01 (26-Nov-2014)

Changed Dependency on Orderable on the Web column

1.5.00 (24-Nov-2014)

Added a check in Initialise to not implement DFF's greater than ATRIBUTE15 when in 11i instances

1.4.99 (20-Nov-2014)

Fixed attachment category not being set via form

1.4.98 (19-Nov-2014)

Added organization join in category download Procedure : addCategoryCriteria, for perfomance issues when downloading categories

1.4.97 (18-Nov-2014)

Updated to Core 210

1.4.96 (18-Nov-2014)

Modified ValidatorRevisions, revisions were claiming to exist, but now we check against the current revisions

1.4.95 (17-Nov-2014)

Moved when attachments write to the sheet, as the category field was being written to the sheet even when cleared

1.4.94 (05-Nov-2014)

Removed right click menu option to show Login Status Bar

1.4.93 (03-Nov-2014)

Removed large section of CachedOrgList querying the Items table for orgs which wasn’t needed

1.4.92 (31-Oct-2014)

Moved Initialize in Refresh as when downloads were run after refresh got a "Name contained an invalid character" error

1.4.91 (30-Oct-2014)

Modified CachedOrgList query as it was working on our side but not client side .
Changed set status column to C_PENDING as per new standards for Interface wizards. set in Main > SetReturnResults Call SetStatusColumn(C_PENDING, CLng(key), section.statusCol.reference).

1.4.90 (30-Oct-2014)

Removed Cartesian join in cached org list

1.4.89 (29-Oct-2014)

Added status bar message to CachedOrgList sql execution to remove FALSE from the statusbar

1.4.88 (24-Oct-2014)

Modified CachedOrgList performance

1.4.87 (24-Oct-2014)

Changed 'Select Fields' to 'Customize Fields' on the setup ribbon

1.4.86 (23-Oct-2014)

Updated Refresh to include Catalogs and Revisions, and Chunking

1.4.85 (20-Oct-2014)

Rewrote the Refresh to enhance performance

1.4.84 (14-Oct-2014)

Added in check in attMod for the Copy to functionality as it was erroring when the sql brought back no attachments

1.4.83 (14-Oct-2014)

Changed initialise xName to xName As String = "A2:A337" to allow for the read of columns

1.4.82 (14-Oct-2014)

Set Planning Time Fence Column and Demand Time Fence proc type to C_LONG to accurately set [BLANK] on upload

1.4.81 (10-Oct-2014)

Added in Retest Interval Column

1.4.80 (10-Oct-2014)

Added new Attachment code to Attachment Modules/Classes/Form, NOTE* Does not coincide with common core as IW core is behind

1.4.79 (09-Oct-2014)

Set Release Time Fence Column proc type to C_LONG to accurately set [BLANK] on upload
Added in New Core Ribbon Code to fix Error 91 on start up

1.4.78 (06-Oct-2014)

Added in check for Lot Control in ValidatorLotDivision as lot control was missing from sheet
Added Line number check on close to remind us to insert line numbers

1.4.77 (02-Oct-2014)

CORE CHANGE Refer to fndAbout version 066. Changed fndAbout Activate code to handle user trying to exit form with the Esc key for Close button.

1.4.76 (30-Sep-2014)

Changed dependency of Transactable to depend on Inventory Item instead of Stockable as Transactable and Stockable both rely on Inventory Item Flag and wizard was erroring far too often

1.4.75 (23-Sep-2014)

Fixed Template Error occurring on columns that did not contain a value by checking if nothing thus checking if the column was of type LOV

1.4.74 (19-Sep-2014)

Added in functionality to only download the latest revision for an Item in download form

1.4.73 (12-Sep-2014)

Changed Catalog SQL to only bring back catalogs for Master Items

1.4.72 (08-Sep-2014)

Changed Import form to search for all Concurrent request Id's available on the sheet, not just 500 as per original coding

1.4.71 (04-Sep-2014)

Changed the column widths of the template LOV to 80;220;40 in record sheet to give room for longer descriptions

1.4.70 (29-Aug-2014)

Updated Validator Revision to allow revisions on the same day

1.4.69 (22-Aug-2014)

Updated Ribbon/Context menu to be in proper order

1.4.68 (22-Aug-2014)

Changed ValidatorItem as the form was opening with invalid controls and Organization error was already catered for by validatorDefaultDependent
Changed flex code in frmFlex to ensure default sql was being run rather than populating the control with that default sql

1.4.67 (22-Aug-2014)

Updated common module DownloadRow, also added in a Trim function to the download selected values to fix spaces before and/or after values

1.4.66 (21-Aug-2014)

Limited Max length property on Max rows in the download form as it was hitting an overflow on 10+ character length
Added a unique to the Download form description search control, as duplicate inventory Id's were being brought back due to no org Id is required to be specified

1.4.65 (20-Aug-2014)

Ucase for lowercase accepted status col added in so the user can type in lower or upper case

1.4.64 (19-Aug-2014)

Added Ucase on C_LOADED and C_ACCEPTED in load record (Wsection) to recognise lower or uppercase Accepted/Loaded
Fixed issue in validator Revision where already current revisions were erroring on update due to being an "Already existing Revision"

1.4.63 (18-Aug-2014)

Added in a TO_CHAR in Initialise for attachments as R12 instances were causing a server error

1.4.62 (05-Aug-2014)

Added ValidatorNumeric to Starting Lot Number to allow Blanks and 0 or greater values

1.4.61 (30-Jul-2014)

Fixed in attMod where quotes remained around attachment.ID2 and .ID3 which was causing an issue with the attachment upload ID's - removed quotes

1.4.60 (24-Jul-2014)

Wizard now terminates objects that continue to hold memory when they are no longer needed, as Excel was crashing when reaching 1.4GB of memory in Task Manager
Added in Call to SetStatusColumn to set status of successfully uploaded attachment in attMod
Fixed Issue where on Refresh the Upload all Attachments MsgBox was appearing for every Row and section

1.4.59 (21-Jul-2014)

Changed Validate_Attachment in attMod to call LoadxmlData first then check for existing attachment data
Removed ValidatorNumeric from Minimum Order Quantity as Oracle also allows negative and zero values

1.4.58 (19-Jul-2014)

Fixed attachment upload issue when encountering special character in attachment content ie "'" To fix added in a Prepare_String in module attMod Validate_Attachment Added in call to UploadAttachmetns in Refresh code when uploading items

1.4.57 (17-Jul-2014)

Added check for Ucase ACCEPTED/Accepted and LOADED/Loaded in WSection - SetRowStatus. Otherwise the status was being cleared when status was written like "Accepted"

1.4.56 (15-Jul-2014)

12.2 fix long_to_char sql errors
Upgraded to core 209
Fix in procedures: modFlex.GetTableBasedLOV and modFlex.CreateSpecialValidation

1.4.55 (09-Jul-2014)

Added a check for package body's less than 10400 else include custom package (x_disable_custom_dml => " & G_DisableCustomDML)

1.4.54 (09-Jul-2014)

Added a join on the 'Service Contract Template' column Where SQL to become SI.COVERAGE_SCHEDULE_ID=SERTEMP.ID(+)

1.4.53 (03-Jul-2014)

Added support for custom package call to validate/update interface records. If debug sheet exists then update cannot be invoked

1.4.52 (26-Jun-2014)

Removed reference to maxrows in download selected as download form can set the maxrows and accidentally limit the download

1.4.51 (23-May-2014)

In Support Module Changed Application.StatusBar call from "Determining Start" to "Determining Start"

1.4.50 (23-May-2014)

Changed dependency for Cycle Count to allow the control to be enabled when a Contract Item Type is selected

1.4.49 (23-May-2014)

Added Red and Green load colors for failed or successful upload/validate in frmProgress

1.4.48 (21-May-2014)

Added in validator for Contract_Item_Type checking for Service/Warranty/Usage and setting Cycle_Count, Purchased, Shippable, Returnable, Check_ATP and Billing_Type accordingly

1.4.47 (09-May-2014)

Updated fndBlockList

1.4.46 (07-May-2014)

Imported the Core code version 208

1.4.45 (06-May-2014)

Changed select statement for Accounting Rule in records sheet

1.4.44 (05-May-2014)

Added in scroll bar on frmItem in the header frame block to allow for dynamic sizing on build

1.4.43 (05-May-2014)

Fixed logic in ValidatorEAM for EAM Type Serial Number Generation

1.4.42 (01-May-2014)

Added in Created From and To date Filter on download form

1.4.41 (17-Apr-2014)

Fixed up incorrect error messages in ValidatorEAM

1.4.40 (04-Apr-2014)

Modified RefreshStatus code to look for the last row with data rather than blankLines<500 as this was ignoring records further down

1.4.39 (02-Apr-2014)

UN Number is now a restricted list on the form to allow for many values

1.4.38 (31-Mar-2014)

Validator Supplier Locator now clears the locator field in the form in the subinventory has no locators

1.4.37 (26-Mar-2014)

Implemented new subInventoryCol property for ValidatorSupplierLocator to allow implementation of Process MFG Locator Columns
Corrected download columns for Process Supply Locator and Process Yield Locator

1.4.36 (21-Mar-2014)

Completed Implementation of ProcessMFG columns

1.4.35 (14-Mar-2014)

Added new function CacheOrgList which creates a global string of all the orgs. This used when validating items for performance reasons

1.4.34 (12-Mar-2014)

Commented ReactivateCurrentRibbonTab and StoreCurrentRibbonTab to prevent ribbon errors on closing the workbook
Added progress bar for uploading
Implemented Validator Template to handle defaulting from template during sheet validation

1.4.33 (06-Mar-2014)

Changed accounting rule in records sheet to handle type PP_DR_ALL

1.4.32 (20-Feb-2014)

Corrected ENABLE_SERVICE_BILLING to SERV_BILLING_ENABLED_FLAG as was causing sql error
Updated Core Code to 205.28 (Unreleased Version) - Disabled loop with doEvents in ExecuteQuery

1.4.31 (17-Feb-2014)

Changes to ribbon code: Added a check on RibbonPropPage in StoreCurrentRibbonTab2 due to errors when exiting the pgm

1.4.30 (04-Feb-2014)

Moved required functions from fndRibbonStubs into IWRibbonStubs and then removed fndRibbonStubs

1.4.29 (03-Feb-2014)

In DefaultUOM Check if a value exists for template - Don't default if template exists'.
Update Ribbon Code

1.4.28 (30-Jan-2014)

Modified core 205. fndXMLHTTP. MaxBytes changed to 15000 to fix "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" caused by a combination of non-ascii chars, database version and our architecture on 11.5.10

1.4.27 (08-Jan-2014)

Fixed problem with the validation of the supplier locator

1.4.26 (31-Dec-2013)

Updated ErrorHandling code in Initialise, Main and Upload
Added Contract Duration Period and Contract Duration

1.4.25 (31-Dec-2013)

Changed download via form to use "AND (si.inventory_item_id,si.organization_id) IN ((229627,204), (229628,204)....)"

1.4.24 (23-Dec-2013)

DownloadSelected - Do not look at columns beyond the last column with data as it causes the Wizard to hang on large sheets

1.4.23 (19-Dec-2013)

Download Selected no longer downloads when only Eng Item is entered for criteria... Eng Item is blanked out if it was defaulted in this case

1.4.22 (19-Dec-2013)

Columns that use ValidatorUOM no longer have loose dependence on the Item Number
Added sub call addCategoryCriteria to DownloadSelected, this will add Category and Category Set criteria to the download including tables and joins for the sections
Commented Loop in ExecuteQuery and set xmlHTTP.Open last parameter to false. This is to prevent the item form trying to load during frmDownload download
Don't set isFormReturn False at the bottom of DownloadSelected, we need this True to prevent queued events from opening forms after download

1.4.21 (22-Nov-2013)

Added the form substitute MTL_SYSTEM_ITEMS.INVENTORY_ITEM_MIR for the Item Number

1.4.20 (23-Oct-2013)

In ValidatorItem we only want to set the column type = C_STATIC when validating master items otherwise dependencies get incorrect parameters

1.4.19 (02-Oct-2013)

Fixed problem with category set tables and joins not being added for catalog section

1.4.18 (23-Sep-2013)

Added Engineering Item column to template

1.4.17 (18-Sep-2013)

Imported the Core code version 205

1.4.16 (16-Sep-2013)

Fixed problem with the generate item on the item form

1.4.15 (26-Aug-2013)

Updated WColumn and ValidatorGeneric - changed use of col.getEntityList.getRow to col.getRow, same with getRowWithUnique
Changed Category Validators on the download form to use validatorGeneric and searchDependentLOV so that the list is cleared on category set change

1.4.14 (20-Aug-2013)

Changed dependencies for Category to no longer be "loose" as it was causing a sql error
Removed caching of flexnumber in ColumnSupportControl as it was causing wrong data to be returned
Added KFF searches for CategoryFrom and CategoryTo on the download form, dependent on category set

1.4.13 (14-Aug-2013)

Added Check to WizardCheckFunctions to set the Wizard Master and Child functions to EAM if it is enabled and Engineering is not

1.4.12 (13-Aug-2013)

Changed Engineering item flag only to default to No when the field is blank on download selected

1.4.11 (05-Aug-2013)

Added new controls to download form to download Engineering Items only and Specific category sets

1.4.10 (12-Jul-2013)

Changed DefaultProfile to only default in Create mode

1.4.09 (26-Jun-2013)

Changed dependence on record sheet for Inspection Required from valueIfNoMatch:DISALBE to valueIfNoMatch:N

1.4.08 (17-Jun-2013)

Fixed the organisation control for the item

1.4.07 (17-Jun-2013)

Added isDownload parameter to initialiseColumns so the attribute columns are set correctly before a download

1.4.06 (07-Jun-2013)

Changed sql Column and Validate Column for category on record sheet from cat.description to cat.concatenated_segments

1.4.05 (28-May-2013)

Added order by 1 to category column sql
Changed frmFlexCombinations to include a description if one exists

1.4.04 (23-May-2013)

Added exception to AddRecord in Upload code to set time fence days to C_VALUE_BLANK when the corresponding time fence code is not user defined (4)
Changed record sheet for physical attribute group to allow decimal values

1.4.03 (27-Mar-2013)

Updated to Core 203

1.4.02 (14-Jan-2013)

Check ENG_ITEM_FLAG has already been included in Item sql before adding
Ensure the id column is on spreadsheet before setting mandatory ie section not in use

1.4.01 (31-Dec-2012)

Created Ribbons toolbar

1.3.75 (20-Dec-2012)

Turned tracing off in Load_File_R12 procedure
Changed call to m4aServlet/uploadfile

1.3.74 (07-Nov-2012)

Missing:RESTRICT from the Category sql

1.3.73 (11-Oct-2012)

Ensure WIZARD_MASTER_FUNCTION is set during the post_login_events

1.3.72 (10-Oct-2012)

Fixed problem with the ValidateGeneric introduced in common code update

1.3.71 (03-Oct-2012)

Added Check for EAM users to allow item master access for form function EAM_INVIDITM_ORG

1.3.69 (30-Jul-2012)

Added support for 64 bit Excel

1.3.68 (05-Jul-2012)

Technical update – Fixed problem where dependence data was not set in WColumn

1.3.67 (26-Jun-2012)

Technical update – Update to the latest generic code

1.3.66 (29-Apr-2012)

Fixed issue with container type and containerised flags attributes not displaying correctly

1.3.65 (27-Apr-2012)

Fixed issue where DFFs disappear after loading, even though they loaded

1.3.64 (24-Apr-2012)

Ensure that columns dependent on the item are using the Inventory_Item_ID

1.3.63 (18-Mar-2012)

Changed submit program to use 1 or 2 rather than Y – N for submit concurrent request, otherwise there are issues updating child level items

1.3.62 (16-Mar-2012)

Technical update – Extended the record sheet to include extended row

1.3.61 (21-Feb-2012)

Updated download to allow % on download LOV fields and added description to the download selection

1.3.60 (13-Feb-2012)

Changed Item Validation to ensure inventory_item_id is set if Item exists against Master Organization

1.3.59 (13-Feb-2012)

Ensure creation of Master takes into account inventory_item_id as this isn’t set for master

1.3.58 (09-Feb-2012)

Changed record sheet so description would allow 239 characters rather than 200
Changed long description to accept up to 3900

1.3.57 (02-Feb-2012)

Added check for attachment status column

1.3.56 (01-Feb-2012)

Updated Wizard to load European decimal comma’s as points

1.3.55 (26-Jan-2012)

Technical update – download module

1.3.54 (16-Jan-2012)

Changed List of Values for ATP Rule to have a command button due to customers having lists greater than 1000 records

1.3.52 (21-Nov-2011)

Set lot divisible to only be available for r12

1.3.51 (21-Nov-2011)

Fixed issue inventory_item_id not set correctly because unique column is set as COMBINATIONX (probably for some other reasons)

1.3.50 (28-Oct-2011)

Fixed issue with lot divisible not validating correctly

1.3.49 (28-Oct-2011)

Fixed issue with copy attachment function

1.3.48 (26-Oct-2011)

Fixed the download from form

1.3.47 (26-Oct-2011)

Added Lot Divisible

1.3.46 (05-Oct-2011)

Corrected the record sheet for the source organization

1.3.45 (26-Sep-2011)

Added a check to only validate record if at least one section has data to process

1.3.44 (01-Sep-2011)

Removed dependence on service item type for shippable flag

1.3.43 (24-Aug-2011)

Added in check for attachment upload to make sure it doesn’t already exist.  If so then error it

1.3.42 (22-Aug-2011)

Added organization to download attachment sqlAdded latest generic code

1.3.41 (19-Aug-2011)

Added attachment download

1.3.40 (19-Aug-2011)

Tax code change, to populate the interface with the tax code = ‘!’ when setting it from No to Yes

1.3.39 (12-Aug-2011)

Fixed blank record functionality trying to set some values as char’s at time of insert rather than -999999 number.The following attributes are not allowed [BLANK]column INVENTORY_PLANNING_CODEcolumn PLANNING_MAKE_BUY_CODEcolumn MRP_SAFETY_STOCK_CODE

1.3.38 (29-Jul-2011)

Removed check against the MTL_SYSTEM_ITEMS.REVISION_QTY_CONTROL_CODE as does not control revision level

1.3.37 (05-Jul-2011)

Ensure only id’s are passed to the Item procedure

1.3.36 (30-Jun-2011)

Made revisions controlled at child org

1.3.35 (27-Jun-2011)

Added handler if they require a prefix for item generation ie “[PRE]”

1.3.34 (15-Jun-2011)

Fixed problem with UOM linked against inventory item

1.3.33 (20-May-2011)

Attachments loader now able to upload files directly from HTTP(s) sources
Added message to attachment form when load completed

1.3.32 (18-May-2011)

Fixed attachment form not erroring when columns are missing
Fixed issue with primary UOM when updating attachment or revision

1.3.31 (17-May-2011)

Fixed download revision sql join

1.3.30 (16-May-2011)

Added organization_id link between revision and item table

1.3.29 (10-May-2011)

Fixed problem with UOMs when mode changed and child org swapped to master

1.3.28 (07-May-2011)

Improved error handling for copy item attachment function

1.3.27 (06-May-2011)

Updated Attachment Code, causing upload error

1.3.26 (05-May-2011)

Corrected the Download from Interface in case certain columns not set

1.3.25 (04-May-2011)

Changed DFF form code to ensure id Columns are returned correctly

1.3.24 (04-May-2011)

Create new template with Status Columns on the left

1.3.23 (04-May-2011)

Added support for DFFs 16-30

1.3.22 (29-Apr-2011)

Added in Copy from another item attachment function to the wizard

1.3.21 (26-Apr-2011)

Fixed problem when the current category is missing in update mode

1.3.20 (06-Apr-2011)

Fixed union join in MTL_DEFAULT_CATEGORY_SETS

1.3.19 (05-Apr-2011)

Added check for MTL_DEFAULT_CATEGORY_SETS

1.3.18 (04-Apr-2011)

Fixed problem with revision interface id
Fixed problem with locator update

1.3.17 (01-Apr-2011)

Added handler in case new category left off the sheet

1.3.16 (31-Mar-2011)

Added handler in case effective date left off the sheet

1.3.15 (31-Mar-2011)

Added the New Category column to support category update
Added latest generic and concurrent form code

1.3.14 (30-Mar-2011)

Fixed the DFF and Locator KFF

1.3.13 (18-Mar-2011)

Changed Revisions deletion to use last_update_login instead of created_by
Added check to see if revision already exists in Validator

1.3.12 (16-Mar-2011)

Changed Revisions to use last_update_login to keep track of interface errors
Removed order by on the download from interface..error after copy

1.3.11 (15-Mar-2011)

Fixed problem with copy functionality
Ensure column reference set before setting results column

1.3.10 (10-Mar-2011)

Changed the behaviour for deriving an item so that is occurs after validation during isValidUpload
Only unload form if it has been loaded previously
Fixed revision validator and refresh

1.3.9 (09-Mar-2011)

Added support for [BLANK] to set column values back to null

1.3.8 (24-Feb-2011)

Ensured Item Number required when loading in create mode

1.3.7 (21-Feb-2011)

Fixed problem with concurrent request screen log button not working correctly for alternate login mode

1.3.6 (18-Feb-2011)

Fixed problem with catalogs not loading correctly

1.3.5 (15-Feb-2011)

Fixed revision refresh

1.3.4 (08-Feb-2011)

Fixed problem with category creation when item already exists – package changed
This change includes the requirement to use the new category column

1.3.3 (07-Feb-2011)

Added revisions
Updated generic and common code

1.1.113 (22-Sep-2010)

Ensure missing item number column handled during download

1.1.112 (21-Sep-2010)

Fixed problem with Orderable on the Web LOV field

1.1.111 (21-Sep-2010)

Throw error if item number not set

1.1.110 (17-Sep-2010)

Corrected download from interface
Corrected download org LOV
Fixed problems with LOV on Receipt Routing download
Fixed problem with Billing Type download column
Made download using selection use the maxRows from setting123
Changed download using selection to use cell text instead of the default value
Set the sqlColumn used for the UOM loose dependence
Fixed the item description list of values on download form
Ensure TemplateABC is always hidden
Removed unload frmItem during initialise
Ensure deleteSQL is not blank prior to calling accumSQL
Fixed problem with material sub element error when blank
Fixed problem with copyFromItem when return column not set
Fixed problem with frmItem Activate called at end of download selection

1.1.109 (14-Sep-2010)

Fixed problems with inconsistency in download results between download options

1.1.108 (04-Sep-2010)

Fixed records sheet with invalid columns, removed support for some service columns until requested by customers

1.1.107 (26-Aug-2010)

Added the ValidatorDependentDefault

1.1.106 (25-Aug-2010)

Added isAllowedNull to the ValidatorMinMax

1.1.105 (17-Aug-2010)

Added Material Cost and Material Sub Element

1.1.104 (09-Aug-2010)

Fixed problem with Download form duplicating the Attribute columns causing sql error

1.2.3 (08-Dec-2010)

Added latest generic code including request viewer

1.1.103 (02-Aug-2010)

Fixed problem with UOM sql created in 1.1.92

1.2.2 (01-Nov-2010)

Fixed problem with Section Header missing if first record in section not

1.1.102 (27-Jul-2010)

Fixed issue where planner code not a combo box
Added in set process id as a required field to stopcategory load issues

1.2.1 (21-Oct-2010)

Fixed problem introduced with 1.2.0

1.1.101 (27-Jul-2010)

Fixed problem with AddRow when item loaded to multiply orgs

1.2.0 (20-Oct-2010)

Changed call to improve SGS performance -requires latest package

1.1.100 (26-Jul-2010)

Changed download form to use implementation

1.1.99 (23-Jul-2010)

Changed mismatch in sub organization query with item dependence

1.1.98 (22-Jul-2010)

Reverted the determine start code: require new method to open attachment form when entire row blank

1.1.97 (20-Jul-2010)

Updated screen updating during download

1.1.96 (20-Jul-2010)

Changed attachment form to not open if item link cannot be found

1.1.95 (16-Jul-2010)

Fixed problem when attachment form opened and then closed and reference lot to unloaded form

1.1.94 (06-Jul-2010)

Added dependence tag to header comments

1.1.93 (05-Jul-2010)

Changed the ValidatorValueDependent to throw error when Required dependence missing

1.1.92 (30-Jun-2010)

Updated the UOM sql to accommodate problems where the item is invalid

1.1.91 (28-Jun-2010)

Updated the UOM sql

1.1.90 (23-Jun-2010)

Corrected download and attachment problems

1.1.89 (17-Jun-2010)

Fixed problem with the Copy From functionality

1.1.88 (13-May-2010)

Added latest generic/common code
Added support for Copy From at the interface table level. Requires package change

1.1.87 (10-May-2010)

Fixed issue with validate values dependent ‘Or’ validation not working correctly.
Fixed issue with ATP component not looking at correct wip supply type value

1.1.86 (10-May-2010)

Added Attachment Functionality

1.1.85 (05-May-2010)

Removed message when value changed to [Blank]

1.1.84 (03-May-2010)

pdated safety stock to allow zero

1.1.83 (23-Apr-2010)

Incorrect template definition in record sheet causing downloader to try to load template

1.1.82 (23-Apr-2010)

Fixed ATP_FLAG issue causing template to not apply correctly

1.1.81 (22-Apr-2010)

Reloaded toolbar to stop bug for French users
Removed end brackets on bind SQL as this is not allowed ie :P1)
Updated common modules to fix upload problem with non-ascii characters in R12

1.1.80 (17-Apr-2010)

Re-installed non DoEvents version of fndxMLHTTP. Changed the name to itemXMLHTTP to preserve this code

1.1.79 (15-Apr-2010)

Added CopyItemNumber and TemplateName to download from interface

1.1.78 (15-Apr-2010)

Fixed copy from functionality to work as expected (Except oracles interface doesn’t)

1.1.77 (14-Apr-2010)

Clear list of values Data after opening download form

1.1.76 (09-Apr-2010)

Ensure invalid records are not passed to upload

1.1.75 (19-Mar-2010)

Updated the common code

1.1.74 (18-Mar-2010)

Improvements to Toolbar behavior

1.1.73 (18-Mar-2010)

Fixed problem with the Context when value set in use on DFF

1.1.72 (17-Mar-2010)

Common RCMenu and Toolbar modules implemented

1.1.71 (05-Mar-2010)

Update generic code for R12 org list of values error

1.1.70 (02-Mar-2010)

Updated common code to improve caching for LOV

1.1.69 (18-Feb-2010)

Update generic code to support new license model

1.1.68 (15-Feb-2010)

Added bind parameters to improve speed on the refresh

1.1.67 (08-Feb-2010)

Added download selected using item and organization code

1.1.65 (29-Jan-2010)

Fixed problem with form grid

1.1.64 (28-Jan-2010)

Changed record sheet dependency and query on wip supply sub inventory as it was too restrictive

1.1.63 (12-Jan-2010)

Updated the max rows to be ignored for the child section so max rows only affects the header item level records

1.1.60 (08-Jan-2010)

Stopped download query from downloading items in other sets of books

1.1.59 (08-Jan-2010)

Added Category Set to download criteria

1.1.58 (21-Dec-2009)

Fixed problem with initialize of master data prior to dependent parents

1.1.57 (02-Dec-2009)

Fixed bug with the SQL for the column Purchasing Asset Category

1.1.56 (02-Dec-2009)

Added tab security for all form functions

1.1.55 (24-Nov-2009)

On update check for engineering products

1.1.54 (18-Nov-2009)

Incorporated the Engineering requirements

1.1.53 (14-Nov-2009)

Added the concurrent request viewer

1.1.52 (02-Nov-2009)

Updated EAM validation where R12 doesn’t care if asset group is transactable
Changed long description length to handle 3800 characters rather than just 200

1.1.51 (30-Oct-2009)

Added EAM validation

1.1.50 (06-Oct-2009)

Corrected ValidatorExpenseAccount when value entered and conditions correct

1.1.49 (05-Oct-2009)

Removed error where catalog left blank

1.1.48 (10-Aug-2009)

Fixed problem with deletion of large number interface rows

1.1.47 (02-Aug-2009)

Fixed problem with reset of process set id

1.1.46 (27-Aug-2009)

Removed doEvents from fndXMLHTTPDoEvent

1.1.45 (17-Aug-2009)

Changed clear status columns to work for a selection

1.1.44 (28-Jul-2009)

Added new validator for Supply Locator

1.1.43 (24-Jul-2009)

Changed default validate column to FLEX_COMBINATION fromFLEX_VALUE

1.1.42 (22-Jul-2009)

Fixed problems with Supply Locator and Subinventory on update

1.1.41 (07-Jul-2009)

DFF’s not showing up when you select them in the customize columns form. Fixed DFF record sheets as they had corrupt data

1.0.40 (04-Jul-2009)

Added Support for multi segment item key flexfield Fixes
Fixes Issue where costing enabled causing wizard to error
Fixes Issue where descriptive flexfield ID’s rather than values are downloaded
Fixes issue R12 concurrent program when running the item import
Stops the wizard updating a category within a category set if that category value doesn’t change during an update.
Note: v1.0.31-39 included internal updates not released to users

1.0.40 (04-Jul-2009)

Added Support for multi segment item key flexfield Fixes
Fixes Issue where costing enabled causing wizard to error
Fixes Issue where descriptive flexfield ID’s rather than values are downloaded
Fixes issue R12 concurrent program when running the item import
Stops the wizard updating a category within a category set if that category value doesn’t change during an update.
Note: v1.0.31-39 included internal updates not released to users

1.0.30 (08-Jun-2009)

Re-Fixed concurrent request to work with r12 parameters

1.0.29 (07-Jun-2009)

Fixed concurrent request to work with r12 parameters

1.0.28 (06-Jun-2009)

Updated concurrent request to work with r12 parameters

1.0.27 (25-May-2009)

Removed carriage returns from sql. Updated download for concatenated segments

1.0.26 (24-May-2009)

Changed message when default value set to blank. Corrected Expense Account validation

1.0.25 (12-May-2009)

Fixed problem with return column when uninitialized when refreshed

1.0.24 (11-May-2009)

Fixed combination sql to work with Organization Chart Of Accounts ID

1.0.23 (10-May-2009)

Made accounts dependent on Organization Chart Of Accounts ID

1.0.22 (09-May-2009)

Corrected results return after reload

1.0.21 (24-Apr-2009)

Updated Planning Time Fence list of values to MTL_TIME_FENCE

1.0.20 (01-Apr-2009)

Fixed problems with catalogs

1.0.19 (11-Mar-2009)

Added Application. ScreenUpdating = True for cursor refresh

1.0.18 (10-Mar-2009)

Fixed problem with initialization of KFF and incorrect setting of Cancel Flag

1.0.17 (03-Mar-2009)

Fixed changes in download where category columns absent from wizard

1.0.16 (02-Mar-2009)

Changed required fields based on mode and master

1.0.15 (11-Feb-2009)

Corrected problem with the Item ID being transferred from copied item

1.0.14 (28-Jan-2009)

Updated message handler to retain copy from and template values

1.0.13 (27-Jan-2009)

Added cell comment to column headers
Made interface id mandatory is section in use

1.0.12 (21-Nov-2008)

Changed return result when id column not specified for a section

1.0.11 (11-Nov-2008)

Reintroduced load_counter lost with custom_install

1.0.10 (07-Nov-2008)

Fixed problem with column reset

1.0.9 (05-Nov-2008)

Fixed problem with child records not loading because status columns are no longer cell bound

1.0.8 (04-Nov-2008)

Fixed problem with download and refresh functionality

1.0.7 (03-Nov-2008)

Else values passed to interface table for processing.
Added an Apply button to activate the template and copy from fields
Throw error message if -999 returned as exception
Fixed problem with non cell bound columns not creating on a new sheet
Increased the download capability to include User Item Type, Item Status and Categories

1.0.6 (07-Oct-2008)

Added support for status codes

1.0.5 (06-Oct-2008)

Added support for profile defaults

1.0.4 (17-Sep-2008)

Added ability to use ACCEPTED records to load child records
Added delete for interface table

1.0.3 (05-Sep-2008)

Fixed issues with template not validating dependents

1.0.2 (28-Aug-2008)

Fixed problem with Org and Item validation when value invalid

1.0.1 (27-Aug-2008)

Fixed problem with form error when org not set