1.4.31 (14-Apr-2025)

Enhanced the Wizard.

1.4.30 (11-Apr-2025)

Default Browser Login and enhanced the Wizard.

1.4.29 (27-Mar-2025)

Updated Supplier Name/Number to return correct records for an 'Inventory' Receipt Source.

1.4.28 (27-Mar-2025)

Updated Supplier Name/Number to return correct records for an 'Organization' Receipt Source.

1.4.27 (26-Mar-2025)

Corrected error in Supplier Name search.

1.4.26 (26-Mar-2025)

Restricted Supplier Name/Number dependent on Receipt Source.

1.4.25 (08-Oct-2024)

Added Default Browser Login option.

1.4.24 (22-Nov-2023)

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

1.4.23 (03-Oct-2023)

Added new Digital Signature.

1.4.22 (30-Aug-2023)

Fixed issue where shipment quantities were downloaded instead of distribution quantities.

1.4.21 (26-Jul-2023)

Internal update.

1.4.20 (05-Jul-2023)

Internal update.

1.4.19 (20-Apr-2023)

Fixed Error 5 when double-clicking on a non-Wizard sheet.

1.4.18 (19-Apr-2023)

Fixed incorrect Wizard name in the setup sheet.

1.4.17 (13-Mar-2023)

Fixed issue that caused large uploads to unexpectedly fail with error "438(Object doesn't support)".
Removed unsecure document links.
Fixed issue where enabling end to end trace did not generate the trace.

1.4.16 (02-Sep-2022)

Internal update.

1.4.15 (06-Sep-2022)

Updated licensing modules.

1.4.14 (16-Aug-2022)

Fixed Error 6 (Overflow) in procedure GetGroupIDs of Module Refresh when running Concurrent Refresh process.

1.4.13 (02-Aug-2022)

Fixed "Shipment Number already exists" error when creating receipts.

1.4.12 (27-Jul-2022)

Fixed Error 13 (Type mismatch) when attempting to create a receipt if the Shipment Number was blank.

1.4.11 (27-Jul-2022)

Fixed multiple errors that were preventing inspect on Internal Orders.

1.4.10 (20-Jul-2022)

Fixed Type mismatch error when validating Shipped Date if the receipt date was blank or invalid.

1.4.09 (20-Jul-2022)

'Update' process option has been removed as per functional request.

1.4.08 (20-Jul-2022)

Fixed incorrect validation resulting in 'You cannot enter a shipped date that is later than the receipt date'.

1.4.07 (12-Jul-2022)

Fixed "Fatal error in concurrent program" when refreshing successful ASN Shipment transactions.

1.4.06 (11-Jul-2022)

Internal update.
Change spelling of Normalise and Denormalise to Normalize and Denormalize in the ribbon buttons.

1.4.05 (08-Jul-2022)

Internal update.

1.4.04 (07-Jun-2022)

Fixed "Fatal error in concurrent program" when refreshing successful Return transactions.

1.4.03 (25-May-2022)

Fixed issue where the wrong Source Organization would download for Internal Order download source.

1.4.02 (01-Apr-2022)

Internal update.

1.4.01 (30-Mar-2022)

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

1.4.00 (21-Jan-2022)

Updated custom Query including:
- Added Not Equals Operator on the Download form.
- Values with single quotes will now download correctly on the sheet.
- Removed ability to free type into the query box within the Download form.
- Removed functionality to save and default the Last used query parameters on the Download form.

1.3.36 (10-Jan-2021)

Fixed issue where the wrong Source Organization would download.

1.3.35 (05-Nov-2021)

Fixed error when validating when Item column is not on the sheet.

1.3.34 (20-Oct-2021)

Improved the performance of Refresh.

1.3.33 (09-Aug-2021)

Internal update.

1.3.32 (14-Jun-2021)

Fixed multiple issues when removing mandatory columns from the sheet (e.g. Interface Id or Inventory Org).

1.3.31 (08-Jun-2021)

Fixed another error when uploading if Interface ID is removed from the sheet.

1.3.30 (08-Jun-2021)

Fixed errors when Validating/Uploading when Interface ID or Inventory Org are removed form the sheet.

