2.5.53 (24-Apr-2025)

Internal bug fix.

2.5.53 (24-Apr-2024)

Internal bug fix.

2.5.52 (08-Apr-2025)

Fixed the download sql error when using Transaction Type as download filter in the OnHand Quantity download source.

2.5.51 (08-Apr-2025)

Resolved the issue where the error message appeared stating 'Lot Quantity must be numeric' when the field was left blank.

2.5.50 (07-Apr-2025)

Turn off the Logging.

2.5.49 (07-Apr-2025)

Internal update.

2.5.48 (21-Mar-2025)

Fixed the multi segment Locator with false delimeter issues in OnHand quantity.

2.5.47 (20-Mar-2025)

Internal update.

2.5.46 (20-Mar-2025)

Default Browser Login - Fixed bug where the browser would not navigate away from the homepage. This stopped the login process from completing.
Enhanced the Wizard - It will now function using the right-click-menu, without the More4apps ribbon tabs.

2.5.45 (03-Dec-2024)

Fixed the issue of Quantity must be numeric when Quantity is blank.

2.5.44 (23-Oct-2024)

Fixed the issue of Quantity must be numeric when quantity is blank.

2.5.43 (17-Oct-2024)

Added Default Browser Login option.

2.5.42 (15-May-2024)

Fixed the issues of Transaction Line DFF Attributes 11 through to 15.

2.5.41 (03-May-2024)

Fixed the type mismatch issue when adding characters to Quantity.

2.5.40 (11-Apr-2024)

Fixed the Update color issues.

2.5.39 (28-Nov-2023)

Internal update.

2.5.38 (28-Nov-2023)

Fixed Locator Project Validation performance issue. This issue could be identified by the Excel Status bar displaying the message 'Getting project information' for a long time.

2.5.37 (28-Nov-2023)

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

2.5.36 (11-Oct-2023)

Added new digital signature.

2.5.35 (11-Oct-2023)

Fix the build issues.

2.5.34 (02-May-2023)

Internal update.

2.5.33 (27-Mar-2023)

Updated the security checking for Subinventory function required.

2.5.32 (16-Mar-2023)

Internal update.

2.5.31 (08-Feb-2023)

Fixed the security violation error due to the 'APPS.' in the code.

2.5.30 (24-Jan-2023)

Internal update.

