2.5.20 (10-Sep-2025)

Fixed error "Compile error in hidden module: fndXMLParse..."

2.5.19 (01-Sep-2025)

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

2.5.18 (13-Aug-2025)

Fixed the issues of Bulk Upload Fails with VBA error if Header Effective Date/From columns missing

2.5.17 (04-Jul-2025)

Fixed the issues of Can't retrieve list line id when updating the price

2.5.16 (22-May-2025)

Fixed the issues of Can't move focus to the control when clicking on the Customer Name and Customer Number fields in Bulk Import mode.

2.5.15 (24-Apr-2025)

Fixed issues of product value validation when System Source Code is PO.

2.5.14 (12-Mar-0025)

Internal update.

2.5.13 (12-Mar-2025)

Internal update.

2.5.12 (14-Oct-2024)

Fixed SQL error message 'Invalid number' while refresh child sections in the bulk upload mode.

2.5.11 (11-Oct-2024)

Internal update.

2.5.10 (10-Oct-2024)

Added Default Browser Login option.

2.5.09 (26-Jun-2024)

Fixed SQL error while downloading from form.

2.5.08 (24-Jun-2024)

Internal update.

2.5.07 (04-Apr-2024)

Fixed issue of not being able to update Round to.

2.5.06 (28-Nov-2023)

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

2.5.05 (12-Oct-2023)

Internal update.

2.5.04 (11-Oct-2023)

Removed the extra buttons on the forms.

2.5.03 (10-Oct-2023)

Added new digital signature.

2.5.02 (25-Sep-2023)

Standard Price List mode: Fixed the issue with 'Price Break Dynamic Formula' field red color in the form.

2.5.01 (28-Jun-2023)

Price List mode: Fixed error message 'Item failed doesn't exist in WDictionary'.

2.5.00 (27-Jun-2023)

Bulk Upload mode: Fixed issue when object doesn't support this property or method.

2.4.99 (16-May-2023)

Price List mode: Fixed Download form percentage bar not showing correctly.

2.4.98 (01-May-2023)

Internal update.

2.4.97 (31-Mar-2023)

Added Dynamic Formula column onto Price Break section when line type is Price Break header.

2.4.96 (14-Mar-2023)

Internal update.