1.3.29 (01-Jun-2021)

Fixed issue with Locator LOV.

1.3.28 (12-May-2021)

'LOT Expiration Date does not match the value in the system' message will no longer display for Receive transactions.

1.3.27 (11-May-2021)

Transaction Date download form filters now working correctly.

1.3.26 (03-May-2021)

Fixed error when download from interface.

1.3.25 (03-May-2021)

Updated security.

1.3.24 (30-Apr-2021)

Fixed issue where quantity values defaulted from row 10 would not upload.

1.3.23 (27-Apr-2021)

Fixed error when deleting Template123 and then clicking 'Edit Template'.
Fixed error 9999 when uploading without a Supplier and PO.

1.3.22 (09-Apr-2021)

Fixed download for 'Lot Origination Date' and 'Lot Secondary Quantity'.

1.3.21 (07-Apr-2021)

Added new columns 'Lot Origination Date' and 'Lot Secondary Quantity'.

1.3.20 (19-Mar-2021)

Fixed issue with the calendar form when using Chinese language.

1.3.19 (08-Jan-2021)

Corrected SQL issue that prevented some internal order records from downloading.

1.3.18 (19-Nov-2020)

Fixed issue where headers would not refresh correctly in 11i.

1.3.17 (19-Nov-2020)

Fixed issue where successfully loaded shipments would return a false error status on refresh.

1.3.16 (19-Nov-2020)

Fixed issue where successfully loaded shipments would return a false error status on refresh.

1.3.15 (19-Nov-2020)

Fixed issue where error messages were not correctly returned from the concurrent program in some situations.

1.3.14 (03-Nov-2020)

The Locator LOV is now dependent on the Project and Task from the PO Distribution (if there is one).

1.3.13 (28-Oct-2020)

The Locator LOV should now be restricted to only valid values.

1.3.12 (27-Oct-2020)

Serial/Lot information is now only required for Transaction Type: Receive with Receipt Routing: Direct Delivery or Transaction Type: Deliver.

1.3.11 (27-Oct-2020)

Fixed "Fatal error in concurrent program" message when refreshing pending transactions.

1.3.10 (20-Oct-2020)

Added required Shipping Date validation for ASN Type 'ASN'.

1.3.09 (20-Oct-2020)

Fixed issue where Lot Number and Serial Number were incorrectly marked required for Receipts.

1.3.08 (06-Oct-2020)

Fixed issue where you could not download receiving transaction data for internal orders.

1.3.07 (16-Sep-2020)

Added download form filter "Transaction Type”.
When doing a Deliver transaction type, it's no longer necessary to copy the transaction ID to the Parent Transaction ID column.’

1.3.06 (15-Sep-2020)

Fixed issue where locators would not validate correctly when using project manufacturing or when more than 1000 exist for the org and subinventory.
Basic implementation of Lot DFF.

1.3.05 (03-Sep-2020)

Lot Expiration Date now downloads and is not validated against Deliver, Accept and Receive Transaction Types.
Quantity is now downloaded when using download source "Receipt".

1.3.04 (31-Aug-2020)

Lot Expiration Date is now validated correctly against the date in the system.

1.3.03 (27-Aug-2020)

Sales Order Number and Line will now only be validated and uploaded when the Receipt Source is 'Customer'.

1.3.02 (27-Aug-2020)

Fixed error in ValidatorLOTNumber when the expiration date in the database was not a valid format - now throws a warning instead.

1.3.01 (27-Aug-2020)

Receipt download - Parent Line Id will now be populated with the transaction_id if the parent_transaction_id is null.
Exchange Type, Exchange Date and Exchange Rate are now Display Only because they are not used in the upload.
ImplementationLines - Added new function InitialiseCurrencyColumns_Basic which sets up the exchange columns as display only.

1.3.00 (26-Aug-2020)

Fixed CURRENCY error when download with some of the download source options.

1.2.99 (26-Aug-2020)

Added Process Option 'Inspect' which allows the transaction types Accept and Reject.

1.2.98 (20-Aug-2020)

Exchange Date now downloads in the correct format.

1.2.97 (20-Aug-2020)

Exchange Type, Date and Rate now download for foreign currency PO’s.