2.5.29 (18-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.5.28 (28-Sep-2022)

Internal update.

2.5.27 (19-Sep-2022)

Updated Licencing Modules.

2.5.26 (31-Aug-2022)

Fixed the error message issue while managing templating without Admin permission.

2.5.25 (22-Apr-2022)

Fixed the Download ribbon message.

2.5.24 (22-Apr-2022)

Fixed spelling issue on the ribbon.

2.5.23 (21-Apr-2022)

Fixed spelling error on the ribbon.

2.5.22 (11-Apr-2022)

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

2.5.21 (04-Mar-2022)

Internal update.

2.5.20 (14-Jan-2022)

Custom Query SQL Injection update.

2.5.19 (06-Jan-2022)

Fixed issue with Stock Locator KFF setting that contains special characters within only one segment.

2.5.18 (15-Nov-2021)

Fixed issue with Average Cost Download using categories and not returning any data.

2.5.17 (23-Jun-2021)

Fixed forms opening with status bar hidden in Excel 2016.

2.5.16 (16-Jun-2021)

Fixed Locator validation erroring with segments that have underscores.

2.5.15 (19-Apr-2021)

Updated security.

2.5.14 (06-Apr-2021)

Updated security.

2.5.13 (17-Nov-2020)

Fixed literal string error when validating Transaction Date.

2.5.12 (05-Oct-2020)

Fixed error when validating Locator To column.

2.5.11 (02-Oct-2020)

Updated security.

2.5.10 (23-Sep-2020)

Fixed Expenditure Type always required.

2.5.09 (23-Sep-2020)

Corrected Expenditure Type validation.

2.5.08 (23-Sep-2020)

Fixed Expenditure Type being required while profile set to "System derived from cost elements".

2.5.07 (23-Sep-2020)

Fixed Project upload for Account Transaction type.

2.5.06 (20-Sep-2020)

Fixed Locator to being required for Project Organizations.

2.5.05 (06-Jul-2020)

Fixed validation SQL error with invalid dependencies.

2.5.04 (01-Jul-2020)

Updated security.

2.5.03 (29-Jun-2020)

Updated Example Sheets.

2.5.02 (25-Jun-2020)

Fixed upload continuing with an invalid Transaction Type.

2.5.01 (24-Jun-2020)

Fixed several columns erroring when header data is invalid.

2.5.00 (08-Jun-2020)

Updated Wizard with new brand colors.

2.4.10 (14-May-2020)

Fixed error when downloading Onhand Quantity.

2.4.09 (09-Apr-2020)

Fixed Locator To Project segments not resolving to IDs during Subinventory Transfer Transactions.

2.4.08 (09-Mar-2020)

Updated WIP Requirements form download when using Locator.

2.4.07 (09-Mar-2020)

Corrected WIP requirements downloads when using Locator as filter.

2.4.06 (06-Mar-2020)

Added Wip job to Transaction History download.
Fixed Subinventory Transfer Locator validation for a Project Organization.

2.4.05 (19-Feb-2020)

Fixed Link error when loading workbook.
Fixed Wip Job Requirements wipjob filter not working correctly.

2.4.04 (19-Feb-2020)

Extended Item LOV drop down, replaced inventory item ID with Description.

2.4.03 (06-Jan-2020)

Updated security.

2.4.02 (11-Dec-2019)

Fixed Lot section not downloading.

2.4.01 (09-Dec-2019)

Fixed various message translation issues.

2.4.00 (29-Nov-2019)

Firewall compliant encoding added.

2.3.12 (07-Nov-2019)

Updated security.

2.3.11 (25-Oct-2019)

Fixed error when downloading multiple Average Cost rows with Cost group as a filter.

2.3.10 (04-Sep-2019)

Updated security.

2.3.09 (02-Jul-2019)

Updated security.

2.3.08 (27-Jun-2019)

Fixed issue where validation would error without a message with Payback Date set correctly in the future.

2.3.07 (26-Jun-2019)

Corrected invalid functionality around Project transfer/borrow/payback.
Fixed validation errors when removing (or invalid length) columns used for extension package validation.

2.3.06 (30-May-2019)

Fixed new sheets not importing More4apps logo.

2.3.05 (21-May-2019)

Updated with new brand colors.
Fixed error when selecting an item with invalid header information.

2.3.04 (15-May-2019)

Internal udpate.

2.3.03 (13-May-2019)

Updated security.

2.3.02 (26-Mar-2019)

Fixed error when downloading Average Cost CostGroup via sheet.

2.3.01 (08-Feb-2019)

Fixed Subinventory LPN error.

2.3.00 (29-Jan-2019)

Versioned for Website release.

2.2.83 (29-Jan-2019)

Fixed bug when double-clicking Load Template from Edit By Sheet
Fixed Current Average Cost Element issue with European decimal standard.
Fix for Average Cost VBA error when uploading multiple items against the same header.

2.2.82 (25-Jan-2019)

Fixed VBA error occurring in Average Costing.

2.2.81 (25-Jan-2019)

Corrected Inventory Org label on Header form.

2.2.80 (24-Jan-2019)

Improved Lot Number validation speed.

2.2.79 (21-Jan-2019)

Updated Wizard package Information version (was missing a version for each header/body).

2.2.78 (17-Jan-2019)

Fixed Interface Download SQL error when Inter-org data exists.

2.2.77 (16-Jan-2019)

Fixed SQL errors when downloading from interface.

2.2.76 (16-Jan-2019)

Made Adjustment Account required when Average cost Transaction Type.
Fixed validation error when Average costing with costing data in both line and element sections.

2.2.75 (15-Jan-2019)

Fixed uploads returning ID's when invalid data exists.

2.2.74 (14-Jan-2019)

Added dropdown functionality for Assembly on Bill Of Material Download form.
Fixed Lot Serials being duplicated.
Fixed Average Cost Download only downloading Org default Cost group.

2.2.73 (10-Jan-2019)

Fixed duplicate results in Average Cost Element Download.
Average Cost Download no longer returns UOM.
Fixed European Decimal issue with Average Cost columns.

2.2.72 (09-Jan-2019)

Fixed SQL error when selecting a Locator KFF combination before validating.
Fixed download issue with Material History Download.

2.2.71 (21-Dec-2018)

Fixed Subinventory Transfer downloading into Inventory Org Code To column.

2.2.70 (21-Dec-2018)

Fixed Download from sheet using Average Cost.
Now only return WIP Jobs with Released or Completed Statuses.
Locator To SQL Error corrected.

2.2.69 (18-Dec-2018)

Added drop down to Item for Average Cost Download Form.
Increased Average Cost Download Speed when not specifying an Item.

2.2.68 (17-Dec-2018)

Fixed minor confusion with Locator KFF form.
Fixed VBA error when switching between Account Alias and Account Transaction Types from sheet.

2.2.67 (14-Dec-2018)

Corrected Lot Expiration Date error when Blank values.

2.2.66 (13-Dec-2018)

Fixed SQL error when entering LPN information.

2.2.65 (11-Dec-2018)

Removed Organization dependency for serial number LOV (both receipt/issue, serial/lot serial).

2.2.64 (05-Dec-2018)

Fixed more search control errors in download forms.
Fixed issue with validating Locator column without associated Inventory Org column.

2.2.63 (04-Dec-2018)

Fixed search control with download forms.

2.2.62 (03-Dec-2018)

Now error Headers that do not have transaction information (Transaction Lines section).

2.2.61 (27-Nov-2018)

Made Bill of Material download fields not required.
Fixed WIP download SQL error.

2.2.60 (26-Nov-2018)

Disabled Lot Origination Date defaulting.

2.2.59 (22-Nov-2018)

Updated icon for Query Login ribbon.

2.2.58 (22-Nov-2018)

Removed account filter for Download from Sheet and Download Form.
Fixed Support/Help ribbon tab name bug.

2.2.57 (21-Nov-2018)

Fixed download error with Material Transaction History when Final Completion column present.

2.2.56 (14-Nov-2018)

Added SQL Logging button and Help button.

2.2.55 (16-Oct-2018)

Updated security.

2.2.54 (15-Oct-2018)

Fixed error in Average Costing without an Organization selected.

2.2.53 (28-Sep-2018)

Fixed error in Lot Validation when a Lot didn’t exist under the specified Organization.

2.2.52 (21-Aug-2018)

Temporarily removed Lot Maturity Date as implementation is currently incorrect.
Removed Time stamp from Lot date columns (expiration/origination).
Only download Final Completion if Wipjob Transaction Type.

2.2.51 (17-Aug-2018)

Error Lot Expiration/Origination Date if using an existing lot and not the respective date set against the lot.

2.2.50 (16-Aug-2018)

Fixed Lot Expiration Date warning for valid dates.
Fixed Lot Status not being returned after upload (Pending).

2.2.49 (14-Aug-2018)

Removed Lot Origination Date Org Type restriction (was OPM only, now R12 only).
Corrected Lot divisible validation causing Lot Quantity to be 0.

2.2.48 (13-Aug-2018)

Fixed error with validate Quantity.

2.2.47 (10-Aug-2018)

Fixed VBA error with Locator To Validation.
Fixed Parent Lot Number being required during Wizard setup.
Fixed Intransit Shipments Subinventory to always being required.
Improved various Locator validation queries.

2.2.46 (01-Aug-2018)

No longer warn Quantity will drive negative if receipt transaction.

2.2.45 (26-Jul-2018)

Modified way we check for Process Manufacturing type org.

2.2.44 (20-Jul-2018)

Fixed VBA errors with Lot Date validation.
Don’t default Lot Origination Date if issue or existing Lot.
Modified Process Manufacturing message to identify column.
Fixed Lot Issue transactions allowing invalid values.

2.2.43 (20-Jul-2018)

Moved Parent Lot Number down one column order.

2.2.42 (20-Jul-2018)

Added Lot Columns: Parent Lot Number, Lot Grade Code, Lot Origination Date.
Fixed rounding issue with Lot Secondary Qty.
Sped up lot date validation by a lot.

2.2.41 (16-Jul-2018)

Fixed issue when removing lot secondary Qty column.
Fixed issue with lot divisible flag items with Receipt Transaction Type.

2.2.40 (16-Jul-2018)

Fixed the issue where users were not allowed to login if the Oracle Servlet Ping was unsuccessful.

2.2.39 (10-Jul-2018)

Fixed DFF Download not showing converted Dates.
Fixed Download Selected bug.

2.2.38 (06-Jul-2018)

Fixed Lot/Serial DFF column type errors.

2.2.37 (26-Jun-2018)

Corrected validation for Issuing Lot Numbers that have no quantity.
Fixed Lot validation looking at wrong divisible Flag.

2.2.36 (08-Jun-2018)

Fixed issues with Lot and Serial DFF uploads.

2.2.35 (07-Jun-2018)

Fixed issue with secondary UOM functionality.

2.2.34 (05-Jun-2018)

Fixed issues with Secondary UOM/Quantity functionality.
Fixed Locator issue where Locator Control of Not Specified is required.

2.2.33 (21-May-2018)

Corrected issue with Org level Locators not being controlled correctly.

2.2.32 (10-May-2018)

Fixed error when selecting a Locator To (Locator to never valid).

2.2.31 (02-May-2018)

Added debug logging and help menu to ribbon.

2.2.30 (05-Apr-2018)

Fixed error when returning Header error with characters greater than 240.

2.2.29 (04-Apr-2018)

Fixed error when removing Inventory Org Code To Column during Interorg Transfers.

2.2.28 (19-Mar-2018)

Account no longer required for Inter Org Transactions.

2.2.27 (16-Mar-2018)

Fixed incorrect date check when Transaction Date Profile is set to Warn or no past periods.

2.2.26 (13-Feb-2018)

Updated Custom Query messages.

2.2.25 (13-Feb-2018)

Updated Downloader to Custom Query.

2.2.24 (02-Feb-2018)

Corrected Header Default Account not defaulting to Line section.

2.2.23 (30-Jan-2018)

Modified Locator function usage to be backwards functional.

2.2.22 (25-Jan-2018)

Fixed BOM download form error, Fixed On Hand Quantity Locator LOV returning invalid results.

2.2.21 (24-Jan-2018)

Corrected issue with Locator validation with project segments.

2.2.20 (12-Jan-2018)

Fixed issue with On Hand Quantity not returning Lot/Serial data.

2.2.19 (11-Jan-2018)

Fixed Revision becoming required for AVG Cost Transaction Types.

2.2.18 (27-Dec-2017)

Fixed error when entering Revisions when using an Average Cost Transaction Type.

2.2.17 (22-Dec-2017)

Fixed On Hand Quantity Lot download.

2.2.16 (11-Dec-2017)

Fixed Download sheet inconsistencies for AVG Cost and On Hand Quantity - Removed Category download filter - use Functional area default.

2.2.15 (08-Dec-2017)

Fixed SQL errors when including Category for download from sheet for AVG Cost and On Hand Quantity downloads.

2.2.14 (07-Dec-2017)

Ensure Inventory Org required error is pushed through processing form.

2.2.13 (04-Dec-2017)

Fixed SQL error trying to download without a selected Inventory Org.

2.2.12 (04-Dec-2017)

Added AVG Cost only columns: Last PO Price, Last Invoice Price, Last PO Number, Last Invoice Number.
Enabled Download from sheet functionality for AVG cost. Uses costing functional area default category set.

2.2.11 (05-Oct-2017)

Handled error in On Hand Quantity Download when no org specified.

2.2.10 (28-Sep-2017)

Added Download via Sheet functionality for Quantity on Hand.

2.2.09 (20-Sep-2017)

Waybill is no longer a numeric column.

2.2.08 (13-Sep-2017)

Fixed issue with Locator loading into Project Segments whether enabled or not.

2.2.07 (31-Aug-2017)

Fixed issue for user with more than 1000 Expenditure Organizations.

2.2.06 (17-Aug-2017)

Allowed Unit Cost validation/Upload for LIFO/FIFO organizations (when receipting).

2.2.05 (14-Aug-2017)

Security updated.

2.2.04 (11-Aug-2017)

Fixed issue where Line DFFs would not be uploaded.

2.2.03 (28-Jul-2017)

Fixed issue where Secondary UOM would invalidate some UOMs.

2.2.02 (25-Jul-2017)

Fixed issue where UOM would invalidate some UOMs.

2.2.01 (17-Jul-2017)

Fixed issue in 12.2.6 environments with Lot Date incorrectly defaulting despite item expiration control being disabled.

2.2.00 (10-Jul-2017)

Versioned for Website release.

2.1.95 (07-Jul-2017)

Fixed inconsistent error occurring in large uploads.

2.1.94 (07-Jul-2017)

Fixed sporadic issue with missing Default Account column.

2.1.93 (06-Jul-2017)

Fixed Delete not working as intended. Now deletes all Lines/Lots/Serials associated with selected header.
Fixed sporadic issue with missing Default Account column.
Added updated Setup sheet.

2.1.92 (03-Jul-2017)

Updated security.

2.1.91 (03-Jul-2017)

Removed some columns from upload validation to speed it up.
Fixed Subinventory not populating after selecting an Item.

2.1.90 (30-Jun-2017)

Fixed Upload issue "the Source Task Information is invalid".

2.1.89 (12-Jun-2017)

Fixed issue where user can upload AVG cost updates despite error messages.
Fixed issue with user entering non numeric numbers into QuantityOnHand column during AVG Costing.

2.1.88 (12-Jun-2017)

Fixed memory issue when bulk uploading data with 32bit database.

2.1.87 (02-Jun-2017)

Fixed Transaction Date server error when invalid date.
Fixed issue when trying to Search/Validate Item in form.
Fixed issue validating invalid Item in form.

2.1.86 (02-Jun-2017)

Fixed error when uploading lot with no Serial Lot section.
Fixed issue with operation Sequence Number causing error during upload.

2.1.85 (02-Jun-2017)

Fixed issue where Serial Lot status were not getting updated on Interface refresh.

2.1.84 (31-May-2017)

Tried to fix issue with big uploads getting memory error.
Hugely increased validation speeds.
Fixed issue during AVGcost Upload: lines not uploading.
Fixed issue where locator would always appear required after encountering a column that was actually required.

2.1.83 (16-May-2017)

Fixed error with Locator validation in LPN transactions.
Sped up Quantity validation.
Locator validation improved during LPN.
Fixed Locator validation always being valid and fixed error.
Fixed Locator validation for project organizations.

2.1.82 (09-May-2017)

Fix for 64Bit Excel when saving/code error causes catastrophic crash.

2.1.81 (08-May-2017)

Fixed error in upload when LPN and UOM columns are removed.
Fixed Download form Supply type not affecting Downloaded Results.
Fixed error introduced in 2.1.80 with Locator validation.
Fixed error when Account column removed.

2.1.80 (05-May-2017)

Fixed errors where certain columns were removed.
Fixed error encountered when attempting upload without a TransactionType.
Defaulting now handled more accurately.

2.1.79 (04-May-2017)

Fixed NextVal error in 10g databases.
Fixed numerous errors occurring on 64Bit versions of Excel.

2.1.78 (28-Apr-2017)

Fixed issue with Locator Project segments that don't have an ID.
Fixed On Hand Quantity Download when using categories.

2.1.77 (21-Apr-2017)

Fixed error when trying to use Example sheets.
Fixed error with "Error in other section" during Project Organization locator validation.
Fixed Upload error when UOM is not present on sheet (valid for AVG cost update).
Fixed Lines form erroring when using Avg Costing (SubInvCache error).
Fixed Transaction Type errors not sticking to controls on forms.
Re-enabled Header uploads with errored lines.
Fix for Lot/Serial Section validation during Average Costing.
Fixed Avg Cost upload for invalid Account Error.
Fixed error for invalid Upload AVG cost.

2.1.76 (12-Apr-2017)

Fixed Lot upload allowing Quantity without a Lot Number.

2.1.75 (11-Apr-2017)

Fixed First Account Segment erroring during KFF validation.
Fixed error when uploading with invalid Transaction Type.
Fixed Lot Quantity being required in all records.
Fixed error with invalid Transaction Dates.
Fixed errors when transferring Wizard from Windows 10 from 7 and vice versa.

2.1.74 (05-Apr-2017)

Fixed error when attempting upload with invalid Item.

2.1.73 (04-Apr-2017)

Fix for Windows 2010 - Windows 7 issues encountered between Functional/Development.

2.1.72 (30-Mar-2017)

Updated Security.

2.1.71 (29-Mar-2017)

Fixed issue with Transfer Organization in closed date periods.
Added Error management for Unexpected Errors during Upload "Unexpected Error in unknown Row. xxx Please save worksheet and send to More4Apps”.

2.1.70 (28-Mar-2017)

Fixed error in On Hand Quantity/Average Cost Download form when Lot/Serial sections missing.

2.1.69 (24-Mar-2017)

Fixed critical VBA error occurring during download attempt.
Fixed error when attempting Quantity On Hand Download with Include Costs checkbox ticked.

2.1.68 (23-Mar-2017)

Added Default Transaction Types/Account to Quantity on Hand Download form.

2.1.67 (13-Mar-2017)

If UOM is blank or missing, use selected item's primary UOM instead.

2.1.66 (08-Mar-2017)

Fixed error when uploading with Lot/Serial sections missing.

2.1.65 (24-Feb-2017)

Fixed AVG cost Accounts being overwritten with new default values.
Fixed Header form not updating when selecting new Transaction Type.

2.1.64 (23-Feb-2017)

Fixed issue with Uploading using multiple Organizations.
Changed upload to not fail upload if any Control codes/quantity errors occur.
Fixed error when Validating Locator To with no Inventory Org To Column.

2.1.63 (14-Feb-2017)

Fixed error when searching with Task Number field.

2.1.62 (14-Feb-2017)

Fixed error with Cost Group column missing for non AVG cost set up.

2.1.61 (08-Feb-2017)

Updated Security.

2.1.60 (19-Jan-2017)

Serial Number LOV will now return Serials that are not assigned to a Subinventory.

2.1.59 (17-Jan-2017)

Fixed Delete showing no Transactions deleted if Serial Lot Section had nothing to delete.
Added Location column to Wizard.
Can now transact Predefined Serials as well as Dynamic at Inv. receipt Serials.
Various Validation/Upload Performance increases.
Receipted new (dynamic) Serials will now error if attempting to select one that exists already under another status.
Renamed Status columns to limit width of columns.
Fixed error when interface downloading.

2.1.58 (12-Dec-2016)

Added support for predefined serials, added Search Control to Serial Forms.

2.1.57 (07-Dec-2016)

Fixed Secondary Quantity erroring for rows that are not UOM controlled.

2.1.56 (06-Dec-2016)

Fixed Secondary Quantity displaying numeric error when not required.

2.1.55 (06-Dec-2016)

Sped up Quantity Validation for sheets with removed columns.
Fixed Secondary UOM always being required regardless of item selected.
Fixed various issues occurring when columns missing.

2.1.54 (05-Dec-2016)

Added Subinventory/Locator Restricted functionality.

2.1.53 (02-Dec-2016)

Fixed issue with Secondary UOM control.

2.1.52 (02-Dec-2016)

Fixed errors with Secondary UOM functionality.

2.1.51 (01-Dec-2016)

Added Secondary UOM/Quantity Functionality for Line and Lot sections.
Fixed Message appearing in the Processing form for Lot Numbers that don't exist when receipting.

2.1.50 (10-Oct-2016)

Fixed Group By SQL error with Quantity Download when Include Costs checkbox is ticked.
Updated Security.
Fixed SQL Error with LPN Locator Defaulting.

2.1.49 (06-Oct-2016)

Fixed SQL error with Locators in Project Organization.

2.1.48 (05-Oct-2016)

Fixed issue with uploading Lot/Serial DFFs with data larger than specified Block Size.

2.1.47 (03-Oct-2016)

Added Example Sheets (Standard/Transfer/WIP Transactions).
Fixed Error in WIP Completion Defaulting for Locator.

2.1.46 (28-Sep-2016)

Modified default "Normal" text to be Arial size 10 as per standard (used for new sheets).

2.1.45 (28-Sep-2016)

Fixed Issue with Account Download for Subinventory Transfers.

2.1.44 (23-Sep-2016)

Fixed Locator Error when selecting a % as a Segment.
Fixed Issue with Using Locators with multiple blank Segments.
Removed Disabled Locators from SQL.
Fixed History Download Returning Incorrect Accounts - Will no longer download Accounts for Account/Account Alias types.

2.1.43 (22-Sep-2016)

Fixed Account Download from History.

2.1.42 (21-Sep-2016)

Restricted Upload errors from 2.1.39 -Now If a line errors in a header, none of the header data will upload.

2.1.41 (21-Sep-2016)

Download Forms will now return the first error found instead of the last.
Renamed all extra columns in Download forms so they are not all caps.

2.1.40 (20-Sep-2016)

Fixed Error with Lot transaction.
Updated Security.

2.1.39 (20-Sep-2016)

Fixed error with receipting an item into a lot that exists with lot uniqueness enabled.
Allowed valid line uploads when there is an error in the same header block.

2.1.38 (13-Sep-2016)

Fixed uploading many lines (1 header) will only process last few records.
Fixed issue with removing columns from sheet.

2.1.37 (05-Sep-2016)

Fixed validation issue with removing particular columns on sheet.

2.1.36 (05-Sep-2016)

Fixed Dependency Issue with Locator To and Subinventory Transfers vs Interorg Transfers.

2.1.35 (30-Aug-2016)

Fixed issue with date validation.
Fixed error when entering incorrect date in transaction date From control for Download forms. Removed refresh message when no accepted IDs and no errored IDs are found.

2.1.34 (26-Aug-2016)

Updated Download Wizard Modules. Updated DFF Context column in uploads.

2.1.33 (23-Aug-2016)

Fixed issue with Quantity Download form pressing enter after typing Item.
Fixed issue with validating Locator on Quantity Download form.
Added ValidateColumn to LOV validation for quantity and WIP forms.
Fixed issue with Locator in Direct Org Transfer validation.
Removed isBlank check in subTransfer Validator.

2.1.32 (22-Aug-2016)

Fixed issue in DFF upload.
Fixed Locator Issue with KFF form.
Fixed issue with Subinventory Transfers with Locators.
Fixed errors in Download quantity functionality.

2.1.31 (16-Aug-2016)

Fixed issue with Interface Refresh.
Fixed incorrect BOM download.
Fix for Serial Lot uploads error.

2.1.30 (16-Aug-2016)

Fix for Excel 2003 - Toolbar access error.
Fixed Issue with avgcost uploads displaying quantity must be numeric error.

2.1.29 (16-Aug-2016)

Fix for Serial Uploads - Quantity must be numeric error when correct values.
Added a not isSerial check for the numeric child check in createQuantities.
Fixed issue where user could not refresh IDs regardless of ID column existing or not.
Fixed issue with initialising with section context columns missing from sheet.

2.1.28 (15-Aug-2016)

Fixed critical error when deleting from interface.
Cleaned up AVG cost form, new non-numeric handling.
Fix for validation error with Items with a null Item Cost.
Optimised Download sources that include Locator Tables.
Handled error if trying to delete values when ID column is not present.
Added check for all sections - Will cancel delete if any are missing

2.1.27 (15-Aug-2016)

Fixed issue where uploading would overwrite accepted status.
Fixed issue trying to open Lot, Serial, Serial Lot DFF forms.
Fixed quantity error when uploading LPN information.

2.1.26 (12-Aug-2016)

Updated Security.

2.1.25 (12-Aug-2016)

Fixed error when opening Lines form.

2.1.24 (12-Aug-2016)

Fixed Locator issue for receipting to pre-generated LPNs.

2.1.23 (11-Aug-2016)

Fixed error in BOM download when selecting Alternate.
Fixed error in non-history/interface downloads.
Fixed Category Issue in AvgCost download.

2.1.22 (11-Aug-2016)

Fixed error in Download (Transaction_Line_context error).

2.1.21 (10-Aug-2016)

Fixed errors in receipting LPN locators and transacting with predefined Subinventories.

2.1.20 (10-Aug-2016)

Added ability to handle and delete errored templates from database.

2.1.19 (09-Aug-2016)

Fixed error when selecting a lot quantity that will drive on hand quantity negative.

2.1.18 (09-Aug-2016)

Fixed error when uploading pre-specified Locators and selecting Item controlled pre-specified Locators.

2.1.17 (05-Aug-2016)

Added bug check for Databases that do not have Patch to fix LPN Interface Error (bug Num: 10009302).
Fixed error when trying to upload non-numeric quantities.
Fixed AVG cost form not erroring correctly - Error on Level and doing weird selections.

2.1.16 (04-Aug-2016)

Fixed error with selecting Subinventory with Locator Control of Pre-specified and not item controlled.

2.1.15 (01-Aug-2016)

Added Average Costing errors: Negative Values when element is zero.
New Avg cost cannot be same as Current Avg cost (Interface limitation).
Fixed WIP Download from sheet not returning Quantity.
Added check for Dynamic type Locators existing in another subinventory.
Removed all validation from WIP and Qty Downloads for Locators (now LOVs instead of KFF).

2.1.14 (29-Jul-2016)

Fix for Upload where ID columns are not on sheet.

2.1.13 (29-Jul-2016)

Fix for Uploads with sections other than Lines erroring.

2.1.12 (28-Jul-2016)

Fixed issue when Uploading Negative value in Cost Element Section.
Fixed error when Refreshing ID data.
Fixed DFF column error when removed from sheet (not templating).
Improved Wip Download when limited options are selected.

2.1.11 (25-Jul-2016)

Fixed ID columns requiring values during validation.
Fixed issue when selecting a Locator that does not exist yet.
Fixed issues in WipJob Download with an Active Date specified.
Fixed issue with Subinventory/Item Locator Type set to Dynamic Entry.

2.1.10 (25-Jul-2016)

Added ability to select new Locators for uploading (but not for package defaulting).
Will (temporarily) display extra segments in Locator KFF.
Fixed error in Errored Uploaded Results.
Fixed error when opening Lines form with no Transaction Type Selected.
Fixed error when Transaction Source column removed from sheet.
Set All Status/message/ID columns as mandatory - can still be removed from Section Selection in Manage Templates.

2.1.09 (21-Jul-2016)

Added Profile Option installer for templating Profile Options.
Added Defaulting from package at validation stage (includes Account).
Fixed error with WIP transactions when Transaction Type Column not populated.
Updated returned error from upload Message – multilingual.
Fixed error initialising with default Account column missing.
Allowed negative values for Percent and Inventory Change Columns (Average Cost).

2.1.08 (20-Jul-2016)

Enhanced WIPJob completion defaulting in lines form - will now error if User tries to enter a different Value.

2.1.07 (20-Jul-2016)

Fixed Locator Error occurring for Project Orgs with Subinventories/items that are not locator controlled (currently unsure of the impact of this change. It was a significant modification that may cause other locator errors).
Fixed Upload of quantities with international Delimiters for decimal (,) to use correct value.
Fixed error opening Lines form with no Type selected in Average Cost Organization.
Fixed AverageCost uploads in Cost Element Section setting values to 0.
Fixed issue in Lines form calculating incorrect Total Average Cost when selecting a new Item.
Fixed WIP download Quantity column (was scheduled_quantity, now required_quantity) also disabled searching by date from sheet.

2.1.06 (18-Jul-2016)

Fixed Locator error in WIP requirements Download form.
Fixed error when double clicking Average Cost column, updated Average Cost Form design, shows all columns now.
Fixed error opening Lines form using Final Completion or Operation Sequence columns.
Fixed Download error for WIP from sheet.

2.1.05 (18-Jul-2016)

Corrected AvgCost precision in forms (also stores long values and uploads them now).
Fixed AVG cost upload error.

2.1.04 (15-Jul-2016)

Fixed Average Cost Download error.
Corrected row number label for foreign languages.

2.1.03 (14-Jul-2016)

Fixed Cost Element section Upload.
Added ability to default a value from Package once and not call package again (Only if one value is ever desired).
Fixed Locator erroring when selecting Project/task information in Locators for Project Organization.
Enabled Upload for Average Cost without selecting a UOM.

2.1.02 (12-Jul-2016)

Fixed Percent Defaulter for lines and Cost Element Sections.
Fixed error with validating line quantity from Cost Element section.
Fixed error in upload for AVGcost data.

2.1.01 (11-Jul-2016)

Fixed Element form not displaying correct values.

2.1.00 (11-Jul-2016)

Fixed Quantity error for comparing decimal values.
Updated CreateQuantity to use doubles, and uses round to compare two doubles.

2.0.99 (11-Jul-2016)

Fixed Average Cost Element section LOV buttons from annoying clicking bug.

2.0.98 (11-Jul-2016)

Fixed error loading Lines or Serial forms with no Header Information (Transaction Type/Org).
Fixed Lot Quantity error comparative check against Lines.

2.0.97 (07-Jul-2016)

Fixed Average Cost error when closing form with invalid but unvalidated controls.
Allowed decimal Quantities.
Fixed Receipted lots erroring if they did not exist (should be able to create new ones when receipting).

2.0.96 (07-Jul-2016)

Fixed Lot form erroring when Line section was blank.

2.0.95 (07-Jul-2016)

Disabled Shipment requirement for Direct Org Transfers, Org To will only show applicable Orgs per Transaction type.
Enabled Download for all Transaction Types regardless of Responsibility (not filtered at all now).

2.0.94 (07-Jul-2016)

Fixed error in Material Overhead Account column.
Fixed errors with Average Cost calculation.
Disabled User Defined Transactions in Header form for Users with no form function access.

2.0.93 (07-Jul-2016)

Fixed Average Costing Error with UOM.
Fixed inconsistency with defaulting account values. Should be more reliable now.
Note - This disables account defaulting from package (will re-implement once client has confirmed the new spec design).

2.0.92 (06-Jul-2016)

Removed Wizard disablility for responsibilities that have access to no transactions (Still unable to do uploads).
Fixed error in Interorg Validation.
Rearranged Lines form controls in Average Cost mode to allow for new LPN control.
Hidden UOM in AVG cost mode.

2.0.91 (05-Jul-2016)

Item Cost now updates during sheet validation (validate/upload), fixed SQL error.
Corrected Responsibility Function checks to update when using Responsibility Change (within About Form).

2.0.90 (05-Jul-2016)

Disabled Wizard use when current responsibility has no access to any related forms.
Fixed issue with Current Item Cost validation.

2.0.89 (04-Jul-2016)

Added check for WIP Work Order-less Completion Transaction types, added all Misc Transaction types to Misc Set.
These Sets are used for hiding Transaction types that are unavailable for responsibilities that have disabled the corresponding Oracle form (Transaction Types are derived from multiple different forms).
Added functionality for standard item cost to be derived during validation and downloaded.
Fixed error in Header if Inventory Org was not in LOV.

2.0.88 (04-Jul-2016)

Fixed error in Average Cost Download.
Fixed uploads with Shipment numbers with varchars.

2.0.87 (29-Jun-2016)

Fixed error in Upload for InterOrg Transaction Types.
Fixed errors in lot/serial DFF setup.

2.0.86 (29-Jun-2016)

Modified ribbon to refresh 'Login Info' Ribbon Group when logging out.

2.0.85 (29-Jun-2016)

Modified Download SQL to exclude serial section for Lot Serial information in OHQuantity Downloads.

2.0.84 (28-Jun-2016)

Updated Header form to disable search control on transactionType change rather than after update.
Fixed error in Uploads for transactions that use Subinventory TO.

2.0.83 (27-Jun-2016)

Fixed error in R11i when trying to derive Precision value.

2.0.82 (27-Jun-2016)

Disabled Transaction Source Search Control for realz.

2.0.81 (27-Jun-2016)

Fixed Subinventory To showing incorrect Values for SubinventoryTransfers.
Disabled Transaction Source Search control for types that do not require it.

2.0.80 (27-Jun-2016)

Fixed Download issue in R11i; Error - White space required.

2.0.79 (27-Jun-2016)

Fixed error in History/Interface Download.

2.0.78 (27-Jun-2016)

Fixed issues in Txn History Download for Shipment number and Locator To (InterOrg Columns).
Disabled incorrect Subinventory Check for Interorg Transfers (Only Subinventory transfers now).

2.0.77 (27-Jun-2016)

Removed Shipment defaulting on Transaction ID option.
Fixed error in Subinventory To Validation.

2.0.76 (27-Jun-2016)

Fixed error in Serial Validation where Issue transaction and status not found.

2.0.75 (24-Jun-2016)

Fixed error when selecting an Item during Interorg Transaction Types.

2.0.74 (24-Jun-2016)

Wizard will now clear Searchlist in Transaction Source LOV if a new Transaction Type is selected.

2.0.73 (24-Jun-2016)

Modified Wizard to handle Organization Profile ID "MFG_ORGANIZATION_ID".

2.0.72 (21-Jun-2016)

Implemented Table based DFF for Source LOV with Search Control.

2.0.71 (15-Jun-2016)

Fixed line-lot-serial Quantity error, fixed Invalid Locator ID.

2.0.70 (15-Jun-2016)

Fixed upload issue with Account, Account Alias, Source LOV transaction types.

2.0.69 (14-Jun-2016)

Fixed issue with InventoryOrgTo incorrectly setting its required property.
Updated issue in Averagecost Download (WIP – shouldn’t affect other downloads or transactions).

2.0.68 (14-Jun-2016)

Fixed issue with Inter Org Transactions.

2.0.67 (13-Jun-2016)

Fixed error in Transaction Type default validation - would error if type requiring value was not required by default.
Added available Account transaction types to Drop Down.

2.0.66 (13-Jun-2016)

Corrected Serial/Lot upload validation.

2.0.65 (13-Jun-2016)

Various bug fixes.

2.0.64 (10-Jun-2016)

Fixed error with Account incorrectly defaulting columns after defaulting occurs (storing defaulted value).
Fixed error in Quantity Validation where it would error required even with a value present.

2.0.63 (09-Jun-2016)

Fixed Issue with Account Flex Form in R11i, Fixed Quantity and Locator issues with LPN transactions, Enabled error popups when Debug is disabled, updated required validation.

2.0.62 (08-Jun-2016)

Updated Transaction Type validation, modified Quantity validation to speed it up, Added 'Account' type transaction functionality. Source will now be Required if LOV or KFF style.

2.0.61 (02-Jun-2016)

Fixed Project columns not being set to 'Required' correctly.

2.0.60 (01-Jun-2016)

Fixed Transaction Type not validating account column correctly, Transaction date on form will default to NOW instead of today’s date, Fixed Transaction Date Error if no Org selected.

2.0.59 (01-Jun-2016)

Modified Delete to check Line section instead of header (effectively the same delete).

2.0.58 (01-Jun-2016)

Corrected Quantity column not erroring with no data.

2.0.57 (01-Jun-2016)

Corrected Account default line error.

2.0.56 (01-Jun-2016)

Fixed Upload with LPN column missing.

2.0.55 (01-Jun-2016)

Fixed Account upload value, fixed header setting line "isrequireds" on the wrong row.

2.0.54 (31-May-2016)

Fixed Refresh error when section was missing from sheet. Fixed issue with item search validation. Added all DFF cols to Lot, Serial, Serial Lot for download. REMOVED disable date Lot dff col.

2.0.53 (30-May-2016)

Updated Oracle messages, caching quantity values to minimise package calls-now correct to locator level, corrected locator issue where subinventory is dynamic entry.

2.0.52 (26-May-2016)

Rollback to 2.0.51 - Serial, Lot, Serial Lot are no longer required unless Item is relevantly controlled.
WipJob and LPN columns can be removed without erroring code.
Validation on columns with blank values will now be skipped. Templates created with same name with different case (upper/lower) will not error.

2.0.51 (26-May-2016)

Fixed locator error, fixed validation error.

2.0.50 (26-May-2016)

Fix for Lot form, various bug fixes, Serial Lot data derives Serials from relevant Lot now.

2.0.49 (26-May-2016)

Updated Lot Number Query.

2.0.48 (25-May-2016)

Fixed Lot Form not validating correctly.

2.0.47 (25-May-2016)

New package version required (Header: 1.2.0 Body: 02.03.00). Non common Wizard no longer supported.
Renamed Package calls in upload procedures, readded Date default to sysdate, hidden the Default Percent control.

2.0.46 (24-May-2016)

Lot Quantity now looks at Selected lot (Now Search Controlled), Added Lot divisible Functionality (Item level control - Cannot split Lot in subinventory if found in another).

2.0.45 (23-May-2016)

Updated Security.

2.0.44 (23-May-2016)

Fixed issue with Item Search, Fixed issue with Locator validation.

2.0.43 (23-May-2016)

Fixed Onhand Quantity download for Serial Lot data, Removed Defaulting Values in Onhand Quantity Form (Transaction Types, Account) - Unnecessary due to default row 10.

2.0.42 (23-May-2016)

Fixed Bill of Material Download SQL Error, Fixed SerialLot Download Onhand Quantity.

2.0.41 (20-May-2016)

Fixed Quantity error message, fixed receipt serials validation error.

2.0.40 (20-May-2016)

Fixed error when trying to open form in orphaned sections, Fixed SerialLot form not opening from ribbon, fixed quantity errors in lines and lot sections.
Fixed Issue for non LPN transactions causing "error in other section".

2.0.39 (19-May-2016)

Fixed Subinventory Transfer LocatorTo validation issue.

2.0.38 (19-May-2016)

Downloader now correctly adds Project/Task information to download.

2.0.37 (19-May-2016)

Fixed Account defaulting for wrong Transaction Types, Fixed LPN with multiple item upload issue.
Fixed LPN issue with trying to issue an LPN that has just been receipted (LPN context updated from 5 to 1).

2.0.36 (18-May-2016)

Updated Package to make sense for user (Ids do not get used except for determining defaulter status) – Update not required for functional use - will still function correctly.
Fixed issue in LPN transactions where receipting an empty LPN then issuing it in the same session wouldn't recognise the change.

2.0.35 (18-May-2016)

Fixed Defaulting Project Data issue - now defaults once a project is selected, Issue with Locator.

2.0.34 (17-May-2016)

Fixed WIP Completion upload.
Fixed error in Serial& lot forms, removed all inter-form buttons, added errors for incorrect serial section usage Fixed Lot Quantity Error.

2.0.33 (16-May-2016)

Fixed 'Level' issue in Quantity Download.

2.0.32 (13-May-2016)

(New custom package version required) Defaulting from package now accepts -2 to ensure package only gets called once if user doesn’t want to use defaulting feature.
UOM in LPN transactions defaults to X when different UOMs are encountered in same LPN. Sorting now includes lower case.

2.0.31 (13-May-2016)

Implemented Source DFF data Enhancement, added project column validation.

2.0.30 (11-May-2016)

Fixed Item SQL error, Implemented Project Default data from package (Only affects custom package - Changes were made to package 05/02/16)

2.0.29 (10-May-2016)

Added sorting to Item and project LOVs. Various bug fixes.

2.0.28 (10-May-2016)

Successfully completed LPN initial tests. Misc Issue/Misc Receipt, Fixed Locator Project Segment consistency Issue.
Added errors; receipting in non-LPN subinv, issuing LPN with no content.

2.0.27 (05-May-2016)

No longer download Onhand Quantity from sheet (msgbox recommends form).
Various bug fixes regarding locator validation.

2.0.26 (03-May-2016)

Fixed Onhand Quantity download form SQL error.

2.0.25 (03-May-2016)

Fixed Txn History Download of WIP data duplicating on accounts and Operation sequences.

2.0.24 (02-May-2016)

Fixed Header form crashing Wizard with automatic form morphing, fixed double clicking columns that won’t exist in form issue.

2.0.23 (29-Apr-2016)

Updated locator to validate correctly and accurately.

2.0.22 (08-Apr-2016)

Fixed error that would occasionally appear after selecting an LPN in form.

2.0.21 (04-Apr-2016)

Fixed Error with Locator SQL - invalid number.
Fixed issue where Lot form will error on validation if Locator is invalid.

2.0.20 (01-Apr-2016)

Fixed Lot form erroring on load.

2.0.19 (01-Apr-2016)

Fixed LocatorTo SQL error requiring missing parameters.

2.0.18 (01-Apr-2016)

Fixed WIP frame on Lines form hiding title.

2.0.17 (01-Apr-2016)

Updated Security.

2.0.16 (31-Mar-2016)

Fixed Alias type transactions allowing account to be populated during upload.

2.0.15 (31-Mar-2016)

Updated Security.
Wizard has been recovered (modules removed and recreated in new worksheet), latest version of common has been implemented, Including new messages Functionality (messages123 sheet), Accounts can have aliases.

2.0.14 (29-Mar-2016)

Fixed Hyperlink for Online documentation going to Sales Order Wizard.

2.0.13 (29-Feb-2016)

Removed Move Order Types from Transaction Type LOV, added selected few more. Added Downloader.

2.0.12 (24-Feb-2016)

Made ID columns non-mandatory as they were expecting values on validation (isRequired gets set to true).

2.0.11 (24-Feb-2016)

Fixed Transaction Source in form and sheet incorrectly validating the description, and setting to isRequired properly.
Also added newer common modules which will fix New Sheet issues.

2.0.10 (22-Feb-2016)

Added Common modules Support, WDownload, fixes deleted column issue.

2.0.09 (22-Feb-2016)

Started LPN mode implementation - Column added, SQL, validation started.
Fixed download returning incorrect Date format.

2.0.08 (05-Feb-2016)

Implemented Project/task date fix and project/task dependency issue.

2.0.07 (29-Jan-2016)

Completed all other download modes.
Fixed serial lot downloads.

2.0.06 (15-Dec-2015)

Successfully downloading txn History mode. Other download modes unimplemented currently.
Disabled Serial Lot downloads as downloader disagrees with non-unique IDs.
Tidied up locator dependencies, forms should load and validate much faster now

2.0.05 (30-Sep-2015)

Fixed Column Headers error in Template 123 (renamed SerialLot to Serial Lot).

1.8.03 (06-Feb-2015)

Fixed refresh to check upload item and serial number.
Updated spreadsheet columns for line level dff's from line transaction x to line transaction.

1.8.02 (13-Feb-2015)

New Package Minimum Header: 1.1.3 Body: 02.02.01
Changed Insert_Transaction_Line to pass in WIP procedure as dynamic SQL based on R12 or 11i.

1.8.01 (06-Feb-2015)

Fixed refresh to check upload result and txn id for blank lines check, rather than txn id.

1.8.00 (06-Jan-2015)

Added support for workorder less completion transactions.

1.7.21 (29-Dec-2014)

Fixed bug in lines DFF, where DFF default values had a space where no space is allowed.

1.7.20 (29-Dec-2014)

Fixed bug in get tasks sql not seeing task_number as a bind variable.

1.7.19 (23-Dec-2014)

Update Material Transaction Download form to enable the include costs check box for average cost organizations.

1.7.18 (13-Nov-2014)

Changed the downloader forms to allow any transaction type for interface and download history, not just those available to create transactions with the Wizard.

1.7.17 (25-Oct-2014)

Added in date to transaction table refresh to improve performance.

1.7.16 (08-Oct-2014)

Fixed subinv caching issue causing Wizard to crash if loading records for different subinvs in different orgs at the same time.

1.7.15 (07-Oct-2014)

Updated post login events to give nice error message if no functional access found.

1.7.14.3 (25-Nov-2014)

Fix for handling long columns in EBS 12.1

1.7.14 (10-Aug-2014)

EBS 12.2 fix Long_to_char for long_to_char sql errors caused by table based validation sets
Core 209 imported
DFFmod.Search_Value_Set_ID sql updated for 12.2
Put in screen freeze code to speed up processing and reduce memory usage
Fixed bug in lot form
Updated downloader for QOH and WIP txns for issues found in support team testing
Fixed bug in serial items screen not defaulting serial number into the form

1.7.13 (04-Jul-2014)

Fixed bug in get default data sql.

1.7.12 (01-Jul-2014)

Defaulted the Settings value for Download Source to get the LOV working properly
SetInternalDownloadOption created to determine the Download Option for Setting Download Form Behaviour

1.7.11 (06-Jun-2014)

Fixed bug in locator to for interorg/direct org transfers
Added support for container number
Fixed bug where txn source for inv txns not being loaded or downloaded

1.7.10 (21-May-2014)

Added in interorg transfer to the Wizard
Removed requirement for locator to column for interorg transfers
Added in requirement to enforce shipment num in interorg
Updated common code
Finished header level validation

1.7.09 (21-May-2014)

Fixed bug with project tasks not getting the correct task id

1.7.08 (05-Mar-2014)

Fixed a ribbon issue with the naming the PRODUCT and SETUP ribbons not matching the core code

1.7.07 (05-Mar-2014)

Updated infrastructure
Fixed bug with serialised items erroring out
Changed Serialised items form to have a search box for the LOV’s

1.7.06 (25-Jul-2013)

Updated infrastructure
Added validation check on serial numbers to check serial number is in correct org
Fixed lines form subinventory to list of values wrong org for interorg transfers

1.7.05 (25-Jul-2013)

Changed transaction lines subinventories field to not error if no subinventories found
Fixed bug with WIP jobs field, when a job not found the form errored
Fixed header form from scrolling up above row 10

1.7.04 (09-May-2013)

Removed session constraint when returning transaction id from temp table as constraint not required
Change validation mode when project manufacturing is used to create the code combination if the combo doesn’t already exist
Fixed issue with subinventory to validation when dealing with inter org transfers

1.7.03 (09-May-2013)

Fixed issue with lines form not defaulting UOM from item primary UOM
Fixed header form not rendering correctly for account/account alias transactions
Changed average cost elements to be doubles so decimal values load

1.7.02 (07-Nov-2012)

Fixed download from Work in Process transactions putting date in the wrong format
Changed transaction download to put the Work in Process job in the Work in Process job field rather than the transaction source

1.7.01 (31-Jul-2012)

Toggle button fixed for ‘Show Validation Messages’ on Custom Menu

1.7.00 (30-Jul-2012)

Changed .xsl file to .xlsm format
Ribbon and Toolbar/Menu code updated (Ribbon implemented for the first time)

1.6.43 (30-May-2012)

Fixed issue with automatic form positioning not working.

1.6.42 (14-Mar-2012)

Updated common modules

1.6.41 (23-Feb-2012)

Changed wizard to allow average cost updates without needing material, material overhead, resource, outside processing and overhead columns on the sheet

1.6.40 (22-Feb-2012)

Fixed issue where average cost element accounts not defaulting from default acct, instead using cost type default accounts first

1.6.39 (18-Feb-2012)

Fixed issue with header form not showing LOV correctly for average costing

1.6.38 (09-Jan-2012)

Fixed refresh issue not finding the org id of the line being refreshed

1.6.37 (06-Dec-2011)

Added multiple org selection in download quantity on hand form

1.6.36 (06-Dec-2011)

Fixed issue where wizard wouldn’t list user defined transaction types due to type_class required to = null. Changed this to allow null and 2

1.6.35 (05-Dec-2011)

Fixed issue where wizard would pause while loading if another application was opened
Fixed issue where unit cost was not loading in average costing organization

1.6.34 (14-Sep-2011)

Fixed download from interface not including the interfaced lot quantity

1.6.33 (14-Sep-2011)

Fixed issue where lot form would not allow you to enter new lot numbers if the item is being transacted for the first time.
Fixed session issue when validating the current on hand quantity sometime returning zero available when stock was available.
Changed color of account field in the line transaction to yellow for misc transactions
Fixed issue with using the wrong session when verifying the on hand qty on r12

1.6.32 (09-Sep-2011)

Changed refresh to refresh the whole sheet and to ignore costed, accepted transactions
Fixed bug in lot form where if not locator controlled it passed locator id = 0 rather than null to sql

1.6.31 (28-Aug-2011)

Added in cancel while loading functionality.
Fixed serial number not downloading with Quantity on hand down.
Removed error where if you delete the component in the download quantity on hand form it put an error about revisions on the s/sheet.
Fixed subinv from/to fields requiring user to press buttons twice.  Issue caused by custom package returning default subinv information

1.6.30 (02-Aug-2011)

Made change to allow subinv transfers without “Organization To” column required on s/sheet

1.6.29 (20-Jun-2011)

Changed average cost validation to allow load of zero on hand qtyChanged download average cost to allow download of item and its cost when zero on hand

1.6.28 (25-May-2011)

Added download average costs formFixed issue with download items with revisions not downloading serial numbersFixed upload average costs not working with initial item costs

1.6.27 (25-May-2011)

Fixed issue with select existing lot in lot form sql error. Fixed date download not working correctly

1.6.26 (05-May-2011)

Added support for default acct and trx source type name for defaulting package
Fixed issue with clear inventory quantity in memory not working
Fixed issue where you couldn’t enter a transaction source when doing a misc issue

1.6.25 (03-Apr-2011)

Re-Added support for Account Issue/Receipt.
Fixed bug with KFF form returning alias instead of account back to the wizard.

1.6.24 (05-Mar-2011)

Removed support for issue to project since not currently used by any customers
Fixed issue with download on hand quantity downloading into item revision field

1.6.23 (30-Jan-2011)

Fixed quantity on hand download double ups of items due to using the transaction id rather than on hand qty views
Fixed error with wip discrete jobs not validating
Fixed excel crashing when choosing direct transfer and then choosing a different source organziation in the transaction headers form
Added account alias transactions back into the wizard
Improved error handling when transaction type is missing and user opens lot/serial or cost details forms
Fixed bug with average costs not loading the cost group or providing status feed back

1.6.22 (10-Dec-2010)

Fixed issue with quantity on hand download missing costing join

1.6.21 (19-Oct-2010)

Changed download code to using having sql for 0 qty rather than by transaction
Added LPN_ID = Null to downloads since wizard doesn’t support warehouse management, speeds query up

1.6.20 (19-Oct-2010)

Fixed issue with items with zeros not downloading correctly
Added functionality to Ignore 0 quantity items on upload
Fixed bug with quantity check rounding decimal numbers when issuing decimal quantities

1.6.19 (17-Oct-2010)

Fixed bug in lines form where it tries to find subinvs/locators when the item is invalid
Removed account and account alias transactions as these can be met via misc receipt/issue

1.6.18 (23-Sep-2010)

Updated downloader to handle organization and item codes starting with zero.
Fixed issue with transaction type sql where not in missing starting bracket in SQL

1.6.17 (23-Sep-2010)

Updated transaction id’s to be strings to handle very large transaction numbers
Added in functionality to download on hand quantities to default transaction type and default account

1.6.16 (23-Sep-2010)

Added pro-rating functionality for average costing
Added in call to update primary qty when doing average cost update
Added delete from average cost details interface table
Fixed download on hand qty bringing back wrong cost in average cost organizations
Added ability to do cost check by average cost group type

1.6.15 (22-Sep-2010)

Fixed download transactions to work for current work day
Changed transaction type list to include only supported transaction types

1.6.12 (08-Aug-2010)

Fixed issue in where wizard not checking asset subinventories correctly

1.6.11 (28-Jul-2010)

Made change to allow issue from non asset subinventory

1.6.10 (16-Jul-2010)

Fixed where account alias lov is the description and not the alias
Fixed issue with account alias allowing account field to be populated in transaction lines form
Fixed bug with set status erroring returning wrong message
Fixed bug with new transaction expecting transaction type
Stopped wizard expecting user to choose org twice when Wizard first used
Fixed issue with locators not working when project mfg not on the instance

1.6.9 (07-Jul-2010)

Fixed issue on txn form where acct alias setting account code where it shouldn’t
Added msg to transaction form when header validation fails and form closes

1.6.8 (28-Jun-2010)

Fixed issue with setting status into the wrong column for transaction ids
Fixed setting DFF value to number instead of checking to see if string or not
Double click organization to opening up the wrong form
Fixed Type Mismatch issue when loading lot transaction where lot quantity is null now creates validation error
Download transactions would return zero rows when transaction type was null
Updated the set status of columns to clear out the error messages

1.6.7 (05-Jun-2010)

Updated Common Modules and common mfg modules
Fixed issue where Avg element errors not updating cell colours

1.6.6 (11-Feb-2010)

Fixed issue where wizard validates unit cost in non avg cost organization, instead this is ignored.
Changed downloader functionality to use common download data type.
Fixed issue where subinv with/without locators only return locator level for qoh
Fixed wip download not working correctly
Added project and task to QOH downloader

1.6.5 (02-Feb-2010)

Added in project mfg functionality for borrow/payback and project transfer
Fixed issue with download of project locators returning ID instead of Project name/task
Fixed validate wip causing other validators to be ignored when they fail validation
Validate Transaction causing form to close, changed this to show errors but load the form
Outstanding – Project Locator KFF combinations SQL error in the form

1.6.4 (15-Jan-2010)

Changed Get Item details to check to see if lookup type MSC_ATP_COMPONENTS_FLAG exists

1.6.3 (14-Jan-2010)

Fixed bug in defaulting Acct Alias not showing account code
Fixed issue where multi segment items not loading
Fixed locator validation issue for subinventory to

1.6.2 (14-Jan-2010)

Fixed locator bugs with subinventory transfers
Fixed bug in refresh overflow
Updated subinv details to look at the location control being item specific
Added validate locator as workaround to locator dff not doing item level validation.

1.6.1 (11-Nov-2009)

Added new CacheRow/Revert row to work around excel 2007 issue causing spreadsheet to grow each time a form is opened
Fixed bug in download bom form with getting revisions

1.6.0 (12-Nov-2009)

Fixed bug where current average cost = 0 causing wizard to error
Removed reference to MFG_LOOKUPS as this causes 11.5.9 issues vs all new releases
Changed download QOH to split Lot and Serial more effectively
Updated load process up by caching the organization details between transaction headers to speed up loading data
Updated delete to continue passed errored columns
Added support to show the column that errors during validation
Fixed download txn reason code issue
Added view requests form

1.5.2 (24-Jun-2009)

Calendar not working in lots form for expiration date fixed
Locator label on transaction lines form behind the current cost field when non costing transaction Fixed issue where default acct from the header is not populating the acct for the transaction line
Loading item/lot wouldn’t load second row of item transactions
Fixed issue where invalid UOM stopping user from using the transaction lines form

1.5.1 (07-Jun-2009)

Removed ability to enter unit cost on transaction form when not average cost organization
Fixed bug where load transaction was missing the distribution account in validate_line_account proc

1.5.0 (21-Apr-2009)

Added Cost Update functionality, created elements form
Changed validate to be used after form has opened and defaulted for hdr and transaction levels
Changed validate line into sections, depending on the type of load

1.4.4 (23-Apr-2009)

Updated Generic Modules – fixed initialize issue
Updated to make Generic module ICWgenSupport for item cost wizard
Applied InvSupport module v1.1

1.4.3 (21-Apr-2009)

Implemented functionality to default subinventory and locator Updated locator fields in transactions form to verify the qty for the loc

1.4.2 (17-Feb-2009)

Added DFF buttons to line, lot and serial forms
Added right click mouse functionality for the toolbar
Updated form zoom buttons

1.4.1 (20-Jan-2008)

Fixed issue where standard cost org could enter cost information in the transaction lines form
Fixed issue where account not defaulting when opening the lines form
Fixed error in getting custom charge account not formatting the date correctly or back date
Fixed issue with refresh only doing one line at a time
Added functionality in validate transaction where check made that account against the transaction when it is a required field for that transaction type
Fixed bug where invalid header allowed transaction lines to be validated
Now transaction checked until the header is validated

1.4.0 (05-Oct-2008)

Added in Wip download form functionality
Added support for subinventory transfers
Recoded the record types so each transaction holds the header information as well
Fixed bug when uploading lots without serial numbers
Added in Spinbutton (up and down) on forms
Fix to downloader – stops it from running queries multiple times
Added in Wip job completion and interorg transfer functionality
Added in payback date which was missing for project borrow/payback

1.3.0 (04-Aug-2008)

Added in upload/download DFF changes
Added in support for Wip component receipt and issue
Fixed bug in validate line where item not checked to see if it exists

1.2.0 (24-Jul-2008)

Added in forms and tool bars for additional download forms
Added download transaction lot and serial number functionality
Fixed bug where subinventory not validated
Added optional cost check box when downloading
Fixed bug where account was not being updated from the form

1.1.1 (14-Jul-2008)

Changed header form to set default account yellow when account_enabled transaction
Added in default account generator code
Fixed issue where serial number check not taking into account if the item has been issued or is in stock

1.1.0 (14-Jul-2008)

Fixed issue with DFF load not loading the current record for serial and lot transactions
Updated Refresh functionality to allow refresh of sections, not just the whole sheet

1.0.4 (22-Apr-2008)

Changed item details record set to incl locator id and account id

1.0.3 (21-Apr-2008)

Fixed problem with dates forward dating transaction updated get_system_date

1.0.2 (13-Apr-2008)

Fixed issues with UOM not loading in form correctly

1.0.1 (09-Apr-2008)

Fixed issue with locator sql missing = sign for non restricted locators

1.0.0 (06-Apr-2008)

Initial version