3.5.11 (15-Apr-2025)

Default Browser Login - Fixed bug where the browser would not navigate away from the homepage. This stopped the login process from completing.

3.5.10 (15-Oct-2024)

Added Default Browser Login option.

3.5.09 (28-Nov-2023)

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

3.5.08 (20-Oct-2023)

Fixed the error issues when users refresh the status without submission.

3.5.07 (11-Oct-2023)

Upload Example sheet. Removed trial information from setup page.

3.5.06 (10-Oct-2023)

Added new digital signature.

3.5.05 (30-Jun-2023)

Internal update.

3.5.04 (30-Jun-2023)

Standard Cost mode: Fixed the header form layout issues.

3.5.03 (31-May-2023)

Fixed VBA error when loading discrete costs with formula on the defaulting rows.

3.5.02 (01-May-2023)

Internal enhancements.

3.5.01 (01-Feb-2023)

Read Only Defaults should set it to No and it should not run for upload.

3.4.99 (01-Feb-2023)

Read Only Defaults should set it to No and it should not run for uploads.

3.4.98 (18-Jan-2023)

Internal update.

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

3.4.96 (05-Jan-2023)

Internal update.

3.4.95 (02-Dec-2022)

Internal update.

3.4.94 (28-Sep-2022)

Internal update.

3.4.93 (19-Sep-2022)

Updating licencing modules.

3.4.92 (22-Jul-2022)

Removed extra blank lines between each download.

3.4.91 (03-May-2022)

Internal update.

3.4.90 (11-Apr-2022)

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

3.4.89 (16-Mar-2022)

Fixed Customize Fields form where customer could untick mandatory columns.

3.4.88 (14-Mar-2022)

Fixed thick blue line at the bottom of the form.

3.4.87 (14-Mar-2022)

Fixed the ribbon message issues when hovering over the icon.

3.4.86 (10-Mar-2022)

Internal update.

3.4.85 (28-Feb-2022)

Fixed the issue with incorrect Group ID while Group ID is blank.

3.4.84 (28-Feb-2022)

Fixed the issue with unable to show all cost type.

3.4.83 (24-Jan-2022)

Fixed the issue of ability to update item cost information when cost type is not allowed to update.

3.4.82 (21-Jan-2022)

Custom Query update with SQL injection fixes.

3.4.81 (07-Dec-2021)

Internal update.

3.4.80 (06-Oct-2021)

Internal update.

3.4.79 (09-Sep-2021)

Fixed the issue with Download Category not matched on the form download criteria.

3.4.78 (08-Sep-2021)

Fixed the issue with Category KFF.

3.4.77 (01-Jul-2021)

Added the Make/Buy onto download form criteria.

3.4.76 (01-Jul-2021)

Fixed the upload performance issues.

3.4.75 (01-Jul-2021)

Internal update.

3.4.74 (01-Jul-2021)

Discrete Standard Costing Mode: Added ability to download Buy Items.

3.4.73 (11-Jun-2021)

Fixed the printing issue when downloading large data.

3.4.72 (10-May-2021)

Fixed run time error message.

3.4.71 (10-May-2021)

Fixed the template issue.

3.4.70 (21-Apr-2021)

Updated security.

3.4.69 (02-Dec-2020)

Updated security.

3.4.68 (06-Oct-2020)

Updated security.

3.4.67 (21-May-2020)

Fixed issue with 'Mode to run request' being blank in the 'Submit Cost Import' window.

3.4.66 (21-May-2020)

Added all columns available on the default template.

3.4.65 (20-May-2020)

Fixed issue of error message when switching between different modes, with missing mandatory columns template.

3.4.64 (19-May-2020)

Fixed issue when mandatory column missing and then double clicking on the cell to open the form.

3.4.63 (19-May-2020)

Discrete Standard Costing Mode: Fixed issue with mandatory column missing when creating a new sheet.

3.4.62 (19-May-2020)

Fixed issue with SQL error when the mandatory column is missing.

3.4.61 (18-May-2020)

Fixed issue with status bar message invisible.

3.4.60 (15-Apr-2020)

Fixed issue with Run-time error '9999'.

3.4.59 (02-Apr-2020)

Rebranding of logo and color scheme.

3.4.58 (03-Mar-2020)

Internal enhancement.

3.4.57 (13-Feb-2020)

Major update for common, code and custom query.

3.4.56 (20-Dec-2019)

Internal enhancement.

3.4.55 (20-Aug-2019)

Resource Rates Mode: Added functional Currency Flag filter to the Resource Code LOV.

3.4.54 (28-Jun-2019)

Internal bug fixes.

3.4.53 (20-Jun-2019)

Internal enhancement.

3.4.52 (20-Jun-2019)

Internal enhancement.

3.4.51 (20-Jun-2019)

Updated the Setup sheet logo.

3.4.50 (18-Jun-2019)

Internal enhancement.

3.4.49 (18-Jun-2019)

Color and Example sheets updated.

3.4.48 (09-Nov-2018)

Fixed upload error when the Group ID sequences gets too large.