1.2.96 (20-Aug-2020)

Receipt Source column is now mandatory to avoid error: "RVTSH-189: Subroutine rvtshiline() returned error”.
Fixed incorrect "Transaction Type must have a value" error when opening the form.

1.2.95 (13-Jul-2020)

Fixed error when Currency Code was removed from the sheet, but Exchange columns were left on.

1.2.94 (15-Jun-2020)

Fixed "column ambiguously defined" error when searching for Deliver to Location in the Download form.

1.2.93 (15-May-2020)

Fixed timeout when validating the PO Line Number.

1.2.92 (14-May-2020)

Fixed bad request error when doing bulk uploads in 11i.

1.2.91 (05-May-2020)

Updated security.

1.2.90 (20-Apr-2020)

Fixed error when performing returns.
Error: PL SQL Exception: Line *#~EXCEPTION=-936 ORA-00936: missing expression [section line].

1.2.89 (03-Apr-2020)

Image on Template 123 is now named 'CustomLogo' instead of 'Picture 1' and custom logos must also be named 'CustomLogo.

1.2.88 (02-Apr-2020)

Fixed issues with colours on example sheets and Template123.

1.2.87 (19-Mar-2020)

Updated colour scheme.

1.2.86 (16-Jan-2020)

Fixed error when downloading when database version is less than 11.2

1.2.85 (21-Nov-2019)

Major update for Common, Core and Custom Query. Firewall compliant encoding added.

1.2.84 (11-Nov-2019)

Updated security.

1.2.83 (19-Jul-2019)

Fixed error where 'Validate Only' was uploading and 'Validate and Upload' was only validating.

1.2.82 (28-Jun-2019)

Internal fixes.

1.2.81 (24-Jun-2019)

Fixed error where the processing form was being shown multiple times when downloading using sheet data on a large number of criteria.

1.2.80 (20-Jun-2019)

Infrastructure update.

1.2.79 (17-Jun-2019)

Rebranding of logo and new colour scheme.

1.2.78 (22-Mar-2019)

Added Quantity Received, Quantity Billed and Quantity Cancelled display only columns.

1.2.77 (05-Mar-2019)

Fixed upload error when attempting to upload a Return transaction.

1.2.76 (28-Feb-2019)

Fixed error when opening the Download form and also when opening the Lines form.

1.2.75 (27-Feb-2019)

Added functionality to filter off the PO Line Number when download via sheet.

1.2.74 (05-Feb-2019)

Removed query hints from the download as these should not be needed.

1.2.73 (01-Feb-2019)

Fixed upload error when attempting to Correct a 'Deliver' transaction.

1.2.72 (31-Jan-2019)

Fixed error on the Download form as 'Release Number To' was not being respected.

1.2.71 (25-Jan-2019)

Fixed validation error when validating the Exchange Rate column.

1.2.70 (04-Jan-2019)

Improved Corrections download performance.

1.2.69 (10-Dec-2018)

Fixed upload error when uploading serial numbers without the Lot Number column on the sheet.

1.2.68 (30-Oct-2018)

Fixed download error as the progress bar would display an incorrect percentage.

1.2.67 (11-Oct-2018)

Updated security.

1.2.66 (04-Sep-2018)

Updated security.

1.2.65 (19-Jul-2018)

Fixed error where changes to the Lot Quantity were not being saved back to the sheet.

1.2.64 (18-Jul-2018)

Fixed upload error where errored cells colours were getting reset.

1.2.63 (17-Jul-2018)

Fixed upload error where a message box was getting shown with no message.

1.2.62 (17-Jul-2018)

Fixed error where the Interface download would download into the row 10 default row.

1.2.61 (12-Jul-2018)

Fixed required Serial Lot validation as this doesn't apply when receiving a Standard Receipt.

1.2.60 (12-Jul-2018)

Added to make the Serial Lot section required when an Item is Serial or Lot controlled.

1.2.59 (11-Jul-2018)

Added validation so that Transaction Types other than Receive or Deliver cannot have a Subinventory.

1.2.58 (11-Jul-2018)

Fixed error when attempting an upload.

1.2.57 (10-Jul-2018)