2.4.95 (14-Mar-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 ot end trace did not generate the trace.

2.4.94 (06-Mar-2023)

Fixed issue with list of value Qualifier Attributes which are different between Oracle and PLW when PTE is PO/ORDER ENTRY.

2.4.93 (16-Feb-2023)

Fixed the duplicated list of values in Item Categories context.

2.4.92 (01-Feb-2023)

Fixed the issue of closing the Download filter size form and getting the automation error message.

2.4.91 (01-Feb-2023)

Removed read only columns - Product Description, Product Category from Line level and Sales Agreement Customer Number from header.

2.4.90 (17-Jan-2023)

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

2.4.89 (05-Jan-2023)

Internal update.

2.4.88 (04-Jan-2023)

Fixed HTTP error 400 - Bad Request issue while uploading a large data of item.

2.4.87 (07-Dec-2022)

'Including Inactive Line' with Yes/No options to filter non active line. It is only available when the Display option is ALL.

2.4.86 (02-Dec-2022)

Internal update.

2.4.85 (28-Nov-2022)

Fixed error message: Please correct form while using 'Download form.

2.4.84 (28-Nov-2022)

Standard Price3 List mode: Fixed SQL error when clicking on the Clear button on the Download form.

2.4.83 (24-Nov-2022)

Internal update.

2.4.82 (21-Nov-2022)

Internal update.

2.4.81 (04-Oct-2022)

Fixed Download by sheet running a download based on empty rows.

2.4.80 (28-Sep-2022)

Fixed issue of downloading message box disappearing.

2.4.79 (19-Sep-2022)

Internal update.

2.4.78 (16-Sep-2022)

Turn off the log file.

2.4.77 (15-Sep-2022)

Updating Licencing Modules.

2.4.76 (15-Sep-2022)

Added download setting features.

2.4.75 (07-Sep-2022)

Fixed the admin error message when trying to access the template manager.

2.4.74 (07-Sep-2022)

Standard mode: Fixed the list value issue of Pricing Break Attributes for PO Entity.

2.4.73 (14-Jun-2022)

Fixed the set up ribbon message issue.

2.4.72 (14-Jun-2022)

Fixed the set up ribbon message issue.

2.4.71 (08-Jun-2022)

Bulk Loader mode: Fixed error message 'Cannot Switch to List Line ID is not on the current sheet'.

2.4.70 (07-Jun-2022)

Fixed typo on the ribbon.

2.4.69 (31-May-2022)

Custom Query update with SQL injection fixes.

2.4.68 (05-May-2022)

Internal update.

2.4.67 (02-May-2022)

Fixed error when rounding factor is required and the multi current not installed.

2.4.66 (06-Apr-2022)

Price List mode: Fixed error when end date is removed in the sheet.

2.4.65 (06-Apr-2022)

Standard Price List mode: Fixed Type mismatch issue.

2.4.64 (04-Apr-2022)

Internal update.

2.4.63 (02-Mar-2022)

Fixed issue with Effective Date not defaulting to the current date.

2.4.62 (11-Jan-2022)

Fixed issue with not being able to save the workbook.

2.4.61 (27-Aug-2021)

Added normalise/denormalise features.

2.4.60 (05-Aug-2021)

Internal update.

2.4.59 (29-Jun-2021)

Fixed the issue of empty secondary price list while creating a new price list.

2.4.58 (29-Jun-2021)

Fixed the ribbon translation issue.

2.4.57 (25-Jun-2021)

Fixed the error message which was invisible on the Download form.

2.4.56 (24-Jun-2021)

Fixed the issue of Price List field in the form holding previous search when switching from one mode to another.

2.4.55 (22-Jun-2021)

Fixed the issue of Context List not updating when switching from one instance to another.

2.4.54 (22-Jun-2021)

Fixed the issue of mode name not matched.

2.4.53 (21-Jun-2021)

Internal enhancement.

2.4.52 (21-Jun-2021)

Fixed the error message while refreshing the page in 11i.

2.4.51 (17-Jun-2021)

Updated cmMessage.

2.4.50 (17-Jun-2021)

Updated cmMessage to the latest one, fixed the issue with orig_system_header_ref while creating a new price list.

2.4.49 (16-Jun-2021)

Added a license key control to only expose PO Entity functionality for client.

2.4.48 (16-Jun-2021)

Fixed the invalid color for multi currency when opening the header form. Removed the requirement for UOM since it is defaulting in sheet and not defaulting on the form all the time.

2.4.47 (28-May-2021)

Internal enhancement.

2.4.46 (20-May-2021)

Fixed the issue with error message when the multi concurrence is missing from the sheet.

2.4.45 (20-May-2021)

Fixed the issue of context value with form reference.

2.4.44 (20-May-2021)

Fixed the issue with list value of pricing break attributes when transaction entity is PO.

2.4.43 (19-May-2021)

Updated transaction entity value in other three modes.

2.4.42 (17-May-2021)

Fixed the issue with BLANK in the DFF context in the PBL mode.

2.4.41 (11-May-2021)

Fixed issue with using dynamic formula in price list line.

2.4.40 (10-May-2021)

Updated security.

2.4.39 (23-Apr-2021)

Fixed issue with not being able to use the price list in sales order.

2.4.38 (21-Apr-2021)

Updated ribbon layout.

2.4.37 (21-Apr-2021)

Updated security.

2.4.36 (07-Apr-2021)

Updated security.

2.4.35 (05-Feb-2021)

Internal enhancement.

2.4.34 (03-Feb-2021)

Internal enhancement.

2.4.33 (03-Feb-2021)

Internal enhancement.

2.4.32 (01-Dec-2020)

Updated security.

2.4.31 (19-Nov-2020)

Added the validation of UOM while the inventory item ID is null.
Fixed the defaulting while product value is null.

2.4.30 (12-Nov-2020)

Fixed issue with UOM defaulting while creating a new line.

2.4.29 (04-Nov-2020)

Fixed issue of login/logout in fndLoginSSO.

2.4.28 (13-Oct-2020)

Fixed the issue of defaulter value while the parent has been updated.

2.4.27 (13-Oct-2020)

Updated security.

2.4.26 (18-Sep-2020)

Fixed the issue of not being able to find the value of pricing break attributes.

2.4.25 (03-Sep-2020)

Updated security.

2.4.24 (01-Sep-2020)

Fixed the version issue.

2.4.23 (28-Aug-2020)

Fixed the mistype match error message when item is not valid.

2.4.22 (28-Aug-2020)

Fixed UOM issues.

2.4.21 (12-Aug-2020)

Fixed download performance issues in the Price List mode while downloading price list header and items.

2.4.20 (19-Jun-2020)

Fixed issue with Template123 when missing.

2.4.19 (19-Jun-2020)

Fixed issue with run-time error - Format Sheet when the Template123 is removed.

2.4.18 (19-Jun-2020)

Fixed issue with Header ID created before upload of Price List.

2.4.17 (10-Jun-2020)

Fixed issue with invalid currency in the parent section and error in the section secondary Price List.

2.4.16 (28-May-2020)

Fixed issue with searching function the process id in the Bulk Import mode.

2.4.15 (27-May-2020)

Fixed issue with template request id align format.

2.4.14 (27-May-2020)

Fixed issue with process id not being select in concurrent submission form.

2.4.13 (15-May-2020)

Fixed issue with download issues in Bulk Import mode.

2.4.12 (15-May-2020)

Fixed issue with secondary price list value.

2.4.11 (15-May-2020)

Fixed issue with automation error.

2.4.10 (08-May-2020)

Fixed the issue with read only column color in Standard Agreement mode.

2.4.09 (27-Mar-2020)

Fixed the issue with refreshing the concurrent process.

2.4.08 (27-Mar-2020)

Rebranding of logo and new color scheme.

2.4.07 (12-Mar-2020)

Added support to set the DFF reference field to list_type_code.

2.4.06 (10-Mar-2020)

Fixed issue with downloading a list of items from a specific price list.

2.4.05 (10-Mar-2020)

Internal enhancement.

2.4.04 (10-Mar-2020)

Internal enhancement.

2.4.03 (18-Dec-2019)

Fixed issue with multi concurrency validation and issues with not being able to download round to value.

2.4.02 (09-Sep-2019)

Fixed issues with refresh errored when the reference id column missing in the sheet.

2.4.01 (09-Sep-2019)

Internal enhancement.

2.4.00 (09-Sep-2019)

Fixed firewall issues.

2.3.99 (09-Sep-2019)

Fixed issues with Qualifier DFF download when one qualifier context has various type of attributes.

2.3.98 (09-Sep-2019)

Fixed issues with validating new records.

2.3.97 (13-Aug-2019)

Internal enhancement.

2.3.96 (30-Jul-2019)

Fixed issue with update lines which have incorrect list line ID.

2.3.95 (24-Jul-2019)

Fixed issues with deleting lines and deleted message.

2.3.94 (22-Jul-2019)

Fixed issue with type mismatch in procedure Parse return string.

2.3.93 (22-Jul-2019)

Fixed performance issue while deleting the line.

2.3.92 (20-Jul-2019)

Fixed issue when deleting the line which belongs to another Price List.

2.3.91 (31-May-2019)

Fixed issue when creating a new agreement when name has already been used in Price List mode.

2.3.90 (31-May-2019)

Fixed issue when operation unit changed and responsiblity not changed.
Fixed issues of PLW Restrict Upload on errored lines doesn't work.

2.3.89 (31-May-2019)

Fixed bug when price list has duplicated secondary list.

2.3.88 (31-May-2019)

Fixed bug when removed the Attributes section from spreadsheet.

2.3.87 (31-May-2019)

Fixed bug when double clicking on the List Header ID to open the form.

2.3.86 (29-May-2019)

Updated the hover over message.

2.3.85 (29-May-2019)

Updated the logo in PLW to the new logo as per the colour scheme update.

2.3.84 (29-May-2019)

Fixed the issue when opening the Download form with Header Only template.

2.3.83 (28-May-2019)

Fixed the issue when updating header using Header Only template.

2.3.82 (28-May-2019)

Fixed bug while creating a new record.

2.3.81 (28-May-2019)

Fixed the download issues when dowload data failed the LOV validation.

2.3.80 (27-May-2019)

Internal enhancement.

2.3.79 (27-May-2019)

Internal enhancement.

2.3.78 (13-May-2019)

Removed the background process from Price List.

2.3.77 (13-May-2019)

Fixed the issues of Line Download Order based on the ribbon Download Order Option.

2.3.76 (13-May-2019)

Fixed the issues of UOM value to be overwritten.

2.3.75 (13-May-2019)

Fixed the issues of Default UOM value in Agreement mode.

2.3.74 (13-May-2019)

Fixed the issues of Refresh status when line section is not successful and attributes data is correct.

2.3.73 (13-May-2019)

Fixed the issues of Removing List Line ID from line section in Bulk Import of Price List mode.
Fixed the issues of refreshing the Line status when its grandchild section is wrong.
Added the Bulk Import Example sheet.

2.3.72 (10-May-2019)

Internal enhancement.

2.3.71 (10-May-2019)

Fixed the issues of REvision Date default to system Date when creating an agreement price list.

2.3.70 (09-May-2019)

Internal enhancement.

2.3.69 (09-May-2019)

Internal enhancement.

2.3.68 (09-May-2019)

Fixed the issues of End Date should be greater than start date in Price List mode.

2.3.67 (09-May-2019)

Fixed the issues of End Date should be greater then start date in Agreement Price List mode.

2.3.66 (09-May-2019)

Internal enhancement.

2.3.65 (09-May-2019)

Internal enhancement.

2.3.64 (08-May-2019)

Internal enhancement.

2.3.63 (07-May-2019)

Fixed bug in Qualifier section when qualifier value is numeric.

2.3.62 (07-May-2019)

Fixed the issues of Blank Address Line when Invoice To is not blank.

2.3.61 (06-May-2019)

Fixed the issues of Break Value From numeric issues.

2.3.60 (06-May-2019)

Internal enhancement.

2.3.59 (06-May-2019)

Fixed the issues of price list value which belongs to source System FTE and Pricing Transaction Entity.

2.3.58 (03-May-2019)

Fixed the issues of Break Attributes list of values.

2.3.57 (02-May-2019)

Fixed bug when opening Download form in Agreement Pricing List mode.

2.3.56 (02-May-2019)

Fixed the issues of currency and multi-Currency default value.

2.3.55 (02-May-2019)

Fixed the issues of ribbon appearance when selecting template.

2.3.54 (30-Apr-2019)

Internal enhancement.

2.3.53 (29-Apr-2019)

Fixed the issues of update each section’s status as ‘Accepted’ when it is successfully updated.

2.3.52 (17-Apr-2019)

Fixed the issues of product value validation when product attributes is ‘All Items’.

2.3.51 (17-Apr-2019)

Fixed the issues of customer drop down list value in Agreement Price List mode.

2.3.50 (11-Apr-2019)

Internal enhancement.

2.3.49 (11-Apr-2019)

Internal enhancement.

2.3.48 (11-Apr-2019)

Internal enhancement.

2.3.47 (09-Apr-2019)

Fixed the issue of customer contact list value in Standard Pricing Agreement mode.

2.3.46 (05-Apr-2019)

Fixed the issue of customer contact list value in Agreement Price List mode.

2.3.45 (04-Apr-2019)

Fixed the issue of rounding to value for all modes.

2.3.44 (02-Apr-2019)

Fixed the bug when putting value onto Product Value To in the Download form.

2.3.43 (01-Apr-2019)

Internal enhancement.

2.3.42 (01-Apr-2019)

Fixed the issue of not updating the existing Secondary Price List.

2.3.41 (01-Apr-2019)

Added the Delete button/features onto Concurrent Processing.

2.3.40 (29-Mar-2019)

Applied the new More4Apps colour scheme.

2.3.39 (29-Mar-2019)

Internal enhancement.

2.3.38 (26-Mar-2019)

Internal enhancement.

2.3.37 (26-Mar-2019)

Fixed the issue of updating ALL ITEM.

2.3.36 (25-Mar-2019)

Fixed the layout of the Secondary Price list when its validation failed.

2.3.35 (22-Mar-2019)

Fixed bug creating Price Break.

2.3.34 (22-Mar-2019)

Fixed the error of creating Secondary Price List while creating a new price list in the Bulk Import of Price List mode.

2.3.33 (19-Mar-2019)

Fixed the issue of global control when it is not in the sheet.

2.3.32 (19-Mar-2019)

Hide/Show the global flag on the form based on the security profile value.

2.3.31 (19-Mar-2019)

Fixed bug when downloading with multiple columns in the header section.

2.3.30 (18-Mar-2019)

Fixed the issue for price list data created prior to the R12 release in Bulk Import of Price List mode.

2.3.29 (18-Mar-2019)

Fixed the issue of Freight Carriers for standard agreement price mode and agreement price mode.

2.3.28 (17-Mar-2019)

Fixed the Qualifier Creating issues when columns are missing.

2.3.27 (15-Mar-2019)

Fixed the Sec price list errors when original reference didn’t exist.

2.3.26 (13-Mar-2019)

Internal enhancement.

2.3.25 (13-Mar-2019)

Fixed the Error message issues for Bulk Import of Price List.

2.3.24 (11-Mar-2019)

Fixed the multi-currency conversion bug when Price List Name is null.
Fixed the BLANK data of effective date when updating.
Fixed the Freight Carriers order issues in Price List mode.

2.3.23 (08-Mar-2019)

Fixed the Download form layout issue for Interface mode.
Applied the default value to each child section upload mode based on Header upload Mode.

2.3.22 (08-Mar-2019)

Fixed the issue when interface line number is empty during updating.
Fixed bug when downloading with multiple columns on the worksheet.

2.3.21 (07-Mar-2019)

Fixed bug when multi-currency value is changed and rounding value always defaults to -2.
Fixed the layout of the price list header form.
Fixed comment column issues.

2.3.20 (06-Mar-2019)

Made the Process type on the concurrent submission window as Display Only, and default to More4Apps.

2.3.19 (06-Mar-2019)

Added Bulk import of price list mode onto Price List Wizard.

2.3.18 (12-Feb-2019)

Fixed the issue of not being update attributes when qualification id was set to a certain value.

2.3.17 (30-Jan-2019)

Fixed the error when changing a Customer label for the header attributes.

2.3.16 (10-Dec-2018)

Used the view to run the security check and improved the performance.

2.3.15 (07-Dec-2018)

Modified the DB Conflict Checking SQL to speed up this process.

2.3.14 (04-Dec-2018)

Fixed the issue where end-To-End Trace with unlimited size didn't work.

2.3.13 (04-Dec-2018)

Updated security.

2.3.12 (08-Nov-2018)

Fixed the issue of Default Ribbon Labels problems.

2.3.11 (08-Nov-2018)

Fixed the issue of not being able to load a list line which based on a formula.

2.3.10 (05-Nov-2018)

Fixed the issue of not updating ribbon when changed the selection on the right click menu.
Fixed the issues of not being able to update the header comments.
Fixed the issues of some ribbon controls not hidden all the time for agreement price list mode.

2.3.09 (02-Nov-2018)

Internal enhancement.

2.3.08 (01-Nov-2018)

Fixed the issue of no records download when the end date is in the past.

2.3.07 (24-Oct-2018)

Internal enhancement.

2.3.06 (24-Oct-2018)

Fixed the issue of not being able to get Price List name when multi-currency is not required.

2.3.05 (19-Oct-2018)

Fixed the issue of not be able to update line data when product attributes are not Item Number.

2.3.04 (14-Sep-2018)

Fixed the error message such as "Bad data at row..." when opening the form on the worksheet.

2.3.03 (11-Sep-2018)

Fixed the issue where code blew up when searching Price List Name on the Agreement Price List Header form.
Fixed the issue where upload failed with creating a new agreement list and with line data.

2.3.02 (31-Aug-2018)

Updated Download Wizard onto the latest version.

2.3.01 (31-Aug-2018)

Provided an error message when trying to update product value

2.3.00 (23-Aug-2018)

Updated Setup sheet.

2.2.99 (20-Aug-2018)

Hide the Customer Section by default.

2.2.98 (20-Aug-2018)

Fixed an issue whilst using the download select functionality where additional syntax was incorrectly being added.

2.2.97 (17-Aug-2018)

Internal enhancement.

2.2.96 (17-Aug-2018)

Added the 'Store Password' icon to the right-click menu.

2.2.95 (17-Aug-2018)

Internal enhancement.

2.2.94 (17-Aug-2018)

Fixed the issues of deleting a price list line in Price List mode.

2.2.93 (16-Aug-2018)

Fixed the issue when putting cursor in any cell above row 11 and initialising the ‘Download Form’.

2.2.92 (15-Aug-2018)

Updated spreadsheet tooltips.

2.2.91 (14-Aug-2018)

Internal security enhancement.
Improved price list line Start Date and End Date formatting.

2.2.90 (10-Aug-2018)

Finalized ‘Standard Pricing Agreements’ and ‘Agreement Price List’ modes.

2.2.89 (10-Aug-2018)

Fixed the Price Qualifier form issues.

2.2.88 (09-Aug-2018)

Fixed the ribbon issues.

2.2.87 (09-Aug-2018)

Fixed the error message of ambiguous name 'cProckey' detected.
Fixed the Dependence problems when it is null.

2.2.86 (08-Aug-2018)

Modified the error message layout.

2.2.85 (08-Aug-2018)

Make the Customer Number required when Customer is not blank.

2.2.84 (08-Aug-2018)

Fixed the issues of the extra data of Customer drop down list.
Apply default value onto Customer Number of Agreement price list mode.
Apply the update security check onto Agreement price list.

2.2.83 (07-Aug-2018)

Modify Product Value validator.

2.2.82 (03-Aug-2018)

Add Product Value validation.

2.2.81 (01-Aug-2018)

Add Custom Item onto the Agreement mode.

2.2.80 (31-Jul-2018)

Fixed the issues of Error Message while columns removed from the sheet.

2.2.79 (27-Jul-2018)

Tidy up the layout of each form.

2.2.78 (27-Jul-2018)

Tidy up the layout of each Download form.

2.2.77 (27-Jul-2018)

Fixed the issues of downloading limited to the current and future on the sheet.

2.2.76 (26-Jul-2018)

Fixed the issues of Error Message while uploading.

2.2.75 (12-Jul-2018)

Fixed the issues of Revision Date type mismatch.

2.2.74 (10-Jul-2018)

Modify the Agreement Price mode download SQL to speed up a few seconds.

2.2.73 (04-Jul-2018)

Tidied up the code.

2.2.72 (04-Jul-2018)

Fixed the issue of Revision Date format.

2.2.71 (04-Jul-2018)

Fixed the issue of download speed.

2.2.70 (02-Jul-2018)

Fixed the issue of Agreement name validation.

2.2.69 (02-Jul-2018)

Hide the ribbon group 'Concurrent Request' and separator for both agreement modes.
Make separate form (Line Form and Attributes Form) for Standard Price List.
Make the Static Formula and Dynamic Formula display only in the Standard Price List mode.

2.2.68 (29-Jun-2018)

Hide the ribbon control 'Display option', 'Download Order' and 'Effective Date' for both agreement modes.

2.2.67 (29-Jun-2018)

Allow ability to download by the price list column.

2.2.66 (28-Jun-2018)

Make 'Round To' columns display only.

2.2.65 (26-Jun-2018)

Fixed the issues of a few columns not uploading.
Add columns (Effective End Date To, Agreement Type and Accounting Rule) onto upload function for Agreement Price List Mode.

2.2.64 (26-Jun-2018)

Fixed the issues of Revision error on form opening and revision validation.

2.2.63 (26-Jun-2018)

Fixed the issues of download error.

2.2.62 (19-Jun-2018)

Fixed the issues of uploading/downloading Accumulation Attribute and Recurring Value for AGR mode.

2.2.61 (18-Jun-2018)

Fixed the issues of Display columns in different mode.

2.2.60 (15-Jun-2018)

Add the new function of Revision Updating for Standard Price List mode and Agreement Price List mode.
Fixed the issues of the fields layout.

2.2.60 (15-Jun-2018)

Add the new function of Revision Updating for Standard Price List mode and Agreement Price List mode.
Fixed the issues of the fields layout.

2.2.59 (13-Jun-2018)

Fixed the issues of form layout.

2.2.58 (11-Jun-2018)

Change Currency, Multi_Currency to text fields for Standard Agreement Price List mode.

2.2.57 (11-Jun-2018)

Fixed the issues of:
- Default value of Revision Date When opening on a blank row.
- Disabled Revision Reason field.
- Unable to upload Invoice To field.
Fixed the control type of search button.

2.2.56 (11-Jun-2018)

Fixed the issues of the default type of "Field" and the value being a $PROFILES$ value.

2.2.55 (18-May-2018)

Fixed the issues of Error 'Could not addBlankRow'.

2.2.54 (18-May-2018)

Merge three modes (Price List, Standard Price List and Agreement Price List) together.

2.2.53 (18-May-2018)

Fixed SQL error when Download via form only using Customer Account Number.

2.2.52 (18-May-2018)

Fixed poor download performance that was due to adding Customer Name and Customer Account Number onto the parent section.

2.2.51 (16-May-2018)

Add Customer Name and Customer Account Number from Customers Interface onto the download sheet and form.

2.2.50 (11-May-2018)

Fixed SQL error when downloading via form using a different display option other than 'Current and Future'.

2.2.49 (07-May-2018)

Fixed SQL error when downloading via sheet using a different display option other than 'Current and Future'.

2.2.48 (26-Apr-2018)

Fixed SQL error when using the Download form to download a price list.

2.2.47 (19-Apr-2018)

Improved download performance when filtering using Line criteria.

2.2.46 (17-Apr-2018)

Added 'Customer Name' and 'Customer Number' fields.
Enabled functionality to download via sheet using the Pricing Context column.

2.2.45 (28-Mar-2018)

Fixed SQL error when using the Download form to download a price list.

2.2.44 (28-Mar-2018)

Fixed issue where a large download would print a blank row.

2.2.43 (05-Mar-2018)

Improved support for Qualifiers.

2.2.42 (28-Feb-2018)

Internal enhancement.

2.2.41 (28-Feb-2018)

Improved support functionality.

2.2.40 (15-Feb-2018)

Fixed error on the Download form when attempting to search for a Price List To.

2.2.39 (13-Feb-2018)

Updated Downloader modules.

2.2.38 (09-Feb-2018)

Fixed the issue uploading failing price lists when the pricing attributes do not have the valueSet, for example, Customer Item.
Fixed the issue uploading failing price lists when the ‘Price Break Header’ type was not specified for price breaks.

2.2.37 (17-Jan-2018)

Improved the upload performance.

2.2.36 (08-Jan-2018)

Removed the ‘List Header ID’ on the ‘Price List Header’ form.

2.2.35 (04-Jan-2018)

Fixed the issue where wrong list header is was brought back to the spreadsheet after clicking 'OK' to close the form.

2.2.34 (04-Dec-2017)

Fixed the issue where ‘Download using the sheet data’ failed in absence of columns ‘Mobile Download’ and or ‘Global’ in the spreadsheet.

2.2.33 (13-Nov-2017)

Updated Security.

2.2.32 (13-Nov-2017)

Added a new profile option ‘More4Apps: PLW Restrict Upload on Errored Lines’ to restrict or continuation of the upload if not all lines passed the pre API validation.

2.2.31 (10-Nov-2017)

Added support to set the DFF reference field to list_type_code.
Fixed the issue where showing the code for the label of button 'Save to Repository' on the 'Management Template' form.

2.2.30 (10-Nov-2017)

Fixed the issue where template management related profile options were not installed.

2.2.29 (09-Nov-2017)

Fixed the issue where upload was failing with pricing attributes Model ID.

2.2.28 (17-Oct-2017)

Fixed issue where users could not revert the UOM back to the primary UOM. The field would be coloured light blue when this did not occur.

2.2.27 (13-Oct-2017)

Updated the common code to the latest.

2.2.26 (12-Oct-2017)

Fixed the following issues:
Downloading using sheet data didn't download the lines starting from today.
Ribbon display option didn't reflect the change of display option on the Download form.
VBA error if double clicking on the upload message columns of child section or grandchild section to open the form.
Effective date on the ribbon showed the wrong date when first time using the Wizard.

2.2.25 (10-Oct-2017)

Fixed issue when using 'Download using sheet data' icon with nothing on the sheet, the Wizard downloads a Price List.

2.2.24 (09-Oct-2017)

Corrected the wrong set up ribbon name.

2.2.23 (09-Oct-2017)

Internal enhancement.

2.2.22 (06-Oct-2017)

Fixed the issue where the download failed in Oracle R11i.
Fixed the issue where create new price list line failed if the operator is 'BETWEEN'.

2.2.21 (05-Oct-2017)

Fixed the issue getting error 'New Pricelist ID must be blank' on the Price List Header form.

2.2.20 (02-Oct-2017)

Fixed issue where the wrong Price list line ID was being returned to the sheet and on upload it was causing an error.

2.2.19 (22-Sep-2017)

Internal enhancement.

2.2.18 (22-Sep-2017)

Pricing Qualifier form and Pricing Attributes form.

2.2.17 (15-Sep-2017)

Added validation that formulas are not allowed for Price list lines where the list line type is 'Price Break Header'.

2.2.16 (15-Sep-2017)

Fixed VBA error when entering an invalid product value then tab out on the line form .
Fixed the issue for ‘Pricing Attribute’ field due to returned more values than Oracle on the pricing attributes form .

2.2.15 (08-Sep-2017)

Changed to set 'Item Number' as the default value of product attribute on the Price List line form.

2.2.14 (08-Sep-2017)

Modified Price List line form to default the ‘Product Attribute’ field to the first item.

2.2.13 (01-Sep-2017)

Fixed the issue where download form didn't load the list of Display Option properly.

2.2.12 (31-Aug-2017)

Internal enhancement.
Added support for mass uploads

2.2.11 (31-Aug-2017)

Fixed the issue where creating new price list failed when leaving the ‘Global Flag’ attribute as blank in the spreadsheet.
Fixed the issue where read-only columns were not formatted with grey colour when generating a new sheet.

2.2.10 (28-Aug-2017)

Fixed the issue when initiating bulk downloading (download over 100K lines).

2.2.09 (23-Aug-2017)

Fixed the issue where no data downloaded using the Download Sheet Data when having repeated headers in the spreadsheet.

2.2.08 (11-Aug-2017)

Fixed defaulting issue for ‘Global Flag’, ‘Active’ and ‘Mobile Download’ attributes when opening the header form.
Fixed the issue displaying the wrong value ’Round To’ on the header form.

2.2.07 (07-Aug-2017)

Fixed the issue where 'Multiple Currency' attribute was empty.

2.2.06 (04-Aug-2017)

Fixed the issue showing the wrong date format after changing the effective date on the toolbar.

2.2.05 (03-Aug-2017)

Fixed the issue where Price List header and lines had an End Date equal to the ribbon 'Effective Date' field and were not being downloaded.

2.2.04 (27-Jul-2017)

Internal enhancement.

2.2.03 (26-Jul-2017)

Fixed the issue where updating a line without providing the Line ID in the spreadsheet got the message "Cannot derive List Line ID" when 'Value' is empty for this line.

2.2.02 (14-Jul-2017)

Internal enhancement.

2.2.01 (27-Jun-2017)

Internal enhancement.

2.2.00 (26-Jun-2017)

Added support for lower database versions e.g. 10g

2.1.99 (22-Jun-2017)

Fixed the issue where download failed if the download result contains the price lists which have same secondary price list.

2.1.98 (21-Jun-2017)

Added support when using the 'Create New Record Value' column when duplicate lines exist.

2.1.97 (08-Jun-2017)

Removed the message box upon opening the header user form when a % was in the spreadsheet.

2.1.96 (06-Jun-2017)

Updated Security.

2.1.95 (30-May-2017)

Fixed the issue where upload failed if there are apostrophe in the price list name.

2.1.94 (22-May-2017)

Fixed issue where status columns were absent from the sheet which was causing the upload to error.

2.1.93 (27-Apr-2017)

Fixed issue using [BLANK] on End Date fields would cause the Start Date field to error.

2.1.92 (19-Apr-2017)

Added performance increase for the download on Excel 2010.

2.1.91 (19-Apr-2017)

Added more processing messages when download price lists.

2.1.90 (19-Apr-2017)

Prevented download from freezing during processing after data is returned from the servlet.

2.1.89 (18-Apr-2017)

Fixed unexpected PL/SQL error when uploading a Price List Line in Update mode belonging to a different Price List.

2.1.88 (03-Apr-2017)

Added support when uploading secondary price lists.

2.1.87 (03-Apr-2017)

Updated Security.

2.1.86 (22-Mar-2017)

Fixed the issue where wrong start date was set when checking price list effective dates.

2.1.85 (21-Mar-2017)

Fixed the time out issue when using 'Create New Record Value' column.

2.1.84 (24-Feb-2017)

Added support for the download when sections of the template do not exist.

2.1.83 (24-Feb-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.

2.1.82 (02-Feb-2017)

Internal enhancements.

2.1.81 (02-Feb-2017)

Internal enhancements.

2.1.80 (25-Jan-2017)

Cosmetic enhancements to Download form.

2.1.79 (19-Jan-2017)

Added support when using '%' in price lists.

2.1.78 (18-Dec-2016)

Internal enhancements.

2.1.77 (15-Dec-2016)

Fixed issue for Item Number form validation/upload validation. Error in UOM validator and when validating product.

2.1.76 (14-Dec-2016)

Implemented new Downloader to fix out of string space error.
Added Downloader order option in ribbon..

2.1.75 (14-Dec-2016)

Fixed customize fields error when removing columns (vba -9999 error).

2.1.74 (09-Dec-2016)

Added performance for uploading.

2.1.73 (09-Dec-2016)

Fixed product UOM defaulting.

2.1.72 (02-Dec-2016)

Fixed the issue where no line will be uploaded if the inventory item has the same UOM as its primary UOM

2.1.71 (01-Dec-2016)

Fixed the issue where the users are not able to open the form if 'Pricing Attribute' column is missing in the spreadsheet.

2.1.70 (30-Nov-2016)

Fixed the issue where the users are not able to open the form if 'Product Attribute' column is missing in the spreadsheet.

2.1.69 (29-Nov-2016)

Made 'Product Attribute' and 'Product Context' required fields.

2.1.68 (16-Nov-2016)

Fixed issue where line conflict check failed when in the spreadsheet a duplicated line Id exists for a header.

2.1.67 (11-Nov-2016)

Changed the conflict check option to 'Enable DB Conflict check/Disable DB Conflict check' and run spreadsheet conflict check all the time regardless if the option is enable or disable.

2.1.66 (11-Nov-2016)

Remove setting the current date as default effective from date on the header level and refined the error message for price list date validation.

2.1.65 (09-Nov-2016)

Updated Security.

2.1.64 (07-Nov-2016)

Updated Security.

2.1.63 (07-Nov-2016)

Upload Header - Fixed the issue where failed to upload the price lists which have the name with over 50 characters.

2.1.62 (02-Nov-2016)

Fixed the issue where faked conflict error was returned when uploading multiple price lists.

2.1.61 (01-Nov-2016)

Fixed issue when UOM is blank it wasn’t using the Default Value in Row 10.

2.1.60 (01-Nov-2016)

Improved the error message for updating a price list which does not exist.

2.1.59 (25-Oct-2016)

Updated module support to the latest version to fix the issue where code blew up when uploading if all DFF attributes were deleted for a section.
Fixed issue where wrong value were sent for DFF attributes when uploading - generate DFF SQL one by one rather than calling updateDFF method for all sections which have DFF columns.

2.1.58 (19-Oct-2016)

Make 'Disable DB Conflict' as default value.

2.1.57 (17-Oct-2016)

Internal bug fix.

2.1.56 (14-Oct-2016)

Internal bug fix.

2.1.55 (10-Oct-2016)

Only set primary UOM code as default when UOM default value is blank in row 10.
Reinitialise DFF columns for defaulting.

2.1.54 (07-Oct-2016)

Correct the Online Documentation link on Setup tab.
Set Conflict Option on the ribbon tool bar to 'Disable Conflict' as default.

2.1.53 (04-Oct-2016)

Fixed the issue of duplicated key when building the dictionary for spreadsheet data line ID - the empty line id won't be added to the dictionary.

2.1.52 (03-Oct-2016)

Improved the performance for conflict check.

2.1.51 (27-Sep-2016)

Fixed the issues of running conflict check:
- Added sort for pricing attributes in the spreadsheet to make the concatenate string the same for same pricing attributes.
- Changed the item of line and db dictionaries to wDictionary because different lines could have same product attribute with different date range.
- After generating the DB line dict removed the lines which exist in the spreadsheet from DB dict because the data in the DB is old.

2.1.50 (12-Sep-2016)

Fixed the issue that when new/updated lines fall into the time range of exist/other lines conflict check will pass which is wrong.

2.1.49 (07-Sep-2016)

Implemented new conflict check.

2.1.48 (02-Aug-2016)

Added 'Conflict Validation' dropdown. Enable to run conflict validation on upload.

2.1.47 (31-Aug-2016)

Updated DW module to the latest version 1.0.58

2.1.46 (16-Aug-2016)

Added validation to prevent the upload of prices to the lists when the access of responsibility is view only.
Increased the limitation for the value of max rows on the Download form to 99999.

2.1.45 (05-Aug-2016)

Add limitation 999 for the value of max rows on the Download form (No code change but changed the maxtextlength of control).

2.1.44 (29-Jul-2016)

Removed package check in New Record Value validation - this could error when:
- A client has European decimal settings as the comparison was for 1.1
- The package was not installed correctly [Internal]

2.1.43 (27-Jul-2016)

Fixed overwriting the user input data for the Precedence field.

2.1.42 (21-Jul-2016)

Fixed overflow issue on price break values when a large number was entered.

2.1.41 (20-Jul-2016)

Check for valid dates before formatting Price List header/lines date validation.

2.1.40 (14-Jul-2016)

Fixed [BLANK] functionality not defaulting from row 10.
[BLANK] can be used to ignore list lines when used in the Line Upload Mode field.

2.1.39 (05-Jul-2016)

Revised error messages for header and line upload load mode to make it reasonable.

2.1.38 (04-Jul-2016)

Added 'Header Upload Mode' and 'List Header ID' to Header section.
Removed 'Load Option' from PLW toolbar and right-click menu.
Added message that section and child sections won't be processed without no update mode for line level.

2.1.37 (29-Jun-2016)

Added upload colour for values that are uploaded.
Fixed DFF issue where values were being excluded from upload.

2.1.36 (25-Jun-2016)

When selecting 'End To End Trace' in the 'Debug Upload' dropdown, the trace file path form now opens. The details are now also written to column E, Rows 1 and 2.

2.1.35 (25-Jun-2016)

Removed client licensing check - issue is more common and can occur when using a value set with meaning.

2.1.34 (23-Jun-2016)

Added client licencing check to attribute Value from/to original FOL.

2.1.33 (23-Jun-2016)

Fixed issue where attribute rows were being set to 'Pending' incorrectly when line upload mode was blank.
Fixed issue where line was still being uploaded when message 'Price List Line ID must be cleared'.
Added M4APS_PLW_OVERRIDE_UPLOAD_SECURITY [More4Apps: PLW Override Upload Security] to override form function check when uploading.

2.1.32 (22-Jun-2016)

Added validation check if 'Line Upload Mode' is missing from the sheet (user will get a message on initialise).

2.1.31 (21-Jun-2016)

Added 'Product Value' to query to derive Line ID.
Added error message if List Line ID is returned twice on the sheet.
Removed List line ID column from 'Clear Status Columns'.
Added 'Line Upload Mode' column to the wizard - currently has Create/Update values only. Create requires a blank List Line ID - Updates require a List Line ID.
The LOV for upload mode is currently static for English - Common 2 has a static LOV which looks at the Messages sheet.

2.1.30 (21-Jun-2016)

Fixed pricing Attribute From value causing (API Values Required) ambiguous error - caused by incorrect code setting attribute value datatype to date. Replicated using a pricing attribute that is a number, then providing a value from of around 12 digits (Excel thinks this is a date).

2.1.29 (18-Jun-2016)

Fixed validation returning the same List Line ID for multiple items where attributes were different e.g. line with item f2000 already exists in PL, but list line was deleted. Copied line down and added new attributes.
Wizard would return the same list line ID for both lines (since attributes are also part of the line). This could still cause problems in the future - if attributes on the sheet are modified e.g. or parts of the line are updated.

2.1.28 (15-Jun-2016)

Minor bug fix.

2.1.27 (15-Jun-2016)

Fixed issue when Excel is not English – cannot open the form.

2.1.26 (14-Jun-2016)

Fixed Qualifier Value from LOVs - no data was being returned for Customer - Customer Class.
Updated DW Modules to the latest version: 1.0.48
Added download option criteria for only line and its child level or bLineCriteria is true to fix the issue that price list without lines were not successful to be downloaded.

2.1.25 (13-Jun-2016)

Default Header Start Date From to today’s date.
Modified date message to only compare Header start date to Line dates if no Header Date To.

2.1.24 (09-Jun-2016)

Fixed independent pricing attribute LOVs causing SQL error.

2.1.23 (03-Jun-2016)

Added date validation if header dates are blank but lines are not.

2.1.22 (02-Jun-2016)

Fixed attribute conflict check.
Added caching to pricing attribute values.

2.1.21 (02-Jun-2016)

Fixed crash with product conflict check validation.
Fixed error message displaying the pricing attribute value rather than the row for conflict check.

2.1.20 (01-Jun-2016)

Added Attribute information and Product Value to the conflict checking validation.
Updated Display Options once user changed them on Download form.
Move the Download option to the header of Download form because they are used by both header and line level now.

2.1.19 (31-May-2016)

Updated DWCustomisations file.

2.1.18 (31-May-2016)

Updated DW Modules to the latest version: 1.0.46

2.1.17 (27-May-2016)

Removed all these four date controls and added same download option setting as Ribbon.
Applied Effective Date and Download option on the ribbon to header level.

2.1.16 (25-May-2016)

Fixed issue when Item Key Flexfield is not showing all segments.

2.1.15 (23-May-2016)

Updated DW Modules to the latest version: 1.0.

2.1.14 (19-May-2016)

Fixed issue when user closes the form as sometimes gets automation errors

2.1.13 (09-May-2016)

Updated DW Modules to the latest version: 1.0.44

2.1.12 (20-Apr-2016)

Added checking for the column does exist in the dRoe before generate SQL where clause in the returnRowSQL

2.1.11 (14-Apr-2016)

Changed returnType to decimal when qualifier data type or price attribute data type is not LOV.
Added trial limitation check for CBOVAL_VALIDATE_CONCURRENT option.

2.1.10 (12-Apr-2016)

Disable fromto, tofrom and toto combobox and search button for Qualifier and Price attribute when it is LOV type.

2.1.09 (11-Apr-2016)

Added trial license counter to price list header. Price Lists/List lines will be counted towards the maximum 5 loads.
User is not logged out after upload, however no more Price Lists will be loaded until user has logged out.
Fixed issue with cached qualifier details in Download form not setting control type correctly.
Fixed issue with custom logo being copied across twice.

2.1.08 (07-Apr-2016)

Fixed Wizard New Sheet button erroring when customLogo missing from Template123.

2.1.07 (01-Apr-2016)

Removed ITEM defaulting on Download form - this always restricts download by line criteria.

2.1.06 (23-Mar-2016)

Fixed Qualifier and Attribute download from Value From - To with LOV causing error.

2.1.05 (17-Mar-2016)

Fixed ICX issue for concurrent uploads.

2.1.04 (17-Mar-2016)

Added Qualifier download for Download form.

2.1.03 (16-Feb-2016)

Removed defaulting for Product Context.

2.1.02 (16-Feb-2016)

Changed template logo to name CustomLogo.

2.1.01 (26-Feb-2016)

Added Downloader functionality.

2.1.00 (24-Feb-2016)

Fixed error when assigning same Attribute code to two different contexts (11i only).
Removed vbNewLine from queries as the carriage return caused error on clients system in 11i (10.2 DB).
Updated package body to 1.3.5 - Fixed precision error.

2.0.99 (03-Feb-2016)

Updated Security

2.0.98 (22-Jan-2016)

Package Body Update – New recommended Version 1.3.4

2.0.97 (21-Jan-2016)

Fixed request ID column check when switching between validate options

2.0.96 (18-Jan-2016)

Fixed Request ID printing to incorrect row during validate concurrent.
Moved logo across to result columns so it doesn't get reprinted with every blank row.

2.0.95 (15-Jan-2015)

Added list line ID to clear status columns.
Fixed concurrent issue where results weren't being brought back for multiple headers.
Fixed Request ID column colour (set to standard blue result column colour).

2.0.94 (06-Jan-2016)

Added Request ID column - required for concurrent uploads.
Results from DB were being overwritten when multiple price lists uploaded in same request ID.

2.0.93 (06-Jan-2016)

Fixed concurrent refresh for multiple price lists.
Updated Package – Now requires [1.3.3 BODY] and [1.1.1 HEAD].

2.0.92 (31-Dec-2015)

Fixed list line IDs being returned after load option check resulting in incorrect error in update.
Rewrote conflict check - Oracle DB check no longer exists (API handles it).
Fixed qualifier value controls (list width size corrected for value from/to. control no longer clears).

2.0.91 (22-Dec-2015)

Fixed download form pricing value labels.
Added mandatory attribute column message when changing context on DFF form for columns not on the sheet.

2.0.90 (21-Dec-2015)

Fixed Download form filter - now gets passed down from the header.
Fixed header form labels truncating column names.

2.0.89 (18-Dec-2015)

Fixed incorrect results returning from package when price list isn't created.
Fixed secondary price list precedence label as not wide enough to accommodate the column name.
Fixed DFF form working incorrectly if required DFF column message appeared.

2.0.88 (14-Dec-2015)

Fixed Line Item conflict messages not returning correctly to sheet

2.0.87 (14-Dec-2015)

Fixed value sets download where the additional where clause is returning as a grouping clause

2.0.86 (11-Dec-2015)

Fixed issue when Delete columns were removed from the sheet.
Fixed download ribbon option causing download error on line section.
Fixed certain Pricing Value To and Value From LOV from bringing back incorrect results.

2.0.85 (10-Dec-2015)

Debug Mode and DB Trace Mode removed from ribbon dropdown.
Fixed Line Type validation not correctly preventing upload of the failed line.

2.0.84 (09-Dec-2015)

Fixed custom label on Customize Fields not respecting the Mandatory Fields selection

2.0.83 (08-Dec-2015)

Fixed Attribute and Line criteria on the Download Form when the sections don't exist on the sheet

2.0.82 (08-Dec-2015)

Added validation for Line Type - this field cannot be updated but API allows it on 11i

2.0.81 (08-Dec-2015)

Fixed issue with mandatory fields not being made required to upload.
Fixed download crash when line section was missing.

2.0.80 (19-Nov-2015)

Fixed trial for Validate Upload mode only

2.0.79 (19-Nov-2015)

Added trial limit check - 5 list lines allowed

2.0.78 (18-Nov-2015)

Fixed validate concurrent uploads not correctly using the current ICX session

2.0.77 (18-Nov-2015)

Updated package error to return to error handler.
Updated error handler in procedures.
Upload will not stop if package isn’t installed correctly or not the latest version.

2.0.76 (05-Nov-2015)

Added limit to customize fields Label field to only allow 200 characters.
Fixed mandatory column check in Wizard.

2.0.75 (04-Nov-2015)

Added fix for creating a new sheet on Excel 2013

2.0.74 (04-Nov-2015)

Removed concurrent profile as now redundant from Wizard

2.0.73 (03-Nov-2015)

Updated UOM to stop recreating the defaulter class when assigning a new UOM default value

2.0.72 (02-Nov-2015)

Updated to support latest package body (1.3.2)

2.0.71 (29-Oct-2015)

Removed download filter from downloader as too slow on some clients systems.
Using new download that only restricts that section for the criteria used - won't pass filter up to parent.
Columns now used for download via sheet:
- Price list name, mobile/active/global download/current/effective from/effective to.
- Product attribute/value/category/UOM/line type.

2.0.70 (27-Oct-2015)

Updated Security – Oracle Form check for access to the pricing form

2.0.69 (12-Oct-2015)

Fixed Latest_Version profile option being deleted when logging into Wizard

2.0.68 (02-Oct-2015)

Fixed download labels for ribbon and right click

2.0.67 (30-Sep-2015)

Fixed context column not resolving [BLANK] value

2.0.66 (16-Sep-2015)

Fixed Qualifier and Price Break DFFs not being downloaded to the sheet.
Ordered Price List download by Price List Name.

2.0.65 (09-Sep-2015)

Fixed ordering of Price List Name for Download Form to be consistent with
Price List Name From and To validation.
Fixed download of Yes/No values in spanish environment.
Fixed Qualifier Value From validation erroring when form is opened after entering data.
Fixed Qualifier DFF attributes not being recognized by the sheet.
Fixed Qualifier Value From search control not resetting LOV.

2.0.64 (27-Aug-2015)

Fixed concurrent uploads with core 212

2.0.63 (24-Aug-2015)

Fixed createNewSheet breaking excel ribbon.
Added delete message when deleting a child.

2.0.62 (24-Aug-2015)

Updated Security

2.0.61 (20-Jul-2015)

Added downloadSelected fix

2.0.60 (08-Jul-2015)

Fixed new record value error causing wizard to blow up

2.0.59 (08-Jul-2015)

Fixed mandatory columns in select customize fields

2.0.58 (08-Jul-2015)

Fixed large uploads erroring

2.0.57 (08-Jul-2015)

Fixed default row 10 date

2.0.56 (07-Jul-2015)

Updated Security

2.0.55 (26-Jun-2015)

Added check for Price Break errors to stop the line from uploading

2.0.54 (28-May-2015)

Fixed Upload Error when returning results

2.0.53 (26-May-2015)

Fixed concurrent request message when not finished.
Fixed price break issues when defaulting.

2.0.52 (25-May-2015)

Fixed breaks not being uploaded when concurrent

2.0.51 (22-May-2015)

Fixed price break validation

2.0.50 (22-May-2015)

Added functionality to update UOM when there is a list line id
Fixed Price break sheet data being overwritten when form open

2.0.49 (19-May-2015)

Updated Support with fixes
Added Download form Clear button
Fixed price break Application method dependency

2.0.48 (19-May-2015)

Fixed incorrect qualifier index

2.0.47 (15-May-2015)

Fixed Delete Line erroring when not on sheet

2.0.46 (15-May-2015)

Fixed UOM defaulting EA invalid
Fixed product value and description not updating

2.0.45 (15-May-2015)

Fixed parse return string when section missing

2.0.44 (14-May-2015)

Fixed Defaulting values for qualifiers
Fixed price break form labels and required field validation

2.0.43 (13-May-2015)

Fixed download form issue with Active and mobile download
Moved sections into order

2.0.42 (13-May-2015)

Fixed download form KFF query from running large SQL
Fixed Qualifier, Attribute and Line Validation for required fields

2.0.41 (12-May-2015)

Fixed Break messages not returning correctly
Changed download form to use regular download

2.0.40 (07-May-2015)

Fixed the following:
- API Return messages for attributes, qualifiers
- Required value from column not being invalidated
- Fixed issue with default row 10 formula
Removed UOM value default as defaults from item
Added price break attribute validation

2.0.39 (05-May-2015)

Fixed Price Break Attribute LOV for 'Item Amount'

2.0.38 (04-May-2015)

Fixed the following:
- Download of Price Break Header line types
- Price Break Application method SQL
- Price Break Attribute LOV
- Price Break download ordering by value from
- Item Category product attribute erroring on value selection
- Upload All price lists
- Concurrent requests

2.0.37 (01-May-2015)

Fixed secondary price lists not being uploaded (they are counted as qualifiers by API)

2.0.36 (01-May-2015)

Fixed download form LOV value for active

2.0.35 (01-May-2015)

Changed label from Display Option to Download Option
Fixed Create New Sheet default value in LOV of 1
Added qualifier start date to Qualifier Upload Procedure

2.0.34 (30-Apr-2015)

Fixed new Ribbon changes for Validate and Upload

2.0.33 (30-Apr-2015)

Updated Validate Option in core/ribbon code

2.0.32 (29-Apr-2015)

Improved line SQL

2.0.31 (29-Apr-2015)

Added Debug Upload option to setup ribbon

2.0.30 (29-Apr-2015)

Changed flexNumber for item flex to 101
Fixed header form -> line form button as lost fix

2.0.29 (22-Apr-2015)

Ensured all command buttons on form have default = vbfalse

2.0.28 (16-Apr-2015)

Added line start date and end date range to replace display option
For large price lists to restrict data for query

2.0.27 (15-Apr-2015)

Fixed download form issue when downloading item

2.0.26 (13-Mar-2015)

Fixed Ribbon issue in Excel 2003

2.0.25 (27-Mar-2015)

Fixed issue where form OK would error if DFF not set up in Oracle

2.0.24 (26-Mar-2015)

Fixed conflict checking for lines where line start date/end date didn't exist

2.0.23 (26-Mar-2015)

Fixed issue with form element startup when going from 3rd child element - 1st header then back to the 1st child element
Fixed download issue with missing children sections
Fixed validation for qualifiers with 'BETWEEN' operators

2.0.22 (17-Mar-2015)

Fixed Settings123 as Customize Fields couldn't be customized
Traced new qualifier attribute query as wrong results returned for ORDER
Fixed header only (no other sections present) upload issue
Fixed Product Value search erroring when Description column missing from sheet
Aligned form controls for better consistency and readability
Fixed download form erroring when choosing pricing attribute that requires numeric value from and to
Fixed upload failing when a qualifier was invalid from validation
Qualifier Between - Allow free type field as this is what Oracle field allows
Reason for this is when = qualifier uses LOV, between is free type
Downloader changed to print ID when 'BETWEEN'

2.0.21 (10-Mar-2015)

Fixed download where Price List existed without any lines
Fixed qualifier duplicate check where context, attr and precedence can be the same

2.0.20 (02-Mar-2015)

Fixed upload ribbon message and order of ribbon DFF forms

2.0.19 (27-Feb-2015)

Removed Header Effective Date From defaulting to today’s start date (API will default)

2.0.18 (25-Feb-2015)

Fixed Product Category display only column displaying wrong field (now shows Category concatenated segments)

2.0.17 (23-Feb-2015)

Added formatBlankDate in ValidatorPriceListDates to format header and line/qualifier dates correctly when using C_BLANK

2.0.16 (19-Feb-2015)

Fixed [BLANK] on header date columns, API defaults header start date to today’s date

2.0.15 (18-Feb-2015)

Removed Outer Join on keyFilterJoins for each section when joining IDs back to header table
Fixed download form error on opening form > 500
Fixed [BLANK] issue in conflict checking for lines

2.0.14 (17-Feb-2015)

Removed Attribute Duplication check, will now correctly find update ID for attributes

2.0.13 (16-Feb-2015)

Effective date in ribbon now defaults to today’s date on startup
Line start date defaulter (todays date) removed
Check for conflicting attributes for a line (otherwise API updates an existing attribute)
Line Start and End date check validation fixed

2.0.12 (12-Feb-2015)

Fixed timeout on post validating line records

2.0.11 (11-Feb-2015)

Fixed large upload not uploading into Oracle correctly (when statestep)
Fixed download form labels being cut off

2.0.10 (11-Feb-2015)

Fixed conflict checking for existing lines in Oracle and product dates on the sheet
Fixed defaults 'Mobile Active' and 'Price List Active' on download form

2.0.09 (10-Feb-2015)

Updated to latest common
Fixed creating new template with All Columns
Fixed Right click toolbar menu order

2.0.08 (10-Feb-2015)

Changed download via sheet supertip to say "Download Price List"

2.0.07 (09-Feb-2015)

Started versioning from 2.0.07 as old PLW currently 1.5.32

1.5.17 (20-Nov-2013)

Fixed issues when loading multiple qualifiers. Query to check existing value was not taking Grouping Number into account

1.5.16 (13-Nov-2013)

Changed Price Breaks form to default to item quantity when blank
Added in code to allow delimited values to not include the colon if the description is missing from the attribute or qualifier
Updated to common code 205

1.5.15 (25-Oct-2013)

Improved Error handling on Attribute and Qualifier flexfields
Updated Qualifiers form, Value from list of values widened, now displaying 3 columns
Value of attribute and qualifier now determined by value concatenated with meaning to allow unique identification of record. Format VALUE_COLUMN:MEANING_COLUMN using : as deliminator

1.5.14 (12-Oct-2013)

Changed get organization call to cater for sites where lot size not specified in mtl_parameters
Fixed bug where 0 operating unit id was treated as invalid

1.5.13 (02-Oct-2013)

Changed Wizard to allow user to set DFF values to [BLANK] to remove DFF value

1.5.12 (12-Sep-2013)

Fixed bug where application type List of values is missing “Block”
Fixed bug where user couldn’t null out price list end date

1.5.11 (12-Sep-2013)

Fixed bug where non seeded attributes do not show for price breaks
Added price breaks form button to price list lines

1.5.10 (12-Sep-2013)

Fixed bug in download selected not ordering price lists correctly and not getting all product values where a price list exists more than once in a list

1.5.9 (15-Aug-2013)

Added in prepare string code around header downloader for lists with apostrophe’s in the name
Fixed bug where selecting date in download form via calendar caused the download button to be disabled
Fixed price breaks form zoom to lines not working
Fixed line end date being blanked out not clearing value in spreadsheet

1.5.8 (14-Aug-2013)

Changed downloader to use ID and temp table when downloading chunks to improve performance and ensure the item and elements can join
Added in prepare string code around header downloader for lists with apostrophe’s in the name
Fixed bug where selecting date in download form via calendar caused the download button to be disabled

1.5.7 (08-Aug-2013)

Changed downloader to download in sections to stop overloading Excel with too much data
Fixed bug in downloader form where item was not available if sales_order_enabled flag <> Yes

1.5.6 (02-Aug-2013)

Removed precision default 2dp when loading new headers with multicurrency set

1.5.5 (17-Jul-2013)

Reapplied core code to latest version 204.12

1.5.4 (15-Jul-2013)

Added in defaulting values for line information to price break form

1.5.3 (12-Jul-2013)

Price Break QPDFF values converted from codes to values on download
Price Break pricing attribute cbo coloring on startup of form fix

1.5.2 (09-Jul-2013)

Price Breaks form option added to ribbon and right-click menu

1.5.1 (04-Jul-2013)

Added in item specific UOM validation
Fixed download form error where values from list name and items where not always sent to downloader

1.5.0 (28-Jun-2013)

Changed infrastructure to check for duplicates and date crossovers to the server to improve speed

1.4.3 (13-Jun-2013)

Fixed bug where downloading by product value returned all values for the price list

1.4.2 (11-Jun-2013)

Enforced loading currency conversion if blank (and required) when doing an update to get around API setting it to an incorrect value
Changed download to not require lines if there is only a header and a secondary price list
Enhancement: Added in Price Break functionality

1.4.1 (05-Jun-2013)

Enhancement:  Added audit history of created by and last updated by to lines, qualifiers and price breaks
Enhancement:  Changed functionality of copy line to run if the last line is being updated and no new lines exist, even if the last line has an end date

1.4.0 (22-May-2013)

Enhancement: Added in functionality to create a new line based on a previous line

1.3.4 (20-Mar-2013)

Added in feedback to download selected when items don’t exist in the download

1.3.3 (20-Mar-2013)

Fixed issue with all sheet load treating lines as blank lines and missing out price lists
Fixed issue where Wizard thought blank line ID was a key value causing duplicate key issue

1.3.2 (18-Mar-2013)

Wizard now checks for duplicate qualifiers to stop API loading them if they have failed validation

1.3.1 (04-Mar-2013)

Updated Wizard to return the line ID of new lines loaded back to the spreadsheet

1.3.0 (04-Mar-2013)

Changed Wizard to use price list line ID to verify if it is an update or not. Removing the need to have new start/end dates

1.2.15 (27-Feb-2013)

Changed Wizard selection method to reduce time in building query
Fixed bug in validation of line dates vs header dates where line date value is null it was trying to validate it

1.2.14 (25-Feb-2013)

Changed upload query for item details to only use the basic item validation rather than full used in inventory Wizards
Added row counter to downloader
Fixed more performance issues with downloader

1.2.13 (15-Feb-2013)

Fixed issue with testing of dates not setting date format to YYYYMMDD to get around international date formats

1.2.12 (04-Feb-2013)

Fixed text issue in mode icon
Fixed bug in Wizard header form where date format swapping to USA format for non USA customers

1.2.11 (07-Jan-2013)

Changed multicurrency check to look at currency values > 1 rather than just 0 before being set to multiorg

1.2.10 (07-Jan-2013)

Added support for line updates to not require current price list value
Fixed download selected not taking effective date into account and using system date
Enhancement: Added support for download selected lines not just lists

1.2.9 (12-Dec-2012)

Made a change to code for SOB profile not set against the responsibility

1.2.8 (14-Dec-2012)

Ribbon fix for application mode and latest core code imported

1.2.7 (12-Dec-2012)

Added code to look at AR system parameters for currency if SOB profile not set against the responsibility

1.2.6 (28-Nov-2012)

Fixed issue where error message on the same line as the header were missing
Enhancement: Changed functionality to allow line end date and new line start date within the same load

1.2.5 (28-Nov-2012)

Found additional performance enhancements around the uploader
Fixed bug in download form with a list index issue
Added in UOM validation where UOM is not primary UOM

1.2.4 (26-Nov-2012)

Enhancement: Added product Context and Attribute fields in download from spreadsheet form
Changed download code, now faster if user selects product context and attribute
Found performance enhancements around the uploader
Fixed bug when creating additional records for the same item, different UOM
Stopped Wizard putting 12:00:00 in date fields if they are left blank

1.2.3 (14-Sep-2012)

Fixed issue with not being able to update end date to another end date or a different end date

1.2.2 (14-Sep-2012)

Fixed issue with loading qualifiers not resetting to the top row before loading

1.2.1 (30-Aug-2012)

Added Org_id parameter to API for release 12
Fixed pressing Ok button in the line attributes clearing out the record

1.2.0 (08-Aug-2012)

Updated file from .xls to .xlsm
Ribbons Enabled

1.1.10 (30-Jul-2012)

Fixed Line Form issue where wizard populated line above
Updated common code

1.1.9 (08-Jul-2012)

Fixed Download DFF issue when segment dependent on parent segment

1.1.8 (01-Jun-2012)

Fixed bug in download selected not downloading all records, just future and current
Fixed bug in download selected where blank records caused all price lists to download and removed duplicate selected price lists from downloading more than once
Changed wizard to allow secondary price lists to be loaded in a single pass rather than requiring a subsequent upload

1.1.7 (18-May-2012)

Fixed bug with download erroring when getting all price lists for an item
Fixed open form issue with secondary price lists

1.1.6 (26-Apr-2012)

Fixed issue where checking required qualifier fields didn’t return a detailed error message
Fixed bug where price list form failed if list end date was missing on the sheet

1.1.5 (26-Apr-2012)

Added in form for download selected to choose current/future and an active date

1.1.4 (04-Apr-2012)

Fixed issue with template listing incorrect column names
Fixed issue where secondary price list would error if description field missing

1.1.3 (04-Apr-2012)

Added download price list from spreadsheet functionality

1.1.2 (21-Mar-2012)

Fixed issue where errored line causing whole load to stop rather than just stopping that line

1.1.1 (19-Mar-2012)

Fixed Lines Form issue where New effective dates were grey but enabled
Fixed issues with secondary price lists form not opening correctly

1.1.0 (08-Mar-2012)

Added functionality to support secondary price lists

1.0.29 (28-Feb-2012)

Fixed status bar issue in get precedence module

1.0.28 (15-Feb-2012)

Fixed issue with attribute required fields causing validation error when opening the form
Fixed date issue where it wasn’t checking the end date being blank and failed thinking the date was between the dates
Updated Common Modules

1.0.27 (25-Jan-2012)

Updated text object fields to use the .text rather than .value to stop fields losing trailing 0′s
Added in new fields for New Start Date and Old Start Date. Reduces confusion on if record is an update or create transaction
Fixed bug where primary UOM field not updating
Added functionality to allow download of lines that are current and future dated as well as All option

1.0.26 (14-Nov-2011)

Fixed bug with top line for attributes not being found

1.0.25 (12-Dec-2011)

Fixed bug with qualifiers trying to load when missing context data

1.0.24 (07-Dec-2011)

Changed wizard to trim any spaces after text in all level object modules for strings

1.0.23 (25-Nov-2011)

Fixed attribute form not opening correctly
Fixed upload updating the item number with the previous record after loading

1.0.22 (22-Nov-2011)

Fixed rounding error using positive 2 instead of negative 2

1.0.21 (18-Nov-2011)

Added defaulting functionality

1.0.20 (16-Oct-2011)

Added support for Global Price lists
Added defaulting functionality to the price lists

1.0.19 (10-Oct-2011)

Fixed issue with splash form not loading correctly, updated generic code as part of the fix

1.0.18 (27-Sep-2011)

Set lines form to default product context, line type and application method
Set uploader to default product context, line type and application method
Fixed bug where line would try to load with out a price value

1.0.17 (04-Sep-2011)

Bug with defaulting line start date
Fixed frozen attribute form issue

1.0.16 (19-Aug-2011)

Fixed issue with creating a new line and end dating old price list line

1.0.15 (17-Aug-2011)

Added in functionality to allow valid lines/qualifiers to load and report on errored lines
Added cancel function when validating load

1.0.14 (25-Jul-2011)

Added in defaulting precedence for price list lines

1.0.13 (15-Jun-2011)

Removed multicurrency field usable if not using advanced pricing

1.0.12 (03-Jun-2011)

Removed security_group_id from dffDFF and QPDFF
Fixed security issue not checking the correct form
Changed multicurrency to check number of records before it is enabled
Updated downloader to not take attribute or qualifiers into account if the columns are not on the sheet

1.0.10 (17-May-2011)

Added support for comma decimals
Added support for oracle versions not supporting multicurrency functionality

1.0.9 (25-May-2011)

Added support for 11.5.9 – Order management only

1.0.8 (06-May-2011)

Fixed Short Date Issues

1.0.7 (06-May-2011)

Fixed issue with DFFs not loading
Increased size of LOV for price list in download form.

1.0.6 (05-May-2011)

Added support to blank out fields where null values are allowed.

1.0.5 (03-May-2011)

Fixed bug in purchaseable flag not being set for PO based price lists

1.0.4 (22-Apr-2011)

Added in code to clear formats to stop wizard crashing in Excel 2007+
Fixed bug in uploader not uploading freight terms
Fixed bug in upload qualifier DFFs

1.0.3 (26-Jan-2011)

Fixed attribute index issue by specifying line records when loading lines, did the same for qualifiers as well

1.0.2 (24-Jan-2011)

Fixed qualifier required columns and upload issue

1.0.1 (22-Jan-2011)

Added qualifiers to Wizard

1.0.0 (06-Jan-2011)

Initial version