3.4.47 (02-Nov-2018)

Internal enhancement.

3.4.46 (17-Oct-2018)

Internal enhancement.

3.4.45 (11-Oct-2018)

Internal enhancement.

3.4.44 (01-Oct-2018)

Standard Costing mode: Improved performance when attempting to do an Upload All.

3.4.43 (03-Sep-2018)

Added checks to ensure Process Manufacturing has been installed.

3.4.42 (30-May-2018)

Updated security.

3.4.41 (30-May-2018)

Resource Overheads mode: Added 'Inactive On' display only column.

3.4.40 (17-May-2018)

OPM Actual Cost Adjustment mode: Fixed error where the Reason Code did not have the correct LOV.

3.4.39 (27-Feb-2018)

OPM Actual Cost Adjustment mode: Fixed error when downloading by Component Class Code on the sheet.

3.4.38 (27-Feb-2018)

OPM Actual Cost Adjustment mode: Fixed error when downloading by Adjustment Type on the sheet.

3.4.37 (26-Feb-2018)

OPM Standard Costing mode: Fixed error when downloading by Component Class Code on the sheet.

3.4.36 (22-Feb-2018)

OPM Standard Costing mode: Fixed error on the Download Form when the Item column is not on the sheet.

3.4.35 (21-Feb-2018)

Fixed error when opening the Form on a row greater than 500 (e.g. 768) would error.
OPM Standard Costing mode: Fixed error on the Download form when attempting to use the Usage Type as a filter.

3.4.34 (19-Feb-2018)

Fixed error where the Default Rows were not being frozen at the top of the sheet.

3.4.33 (13-Feb-2018)

Updated Downloader modules.

3.4.32 (16-Feb-2018)

Updated Security.

3.4.31 (13-Feb-2018)

Downloader ribbon name changed to ‘Custom Query’ ribbon.

3.4.30 (07-Feb-2018)

Fixed error in the User form when doing an Upload All without being Logged in.

3.4.29 (08-Dec-2017)

Fixed validation errors when changing between modes.

3.4.28 (28-Nov-2017)

Resource Overheads and Overhead Associations mode: Fixed issues in the Download forms.

3.4.27 (27-Nov-2017)

Resource Rates mode: Fixed error when opening the Download form then the User form.

3.4.26 (27-Nov-2017)

OPM Standard Costing mode: Fixed error in the Download form when using a Category From To.

3.4.25 (24-Nov-2017)

OPM Actual Cost Adjustment mode: Fixed error in the Download form when using the Download Posted GL Adjustments checkbox.

3.4.24 (24-Nov-2017)

OPM Actual Cost Adjustment mode: Fixed errors when downloading using a Category From To.

3.4.23 (24-Nov-2017)

OPM Actual Cost Adjustment mode: Fixed error when using the forms in the wrong responsibility.
Standard Costing mode: Fixed error where DFF's were not updating correctly.
OPM Actual Cost Adjustment mode: Fixed error in the Download form when using the Download Posted GL Adjustments checkbox.

3.4.22 (23-Nov-2017)

Fixed error when downloading using sheet data with multiple lines of criteria.

3.4.21 (21-Nov-2017)

Fixed error as [X] was being left on the sheet when the DFF has not been implemented.
OPM Standard Costing mode: Fixed error with the Download Frozen Costs as was not downloading anything.

3.4.20 (21-Nov-2017)

Standard Costing mode: Fixed error on the Submit Cost Update when entering an Invalid Organization.

3.4.19 (21-Nov-2017)

Standard Costing mode: Fixed error on the Submit Cost Update form when entering an invalid Item Range option.

3.4.18 (21-Nov-2017)

Internal fixes.

3.4.17 (30-Oct-2017)

Fixed error when opening the header form in 64 bit Excel.

3.4.16 (20-Sep-2017)

Internal enhancements.

3.4.15 (30-Aug-2017)

Internal enhancements.

3.4.14 (24-Aug-2017)

Internal enhancements.

3.4.13 (23-Aug-2017)

Fixed error when using the Submitting a Cost Update using a range of items.

3.4.12 (22-Aug-2017)

Added validation to check if Cost Elements exist when attempting to create new ones.

3.4.11 (18-Aug-2017)

Fixed validation error as it was not taking into account the Allow Updates Flag on the Cost Type.

3.4.10 (17-Aug-2017)

Fixed error when doing copy costs when the Cost Rollup column was not on the sheet.
Fixed error when attempting to Create Costs without the Copy Cost columns on the sheet.

3.4.09 (11-Aug-2017)

Fixed DFF error incorrectly saying they are not implemented.

3.4.08 (10-Aug-2017)

Internal enhancements.

3.4.07 (10-Aug-2017)

Internal enhancements.

3.4.06 (07-Aug-2017)

Internal enhancements.

3.4.05 (07-Aug-2017)

Actual Cost Adjustment Mode: Fixed error where the Adjustment Quantity was being set incorrectly to invalid.

3.4.04 (07-Aug-2017)

Internal enhancements.

3.4.03 (04-Aug-2017)