Fixed error when creating an ASN as the Shipment Number was not required.
Fixed error when creating a receipt with a required Subinventory as was incorrectly being set to invalid.
Fixed error where required fields were not being set invalid when clicking OK on the form.
Fixed error where Serial Lot Interface IDs were being downloaded when no Serial Lot information existed.
Added validation to make sure the total Lot Quantities match the line quantity.

1.2.56 (26-Jun-2018)

Custom Query updated to version 1.1.08

1.2.55 (15-Jun-2018)

Added validation to the Subinventory column as was previously incorrect.

1.2.54 (07-Jun-2018)

Changed Container Number validation to allow non-numeric characters.

1.2.53 (10-May-2018)

Removed error message when attempting to default the quantity.

1.2.52 (08-May-2018)

Fixed error where the Status bar was being cut off in the form on Windows 10.

1.2.51 (02-Apr-2018)

Added functionality to create receipts based on Inter-Organization Transfers.

1.2.50 (10-Apr-2018)

Fixed error on the Refresh where rows below row 500 were not getting refreshed correctly.

1.2.49 (05-Mar-2018)

Updated Security.

1.2.48 (02-Mar-2018)

Fixed error where the Deliver To Location LOV was not being populated.

1.2.47 (01-Mar-2018)

Made the Ship To Location not mandatory as it not needed in some situations.
Added defaulting to the Deliver To Location field based on the PO Distribution.

1.2.46 (28-Feb-2018)

Fixed error with the Submit Concurrent Program as no values were being brought up in the LOV.

1.2.45 (05-Feb-2018)

Fixed error where the Wizard was downloading the Receipts out of order.

1.2.44 (31-Jan-2018)

Fixed error when downloading receipts in 64 bit excel.

1.2.43 (13-Dec-2017)

Added validation the Wizard. Now checks to make sure the number of Serial Numbers match the line quantity.

1.2.42 (30-Oct-2017)

Added Need by Date Display only column.
Changed the sheet colour for the Order Quantity column as this is Display Only.

1.2.41 (20-Oct-2017)

Fixed error when loading the form on the child section in 64 bit excel.

1.2.40 (18-Oct-2017)

Fixed spelling error in the Transaction Type validation.

1.2.39 (09-Oct-2017)

Upgraded Core to 213.1 from 212.5
This fixes EBS 11i connection issues caused by Core 212.5

1.2.38 (06-Oct-2017)

Fix for upload issue cause SQL Error: PL SQL Exception :Lines*11~EXCEPTION=-1400 ORA-01400: cannot insert NULL into "PO"."RCV_TRANSACTIONS_INTERFACE"."TRANSACTION_DATE") [section Lines]'.

1.2.37 (05-Oct-2017)

Changed the Corrections download to download the ship_to_location from the receiving transactions ship_to_location as corrections doesn’t seem to have a concept of ship_to_location - but the wizard/interface requires it for upload. Download returns wrong Ship To Location.

1.2.36 (26-Sep-2017)

Fixed upload error where the Subinventory was being loaded when doing a Deliver transaction.
Fixed validation error with the Revision as was incorrectly erroring.
Changed Download. Transaction dates now can’t be downloaded.

1.2.35 (14-Sep-2017)

Changed the Deliver To Location Validation. Now makes it required if the Transaction Type is 'Deliver' or the Receipt Routing is 'Direct Delivery'.
Fixed error with the refresh when creating an ASN.
Changed validation on the Serial/Lot Section as was erroring when returning to supplier.
Changed the Upload to use the Parent Line ID rather than the Transaction ID.

1.2.34 (07-Sep-2017)

Fixed error in the refresh where it was incorrectly erroring line records.

1.2.33 (07-Sep-2017)

Made the PO Line column mandatory on the sheet.

1.2.32 (06-Sep-2017)

Made the Deliver To Location column larger on the form.

1.2.31 (06-Sep-2017)

Made the PO Number mandatory on the sheet.

1.2.30 (05-Sep-2017)

Fixed error where the Refresh was refreshing the whole sheet which was changing Accepted to Error.

1.2.29 (01-Sep-2017)

Fixed error where the Lot/Serial Number fields were being set to invalid with no data in them.
Fixed error where the Quantities were not being derived correctly for all lines.

