1.7.65 (22-May-2025)

Fixed error of Method 'Pastespecial' of object'_Worksheet' failed.

1.7.64 (23-Apr-2025)

Fixed the error of Error 1004 (Application-defined or object-defined error) when creating a new qualifier.

1.7.63 (25-Mar-2025)

Internal update.

1.7.62 (15-Oct-2024)

Added Default Browser Login option.

1.7.61 (09-Oct-2024)

Fixed issue of "Whitespace is not allowed at this location" when line number contains apostrophes.

1.7.60 (18-Jul-2024)

Modifier Number - Fixed bug where modifier number could cause the following error: Run-time error "6".

1.7.59 (27-Mar-2024)

Improved Modifier Line download performance by modifying the subquery for Adjustment type.

1.7.58 (21-Feb-2024)

Made the Value From as required color in the Header Qualifier form.

1.7.57 (07-Feb-2024)

Internal update.

1.7.56 (05-Feb-2024)

Fixed the control order issues in the form.

1.7.55 (30-Jan-2024)

Fixed issue of color changes to green when opening the form.

1.7.54 (04-Jan-2024)

Fixed issue of adding colon onto the value in the 'Value From' field.

1.7.53 (04-Jan-2024)

Internal update.

1.7.52 (29-Nov-2023)

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

1.7.51 (16-Oct-2023)

Fixed the validation color issue: Blue color when Upload option is Validate only and green color when Upload option is Validate and Commit.

1.7.50 (11-Oct-2023)

Fixed digital signature issue while creating a new sheet.

1.7.49 (10-Oct-2023)

Added new digital signature.

1.7.48 (03-Oct-2023)

Fixed issues with multi value found in the Qualifiers section.

1.7.47 (04-Sep-2023)

Fixed the issues of A Bucket value is not required for manual modifiers when bucket value is empty in the sheet.

1.7.46 (01-Sep-2023)

Fixed the issue when not able to create second Line Qualifier records.

1.7.45 (31-Aug-2023)

Fixed the Query Log disappear issues.

1.7.44 (01-May-2023)

Internal update.

1.7.43 (27-Apr-2023)

Internal update.

1.7.42 (18-Apr-2023)

Fixed the BLANK issues in DFF.

1.7.41 (27-Mar-2023)

Fixed incorrect error message for Price Break header type while line application method is not empty.

1.7.40 (27-Mar-2023)

Fixed the issue when Price Break section missing for Price Break Header type.

1.7.39 (17-Mar-2023)

Fixed the incorrect error message pop up in Pricing Phase at line level.

1.7.38 (10-Mar-2023)

Fixed the issue with Modifier Level not in ascending order.

1.7.37 (08-Mar-2023)

Fixed issue with UOM required when UOM is empty.

1.7.36 (07-Mar-2023)

Fixed the issue with UOM required when the type is 'Item Quantity' which is not respected at line level in the form.

1.7.35 (06-Mar-2023)

Fixed the 11i minimum package required issues.

1.7.34 (01-Mar-2023)

Added More4apps Enable UOM default to control the UOM defaulting.

1.7.33 (24-Feb-2023)

Fixed the Run-time error '381' when using Download form.

1.7.32 (23-Feb-2023)

Added the package minimum required for 11i.

1.7.31 (21-Feb-2023)

Fixed the issue with 'the bind identifier has to be non-zero length' in 11i.

1.7.30 (21-Feb-2023)

Fixed the issue with 'the bind identifier has to be non-zero length' in 11i.

1.7.29 (21-Feb-2023)

Fixed issue when cannot updating the continuous break in 11i.

1.7.28 (18-Jan-2023)

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

1.7.27 (05-Jan-2023)

Internal update.

1.7.26 (02-Dec-2022)

Internal update.

1.7.25 (28-Nov-2022)

Fixed date issue in the Download form.

1.7.24 (21-Nov-2022)

Internal update.

1.7.23 (14-Nov-2022)

Fixed the SQL issue in DFF setting (e.g. PO AgreementNumber Setting in 11i) with order by columns not in select clause.

1.7.22 (07-Nov-2022)

Fixed the invalid qualifier in the Qualifier section.

1.7.21 (01-Nov-2022)

Allow qualifier value written back to the sheet if user only puts the value on the sheet (without combination).

1.7.20 (28-Oct-2022)

Internal update.

1.7.19 (28-Oct-2022)

Fixed the Qualifier form performance issue.

1.7.18 (27-Oct-2022)

Fixed the combination issues for the qualifier value from when data has spaces at the end.

1.7.17 (27-Oct-2022)

Internal update.

1.7.16 (27-Oct-2022)

Fixed the combination issues for the qualifier value from when data has spaces at the end.

1.7.15 (25-Oct-2022)

Fixed searching issue on the 'value from' - first click bring empty data, only second click bring data on the Qualifier value from.

1.7.14 (25-Oct-2022)

Fixed the form loading with infinite loop issues while clicking on the search button without search criteria.

1.7.13 (04-Oct-2022)

Fixed tab defaulting issue in the Download form.

1.7.12 (04-Oct-2022)

Internal update.

1.7.11 (19-Sep-2022)

Internal update.

1.7.10 (24-Aug-2022)

Header/Line Qualifier order now downloads by the Line Group Number.

1.7.09 (20-May-2022)

Internal update.

1.7.08 (20-May-2022)

Fixed the run-time error '9999' - frmDownloadSelected.startup while downloading with Name and product value together.

1.7.07 (12-Apr-2022)

Fixed the UOM performance issue while uploading large data.

1.7.06 (11-Apr-2022)

Fix for one-drive saving issue by removing code from the on_save event.

1.7.05 (18-Mar-2022)

Internal update.

1.7.04 (18-Mar-2022)

Fixed the bucket issue in line level.

1.7.03 (18-Mar-2022)

Improved performance with uploading large line data.

1.7.02 (18-Mar-2022)