All Modes - fixed error when downloading via sheet with no filters.
Resource Overheads Mode - Made the Resource Overhead Description Label on the form bigger.

3.4.02 (04-Aug-2017)

Resource Overheads Mode - Added validation as you can’t update Overhead Rates for Frozen or Average Cost Types.

3.4.01 (03-Aug-2017)

Resource Overheads Mode - Fixed error where incorrect results were being downloaded into the mode.
Resource Overheads Mode - Made Resource Code Description not mandatory on the sheet.

3.4.00 (03-Aug-2017)

Implemented Resource Overheads mode.

3.3.20 (26-Jul-2017)

Internal enhancements.

3.3.19 (26-Jul-2017)

OPM Standard Costs Mode - Fixed error with the Item LOV as items without User Item Types were not being returned.
OPM Standard Costs Mode - Fixed error when attempting to download via sheet using Usage type as a filter.

3.3.18 (25-Jul-2017)

Internal enhancements.

3.3.17 (14-Jul-2017)

Standard Costing Mode - Fixed error when download via sheet using a Cost Element as a filter.

3.3.16 (12-Jul-2017)

Fixed issue with the Build Data functionality as was duplicating records when it was printing.

3.3.15 (12-Jul-2017)

Internal enhancements.

3.3.14 (11-Jul-2017)

Internal enhancements.

3.3.13 (10-Jul-2017)

Standard Costing Mode - Fixed download issue when having incorrect data in the Based on Rollup Field.

3.3.12 (10-Jul-2017)

Standard Costing Mode - Fixed download issue when having incorrect data in the Based on Rollup Field.
Standard Costing Mode - Fixed upload SQL error when attempting to upload invalid data.

3.3.11 (07-Jul-2017)

Actual Cost Adjustment Mode - Changed name from Average Cost Adjustments to Actual Cost Adjustments as was incorrect.
Actual Cost Adjustment Mode - Added defaulting to the Cost Element UOM to default based on the Item UOM.

3.3.10 (29-Jun-2017)

Fixed download issue when downloading with Last PO Price and Last Invoice Price columns on the sheet.

3.3.09 (28-Jun-2017)

Fixed download error where you couldn’t download in the sheet by '3%'.

3.3.08 (27-Jun-2017)

Standard Costing Mode - Fixed validation SQL error when putting just the item on the sheet and opening the form.

3.3.07 (27-Jun-2017)

Internal enhancements.

3.3.06 (23-Jun-2017)

Fixed issue where dates were being printed incorrectly e.g. DD/MM/YYYY was being printed as MM/DD/YYYY.

3.3.05 (16-Jun-2017)

Average Cost Adjustment mode - Fixed download error as was erroring when downloading with an Item From To.

3.3.04 (14-Jun-2017)

Improved download performance.

3.3.03 (12-Jun-2017)

Internal enhancements.

3.3.02 (08-Jun-2017)

Resource Rates mode - Fixed error where it was incorrectly saying that the Interface ID and group ID columns were required.
Fixed error where the Process Option was changing when logging into the Wizard.

3.3.01 (07-Jun-2017)

Resource Associations mode - Fixed error in the Download form when trying to download using a cost type.

3.3.00 (07-Jun-2017)

Implemented Resource Rates and Resource Assocation modes.

3.2.02 (25-May-2017)

Added custom functionality to the Build Data to only print using the Lowest Level BOM from the Cost Rollup functionality.

3.2.01 (10-May-2017)

Fixed error on the Download form when selecting a Category from the KFF form.

3.2.00 (03-May-2017)

Rolled Version Number up to 3.2.00 for Release.

3.1.67 (01-May-2017)

Fixed error when removing the Item column from the sheet and opening the download form.
Changed message when double clicking on a row that is above row 10.

3.1.66 (27-Apr-2017)

Removed 'All Columns' Option from the new sheet form as is now redundant.

3.1.65 (24-Apr-2017)

Average Cost Adjustment Mode - Updated error message when the GL_Posted_Ind is null to be more user friendly.

3.1.64 (21-Apr-2017)

Average Cost Adjustment Mode - Fixed error with the UOM as some values were not in the LOV.
Average Cost Adjustment Mode - Fixed error with the GL_POSTED_IND check when uploading as was causing rows not to be uploaded. Fixed error with the Item as some items were not being found in the LOV.

3.1.63 (20-Apr-2017)

Average Cost Adjustment Mode - Fixed error with the Download as was not downloading Adjustments correctly.

3.1.62 (11-Apr-2017)

Fixed download error when downloading via interface.
Fixed Download form error when trying to search for a Category.
Enabled OPM Average Cost Adjustments Mode.

3.1.61 (11-Apr-2017)

Added validation for when you are trying to create a cost with no cost elements.
Fixed error so now the UOM field gets populated when the Item is changed.
Fixed error when trying to search for an item when the "Did you mean to search for an item" message appears.
Added validation to make sure the lot size is greater than zero.
Fixed download error with the Download form.

3.1.60 (15-Mar-2017)

