Version 1.3.52 (21-Nov-2011)
Set lot divisible to only be available for r12.
|
 |
Version 1.3.51 (21-Nov-2011)
Fixed issue inventory_item_id not set correctly because unique column is set as COMBINATIONX (probably for some other reasons)
Version 1.3.50 (28-Oct-2011)
Fixed issue with lot divisible not validating correctly.
Version 1.3.49 (28-Oct-2011)
Fixed issue with copy attachment function
Version 1.3.48 (26-Oct-2011)
Fixed the download from form.
Version 1.3.47 (26-Oct-2011)
Added Lot Divisible
Version 1.3.46 (05-Oct-2011)
Corrected the record sheet for the source organization
Version 1.3.45 (26-Sep-2011)
Added a check to only validate record if at least one section has data to process
Version 1.3.44
Removed dependence on service item type for shippable flag.
Version 1.3.43 (24-Aug-2011)
Added in check for attachment upload to make sure it doesn't already exist. If so then error it.
Version 1.3.42 (22-Aug-2011)
Added organization to download attachment sqlAdded latest generic code.
Version 1.3.41 (19-Aug-2011)
Added attachment download.
Version 1.3.40 (19 -Aug-2011)
Tax code change, to populate the interface with the tax code = ‘!’ when setting it from No to Yes.
Version 1.3.39 (12 -Aug-2011)
Fixed blank record functionality trying to set some values as char’s at time of insert rather than -999999 number.The following attributes are not allowed [BLANK]column INVENTORY_PLANNING_CODEcolumn PLANNING_MAKE_BUY_CODEcolumn MRP_SAFETY_STOCK_CODE.
Version 1.3.38 (29- Jul-2011)
Removed check against the MTL_SYSTEM_ITEMS.REVISION_QTY_CONTROL_CODE as does not control revision level.
Version 1.3.37 (05-Jul-2011)
Ensure only id’s are passed to the Item procedure.
Version 1.3.36 (30 -Jun-2011)
Made revisions controlled at child org.
Version 1.3.35 (27- Jun-2011)
Added handler if they require a prefix for item generation ie "[PRE]".
Version 1.3.34 (15- Jun-2011)
Fixed problem with UOM linked against inventory item.
Version 1.3.33 (20-May-2011)
Attachments loader now able to upload files directly from HTTP(s) sources.
Added message to attachment form when load completed.
Version 1.3.32 (18-May-2011)
Fixed attachment form not erroring when columns are missing.
Fixed issue with primary UOM when updating attachment or revision.
Version 1.3.31 (17-May-2011)
Fixed download revision sql join.
Version 1.3.30 (16-May-2011)
Added organization_id link between revision and item table.
Version 1.3.29 (10-May-2011)
Fixed problem with UOMs when mode changed and child org swapped to master.
Version 1.3.28 (07-May-2011)
Improved error handling for copy item attachment function.
Version 1.3.27 (06-May-2011)
Updated Attachment Code, causing upload error.
Version 1.3.26 (05-May-2011)
Corrected the Download from Interface in case certain columns not set.
Version 1.3.25 (04-May-2011)
Changed DFF form code to ensure id Columns are returned correctly.
Version 1.3.24 (04-May-2011)
Create new template with Status Columns on the left.
Version 1.3.23 (04-May-2011)
Added support for DFFs 16-30.
Version 1.3.22 (29-Apr-2011)
Added in Copy from another item attachment function to the wizard.
Version 1.3.21 (26-Apr-2011)
Fixed problem when the current category is missing in update mode.
Version 1.3.20 (06-Apr-2011)
Fixed union join in MTL_DEFAULT_CATEGORY_SETS
Version 1.3.19 (05-Apr-2011)
Added check for MTL_DEFAULT_CATEGORY_SETS
Version 1.3.18 (04-Apr-2011)
Fixed problem with revision interface id
Fixed problem with locator update
Version 1.3.17 (01-Apr-2011)
Added handler in case new category left off the sheet
Version 1.3.16 (31-Mar-2011)
Added handler in case effective date left off the sheet
Version 1.3.15 (31-Mar-2011)
Added the New Category column to support category update
Added latest generic and concurrent form code
Version 1.3.14 (30-Mar-2011)
Fixed the DFF and Locator KFF
Version 1.3.13 (18-Mar-2011)
Changed Revisions deletion to use last_update_login instead of created_by
Added check to see if revision already exists in Validator
Version 1.3.12 (16-Mar-2011)
Changed Revisions to use last_update_login to keep track of interface errors
Removed order by on the download from interface..error after copy
Version 1.3.11 (15-Mar-2011)
Fixed problem with copy functionality
Ensure column reference set before setting results column
Version 1.3.10 (10-Mar-2011)
Changed the behaviour for deriving an item so that is occurs after validation during isValidUpload
Only unload form if it has been loaded previously
Fixed revision validator and refresh
Version 1.3.9 (09-Mar-2011)
Added support for [BLANK] to set column values back to null
Version 1.3.8 (24-Feb-2011)
Ensured Item Number required when loading in create mode
Version 1.3.7 (21-Feb-2011)
Fixed problem with concurrent request screen log button not working correctly for alternate login mode
Version 1.3.6 (18-Feb-2011)
Fixed problem with catalogs not loading correctly
Version 1.3.5 (15-Feb-2011)
Fixed revision refresh.
Version 1.3.4 (08-Feb-2011)
Fixed problem with category creation when item already exists - package changed.
This change includes the requirement to use the new category column.
Version 1.3.3 (07-Feb-2011)
Added revisions
Updated generic and common code
Version 1.2.3 (8-Dec-2010)
Added latest generic code including request viewer
Version 1.2.2 (1-Nov-2010)
Fixed problem with Section Header missing if first record in section not
Version 1.2.1 (21-Oct-2010)
Fixed problem introduced with 1.2.0
Version 1.2.0 (20-Oct-2010)
Changed call to improve SGS performance -requires latest package
Version 1.1.113 (22-Sep-2010)
Ensure missing item number column handled during download
Version 1.1.112 (21-Sep-2010)
Fixed problem with Orderable on the Web LOV field
Version 1.1.111 (21-Sep-2010)
Throw error if item number not set.
Version 1.1.110 17 September 2010
Corrected download from interface
Corrected download org LOV
Fixed problems with LOV on Receipt Routing download
Fixed problem with Billing Type download column
Made download using selection use the maxRows from setting123
Changed download using selection to use cell text instead of the default value
Set the sqlColumn used for the UOM loose dependence
Fixed the item description list of values on download form
Ensure TemplateABC is always hidden
Removed unload frmItem during initialise
Ensure deleteSQL is not blank prior to calling accumSQL
Fixed problem with material sub element error when blank
Fixed problem with copyFromItem when return column not set
Fixed problem with frmItem Activate called at end of download selection
Version 1.1.109 (14-Sep-2010)
Fixed problems with inconsistency in download results between download options
Version 1.1.108 (4-Sep-2010)
Fixed records sheet with invalid columns, removed support for some service columns until requested by customers
Version 1.1.107 (26-Aug-2010)
Added the ValidatorDependentDefault
Version 1.1.106 (25-Aug-2010)
Added isAllowedNull to the ValidatorMinMax
Version 1.1.105 (17-Aug-2010)
Added Material Cost and Material Sub Element
Version 1.1.104 (9-Aug-2010)
Fixed problem with Download form duplicating the Attribute columns causing sql error
Version 1.1.103 (2-Aug-2010)
Fixed problem with UOM sql created in 1.1.92
Version 1.1.102 (27-Jul-2010)
Fixed issue where planner code not a combo box
Added in set process id as a required field to stopcategory load issues
Version 1.1.101 27 July 2010
Fixed problem with AddRow when item loaded to multiply orgs
Version 1.1.100 (26-Jul-2010)
Changed download form to use implementation
Version 1.1.99 (23-Jul-2010)
Changed mismatch in sub organization query with item dependence
Version 1.1.98 (22-Jul-2010)
Reverted the determine start code: require new method to open attachment form when entire row blank
Version 1.1.97 (20-Jul-2010)
Updated screen updating during download
Version 1.1.96 (20-Jul-2010)
Changed attachment form to not open if item link cannot be found.
Version 1.1.95 (16-Jul-2010)
Fixed problem when attachment form opened and then closed and reference lot to unloaded form
Version 1.1.94 (6-Jul-2010)
Added dependence tag to header comments
Version 1.1.93 (5-Jul-2010)
Changed the ValidatorValueDependent to throw error when Required dependence missing
Version 1.1.92 (30-Jun-2010 )
Updated the UOM sql to accommodate problems where the item is invalid
Version 1.1.91 (28-Jun-2010)
Updated the UOM sql
Version 1.1.90 (23-Jun-2010)
Corrected download and attachment problems
Version 1.1.89 (17-Jun-2010)
Fixed problem with the Copy From functionality
Version 1.1.88 (13-May-2010)
Added latest generic/common code
Added support for Copy From at the interface table level. Requires package change
Version 1.1.87 (10-May-2010)
Fixed issue with validate values dependent 'Or' validation not working correctly.
Fixed issue with ATP component not looking at correct wip supply type value.
Version 1.1.86 (10-May-2010)
Added Attachment Functionality
Version 1.1.85 (05-May-2010)
Removed message when value changed to [Blank]
Version 1.1.84 (03-May-2010)
Updated safety stock to allow zero
Version 1.1.83 (23-Apr-2010)
Incorrect template definition in record sheet causing downloader to try to load template.
Version 1.1.82 (23-Apr-2010)
Fixed ATP_FLAG issue causing template to not apply correctly
Version 1.1.81 (22-Apr-2010)
Reloaded toolbar to stop bug for French users
Removed end brackets on bind SQL as this is not allowed ie :P1)
Updated common modules to fix upload problem with non-ascii characters in R12
Version 1.1.80 (17-Apr-2010)
Re-installed non DoEvents version of fndxMLHTTP. Changed the name to itemXMLHTTP to preserve this code.
Version 1.1.79 (15-Apr-2010)
Added CopyItemNumber and TemplateName to download from interface
Version 1.1.78 (15-Apr-2010)
Fixed copy from functionality to work as expected (Except oracles interface doesn't)
Version 1.1.77 (14-Apr-2010)
Clear list of values Data after opening download form
Version 1.1.76 (09-Apr-2010)
Ensure invalid records are not passed to upload
Version 1.1.75 (19-Mar-2010)
Updated the common code
Version 1.1.74 (18-Mar-2010)
Improvements to Toolbar behavior
Version 1.1.73 (18-Mar-2010)
Fixed problem with the Context when value set in use on DFF
Version 1.1.72 (17-Mar-2010)
Common RCMenu and Toolbar modules implemented
Version 1.1.71 (05-Mar-2010)
Update generic code for R12 org list of values error
Version 1.1.70 (02-Mar-2010)
Updated common code to improve caching for LOV
Version 1.1.69 (18-Feb-2010)
Update generic code to support new license model
Version 1.1.68 (15-Feb-2010)
Added bind parameters to improve speed on the refresh
Version 1.1.67 (8-Feb-2010)
Added download selected using item and organization code
Version 1.1.65 (29-Jan-2010)
Fixed problem with form grid
Version 1.1.64 (28-Jan-2010)
Changed record sheet dependency and query on wip supply sub inventory as it was too restrictive
Version 1.1.63 (12-Jan-2010)
Updated the max rows to be ignored for the child section so max rows only affects the header item level records
Version 1.1.60 (8-Jan-2010)
Stopped download query from downloading items in other sets of books
Version 1.1.59 (8-Jan-2010)
Added Category Set to download criteria
Version 1.1.58 (21-Dec-2009)
Fixed problem with initialize of master data prior to dependent parents
Version 1.1.57 (2-Dec-2009)
Fixed bug with the SQL for the column Purchasing Asset Category
Version 1.1.56 (2-Dec-2009)
Added tab security for all form functions
Version 1.1.55 (24-Nov-2009)
On update check for engineering products
Version 1.1.54 (18-Nov-2009)
Incorporated the Engineering requirements
Version 1.1.53 (14-Nov-2009)
Added the concurrent request viewer
Version 1.1.52 (2-Nov-2009)
Updated EAM validation where R12 doesn't care if asset group is transactable.
Changed long description length to handle 3800 characters rather than just 200.
Version 1.1.51 (30-Oct-2009)
Added EAM validation
Version 1.1.50 (6-Oct-2009)
Corrected ValidatorExpenseAccount when value entered and conditions correct
Version 1.1.49 (5-Oct-2009)
Removed error where catalog left blank
Version 1.1.48 (10-Aug-2009)
Fixed problem with deletion of large number interface rows
Version 1.1.47 (2-Aug-2009)
Fixed problem with reset of process set id
Version 1.1.46 (27-Aug-2009)
Removed doEvents from fndXMLHTTPDoEvent
Version 1.1.45 (17-Aug-2009)
Changed clear status columns to work for a selection
Version 1.1.44 (28-Jul-2009)
Added new validator for Supply Locator
Version 1.1.43 (24-Jul-2009)
Changed default validate column to FLEX_COMBINATION fromFLEX_VALUE
Version 1.1.42 (22-Jul-2009)
Fixed problems with Supply Locator and Subinventory on update
Version 1.1.41 (7-Jul-2009)
DFF's not showing up when you select them in the customize columns form.Fixed DFF record sheets as they had corrupt data.
Version 1.0.40 (4-Jul-2009)
Added Support for multi segment item key flexfield Fixes
Fixes Issue where costing enabled causing wizard to error
Fixes Issue where descriptive flexfield ID's rather than values are downloaded
Fixes issue R12 concurrent program when running the item import
Stops the wizard updating a category within a category set if that category value doesn't change during an update.
Note: v1.0.31-39 included internal updates not released to users
Version 1.0.40 (4-Jul-2009)
Added Support for multi segment item key flexfield Fixes
Fixes Issue where costing enabled causing wizard to error
Fixes Issue where descriptive flexfield ID's rather than values are downloaded
Fixes issue R12 concurrent program when running the item import
Stops the wizard updating a category within a category set if that category value doesn't change during an update.
Note: v1.0.31-39 included internal updates not released to users
Version 1.0.30 (08-Jun-2009)
Re-Fixed concurrent request to work with r12 parameters.
Version 1.0.29 (07-Jun-2009)
Fixed concurrent request to work with r12 parameters
Version 1.0.28 (06-Jun-2009)
Updated concurrent request to work with r12 parameters
Version 1.0.27 (25-May-2009)
Removed carriage returns from sql. Updated download for concatenated segments.
Version 1.0.26 (24-May-2009)
Changed message when default value set to blank. Corrected Expense Account validation
Version 1.0.25 (12-May-2009)
Fixed problem with return column when uninitialized when refreshed
Version 1.0.24 (11-May-2009)
Fixed combination sql to work with Organization Chart Of Accounts ID
Version 1.0.23 (10-May-2009)
Made accounts dependent on Organization Chart Of Accounts ID
Version 1.0.22 (9-May-2009)
Corrected results return after reload
Version 1.0.21 (24-Apr-2009)
Updated Planning Time Fence list of values to MTL_TIME_FENCE
Version 1.0.20 (01-Apr-2009)
Fixed problems with catalogs
Version 1.0.19 (11-Mar-2009)
Added Application.ScreenUpdating = True for cursor refresh
Version 1.0.18 (10-Mar-2009)
Fixed problem with initialization of KFF and incorrect setting of Cancel Flag
Version 1.0.17 (03-Mar-2009)
Fixed changes in download where category columns absent from wizard
Version 1.0.16 (02-Mar-2009)
Changed required fields based on mode and master
Version 1.0.15 (11-Feb-2009)
Corrected problem with the Item ID being transferred from copied item
Version 1.0.14 (28-Jan-2009)
Updated message handler to retain copy from and template values
Version 1.0.13 (27-Jan-2009)
Added cell comment to column headers
Made interface id mandatory is section in use
Version 1.0.12 (21-Nov-2008)
Changed return result when id column not specified for a section.
Version 1.0.11 (11-Nov-2008)
Reintroduced load_counter lost with custom_install
Version 1.0.10 (07-Nov-2008)
Fixed problem with column reset
Version 1.0.9 (05-Nov-2008)
Fixed problem with child records not loading because status columns are no longer cell bound
Version 1.0.8 (04-Nov-2008)
Fixed problem with download and refresh functionality
Version 1.0.7 (03-Nov-2008)
Else values passed to interface table for processing.
Added an Apply button to activate the template and copy from fields
Throw error message if -999 returned as exception
Fixed problem with non cell bound columns not creating on a new sheet
Increased the download capability to include User Item Type, Item Status and Categories
Version 1.0.6 (07-Oct-2008)
Added support for status codes
Version 1.0.5 (06-Oct-2008)
Added support for profile defaults
Version 1.0.4 (17-Sep-2008)
Added ability to use ACCEPTED records to load child records
Added delete for interface table
Version 1.0.3 (05-Sep-2008)
Fixed issues with template not validating dependents
Version 1.0.2 (28-Aug-2008)
Fixed problem with Org and Item validation when value invalid
Version 1.0.1 (27-Aug-2008)
Fixed problem with form error when org not set