Fixed issue with getting error message 'Multiple qualifier meaning values found'.

1.7.01 (18-Mar-2022)

Updated ribbon message for icon when hovering over it.

1.7.00 (04-Mar-2022)

Fixed form open issue while double-clicking on the form.

1.6.99 (04-Mar-2022)

Fixed the issue of product value not found.

1.6.98 (04-Mar-2022)

Fixed the opening tab issue when opening the Download form.

1.6.97 (04-Mar-2022)

Update the ribbon message.

1.6.96 (04-Mar-2022)

Update the message when hovering over the 'Upload All' icon on the ribbon.

1.6.95 (28-Feb-2022)

Fixed the download issue when blank row between multiple download data.

1.6.94 (28-Feb-2022)

Internal enhancement.

1.6.93 (28-Feb-2022)

Fixed type mismatch issue when opening Modifier Header form.

1.6.92 (28-Feb-2022)

Internal enhancement.

1.6.91 (21-Feb-2022)

Fixed the ModifierLineInfo.ValidateProductValue encountered a runtime error at line 440.

1.6.90 (21-Feb-2022)

Fixed the validation fired for 'every' keystroke field - Parent Number.

1.6.89 (18-Feb-2022)

Fixed the download form cut off issues.

1.6.88 (17-Feb-2022)

Added message to icon when hovering over the 'Download using sheet data'.

1.6.87 (17-Feb-2022)

Fixed the incorrect error message using 'Download using sheet data'.

1.6.86 (03-Feb-2022)

Fixed the error message 'Incompatibility Group' when using Blank features for Incompatibility Group field.

1.6.85 (27-Jan-2022)

Fixed issue with validation fail while opening 'pricing Modifiers Line Qualifiers' form.

1.6.84 (24-Dec-2021)

Internal update.

1.6.83 (24-Dec-2021)

Internal update.

1.6.82 (20-Dec-2021)

Fixed the Terms Attributes, Terms Value and Application validation on the form.

1.6.81 (16-Dec-2021)

Fixed the Terms Attributes, Terms Value and Application validation when Modifier type is Deal and line type is Terms Substitution.

1.6.80 (10-Dec-2021)

Fixed issue where getting a SQL error when querying customer order on the Pricing Header Qualifier form.

1.6.79 (09-Dec-2021)

Fixed the error message with Application - defined error.

1.6.78 (08-Dec-2021)

Fixed issue with UOM mandatory. Removed the UOM required except Item Quantity type.

1.6.77 (25-Nov-2021)

Turned the Logging Off.

1.6.76 (25-Nov-2021)

Fixed issue with not being able to update the Global flag when the profile option is Yes.

1.6.75 (29-Sep-2021)

Fixed issue with not being able to update Date Time context in Qualifier section.

1.6.74 (29-Sep-2021)

Fixed the issue with not being able to create a new line qualifier when creating a new line.

1.6.73 (29-Sep-2021)

Added [Blank] feature for FirstDateType, SecondDateType, First Start Date and Second End Date.

1.6.72 (03-Sep-2021)

Added [Blank] feature for Incompatibility Group field.

1.6.71 (30-Aug-2021)

Added line download filter to the Wizard.

1.6.70 (05-Aug-2021)

Internal enhancement.

1.6.69 (27-Jul-2021)

Fixed the 9999 error message when opening the header form on a blank line.

1.6.68 (27-Jul-2021)

Internal enhancement.

1.6.67 (27-Jul-2021)

Added six columns: 'Date Type I' and associated 'Start Date' and 'End Date'. 'Date Type II' and associated 'Start Date' and 'End Date' in the Wizard.

1.6.66 (14-Jun-2021)

Fixed typo in error message.

1.6.65 (14-Jun-2021)

Fixed the issue with Qualifier validation.

1.6.64 (14-Jun-2021)

Fixed the error message for Effective From date and fixed the issue of UOM data not being removed from form.

1.6.63 (14-Jun-2021)

Fixed the Run-time error when product value is incorrect and the value from is incorrect.

1.6.62 (14-Jun-2021)

Fixed the Validation for Get Item Type when line type is other item discount.

1.6.61 (04-Jun-2021)

Fixed the Application Method issues.

1.6.60 (04-Jun-2021)

Fixed the Charge Name and Application Method issues.

1.6.59 (04-Jun-2021)

Fixed the duplicated Qualifier DFF issue in LOVs.

1.6.58 (04-Jun-2021)

Fixed the layout issue.

1.6.57 (04-Jun-2021)

Fixed the issue with Qualifier context issues while value set is nothing.

1.6.56 (31-May-2021)

Fixed the issue with DFF context form reference in the header and download context problems.

1.6.55 (14-May-2021)

Fixed the issue with Price Break Type Volume type.

1.6.54 (14-May-2021)

Fixed the issue with Price Break Type modifier type issues.

1.6.53 (14-May-2021)

Fixed the issue with Price Break Type modifier type issues.

1.6.52 (14-May-2021)

Fixed the issue with Price Break Type data input with the profile QP: Continuous Price Breaks.

1.6.51 (20-Apr-2021)

Updated security.

1.5.151 (12-Jul-2019)

Fixed the issue of Application Method validation when Modifier is Discount List.

1.6.50 (20-Apr-2021)

Updated security.

1.5.150 (12-Jul-2019)

Fixed the issue of Asked For Flag validation and updating issues when it should not be.

1.6.49 (07-Apr-2021)

Updated security.

1.5.149 (12-Jul-2019)

Fixed the issue of Product Value/Attributes required for Discount List.
Fixed the issue of Default Accrue value when column is missing.

1.6.48 (16-Feb-2021)

Fixed the issue with defaulter DFF with form reference in additional list line level.

1.5.148 (12-Jul-2019)

Fixed the issue of the date range validation.

1.6.47 (16-Feb-2021)

Fixed the issue with double-clicking on the form.

1.5.147 (12-Jul-2019)

Fixed the issue of Creation/Updating the Formula in Price Break.

