Version 1.6.8 28-Jun-2010 Fixed issue with setting status into the wrong column for transaction ids Fixedsetting 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. Version 1.6.7 05-Jun-2010 Updated Common Modules and common mfg modules Fixed issue where Avg element errors not updating cell colours Version 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 Version 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. Version 1.6.4 15-Jan-2010 Changed Get Item details to check to see if lookup type MSC_ATP_COMPONENTS_FLAG exists Version 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 Version 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. Version 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 Version 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 effectivily. 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. Version 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 wouldnt load second row of item transactions. Fixed issue where invalid UOM stopping user from using the transaction lines form. Version 1.5.1 7-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 Version 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 Version 1.4.4 23-Apr-2009 Updated Generic Modules, - fixed initialise issue. Updated to make Generic module ICWgenSupport for item cost wizard Applied InvSupport module v1.1 Version 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 Version 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 Version 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. Version 1.4.0 5-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 Version 1.3.0 4-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 Version 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. Version 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. Version 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 Version 1.0.4 22-Apr-2008 Changed item details record set to incl locator id and account id, Version 1.0.3 21-Apr-2008 Fixed problem with dates forward dating transaction updated get_system_date Version 1.0.2 13-Apr-2008 Fixed issues with UOM not loading in form correctly Version 1.0.1 9-Apr-2008 Fixed issue with locator sql missing = sign for non restricted locators Version 1.0.0 6-Apr-2008 Initial version