Added Plan level download to a customer Cost Rollup customization.

3.1.59 (15-Mar-2017)

Standard Costing Mode - Fixed error with the Item Caching functionality when no data has been returned.

3.1.58 (09-Mar-2017)

Standard Costing Mode - Fixed error with the Item Caching functionality as it was not respecting Default Row 10 Values.

3.1.57 (07-Mar-2017)

Changed Build Organization Data functionality to not include display only fields as could cause inconsistencies in the copied data.
Fixed error where the Header display only columns were not defaulting when doing a Validate Only.

3.1.56 (24-Feb-2017)

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.

3.1.55 (24-Feb-2017)

Standard Costing Mode - Fixed error with the item validation as was setting it incorrectly to invalid.

3.1.54 (22-Feb-2017)

Fixed error with the build data as was duplicating rows when rows in the selected range are blank.

3.1.53 (21-Feb-2017)

Standard Costing Mode - Fixed error with the Item Caching as was not working correctly.

3.1.52 (17-Feb-2017)

Fixed error with customer Cost Rollup customization. Multi segment item were downloading incorrectly.

3.1.51 (16-Feb-2017)

Fixed error with customer Cost Rollup customization. Now displays the button on the ribbon when logging in.
Fixed SQL error with the customer Cost Rollup customization.
Fixed error where rows were being duplicated with the Build Data functionality.

3.1.50 (15-Feb-2017)

Fixed error with customer Cost Rollup customization. Now uses the explode level based on the organization.

3.1.49 (08-Feb-2017)

Standard Costing Mode - Fixed error where duplicate Cost Elements were getting downloaded.

3.1.48 (07-Feb-2017)

Fixed download error with customer Cost Rollup report functionality as the Cost Element results were incorrect.

3.1.47 (07-Feb-2017)

Implemented customer Cost Rollup Report Functionality.
Updated Downloader Modules.

3.1.46 (18-Jan-2017)

Average Cost Adjustment Mode - Fixed caching error when switching between modes.

3.1.45 (17-Jan-2017)

Average Cost Adjustment Mode - Added error message when trying to update an adjustment that doesn’t exist in Oracle.
Fixed error when trying to create a Value Cost or Unit Cost Adjustment.

3.1.44 (22-Dec-2016)

Standard Costing Mode - Fixed error where the Based on Rollup was downloading with 'Y' and 'N'.

3.1.43 (22-Dec-2016)

Standard Costing Mode - Fixed error where the Sub Element column was not being populated for a Cost element of Resource.
Average Cost Adjustment Mode - Made the Cost Element UOM field dependent on the Items UOM Class. Fixed error where display only columns were being validated.

3.1.42 (19-Dec-2016)

Average Cost Adjustment Mode - Moved form control on the Download form to make it more readable.

3.1.41 (14-Dec-2016)

Average Cost Adjustment Mode - Added GL Date From To download criteria to the Download form. Now checks against the GL Posted Index before upload as was causing errors.

3.1.40 (07-Dec-2016)

Standard Costing Mode - Fixed blow up error when the Cost Rollup column was removed from the sheet.

3.1.39 (05-Dec-2016)

Average Cost Adjustment Mode - Reordered 'Current' display only columns to make it easier to read.

3.1.38 (29-Nov-2016)

Average Cost Adjustment Mode - Fixed issue where the Update was not working.

3.1.37 (15-Nov-2016)

Standard Costing Mode - Fixed error where no Costs exist when defaulting the lot size. Fixed the Build data query to be dependent on your Responsibility.

3.1.36 (15-Nov-2016)

Standard Costing Mode - Fixed error where the form was blowing up when 'Cost Rollup' was Yes and the cost type was left blank.

3.1.35 (09-Nov-2016)

Average Cost Adjustment Mode - Fixed download error where UOM was being downloaded into the Item column.

3.1.34 (07-Nov-2016)

Standard Costing Mode - Fixed Upload error with the Cost Rollup Functionality when the Assignment set was not populated.

3.1.33 (07-Nov-2016)

Process Costing Mode - Fixed 'Invalid Username' error when doing an upload.

3.1.32 (04-Nov-2016)

Average Cost Adjustment Mode - Added Item UOM Column. Fixed issue where a Valid cost type was being set to invalid.

3.1.31 (03-Nov-2016)

Standard Costing Mode - Added validation as the Rollup Option is required when the Cost Rollup is 'Yes'.

3.1.30 (03-Nov-2016)

Standard Costing Mode - Added functionality to download via the Based on Rollup Flag when downloading via the sheet. Fixed errors when Cost Rollup functionality when removing 'Assignment Set' and 'Rollup Option' from the sheet.

3.1.29 (02-Nov-2016)

Standard Costing Mode - Fixed Download error when using the Download Form and unticking 'Based on Rollup' and 'Rolled Up'.

3.1.28 (01-Nov-2016)

Standard Costing Mode - Fixed error where dates were being printed as 12:00:00 when no dates existed for an item.
Changed wording of the Submit Concurrent Program when running a Cost Rollup.
Fixed error that would occur when the DFF columns were removed from the sheet.