1.6.46 (27-Jan-2021)

Added the error log for workbook initialise.

1.5.146 (11-Jul-2019)

Fixed the issue of Price Break Value or Formula validation colour on the sheet.

1.6.45 (27-Jan-2021)

Fixed the issue with Bucket valiation.

1.5.145 (11-Jul-2019)

Fixed the issue of either Price Break Value or Formula had a value.

1.6.44 (27-Jan-2021)

Fixed the issue with Bucket validation.

1.5.144 (11-Jul-2019)

Fixed the issue of parent form closed while the child form is closing.

1.6.43 (12-Jan-2021)

Fixed issue where code blew up if no 'Volume type' in the spreadsheet. Fixed issue where code blew up with some version of the servlet.

1.5.143 (11-Jul-2019)

Fixed the issue of Comparison value validation message too often when modifier line type changes.

1.6.42 (09-Jan-2021)

Fixed issue with UOM defaulting in Discount List type.

1.5.142 (11-Jul-2019)

Fixed the issue of related child section presented when modifier line type changed.

1.6.41 (01-Dec-2020)

Updated security.

1.5.141 (11-Jul-2019)

fixed the issue of Discount value or Formula validation.

1.6.40 (01-Dec-2020)

Fixed issue with Product value required validation.

1.5.140 (11-Jul-2019)

Fixed the issue of Product Value required validation.

1.6.39 (20-Nov-2020)

Fixed issue with UOM defaulting for Not Promotion and not Discount line type.

1.5.139 (11-Jul-2019)

Fixed the issue of Accrue Discount must be required for Line type Promotional Goods.

1.6.38 (20-Nov-2020)

Fixed issue with UOM defaulting for Promotion and Discount line type.

1.5.138 (11-Jul-2019)

Fixed the issue of Application Method required message for Other Item Discount type.

1.6.37 (04-Nov-2020)

Fixed issue with fndLoginSSO error message.

1.5.137 (09-Jul-2019)

Fixed the issue of comparison validation message.

1.6.36 (04-Nov-2020)

Fixed issue with the price list operand as decimal.

1.5.136 (09-Jul-2019)

Fixed the issue with Download message.

1.6.35 (30-Oct-2020)

Fixed issue with Product Attributes and Product Value required for Discount.

1.5.135 (09-Jul-2019)

Fixed the issue of Error Message too often in Get Item section.

1.6.34 (06-Oct-2020)

Updated security.

1.5.134 (09-Jul-2019)

Fixed the issue of Error Message too often for UOM in Get Item section.

1.6.33 (12-May-2020)

Internal enhancement.

1.5.133 (09-Jul-2019)

Fixed the issue of Error Message while opening the Get Item form.
Fixed the issue of UOM dependence on Product Value.
Fixed the issue of UOM validation.

1.6.32 (12-May-2020)

Fixed download form issue when clicking on the modifier from search button twice.

1.5.132 (09-Jul-2019)

Fixed the issue of Comparison Value.

1.6.31 (29-Apr-2020)

Fixed the line date validation issues when header date start date equals to line date start.

1.5.131 (09-Jul-2019)

Fixed the bug of the pop-up message after the updating process finish.

1.6.30 (29-Apr-2020)

Fixed the error message issue.

1.5.130 (08-Jul-2019)

Fixed the issue of duplicated records while download via sheet.
Fixed the bug of download counter errors.

1.6.29 (29-Apr-2020)

Internal fix.

1.5.129 (08-Jul-2019)

Fixed the issue of empty Line Modifier.

1.6.28 (29-Apr-2020)

Fixed issue with UOM being mandatory while the line level is Line and line type is Freight/Special Charge.

1.5.128 (05-Jul-2019)

Fixed the issue of Benefit Price List validation.

1.6.27 (29-Apr-2020)

Fixed issue with UOM being mandatory while the line level is order and line type is Freight/Special Charge.

1.5.127 (05-Jul-2019)

Removed the red colour of drop-down list while searching on the form.

1.6.26 (29-Apr-2020)

Fixed issue with Modifier Type validation while crating a new type but with same Modifier Number.

1.5.126 (04-Jul-2019)

Fixed the bug with Benefit Price List validation when selection is not in the list.

1.6.25 (28-Apr-2020)

Fixed issue with not being able to update the Charge Name.

1.5.125 (04-Jul-2019)

Fixed the issue with Price List validation for Get Item section.

1.6.24 (17-Apr-2020)

Internal enhancement.

1.5.124 (04-Jul-2019)

Fixed the issue with order of list of parent number.

1.6.23 (17-Apr-2020)

Internal enhancement.

1.5.123 (04-Jul-2019)

Fixed the issue with List data of parent number.

1.6.22 (17-Apr-2020)

Fixed issue with Template appearance.

1.5.122 (04-Jul-2019)

Fixed the issue of uploading Application Method when Line Type is ‘Order’.

1.6.21 (17-Apr-2020)

Fixed issue with not being able to create a new Get/Buy Item.

1.5.121 (04-Jul-2019)

Fixed the issue of updating Other Item Discount with blank product value and product attributes.

1.6.20 (17-Apr-2020)

Internal enhancement.

1.5.120 (03-Jul-2019)

Fixed the issue of Object variable not set when price break section is empty for Price Break Header.

1.6.19 (17-Apr-2020)

Provided the ability to Create/Update the Get/Buy Item DFF.

1.5.119 (03-Jul-2019)

Fixed the issue of Bucket disable while changing Line Type from ‘Order’ to ‘Line Around’.

1.6.18 (16-Apr-2020)

Fixed issue with getting error "Could not set the Value property' on the login form.

1.5.118 (03-Jul-2019)

Fixed the error of Example Sheet which contains Parent Number data for Non-Deal Modifier type.

1.6.17 (16-Apr-2020)

Fixed bug with default value in Get Item section and Buy Item section.

1.5.117 (03-Jul-2019)