1.2.28 (31-Aug-2017)

Fixed error as the wrong value was being uploaded into the CREATED_BY column at the Line level.

1.2.27 (22-Aug-2017)

Made the Receipt Number not required if we are doing a Create.
Made the Deliver to Location and Ship to Location columns mandatory on the sheet.

1.2.26 (10-Aug-2017)

Made the Receipt Number mandatory on the sheet.

1.2.25 (07-Aug-2017)

Made the Receipt Routing column mandatory.
Adding defaulting to the Receipt Routing based on the PO.

1.2.24 (04-Aug-2017)

Changed Transaction Type defaulting to only default to Receive.

1.2.23 (03-Aug-2017)

Fixed error when attempting to open the form when the Item column was not on the sheet.

1.2.22 (28-Jul-2017)

Fixed upload error when the shipping date value was an invalid date.

1.2.21 (25-Jul-2017)

Fixed concurrent program error when attempting to receipt an ASN.

1.2.20 (10-Jul-2017)

Fixed validation error when creating an Internal Receipt when the Req Number column was not on the sheet.

1.2.19 (07-Jul-2017)

Fixed SQL error when attempting to update a receipt.

1.2.18 (07-Jul-2017)

Fixed error when creating ASN's as was erroring on the Shipped Date.

1.2.17 (06-Jul-2017)

Changed wording on the ribbon from 'Shipment' to 'ASN Shipment'.

1.2.16 (05-Jul-2017)

Fixed validation error when attempting to Update ASN's.

1.2.15 (28-Jun-2017)

Fixed error when attempting to Update when the ASN Type value is blank.

1.2.14 (26-Jun-2017)

Fixed upload error as the Header row was being Uploaded incorrectly when doing a Return.

1.2.13 (21-Jun-2017)

Fixed refresh error where rows where getting incorrectly set to invalid.

1.2.12 (15-Jun-2017)

Made Receipt data column mandatory.
Fixed error where the Log in button label was not changing when logging in.

1.2.11 (15-Jun-2017)

Fixed issue with the Quantity Defaulting when the Receipt Source column has been removed from the sheet.

1.2.10 (15-Jun-2017)

Fixed upload error where the Parent_transaction_id was not being uploaded when attempting a Return transaction.

1.2.09 (14-Jun-2017)

Updated Security.

1.2.08 (07-Jun-2017)

Changed wording when attempting to download on a row lower then row 11.
Fixed validation error when removing the Receipt Source column from the sheet.
Fixed error when in the refresh when attempting to upload a return transaction.

1.2.07 (07-Jun-2017)

Fixed upload error when trying to complete a Return.
Updated the message when opening the DFF form when the DFF is not setup.
Updated error when attempting to update a receipt with a customer number.
Added row number checks to prevent downloads into row 10 (Default Row).
Made Receipt Number mandatory.
Fixed Error when removing the Inventory Org Code column and trying to open the Download form.

1.2.06 (04-May-2017)

Changed Ribbon Download Source wording from 'Purchase Order' to 'Open Purchase Orders'.

1.2.05 (27-Apr-2017)

Fixed error when uploading large amounts of data.

1.2.04 (03-Apr-2017)

Updated Security.

1.2.03 (28-Mar-2017)

Added Order Bys to the download based on your Download Source Option.

1.2.02 (28-Mar-2017)

Removed the Source Option from the Download form as was causing mismatches with the Download Source Option LOV in the ribbon.

1.2.01 (28-Mar-2017)

Renamed the Download Source Options to make it easier for users to navigate the Wizard.

1.2.00 (27-Mar-2017)

Added defaulting to the ‘Received By’ column to default based on the Employee you are logged in as.
Fixed error with the Download as the Project Number was not being downloaded.

1.0.120 (17-Mar-2017)

Internal Enhancements.

1.0.119 (25-Jan-2017)

Implemented the ribbon.

1.0.118 (23-Jan-2017)

Updated Security.

1.0.117 (16-Jan-2017)

Fixed error with the PO Shipment Number column being incorrectly set to invalid.

1.0.116 (23-Dec-2016)