3.1.27 (31-Oct-2016)

Standard Costing Mode - Added Cost Rollup functionality.

3.1.26 (28-Oct-2016)

Standard Costing Mode - Fixed issue with Build Organization Data functionality where the column was removed from the sheet.

3.1.25 (28-Oct-2016)

Standard Costing Mode - Added Build Organization Data functionality.

3.1.24 (19-Oct-2016)

Standard Costing Mode - Fixed issue where ‘Include in Rollup’ column was not downloading correctly.

3.1.23 (11-Oct-2016)

Average Cost Adjustment Mode - Fixed issue as the DFF's were not set up correctly.

3.1.22 (11-Oct-2016)

Standard Costing Mode - Fixed issue when using the Download form without any of the Read only columns on the sheet.

3.1.21 (05-Oct-2016)

Implemented Average Cost Adjustments mode

3.1.20 (28-Sep-2016)

Standard Costing Mode - Modified the download to improve the download performance.

3.1.19 (20-Sep-2016)

Standard Costing Mode - Modified download SQL to improve the download performance.

3.1.18 (16-Sep-2016)

Standard Costing Mode - Fixed error where the Sub Elements were being set to Invalid when they are valid in Oracle.

3.1.17 (14-Sep-2016)

Standard Costing Mode - Fixed error where the cost elements were being downloaded with incorrect data.

3.1.16 (14-Sep-2016)

Standard Costing Mode - Fixed download error as Costs without any Cost Elements were not being downloaded.

3.1.15 (13-Sep-2016)

Standard Costing Mode - Fixed error where the cost elements were being downloaded with incorrect data.

3.1.14 (13-Sep-2016)

Standard Costing Mode - Fixed download error that was caused when downloading via sheet with more than 50 rows of criteria selected.

3.1.13 (08-Sep-2016)

Standard Costing Mode - Fixed issue with Activity Occurrences and Number Of Items validation as was incorrectly setting these to required.

3.1.12 (05-Sep-2016)

Standard Costing Mode - Fixed SQL error when searching for an item without using the KFF.

3.1.11 (02-Sep-2016)

Standard Costing Mode - Fixed issue where Items without Sub Elements were not downloading when downloading via sheet.

3.1.10 (01-Sep-2016)

Updated Downloader Modules.

3.1.09 (30-Aug-2016)

Standard Costing Mode - Fixed upload issue where the Group ID's were getting incorrectly generated.

3.1.08 (16-Aug-2016)

Standard Costing Mode - Fixed issue when using the 'Based on Rollup' option in the Download form.

3.1.07 (15-Aug-2016)

Standard Costing Mode - Modified Download SQL to improve the download speed.

3.1.06 (05-Aug-2016)

Standard Costing Mode - Modified Download SQL to improve the download speed.

3.1.05 (29-Jul-2016)

Standard Costing Mode - Changed Category Search Controls back to be a KFF on the Download form.
Category KFF on the Download form now changes based on the Category Set LOV.

3.1.04 (26-Jul-2016)

Standard Costing Mode - Fixed error where Downloading by the Cost Element and Sub Element from the sheet was not returning the correct records.
Fixed error 'You cannot Update the Default Cost when Transactions exist for the Item' as was incorrectly checking against the quantities.
Changed Category KFF's on the Download form to be Search Controls.

3.1.03 (23-Jun-2016)

Standard Costing Mode - Added ability to Default the Lot Size with the value from Oracle based on your Organization/Item/Cost Type combination.

3.1.02 (21-Jun-2016)

Standard Costing Mode - Fixed SQL error when using the Aggregate by Sub Element functionality on the Download Form.

3.1.01 (20-Jun-2016)

Standard Costing Mode - Added ability to download by Sub Element on the Download form.

3.1.00 (15-Jun-2016)

Updated Licensing.

3.0.43 (15-Jun-2016)

Fixed error as the Debug Upload LOV was not being populated when opening the Wizard.
Internal Enhancements.

3.0.42 (10-Jun-2016)

Internal Enhancements.

3.0.41 (10-Jun-2016)

Internal Enhancements.

3.0.40 (10-Jun-2016)

Internal Enhancements.

3.0.39 (08-Jun-2016)

Internal Enhancements.

3.0.38 (08-Jun-2016)

Internal Enhancements.

3.0.37 (02-Jun-2016)

Internal Enhancements.

3.0.36 (31-May-2016)

Package Versions changed.
Internal Enhancements.

3.0.35 (30-May-2016)

Internal Enhancements.

3.0.34 (23-May-2016)

Updated Licensing.

3.0.33 (18-May-2016)

Changed the way header only update results are printed as could print incorrect.
Fixed error where Rolled up Costs were not being removed when updating the based on rollup flag from Yes to No.

3.0.32 (17-May-2016)

Internal Enhancements.

3.0.31 (12-May-2016)

Fixed error with refresh as would only refresh 100 rows at a time.
Fixed error where the status column was being validated and asking for a value to be inserted into it.

3.0.30 (10-May-2016)