Fixed the issue of Bucket validation.

1.6.16 (30-Mar-2020)

Fixed issue with removing value of ESTIM_ACCRUAL_RATE.

1.5.116 (02-Jul-2019)

Fixed the issue of pricing phase and volume type value when modifier type changes.

1.6.15 (30-Mar-2020)

Internal enhancement.

1.5.115 (02-Jul-2019)

Enabled the Bucket List in the form when needed.
Fixed the issue of Price Break Header validation.
Fixed the issue of updating the Get Item/Buy Item section when the modifier Line Type is ‘Price Break Header’.

1.6.14 (24-Feb-2020)

Fixed issue with removing Modifier Effect Date value.

1.5.114 (02-Jul-2019)

Fixed the issues of default Bucket value while the profile value is No.

1.6.13 (24-Feb-2020)

Fixed issue with removing line end date value.

1.5.113 (28-Jun-2019)

Fixed the issues of Application Method for Other Item Discount type.

1.6.12 (24-Feb-2020)

Internal enhancement.

1.5.112 (28-Jun-2019)

Fixed the issues of Percentage value always update to 0 when it is decimal.

1.6.11 (24-Feb-2020)

Updated the form control color.

1.5.111 (28-Jun-2019)

Fixed the issues of Application Method and Price List validation.

1.6.10 (24-Feb-2020)

Rebranding of logo and color schemes.

1.5.110 (26-Jun-2019)

Fixed the issues of Quantity back colour.

1.6.09 (24-Feb-2020)

Updated the Example sheet color.

1.5.109 (26-Jun-2019)

Fixed the issues of List Line Adjustment for Promotional Goods.
Fixed the issues of Promotional goods UOM validation in the uploading process.
Fixed the issues of updating Buy Item section when should not be allowed.

1.6.08 (29-Nov-2019)

Fixed issues with validation of Unit of Measure attributes.

1.5.108 (26-Jun-2018)

Fixed the issues of parent number validation.

1.6.07 (29-Nov-2019)

Fixed error when Automatic column is not on the sheet.

1.5.107 (26-Jun-2019)

Fixed the issues of Application Method in the Line level.

1.6.06 (27-Nov-2019)

Fixed issues with unable to remove formula value.

1.5.106 (24-Jun-2019)

Fixed the issues of List of value for Get Product Attribute in Get Item section.
Updated the error message as like EBS when pricing phase is not right.

1.6.05 (24-Sep-2019)

Fixed downloading error message when line section is missing in the spreadsheet.

1.5.105 (24-Jun-2019)

Fixed the issues of Promotional Get Item UOM dependence with Product Value.
Fixed the issues of Pricing Phase not allowed for Promotional goods.

1.6.04 (24-Sep-2019)

Internal enhancement.

1.5.104 (24-Jun-2019)

Fixed the issues of Group Line for both Promotional goods and Other Item Discount type.

1.6.03 (02-Aug-2019)

Added Processing form to allow users to stop the download.

1.5.103 (24-Jun-2019)

Internal enhancement

1.6.02 (02-Aug-2019)

Internal update.

1.5.102 (22-Jun-2019)

Fixed the issues of Empty Break Type List and Break type list value.

1.6.01 (02-Aug-2019)

Fixed the issue when clicking on the Download via form button in the Setup sheet.

1.5.101 (21-Jun-2019)

Fixed the issues of Pending status for uploading multiple lines.

1.6.00 (29-Jul-2019)

Internal update.

1.5.100 (21-Jun-2019)

Fixed the issues of getting current buy item details.

1.5.99 (21-Jun-2019)

Fixed the issues of written wrong UOM from spreadsheet to the form.

1.5.98 (19-Jun-2019)

Fixed the issues of failed to update the Value From/Value To, UOM, and Pricing Attributes when required.

1.5.97 (19-Jun-2018)

Fixed the issues of getting incorrect list value of Agreement Price list in the Header section.
Fixed the issues of empty Buy Value To data in the form.

1.5.96 (19-Jun-2019)

Fixed the issues of updating Get Application Method in the Get Item section.
Fixed the issues incorrect pop up message after updating process.
Fixed the issues of duplicated records based on our combination keys for Get Item/Buy Item sections.

1.5.95 (19-Jun-2019)

Fixed the issues of updating group number in the Buy Item section.

1.5.93 (17-Jun-2019)

Fixed the issues of updating 'Get Item' record for Other Item Discount type.

1.5.92 (14-Jun-2019)

Removed the product value required validation for Promotion type and Order line type.

1.5.91 (14-Jun-2019)

Fixed the issue of blank Quantity validation while opening the form for promotional goods type.

1.5.90 (13-Jun-2019)

Fixed the issue of 'Pending' Status issue when updating more than two modifiers.

1.5.89 (12-Jun-2019)

Changed the layout of Modifier Line form and Template123.

1.5.88 (12-Jun-2019)

Added dependence to the UOM in the Buy Item section.
Cached the item UOM list in the Buy Item section to improve the performance.

1.5.87 (07-Jun-2019)

Changed the layout of Template and Buy Item form.
Fixed the issue of Default value of Buy UOM in Buy Item section.

1.5.86 (07-Jun-2019)

Added new modifier line type Other Item Discount and related section.

1.5.85 (16-May-2019)

Internal enhancement.

1.5.84 (08-May-2019)

Added Buy Item Details product value instead of using line details product value.

1.5.83 (01-May-2019)

Updated security.

1.5.82 (24-Apr-2019)

Fixed the error of 'The requested URL /pls/vis7/m4aps_xml.generate_xml was not found on this server' on R11.
Modified the errors of Modifier Type SQL.

1.5.81 (09-Apr-2019)

Fixed the error of query line qualifiers via the Download form.

1.5.80 (09-Apr-2019)

Fixed the issue of time out when downloaded lines.

1.5.79 (28-Mar-2019)

Fixed the error of uploading a Modifier when the Modifier Name and Modifier Number contains the space at the end.

