Version 4.1.20 (17-Jan-08)
Date format on download made consistent with forms

Version 4.1.19 (16-Jan-08)
Document Number field was left red on s/s by form if no value entered
Source Type field was red on form when Supplier defaults and nothing in LOV

Version 4.1.18 (14-Jan-08)
Attachments upload was not working. Upgraded module to support URL attachments
Upgraded About, Login, and URL setup forms

Version 4.1.17 (20-Dec-07)
Correct upload defaulting behavior for new Source Org functionality

Version 4.1.16 (17-Dec-07)
Non auto source sourcing - Upload and Form defaulting added for Source Org and Source Sub inventory
Fixed several form behavior issues with defaulting

Version 4.1.15 (11-Dec-07)
Was not writing default Source Org to spreadsheet if default used
The Destination type was not defaulting correctly if left blank on upload

Version 4.1.14 (10-Dec-07)
Fixed bug in Load_Default_Source_Type

Version 4.1.13 (12-Dec-07)
Stopped 555 errors being thrown in SourcingAttempt2 module

Version 4.1.12 (23-Nov-07)
Dave fixed auto sourcing. Needs to go in conjunction with new latest riw package - 1.0.14 22 Nov 2007

Version 4.1.11 (14-Nov-07)
Sourcing Document tidy up

Version 4.1.10 (9-Nov-07)
Sourcing Document Stuff attempt2

Version 4.1.9 (6-Nov-07)
Document Number was validating false when blank
Messaging changed for Document Number Search

Version 4.1.8 (23-Oct-07)
Various Lines form bugs fixed
Blank lines counter changed from 5000 to 15000 in Upload
Blank lines counter changed from 100 to 15000 in Refresh
Batch form was not retrieving column header positions
Fix made to Set Status for Excel 2007

Version 4.1.7 (7-Oct-07)
Update Lines form to read any Subinventory setting from the spreadsheet
Changes to help prevent toolbars locking
Stop Quantity defaulting to 1 for client customisation
Client wants the Source Type to default to Inventory for Items

Version 4.1.6 (26-Oct-07)
Blanket download had error in SQL
Further work on Auto Sourcing
Fixed bug where Organization Code was running some non related SQL in some cases

Version 4.1.5 (19-Oct-07)
Other downloads failed due to extra columns in requisition download
Function ResolveDocNumFromID was crashing when a blank value was passed as the POHeaderID

Version 4.1.4 (28-Sep-07)
Add columns Document Type, Document Number and Document Line
Hiding sourcing option on the toolbar for client customisation
Override tables form references to settings123 changed. An extra row inserted into the settings sheet caused it to be out of whack
The form was over writing the Deliver to Location with the Default Deliver to Location.
Download was requiring to start at row 11 instead of 10
Customisation to force Expense as default Dest Type for client customisation in Item form and Upload
Form was not resetting default Dest Type on load to Expense
Added sourcing columns to requisition download

Version 4.1.3 (20-Sep-07)
Removed caching of Destination_Locations. Changed Location on lines form to long list of values
Header DFFs were not writing to row 6
Stopped Lines and Dist DFF forms from loading on rows prior to row 10
Customisations added for client customisation
Fix for Excel formatting numerics > 11 in length in scientific format
Double-clicking in row 10 did not load forms

Version 4.1.2 (10-Sep-07)
Fixed shading issue with enforces sourcing in the requisition lines.

Version 4.1.1 (10-Sep-07)
Fix for DFF Context validation failing if invalid. Invalid Contexts should be ignored

Version 4.1.0 (9-Sep-07)
Updated version to 4.1 due to huge change in functionality with internal req's now supported
Fixed bug when sourcing from supplier only returning the supplier code, not the source document

Version 4.0.9 (23-Aug-07)
Fixed issue in uploader, where source type was not the correct format. Updated type mismatch issue when collecting data from a cell. Fixed issue when checking source organization_id > 0 to <> ""

Version 4.0.8 (23-Aug-07)
Updated code around default source type, now use load_default_source type in form and in upload code
Added internal order functionality.

Version 4.0.7 (6-Aug-07)
DFF fix for Profile options embedded in Value Set SQL
Key Flexfield form was not handling Profile Options in Value Set SQL
Autosource now returns Currency and Unit of Measure. Requires Package Body version 1.2.6
Right trim values for free form text DFF segments