Fixed issue when doing a Copy Cost Request as the upload results were being printed above row 9.

3.0.29 (15-Jun-2016)

Internal Enhancements.

3.0.28 (06-May-2016)

Fixed SQL error when uploading.
Fixed SQL error when attempting a download using only an item.

3.0.27 (02-May-2016)

Made the Based ON Rollup column not required.

3.0.26 (15-Jun-2016)

Modified Cost Type LOV to handle more than 1000 Cost Types.
Fixed validation when performing a Copy Cost request as it was checking against the Default Cost Type and Quantity on Hand.

3.0.25 (22-Apr-2016)

Internal Enhancements.

3.0.24 (18-Apr-2016)

Modified Inventory Organization Code LOV to handle more than 1000 organizations.

3.0.23 (14-Apr-2016)

Fixed problems when trying to log in after stopping the download.

3.0.22 (13-Apr-2016)

Improved Download performance.

3.0.21 (12-Apr-2016)

Fixed problems when trying to log in after stopping the download.
Added fix to the Ribbon as errors would occur after stopping the download.

3.0.20 (08-Apr-2016)

Updated Licensing.

3.0.19 (23-Mar-2016)

Added validation to the Item Column so we are now checking against the Default Cost Type and Quantity on Hand.
Changed processing form messages to reflect a running total on the number of Costs Uploaded/Errored.

3.0.18 (16-Mar-2016)

Changed Validation when completed a Header Only Update to print the errors onto the sheet.
Changed the Refresh so that is doesn’t refresh rows that have been errored due to validation.

3.0.17 (07-Mar-2016)

Changed Cost Type LOV as this was bringing back incorrect values.

3.0.16 (04-Mar-2016)

Updated Licensing.

3.0.15 (15-Feb-2016)

Fixed Item LOV as no results were being returned.
Improved error handling when trying to create header only costs.

3.0.14 (26-Jan-2015)

Fixed bug as the Based on Rollup flag wasn't being uploaded.

3.0.13 (07-Jan-2016)

Fixed bug in the download to include Rate or Amount as this was not being populated on the sheet.

3.0.12 (22-Dec-2015)

Updated Licensing.

3.0.11 (21-Dec-2015)

Modified Cost Type LOV as the list of values returned was incorrect.

3.0.10 (07-Dec-2015)

Added Trial License validation.

3.0.09 (03-Dec-2015)

Made the Category dependent on the Category Set LOV in the Download form.

3.0.08 (02-Dec-2015)

Modified Download SQL to not look at the default category set as this returned an incorrect number of values.

3.0.07 (18-Nov-2015)

Fixed Upload error when generating Group IDs.

3.0.06 (17-Nov-2015)

Fixed Upload error when generating Group IDs.

3.0.05 (12-Nov-2015)

Modified the Refresh to print accurate status messages.
Updated the message that is displayed when you have duplicate cost elements in the interface table.

3.0.04 (11-Nov-2015)

Removed Redundant Profile Option as this was not used in the Wizard.

3.0.03 (02-Nov-2015)

Fixed error with the delete when the Cost Elements section was removed from the sheet.
Fixed bug in the download to include based on rollup as this was not being populated on the sheet.

3.0.02 (23-Oct-2015)

Updated Licensing.

3.0.01 (15-Oct-2015)

Added Download Wizard functionality.

3.0.00 (23-Sep-2015)

Added Description Defaulting to the Submit Update form
Added Invoice Currency Code, Invoice Exchange Rate and Invoice Price per unit columns
Added Normalize and Denormalize data functionality
Changed copy item function to not use concurrent program. Now have profile option More4Apps: ICW Allow Direct Item Cost Copy Without Concurrent Program to enable this functionality, otherwise it resorts to the old way
Added in last PO price and last invoice actual cost columns
Added PO creation date column
Added in last PO approval date column
Added Last Receipt PO and Date, Last Invoice Number and Date columns
Changed the way group id is generated, to be based on cost type only, not cost type and organization combination

1.5.20 (08-Oct-2013)

Fixed behaviour of mode/process drop-downs on Item Cost Wizard ribbon/menu which were not updating correctly when changed

1.5.19 (01-Oct-2013)

Fixed issue with chunking using up 32k causing Excel to error
Fixed issue with the item cost form erroring when adding a new item via the form
Changed code to check for duplicates to reset after each chunk
Fixed bug where Wizard expected lot size
Added validation to check lot size is >0 in the Wizard
Rebuild refresh process to improve performance
Added check in validation to make sure item asset flag is Yes

1.5.18 (19-Sep-2013)

Changed Wizard to get chunks of data at 1000 records per chunk
Removed conditional formatting, causing Excel to crash

1.5.17 (18-Sep-2013)

Changed Wizard download from interface to not include last PO or invoice checks to improve performance

1.5.16 (28-Aug-2013)

Changed Wizard to cache items pre-upload.  Caching also added to check if subelements are in interface table

1.5.15 (28-Aug-2013)

Fixed large download bug when hitting maximum value of long variable
Improved performance on uploads
Fixed based on rollup flag not setting correctly