1.5.78 (08-Mar-2019)

Added the company logo onto the example sheet.

1.5.77 (04-Dec-2018)

Internal enhancement.

1.5.76 (22-Oct-2018)

Fixed the type mismatch error of ribbon issue.

1.5.75 (22-Oct-2018)

Removed the hidden columns.

1.5.74 (22-Oct-2018)

Fixed the issue of Product Value 'ALL' not shown on the Exclude Lines Form
Added Modifiers Exclusions Example sheet.

1.5.73 (20-Oct-2018)

Fixed the issue of extra data in the Product value list.

1.5.72 (20-Oct-2018)

Fixed the issue of product value list when product attribute is 'Item Categories'.

1.5.71 (15-Nov-2018)

Fixed the issue where failed to update the Exclude Lines.
Fixed the error when opening the Exclude Lines form.
Fixed the bugs for Exclude Lines validation.
Fixed the issue of getting error message 'out of stack space, etc'.
Fixed the validation when either product attributes or product value is missing.

1.5.70 (10-Oct-2018)

Fixed the issue of saving files with Excel 64-bit.

1.5.69 (09-Oct-2018)

Fixed the errors of UOM SQL when product attributes is All Items.

1.5.68 (08-Oct-2018)

Fixed the issue of empty Line Modifiers while creating a modifier.

1.5.67 (02-Oct-2018)

Fixed the issue of Modifier Number validation on the Modifier list Lines form.

1.5.66 (27-Sep-2018)

Fixed the issue when creating a modifier, the line modifier number defaults to 1.

1.5.65 (07-Sep-2018)

Fixed the issue where code blew up during the upload in some circumstances.

1.5.64 (06-Sep-2018)

Fixed the issue of memory leak during the upload

1.5.63 (04-Sep-2018)

Fixed the issues of appearance of form control and failure of extension package.

1.5.62 (29-Aug-2018)

Fixed the issues of null modifier number during validation when using auto generator.

1.5.61 (28-Aug-2018)

Added Extension Package which auto creates a Modifier number based on the site tied to the responsibility.

1.5.60 (22-Aug-2018)

Fixed the issue of memory leak when uploading.

1.5.59 (28-Jun-2018)

Fixed the issues of code blow up if the price breaks value from is blank.

1.5.58 (28-Jun-2018)

Fixed the issues when other type price list such as Agreement Price List appeared on the list of Modifier Number.

1.5.57 (28-Jun-2018)

Internal enhancement.

1.5.56 (24-May-2018)

Internal enhancement.

1.5.55 (02-May-2018)

Made 'Yes' as default Value of Global when the security profile is Off.

1.5.54 (30-Apr-2018)

Made Global control type as a list box instead of check box.

1.5.53 (30-Apr-2018)

Fixed the issue when modifier downloaded not filter by display options correctly.

1.5.52 (30-Apr-2018)

Fixed the issue when the profile QP: Security Control is set to On the Global flag should be available at the header level, otherwise hidden the control.

1.5.51 (06-Mar-2018)

Fixed the issue where download large pricing modifier failed with "Error 9999".

1.5.50 (22-Feb-2018)

Fixed the issue where getting errors on duplicate key for duplicated lines in the spreadsheet.

1.5.49 (20-Feb-2018)

Corrected the error message ‘Line Effective To Date must be less than the Line Effective Date From’ to ‘Line Effective To Date must be greater than the Line Effective Date From’.

1.5.48 (16-Feb-2018)

Fixed the issue where cannot put a 'Yes' in the Delete Price Qualifier checkbox.
Fixed the issue where the value of Delete Price Qualifier was not populated when opening the Header/Line Qualifier form.

1.5.47 (14-Feb-2018)

Removed the 'Delete Line' column from the spreadsheet since Oracle does not allow to delete lines with supported types by the Wizard.

1.5.46 (13-Feb-2018)

Fixed the issue where upload new Modifier got "Error 9 (Subscript out of range)" error if the line has invalid data.
Fixed the issue where code blows up if the effective date from/to have the year before 1000.

1.5.45 (13-Feb-2018)

Fixed the issue where did not get the error message "Multiple qualifier meaning values found" when same qualifiers exist.
Fixed the issue where upload failed with the error message 'This key has been associated' if the modifier line has excluded lines.

1.5.44 (09-Feb-2018)

Fixed the issue getting the error "Multiple qualifier meaning values found" even though there is no multiple records for the validated Qualifier.
Changed the name of "Downloader" menu to "Custom Query".

1.5.43 (09-Feb-2018)

Fixed the issue where the line form shows the wrong UOM description.
Fixed the issue where upload multiple modifiers failed if at least one modifier line has line qualifier(s).
Fixed the issue unexpected value were written to the Modifier Header when opening the Header/Line Qualifier form with something wrong in the Modifier Header.

1.5.42 (01-Feb-2018)

Fixed the issue where upload failed if the Line Modifier Lever is ORDER.

1.5.41 (01-Feb-2018)

Fixed the issue where Oracle ORA-1403 error returned for the upload when the Header/Line Qualifier ID does not exist.

1.5.40 (18-Jan-2018)

Fixed the issue where message "Validated with Errors!" was written to the 'Upload Message' column when actually no error in the spreadsheet data.

1.5.39 (16-Jan-2018)

Fixed the issue where wrong value of Qualifier Value From/To were written back to the spreadsheet after click 'OK' button to close the form.

1.5.38 (11-Jan-2018)

Fixed the issue where error message for the all child levels, for example Qualifier level or Line level, were not written to the spreadsheet.

1.5.37 (11-Jan-2018)

Fixed the issue where 'Value' and 'To' on the download form were disabled incorrectly if the attribute was "iStore Section".

1.5.36 (11-Jan-2018)