Version 4.0.6 (24-Jul-07)
Changed Load Counter method so Profile option is only written to for trial version customers
Enforce 150 character maximum on DFF segments with no value set
Apply licence key control to Validate function

Version 4.0.5 (10-Jul-07)
Fix for DFF functionality not properly initialised

Version 4.0.4 (9-Jul-07)
VBA Protection entirely automated. Use Excel Protection from Excel menu - Tools / Protection

Version 4.0.3 (5-Jul-07)
Flexfield form was not enabling Ok button in certain circumstances
Flexfield form was not indicating when search required once criteria entered

Version 4.0.2 (20-Jun-07)
Fix for Dependant value sets in Key Flexfield form
DFF form fields are now disabled where columns are not available on the spreadsheet

Version 4.0.1 (18-Jun-07)
Fix for Language issue in LOV SQL for Attachment Categories
Further DFF and Flex form improvements - Fix for SSO login bug in 4.0.0

Version 4.0.0 (11-Jun-07)
Single Sign-On support added

Version 3.5.0 (5-Jun-07)
DFF and Flex modules upgraded
This and future versions will NOT operate in Excel 97
Minor enhancement to About form to show logged in Responsibility

Version 3.4.8 (27-Apr-07)
Distributions form LOV for Tasks was not showing Task Name

Version 3.4.07 (20-Apr-07)
Minor fix to Header form where no Forward-to change allowed
URLEncoding added to handle special characters passed in SQL bind parameters

Version 3.4.06 (12-Apr-07)
Fix to Item validation issue introduced in 3.4.05

Version 3.4.05 (28-Mar-07)
Multi language fix for SQL Bind variable technique. Requires M4APS_XML package body 3.0.08

Version 3.4.04 (27-Mar-07)
Bug in download of quotations, where it was not selecting the correct lines
Bug in download of quotations, where missing categories segments
Bug in download, incorrect category alias
Fix for timeout problem caused by Internet Explorer 7
Added search button to forward to person - it used to be cached

Version 3.4.03 (6-Mar-07)
AutoSource check in Lines form was unnecessarily clearing Supplier and Tax Code LOVs
Tolerate missing port number in login URL (for 8000 default)
Better error handling for invalid URL setup
Some minor DFF form settings were not complete
Added SQL Bind variable technique to improve performance of Item validation

Version 3.4.02 (13-Feb-07)
Performance issue for Approved Supplier List. Tightened up query to use more than 1 index
Fixed issue where returning values from iproc cleared out the supplier site
Changed download to verify if document exists, so the user doesn't have to press the button to check to the document number

Version 3.4.01 (12-Feb-07)
Made change to iproc download to verify the Approved supplier list supplier is 'approved'

Version 3.4.00 (10-Feb-07)
Added in functionality to download quotations and planned purchase orders

Version 3.3.03 (30-Jan-07)
Fixes for no value sets in Key Flexfield segments

Version 3.3.02 (23-Jan-07)
Fix for Flex form not behaving properly for non validated value sets like Item since 3.0.00
Multi-language fix in DFF module
Fix for DFF validation bug introduced in 3.0.01

Version 3.3.01 (18-Jan-07)
Lines form was not refreshing Source Org LOV after change to Inventory Source
Minor tidyup on the form fields for Source Type, Source Org, and Supplier LOVs
Distributions DFF column 2 was incorrectly mapped to column 1 on the spreadsheet
Use Line Attribute15 for linking to Spreadsheet Interface ID as Oracle does not provide a working reference back to the interface table
Was using Reference Num field for this purpose but users now wish to upload this column

Version 3.3.00 (11-Jan-07)
Major updates to DFF and Flex module
Minor fix to Show/Hide Template sheet form
Added Line level "Reference Num" column

Version 3.2.51 (10-Jan-07)
In the lines form, added check box to only return lines from approved suppliers
Added Suggested Vendor/Site/Contact and Buyer columns for Template Download
Number of blank lines tested changed from 500 to 5000

Version 3.2.50 (25-Dec-06)
10g database was not being detected properly for non-ASCII character handling