1.5.14 (26-Aug-2013)

Improved performance on uploads
Fixed bug where basis wasn’t being validated

1.5.13 (13-Aug-2013)

Add line numbers and error trapping to ribbon modules to help fix issues

1.5.12 (08-Aug-2013)

Changed downloader to download in chunks of items to stop Excel running out of memory

1.5.11 (25-Jul-2013)

Changed submit cost update to include additional parameter number 35 which exists on some r12 instances

1.5.10 (25-Jul-2013)

Updated common Modules

1.5.9 (03-Apr-2013)

Added extra caching to improve item validation speed
Fixed bug in Copy Costs form where Wizard crashes if the organization code is blank
Fixed bug in Elements form where moving to a blank row 10 caused the item details to automatically populate from previous line

1.5.8 (18-Mar-2013)

Added in functionality to only download items within a PO

1.5.7 (06-Mar-2013)

Updated get item code to improve item validation time

1.5.6 (28-Jan-2013)

Changed downloader to download in element, sub-element order
Reapplied fixed issue with uploader marking last record too early causes duplicate costs

1.5.5 (24-Jan-2013)

Added support for Material Sub Element DFF context

1.5.4 (22-Jan-2013)

Imported the latest ribbon code implementing the new ribbon tab names etc

1.5.3 (16-Jan-2013)

Added support to Standard Cost updates for cost types within Average Costing Organizations
Updated common modules

1.5.2 (16-Nov-2012)

Fixed bug with validate item in form not checking if copying cost
Changed messaging for copy cost to Accepted and included the load in the loaded counter

1.5.1 (16-Nov-2012)

Added logged in check to delete from interface table

1.5.0 (26-Oct-2012)

Changed the way the upload and update works to only build extra elements at the end of the load to stop duplicate rows being loaded

1.4.04 (26-Oct-2012)

Fixed issue where changing upload option not working
Added in check to make sure User has rights to import costs
Added feature to restrict records the User can delete to their own when doing a delete all

1.4.03 (10-Sep-2012)

Ribbons implemented
Fixed issue where Upload All not doing pre-load check
Fixed issue where Wizard uploaded records when errored

1.4.02 (06-Sep-2012)

Fixed bug in copy costs failing when copy cost column missing
Updated generic modules due to 64bit copy row issue
Updated downloader to stop skipping rows, this is a change to new downloader module with new property for last row inserted

1.4.01 (21-Aug-2012)

Fixed bug in copy costs erroring when copy collection variable is not set
Fixed bug with download treating some number columns as dates

1.4.00 (21-Aug-2012)

Added support for copy costs within an organization concurrent program

1.3.07 (21-Mar-2012)

Improved process to default the correct cost type when submitting import

1.3.06 (12-Mar-2012)

Changed message to Inserting into interface when validation completed
Fixed bug when first trying to load a record causing no load to occur
Updated common module
Added Cancel button functionality to the Wizard

1.3.05 (12-Mar-2012)

Changed refresh to load all lines into a collection before validating

1.3.04 (29-Feb-2012)

Fixed issues with interface downloader not working
Changed refresh to ignore errored/validated lines and only look at all other lines where there is an interface ID

1.3.03 (28-Feb-2012)

Fixed issues with downloader not working
Improved design to generate multiple group ID’s if multiple orgs/cost types loaded at the same time

1.3.02 (11-Jan-2012)

Fixed download issues found in testing
Changed Wizard to allow duplicate sub element/activity to load only if value is not duplicated

1.3.01 (11-Jan-2012)

Updated Wizard element to check if Occurrences/item units on the form

1.3.00 (11-Jan-2012)

Changed Wizard to be object based
Added support for activity Occurrences and item units
Changed refresh to verify loaded cost is the same as the Wizards cost

1.2.15 (16-Dec-2011)

Added defaulted flag to Item Cost header

1.2.14 (14-Dec-2011)

Fixed multiselect downloads overriding each other for multiple orgs
Fixed single org loads not downloading due to multiselect change
Found bug when in create mode it checks material cost only rather that total item cost value

1.2.13 (09-Dec-2011)

Added in multi-select function on the download current costs form

1.2.12 (30-Nov-2011)

Added new Concurrent request query for performance issue

1.2.11 (17-Oct-2011)

Added in refresh to allow for error status 4 in the interface table

1.2.10 (05-Sep-2011)

Changed downloader to use MTL_SYSTEM_ITEMS_B_KFV instead of MTL_SYSTEM_ITEMS_KFV for R12

1.2.9 (05-Sep-2011)

Added in check to make sure the same sub element is not being loaded within an item

1.2.8 (19-Aug-2011)

Updated common modules
Fixed Object Runtime Issue with the Header form

1.2.7 (11-Feb-2011)

Fixed validate item bug not loading based on rollup = No value, only ‘N’ value
Fixed item form not validating item exists on opening

1.2.6 (11-Feb-2011)

Allowed update of frozen costs for items where on hand quantity = 0

1.2.5 (11-Feb-2011)