Fixed error when using the Vendor Source Option as the 'Inventory Org' Column was not being printed correctly compared to the 'Ship to Organization' Column.

1.0.115 (16-Dec-2016)

Fixed download issue when downloading with a max row of 1000.
Fixed issue where the Wizard was erroring when using a custom column label.

1.0.114 (07-Dec-2016)

Internal Enhancements.

1.0.113 (18-Nov-2016)

Fixed serial numbers failing validation when receipt is for non-inventory record ie no item number.

1.0.112 (17-Nov-2016)

Fixed error where iProcurement users with the correct function were not able to use the Wizard.

1.0.111 (16-Oct-2016)

Fixed error when using corrections as was erroring saying the 'Shipment number must exist'.
Fixed quantity error with corrections when using a negative quantity as corrections can have a negative quantity.

1.0.110 (30-Sep-2016)

Fixed error when downloading with a Transaction Source of 'Supplier' and a PO Number as no results were being downloaded.

1.0.109 (10-Aug-2016)

Fixed download error in Internal Req downloader.

1.0.108 (28-Jul-2016)

Added validation to prevent user from trying to load Deliver Transaction Type when the Receipt Number (header level) is missing.

1.0.107 (02-Jun-2016)

Internal Enhancements.

1.0.106 (23-May-2016)

Updated Security.

1.0.105 (23-May-2016)

Fixed bug where Deliver transaction erroring due to wrong autoreceipt type of RECEIVE rather than deliver when routing is direct delivery.

1.0.104 (23-Mar-2016)

Fixed error where Deliver transaction not loading due to missing parent record Id on transaction lines interface record.

1.0.103 (07-Dec-2015)

Updated Security.

1.0.102 (09-Oct-2015)

Fixed error where the Deliver transactions were not loading due to missing parent record Id on transaction lines interface record.

1.0.101 (29-Jul-2015)

Internal Enhancements.

1.0.100 (05-Jun-2015)

Fixed error with the Serial Number validation.

1.0.99 (18-May-2015)

Added Sales Order line details for Internal Orders.

1.0.98 (24-Mar-2015)

Added ReqHeader and ReqLine columns for Internal Orders.

1.0.97 (18-Mar-2015)

Added Internal Orders to the Received source list.

1.0.96 (12-Mar-2015)

Internal Enhancements.

1.0.95 (17-Feb-2015)

Internal Enhancements.

1.0.94 (16-Feb-2015)

Internal Enhancements.

1.0.93 (11-Feb-2015)

Internal Enhancements.

1.0.92 (10-Feb-2015)

Internal Enhancements.

1.0.91 (10-Feb-2015)

Updated the Correction download to enable a download using the Project Number.

1.0.90 (13-Nov-2014)

Internal Enhancements.

1.0.89 (01-Sep-2014)

Internal Enhancements.

1.0.88 (28-May-2014)

Ensure ReceiptSourceCode is set before trying to default the quantity

1.0.87 (27-May-2014)

Internal Enhancements.

1.0.86 (11-Apr-2014)

Check for column existing before trying to use in the download interface

1.0.85 (09-Apr-2014)

Ensure the Shipment Number is on the sheet before referencing

1.0.84 (04-Apr-2014)

Fixed Upload error when uploading with a Receiver.

1.0.83 (11-Mar-2014)

Internal Enhancements.

1.0.82 (07-Mar-2014)

Internal Enhancements.

1.0.81 (24-Jan-2014)

Fixed error when the PO number was being used to determine the Supplier during upload

1.0.80 (19-Jan-2015)

Internal Enhancements.

1.0.79 (17-Jan-2014)

Internal Enhancements.

1.0.78 (09-Nov-2013)

Changed the Project and Task to return the numbers instead of name

1.0.77 (07-Nov-2013)

Corrected the Quantity Validation to allow negative values.

1.0.76 (17-Oct-2013)

Added release number for Blanket Purchase Order receipting

1.0.75 (14-Oct-2013)

Ensured that the download form uses the Project Name and Task Name to match the download which returns Project Name and Task Name

1.0.74 (18-Sep-2013)

Fixed a bug where downloading before opening the Receipt form would cause errors.
Fixed InitialiseDFFForm, it was attempting to load the wrong form causing an error.