Version 3.2.49 (18-Dec-06)
Handler added for errors caused by apostrophe character in filename
AutoSource was not called for Category based Lines
Stop closed Req Lines from being downloaded
Stop 'CLOSED' and 'FINALLY CLOSED' P.O. Lines from being downloaded

Version 3.2.48 (15-Dec-06)
Batch Submit form now remembers last settings for Grouping, List My Batches, Initiate Approval
Was not loading Supplier Item for Category based Lines
Was not downloading Suggested Supplier/Contact and Supplier Item details

Version 3.2.47 (13-Dec-06)
Call to Price Break procedure updated for changes in 11.5.10

Version 3.2.46 (13-Dec-06)
New Protection feature requires regular resetting otherwise it changes into Excel protection which stops the forms/upload operating

Version 3.2.45 (12-Dec-06)
Auto/Same feature was case sensitive. Changed to make it case insensitive
New AutoSource caching feature was not checking array size limit

Version 3.2.44 (8-Dec-06)
Fix for Invalid Type message when uploading or running form on non-Item Lines

Version 3.2.43 (6-Dec-06)
Added need-by-date parameter to AutoSource, required where Price Breaks depend on date
Requires package body version 1.2.3 but will still function as before with old package
Bug fix in AutoSource where form was passing Dest Org ID, not Dest Location ID
AutoSource results now cached to help form and upload performance (minor improvement)
Wrong value used for Inventory Org in form - Item validation was only working for Deliver-To Locations attached to a specific Org
Fixes for missing optional columns not handled in some cases
iProc search form was returning UOM code to Lines form, not user value
Added Protection form to RW Setup Toolbar

Version 3.2.42 (29-Nov-06)
Upgraded DFF module
Removed loop technique from create_toolbars

Version 3.2.41 (17-Nov-06)
Performance improvement to Item validation

Version 3.2.40 (11-Oct-06)
Fixed further problem with Forward-To LOV if no Req Type populated on form load

Version 3.2.39 (10-Oct-06)
Upgraded Descriptive Flexfield module
Added support for Table validated Value sets to Flex module
Added Profile Option install for Oracle on Demand sites
Forward to LOV was not populating on first load of Requisition Header form

Version 3.2.38 (2-Oct-06)
Destination Subinventory column was not being loaded
Allowed Lines with no Quantity to be ignored rather than cause an upload error

Version 3.2.37 (21-Sep-06)
Source Subinventory column added. No form or upload validation at this stage

Version 3.2.36 (19-Sep-06)
Added sourcing by Category

Version 3.2.35 (15-Sep-06)
Approver LOV was not loading in Header form when no supervisor hierarchies used

Version 3.2.34 (26-Aug-06)
Inactive Templates excluded from LOV in download form

Version 3.2.33 (25-Aug-06)
Changes to Approval and Forwarding to cope with no position hierarchy defined

Version 3.2.32 (16-Aug-06)
Was not loading Suggested Vendor for Non-Item based Lines
Item Source defaults were writing over any existing values on form load

Version 3.2.31 (28-Jul-06)
Flex form was not loading properly for missing or empty value sets
Was not resetting Flexfield config values before validating Item on form load

Version 3.2.30 (21-Jul-06)
Change to Approval Paths LOV SQL
Flex Combinations form fixed to allow for apostrophes in segment values
Stop Item validation from running when no Destination Organization selected
Attachment Categories LOV changed to multi-language view

Version 3.2.29 (19-Jul-06)
Handle configurations not using a Value Set for any Key Flexfield Segment
Note to Approver added to header and line
Calendar form changed to fix backspace bug
Two template sheets added - one for multi req sheets and on for single reqs per sheet
New form added for showing/hiding template sheets. Last setting cached for creating new sheets from template sheets
Fix to Replace97 procedure in case string being replaced has no length

Version 3.2.28 (23-Jun-06)
Handle configurations not using a Value Set for Items
Use standard search instead of Combinations button where there is only one Key Flexfield segment
Line level attachments added
Approval Path and Forward To Person added

Version 3.2.27 (25-May-06)
Allow for missing profile option PO: Legal Requisition Type
Allow for no default Line Type set in Purchasing Options
New user functionality to allow some columns to be set as mandatory/optional by the user
Special character handling function added to modXMLHTTP for 11.5.10CU2