Corrected the incomplete error message: "Modifier Value must be null when Operator not set. You cannot have a Modifier Line To value to with an".
Fixed the issue where disabled textbox 'Value To' on the Line level Modifier Qualifier form was highlighted yellow which should be greyed out.
Fixed the issue clicking searching button to search 'Product Value' on the Modifier Line form and clicking searching button to search qualifier 'Value From' and 'Value To' on the Line/Header Qualifier Form doesn’t work.

1.5.35 (10-Jan-2018)

Fixed the issue where wrong value of 'Qualifier Value From' 'Qualifier Value To' on the both Header level and Line level were not marked as red in the spreadsheet.

1.5.34 (08-Jan-2018)

Fixed the issue where 'Incompatibility Group' was not populated when opening the List Line form.
Fixed the issue where failed to catch the wrong value of 'Qualifier Value From' and 'Qualifier Value To'.

1.5.33 (08-Jan-2018)

Added the missing word 'to' the error message "'Have set Global flag on the header level to 'Yes' as security control is not enabled".

1.5.32 (20-Dec-2017)

Fixed the issue where back to front 'Yes/No' values were downloaded in German.

1.5.31 (07-Dec-2017)

Fixed the issue failed to opening the Line form with blank line.
Allow any value for Header/Line Qualifier Value From/To when the operator is 'BETWEEN'.

1.5.30 (01-Dec-2017)

Added support of showing corresponding line modifier type according to the header modifier type and line modifier level.
Fixed the issue where on the Modifier Line Form the Line Automatic field was not automatic selected when the header has the Automatic field checked.
Removed unsupported line type from the Line Type list of Modifier Line Form.
Fixed the issue when Group of Lines is selected as the modifier level, the Volume Type, Product Attribute, and Product Attribute Value fields were not changed to mandatory fields.
Fixed the issue where download data via form failed with SQL error when having Line Level Product Criteria.
Fixed the issue where on the Modifier Line Form back colour Product Attribute, Product Value were changed to yellow incorrectly after entering the value.

1.5.29 (17-Nov-2017)

Added the support to profile option "QP: Continuous Price Breaks" allow non-continuous price break value.
Improved the warning message when having patch 11828647 installed and having 'Print On Invoice Flag' in the spreadsheet.
Updated the example spreadsheet with adding new added columns "Header Qualifier ID" and "Line Qualifier ID".

1.5.28 (08-Nov-2017)

Default Automatic on the Line level to same as header level automatic flag if line level automatic is not populated in the spreadsheet.

1.5.27 (30-Oct-2017)

Added Header Qualifier ID and Line Qualifier ID - used for updating qualifiers when downloaded from Oracle.

1.5.26 (12-Oct-2017)

Fixed the issue where form opens then closes on its own.

1.5.25 (11-Oct-2017)

Fixed the VBA error when the users double click in the spreadsheet.
Fixed the VBA error when the users interact with the spreadsheet during the download using sheet data.

1.5.24 (10-Oct-2017)

Changed the product related fields on the line form from mandatory to optional.
Fixed the issue where display only columns were not grey when generating a new sheet.

1.5.23 (13-Sep-2017)

Updated Security.

1.5.22 (05-Sep-2017)

Added Downloader tab to the Wizard.

1.5.21 (24-Aug-2017)

Updated Security.

1.5.20 (14-Aug-2017)

Fixed the issue getting error "Please enter required information - Estimated Accrual Rate." for upload.

1.5.19 (13-Jul-2017)

Changed to call CentralErrorHandler for the error handler for printForward in the module dlDownload.

1.5.18 (09-Jun-2017)

Fixed the issue where lines which do not have the line level qualifiers matching the download criteria will be downloaded incorrectly.

1.5.17 (09-Jun-2017)

Fixed the issue where download failed with SQL error when having Line level qualifier criteria.

1.5.16 (06-Jun-2017)

Fixed the issue where failed to update the 'Global' from 'No' to 'Yes' for existing modifiers. Added the validation when security control is not enabled 'Global' on the header level cannot be set to "No".

1.5.15 (06-Jun-2017)

Added validation that price break is required when a volume type exists.
Fixed the issue where original value of 'Automatic' and 'Active' were overwritten incorrectly when it is an update and the users leave empty in the spreadsheet for them.

1.5.14 (04-Jan-2017)

Fixed the issue where line modifier number with over 15 digitals will be rounded by Excel.

1.5.13 (02-Mar-2017)

Updated core module to 212, then 212.5
Now setting Language on Login: Language for the user is now being set from user's EBS preferences irrespective of what is chosen on the Browser Login page.

1.5.12 (01-Mar-2017)

Fixed the issue where line exclusions were downloaded as line level attributes.

1.5.11 (16-Feb-2017)

Fixed the issue where upload fails when UOM is blank by skipping to check UOM in the valid UOM list if UOM is blank.

1.5.10 (09-Feb-2017)

Updated Security.

1.5.09 (24-Jan-2017)

Fixed the issue where wrong pricing attribute datatype was written for Get Item and caused the wrong sale order created.

1.5.08 (24-Jan-2017)

Fixed the issue where getting wrong product values for the get items.

1.5.07 (23-Jan-2017)

Fixed the issue where getting wrong product values for the get items.

1.5.06 (14-Oct-2016)

Internal update.

1.5.05 (04-Oct-2016)

Updated Security.

1.5.04 (02-Sep-2016)

Fixed the issue that some items missed in the UOM list on the modifier line form.

1.5.03 (19-Aug-2016)

Added showing the default precedence for qualifier on the header level and line level of precedence is blank.

1.5.02 (19-Aug-2016)

Stop showing error when user type "-" for grouping number because "-1" is valid value.

1.5.01 (23-Jun-2016)

Corrected the title of frmModifierBuyItem to Buy Item which was Get Item before.

1.5.00 (22-Jun-2016)

Fixed the issue that Wizard created a new one price attribute instead of updating existing one when the line level product value is changed as well.

1.4.55 (16-Jun-2016)

Fixed the issue that user couldn't check "Delete Line Exclusion" checkbox.