1.0.73 (30-Aug-2013)

Fixed problem with the DFF form not writing values to the sheet correctly.

1.0.72 (28-Aug-2013)

Internal Enhancements.

1.0.71 (28-Aug-2013)

Internal Enhancements.

1.0.70 (22-Jul-2013)

Internal Enhancements.

1.0.69 (20-Jul-2013)

Make the search for project/task by number rather than project/task name

1.0.68 (19-Jul-2013)

Internal Enhancements.

1.0.67 (18-Jul-2013)

Internal Enhancements.

1.0.66 (12-Jul-2013)

Fixed form error when toggling between download and upload

1.0.65 (27-Jun-2013)

Added Project and Task to download form

1.0.64 (25-Jun-2013)

Changed the order by on the supplier LOV

1.0.63 (11-Jun-2013)

Ensure transaction date is defaulted during upload if transaction date column not on spreadsheet

1.0.62 (10-Jun-2013)

Ensure organization is set before finding open periods

1.0.61 (06-Jun-2013)

Set the organization during upload if R12 based on the session information
Updated comments and mandatory columns for form selection

1.0.60 (05-Jun-2013)

Changed Refresh code to use the shipment_header_id in the shipmentHeader SQL

1.0.59 (28-May-2013)

Ensure lov cache is reset if the mode changes

1.0.58 (27-May-2013)

Fixed category sql to search for the default category_set_id in purchasing

1.0.57 (16-May-2013)

Added Project and Task for download only

1.0.55 (20-Mar-2013)

Updated the ValidatorExchange to ensure column existence is always tested

1.0.54 (28-Feb-2013)

Fixed problem where the supplier id was trying to be passed twice to interface table

1.0.53 (27-Feb-2013)

Default the supplier based on the PO number

1.0.52 (25-Feb-2013)

Fixed problem with Validation of List of Values where dependent data was saved incorrectly

1.0.51 (20-Feb-2013)

Made the Ship Location lookup a searchable list

1.0.50 (07-Feb-2013)

Fixed decimal rounding for quantity in ValidatorQuantity

1.0.49 (31-Jan-2013)

Modified Refresh code to utilise requestID to optimise performance
Fixed problem where delete from interface would not delete out of the po_interface_errors table

1.0.48 (29-Jan-2013)

Added validator for shipment date

1.0.47 (22-Jun-2012)

Changed the po sql to reflect the difference between the inventory org and po header org

1.0.46 (21-Jun-2012)

Removed the use any t1 tables in download sql

1.0.45 (20-Jun-2012)

Removed the use of t1 tables in PO sql

1.0.44 (20-Jun-2012)

Added language to the About This Program Form

1.0.43 (15-Jun-2012)

Corrected search for PO Line number

1.0.42 (08-Jun-2012)

Update the error handling

1.0.41 (29-Mar-2012)

Fixed problem with default quantity when trans type invalid

1.0.40 (17-Jan-2012)

Added dependence values for validation when form opens

1.0.39 (16-Jan-2012)

Ensure defaults are using cached values

1.0.38 (12-Dec-2011)

Changed PO Validation to use the Ship To Organization

1.0.37 (08-Dec-2011)

Changed PO Validation to ensure expensed items are correctly validated

1.0.36 (08-Dec-2011)

Removed warehouse sql from corrections sql
Changed ValidatorUOM to use the base UOM view

1.0.35 (21-Nov-2011)

Download based on the columns on the spreadsheet

1.0.34 (18-Nov-2011)

Changed download to exclude quantities which are now defaulted during validation if left blank

1.0.33 (08-Nov-2011)

Fixed issue when receipt source was not set

1.0.32 (03-Nov-2011)

Change the PO sql to ensure orgs are set using the destination org

1.0.31 (02-Nov-2011)

Change the ValidatorReceipt to ensure validate is set to true in Create mode

1.0.30 (14-Oct-2011)

Removed the cache on the transaction id as caused problems when swapping process modes

1.0.29 (10-Oct-2011)

Use ap_suppliers instead of po_vendors when in R12

1.0.28 (28-Sep-2011)

First Release