Version 1.1.82 (12 July 2010)
Modified Price validation. Now allowing Amount Base Line Types to be 1 or empty.

Version 1.1.81 (7 July 2010)
Fixed bug where Key flex fields were failing to initialise caused by a language problem.

Version 1.1.80 (5 July 2010)
Changed validation of distributions Deliver_To_Location. Apostrophes in the Location Name would mean no values would be returned from the database. Changed it to use the proc that the other locations use.
Added back in 'Upload All Attachments'. Was unable to replicate previous upload issue.
Added new setup sheet.
Common modules upgraded to v128.
Fixed bug in the Line Quantity/Distributions Quantity check.  DistributionTotal was truncating the decimal values.

Version 1.1.79 (2 July 2010)
Removed 'Upload All Attachments' from toolbar. It needs to be fixed.

Version 1.1.78 (29 June 2010)    
Added a download progress form.

Version 1.1.77 (24 June 2010)
Added LOVs to download form. Added further error handling to try to pick up errors any download errors.

Version 1.1.76 (09 June 2010)
Download upgraded.
Fixed bug - Line Number was not being uploaded.
Price validation. Fixed bug where it was impossible to load a line with an AMOUNT based line type.
Fixed bug in refresh where a 500+ line purchase order would cause POs below not to be refreshed.

Version 1.1.75 (03 June 2010)
Fixed bug in Lines form which set continue_level = 3. Which then stopped the item query from returning data.

Version  1.1.74 (28 June 2010)
Fixed bug in interface distributions download sql.
Fixed bug where Line would not be uploaded when PO was being re-uploaded. This would only occur when the Line was not on the same row as the shipments.
Further fixes for big uploads.

Version 1.0.57 (9 December 2009)
Made changes to Purchase Order Number validation. Now looks at Purchasing Options and will let Alphanumerics through.
Adjusted toolbar positions with excel 2003.

Version 1.0.56 (23 November 2009)
Put a prepare_string around the location_code in modmain.get_deliver_to_location to remove morrisons bug with apostrophy in string.
Fixed bug where you would get an application error if the currency columns were removed from the wizard.
Added missing column 'Line Effective Date' to sheet1 and template.

Version 1.0.55 (10 November 2009)
Organization override re-added – because it was mistakenly removed.
Supplier override removed because it was not implemented - so it was misleading to have it available in the list.
Requestor added to download.
Added defaulting of distributions 'Deliver to Location' from the requestor.
Automatically generating line numbers if they are not provided.
Updated concurrent request viewer.

Version 1.0.54 (30 October 2009)
Item key flexfield modified. It was not bringing back values when used against some r12 instances.

Version 1.0.53 (29 October 2009)
Fixed bug where a distributions insert at the start of an accumulate block processblockdata call would not have the lineID and hence the block with fail with a ora-00936 error.

Version 1.0.52 (28 October 2009)
Added concurrent request viewer.
Changed item validation to work off the org_id from po_system_parameters rather than filtering on SOB.
Fixed bug where a distributions insert at the start of an accumulate block processblockdata call would not have the lineID and hence the block with fail with a ora-00936 error.

Version 1.0.51 (21 October 2009)
Added override tables for 'Blanket Approval Status' and 'Standard PO Approval Status'
Removed override tables that did not do anything - brought across from Requisition Wizard but never implemented.
Item kff added code to allow a one segment item kff to have a delimiter as part of the item text.
Added validation check for duplicate line numbers on upload.
Restricted Download Type LOV to Blanket and Standard only. It previously included all the PO Types ie Quotations, RFQs etc

Version 1.0.50 (24 September 2009)
Fixed r12 multi org bug where responsibility orgid was being used rather than the selected orgid.

Version 1.0.49 (27 August 2009)
Added global agreement and price limit columns

Version 1.0.48 (26 August 2009)
Item validation changed on line form. Validates on after update rather than needing to open the flexfield form. And, updates category, unit of measure and price accordingly.
Fixed bug where price was not being updated at times on line form.
Changed submit form to default to the buyer who is logged into the spreadsheet.

Version 1.0.47 (24 August 2009)
Removed defaulting of the Charge Account – now letting oracle default the values if they are not provided.

Version 1.0.46 (14 August 2009)
Added Line_type to context defaulting. Changed Context Defaulting to stop it using substitutions

Version 1.0.45 (22 July 2009)
Fixed bug where rate type and rate date were transposed in download
Added l.line order by clause to download
Fixed Exchange Rate Date bugs in Header form
Fixed upload validation for currency
Fixed download bug where alphanumeric PO Number cell value was set to 0
Fixed bug in attachment upload – the wizard was looking to see where line attachments section ended and hence would not upload if it was below other sections.
Fixed bug where the header attachments broke the delete messages for the line deletes.

Version 1.0.44 (21 July 2009)
Added Currency Columns to template sheet

Version 1.0.42 (13 July 2009)
Changes in package call for 11.5.9
Change order by clause in download selection

Version 1.0.41 (8 July 2009)
Added column Allow Price Override to lines section

Version 1.0.40 (2 July 2009)
Range delete bug fixed. Where 'Lines distributions' message would pop a lot.
Fixed 'effective date from' bug on header form. If there was no 'effective date to' then the 'expected date from' validation would error.
Date handling improvements.
Fixed bug where wizard would try to delete from the interface tables when IDs on the sheet were blank or not numeric.
Changes to the Batches form.  Disallowed submission of Blanket, Create Sourcing Rules and Incomplete. This was causing the Request to fail without returning any messages to the wizard.

Version 1.0.39 (5 June 2009)
Fixed tax code defaulting for r12

Version 1.0.38 (21 May 2009)
Key Flex upgraded to handle 14 segments