Version 3.2.26 (20-Apr-06)
Changes to Sourcing to include Document Line number. Clear details if Supplier changed
Login change to allow space character in password
Enhancement to login form to better show HTML error messages
Distributions form was not writing Expenditure Item Date to sheet since Calendar change

Version 3.2.25 (10-Apr-06)
Login enhanced to allow non alphanumeric characters in password

Version 3.2.24 (24-Mar-06)
Missing Price column was not properly tolerated
Distribution Error Status was not beng recorded when Project number Invalid

Version 3.2.23 (15-Mar-06)
Fix to Calendar positioning for Excel 97

Version 3.2.22 (28-Jan-06)
MS-Office Calendar replaced with VBA calendar

Version 3.2.21 (25-Jan-06)
Fix to new Blanket P.O. download SQL for generated flexfield columns
Loop added to counter intermittant failure to show toolbars on startup
Minor tidy-up to Line and Distribution defaulting
Package was not compiling in releases prior to 11.5.9

Version 3.2.20 (24-Jan-06)
Changed lines form to always default qty to 1
Updated bug with sourcing rules where supplier not clearing and partial sourcing option causing supplier site error

Version 3.2.19 (18-Jan-06)
Exclude Releases from P.O. download

Version 3.2.18 (17-Jan-06)
Was erroring line where no default Inventory Item price even if price is on datasheet
Handle blank lines between distributions
Was not recognising subsequent partial Lines when looping through Distributions
Was not writing error messages to error columns for failures in 'Build' procedures
Build Lines procedure was not handling "CALC" auto-calc feature

Version 3.2.17 (6-Jan-06)
Errored Location Codes were being overwritten with the default after failure
Allow Destination Org to default from Location during Upload if value missing

Version 3.2.16 (23-Nov-05)
Further fix in download form for numeric to value conversion error
Flexfield format was not swapping properly between Item and Category

Version 3.2.15 (19-Nov-05)
Fix in download form for numeric to value conversion error

Version 3.2.14 (18-Nov-05)
Price defaulting in form required fix as a result of the UOM conversion changes
Calendar object switched to late binding method
Fix for 9th Segment on Flexfield form not working
Stop Login procedure from looping if M4APS_XML not installed

Version 3.2.13 (10-Nov-05)
Stop UOM conversion call when Item is changed

Version 3.2.12 (5-Nov-05)
Stop UOM conversion call when there is no change in UOM or no item id
Lines form now getting an updated UOM (based on class and inter item uom conv) from item when item is selected
Additionally allow all UOMS when no inventory item is selected when first opening lines form
Stop Quantity from clearing - fix error colour not clearing for UOM

Version 3.2.11 (21-Oct-05)
Fix to price treatment during upload

Version 3.2.10 (18-Oct-05)
Form was not defaulting Price correctly. Remove redundant AutoSource calls in Lines form

Version 3.2.09 (14-Oct-05)
New DFF button and Override Tax profiles enhancements not working

Version 3.2.08 (12-Oct-05)
Fixed Get Buyer issue, re-enabled Autosource call in AfterItem
Use Tax: Allow Override of Tax Code profile option to control Tax code functionality

Version 3.2.07 (10-Oct-05)
Stop DFF buttons from displaying on toolbar if none configured

Version 3.2.06 (10-Oct-05)
Added price break functionality for unit prices and sourcing
Added sourcing functionality to allow no sourcing, full sourcing and partial sourcing
Partial sourcing defaults supplier, supplier site, supplier item and contact information. It also will default the unit price if the user has not entered one.
Full sourcing will return values and replace those entered by the user.
The interface does not use user entered values when sourcing = full sourcing ("Y")

Version 3.2.05 (6-Oct-05)
Suggested Quantity column only exists from 11.5.10
Fix bug stopping download if Header Description cell missing
Improvements to text/number cell formatting for values with trailing zeros or decimals

Version 3.2.04 (3-Oct-05)
Improvements to text/number cell formatting for values with leading zeros
Change to icx_por_categories_vl from icx_cat_categories_tl in iProc Catalog search
Was not providing the usual Yes/No/Cancel options if Key Item/Category/Quantity values missing
Item validation Error message was not being written to the worksheet
Include Suggested Quantity in the Template Download