Changed download sql in statement on the elements not to use a distinct subquery on parent download as this was slowing down the query
Removed references to category set/categories in element download if they are not part of the selection criteria
Fixed defaulting bug in download category to defaulting to the category from rather than the users default value

1.2.4 (04-Feb-2011)

Changed last po price and last inv price download sql to reference back to the header rather than to just the cost type
Fixed LOV on download organization to validate it is a valid organization
Fixed item cost details download sql to join back on organization and item_id

1.2.3 (02-Feb-2011)

Re-imported Generic modules
Added in download from spreadsheet functionality
Changed toolbar LOV options order the same as BOM and Item wizards

1.2.2 (24-Jan-2011)

Added DFF functionality to the wizard

1.2.1 (14-Jan-2011)

Made a change to the submit import program to disable the submit button if the cost type field is blank

1.2.0 (09-Oct-2010)

Changed wizard to accumulate SQL before loading it and to reduce database SGA load. Requires version 1.2.0 of the package body to work.

1.1.16 (14-Jun-2010)

Updated common modules with other MFG wizards
Fixed bug in Download form when you delete the item it handled error
Fixed bug where hide messages not working
Fixed set_status not clearing error message column when record valid/inserted
Fixed issue with submit cost update not returning organization properly
Fixed toolbar issue with insert template missing
Changed tool bar options to be more user friendly for upload types and validate vs validate commit
Fixed issues with set status not working for update mode

1.1.15 (24-May-2010)

Changed mfg_lookups_v to fnd_lookup_values_vl for 11.5.9 support.

1.1.14 (24-May-2010)

Added support for uploading using european decimal point
Fixed ambiguity were you can chose INSERT mode and then UPDATE cost

1.1.13 (10-May-2010)

Fixed bug where bind variable was next to a bracket causing Java IN OUT error
Changed get_item_cost_info to return qty/po and inv prices even if the cost type for the item isn’t setup

1.1.12 (27-Apr-2010)

Fixed bug in Item Costs form where shrinkage not defaulting to 0 and lot size not defaulting to 1

1.1.11 (25-Mar-2010)

Added functionality to delete updated records without having to download the records first.
Changed check for current load status to only take Interfaced and Accepted items into account.

1.1.10 (18-Mar-2010)

Toolbar/RC Menu improvements

1.1.9 (17-Mar-2010)

Fixed but where create turns into update.
Fixed return message for update not showing correctly
Fixed delete all transactions pressing no option deleted

1.1.8 (05-Mar-2010)

Added functionality to update current costs keeping existing costs not being updated there. By adding to interface

1.1.7 (09-Feb-2010)

Changed design to validate all records before allowing any insert of costs

1.1.6 (09-Feb-2010)

Changed MSTK KFF to look at costing enabled flag instead of invoice enabled
Updated MSTK KFF not to look at master org, using child org instead

1.1.5 (05-Feb-2010)

Added in check boxes to select the download type
Added element source type field to the wizard
Removed requirement that cost must not be zero
Fixed Issue where new item level record erroring when there is no item on that record

1.1.4 (30-Jan-2010)

Fixed download basis type bug with mfg_lookups (affecting 11.5.9)

1.1.3 (25-Jan-2010)

Fixed Bug where material overhead didn’t allow all 6 basis types.

1.1.2 (25-Jan-2010)

Fixed Bug in shrinkage where test of value using clng causing anything over .5 to round up to 1
Changed Delete functionality so if you press delete for an item then all subelements for that item are deleted
Changed Item level validation to return the correct error message when there is a validation fault rather than just Erroring without a reason.
Item Cost form wasn’t defaulting based on rollup to what was on the spreadsheet.

1.1.1 (25-Jan-2010)

Fixed Gensupport SetStatus not working correctly
Fixed default activity passing value instead of ID
Changed refresh of costs updated to excl the cost value as that would only work for single element cost changes
Fixed bug in based on rollup not using shrinkage when it is based on rollup

1.1.0 (05-Jan-2010)

Changed upload to only upload records when they have passed validation
Upgraded CstSupport, InvSupport to be object based rather than record based
Fixed bug where activity not erroring when activity isn’t found
Fixed issue with download not downloading DFF’s correctly

1.0.4 (19-Dec-2009)

Updated KFF and DFF modules
Fixed bug in validate header values populating current row not header row

1.0.3 (05-Dec-2009)

Created form to choose request to run
Added view requests form
Updated common modules

1.0.2 (22-Oct-2009)

Ignored records not being reset
Refresh not taking rows below the header into account causing it not to validate against the org/item/cost type
Fixed activities not loading for sub element
Added check of concurrent request against refresh functionality
Added limit of 10 decimal places to loads due to size inconsistency between oracle and excel

1.0.1 (24-Sep-2009)

Updated import to delete from interface table if Import is successful.
Added in sum by sub element when downloading costs

1.0.0 (02-Sep-2009)

Initial versionDelete function wasn’t deleting errored rows
Basis field error incorrectly going to subelement field
Created form to submit cost update if user has functional access