1.4.54 (16-Jun-2016)

Fixed the issue that users are not able to generate new sheet with Excel 2003.

1.4.53 (09-Jun-2016)

Fixed the issue with Wizard creating a new price attribute instead of updating existing one when having multiple price attributes with same attributes setting for one line.

1.4.52 (09-Jun-2016)

Fixed the issue of showing duplicated product description column when there is no duplicated actually.

1.4.51 (09-Jun-2016)

Added message if Patch 11828647 installed which will ignore the value for PrintOnInvoice flag and give ‘No’ always.
Fixed the issue that Calendar button on the download form didn’t work.
Added validation for Display and Date on the download form.

1.4.50 (09-Jun-2016)

Removed the checking of valuefrom has to be 0 for first price break because the user was able to create first price break with start number as zero.
For all combobox stop validating user input when user is typing and only validate when user finishes the typing.

1.4.49 (07-Jun-2016)

Changed Accrue Discount checkbox and Disc Accrual Conversion Rate to not compulsory.

1.4.48 (07-Jun-2016)

Disabled ValueFrom and ValueTo on the modifier line form if the line type is Price Break Header because they have to be added/edited using Price Break form.

1.4.47 (01-Jun-2016)

Remove checking Line level dependence for price attribute for download form.

1.4.46 (25-May-2016)

Fixed the issue of the wrong row in the spreadsheet was highlighted for more forms.

1.4.45 (25-May-2016)

Fixed issue that in some cases the Wizard crashed when uploading Qualifiers.

1.4.44 (23-May-2016)

Updated Security.

1.4.43 (19-May-2016)

Added order for the list of value of Key Flexfield.

1.4.42 (09-May-2016)

Removed organization access check when getting organizations.

1.4.41 (09-May-2016)

Fixed the issue of the wrong row in the spreadsheet was highlighted when opening some forms.

1.4.40 (06-May-2016)

Added ‘Modifier Line Buy Items' and 'Modifier Line Get Items' to right-click menu.

1.4.39 (05-May-2016)

Fixed the issue that wrong modifiers were downloaded using sheet data when modifier description are not blank.
Remove the validation list of values when no data input or users take out the input.

1.4.38 (05-May-2016)

Updated Security.

1.4.37 (03-May-2016)

Enable 'Debug Upload' option in the Setup Ribbon/Toolbar.

1.4.36 (03-May-2016)

Fixed the issue for Download form that FromTo label of qualifier and line qualifier are not hidden when the attribute is LOV.

1.4.35 (02-May-2016)

Added validation for SourceSystemCode checking.

1.4.34 (28-Apr-2016)

Ability to enable.disable price Attributes button when having/not having product value input.

1.4.33 (21-Apr-2016)

Fixed the issue of writing the data back to wrong line in the spreadsheet when clicking Ok on the Modifier Qualifier form.

1.4.32 (21-Apr-2016)

Changed Value From,Precedence and Operator to not required on the modifier header level form.

1.4.31 (21-Apr-2016)

Added pModifierLineTypeCode <> "SUR" when validate accrue discount

1.4.30 (21-Apr-2016)

Changed Value From,Precedence and Operator to compulsory on the modifier line level.

1.4.29 (18-Apr-2016)

For modifier line form disable product attribute controls always when the modifier level is 'ORDER'.

1.4.28 (18-Apr-2016)

Fixed issue of failed to find Line level qualifier when delete line level qualifiers.

1.4.27 (12-Apr-2016)

Add order by name for searching modifier list.

1.4.26 (11-Apr-2016)

Add Order by modifier number for header SQL.

1.4.25 (04-Aug-2015)

Fixed the issue that failing to download inactive modifiers with ‘Active Only’ option unchecked.

1.4.24 (04-Jul-2015)

Fixed download via sheet data issue.

1.4.23 (04-Jul-2015)

Modifiers that don’t match header and line qualifier criteria’s won’t be downloaded now.

1.4.22 (04-Apr-2015)

Disable controls for qualifier and line qualifier when the value is text.
Fixed the issue of error message is blank when open specific forms with missing required columns in the spreadsheet.

1.4.21 (30-Mar-2015)

Able to login/logout label and supertip according to whether you’re logged in or not.
Added order by for querying Qualifier and Qualifier Attribute list.

1.4.20 (24-Mar-2015)

Added Modifier Qualifier and Modifier Line Level Qualifier to 'Download from Form'.

1.4.19 (02-Mar-2015)

Updated Security.

1.4.18 (03-Aug-2014)

Fixed the issue that multiple duplicate list line IDs returning when multiple price breaks on line.

1.4.17 (03-Aug-2014)

Fix error 'ORA-01482: unsupported character set' cause by long columns changed to Clobs in 12.2.

1.4.16 (12-Aug-2014)

Fixed bug when downloading where used referencing the incorrect column name.

1.4.15 (12-Aug-2014)

Updated Core.

1.4.14 (01-Aug-2014)

Re-added in charge name for charge types and it now works on r12.1.3 onwards.

1.4.13 (08-Jul-2014)

Added check to remove comma from numbers when loading data.
Changed Wizard so currency isn't mandatory and users can select [BLANK] from the list of currencies.

1.4.12 (08-Jul-2014)

Fixed the bug for categories returning the wrong Id.
Added in needed for org Id for r12 if not global.
Fixed bug when adding line to existing modifier.
Fixed bug in loading multiple lists without a gap between them.
Fixed bug where DFF validation error on header form not showing if you open up a child form.
Fixed bug where Wizard errors out if product value not found.
Added cache check on get pricing phases to reduce sql calls.

1.4.11 (05-Jun-2014)

Fixed bug where Wizard allowed trailing space in modifier number, causing Oracles modifiers form to get OE_LOCK_ROW error.

1.4.10 (24-May-2014)

Fixed bug in line qualifier loads sending up the command block too many times.

1.4.9 (06-May-2014)

Improvement of performance for download.