Version 3.2.03 (23-Sep-05)
Added option on download form to overwrite existing lines
Changed column naming convention for Line level DFFs
Minor performance improvement for download form

Version 3.2.02 (19-Sep-05)
Fix for Default inventory org not defaulting correctly
Updated frmlines LoadDestOrganization, now it will query the Inventory Org
Fix to stop new Batch ID being retrieved when in validate only mode or nothing to upload
Added search criteria to Named User maintenance form
Added error messages if Quantity populated but not mandatoy Item or Category values

Version 3.2.01 (19-Sep-05)
Enhancements to iProc search for multi-language support

Version 3.2.00 (25-Aug-05)
Added in iprocurement functionality. Updated Main Lines form to include iproc array and supplier item field
Created new tab in Lines form for iProc searching
Created new Search Results form to review iProcurement searches

Version 3.1.02 (17-Aug-05)
Added Header level Note to Buyer
Position of all header columns now flexible
New sample sheets

Version 3.1.01 (12-Aug-05)
Added User Override for Destination Types

Version 3.1.00 (09-Aug-05)
Further fix for Caching Org/Locations not working prior to 11.5.8
Was not using Session ID login method added in 3.0.25
Switched XML object from Fixed Reference to Late Binding

Version 3.0.29 (04-Aug-05)
Expired users removed from Named User form
Fix for issues in AUTO / SAME Req numbering feature
Minor change to Refresh feature to re-display Pending status
Refresh feature was missing last returned Req Number

Version 3.0.28 (03-Aug-05)
Fix for Caching Org/Locations not working prior to 11.5.6, plus a performance improvement
Fix for certain DFF Value sets containing $Profiles$: and IN statements

Version 3.0.27 (27-Jul-05)
Stop repeated DFF configuration caching when no columns defined

Version 3.0.26 (14-Jul-05)
Note to Buyer field added

Version 3.0.25 (07-Jul-05)
Fix for MLS code change affecting procedure calls including apostrophe characters
Support new login validation method

Version 3.0.24 (01-Jul-05)
Added 'List My Batches Only' button to Batches form
Stopped word wrapping in Error columns
Refresh function enhanced to show Req Numbers for multiple Reqs per sheet
Added test for Concurrent Request status into Refresh function

Version 3.0.23 (22-Jun-05)
Fix Dff reference field issue
Tune Caching SQL for Organisations / Locations

Version 3.0.22 (14-Jun-05)
Fix bug in frmDFF using A_ValueSet instead of rsFlex array
Array counter fix to Get_Buyer_ID proc

Version 3.0.21 (03-Jun-05)
Fix to Refresh batches
Was not using Item Price default if column was missing from spreadsheet
Added feature allowing automatic Req numbering in the spreadsheet. New AUTO and SAME special values
MLS views used for multi-language Flex Value Sets
Support for all languages added
Updates to DFF module
Reference Number used to better display new Req numbers for Imported Lines in Refresh

Version 3.0.20 (20-May-05)
Change to Group By parameter passed to Req Import concurrent program

Version 3.0.19 (17-May-05)
Allow for HR_LOCATIONS_ALL_VL view not available until 11.5.9 or HR Family Pack E

Version 3.0.18 (12-May-05)
Download was duplicating Requisition Lines where multiple languages used

Version 3.0.17 (9-May-05)
Bug Fix in DFF module for non-validated value sets

Version 3.0.16 (4-May-05)
Translate Value set IDs to values for DFF

Version 3.0.15 (29-Apr-05)
Handle missing column errors in lines form and during upload
Fix Lines form to load defaults and disable columns when not on sheet
Re-design DeleteBatch procedure
Fix for Destination Organisation not defaulting for first line uploaded
Stop Destination Organisation from clearing on form if Item on sheet

Version 3.0.14 (26-Apr-05)
Removed Batch ID join from Refresh function
Enhancements to Batch header form to describe existing batches
Fix Range selection for Delete and Upload
Add Delete Batch button on Batches form, handle ' character in DFF fields
Change from P to N for AUTOSOURCE_FLAG column
Clear AutoSource defaulted Supplier Site and Contact if user changes suggested supplier

Version 3.0.13 (19-Apr-05)
Support Profile Option in DFF Context Reference field
Move Flex sql procedure from server to VBA
Improvements to DFF module

Version 3.0.12 (07-Apr-05)
Fix to Requisition Number using correct request id

Version 3.0.11 (31-Mar-05)
Fix for problem retaining Digital Certificate

Version 3.0.10 (29-Mar-05)
Mods to precision for foreign currency price

Version 3.0.09 (29-Mar-05)
Allow DFF module to process or reference IDs when required

Version 3.0.08 (24-Mar-05)
Correction for local currency price calculation
Hide login configuration toolbar unless Setup toolbar shown
Stop rounding converted price to foreign currency precision. Allow 7 digits
Invert loaded exchange rate to be consistent with Requisition Summary form

Version 3.0.07 (21-Mar-05)
Allow Exchange Rate column to be deleted when not required

Version 3.0.06 (18-Mar-05)
Fix key flex bug and default rates when not in sheet during upload

Version 3.0.05 (16-Mar-05)
Support Profile defaults in Key Flexfield segments

Version 3.0.04 (15-Mar-05)
Complete foreign currency unit price calculation feature
Change to Overridetable feature
Cancelling upload after error was not stopping process

Version 3.0.03 (14-Mar-05)
Calculate currencies using rates from tables

Version 3.0.02 (10-Mar-05)
Correct error messages, check for for missing columns, do not re-validate line when already uploaded, Reject line if qty is zero
Make all distrib colums optional
Use mtl_system_items_b base table instead of view

Version 3.0.01 (02-Mar-05)
Add currency tab to Lines form, load org_id from location info for Item validation
Fix for European decimal point character not being handled properly
Removed constraint on non-ascii characters

Version 3.0.00 (24-Feb-05)
Add new dynamic DFF functionality, use ad_sessions_s.nextval for batch ID

Version 2.1.28 (08-Feb-05)
Fix bug: same sequence id in distrib table table id when subsequent block upload

Version 2.1.27 (04-Feb-05)
Remove prepare_string func for l_description,Category flexarray bug fix
move cursor with validate, delete, etc s/s scroll events

Version 2.1.26 (02-Feb-05)
Named user licence key model implemented

Version 2.1.25 (29-Jan-05)
Add Buyer column and use fnd_profile proc instead of m4aps_xml.get_apps_profile
Improve error messages

Version 2.1.24 (21-Jan-05)
Add get profile function to flex module, fix line type default error

Version 2.1.23 (27-Jan-05)
Added new Req Number column

Version 2.1.22 (27-Jan-05)
Add error msg when no item selected and item desc blank, error msg when no line amount but category or item exist
Added option on RW Setup toolbar to hide permanently

Version 2.1.21 (26-Jan-05)
Minor form bug fix

Version 2.1.20 (24-Jan-05)
Fix bug for incorrect total dist when first dist row is blank

Version 2.1.19 (21-Jan-05)
Req search for download was not picking up Reqs with a null description Allow INCOMPLETE Requisitions to be searched and downloaded Allow download if Number or Description criteria populated

Version 2.1.18 (14-Jan-05)
Add option to delete lines by selecting a range

Version 2.1.17 (11-Jan-05)
Bug fix for default Category from Item selection using same DB call
Clear Item Desc if update not allowed

Version 2.1.16 (10-Jan-05)
Remove calls in Description_Change(frmLines) proc, download tax_code and not tax_id
Fix destination type LOV bug where list not refreshed with Inventory
item after non-inventory selection on frmLines, Search criteria in frmFlex
Requisition Status override option
Cache Destination Org and Deliver to Location dependant LOVs
Add ability to search downloads by LOV columns available
Add default distribution qty
Recall download prior settings form
Add Supplier & Site for PO download
Improve no line amt message
Check if Exp Item date required during upload
Check if need by required during upload
Reduce DB calls and load into arrays where possible to further improve speed

Version 2.1.15 (11-Nov-04)
Added Billable flag to Workflow call for Capitalisable transactions

Version 2.1.14 (10-Nov-04)
Correction to Account defaulting for Source = Inventory

Version 2.1.13 (01-Nov-04)
Stop operation if user not setup with an employee

Version 2.1.12 (21-Oct-04)
First release. Built on R11i 11.5.8 and 11.5.9