1.4.8 (22-Apr-2014)

End Date values being returned form an independent valueset.

1.4.7 (07-Mar-2014)

Fixed bug in downloader creating spaces between downloads

1.4.6 (07-Mar-2014)

Fixed bug where line number, which was the key field for each line wasn’t updating the collection causing lines to be ignored

1.4.5 (07-Mar-2014)

Core Menu code and ribbon refresh
Mode toolbar icon fixes
Updated duplicate qualifier check code.
Fixed bug with qualifier lines form not validating the modifier line first

1.4.4 (18-Feb-2014)

Fixed issue with downloader not working for categories

1.4.3 (05-Feb-2014)

Added duplicate modifier line number check due to API erroring without a reason

1.4.2 (14-Jan-2014)

Fixed issue where API error message showing at the bottom of the load.
Added validation to price breaks to include making sure value is null on the line.
Added in check for duplicate header qualifier, duplicate line qualifier and duplicate attributes.
Fixed bug with getting time UOMs not loading in lines form.
Updated lines form to only render discount redemption/rates when appropriate.
Improved handling of line level fields, as some were not required but caused the Wizard to error if they were present.

1.4.1 (13-Jan-2014)

Fixed lines button not working in price breaks form
Added in check for duplicate attributes

1.4.0 (09-Jan-2014)

Added in line exclusion functionality
Fixed bug where discount redemption rates are not being downloaded

1.3.16 (02-Jan-2014)

Fixed bug in getting line qualifiers not loading if line id doesn’t exist

1.3.15 (14-Dec-2013)

Added caching to line items.
Fixed accrue on discount required when Promotion and a discount, when it isn’t required.

1.3.14 (21-Nov-2013)

Checking if qualifier exists was not looking at qualifier value. Added this to the query.
Fixed bug in get organization details where a null lot number caused wizard to error.

1.3.13 (04-Nov-2013)

Central Error handler added to: QPDFF class, QPContext class QPAttribute class, dffValueSet class, dffValueSets class, dffQP module.
Customer used to determine when to concatenate value with meaning to allow unique identification of record.
frmModifierQualifiers: cboValueFrom changed: widened, now displaying 3 columns
dffValueSet.TableBasedLovSQL: Changed to concatenate value with meaning to allow unique identification of record in situation when If Me.ID_COLUMN_TYPE = “N” And Me.MEANING_COLUMN_TYPE = “V”.
Using : as deliminator. Me.VALUE_COLUMN_NAME & ” || ‘:’ || ” & Me.MEANING_COLUMN_NAME

1.3.12 (12-Oct-2013)

Added Surcharge to list of valid line types to allow formula LOV

1.3.11 (25-Sep-2013)

Added validation so you can’t add new price break lines when there are no price breaks
Updated common code

1.3.10 (17-Sep-2013)

Fixed bug where freight charges weren’t allowing order level lines changed

1.3.9 (19-Jul-2013)

Fixed bug where freight charges weren’t allowing order level lines

1.3.8 (27-Jun-2013)

Fixed bug where qualifiers wouldn’t load without an a valueset

1.3.7 (26-Jun-2013)

Applied fixes to download between not working
Updated download form value to so it doesn’t validate if wildcard entered into the field

1.3.6 (20-Jun-2013)

Removed line requirement for promotions to have application method.
Fixed bug where currency field wasn’t being validated.
Fixed bug where only first qualifier for qualifier attribute loading.
Updated ribbon bugs

1.3.5 (15-May-2013)

Added in comments sheet coding.

1.3.4 (15-May-2013)

Fixed issue print on invoice is allowed to be no for price break line header type.

1.3.3 (18-Apr-2013)

Fixed issue with limits causing messages to show twice
Updated get item details to use faster sql code
Added in price breaks to end upload message
Fixed bug in price breaks where it errored if from/to values equalled other records

1.3.2 (22-Mar-2013)

Changed download from sheet to allow inactive modifiers as well as modifiers from other sources

1.3.1 (26-Feb-2013)

Added buttons to the ribbon/toolbar to launch Limits header/lines form
Finished Limits downloader and fixed constraint form/code.

1.3.0 (15-Feb-2013)

Added Limits functionality

1.2.1 (26-Sep-2012)

Fixed issue where line qualifiers missing Wizard fails upload

1.2.0 (17-Sep-2012)

Ribbons enabled

1.1.1 (08-Sep-2012)

Changed way price breaks are loaded
Fixed bug in download form which would grey the field out and stop you downloading
Fixed bug in secondary load of line qualifiers

1.1.0 (31-Jul-2012)

Added price break functionality

1.0.12 (12-Jun-2012)

Fixed download from not popping KFF for items
Changed line downloader to union item and category rather than outer join

1.0.11 (08-Jun-2012)

Fixed Download DFF issue when segment dependent on parent segment

1.0.10 (06-Jun-2012)

Updated to 64bit functionality
Fixed issue with download from spreadsheet where it would download duplicate lists and all lists if there is a blank record
Changed upload to allow line qualifiers to load at the same time as header qualifiers

1.0.9 (14-May-2012)

Added download from spreadsheet function
Fixed security issue where it informs user if they are not allowed to update qualifiers at the header level
Added in check to make sure only promo lines can be deleted

1.0.8 (16-Mar-2012)

Fixed bug with default attribute causing duplicate records

1.0.7 (16-Mar-2012)

Made changes to the way dates work to remove issues when changing date formats in different countries

1.0.6 (09-Mar-2012)

Added fix for line qualifiers trying to load when the line_id doesn’t exist
Fixed bug with qualifier line dff form not loading if there is a dff error on the sheet

1.0.5 (14-Dec-2011)

Added fix for looping attributes error

1.0.4 (13-Dec-2011)

Added Trim function to strings to remove space issues in sheet values

1.0.3 (30-Nov-2011)

Changed discount accrue value to only be required when modifier header isn’t discount and line is discount

1.0.2 (29-Nov-2011)

First release