10.4.39 (07-Apr-2025)

Accounts for Miscellaneous and Freight Line Types were not being uploaded since 10.4.36

10.4.38 (04-Apr-2025)

Fix for potentially wrong COA ID used in on-server GL Account validation.

10.4.37 (26-Feb-2025)

Enhanced the Wizard - It will now function using the right-click-menu, without the More4apps ribbon tabs.

10.4.36 (31-Jan-2025)

Accommodated servers with load balancing.

10.4.35 (23-Dec-2024)

Fixed the issue of not showing Global DFF attributes in the form.

10.4.34 (29-Oct-2024)

Fixed the issue of PO Matched Invoices not showing PO Number at line level.

10.4.33 (17-Oct-2024)

Added Default Browser Login option.

10.4.32 (13-Sep-2024)

When downloading via sheet you now have the option to include tax lines.

10.4.31 (03-Sep-2024)

Internal bug fix.

10.4.30 (15-Aug-2024)

Added validation to verify that the 'Requester User Name' matches the corresponding 'Requester'.

10.4.29 (08-May-2024)

Header Attachments Upload - Fixed issue where attachments were being loaded against the wrong invoice.

10.4.28 (30-Jul-2024)

Internal updates.

10.4.27 (01-Jul-2024)

Requester Number Field: Added validation to stop upload if a 'Requester number' is provided without an associated 'Requester user name' and 'Requester'. Disabled 'Requester Number' LOV on user form when both 'Requester User Name' and 'Requester' LOVs are disabled.

10.4.26 (23-May-2024)

Improved performance of Requester number LOV.

10.4.25 (21-May-2024)

Internal update.

10.4.24 (17-May-2024)

Improved refresh performance by removing redundant server requests for cached session variables.

10.4.23 (09-May-2024)

Added functionality that allows you to clear all the DFF Distribution data.

10.4.22 (01-May-2024)

Fixed incorrect spelling for Line and Distribution Global Attributes.

10.4.21 (30-Apr-2024)

Fixed issue where DFF form crashes due to inadequate allowance for maximum number of attributes.

10.4.20 (17-Apr-2024)

Internal update.

10.4.19 (04-Apr-2024)

Bug fix.

10.4.18 (28-Mar-2024)

Fixed issue with Global DFF upload.

10.4.17 (03-Jan-2024)

Changed requester number column functionality. The column is now only mandatory when requester information is provided. Previously the column was mandatory even when no requester information was populated.

10.4.16 (28-Feb-2024)

Fixed IDC bug where users with the profile "More4apps: PIW Document Processing Allow 'Update LOV'" set to 'Yes' could not upload the Supplier LOV data.

10.4.15 (02-Feb-2024)

Changed Invoice Global Descriptive Flexfields to validate off the Transaction Table Global DFF definition rather than the Interface Table Global DFF definition. to fix issues where the global Category values are rejected with the following message "Invalid Invoice global DFF DFF context".

10.4.14 (04-Jan-2024)

Adjusted Tax Code Effective Date validation.

10.4.13 (04-Dec-2023)

Fixed 'fetch out of sequence' error when uploading bulk data.

10.4.12 (15-Nov-2023)

Fixed Argentina DFF Localizations not correctly showing in R12.

10.4.11 (03-Nov-2023)

Fix for bug where the End-to-End Trace might not return the SQL Statement's execution plan.

10.4.10 (04-Sep-2023)

Added new digital signature.

10.4.09 (03-Jul-2023)

Improved error handling on upload.

10.4.08 (22-Jun-2023)

Reduced the risk of timeouts when doing mass invoice cancellations.

10.4.07 (07-Jun-2023)

Fixed issue where Tax Amount was not generating a separate Tax Distribution.

10.4.06 (24-May-2023)

Added support for Federal Global Distribution DFFS.

10.4.05 (17-May-2023)

Internal update.

10.4.04 (11-May-2023)

Internal update.

10.4.03 (11-May-2023)

Internal update.

10.4.02 (11-May-2023)

Internal update.

10.4.01 (03-May-2023)

Internal update.

10.4.00 (24-Apr-2023)

Internal update.

10.3.99 (20-Apr-2023)

Internal update.

10.3.98 (03-Apr-2023)

Internal update.

10.3.97 (15-Mar-2023)

Fixed issue around when using Line Limit profile setting, the upload results message was not being updated correctly.

10.3.96 (09-Mar-2023)

Internal updates.

10.3.95 (27-Feb-2023)

Fixed bug with Distribution Set not performing non wildcard searches.

10.3.94 (23-Feb-2023)

Added support for Descriptive Flexfield form reference - :INVOICES_FOLDER.PARTY_SITE_ID

10.3.93 (22-Feb-2023)

Updated form supertips.

10.3.92 (21-Feb-2023)

Fixed bug where Distribution Set was incorrectly defaulting the wrong value from the Supplier Site.

10.3.91 (20-Feb-2023)

Changed Distribution Set LOV across header and distribution forms to long list from short list.

10.3.90 (02-Feb-2023)

Fixed date format bug on GL Date field on the Submit Payables Import form.

10.3.89 (26-Jan-2023)

Intelligent Data Capture: Fixed bug when downloading bulk data or uploading suppliers when using Logging.

10.3.88 (19-Jan-2023)

Setup sheet updates.

10.3.87 (19-Jan-2023)

Fixed an issue that caused large uploads to unexpectedly fail with error "438(Object doesn't support)".

10.3.86 (09-Jan-2023)

Added support for multiple receipt line number upload fix via optional 'Receiving Transaction ID' for PO and receipt downloads.

10.3.85 (06-Jan-2023)

Internal updates.

10.3.84 (06-Jan-2023)

PO Download now correctly returns all receipt lines that the Receipt Download provides.

10.3.83 (04-Jan-2023)

Fixed bug in R12 for Document Category LOV not showing 'Expense Report'.

10.3.82 (22-Dec-2022)

Intelligent Data Capture: Document Status column now is being set when using the Document Deletion functionality.

10.3.81 (21-Dec-2022)

Intelligent Data Capture: Increased feedback on all API response statuses.

10.3.80 (15-Dec-2022)

Intelligent Data Capture: Fixed bug preventing using the Update LOV form.

10.3.79 (01-Dec-2022)

Internal updates.

10.3.78 (30-Nov-2022)

PO and Receipt Download by Sheet now populates Inventory Item column

10.3.77 (01-Nov-2022)

Internal updates.

10.3.76 (27-Oct-2022)

Fixed error when editing the attachment title field in the form, when the column wasn't on the sheet.

10.3.75 (07-Oct-2022)

Internal update.

10.3.74 (14-Sep-2022)

Internal update.

10.3.73 (14-Sep-2022)

Internal update.

10.3.72 (22-Aug-2022)

Bug fixes across R11 invoice downloads.

10.3.71 (19-Aug-2022)

Fixed bug in R11 where invoices with multiple distribution lines were not being printed to the sheet.

10.3.70 (05-Aug-2022)

Fixed bug where 'Validate Only' would create records in the interface.

10.3.69 (02-Aug-2022)

Internal update.

10.3.68 (02-Aug-2022)

Internal update.

10.3.67 (02-Aug-2022)

Internal update.

10.3.66 (13-Jul-2022)

Internal update.

10.3.65 (05-Jul-2022)

Fixed bug where valid project data was being rejected during upload.

10.3.64 (21-Jun-2022)

Fixed issue where uploading invoice failed on R11 and some status bar message was missing.

10.3.63 (20-Jun-2022)

Minor SGA improvement adjustments.

10.3.62 (09-Jun-2022)

Improved load and performance on the SGA of the database during invoice uploads.

10.3.61 (03-Jun-2022)

Internal update.

10.3.60 (13-May-2022)

Custom Query initial header row is now set to row 9 to match the Wizard column headings row.

10.3.59 (11-May-2022)

Internal updates.

10.3.58 (21-Apr-2022)

Fixed issue where Greek Global DFF contexts were loading the incorrect value into the interface table.

10.3.57 (20-Apr-2022)

Fixed issue where Greek Global DFFs were not initializing correctly.

10.3.56 (19-Apr-2022)

Fixed the attachment issue where name of attached file was messed up when file name has non-ascii characters, for example Japanese characters.

10.3.55 (14-Apr-2022)

Fixed multiple issues with Header, Line and Distribution Global DFFs not working correctly.

10.3.54 (13-Apr-2022)

Fixed incorrect Distribution Global DFF Context LOV displaying for Argentina.

10.3.53 (08-Apr-2022)

Fixed issues around Header Global DFFs not correctly Uploading the Header Global DFF column data.

10.3.52 (07-Apr-2022)

Fixed issues around Header Global DFFs not correctly identifying the Header Global DFF columns on the sheet.

10.3.51 (28-Mar-2022)

Added Pay Alone column to Invoice downloads.

10.3.50 (18-Mar-2022)

Minor sheet bug fixes.

10.3.49 (18-Mar-2022)

Minor sheet bug fixes.

10.3.48 (17-Mar-2022)

Several form and sheet validation fixes across R12 tax columns for Tax setups with different code to name values.

10.3.47 (01-Mar-2022)

Fixed duplicate errors in Tax Code LOV cache.

10.3.46 (21-Feb-2022)

Fixed intermittent performance issues during Upload.

10.3.45 (16-Feb-2022)

Intelligent Data Capture: Reject Dashboard now contains Supplier Name field.

10.3.44 (10-Feb-2022)

Intelligent Data Capture: Added new messaging around missing documents when using the 'Invoices' process.

10.3.43 (09-Feb-2022)

Custom Query update for SQL injection fixes.

10.3.42 (01-Feb-2022)

Bug fix when using 'Match Selected Invoice Line' would pop the PO Helper form twice.

10.3.41 (27-Jan-2022)

Internal update.

10.3.40 (08-Dec-2021)

Internal update.

10.3.39 (29-Nov-2021)

Minor bug fix on the Distribution form.

10.3.38 (29-Nov-2021)

Fixed form and sheet validation bugs on Ship To column.

10.3.37 (18-Nov-2021)

Fixed errors across Supplier Site searching functionality on the header form.

10.3.36 (03-Nov-2021)

Minor messaging updates.

10.3.35 (03-Nov-2021)

Added warning message across all download by sheet functions to help prevent extreme downloads occurring.

10.3.34 (03-Nov-2021)

Internal update.

10.3.33 (03-Nov-2021)

Fixed Transaction From-To validation on the Download Form preventing validate date combinations.

10.3.32 (01-Nov-2021)

Fixed the spelling error in the tips for Query Log button.

10.3.31 (27-Oct-2021)

Fix validation bug on Tax column when Tax and Tax Full Name were different values.

10.3.30 (19-Oct-2021)

Improvements to the Example sheet.

10.3.29 (18-Oct-2021)

Fixed issue where default row (10) was not frozen when creating a new sheet.

10.3.28 (04-Oct-2021)

Download bug fixes across Form and Sheet downloads.

10.3.27 (04-Oct-2021)

Fixed download cell formatting and coloration issues when using row 11.

10.3.26 (04-Oct-2021)

Internal update.

10.3.25 (20-Sep-2021)

Fixed bug in R11i which could upload R12 columns data.

10.3.24 (15-Sep-2021)

Removed Remit To Supplier and Remit To Supplier Site defaulting.

10.3.23 (15-Sep-2021)

Added Requester Number to Download.

10.3.22 (14-Sep-2021)

Improved missing Invoice Import Program responsibility message.

10.3.21 (14-Sep-2021)

Internal update.

10.3.20 (03-Sep-2021)

Further caching improvements.

10.3.19 (19-Aug-2021)

Modifications for handling duplicates across Requester column.

10.3.18 (06-Aug-2021)

Fixed cell coloration issue on R12 Dist DFF status column.

10.3.17 (06-Aug-2021)

Fixed error of 'CG_USER_NAME is not cached' which occurred during login with empty Licence Key.

10.3.16 (05-Aug-2021)

Fixed unintended interaction with the 'More4Apps: PIW Restrict Overlay Account Override' across 12.2.4+
Fixed bug with Remit to Bank Account LOV in 12.2.6

10.3.15 (05-Aug-2021)

Improvements of retrieving and storing of cached data during validation and opening of forms.

10.3.14 (26-Jul-2021)

Distribution Set now returns and validates the correct LOV across multi org setups.

10.3.13 (12-Jul-2021)

Updated security.

10.3.12 (08-Jul-2021)

Fixed validation invoice upload bug when Project data was on the sheet.

10.3.11 (08-Jul-2021)

Fixed Download form bug where invalid 'Created By' values would get past Download form validation.

10.3.10 (22-Jun-2021)

Fixed Multi Org validation bug around Purchase Order columns.

10.3.09 (02-Jun-2021)

Intelligent Data Capture - Fixed LOV Upload bug when processing more than 10k supplier records.

10.3.08 (02-Jun-2021)

Updated security.

10.3.07 (10-May-2021)

Fixed bug when Supplier Name column was removed from the sheet.

10.3.06 (03-May-2021)

Updated security.

10.3.05 (23-Apr-2021)

Fixed minor bug on Concurrent Request form.

10.3.04 (21-Apr-2021)

Fixed the issue of tool tips of buttons under 'Help' not showing correctly.

10.3.03 (21-Apr-2021)

Additional various bugs around Purchase Order Lines types.

10.3.02 (20-Apr-2021)

Fixed various bugs around Purchase Order Line types.

10.3.01 (13-Apr-2021)

Fixed validation bug on Dependent DFF value sets.

10.3.00 (16-Mar-0021)

Updated security.

10.2.99 (10-Mar-2021)

Fixed issue where code blew up when users click the Login button with an incorrect host name in the list.

10.2.98 (10-Mar-0021)

Fixed incorrect truncation of error messages from project validation API.

10.2.97 (08-Mar-2021)

Fixed issue where code blew up when refreshing request status.

10.2.96 (05-Mar-2021)

Updated security.

10.2.95 (01-Mar-2021)

Fixed performance issue when downloading PO Data by sheet.

10.2.94 (26-Feb-2021)

"Load form to correct the error..." is no longer an option when the form is already open, as this causes an error.

10.2.93 (15-Feb-2021)

Fixed IDC bug when downloading data from workflows which only contain Header data.

10.2.92 (10-Feb-2021)

Changed Remit To Bank Account 12.2.8 fix for 12.2.7 onwards.

10.2.91 (20-Jan-2021)

Fixed bug on Remit to Bank Account column in 12.2.8

10.2.90 (13-Jan-2021)

Updated security.

10.2.89 (15-Dec-2020)

Updated security.

10.2.88 (30-Nov-2020)

Fixed error when clicking 'List My Batches Only' in the 'Submit Invoiced Validation' form.

10.2.87 (24-Nov-2020)

Fixed invalid remit to supplier/site errors due to incorrect remit to primary defaulting.

10.2.86 (23-Nov-2020)

Fixed form control and display errors on Tax Control amount field on the Distributions form.

10.2.85 (20-Nov-2020)

Fixed bug preventing forms opening for non-english excel setups.

10.2.84 (20-Nov-2020)

Intelligent Data Capture - Minor sheet adjustments.

10.2.83 (18-Nov-2020)

Intelligent Data Capture - Security improvements.

10.2.82 (04-Nov-2020)

Minor sheet display bug fix.

10.2.81 (04-Nov-2020)

Updated security.

10.2.80 (08-Oct-2020)

Fixed bug where generating new Wizard sheets could get name conflicts.

10.2.79 (02-Oct-2020)

Fixed PO Download bug where default row color could change color when no PO download results would return.

10.2.78 (02-Oct-2020)

Updated security.

10.2.77 (01-Sep-2020)

Updated security.

10.2.76 (31-Aug-2020)

Intelligent Data Capture - Improved clarify on messaging.

10.2.75 (27-Aug-2020)

Fixed display bug on Tax column on Distributions form.

10.2.74 (27-Aug-2020)

Fixed bug on Tax column.

10.2.73 (26-Aug-2020)

Intelligent Data Capture - Fixed bug with multiple Duplicate Document Ids applying multiple IDC attachments.

10.2.72 (26-Aug-2020)

Fixed bug with Tax Regime and Tax columns writing the Code instead of face value when using the Distribution form.

10.2.71 (25-Aug-2020)

R11i PO and Receipt Download by Sheet now works correctly.

10.2.70 (17-Aug-2020)

Fixed minor new sheet issues.

10.2.69 (17-Aug-2020)

Fixed the issue where first created sheet was named as 'Sheet3' instead of 'Sheet1'.

10.2.68 (17-Aug-2020)

Fixed the issue that Wizard logo was stretched when new sheets are created.

10.2.67 (17-Aug-2020)

Fixed bug with batching on Submit Validation form.

10.2.66 (17-Aug-2020)

Added Packing Slip, Bill of Lading and Waybill Airbill as filter criteria on PO Receipt Downloads by sheet.

10.2.65 (06-Aug-2020)

Fixed the issue of creating new sheet broke the digital signature.

10.2.64 (04-Aug-2020)

Holds and Releases download by sheet and form now correctly respect the 'Holds Name' parameter.

10.2.63 (04-Aug-2020)

Fixed Download By Form bug where batch downloads would not return any download results.

10.2.62 (03-Aug-2020)

Holds and Releases download by sheet and form now correctly respect the 'Active Holds Only' parameter.

10.2.61 (03-Aug-2020)

Fixed batch name LOV multi org display issue.

10.2.60 (29-Jul-2020)

Columns containing data with leading zeros are now retained during downloads.

10.2.59 (20-Jul-2020)

Improved time-out issues and filter query performance for Download By Sheet and Download By Form functionality.

10.2.58 (16-Jul-2020)

Fixed bug where alphanumeric supplier numbers would download as 0.

10.2.57 (16-Jul-2020)

Fixed bug where Exchange Rate Type was downloading ID value instead of user value.

10.2.56 (06-Jul-2020)

Updated security.

10.2.55 (18-Jun-2020)

Non-Independent Data Capture invoices uploaded in IDC mode now no longer are marked as IDC.

10.2.54 (09-Jun-2020)

Minor bug fix.

10.2.54 (09-Jun-2020)

Minor bug fix.

10.2.53 (03-Jun-2020)

Updated security.

10.2.52 (21-May-2020)

Fixed validation bug which falsely detected Invoice Number duplications.

10.2.51 (18-May-2020)

Intelligent Data Capture - Added 'Save and Learn' button to Document Processing form.

10.2.50 (29-Apr-2020)

Internal update.

10.2.49 (28-Apr-2020)

Fixed cell coloration bug with Tax Code field.
Fixed bug when loading Invoice Header form and Requester ID column when missing on the sheet.

10.2.48 (15-Apr-2020)

Internal update.

10.2.47 (08-Apr-2020)

Internal update.

10.2.46 (06-Apr-2020)

Internal updates.

10.2.45 (03-Apr-2020)

Receipt lines of match option 'R' and matching basis 'Amount' with zero received amounts will no longer be brought down into the sheet.

10.2.44 (03-Apr-2020)

Fixed the issue of getting SQL error during the login.

10.2.43 (03-Apr-2020)

PO and Receipt Downloads now bring down 'Closed for Receipt' closed code Receipts.
Amount billed replaced with Amount Unbilled for consistency alongside Quantity Unbilled.

10.2.42 (02-Apr-2020)

Fixed the issue of getting SQL error during the login.

10.2.41 (31-Mar-2020)

Internal update.

10.2.40 (27-Mar-2020)

Security adjustments for Invoice Multi-Org downloads.

10.2.39 (25-Mar-2020)

PO and PO Receipt Download by sheet now support Multi-Org functionality.

10.2.38 (20-Mar-2020)

Fixed bug when downloading Invoices or PO's with removed columns from the sheet.

10.2.37 (20-Mar-2020)

Fixed validation bug around Remit To Supplier and Remit To Supplier Site columns.

10.2.36 (20-Mar-2020)

Intelligent Data Capture - Reject Dashboard link expiry time adjustments.

10.2.35 (19-Mar-2020)

Fixed validation bug around Remit To Supplier and Remit To Supplier Site columns.

10.2.34 (18-Mar-2020)

Fixed SQL bug on Receipt PO Download.

10.2.33 (17-Mar-2020)

Minor display only column adjusts for PO and Receipts downloads.

10.2.32 (17-Mar-2020)

Adjustments for Purchase Order and Receipt Download data.

10.2.31 (16-Mar-2020)

Fixed Amount Bill, Amount Received and Line Amount columns for PO and Receipt Downloads.
Fixed bug where duplicate receipt lines could appear during PO downloads.

10.2.30 (16-Mar-2020)

Fixed bug for PO Download where extra duplicated receipt lines could download.
Line Amount now reflects the amount remaining for the PO/Receipt line for PO and Receipt downloads.

10.2.29 (11-Mar-2020)

Removed message during Download PO By Sheet.
PO Download now no longer brings down Receipt Data for PO Lines of match option type 'P'.

10.2.28 (06-Mar-2020)

Minor PO Download by sheet adjustments.
Minor Remit to Supplier/Site adjustments regarding defaulting and active/end dated sites.
Minor Wizard column position adjustments.
Fixed bug when display only columns were removed from the sheet.

10.2.27 (05-Mar-2020)

Removed modified messaging around R12 default tax code messaging.

10.2.26 (04-Mar-2020)

Improved defaulting and LOVs for Remit To Supplier and Remit To Supplier Site columns.

10.2.25 (03-Mar-2020)

Improved PO and Receipt download by sheet functionality.
Added cell coloration to all Data Downloads.
Added new Display only columns: Amount Received, Amount Unbilled, PO Line Type, PO Line Match Basis.

10.2.24 (26-Feb-2020)

Fixed error on Download form when entering extremely large numbers in the Amount To From fields.

10.2.23 (18-Feb-2020)

During upload, multiple PO Line columns now correctly show the correct colour states based on upload outcome.

10.2.22 (17-Feb-2020)

Fixed bug using Delete when not logged into EBS.

10.2.21 (10-Feb-2020)

Intelligent Data Capture - Added new Indexing category status for containing Oracle Upload ready invoices.

10.2.20 (05-Feb-2020)

Intelligent Data Capture - Fixed minor bugs around upload with Deleted and Archived documents on the sheet.

10.2.19 (04-Feb-2020)

Intelligent Data Capture - Upload now ignores Deleted and Archived documents.

10.2.18 (04-Feb-2020)

Updated with new re-brand colours.

10.2.17 (30-Jan-2020)

Intelligent Data Capture - Added Delete functionality set by new Profile Option.

10.2.16 (21-Jan-2020)

Minor form and sheet visual adjustments.

10.2.15 (06-Jan-2020)

Updated security.

10.2.14 (30-Dec-2019)

Minor visual adjustments on Header form.

10.2.13 (19-Dec-2019)

Fixed downloading errors on Form and Sheet for R11i users.

10.2.12 (19-Dec-2019)

Minor bug fix during upload.

10.2.11 (18-Dec-2019)

Intelligent Data Capture - Document Processing From button now only allows amending for Active documents.

10.2.10 (13-Dec-2019)

Intelligent Data Capture - Fixed cell wrapping and carriage returns on Attach Description column.
Fixed bug when loading Invoice Header form and Requester ID column was missing on the sheet.

10.2.09 (09-Dec-2019)

Intelligent Data Capture - Simplified tracking form.
Intelligent Data Capture - IDC manual archiving no longer colours Document ID column.

Fixed minor bug on Clear Status Columns functionality.

10.2.08 (05-Dec-2019)

Intelligent Data Capture - Fixed bug with leading zero Invoice Numbers not printing correctly for downloads.

10.2.07 (04-Dec-2019)

Intelligent Data Capture - Fixed data overwriting bug when downloading data and fixed bug when downloading only a single document.

10.2.06 (04-Dec-2019)

Intelligent Data Capture - Fixed message bug when using Dashboard and improved Upload Performance for uploads.

10.2.05 (02-Dec-2019)

Fixed validation bug introduced in version 10.2.04.
Improved Security.

10.2.04 (29-Nov-2019)

Added progress form to Refresh process.
Added archive button to Dashboard process.

Intelligent Data Capture - Added new status and message columns for IDC to help provide additional feedback of processes.
Added new attachment section to help better facilitate automatic attachment processing as well as user entered attachments.
Fixed Tax/Freight blank line print debug for downloads.

10.2.03 (21-Nov-2019)

Intelligent Data Capture - Additional fixes around Tax Lines when bring down data from Xtracta

10.2.02 (21-Nov-2019)

Added new logic in Wizard and Xtracta to identify intentional zero freight/tax lines (0.00) and zero defaulted freight/tax lines (0) for math calculations. Only intentional zero freight/tax lines will be brought down into the sheet.

10.2.01 (20-Nov-2019)

Intelligent Data Capture - Zero dollar tax lines are no longer brought down through the download process and removed refresh functionality as it is now obsolete and its implementation does not work within the new configuration.

10.2.00 (18-Nov-2019)

Intelligent Data Capture - Fixed Freight Line bug on document Download and added new Reject Dashboard to process (replaces Training and Rejects sheet).

10.1.99 (15-Nov-2019)

Intelligent Data Capture - Improved performance and added progress bar to invoice download process.

10.1.98 (11-Nov-2019)

Improved column name consistency by removing special characters in column names for usage across Custom Query and Intelligent Data Capture.

10.1.97 (25-Oct-2019)

Improved consistency of messages across core functions.

10.1.96 (24-Oct-2019)

Added Line Global DFF columns section.

10.1.95 (11-Oct-2019)

Fixed bug when opening the Download form for 11i users.

10.1.94 (11-Oct-2019)

Added the firewall solution to download feature.

10.1.93 (09-Oct-2019)

Fixed bug where Prepayment validation status of 'Unvalidated' would be written back as 'Not Validated'.
Fixed refresh bug where invalid data was entered across status and header columns.

10.1.92 (09-Oct-2019)

Enabling solution to try and stop the calls being mistaken as sql injection by firewalls (requires ServletVersion >= 10294 for R12 or Shared Package version >=50421 for R11 to work).Added a new checkbox "Allow Pop-Ups" to the Login form to enable the users block or unblock the popped up dialog.

10.1.91 (04-Oct-2019)

Improved Profile Option value caching.

10.1.90 (02-Oct-2019)

Fixed decimal column formatting on PP Line Num and PP Dist Num columns.
Fixed bug where refresh would not retrieve prepayment validation statuses.

10.1.89 (26-Sep-2019)

Fixed bug where download by sheet was not collecting the correct cell values from criteria columns

10.1.88 (25-Sep-2019)

Fixed bug preventing single org setups from downloading data

10.1.87 (23-Sep-2019)

Intelligent Data Capture - QA and Output buttons are now mutually exclusive and show based upon the 'Document Processing Enable QA' profile option

10.1.86 (23-Sep-2019)

Improved Download Performance for non multi-org setups

10.1.85 (17-Sep-2019)

Submit for Validation form now pops a message when duplicate invoice numbers are returned for a Multi Org users

10.1.84 (13-Sep-2019)

Invoice ID parameter on Submit for Validation form is now being correctly populated

10.1.83 (12-Sep-2019)

Multi Org adjustments on the Submit for Validation form.
Fixed tabbing ordering on the Download form.
Fixed bugs with Multi Org downloads via sheet and form.

10.1.82 (06-Sep-2019)

Added security

10.1.81 (05-Sep-2019)

More4apps: PIW Enable Multi Org Import' now no longer needs to be enabled for MO downloads.
Added Operating Unit to the Download form and as Download By Sheet criteria.

10.1.80 (04-Sep-2019)

Fixed bug on PO Matching form when using Blanket Purchase Order Releases

10.1.79 (04-Sep-2019)

Added new change log sheet

10.1.78 (02-Sep-2019)

Fixed bug on Distributions form where PO Dist Number column would not update correctly when modified.

10.1.77 (28-Aug-2019)

Fixed refresh bug which would incorrectly identify when no data was found on the sheet.

10.1.76 (27-Aug-2019)

Fixed the issue where public macro 'ShowWizardToolbars' missed.

10.1.75 (23-Aug-2019)

Intelligent Data Capture - Modified refresh messages.

10.1.74 (23-Aug-2019)

Intelligent Data Capture - Modified message when multiple users are accessing the same document for amending.

10.1.73 (23-Aug-2019)

Intelligent Data Capture - Fixed Quick PO Matching Helper form PDF button to correctly view the invoice document.
Intelligent Data Capture - Fixed bug when trying to view a document image when unable to find selected invoice data.

10.1.72 (23-Aug-2019)

Intelligent Data Capture - Fix bug with Document Uploader button not opening onto the correct process.

10.1.71 (16-Aug-2019)

Bug fixes on clicking ribbon buttons when selection is on an image.

10.1.70 (15-Aug-2019)

Made Requester and Requester Username column errors more consistent.

10.1.69 (14-Aug-2019)

'Submit Invoice Validation' button now correctly opens the correct form.

10.1.68 (14-Aug-2019)

Fixed bug when using 'Submit for Validation' and 'Refresh' functionality when no data was on the sheet.
Fixed bug when using the 'Download Open Receipts from Sheet' action.
Fixed bugs around Requester, Requester Username and Requester ID columns.

10.1.67 (13-Aug-2019)

Internal update.

10.1.66 (09-Aug-2019)

Fixed SQL error on Download Form.
Now uploading Work_ID instead of Employee_ID for Requester column.
Header form now no longer pops the Requester Duplicates form.

10.1.65 (09-Aug-2019)

Added Requester ID column in help reduce the number of occurrences the Requester Duplicate form pops up.

10.1.64 (08-Aug-2019)

Fixed bugs on download for R11i bringing down '~s' on some data fields.
Fixed bug with validation and error message box not resuming when an error occurs on the Remit to Bank account field.

10.1.63 (02-Aug-2019)

Multi-Org enabled for Downloading Invoices By Sheet and Form when using the 'More4Apps: PIW Enable Multi Org Import'.

10.1.62 (26-Jul-2019)

Numerous bug fixes in refresh. Messaging and statuses from refresh are now more consistent for Multi-Org setups.

10.1.61 (25-Jul-2019)

Download by sheet will now remove the download criteria from the sheet.
Created By search criteria on the Download Form is now based on username instead of description.

10.1.60 (25-Jul-2019)

Fixed bug for EBS where uploaded binary file (pdf, png, jpg, etc) were failed or the file was corrupted in some of PCs.
Fixed bug when Download via Form and sheet when columns have been modified on the sheet.
Fixed download bug in R11i.

10.1.59 (19-Jul-2019)

URL Attachments can now be up to 2000 characters in length instead of 255.

10.1.58 (18-Jul-2019)

Refresh process will return more messages and statuses to more easily help determine the cause of invoice reject issues.

10.1.57 (05-Jul-2019)

Fixed bug on PO Matching form which would sometimes not correctly print distribution data which was user modified.

10.1.56 (04-Jul-2019)

Modified Invoice and Distribution form searching result message boxes to be more unified and consistent.

10.1.55 (01-Jul-2019)

Updated Security.

10.1.54 (28-Jun-2019)

Fixed bug when using default row and upload all together.
Distributions from tabs; Purchase Orders and Projects will now always show even if their respective columns are missing on the sheet.

10.1.53 (26-Jun-2019)

Fixed download by sheet error for Holds in Fusion.
Fixed minor bugs associated with More4apps: PIW Default Batch Source profile option.
Added new Distribution Sets column at the Invoice Level on the sheet and added a new distribution set field on the invoice form.

10.1.52 (26-Jun-2019)

Fixed errors when accessing holds for upload or download in Fusion.

10.1.51 (25-Jun-2019)

Changed More4apps: PIW Default Batch Source profile option to a LOV instead of a free text field.

10.1.50 (25-Jun-2019)

Fixed bug with the download where invoices with only header data would fail to print to the sheet.

10.1.49 (17-Jun-2019)

Fixed error when downloading using Supplier Name in via form or sheet.

10.1.48 (13-Jun-2019)

Fixed error when refreshing in Fusion.
Fixed error when downloading in Fusion.

10.1.47 (06-Jun-2019)

Fixed bug when downloading invoices would write ‘#NA’ in the distribution section when no distribution data was available.

10.1.46 (04-Jun-2019)

Fixed the issue where error overflow happened when opening the Concurrent Request form.

10.1.45 (04-Jun-2019)

Changed the default processing data to 1 on the Concurrent Requests form to help improve performance on systems with large amounts of requests.

10.1.44 (31-May-2019)

Fixed bug - When loading attachments during refresh would always 'reject' attachments.

10.1.43 (31-May-2019)

Added error handler to the View Concurrent Request to improve the error message when exception happens.

10.1.42 (30-May-2019)

Fixed refresh parameter bug when using new versions of the Wizard with older packages.

10.1.41 (30-May-2019)

Attachment, Holds and Releases now make better use of 'Reject' statuses.
Tax code defaulting now correctly applies and validates when opening the Distributions form.

10.1.40 (29-May-2019)

Wizard sets 'Use Default Tax Codes' as the new default in the Wizard setup tab.
R12 Dist Status column has been renamed to 'R12 Dist DFF Status' in order to better convey its purpose.
R12 Dist DFF Status now no longer gets written unnecessarily during validation or upload.
Error sheet range has been expanded to include checking user entered or copied cell data errors (#DIV0!, #N/A etc).

10.1.39 (28-May-2019)

Fixed bug during download process when column headings had column spaces.

10.1.38 (28-May-2019)

R12 tax is now correctly following the default hierarchy and retrieving the correct values when tax defaulting is enabled.

10.1.37 (20-May-2019)

Intelligent Data Capture: Now correctly escaping XML characters for Soap API calls.

10.1.36 (20-May-2019)

Fixed button labelling issue on Intelligent Data Capture ribbon.
Fixed messaging grammar on intelligent data capture message.

10.1.35 (15-May-2019)

Retrieving Invoice ID now also checks supplier site data as invoice numbers can be reused within the same supplier across different supplier sites (requires package versions; spec 3.0.8, body 3.5.6).

10.1.34 (13-May-2019)

Invoice header form now defaults Invoice Name field when defaulting details from PO Number.

10.1.33 (09-May-2019)

Added the ability to switch the label of login/logout button according to the current login status.
When not login and clicking login/logout button no longer showing the message of "No user is currently logged in" but pop up the login form.

10.1.32 (06-May-2019)

Fixed bug when opening attachments form when 'Attach Desc' column was missing on the sheet.
Intelligent Data Capture: Fixed bug with blank distribution lines showing when printing data onto the sheet.

10.1.31 (02-May-2019)

Fixed visual bug on progressing form when deleting invoices.

10.1.30 (01-May-2019)

Intelligent Data Capture: Added expire duration for amending documents API call.

10.1.29 (30-Apr-2019)

Corrected the label of ribbon support group from Debug to Support.

10.1.28 (25-Apr-2019)

Fixed sheet printing error when invalid Supplier Number was entered on the Header Form.
Fixed bug on Distributions form where Includes Tax was copying Tax Code value.

10.1.27 (24-Apr-2019)

Added new debug option - 'End to End Trace Unlimited Size'.
Added menu button 'Logging' to enable the query log.
Added menu button group 'Help' to provide the links to help documents.

10.1.26 (23-Apr-2019)

Fixed bug on forms when typing in a date into a date field.
Fixed bug when trying to use Template123 content after Template123 was removed.

10.1.25 (17-Apr-2019)

Minor bug fixes during Download process.

10.1.24 (17-Apr-2019)

Fixed bug found with DFF column heading checking during download.

10.1.23 (16-Apr-2019)

Made fixed price PO lines default quantity value to 1 (instead of 0 or blank) and unit price based on the line amount.
Fixed divide by zero errors in distribution and PO matching helper forms.
Minor improvements to PO Matching form.
Download performance can now be improved by removing all DFF sections from the sheet.

10.1.22 (12-Apr-2019)

Progress form can now no longer be closed unless the process is canceled or until the process is completed.
Progress form does not pop until after logging in for Download by Form.

10.1.21 (11-Apr-2019)

Added processing form for Download by Sheet and Download by Form.

10.1.20 (11-Apr-2019)

Download is now more responsive and has more meaningful status bar messaging.

10.1.19 (10-Apr-2019)

Adjusted Performance and issues around Bulk Downloads on Form and Sheet.
Fixed bug when using download by sheet and having 'Invoice Type' data.

10.1.18 (08-Apr-2019)

Removed downloading Attachment Data from Form and Sheet downloads due to performance reasons.
Fixed bug when opening Distributions form.
Fixed bug when opening Holds and Attachment forms when the Invoice Number column does not exist on the sheet.

10.1.17 (05-Apr-2019)

Fixed selection bug when clicking Download by Sheet or Download from the ribbon.

10.1.16 (03-Apr-2019)

Multiple bug fixes on the PO Matching Download form.
Error handling fixes and cell colouration changes on Invoice and Dist forms.

10.1.15 (28-Mar-2019)

Fixed inconsistencies on the processing form and improved performance when canceling tasks.
Multiple form fixes for PO Matching Download form.

10.1.14 (26-Mar-2019)

Fix Download by Sheet bug when criteria columns are missing from the sheet.
Added processing form to invoice deletion process which allows the ability to cancel the process.
Minor delete process fixes.
Fixed some occurrences of old error colours on Wizard forms.

10.1.13 (26-Mar-2019)

Intelligent Data Capture - Fixed bug with Upload LOV button not correctly determining SysAdmin users.
Fixed DFF bug when using Download by Sheet and the Download form.
Fixed odd behavior around the status column colours during upload.
Fixed minor control colouration bugs on numerous Wizard forms.
Cleaned up and updated column heading comments.
Cleaned up Setup sheet and updated links.

10.1.12 (25-Mar-2019)

Downloading ID based DFFs now resolve into the correct values.

10.1.11 (21-Mar-2019)

Added new sheet colour scheme to the Wizard.

10.1.10 (20-Mar-2019)

Modified supertip labels across multiple forms.

10.1.09 (19-Mar-2019)

Added Holds button to ribbon and right click context menu.
Fixed error pop up when logging into the Wizard where the Intelligent Data Capture sheets have been removed.

10.1.08 (18-Mar-2019)

Added Holds button under the 'Forms' gallery on the ribbon.
Fixed bug when opening Holds form when on a row which didn't contain a validated invoice.
Updated control super-tips across multiple Wizard forms.
Added fixes to application status bar to help handle with 'False' statuses.
Removed duplicates in Holds query on Download form.

10.1.07 (18-Mar-2019)

Added new Download form redesign with additional download fields/criteria.
Added Download by Sheet functionality.

10.1.06 (08-Mar-2019)

Fixed bug on Submit Payables Import form which would apply the last used GL Date when left blank.

10.1.05 (06-Mar-2019)

Updated section headers with proper case.

10.1.04 (01-Mar-2019)

Minor code re-factor.

10.1.03 (28-Feb-2019)

Additional minor fixes around cursor row selection check around row 11.

10.1.02 (28-Feb-2019)

Minor fixes around cursor row selection check around row 11.

10.1.01 (22-Feb-2019)

Right click context menu now correctly shows/hides mode control.
Minor Form control sizing adjustments to help reduce labelling across different screen resolutions.
DFF, Holds, Attachments made minor form adjustments.

10.1.00 (22-Feb-2019)

Fixed bug around cursor row selection being below row 11 and not allowing functionality.

10.0.99 (21-Feb-2019)

Fixed bug when using Debug Mode in setup tab and performing Wizard Uploads.
Minor form size and button arrangements to help with screen resolution differences.
Minor messaging fixes for Mode Support.

10.0.98 (20-Feb-2019)

Minor adjustments for Modes messaging and sheet content.

10.0.97 (19-Feb-2019)

Minor adjustments for Mode support.

10.0.96 (18-Feb-2019)

Added mode Support to the Wizard to better handle IDC and Standard AP functionality.

10.0.95 (05-Feb-2019)

Checked on profile naming consistency.

10.0.94 (18-Jan-2019)

Fixed messaging bug where intelligent data pops during refresh for non-intelligent data capture users.

10.0.93 (15-Jan-2019)

Added profile option 'More4Apps: PIW Enable Holds and Hold Releases on paid invoices' which when set to 'Yes' allows users to upload holds and hold releases to paid invoices.

10.0.92 (14-Jan-2019)

Updated security.

10.0.91 (09-Jan-2019)

The profile option "More4Apps: PIW Validate Only" now functions correctly

10.0.90 (20-Dec-2018)

Fixed performance and stability issues when doing bulk uploads using "Upload All" or large selections.

10.0.89 (18-Dec-2018)

Fixed error when updating DFFs when the PIW_CUSTOM body version was 1.0.05 or lower.

10.0.88 (14-Dec-2018)

Added attachment validation to check attachment content is less than 255 characters for attachment uploads of URL types.
Fixed bug where validation check on attachment content for TEXT attachment uploads was incorrect.
Intelligent Data Capture: Fixed bug where files would be stored, processed and attempted to attach in Oracle on invoices that failed to import into EBS.

10.0.87 (12-Dec-2018)

Fixed bug on PO Matching download form which would download the full search and not the users reduced selection.

10.0.86 (11-Dec-2018)

Modified some of the intelligent data capture messages for easier readability.
Fixed issue where Document ID was invalid during refresh.

10.0.85 (10-Dec-2018)

Fixed bug when opening SOAP API form from the ribbon.

10.0.84 (10-Dec-2018)

Intelligent Data Capture: SOAP API functionality now correctly resolves Xtracta identifiers (form and refresh).
Intelligent Data Capture: SOAP API functionality now correctly resolves all header identifiers (form and refresh).

10.0.83 (06-Dec-2018)

Intelligent Data Capture: Added "More4Apps: PIW Document Processing File Storage Mechanism" profile option.
Intelligent Data Capture: Added SOAP API functionality as a file storing method. Setup for this can be found using the SOAP API button on the ribbon.
Intelligent Data Capture: Added 'View Document' button to ribbon, which opens the document image associated to the selected invoice.
Intelligent Data Capture: Removed 'Document URL' and 'Cumulus URL' columns from processing sheet, use View Document button instead.
Now performing intelligent data capture file downloads and file processing during refresh instead of on invoice data download.

10.0.82 (07-Dec-2018)

Fixed issue where the "Upload LOV" form would incorrectly give a sysadmin error and not populate the LOV name list.

10.0.81 (06-Dec-2018)

Fixed "Error 5" when validating multiple distributions which contain validation errors.

10.0.80 (06-Dec-2018)

Freight lines now require a non-PO accounting source to be considered valid.

10.0.79 (03-Dec-2018)

Added a checkbox to the "Submit Payables Import" form which enables/disables defaulting of the Invoice Batch field.

10.0.78 (03-Dec-2018)

Restricted access to modifying SQL in the "Upload LOV" form to sysadmins only.
Allowed non-admins who have the "Update LOV" profile set to update the LOV (But not modify the SQL).

10.0.77 (21-Nov-2018)

Merged special versions of AP Invoice messaging rewrite.

10.0.76 (20-Nov-2018)

Fixed grammar across several messages in the Wizard.

10.0.75 (16-Nov-2018)

Updated validation and upload to use new messaging system.

10.0.74 (15-Nov-2018)

Updated Invoice/Batch deletion process to use new messaging system.

10.0.73 (14-Nov-2018)

Internal update.

10.0.72 (12-Nov-2018)

Removed Holds and Releases sections on Extras forms as it is completed through the refresh process.

10.0.71 (09-Nov-2018)

Messaging rebuild initial commit.

10.0.70 (08-Nov-2018)

Fixed bugs around using the Holds and GL Fields on the Submit Payables Import form.

10.0.69 (05-Nov-2018)

Fixed bug when opening Invoice header form when Supplier Site column as removed form the sheet.

10.0.68 (02-Nov-2018)

Updated Security.

10.0.67 (30-Oct-2018)

Minor adjustments made to the Setup sheet.
Renamed Intelligent data capture sheets.

10.0.66 (30-Oct-2018)

Merged special versions of AP Invoice Refresh rewrite, 10.0.53 - 10.0.65 is the commit history for the refresh rewrite.

10.0.65 (29-Oct-2018)

Fixed bug during Invoice DFF extras upload where the Wizard could grab the incorrect Invoice Flex Field details of other sections.

10.0.64 (26-Oct-2018)

When using the Holds form, the selected cell will now stay at the holds sections on the worksheet.

10.0.63 (17-Oct-2018)

Fixed error with attachment description when loading Attachments through the forms manually.

10.0.62 (15-Oct-2018)

Adjusted some of the Holds and Hold Releases message content on Holds form.

10.0.61 (10-Oct-2018)

Numerous bug fixes around manually uploading Holds and Releases using the form.
Fixed bug on Refresh where loading hold releases would not always load correctly.

10.0.60 (08-Oct-2018)

Improved refresh performance with bulk data sheets.
Fixed bug with Attachments form not correctly registering invoice id on multi-line attachments.

10.0.59 (02-Oct-2018)

Payment Priority and Discount Amount columns show correct validation colours when being loaded through Extras.
Standard refresh now correctly respects profile of user access to; Holds, Releases and Dist DFFs.

10.0.58 (02-Oct-2018)

Fixed minor display issues on Extras form and made improvements to the Extras Upload process.

10.0.57 (01-Oct-2018)

Refresh Holds, Releases, Attachments and Dist DFF messages will now only show if their respective columns exist on the sheet.

10.0.56 (01-Oct-2018)

11i will now no longer prompt to ask to refresh Distribution DFFs.
Dist DFFs on refresh will now only upload lines with Dist DFF data.

10.0.55 (01-Oct-2018)

Fixed bug where R11i would get SQL errors when loading Holds or Releases.
Fixed bug where refreshing invoices that were not created yet would give SQL errors.

10.0.54 (28-Sep-2018)

Fixed bug where if alpha characters were entered in the Invoice ID column would cause a SQL error.

10.0.53 (28-Sep-2018)

Improved the process and performance of Refresh.
Improved the process and performance of Extra Uploads.

10.0.52 (15-Oct-2018)

Intelligent Data Capture: Fixed bug when downloading invoices attachment category data would be blank.

10.0.51 (25-Sep-2018)

Intelligent Data Capture: Missing column messages on rejects and processing sheets have been made consistent.
Now manages better messaging and profile checking before using all automation actions.

10.0.50 (18-Sep-2018)

Intelligent Data Capture: All Document Processing Profile Options are now available across Site, Responsibility and User levels.
"More4Apps: PIW Document Processing Default Attachment Type" profile option now uses an LOV instead of free text.

10.0.49 (14-Sep-2018)

Intelligent Data Capture: Invoice Type column is now mandatory on the sheet.

10.0.48 (14-Sep-2018)

Added Example Sheet to the Wizard, showing examples of various invoice types and general Wizard practises.

10.0.47 (14-Sep-2018)

Purchasing Category and Ship To columns have been added to the 'Mandatory Fields' form on the setup tab.

10.0.46 (10-Sep-2018)

Header level PO number will follow the conditions below as to whether or not it gets written into the interface table.
- If ALL lines have the same PO as the Header, write the PO to the Header.
- If one or more lines of accounting do not match the header PO - either different PO, use of GL Account, Project Accounting Lines - then do not write the PO number back to the Header.

10.0.45 (06-Sep-2018)

Intelligent Data Capture: Improved security by making Document URL link based on the users document storage location instead of Xtracta.
Cleaned up Automation sheets and arranged columns to be consistent with default Wizard sheet.

10.0.44 (04-Sep-2018)

Updated Invoice Type validation messages.
Automation: Minor adjustments made on the document processing ribbon buttons with labels and supertips.

10.0.43 (03-Sep-2018)

Intelligent Data Capture: Fixed bug introduced in version 10.0.42 where it would not correctly bring down several columns of data into the sheet.

10.0.42 (03-Sep-2018)

Intelligent Data Capture: Now bringing down the Invoice Type value through for identifying between Standard Invoices and Credit Memos.

10.0.41 (31-Aug-2018)

Intelligent Data Capture: Renamed automation sheets to be; 'Automation Processed Documents' and 'Automation Rejects'.
Fixed minor messaging error introduced in version 10.0.40

10.0.40 (30-Aug-2018)

Intelligent Data Capture: Added new messaging and prevention of Invoice downloads when Attachment Setup is incomplete on the Processing and Service Account form.

10.0.39 (27-Aug-2018)

Intelligent Data Capture: Implemented new attachment setup system for managing attachments in Automation using account settings.
Added More4Apps: PIW Document Processing File Processing Profile Option, used to drive how attachments will be processed.
Added More4apps: PIW Document Processing Default Attachment Type Profile Option, used to default the Attach Category value on the sheet.

10.0.38 (24-Aug-2018)

Fixed bug where downloading purchase details would incorrectly load into the default row.

10.0.37 (17-Aug-2018)

Fixed bug when trying to load Global DFFs form when Global DFFs were not enabled on the Setup tab.

10.0.36 (13-Aug-2018)

Fixed bug where refresh would always say no holds were releases unnecessarily.
Fixed bug where XML Parse error would occur when selected 'No' when asked to load holds during refresh.

10.0.35 (09-Aug-2018)

Fixed bug where holds were not always loading the hold reason into Oracle.

10.0.34 (09-Aug-2018)

Fixed bug where the Wizard would get numerous pop up messages when having multiple excel workbooks open alongside AP Invoice Wizard in the same session.
Dropdown ribbon controls now are unable to be modified.

10.0.33 (08-Aug-2018)

Clear status columns and removing duplicate headers status form now prevents access to the spreadsheet until the process has been completed.

10.0.32 (08-Aug-2018)

Made invoice number and supplier names case insensitive and added '%' in the front when searching on the Download form.

10.0.31 (07-Aug-2018)

Right click context menu now correctly prevents Wizard actions when cells contain excel invalid/error data.
Minor Bug fixes with the changes implemented in version 10.0.31

10.0.30 (06-Aug-2018)

Now preventing Wizard actions (upload, download, refresh etc) when cells contain excel invalid/error data.

10.0.29 (03-Aug-2018)

Fixed bug with Attachments form looking at the incorrect invoice ID's.

10.0.28 (03-Aug-2018)

Fixed bugs with clear status columns which was clearing statuses outside of the specified range to clear.

10.0.27 (01-Aug-2018)

Modified messaging and column heading row checks when using clear status columns.

10.0.26 (31-Jul-2018)

Intelligent Data Capture: Downloaded Invoice Images will now upload as URL attachment links in Oracle (Network drive locations). Note this is a band-aid solution for now, whilst we explore full intent for this problem of avoiding uploading Xtracta links as attachments.

10.0.25 (13-Jul-2018)

Fixed bug where Holds/Releases could grab the incorrect invoice ID value when loading Holds/Releases manually.
Holds/Releases will now continue to upload with Status message of 'Ignored'.
Refresh now correctly processes Releases.

10.0.24 (12-Jul-2018)

Loading Holds and Releases now correctly updates the Event_Status_Code value in the xla_events table.

10.0.23 (11-Jul-2018)

Fixed 64bit errors around downloading invoices.

10.0.22 (12-Jun-2018)

Improved error handling.

10.0.21 (08-Jun-2018)

Fixed minor bug introduced in 10.0.20 where Distribution Global DFFs were not returning the correct list of context values.

10.0.20 (07-Jun-2018)

Global DFFs now correctly show the right contexts based on Country Code in Multi-Org setups.
Improved Error Handling management around Upload.

10.0.19 (06-Jun-2018)

Fixed bug where download was not correctly converting ID Based DFF's into values.

10.0.18 (05-Jun-2018)

Improved working with workbooks between windows 7 and windows 10 operating systems.

10.0.17 (05-Jun-2018)

Write error code and error contents to error log sheet if invalid contents returned.

10.0.16 (01-Jun-2018)

"More4Apps PIW: Restrict Overlay Account Override" Profile Option will now only be installed in R12.

10.0.15 (01-Jun-2018)

Added new Yes/No profile option "More4Apps PIW: Restrict Overlay Account Override" which restricts the overlay account from being updated in AP_INVOICES_LINES_ALL for R12.

10.0.14 (31-May-2018)

Intelligent Data Capture: Fixed bug where negative Tax/Freight lines were not getting printed to the Sheet.

10.0.13 (30-May-2018)

Invoice Received Date can now be made mandatory through the Mandatory Fields form.

10.0.12 (30-May-2018)

Fixed VBA Error occurring during validation when Supplier Site column was removed from the Sheet.
Removed misleading column comment on Hold Name column.

10.0.11 (30-May-2018)

Intelligent Data Capture: Invoice Freight and Tax Lines with zero amounts now no longer get written to the sheet.

10.0.10 (21-May-2018)

Added Refresh performance improvements when loading Holds.

10.0.09 (18-May-2018)

Fixed bug when updating R12 Distributions would remove status column cell colouration.

10.0.08 (15-May-2018)

Improved Refresh performance.

10.0.07 (14-May-2018)

PO Matching Quick form position saving now occurs on all button functions.

10.0.06 (11-May-2018)

Fixed right-click context menu display and position for Custom Query.

10.0.05 (11-May-2018)

Updated Downloader to Custom Query.

10.0.04 (10-May-2018)

PO Matching Quick form screen position is now saved on OK/Cancel and will open to its last position when re-opened. This gets reset on Login.

10.0.03 (09-May-2018)

Fixed bugs with PO download all and PO download selected grabbing the incorrect rows.

10.0.02 (04-May-2018)

Improved Wizard Download forms content shuffling between left and right list boxes.

10.0.01 (01-May-2018)

Fixed overflow bug when downloading invoices with more than 32k lines.
Fixed bug with PO Matching form when 'No Open Lines' error was occurring incorrectly for Release PO's in R11i.

10.0.00 (26-Apr-2018)

Updated version for website release.

9.10.08 (24-Apr-2018)

Remit to Supplier now no longer defaults if only one value exists.

9.10.07 (24-Apr-2018)

Fixed bug when downloading on row 11 would apply default row formatting to the downloaded content.

9.10.06 (23-Apr-2018)

Default row is now panel frozen alongside column headers.

9.10.05 (20-Apr-2018)

Fixed bug with PO Matching Helper Form incorrectly displaying data against labels.
Fixed bug with PO Matching Helper Form when trying to download records with blank/zero Quantities.

9.10.04 (19-Apr-2018)

Fixed bug when using PO Matching download with Suppliers that contained apostrophes.

9.10.03 (18-Apr-2018)

Fixed error 6 overflow bug on Submit Validation form when a lot of Batches exist.

9.10.02 (17-Apr-2018)

Fixed Refresh bug introduced in 9.10.01

9.10.01 (17-Apr-2018)

Fixed bug where refresh was including the default row.

9.10.00 (17-Apr-2018)

Improved PO Matching Download Form performance.

9.9.99 (16-Apr-2018)

Fixed bug where Holds/Releases were not correctly clearing status columns before writing to them.

9.9.98 (12-Apr-2018)

Fixed error "PO header, PO line, PO release and PO shipment information does not match" when only providing a release number for single line POs.

9.9.97 (11-Apr-2018)

Formulas defaults from default row 10 will now correctly reference the current row rather than row 10.

9.9.96 (28-Mar-2018)

Additional fixes for 64bit Excel.

9.9.95 (23-Mar-2018)

Fixed bug with default row writing header level defaults across all distributions.

9.9.94 (23-Mar-2018)

Fixed PO Matching Helper Query.

9.9.93 (22-Mar-2018)

Fixed bug where Freight/Tax Lines where giving PO Data errors incorrectly.

9.9.92 (21-Mar-2018)

Made improvements about the PO Data Query.
Fixed 64bit crash when uploading.
Fixed bugs around PO Matching.
Improved performance around Header Validation by modifying the remit to primary defaulting process.

9.9.91 (15-Mar-2018)

Improved the performance of the PO Matching Helper Form.
Improved messaging around the PO Matching Helper.
Fixed bug where unapproved release numbers would bring up the matching helper with 0 lines.
Fixed VBA error when a PO had an unapproved release.

9.9.90 (14-Mar-2018)

Fixed bug where distribution validation was picking up incorrect line level PO Number value.

9.9.89 (13-Mar-2018)

Fixed bug where the Wizard was not respecting having a zero value operating unit.

9.9.88 (12-Mar-2018)

PO Matching Helper Form - Moved the item details further to the left and extended the item description size.
Improved performance of Caching PO Line data by restricting query based on release number - BLANKET type POs must now provide a Release Number.
Added Supplier Item Number to PO Download.

9.9.87 (08-Mar-2018)

Fix for XML parse error caused by incorrect handling of character set encodings.
An invalid character was found in text content.
Removed code that stopped the program running when validating distributions for a customer. This bug was introduced in version 9.9.86

9.9.86 (06-Mar-2018)

More modifications to the upload message.
Added customer licence key control for Default PO Matching Enhancement content.

9.9.85 (05-Mar-2018)

Fixed bug with upload selected when the first row in the selection was not able to find an invoice.
More adjustments made around the return message after uploading invoices.
Fixed bug when PO Defaulting was not correctly comparing sheet values.

9.9.84 (02-Mar-2018)

Downloading PO data is now ordered by; PO Num, Releases, PO Line Num, PO Shipment Num.
Release column is now between PO Num and PO Line Number on the PO Matching Helper form.
Fixed bug where PO Matching Helper form was still popping up when Default PO data was found due to missing Shipment Number.

9.9.83 (01-Mar-2018)

Fixed more bugs around Clear Status columns functionality.
PO Inventory Item now gets written to the sheet when using the PO Matching form.
Fixed performance when caching PO Data.
PO Matching Helper form now correctly filters results on PO release number if it exists.
PO Matching Helper form now shows Release Number and will write the Release Number on any new lines created through the Helper form.

9.9.82 (28-Feb-2018)

Fixed bug in R11 with PO Matching form not correctly retrieving the correct distribution data and where PO Matching form was being popped twice even after matching the PO Line.
Fixed bug where Shipment validation failed on PO Lines that had been matched through PO Matching form.

9.9.81 (28-Feb-2018)

Fixed bug with PO Matching Automation defaulting when a line found multiple matches and did not correctly pop the PO Matching form.

9.9.80 (27-Feb-2018)

Fixed download bug in R11 preventing searches on the Download form.
Fixed a runtime error bug when using Clear Status column function.
Fixed upload bug in R11 around the Unit of Measure column.

9.9.79 (26-Feb-2018)

Fixed bug in PO Matching SQL not finding non-release PO's.
Fixed bug with PO Matching form that was writing blank values instead of 0 for Qty Invoiced, Unit Price and Amount.
Release Number now gets written across each of the lines from a Header Level Release Number via Xtracta Automation.

9.9.78 (23-Feb-2018)

Remit to Supplier and Site columns now do not overwrite user’s values through the sheet.
Fixed by with PO Data Defaulting for customer/Automation where it was not matching on exactly all five conditions (PO, Unit Price, Dist Desc, Quantity Invoiced, Release Num).
Fixed bug where PO Data defaulting was not correctly working when a release was specified.

9.9.77 (21-Feb-2018)

Added PO Data default for PO line and Inventory Item for customer in order to auto match PO's with automation.

9.9.76 (20-Feb-2018)

All precision checked columns on the forms now cannot have values entered with greater precision than specified by the functional precision.
Modified precision error message on forms to be more consistent with the corresponding sheet validation message.

9.9.75 (19-Feb-2018)

Fixed bug where precision was not being correctly applied when specifying a currency code.

9.9.74 (15-Feb-2018)

Increased Wizard memory performance when downloading records using the Download form.

9.9.73 (14-Feb-2018)

Fixed bug where Remit to Supplier/Site was incorrectly defaulting by not respecting organization.
Fixed bug with Remit to Supplier/Site validation.
Fixed download bugs around PO Matching.

9.9.72 (09-Feb-2018)

Fixed validation bug when a remit to site value existed with no Remit to Supplier.
Disabled Remit to Supplier and site upload functionality for Fusion.

9.9.71 (08-Feb-2018)

Fixed bugs relating to when the 'Remit to Site/Supplier' columns are removed from the sheet.
Fixed validation bug on Remit to Supplier and Site columns which would sometimes allow errored values through.
Fixed Fusion custom install error with inserting into invalid table.
Tax Control Amount column now respects the precision of the base currency code.

9.9.70 (05-Feb-2018)

Fixed bug where remit to supplier and site columns were not correctly writing errors back to the sheet and leaving behind red cells e.g. red cells on the sheet with no values, or red cells with last used LOV values.
Fixed bug with Remit to Site/Supplier not clearing correctly on the form when Supplier Site is changed.
Fixed bug with using the Invoice form if when Remit to site and supplier columns removed from the sheet.

9.9.69 (26-Jan-2018)

Remit to Supplier and Remit to Site now correctly function like normal wizard columns and are not just Extra Update only (R12 Only).

9.9.68 (23-Jan-2018)

Single Item Lines with blank Tax Codes now no longer get given the Tax Line Tax Code.
Improvements made with how the upload selected operates.

9.9.67 (19-Jan-2018)

Fixed bug where the sheet was not correctly refreshing when using Duplicate Headers Option.
Obtaining Global DFF Country code through package call instead of profile for R12.

9.9.66 (16-Jan-2018)

Added developer Download debugging tools.

9.9.65 (16-Jan-2018)

Fixed the issue where uploading attachment did not work with the Fusion 9.2

9.9.64 (10-Jan-2018)

Further improvements when refreshing bulk data.

9.9.63 (09-Jan-2018)

Improved download performance when downloading data above existing data.

9.9.62 (05-Jan-2018)

Selected Cell updated during Upload now correctly updates the work sheet your download on.
Improved Performance on Refresh for bulk data.

9.9.61 (03-Jan-2018)

Improved the download performance for large downloads.

9.9.60 (27-Dec-2017)

Excel Memory is now getting correctly re-allocated after performing large downloads. NOTE: During downloading we can use a lot of memory, this fix just makes the memory usage return back to what it was before the download- after the download is completed. This is to help general memory usage within the wizard as it is less likely to hit memory issues by releasing- used memory. This does not fix the problem of a massive download exceeding the memory limit on its own. (i.e. The download being so large - that no matter how much free memory is available it is going to need more than what Excel can handle).

9.9.59 (21-Dec-2017)

Improved Upload Performance of the Wizard and made more responsive.

9.9.58 (19-Dec-2017)

File Attachments are now fixed in Fusion.

9.9.57 (15-Dec-2017)

Fixed the issue where uploading file attachment failed on Fusion with R12 relevant error message.

9.9.56 (11-Dec-2017)

Changed mislabelled label 'Qty Unbilled' to 'Qty Billed' on Receipts for PO Matching Edit Form.
PO Matching Edit Form now correctly displays labels against the columns data.

9.9.55 (11-Dec-2017)

PO Matching form now displays the search result data correctly against the labels.
Changed mislabelled label 'Quantity Unbilled' to 'Quantity Billed' for Receipt Result searches on PO Matching form.
Fixed SQL error when using PO Matching Form searches with Item Filter criteria.
Modified SQL to improve performance accessing Submit Validation form.

9.9.54 (04-Dec-2017)

Automation - Performance adjustments made for downloading data to the sheet.

9.9.53 (16-Nov-2017)

Modified core to allow it to accept the fndEncodeSQL module firewall solution when necessary. To do this swap out the module fndEncodeSQLStubs with fndEncodeSQL.
See google doc: SQL Encoding, Firewalls and SQL Injection https://docs.google.com/document/d/1QhkrLn23h3TOOexn_2m3awAFzYvKbNLvmRlbexA3HyY/edit

9.9.52 (23-Nov-2017)

Internal fix.

9.9.51 (10-Nov-2017)

Customer Taxpayer LOV is now restricted by Entity Name and Operating Unit.

9.9.50 (08-Nov-2017)

Fixed bug where Customer Tax column was not able to correctly find values in the LOV during validation.

9.9.49 (07-Nov-2017)

Fixed bug where Extras was not correctly uploading all selected lines.

9.9.48 (31-Oct-2017)

Fixed bug where Customer Taxpayer column was not being written to through the form.

9.9.47 (27-Oct-2017)

Fixed bug where 'Number Format' button was not correctly storing the cell format and where 'Number Format' was not getting correctly applied through validation.
Added form validation on Customer Taxpayer column (Reg#) to catch when selected values do not match Operating Unit.

9.9.46 (24-Oct-2017)

Improved automation error logging.

9.9.45 (20-Oct-2017)

Fixed bug where Customer Taxpayer column was not correctly downloading.

9.9.44 (17-Oct-2017)

Fixed bug on View Concurrent form incorrectly defaulting the value 'APXIIMPT'.

9.9.43 (16-Oct-2017)

Fixed bug when trying to update paid invoices.

9.9.42 (09-Oct-2017)

Fixed bug with profile option "More4Apps: PIW Limit Invoice Upload" that did not restrict above 500.

9.9.41 (03-Oct-2017)

Updated Security.

9.9.40 (29-Sep-2017)

Removed "No Tax Lines Processing was performed" message - piwMain.UploadLoadedMessage - removed Tax Lines message when no tax data exist.

9.9.39 (22-Sep-2017)

Added default values on 'View Concurrent' for Fusion.

9.9.38 (12-Sep-2017)

Updated Security.

9.9.37 (12-Sep-2017)

Fixed SQL error when updating a lot of data using the Extras process.

9.9.36 (04-Sep-2017)

Fix bug where receipt downloading was missing PO Line Number causing Shipping Number to be invalid.

9.9.35 (01-Sep-2017)

Added Output button on automation Document Processing form.

9.9.34 (30-Aug-2017)

Made more slight changes to post processing messaging.

9.9.33 (29-Aug-2017)

Modified post processing message (ie Uploading, Deleting or Rejecting invoice/lines) to be more meaningful.
Corrected 'Closed' and 'Revert' button labels to 'Ok' and 'Cancel' on the Header and Distribution forms.

9.9.32 (28-Aug-2017)

Fixed bug where number format was incorrectly defaulting as text.

9.9.31 (25-Aug-2017)

Merged changes from special version 9.8.69.11 for customer.

9.9.30 (15-Aug-2017)

Fixed Submit Validation issue where batch ID was not being respected and processed all Batches against the User.
Note: 'Minimum Threshold for Parallel Processing' needs to be set to achieve this, whereby it is now correctly default on form load.

9.9.29 (14-Aug-2017)

Updated Security.

9.9.28 (09-Aug-2017)

Fixed bug when updating Pay Group column through the extras form was entering the 'Meaning' and not the 'Lookup_Code'.

9.9.27 (08-Aug-2017)

Fixed the Fusion only issue getting the error message that user has been changed to another user when two user login at the same time.

9.9.26 (08-Aug-2017)

Fusion - Fixed issue with new Business Units that do not have tax and po system parameters populated.

9.9.25 (02-Aug-2017)

Fixed bug on Extras form where Holds Release checkbox control was being displayed incorrectly on form load.

9.9.24 (24-Jul-2017)

Improved the performance of View Concurrent Requests in Fusion.

9.9.23 (24-Jul-2017)

Set 'More4apps AP Invoice Wizard' as the default value for the Batch Source as per Wizard documentation.

9.9.22 (20-Jul-2017)

Fixed problem where Upload LOV form default SQL would be blank.

9.9.21 (14-Jul-2017)

Fixed bug where searching by pay group on the download form would not return correct results.
Added profile option 'More4Apps: PIW Use Pay Group Meaning' which determines to use the pay group meaning or the pay group code.

9.9.20 (11-Jul-2017)

Fixed "piwMain.Upload_Invoices encountered a runtime error at line 770" while uploading invoices.

9.9.19 (07-Jul-2017)

Fixed automation message popup when clicking refresh when not an automation user.

9.9.18 (07-Jul-2017)

Modified Refresh Call to package for customer so to not send up an ORG_ID value.

9.9.17 (06-Jul-2017)

Fixed bug when a copied selected cell was printed across all blank cells in the row when using the download functionality.

9.9.16 (06-Jul-2017)

Added automation URL columns to the Process Documents and Reject Sheets.
Default row is now correctly displaying on Process Documents and Reject Sheets.

9.9.15 (03-Jul-2017)

Added button to archive selected documents for document automation.
Added automation profile option to allow the archiving of documents "M4APS_PIW_ENABLE_DOCUMENT_ARCHIVING".

9.9.14 (03-Jul-2017)

Updated Security.

9.9.13 (30-Jun-2017)

Fixed KFF Caching issue when changing Operating Unit.

9.9.12 (30-Jun-2017)

Fixed validation bug between Invoice Amount and Tax Control Amount Columns when Amount was 'Calc'.

9.9.11 (29-Jun-2017)

Updated Downloader Modules.

9.9.10 (27-Jun-2017)

Fixed bug where Extra uploads were not loading correctly unless you had holds.

9.9.09 (27-Jun-2017)

Fixed bug where Attachments would link incorrectly when refreshed mid process.

9.9.08 (26-Jun-2017)

Clear Status Columns now also removes the attachments, release and holds status.
Tax Control Amount is now factored in with the Total Balance Calculation when the profile "More4Apps: PIW Deduct Tax Control Amount".

9.9.07 (23-Jun-2017)

Fixed bug for customer in which ORG_ID was still uploading at header level.

9.9.06 (20-Jun-2017)

Fixed the issue where an application_id > 32767 would cause an overflow error.

9.9.05 (20-Jun-2017)

Fixed the issue when getting the add-on errors when opening the Wizard.

9.9.04 (19-Jun-2017)

Fixed bug when selecting 'No' when asked to upload Holds on Refresh.

9.9.03 (15-Jun-2017)

Added fix for customer (11i, 9i Database) to NOT upload ORG_ID in distributions.

9.9.02 (07-Jun-2017)

Fixed SQL Error when submitting for Invoice Validation on 11.5.10

9.9.01 (06-Jun-2017)

Disabled access for 11i users to access the 'Extras' form on the ribbon.

9.9.00 (01-Jun-2017)

Fixed Tasks LOV SQL bug for 12.2.2

9.8.99 (29-May-2017)

Now uploading only account Id in 12.2.4 instead of both account value and account Id for the invoice account column.

9.8.98 (16-May-2017)

Fixed bug where by uploading Tax data from the distribution section would cause a SQL error "Column not allowed here".

9.8.97 (16-May-2017)

Updated Downloader Modules.

9.8.96 (11-May-2017)

Fixed bug when submitting invoice validation to now look at both the applications assigned to the responsibilities request group and concurrent programs.

9.8.95 (01-May-2017)

Updated Security.

9.8.94 (24-Apr-2017)

Fixed bug where GL Date was set as a mandatory field by default.
Fixed bug where Downloader was missing from Toolbar and right click menu.
Fixed runtime error when opening Distributions form.
Fixed Compile error in hidden module modXMLHTTP bug for 11i caused by incorrect new line character.
Fixed active cell row check when clicking on 'Match Distributions using form'.

9.8.93 (21-Apr-2017)

Fixed right click and toolbar menus for download button and download open receipts.

9.8.92 (20-Apr-2017)

Reverted Upload All validation changes made in 9.8.90/9.8.91 as is 'intented' functionality.
Fixed SQL bug when local operating unit was invalid.
Improved performance around default row during upload.

9.8.91 (13-Apr-2017)

Fixed missing toolbar and right click options of some of the recently added features in PIW.
Fixed validation bug introduced in 9.8.90
Added Attachments columns to the Mandatory Fields form.

9.8.90 (12-Apr-2017)

Added Default Row 10.
Fixed issue when Validating/Upload All would ignore invoices/lines with no distribution amount value.

9.8.89 (11-Apr-2017)

Renamed profile option "More4Apps: PIW Limit Invoice Upload" to "More4Apps: PIW Invoice Line Upload Limit".

9.8.88 (10-Apr-2017)

Added Amount Paid and Amount Withheld download columns.
Added profile option "More4Apps: PIW Invoice Line Upload Limit" which limits the amount of lines an invoice can have.

9.8.87 (28-Mar-2017)

Updated Security.

9.8.86 (28-Mar-2017)

Fixed "Create Sub Account" button in Processing Service form - Upload LOV button for Document Processing will now default the first value in the list if there is only one to choose from.

9.8.85 (23-Mar-2017)

Users are now able to Submit Invoice Validation regardless of the request group application.

9.8.84 (22-Mar-2017)

Added to new profile option to restrict the entering licence key function to Sysadmin level users.

9.8.83 (21-Mar-2017)

Added Model and Serial Number columns.

9.8.82 (21-Mar-2017)

Fixed Error 91 when attempting to use the "Document Processing form" on a document that has been archived.

9.8.81 (20-Mar-2017)

Fixed Bug where only 1 tax code would show in the LOV when tax codes had the same name but different case. Also Tax Rate Name duplicates removed. Fixed problem where error message form would continually display even when choosing "continue without showing errors".

9.8.80 (20-Mar-2017)

Added Operating Unit to "Processed Documents Example" sheet.

9.8.79 (17-Mar-2017)

Fixed problem where Download Processed Documents would add a blank line before tax lines instead of after.

9.8.78 (17-Mar-2017)

Fixed problem where independent DFF value sets would not display any value.

9.8.77 (15-Mar-2017)

Fixed SQL error on upload Missing IN or OUT Parameter when DFF LOV SQL contains :LINE_SUM_FOLDER.rcv_transaction_id

9.8.76 (14-Mar-2017)

Amount and Quantity columns downloaded via the Invoice Document Processing tab will now have a number format instead of text.

9.8.75 (14-Mar-2017)

Added Quantity Invoiced and Unit Price fields to the PO Matching Helper form display details.

9.8.75 (14-Mar-2017)

Added Quantity Invoiced and Unit Price fields to the PO Matching Helper form display details.

9.8.74 (06-Mar-2017)

Improvements to the Downloader Ribbon tab.

9.8.73 (20-Feb-2017)

Fixed bug where tax code LOV would show IDs instead of codes in 11i.

9.8.72 (23-Feb-2017)

Fix the issues where users are being logged in with the wrong language. Overrides the language selected on the Login Page to the users EBS preferences default language.
Note – Loss of Functionality. This now means users cannot change languages if they want to.

9.8.71 (20-Feb-2017)

Document Processing Quality Assurance can now be enabled by setting the following profile option: More4Apps: PIW Document Processing Enable QA.

9.8.70 (08-Feb-2017)

Updated Security.

9.8.69.7 (06-Mar-2017)

Fixed issue where users are being logged in with the wrong language.
Further Information: In EBS 12.2 a framework patch has stopped us from being able to select a language in the browser login page.
To work around this problem the language for the user is now being set from user's EBS preferences irrespective of what is chosen on the Browser Login page.

9.8.69 (26-Jan-2017)

Removed the AIW disclaimer from the Setup Sheet.

9.8.68 (18-Jan-2017)

Added the new Setup Sheet.

9.8.67 (17-Jan-2017)

Added Title column to Attachments.

9.8.66 (17-Jan-2017)

Updated Security.

9.8.65 (13-Jan-2017)

"Submit Invoice Validation" can no longer be used if your responsibility is assigned to a request group that does not have that program.

9.8.64 (12-Jan-2017)

Invoice Total will now prompt the user that it's mandatory if they remove it and try to upload.

9.8.63 (12-Jan-2017)

Re-implemented the Invoices Loaded/Validated message box.

9.8.62 (11-Jan-2017)

Invoice Download no longer prints duplicates when there are multiple payment schedules
Invoice Type can now be entered in 11i
Document Category will now error if it has a value and the profile 'Sequential Numbering' is set to 'Not Used' as this is not allowed.

9.8.61 (10-Jan-2017)

Quantity Invoiced and Amount now download correctly from the distributions when download PO details for selected PO.

9.8.60 (09-Jan-2017)

Changed browser settings to suppress JavaScript errors during login.
Core version now: 208.31.1 fndIELogin: 012

9.8.59 (23-Dec-2016)

Fixed error when uploading in 11i.

9.8.58 (22-Dec-2016)

Fixed error as the Downloader add in's profile options were not being installed.

9.8.57 (21-Dec-2016)

When downloading/refreshing documents from the Invoice Document Processing ribbon, formulas will be copied down from row 10.

9.8.56 (19-Dec-2016)

FUSION - Added warning message when trying to search for aliases in the flex form.

9.8.55 (19-Dec-2016)

Remit to Bank Account can now be cleared using the Extras functionality by entering [BLANK] into the cell.

9.8.54 (16-Dec-2016)

Fixed error when trying to open the DFF Context form when no data existed on the sheet.

9.8.53 (16-Dec-2016)

Fixed misaligned Distribute button in PO Matching Helper form.
Removed the JPG button from the PO Matching Helper form.

9.8.52 (08-Dec-2016)

Fixed error when downloading Selected PO’s.

9.8.51 (08-Dec-2016)

Additional change required for previous fix.

9.8.50 (07-Dec-2016)

Download Selected POs will now download supplier information for POs that have a site which isn't a pay site.

9.8.49 (05-Dec-2016)

Updated Security.

9.8.48 (02-Dec-2016)

Fixed incorrect "Must provide PO line for multi line PO" when using the PO Matching Helper form distribute button.

9.8.47 (02-Dec-2016)

Fixed SQL error with "match_option" in PO Matching Download form when match type is "Receipt".

9.8.46 (30-Nov-2016)

Download details for Selected PO(s) now downloads all shipments - receipted or not (consistent with the form download).

9.8.45 (29-Nov-2016)

Improved performance of mass uploads. Performance was affected when the PO Matching Helper form was implemented.

9.8.44 (29-Nov-2016)

FUSION - Fixed SQL error ["SECURITY_GROUP_ID": invalid identifier] when installing profile options. This occurs the first time the Wizard is run on an instance.

9.8.43 (28-Nov-2016)

Fixed bug where POs with one open and some closed lines would error when no PO line number was entered on the sheet.

9.8.42 (24-Nov-2016)

FUSION - Modified the Expenditure Type LOV as values were not displaying.
FUSION - Fixed SQL errors with Tax Code and Intended Use.

9.8.41 (22-Nov-2016)

Fixed bug where having PO matched lines, GL/PA lines and Tax lines would result in "PO Line required for multi-line PO" message.

9.8.40 (21-Nov-2016)

Fixed a bug where PO Line numbers were entered without PO at line level which caused a "PO Line required for multi-line PO" on non-matched lines. This will only occur if there were other lines that did have a PO number entered at line level.

9.8.39 (18-Nov-2016)

Added ‘Distribute’ button to the PO Matching Helper form to allow users to enter GL/PA information using the Distribution form during validation.
Cursor will now move to the row in question when the PO Matching Helper form opens.
Rows 1-9 are now frozen panes on the "Rejects" and "Processed Documents Example" sheets.
The total amount validation no longer runs when using the 'Match Selected Invoice Line' ribbon button.
Renamed ribbon button 'Edit Selected PO Line' to 'Match Selected Invoice Line'.
Added a new button to the ribbon called 'Match All Unmatched Invoice Lines'. This performs the same matching functionality as 'Validate' but give the user a clearer way of selecting this.
Fixed bug where you would get an import error if you loaded non-PO-matched lines when you had a multi-line PO entered at header level.

9.8.38 (17-Nov-2016)

Fixed bug where the PO Matching Helper form would not be visible and caused the spreadsheet to become unresponsive.

9.8.37 (17-Nov-2016)

Removed old piece of AECOM customization that was causing an error on one of their databases.

9.8.36 (15-Nov-2016)

Fixed a bug with AECOM customization.

9.8.35 (15-Nov-2016)

Fixed error with Tax Code SQL when more than 1000 tax codes exist.

9.8.34 (14-Nov-2016)

Added a splash form when refreshing to eliminate errors caused from interrupting the refresh in progress.

9.8.33 (14-Nov-2016)

Liability Account Combination LOV is now restricted to Liability type accounts.

9.8.32 (14-Nov-2016)

Fixed SQL error when opening Header form after validating with an invalid Legal Entity on the sheet.
Fixed error when PO Number and project info existed on the sheet and PO had no valid lines.
Potentially fixed a bug with customer customization.

9.8.31 (11-Nov-2016)

Fixed error in 11i when searching for receipts in the PO Matching form.

9.8.30 (10-Nov-2016)

Fixed bug where the PO Matching Helper form would open when an account was entered.

9.8.29 (10-Nov-2016)

Added new columns "Start Expense Date" and "End Expense Date" to sheet for upload and download.

9.8.28 (09-Nov-2016)

Added ‘Document Uploader’ button to the ‘Invoice Document Processing’ ribbon tab.
The ‘Document Uploader’ button opens a browser page to drag and drop documents which are then uploaded to the processing service.

9.8.27 (07-Nov-2016)

Fixed bug where the Document Processing Profiles would not be saved correctly.

9.8.26 (07-Nov-2016)

Updated Security.

9.8.25 (04-Nov-2016)

Added AECOM Customization to default the expenditure organization from their API.

9.8.24 (26-Oct-2016)

Added new download only column "Match Option" for PO Downloads.

9.8.23 (11-Oct-2016)

Fixed the tab order in the Distribution form.
Changed missing custom packages message to be a bit more informative.
Fixed error in DFF form when switching to a context with dependent txt controls (not Combo Box).

9.8.22 (10-Oct-2016)

Fixed error in hidden module when opening the Wizard.

9.8.21 (06-Oct-2016)

Updated the Downloader functionality.

9.8.20 (04-Oct-2016)

Added an Undo function for Clear Status Columns.
Fixed bug where downloading "Invoices" from the "Invoice Document Processing" tab would create attachments with .jpg extension instead of .pdf.

9.8.19 (30-Sep-2016)

Fixed bug where PO Line SQL would run even when there was no PO numbers on the sheet causing performance issues - also added status message.
Added "Clear Status Columns" button to the ribbon.

9.8.18 (23-Sep-2016)

Fixed bug where Tax Codes entered against an Invoice Date that is not in the current rate date range would error (They were valid for a previous tax rate date range).

9.8.17 (21-Sep-2016)

Fixed error when refreshing if multiple various operating units exist on the sheet with blank lines in between.
Complex POs are now allowed to be matched to (Requires M4APS_PAYINVIZARD 3.4.5).

9.8.16 (19-Sep-2016)

"Remit to Supplier" and "Remit to Site" now download from the Payment Schedule level.
Extras now allow you to clear the values for "Remit to Supplier" and "Remit to Site" by entering [BLANK] in the field (Requires M4APS_PIW_CUSTOM 1.1.4).

9.8.15 (16-Sep-2016)

Fixed SQL error when downloading invalid PO lines.

9.8.14 (14-Sep-2016)

Download Selected POs will now leave invalid POs on the sheet and mark them red when profile ‘More4Apps: PIW Retain Invalid PO Download Criteria’ is set.

9.8.13 (12-Sep-2016)

Fixed incorrect initialization of OUs resulting in errors when invalid operating units existed for a mass multi OU update (holds and releases).

9.8.12 (09-Sep-2016)

Added fix for loading mass releases (without holds) across different operating units.

9.8.11 (08-Sep-2016)

Additional fixes to multi-org mass loaded holds and releases.

9.8.10 (07-Sep-2016)

Fixed error when uploading holds when invoices that were "selected for payment" would cause a no_data_found exception for the entire batch of uploads.

9.8.09 (07-Sep-2016)

Fixed bug where Tax line would not be written to the sheet when downloading invoices via the "Invoice Document Processing" tab.

9.8.08 (06-Sep-2016)

Fixed for extras when loading multiple releases across operating units.

9.8.07 (06-Sep-2016)

Fixed for extras when loading multiple holds across operating units.
Fixed automation error when using the Downloader (tab) with no filters.

9.8.06 (05-Sep-2016)

Extras functionality now works across operating units for Multi-Org sites.

9.8.05 (05-Sep-2016)

Updated Security.

9.8.04 (01-Sep-2016)

Fixed issues with returning incorrect Payment Methods with PO Downloads.

9.8.03 (31-Aug-2016)

Fixed error when uploading attachments when the Invoice ID was not populated.
Fixed the issue that when attachment type is URL the format of URL shouldn't be checked for non-fusion database.

9.8.02 (30-Aug-2016)

Fixed error when uploading attachments in Fusion.

9.8.01 (30-Aug-2016)

Added attachment support for Fusion.

9.8.00 (30-Aug-2016)

Fixed whitespace issue encountered with Fusion Invoice import.

9.7.99 (29-Aug-2016)

Fixed issue with submitting Fusion Invoice imports, and opening Batch Source form in Fusion.

9.7.98 (22-Aug-2016)

Multiple fixes to the Document Processing Service.
JPG is no longer used as it does not work well with multi-page invoices, PDF will be written to attachments instead.
Fixed issue where leading zeros would be stripped off values (e.g. Invoice Number). Fixed issue where uploading large amounts of suppliers using "Upload LOV" could fail (Somewhere between 10,000 and 15,000).
Added the "Dist Description" column to the "Processed Documents Example" sheet.
Fixed bug where refresh would continuously loop when clicking off excel, eventually resulting in an error.

9.7.97 (19-Aug-2016)

Changes to the Payables Import for Fusion environments.

9.7.96 (17-Aug-2016)

Additional fix required for issue in V9.7.95

9.7.95 (16-Aug-2016)

Fixed bug where tax lines would not adopt their associated item line's account when using line group numbers and prorate ‘No’.

9.7.94 (11-Aug-2016)

Fixed issue where the Award Number was not being uploaded.

9.7.93 (11-Aug-2016)

Fixed bug where upload would continue even when Requester/User Name is invalid.

9.7.92 (08-Aug-2016)

Corrected tooltip for Requester and Requester User Name.
Added Requester User Name column - This will ensure that a unique requester is used so the user will not be prompted to choose from duplicates when uploading.

9.7.91 (28-Jul-2016)

Fixed the tab order in the Header form.
Invoices can no longer be put on hold if the invoice has been paid.
Fixed the Requester User Name LOV showing invalid requesters.
Added columns "Remittance Message 2" and "Remittance Message 3".

9.7.90 (27-Jul-2016)

Rearranged "requester user name" and "requester" columns and fixed tab order in the form.
Fixed error in Fusion where submit was not working correctly for batch invoices.
GL Date is no longer required in Fusion.

9.7.89 (27-Jul-2016)

Added ‘Requester User Name’ to the Template123 sheet.

9.7.88 (27-Jul-2016)

Added new column "Requester User Name" to uniquely identify requesters.
Fixed bug where ‘Downloader’ would be duplicated in the right click menu.

9.7.87 (15-Jul-2016)

Fixed AECOM default expenditure org customization not defaulting.

9.7.86 (15-Jul-2016)

Fixed USER_ID errors when logging in to Fusion environment.
Fixed Get_Delimiter errors when logging in to Fusion environment which also caused "oops not cached" and "invalid use of null" error.

9.7.85 (14-Jul-2016)

Fixed multiple minor display issues.
When downloading processed document, amount fields will now be correctly formatted as numbers and other fields will be ‘General’.

9.7.84 (06-Jul-2016)

Fixed bug where upload attachments button was enabled when mandatory information was missing.

9.7.83 (05-Jul-2016)

Fixed bug where Tax Codes were incorrectly marked invalid when multiple rates existed for the tax code and one of them had an end date before today’s date.
Fixed errors in invoice form when Supplier Name or Remit to Supplier columns were not on the sheet.
Fixed bug when viewing the Document Tracking form with mass amounts of invoices.

9.7.82 (01-Jul-2016)

GL Date is now a required field for Fusion (private instance).
All five DFF forms will now show in the right click menu.
Language fix for downloaded Numbers.
Fixed bug where Attachments would falsely state loaded when attempting to attach to a Pending row with an interface ID.
Fixed bug where using formulas in download selected receipt ranges would not work because the values were cleared out.
Fixed up Download form required criteria message.

9.7.81 (04-Jul-2016)

Implemented the Downloader ribbon tab.

9.7.80 (01-Jul-2016)

Fixed error when uploading holds to downloaded invoices.

9.7.79 (01-Jul-2016)

Ensured all PO Approved checks are in place.

9.7.78 (30-Jun-2016)

Submit Invoice Validation form is now disabled for Fusion.
Corrected the LOVs for R12 Tax columns (Regime, Code, Status, Tax, Jurisdiction) in Fusion.
Fixed XML Parse error when searching for Receipts in the PO Matching form with PO Number as criteria.

9.7.77 (09-Jun-2016)

Fixed bug where end-dated GL Accounts would not be errored in some cases.

9.7.76 (08-Jun-2016)

Fixed issues with Tax Rate Name LOV not populating correctly.

9.7.75 (02-Jun-2016)

Fixed error when validating and "Statistical Quantity" is not on the sheet.

9.7.74 (02-Jun-2016)

Fixed bug where invoice would continue to upload even when GL accounts were closed or not postable.

9.7.73 (30-May-2016)

Fixed incorrect "No open lines found for this PO" message when the PO is not project related.
Fixed error when opening PO Matching Download form when invalid supplier info exists on the sheet.

9.7.72 (26-May-2016)

Fixed "Invalid use of Null" error in Distribution form when validating tasks.

9.7.71 (26-May-2016)

Fixed "Invalid use of Null" error in Distribution form when validating tasks.

9.7.70 (24-May-2016)

Fixed multiple accounting sources incorrectly erroring even though "PA: Allow Override of PA Distributions in AP/PO" was set.

9.7.69 (17-May-2016)

Quantity invoiced can now be uploaded without PO information and downloads correctly.

9.7.68 (13-May-2016)

Batch Source can now be validated in the extension package.

9.7.67 (12-May-2016)

Implemented Assessable Value column for R12.2.4 and above.

9.7.66 (06-May-2016)

Fixed error when opening the PO Matching form when Supplier Number is removed from the sheet.
Fixed "Supplier Name does not match Supplier Number" error when Supplier Number was removed from the sheet.

9.7.65 (05-May-2016)

Experimental fix for "numeric or value error" on upload when doing large uploads.

9.7.64 (04-May-2016)

Implemented high level error handling for uploads.

9.7.63 (02-May-2016)

Added mandatory field option for "Document Category".

9.7.62 (14-Apr-2016)

Fix for site not downloading in some cases using open receipt sheet download.

9.7.61 (06-Apr-2016)

Fixed issue with Download Open Receipts via Sheet where the supplier site would not be populated.

9.7.60 (29-Mar-2016)

Fixed error where UOM could be rejected by the import when duplicate UOM codes exist with different cases e.g. EACH and Each.

9.7.59 (24-Mar-2016)

PO Matching Helper form will now display when multiple shipments exist for the same line.
Major performance improvement to multiple PO Download (via sheet) when supplier information doesn't exist.

9.7.58 (17-Mar-2016)

Implementing more Fusion functionality.

9.7.57 (16-Mar-2016)

Fixed incorrect payment method downloading from "Download Details for Selected PO(s)".

9.7.56 (16-Mar-2016)

Implemented Distribution Level PO Matching via the PO Matching Helper form.

9.7.55 (07-Mar-2016)

PO Matching Helper form will no longer display for Tax and Freight lines.

9.7.54 (03-Mar-2016)

PO Line - Item Description now displays the full value as per Oracle.

9.7.53 (03-Mar-2016)

Fixed JPG and PDF buttons not working on the PO Matching Helper form.

9.7.52 (03-Mar-2016)

Fixed PO Distribution download duplicating rows for multiple shipments.
Item Description is now obtained from the inventory item description rather than the PO line.
Charge account description is now displayed as per Oracle Forms.

9.7.51 (02-Mar-2016)

When PO Number and Project Number are entered and the profile ‘More4Apps: PIW Enable PO Matching Helper Form- is set to true - Wizard will attempt to default the PO Line, PO Shipment and PO Distribution Number, and ignore the Project Number when uploading.

9.7.50 (01-Mar-2016)

Phase 1 of Fusion Implementation.

9.7.49 (25-Feb-2016)

Implemented controls on Submit Invoice Validation form - From Invoice Date, To Invoice Date, Supplier Name, Pay Group, Invoice Number, Set of Books.

9.7.48 (25-Feb-2016)

Updated Security.

9.7.47 (23-Feb-2016)

Added new PO Distribution fields to the PO Download.
Added Line Amount to the PO Helper form header. Widened PO Helper form slightly.

9.7.46 (19-Feb-2016)

Added Supplier Item Number and Dist Description on the PO Matching Helper form.

9.7.45 (19-Feb-2016)

Supplier Name is now validated to match Supplier Number.

9.7.44 (18-Feb-2016)

Fixed "No Open Lines found for this PO" message incorrectly displaying.

9.7.43 (16-Feb-2016)

Fixed bug where Account was validated against the current date instead of the GL Date.

9.7.42 (10-Feb-2016)

Fixed error handling issue when validating invoices.

9.7.41 (05-Feb-2016)

Fixed freezing when PO columns not on the sheet.

9.7.40 (29-Jan-2016)

Fix for Wizard hanging when PO Helper SQL returns no data.
Download Open Receipts - When there is multiple pay sites for the supplier then return no site.

9.7.39 (27-Jan-2016)

When using a directory to store processing service documents, downloaded processed documents will now display an Attach Type of 'File'.
Performance Improvements to the PO Matching Helper.

9.7.38 (25-Jan-2016)

Download Details for POs now excludes cancelled and closed PO Lines and Shipments.
Fixed bug where shipment lines were not being counted correctly and so the PO Helper form was not appearing when shipment information was missing.

9.7.37 (25-Jan-2016)

Fixed SQL error when downloading open receipts.

9.7.36 (22-Jan-2016)

Download Open Receipts from Sheet now gets supplier/site information from the supplier rather than the receipt.
Download Open Receipts from Sheet now downloads the Quantity Unbilled (Quantity Invoiced - Quantity Received).

9.7.35 (21-Jan-2016)

Project Information is now displayed on the PO Matching Helper form.

9.7.34 (21-Jan-2016)

Inventory Item now downloads correctly for Receipt downloads.

9.7.33 (23-Dec-2015)

Fixed Wizard freezing when validating, and P.O. Number - Line Level was not on the sheet.

9.7.32 (23-Dec-2015)

When no open lines exist for a PO, the Wizard will throw an error.

9.7.31 (22-Dec-2015)

Updated Security.

9.7.30 (21-Dec-2015)

Added warning message when trying to open the PO Matching Helper form and profile is turned off (the form will not open).
Unit Price is no longer editable in the PO Matching Helper form, but will change to reflect the match amount.
Quantity invoiced will no longer display negative values, it will display 0 instead.

9.7.29 (21-Dec-2015)

Fixed valid Supplier error when ‘More4Apps: PIW Enable PO Matching Helper Form’ is not ‘Yes’.

9.7.28 (21-Dec-2015)

PO Matching Helper Form - PO Info that returns 0 for Quantity, Amount or Unit Price will display as blank and required colour:
- Supplier Name is now displayed
- Aligned header labels
- Widened Match Column field as it was a bit squished

9.7.27 (17-Dec-2015)

Added button ‘Edit Selected PO Line’ which opens a form to edit the selected PO Line and select different lines.
Fixed bug where a PO not belonging to the Supplier on the sheet would cause the Supplier to be invalid.

9.7.26 (14-Dec-2015)

Fixed PO Lines not being cached properly when opening the Lines form.

9.7.25 (14-Dec-2015)

Fixed issue where PO Matching Helper form was not opening when it should have been.

9.7.24 (14-Dec-2015)

Profile Option ‘More4Apps: PIW Enable PO Matching Helper Form’ must be set to Yes to use new PO Matching functionality.

9.7.23 (10-Dec-2015)

Fixed supplier error when no POs on the sheet.

9.7.22 (07-Dec-2015)

Fixed number values being written to the sheet incorrectly for foreign languages.
Added new PO Matching form which will prompt to enter missing PO information during upload.

9.7.21 (27-Nov-2015)

Added missing Supplier Item Number column functionality.
Document ID cells are no longer coloured the standard data cell teal on validation.
When a Document is archived, the cell now changes to the green processed colour.
Widened the submit batch form and batch name dropdown column widths so larger batch names are visible.

9.7.20 (26-Nov-2015)

Fixed "Stream has already been closed" error.

9.7.19 (26-Nov-2015)

Fixed bug with download selected POs where multiple POs with varying line number criteria would bring back too many results.

9.7.18 (25-Nov-2015)

Modified the "Download Details for Selected PO(s)" to filter on "P.O. Number - Line Level" and "P.O. Line Number".
Supplier Name is no longer required for downloading selected PO’s.

9.7.17 (19-Nov-2015)

Merged Document Processing Functionality.
Fixed bug where Attachments would error when 'Attach Desc' column was not on the sheet.
Fixed bug where Document Refresh would write back incorrectly for a certain situation - more details in OCR Manager.

9.7.16 (11-Nov-2015)

Added 'Debug Upload' option to the setup ribbon tab and implemented the functionality for ribbon and toolbar.
When incorrect character case is detected in a form LOV, the value is now corrected rather than errored.

9.7.15 (11-Nov-2015)

Fixed bug in unit price * quantity where it would incorrectly error valid values

9.7.14 (10-Nov-2015)

Fixed persistent invalid colour in form when clicking the search button on controls already containing a valid value

9.7.13 (09-Nov-2015)

Fixed 'Submit Invoice Validation' problem with order of parameters and incorrectly excluding enabled (but not displayed) parameters

9.7.12 (06-Nov-2015)

Fixed bug where clicking cancel on the submit import form would prevent invoice validation from submitting

9.7.11 (04-Nov-2015)

Implemented ‘Submit Invoice Validation’ button for submitting the Invoice Validation Concurrent Request.
Replaced ‘Approve’ button with ‘Submit Invoice Validation’.
Ordered the toolbar/right click menu to match the ribbon order.

9.7.10 (02-Nov-2015)

Made the failed Dist DFF upload message more descriptive

9.7.09 (28-Oct-2015)

Added message to clear status columns when nothing is loaded when doing a multiple selection update from the Extras form

9.7.08 (23-Oct-2015)

Updated BlockList.
Fixed bug where payment priority and discount amount would update using the value from the first row for all selected records.

9.7.07 (23-Oct-2015)

Fixed Tax Rate Name error in Validate as this was rejecting for the same reason as above

9.7.06 (22-Oct-2015)

Fixed bug where Tax Rate Name would not be displayed when the Jurisdiction code was different to the description.
Improved performance of caching tax rate names - removed the Union in the SQL as it was not doing anything but slow down the query.

9.7.05 (19-Oct-2015)

Fix for Application Object Error if Supplier Name column missing from sheet when opening Invoice Header form.
‘Validation Messages’ button tooltip now says "highlighted" instead of "orange" as the colour varies between excel versions.
Fixed SQL error when searching for Purchasing Category.
Added new button ‘Approve’ which Calls the Approval API for all needed invoices on the sheet.
Removed Unit of Measure upload for 11i - Interface column unit_of_meas_lookup_code only available in R12.
Fixed bug where using upload selected on multiple invoices could cause invoices below the selection to be uploaded.
Added warning message on upload when Distribution DFF profile is set and Required columns are missing from the sheet.
Fixed error when loading Dist DFFs when 'Line Number' exists on the sheet but 'R12 Dist Status' doesn't.
Fixed Excel 2013 bug where entering values in a sheet after creating a new sheet would write to the wrong sheet after tabbing.
When PO Number exists but no supplier/site info exists, default the supplier/site info to the sheet as it is needed for the upload and refresh.
When Using Refresh, Attachments and Extras Functions - The Invoice ID can now be derived from the Invoice Number/Supplier combination.

9.7.04 (16-Oct-2015)

Added profile option "More4Apps: PIW Enable Multi Org Import" which allows import for multi-org (does not pass the OU parameter to the import program)

9.7.03 (13-Oct-2015)

Added new clauses to PO search SQL so the list is more consistent with Oracle.
Refresh will now only check the status of Invoices with 'Pending' and 'Error' Status.
Fixed PO/Supplier validation bug.

9.7.02 (08-Oct-2015)

Rearranged the controls on the PO tab of the Distributions Form.
Fixed bug where Supplier Site would be cleared when opening form in 11i.
Fixed bug where invalid Remit To Bank Account would stop the entire validation process.
Fixed another issue where a valid Remit To Bank Account would error on the first validation run.
Fixed error in download after switching from an R12 instance to 11i.

9.7.01 (07-Oct-2015)

Fixed bug where attachments would be rejected on first attempt.
Fixed bug where Remit to Bank Account was not validating on the sheet.
Fixed error when downloading in 11i - Remit to Supplier and Site are not available for 11i.
Fixed bug where Pay Group would be marked invalid if the name was different to the code in the form - code is now the first column in the SQL.

9.7.00 (05-Oct-2015)

Moved P.O. validation to the server-side to improve performance.
Mandatory upgrade to Package Body 3.4.0

9.6.75 (30-Sep-2015)

Modified Type1099 profile description as it was not escaping single quotes properly on customer system

9.6.74 (25-Sep-2015)

Added new profile option "More4Apps: PIW Disable Type1099 Default" which disables Tax Type default and inserts 'NA' into the type_1099 interface column

9.6.73 (23-Sep-2015)

Added Currency Code Substitution for customer

9.6.72 (21-Sep-2015)

Fixed bug where RetrieveLegalEntity was not actually returning the answer

9.6.71 (16-Sep-2015)

PO Line Number will now default based on inventory item if 1 match is found and new profile More4Apps: PIW Suppress Deriving Line from Item is not "Y".
Added new Function Default_PO_Line which is called in Validate_Distribution to derive the poline from the item.

9.6.70 (16-Sep-2015)

Fix for Tax Regimes LOV not considering Legal Entity Override value on sheet

9.6.69 (29-Aug-2015)

Added two substitutions for customer. Needed to handle patch not installed better.
Handled null in Substitutions proc by changing ReplaceCase to accept Variants

9.6.68 (28-Aug-2015)

Added R12 check to prevent caching of Remit to Suppliers

9.6.67 (27-Aug-2015)

No longer attempt to cache Remit to Suppliers in 11i as this column does not exist

9.6.66 (21-Aug-2015)

Fixed SQL error when opening header form

9.6.65 (18-Aug-2015)

Do not attempt to cache Remit to Suppliers when we don't have supplier and site

9.6.64 (30-Jul-2015)

Fixed limit responsibility issue

9.6.63 (23-Jul-2015)

Added a no data found exception when checking bug number in GetMainMultiCall

9.6.62 (29-Jun-2015)

Fixed incorrect tax amount validation when using negative values

9.6.61 (15-Jun-2015)

Added ability to upload duplicate invoice numbers for the same supplier when the site is different

9.6.60 (05-Jun-2015)

Downgraded core to version 208.31 because WebTestDB is broken in 208.32 for r12

9.6.59 (04-Jun-2015)

Fixed bug in 11i where Wizard failed during login.
Fixed bug where query would error (Error in XML processing ORA-00907) if the supplier name contains an apostrophe

9.6.58 (26-May-2015)

Added line_location_id substitution for Case

9.6.57 (30-Apr-2015)

Added Remit to Supplier/Site Updates to the Sheet, Invoice Form, Extras Form and the Download SQL

9.6.56 (15-Apr-2015)

Updated to Core 208.30
Moved Update Release position on Settings123 due to core change

9.6.55 (27-Mar-2015)

Remove balancing segment as causing problems

9.6.54 (19-Mar-2015)

Fixed error caused by the ‘Account’ column not being on the sheet

9.6.53 (18-Mar-2015)

Check R12 before downloading taxation country in header sql

9.6.52 (16-Mar-2015)

Fixed Ids being written instead of values when download DFFs

9.6.51 (11-Mar-2015)

Added default for account when it's blank and the invoice type is pre-payment.
Fixed column alignment issue with the PO Match Edit Form when matching receipts.

9.6.50 (06-Mar-2015)

Removed deferred accounting period validation, this is incorrect since Oracle patch#12902832:R12.AP.B
Added cell comments for 'Deferred Acctg Start Date' and 'Deferred Acctg End Date'

9.6.49 (06-Mar-2015)

Get the cached default tax country first, then try the site country.
Found that the site country is not correct for foreign sites because the fiscal class depends on this and foreign sites bring back no LOV.

9.6.48 (04-Mar-2015)

If Tax amount needs to be rounded, the wizard will now prompt the user as it does for dist amount and unit price

9.6.47 (26-Feb-2015)

Tax control amount no longer needs to be less than the invoice total for CREDIT MEMOS

9.6.46 (23-Feb-2015)

Remit to Bank Account and Expenditure Organization are now search lists on the form to prevent the queries timing out on form load

9.6.45 (19-Feb-2015)

Added Line DFF form ribbon option

9.6.44 (18-Feb-2015)

Prevent custom update executing when only Distribution DFF update running

9.6.43 (18-Feb-2015)

Removed the Settings123 checks for the DFF form ribbon button as Settings123 is no longer used to control this

9.6.42 (18-Feb-2015)

Fix for bug in KFF form where parents with no value set were incorrectly disabling child controls

9.6.41 (18-Feb-2015)

Fix for very extremely numbers generated from database sequence for Invoice and Distribution interface table IDs

9.6.40 (13-Feb-2015)

Invoice Batches form was not accepting today's date as the default for Invoice Date when testing for GL Date period range.
Support added for Translated Independent value sets used in Descriptive Flexfields

9.6.39 (11-Feb-2015)

Same fix as above for receipt line number - also corrected the interface column for receipt line number

9.6.38 (10-Feb-2015)

Store the value for receipt number in the variable even when M4APS_PIW_NOCHECKPO is set to yes so we upload the unvalidated value

9.6.37 (09-Feb-2015)

Added profile option 'More4Apps: PIW Disable Key Flexfield Security in Form' to prevent KFF Security affecting KFF form LOVs

9.6.36 (17-Jan-2015)

Fixed minor tab order issue in new KFF form fields

9.6.35 (14-Jan-2015)

Improved performance of Remit to Bank Account validation

9.6.34 (12-Jan-2015)

Fixed bug where attachment errors were written to the wrong row

9.6.33 (12-Jan-2015)

In Get_Letter_Add_To_Section - changed Get_Letter to getLetter as Get_Letter was returning the index causing an error with missing columns

9.6.32 (08-Jan-2015)

Added rounding to amount in Receipt Download from Sheet.
Improved performance of Receipt Download.

9.6.31 (07-Jan-2015)

Changed format of flexfield cells in Settings123 from General to Text

9.6.30 (08-Dec-2014)

Added Edit Match Multi which allows users to edit multiple PO lines efficiently in the PO Matching form by double-clicking on a line in the form.
Made the PO Matching form resizeable.

9.6.29 (04-Dec-2014)

Replaced FormDFFContextDefault and DFFContextDefault with the procedure specified in customer case

9.6.28 (26-Nov-2014)

Fixed freezing when clicking Cancel on a form

9.6.27 (21-Nov-2014)

Updated DKFF error message

9.6.26 (14-Nov-2014)

Fixed issues with DKFF

9.6.25 (12-Nov-2014)

Increased the width of the Item column on the PO Matching form

9.6.24 (12-Nov-2014)

Corrected ‘Quantity Billed’ label to ‘Quantity Unbilled’ on the PO Matching form.
Added a more descriptive comment to the Quantity Unbilled column.

9.6.23 (10-Nov-2014)

Fixed issue with Supplier Site default

9.6.22 (05-Nov-2014)

Fixed issue with Task validation

9.6.21 (31-Oct-2014)

Added Invoice Type as criteria on the download form

9.6.20 (30-Oct-2014)

Altered Task SQL for 12.2.2 onwards

9.6.19 (29-Oct-2014)

Added :INV_SUM_FOLDER.INVOICE_AMOUNT Substitution for customer

9.6.18 (29-Oct-2014)

Cache DKFFs based on Structure ID, not App Code because this is not unique

9.6.17 (23-Oct-2014)

Added Caching of DKFF information to improve performance.
Key Flexfield segment controls are now coloured white when they are not required.
Now downloading the distribution line type into the Line Type column.
Added R12 Dist Status column to prevent re-updating of the Distribution DFFs.
Added Tax Country to the header download.
Added Line Number to the download.
Added Reminder when updating Dist Dffs telling the user to validate their invoices.

9.6.16 (21-Oct-2014)

Expense Reports can now be downloaded in R12

9.6.15 (20-Oct-2014)

Added IsBlank checks on value set ID when disabling KFF segment controls as these are not set for DKFFs

9.6.14 (14-Oct-2014)

Added Support for Descriptive Key Flexfields.
Made PO Number display larger in forms.

9.6.13 (02-Oct-2014)

Added Supplier Tax Columns

9.6.12 (26-Sep-2014)

Inventory Item now downloads with PO Information.

9.6.11 (24-Sep-2014)

Fixed Issues with DFF dates not displaying correctly

9.6.10 (19-Sep-2014)

Added Discount Amount from the Payment schedule to 'Extras' group of columns for updating existing invoices

9.6.09 (11-Sep-2014)

Fixed bug where having a PO Number, NO Supplier details and Skip P.O. Validation turned on would prevent an upload.

9.6.08 (03-Sep-2014)

Added case insensitive :INV_SUM_FOLDER.INVOICE_DATE and :INV_SUM_FOLDER.TERMS_NAME Substitutions

9.6.07 (20-Aug-2014)

Added: INV_SUM_FOLDER.INVOICE_NUM Substitution

9.6.06 (30-Jul-2014)

Added payment_num column including support for multiple payment schedules on Download.
Changed Tax Jurisdiction SQL so that code and name have swapped places as we should be using the code
Tax Regime now displays the code, not the name, as per Oracle
Removed multiple tax lines with same tax code restriction as Oracle accepts this
Added WorkFlow Flag column

9.6.05 (24-Jul-2014)

Renamed the Waybill/Airbill column to Waybill Airbill (Removed the slash) as it was causing issues with the download.

9.6.04 (23-Jul-2014)

Updated Core for 12.2.3 Compatibility

9.6.03 (19-Jun-2014)

Modified the PO Download SQL to include receipt information and the Quantity Received and Quantity Unbilled

9.6.02 (11-Jun-2014)

Added R12 Columns Item Description, Reference1 and Reference2 columns
Note - Reference columns exist in the interface for 11i but do not seem to submit. They do download if entered in Oracle forms.

9.6.01 (10-Jun-2014)

Fix for fault in Refresh procedure when Tax Lines are included in the invoice

9.6.00 (04-Jun-2014)

Fix for problems caused by server-side validation of Project related distributions. Requires package body version 3.3.0
Removed Project Status from R11i LOV as not available in Oracle view.
Disabled all the Merchant columns for R11i.
Fix for minor Expenditure Type validation bug.
Fix for ‘Rejected’ status for Invoice appearing on the wrong row

9.5.21 (03-Jun-2014)

Legal Entities performance improvement

9.5.20 (13-May-2014)

Performance Improvement to ‘Upload All Invoices'

9.5.19 (13-May-2014)

Added Status, Start Date and End Date to the Project Number LOV
Added Debug Mode Checkbox to Submit Batch form

9.5.18 (13-May-2014)

Attachments now set colours for the correct row and upload the correct content
Added Profile Option M4APS_PIW_DISABLEPOMATCH, when set true prevents the user from using any of the functions under the PO Matching button

9.5.17 (09-May-2014)

Fix for bug in 'Validate only' mode released in 9.5.00

9.5.16 (09-May-2014)

Fixed Payment Columns not colouring white on upload.
Attachment form now resets the cursor position after checking the status

9.5.15 (01-May-2014)

When a PO and PO Line are selected at line level, we now pass up the inventory item id for that po line.

9.5.14 (18-Apr-2014)

Profile option 'More4Apps: PIW Disable the automatic Invoice Total Calc function' added to allow this feature to be controlled

9.5.13 (17-Apr-2014)

Added some header columns to the Download Open Receipts from Sheet sql

9.5.12 (17-Apr-2014)

Fixed bug with attachment statuses being written to the wrong row.

9.5.11 (17-Apr-2014)

Resized Invoice Header form to new max size standards and added in a scrollbar as the form was too big for 768 resolutions.

9.5.10 (16-Apr-2014)

Fixed bug where leading zeros were being removed from account segments.

9.5.09 (16-Apr-2014)

Profile option 'More4Apps: PIW Control Future Dated Invoices' added to provide better control. This replaces the default warning
New profile option values are:
- Warning (or blank) - same behaviour as before
- Ignore
- Reject

9.5.08 (15-Apr-2014)

Added Bill of Lading, Waybill/Airbill, Shipment Number and Packing Slip to the template.

9.5.07 (10-Apr-2014)

Added new option under PO Matching dropdown – Download Open Receipts from Sheet. This uses Receipt Number, Bill of Lading, Waybill/Airbill, Shipment Number and Packing Slip as criteria.

9.5.06 (09-Apr-2014)

Fix for bug in Extras processing where incorrect rows were being validated for upload

9.5.05 (07-Apr-2014)

Changed purchasing category SQL back to how it was (Using the meaning instead of the code)

9.5.04 (07-Apr-2014)

Added Purchasing Category column to the template

9.5.03 (07-Apr-2014)

Added ErrorHandler to Substitutions and ReplaceCase

9.5.02 (04-Apr-2014)

Set frmDFF Startup ErrorHandler entryPoint to vbTrue

9.5.01 (03-Apr-2014)

Added ErrorHandlers to frmDFF, DFFColumnEvents and DFFColumnClickEvents to help diagnose DFF Issue

9.5.00 (01-Apr-2014)

In Validate only mode the extension package is now called, enabling custom validation to occur in this mode

9.4.16 (01-Apr-2014)

Implemented Merchant columns (name, document number, reference, tax reg num, taxpayer

9.4.15 (28-Mar-2014)

Added substitution for customer

9.4.14 (27-Mar-2014)

Provided OverrideTable functionality for ap_terms

9.4.13 (24-Mar-2014)

Further fixes to new Extras functionality

9.4.12 (21-Mar-2014)

Fix for Extras function not correctly establishing 1st Row to load from when using Entire Sheet option

9.4.11 (19-Mar-2014)

Added Profile Option ‘More4Apps: PIW Disable Download’. This prevents the user opening the download form when the profile option is set to Y.

9.4.10 (13-Mar-2014)

Added p_quantity to parameters

9.4.09 (13-Mar-2014)

Changed Remit To Bank Account "Last" variables to variants so they are a consistent type with the "Current" values
Payment_Due_Date, Discount_Due_Date and Payment_Priority are now coloured white on upload to show they are not loaded

9.4.08 (04-Mar-2014)

Improved the performance of Get_Remit_To_Bank_Accounts sql

9.4.07 (28-Feb-2014)

Fixed Error 9999 when closing the Wizard.
Payment_Due_Date, Discount_Due_Date and Payment_Priority are now coloured white on upload to show they are not loaded

9.4.06 (28-Feb-2014)

Check Payment Priority exists before attempting to validate in Validate_Invoice

9.4.05 (24-Feb-2014)

Fix for: Compile Error in Hidden Module

9.4.04 (24-Feb-2014)

We now load the release_num to the interface - for when we cannot validate the release_id)

9.4.03 (20-Feb-2014)

Payment Priority now loads into interface, however it still defaults to 99 when submitted

9.4.02 (20-Feb-2014)

Get_PO_Release - Still want to get the entered release number even though we aren't validating it

9.4.01 (18-Feb-2014)

Added new columns Unique Remittance Identifier and URI Check Digit

9.4.00 (18-Feb-2014)

Significant performance improvement to upload and validation of Project related distributions. Requires package body 3.2.0

9.3.08 (11-Feb-2014)

Changed the function used to find the last used row in RefreshStatus for speed

9.3.07 (03-Feb-2014)

Added Payment Priority (Payment schedule) and Invoice level Descriptive Flexfields to Custom uploads feature

9.3.06 (28-Jan-2014)

Fixed overflow error when downloading PO Information.

9.3.05 (23-Jan-2014)

Changed Site LOV Column widths on the Invoice form to display the Site ID in the second column.

9.3.04 (20-Jan-2014)

In Validate Invoice, set Validate_Invoice to True when we have no Local_OU_ID so that validation for other invoices continues

9.3.03 (14-Jan-2014)

Added Remittance Message 1 to form.
Corrected display column for Pay Group as per Oracle forms.
PO Download now retains header information on the sheet.

9.3.02 (13-Jan-2014)

Merged Tax Code/Account Validation for customer

9.3.01 (09-Jan-2014)

Implemented New Column ‘Track As Asset’

9.3.00 (05-Jan-2014)

Substantial performance improvement in Refresh function

9.2.26 (06-Jan-2014)

Added prompt for PO Download to ask if the user would like to include GL Accounts.
Changed message re upload permission from ‘Quick Invoices’ function to ‘Open Interface Invoices’ function.
‘Invoice ID’ column is now mandatory to run the Refresh function.

9.2.25 (17-Dec-2013)

Changed Legal Entity LOV to be consistent with Oracle.

9.2.24 (13-Dec-2013)

Work on Suppress Upload Validation Messages functionality.
Change icon order in Wizard Ribbon.

9.2.23 (11-Dec-2013)

Added functionality to Suppress Upload Validation messages.
Added new icon 'Validation Messages' to the Ribbon, toolbar and right click menu.

9.2.22 (07-Dec-2013)

Fixed bug stopping the Line IDs and Statuses from being cleared on Refresh

9.2.21 (03-Dec-2013)

Added Substitution for Invoice Line Number

9.2.20 (27-Nov-2013)

Hold Reason will now default when Hold Name is changed in the form.
Hold Reason, Release Status, Release Name, Payment Due Date, Discount Due Date added to template.
Fixed a bug in cmdCalc_Click where the last invoice on the sheet was being ignored (Had to set blankrows = 0 after getting the MaxRow).

9.2.19 (27-Nov-2013)

Added a_add_tax_to_inv_amount to the double click for the Invoice form

9.2.18 (26-Nov-2013)

Fixed issues with locked cells.
Added logic to the Calc button click so that it now only validates the distributions for the invoice.

9.2.17 (25-Nov-2013)

Fixed PIW_CUSTOM error when downloading in 11i.
Removed the check for multiple tax codes for a single line group number.

9.2.16 (06-Nov-2013)

Added check that statistical quantity is on the sheet in Validate_Distribution
Changed ToolBar Icon for "ShowExtras"
Tidied up logic around determining which DFF Context to use so that it is easier to read

9.2.15 (05-Nov-2013)

‘Remove Duplicate Headers’ now displays a progress bar and formats columns which it cannot read from (to avoid an error).
Changed Toolbar icon for ‘ShowExtras'.
Added ‘Remove Duplicate Headers’ button to toolbar.
Fixed an issue related to global DFs at distributions level for India localizations.

9.2.14 (01-Nov-2013)

Added R12 checks for Purchasing Category, Payment Reason Code, Payment Reason Comments, Bank Charge Bearer and for party_site in refresh sql

9.2.13 (31-Oct-2013)

Test for M4APS_PIW_CUSTOM installation was not correct, stopping the download from working properly for Payment Schedule information

9.2.12 (01-Nov-2013)

Implemented new columns: Payment Reason Code, Payment Reason Comments and Bank Charge Bearer

9.2.11 (30-Oct-2013)

Added new ribbon button 'Remove Duplicate Headers'

9.2.10 (25-Oct-2013)

Implemented Purchasing Category column

9.2.09 (22-Oct-2013)

In Validate_Distribution - Ensure statistical quantity column before continuing validation

9.2.08 (21-Oct-2013)

Changed sql to round the amount based on p_precision

9.2.07 (18-Oct-2013)

Implemented Statistical Quantity and Unit of Measure columns at line level for R12.
Added Precision rounding for Dist amount column when downloading from PO Matching form

9.2.06 (18-Oct-2013)

Fix for bug in 9.1.94 fix

9.2.05 (16-Oct-2013)

Download now picks up details from last Payment Schedule record if custom package installed and Payment Due Date or Discount Due Date columns exist

9.2.04 (15-Oct-2013)

Tax Code LOV is now restricted to active dates

9.2.02 (08-Oct-2013)

Batch Name Length was returning incorrect result when batch name = 50 characters

9.2.01 (17-Sep-2013)

Customisations added for customer in the Batch Control form and Invoice level DFF

9.2.00 (02-Aug-2013)

Added Invoice level support for Invoice Holds and Releases. These can only be loaded after the Invoices are imported

9.1.99.3 (05-Nov-2014)

Fix for handling long columns in EBS 12.1

9.1.99.1 (03-Jul-2014)

Fix for Descriptive Flexfield for 12.2

9.1.99 (22-Oct-2013)

In Validate_Distribution – Ensure we have a statistical quantity column before continuing validation

9.1.98 (21-Oct-2013)

Changed piwPODownload – POSQL – to round the dist amount using global p_precision

9.1.97 (18-Oct-2013)

Implemented Statistical Quantity and Unit of Measure columns at line level for R12
Added Precision rounding for Dist amount column when downloading from PO Matching form
Ribbon cosmetic fixes for cases

9.1.96 (18-Oct-2013)

Fix for bug in 9.1.94 fix

9.1.95 (14-Oct-2013)

Validate_Distribution – line 3260 – Changed Null to ‘N’ as interface was returning error for null value
Fix for compile error caused by copying something from the WIP version

9.1.94 (11-Oct-2013)

piwCache – caTaxCodes-line 110 & 180 – Added where clauses to restrict tax codes to active dates

9.1.93 (08-Oct-2013)

Customisation changed – Username dropped from Gateway batch

9.1.92 (08-Oct-2013)

Validate Invoice (Line 1990) Do not prompt if the form is open

9.1.91 (21-Sep-2013)

Customisations added for customer in the Batch Control form and Invoice level DFF (Post Login Events)

9.1.90 (20-Sep-2013)

Fix for Get_Receipt_Line_Number/RVC Transaction ID validation returns several rows when 3 way matching exists. Ensure RECEIVE is the first one

9.1.89 (20-Sep-2013)

Fix for Use fnd_global.user_id rather than “1″ for Last Updated By and Created By columns in default Batch Source
Fix for  l_Prorate. Let Null be loaded by default but set to N if the profile option is set. Separate Tax Lines only

9.1.88 (18-Sep-2013)

Fix  If R12 And IsNull(l_Includes_Tax) And l_Add_Tax_To_Inv_Amount = “Y” Then l_Includes_Tax = “N”

9.1.87 (01-Aug-2013)

Fix to Remit To Bank Accounts caching SQL

9.1.86 (16-Jul-2013)

Updated Core Code to version 205

9.1.85 (04-Jul-2013)

Fix for “doesn’t continue validating”

9.1.84 (04-Jul-2013)

Fix for invalid error “You have used the same Line Group Number (or none) for multiple Tax Lines”.
Change was made in function ValidateTaxTypes

9.1.83 (03-Jul-2013)

Fix for Default payment method to ‘Check’ if supplier site information has been defaulted but payment method is blank, when matching PO Details

9.1.82 (02-Jul-2013)

Fix for Only default supplier site specific information if we can default the supplier site when matching PO Details

9.1.81 (02-Jul-2013)

Flex form now defaults to the segments tab on startup

9.1.80 (01-Jul-2013)

Fix for “balancing_segment, cost_center_segment or account_segment are populated on item lines that are po related in 11i”
Have added in extra validation into Validation_Distribution so that these fields don’t get populated on PO related invoice line

9.1.79 (27-Jun-2013)

DefaultSupplierInfo function now defaults the supplier site

9.1.78 (26-Jun-2013)

Fix for case – Retrieve PO Data. Removed condition and added outer join to query in the DefaultSupplierInfo function>

9.1.77 (20-Jun-2013)

Fix for Download not returning some Document Categories

9.1.76 (20-Jun-2013)

Enhancement – “Give users a choice of which DFF config to use for the Distributions section”.   Added new profile option “More4Apps: PIW Use Distribution Level DFF configuration (R12 only)”. Set profile to ‘Yes’ to use Distribution DFF configuration and set ‘No’ or leave blank to use Line DFF configuration

9.1.75 (20-Jun-2013)

Fix – Query did not have an alias in function RetrieveLegalEntity causing “Character ‘)’ is not allowed in an XML tag name” error

9.1.74 (18-Jun-2013)

Added new column “Add Tax To Inv Amount”.  User can now explicitly set Add Tax To Inv Amount flag on upload

9.1.73 (14-Jun-2013)

Fix – Prorate field now gets defaulted to ‘N’ for tax lines if the user has left the Prorate field blank.
Wizard validation can now handle “OFFSET” Tax lines.
Added in fix for R12 Tax Init SQL, where Legal Entity was getting defaulted incorrectly.   R12 Tax Init SQL generation has been moved to single common function

9.1.72 (12-Jun-2013)

Fix in “Download PO Details” where column indices were getting cached but they shouldn’t have been. The “Download PO Details” functionality has been enabled on the ribbon and toolbar<

9.1.71 (12-Jun-2013)

Made a change to how bMultipleTaxCodes gets set in validate_Invoice, blank tax codes are no longer included in the logic when setting bMultipleTaxCodes = true/false.  Added new validation method ‘DefaultItemsTaxCode’ which will default tax codes when ‘Item’ lines have a blank tax code and there is one ‘Tax’ line with a tax code

9.1.70 (11-Jun-2013)

Fix for “Tax Regime” being validated incorrectly.  Have updated R12 queries in the Wizard as per form trace files

9.1.69 (07-Jun-2013)

Problem with case insensitive searching causing the Wizard to error on searches.   Have removed case insensitive searching from this Wizard, the same as change 204.6 to the core code

9.1.68 (04-Jun-2013)

“Remittance Message 1″ field added to the Wizard at invoice header level. This is a R12 only field

9.1.67 (31-May-2013)

Fix for “Invoice DFF icon does not error nicely when selected and active cell row is < 10″

9.1.66 (29-May-2013)

Fix for 11i Invoice distributions getting downloaded Multiple times. This was being caused by the same problem as 9.1.65 but in the 11i distributions query

9.1.65 (28-May-2013)

Fix for Invoice getting downloaded Multiple times.  Fix has been added into the download query as the join with the per_people_f table was returning multiple records

9.1.64 (27-May-2013)

Fix for “Invoice Distributions form – Purchase Order tab”. Searching for a valid PO number will now enable the PO fields

9.1.63 (27-May-2013)

Fix for “Hold Reason remains after Hold Name is nulled”. If Hold Name on the ‘Submit Batches” form is set blank then the Hold Reason is set to blank and disabled by the Wizard

9.1.62 (23-May-2013)

Fix for “Error Downloading Invoice from R12.0.4 (ap_invoices.PAY_AWT_GROUP_ID doesn’t exist)”. Checks have been added to exclude the column “Payment AWT Group” from wizard operations on version R12.0.4 of Oracle EBS

9.1.61 (21-May-2013)

Added in checks to the ‘Workbook_BeforeClose’ to tell the developer if they have left the debug on or they have forgotten to add in the line numbers

9.1.60 (20-May-2013)

Fix for “Error Downloading 5000 Invoices”.  Due to the 1000 record limit of the ‘In’ statement on the download query, the user can only download less then 1000 invoices at a time.   Message box has been added to the download form to let the users know they can’t download more then 1000 invoices in one go

9.1.59 (16-May-2013)

Fix for case – Duplicate distribution lines being downloaded

9.1.58 (15-May-2013)

Fix for “Expenditure Organization not being downloaded in 11i”.  Updated distribution download query for 11i so that ‘Expenditure  Organization’ now gets written to the correct column in the spreadsheet

9.1.57 (14-May-2013)

Fix for ‘Invalid use of Null’ message when loading Tax distributions based on the ‘Tax Amount’ column

9.1.56 (14-May-2013)

Fix for ‘Invoice Distribution DFF Attributes downloaded into sheet when they don’t exist’

9.1.55 (08-May-2013)

Fix for ‘Invoice Hold Name in Submit Invoice Import is not working as expected’
Control event for combo box HoldLIstbox has been changed from an ‘on change’ to an ‘after update’

9.1.54 (03-May-2013)

Switch Descriptive Flexfield to using Line Level configuration rather than Distribution level configuration for 12.1.3 Fix for not handling non-numeric value in Invoice Total column appropriately

9.1.53 (02-May-2013)

Fix for ‘Invalid use of null’ message when validating distributions that include a Tax Amount value

9.1.52 (02-May-2013)

If the user has entered includes tax = No in the spreadsheet then l_Includes_Tax now gets set to ‘N’ instead of ‘Null’ in Validate_Distribution

9.1.51 (18-Apr-2013)

Added better error handling in around the showing of the header form and double clicking on the spreadsheet

9.1.50 (15-Apr-2013)

Fix for Clear button not working on ‘Charge Account’ form

9.1.49 (15-Apr-2013)

Fixed incorrect spelling in ribbon tooltip

9.1.48 (05-Apr-2013)

Added in new validation to stop the user from adding in time values for DFF attributes of type ‘Standard Date’

9.1.47 (04-Apr-2013)

Added in new validation so that users can enter both tax inclusive and exclusive lines on an invoice as long as they have not entered any Line Group Numbers for the invoice lines

9.1.46 (03-Apr-2013)

Changed the order in which substitutions get tested in function ‘substitutions’, as they were getting substituted incorrectly

9.1.45 (03-Apr-2013)

Added profile option ‘More4Apps: PIW Limit Tax Classifications LOV by OU’

9.1.44 (27-Mar-2013)

Re-wrote Invoice Import Concurrent program submit to handle non-ascii characters

9.1.43 (20-Mar-2013)

Fix for customer – Bug in downloading query when searching without an invoice number

9.1.42 (15-Mar-2013)

Fix for customer – R11i the generated GDF Context was incorrect.  It need to end with “INVOICE_INFO”.  Changed this for R11i only

9.1.41 (11-Mar-2013)

Fix for customer – “Incorrect Account causes a server error”.  Added in SQL code to Function Get_CCID in module genFlex so that the query can handle invalid account numbers

9.1.40 (05-Mar-2013)

Fix for failure to load the last block of Distributions on an invoice when the following Invoice fails validation ‘Minor changes to handle deletion of the mandatory Amount’ column

9.1.39 (04-Mar-2013)

Fixed bug where ‘Download PO Details’ toolbar buttons were not working correctly

9.1.38 (22-Feb-2013)

Fixed up colouring of cells, the ‘Remit to Bank Account’ change event on the invoice header form was setting the incorrect column valid on the spreadsheet

9.1.37 (21-Feb-2013)

Fix to ‘Remit to Bank Account’ column on form.  Was not able to handle scenario where the column was deleted

9.1.36 (19-Feb-2013)

Rewrote GET_CCID call.  Original call was on occasion returning the wrong CCID in R12

9.1.35 (14-Feb-2013)

Added in checks to PIWPO Download so that the code doesn’t reference columns that have been deleted off the spreadsheet

9.1.34 (11-Feb-2013)

Added filter to the tax code SQL so that tax codes of type AWT (Withholding) don’t get displayed anymore

9.1.33 (05-Feb-2013)

Added checks into Startup on PIW Batches form and Delete_Invoices function to see if the current user is registered.  If they are not then an error message is displayed and the process is stopped.  Fixed up issue for customer where their unregistered users were unable to validate invoices

9.1.32 (04-Feb-2013)

Fix for customer, Added Profile Option “More4Apps: PIW Default Batch Source”.  Use this Profile option to set the Batch source for this wizard, If this Profile setting is populated then the wizard will default the Batch source to the value of the Profile setting, If the Profile Option is blank then the User can select a Batch source from the valid Batch Sources on the PIW Source form

9.1.31 (04-Feb-2013)

Fix for customer, download PO Details button’s were not being hidden in the toolbar

9.1.30 (30-Jan-2013)

Updated core ‘Request’ code where customer were not able to open concurrent Program log/output file at Wizard level

9.1.29 (29-Jan-2013)

Modified the query in function Get_AWT_Groups so that the withholding tax groups now get filtered based on which operation unit is currently being used

9.1.28 (26-Jan-2013)

Fix for failure in validating Tax Rate column in R12 (Validate_Numeric function was trying to set it to null and it was defined as a string)

9.1.27 (24-Jan-2013)

Removed changes put in place for version 9.1.24 above. Fix for case is now done all in the wizard code and not the package.  Added check into method Upload_Invoices to see if the current user is registered, if they are not then error message is displayed and Uploading is not run

9.1.26 (23-Jan-2013)

Changed column “Remit To Bank Account” to display the remit-to bank account number and not name as per customer’s needs

9.1.25 (22-Jan-2013)

Changed the Concurrent Request code to reduce the too-many-rows error coming out of the log and output buttons for customer

9.1.24 (22-Jan-2013)

Added in fix for case, Updated package to check licence validate before loading header information into the interface table.  Added in new section of code to ‘Parse_Return_String function to handle the new return value from the package when an unnamed user has tried to upload an invoice (“N” – Unnamed User error on upload)

9.1.23 (21-Jan-2013)

Added in changes “Retrieve PO Data”.  Added in the ability to download details for just the selected PO’s on the sheet.
Moved “Download PO Details” button to be part of the “PO Matching” button

9.1.22 (09-Jan-2013)

Added in new column “Remit to Bank Account” and associated validation, control on the invoice form and code to retrieve the LOV’s

9.1.21 (21-Dec-2012)

Fix for Date and Number values keeping values from prior row when current value invalid

9.1.20 (20-Dec-2012)

Turned tracing off in Load_File_R12 procedure.  Changed call to m4aServlet/uploadfile
Newest ribbon code (version 100)

9.1.19 (30-Nov-2012)

Fix for bug in Distributions form on R12 when ‘Includes Tax’ column removed

9.1.18 (29-Nov-2012)

Pay Group added to downloader

9.1.17 (23-Nov-2012)

Variable ‘o_Dist_Amount’ was getting set incorrectly in function ‘Validate_Distribution’, now getting set to unrounded spreadsheet value for case

9.1.16 (19-Nov-2012)

Fixed up logic in ‘Get_TaxCode’ method for “Date tracking not working on Tax Code selection” issue in case

9.1.15 (14-Nov-2012)

Added Income Tax type to 11i download

9.1.14 (14-Nov-2012)

Fix for bug in validation when Supplier Site column is removed

9.1.13 (14-Nov-2012)

Added clause to header download sSQL=sSQL & “and i.invoice_type_lookup_code<>’EXPENSE REPORT’”

9.1.12 (08-Nov-2012)

Added in Download SQL for R12 and 11i to retrieve the “Award Number” for Project Distributions as this was not getting downloaded.  ‘Fix to bug introduced in 9.1.10 causing wrong Operating Unit to be used for queries in certain circumstances

9.1.11 (07-Nov-2012)

Added support for form field:D_SUM_folder.task

9.1.10 (25-Oct-2012)

Change to Multicall to split from common modules call.  (This is dependant on partially upgraded common modules)

9.1.09 (24-Oct-2012)

Added in filtering to the receipt queries in the PO matching screen the receipt queries should now be respecting the ‘More4Apps:PIW No Closed P.O.s’ and ‘More4Apps:PIW No Closed for Invoice P.O.s’ profile options

9.1.08 (23-Oct-2012)

Updated Core code to Version 202

9.1.07 (17-Oct-2012)

Made download status columns dependent on whether they are selected for use

9.1.06 (16-Oct-2012)

Download Status filters added

9.1.05 (26-Sep-2012)

Added profile option ‘More4Apps:PIW No Closed for Invoice P.O.s’ to provide further control over P.O. matching

9.1.04 (19-Sep-2012)

PO Matching form changes:  Changed Category Queries to look for the default Purchasing structure.  Previously the structure was hard coded to ‘PO_ITEM_CATEGORY which is ok in most cases as it is the structure that is used mostly for this.  But, it can be changed.
Changed item queries to be filtered by Inventory Org rather than Operating Unit.
Added Error handling to all procedures
Fixed Type Mismatch bug in SumSelected and cmdDownload_Click.  Doing numeric checks on row.item(“Quantity_Invoiced”) and row.item (“Unit_Price”) ‘before multiplying them.  PO Matching
form Changes: Added in dynamic column sizing for “item description” on the PO Matching UI.Added
in Receipt Date From/To fields to the PO Matching screen

9.1.02 (06-Sep-2012)

Fix for Expenditure Orgs not populating LOV on Distributions form due to recent R12 multi-org changes
Fix for client specific customisation also broken due to the recent R12 multi-org changes

9.1.01 (04-Sep-2012)

Includes Tax flag was not being populated for Freight or other non-Tax, non-Item lines

9.1.00 (21-Aug-2012)

Ribbon menu enabled

9.0.27 (23-Aug-2012)

Refresh and Attachments load were not coping with multiple Operating Unit Invoices on the layout
Default Prorate Flag to Yes when automatically assigning Line Group Numbers to Tax distributions

9.0.26 (20-Aug-2012)

Automatically populate the Line Group Number and Prorate Flag columns when ‘Tax Amount’ column used
Added validation to enforce R12 constraints in Tax Lines
Automation added to provide new line Group Numbers for Tax and associated Item distributions for each new Tax Code

9.0.25 (17-Aug-2012)

Added Search filters on Pay group and User (but not yet by Invoice Status)

9.0.24 (10-Aug-2012)

Fix for Security SQL in DFF and KFF forms needing to handle blank start or end values in low/high constraints

9.0.23 (17-Jul-2012)

Fix for SQL error in R11i Distributions download
Added validation to enforce the Prorate Flag for Tax lines with a Line Group Number
Added validation to prevent the Includes Tax flag from being set to Yes when the invoice contains Tax distributions
Added a check to make sure an End Date or Num of Periods is used when using Deferred Tax
Form searches for Suppliers, Sites, Projects are now case insensitive provided the database is 10g or greater
Since you cannot duplicate Supplier and Site names in different case, upload validation for these is also now case insensitive

9.0.22 (12-Jul-2012)

For R12 when using the ‘Tax Amount’ column, default the Line Group Number if not done by the user and set the Prorate Flag to Yes for the Tax distribution

9.0.21 (11-Jul-2012)

Added the ability to Refresh / Load Attachments based on Voucher Number if the Invoice Number is absent

9.0.20 (05-Jul-2012)

Fix for error loading Tax Lines in R12
Fixed bug in 9.0.19.  If you deleted the ‘Deferred Acctg Num of Periods’ column you received an Application error when uploading

9.0.19 (02-Jul-2012)

Removed column ‘Deferred Acctg Flag’. This now depends on the existence of an ‘Deferred Acctg Start Date’ value
Added further validation for the Deferred Acctg columns
Published Prepayment columns ‘PP Apply Amount’, ‘PP Inv Num’, ‘PP Line Num’, ‘PP Dist Num’, ‘PP GL Date’, ‘Invoice Includes PP’
Basic validation is included for these columns. More to come including forms support

9.0.18 (26-Jun-2012)

Added columns ‘Deferred Acctg Flag’, ‘Deferred Acctg Start Date’, ‘Deferred Acctg End Date’, ‘Deferred Acctg Period Type’, ‘Deferred Acctg Num of Periods’

9.0.17 (19-Jun-2012)

Fix for SQL error when searching for P.O. Lines in the P.O. Match form

9.0.16 (12-Jun-2012)

Fixes for dependent attribute DFF table based validation bugs:
1) Upload, download and form: Attributes with no value sets would cause incorrect SQL causing XML parse errors.
2) Form Only: Child attributes being disabled incorrectly in certain circumstances

9.0.15 (07-Jun-2012)

Fix for DFF language problem in datesizard Version

9.0.14 (06-Jun-2012)

DFF fix for LOVs not displaying any values.  Affected attributes were dependent on date based parent attributes.
DFF fix for downloading date based attributes not being converted properly depending on the value set causing differences in formatting when downloaded

9.0.13 (01-Jun-2012)

Fix for error on loading Invoice Header form in R11i

9.0.12 (24-May-2012)

Change to Global DFF Flexfield from 12.1 to use the Interface tables, not the Invoice tables

9.0.11 (22-May-2012)

Fix for Fiscal Class LOV

9.0.10 (22-May-2012)

Added Site/Responsibility/User level profile option ‘More4Apps: PIW Disable Batch Import’
Fix to download not populating certain columns
Performance fixes to R12 Distributions download. Performance improved if the following optional columns are removed:- Primary Intended Use
- Product Fiscal Class
- Business Category
- Fiscal Class
- Product Category

9.0.09 (11-May-2012)

Changed install of AP Source to loop through all installed and enabled languages

9.0.08 (08-May-2012)

Added custom control account validation for a customer

9.0.07 (01-May-2012)

Fixed for R12 distributions download accessing wrong view
Additional handlers added for login problems caused by AP setup issues

9.0.06 (27-Apr-2012)

Added Invoice Type and Document Category to download
Fixed bug in Invoice header form causing Suppliers and Sites to be mixed up
Fixed duplication of some distributions in download in R12

9.0.05 (18-Apr-2012)

Fixes to policy controlled Tax LOVs
Now works in Excel 64 bit version
Fix for Tax lines being download when
Include Tax Lines option on Download form unchecked

9.0.04 (03-Apr-2012)

Added Customer Taxpayer column

9.0.03 (02-Apr-2012)

Fix for Subscript out of Range messages in Distributions form after change of Operating Unit

9.0.02 (03-Mar-2012)

Clear the profile option cache when changing responsibility
Multi-Org: Tax Rate Name, Regime Tax Codes, Tax Status Codes

9.0.01 (22-Feb-2012)

Multi-orged: location, legal entity, Tax codes

9.0.00 (22-Feb-2012)

Major changes for new ‘Operating Unit’ column

8.2.35 (22-Feb-2012)

Instance shown on status bar and forms. Fix color bug in URL setup and Help forms

8.2.34 (17-Feb-2012)

Added Doc Sequence Value to Voucher Number download

8.2.33 (15-Feb-2012)

Added Header Level Liability Account to download

8.2.32 (05-Jan-2012)

Fix for Tax Code validation on upload not rejecting invalid Tax Codes
Fix for Distributions form not erroring Tax Code when case not correct

8.2.31 (06-Dec-2011)

Fix for end-dated Tax Code causing rejection even if there are other versions of the Tax Code valid for the Invoice date
Fix for D_SUM_FOLDER.VAT_CODE support added in 8.2.23 not having surrounding single quotes

8.2.30 (28-Nov-2011)

GetMainMultiCall fixed bug where r12 DFF caching would cause the oops message 4 times
Added override table for Supplier Sites

8.2.29 (22-Nov-2011)

Payment Terms LOV and validation was not rejecting end-dated values

8.2.28 (16-Nov-2011)

Fix for matching form error. Form would error if wizard was not already logged in

8.2.27 (16-Nov-2011)

Fix for form error when closing ‘Edit Match Quantity’ form

8.2.26 (11-Nov-2011)

Income Tax Region column added to template and sheet1. Code was done in 8.2.18 but column wasn’t added to sheets

8.2.25 (06-Nov-2011)

Default DFF configuration to read from Distributions for 12.1.3 rather than Lines which has been the default for R12

8.2.24 (04-Nov-2011)

Add support for Award Number column to Form and Upload. Download not done yet

8.2.23 (02-Nov-2011)

Add support for D_SUM_FOLDER.VAT_CODE form field in Distributions DFF
Fix ‘Invalid use of null’ message in new R12 column ‘Tax Control Amount’ if left blank
Load Terms Name as well as ID to avoid AP not processing the ID value

8.2.22 (26-Oct-2011)

Stop from rejecting blank DFF segment if it is dependent on a parent segment and the parent segment has no value
This removes the need for the 8.2.18 mod for a client

8.2.21 (19-Oct-2011)

Tax Code now downloading into text column to stop leading zeros being stripped

8.2.20 (17-Oct-2011)

Trim Tax code column to remove leading spaces
Skip Invoice Header DFF validation for client

8.2.19 (14-Oct-2011)

Added Customization for client. Pay details defaulting from site in header form

8.2.18 (12-Oct-2011)

Fixed bug in Header form that caused Tax Control Amount to continuously pop messages
Skip mandatory DFF segment validation for client

8.2.17 (11-Oct-2011)

Added columns – Tax Control Amount and Tax Region
Added Accounting Date to distributions form

8.2.16 (03-Oct-2011)

Columns Added – Legal Entity, Primary Intended Use, Ship To, Product Fiscal Class, Fiscal Class, Business Category, Product Type, Product Category
Modification for client- Stopped site Id being set to 0 when site is invalid

8.2.15 (27-Sep-2011)

Added customization for client stop Batch Source form loading except for a certain responsibility
Changed toolbar icon for attachments
Fix for failure to change Org properly in R12 from ‘About’ form
Fix for Accounting KFF string not removing leading and trailing spaces before upload

8.2.14 (20-Sep-2011)

Change to customization for (customer)

8.2.13 (09-Sep-2011)

Added support for DFF forms personalisation for (customer)
Re-enabled test to make sure there is a Tax Code for TAX lines but only if there is no system default

8.2.12 (01-Sep-2011)

Stopped the following columns from being populated in the interface table for R12 – balancing_segment, cost_center_segment, account_segment
Providing these values causes the Payables form in Inquiry Mode to error when the lines tab is click on with the following message:This is a read only flexfield. You cannot change any values in the flexfield’

8.2.11 (26-Aug-2011)

Fix for Tax Code Error: ‘Tax Code ‘*Tax Name*’ is not valid for the invoice date

8.2.10 (24-Aug-2011)

Fix for problem when closing combinations form caused by new Splash form

8.2.09 (25-Jul-2011)

Fixed bug in rounding during Tax calculations

8.2.08 (12-Jul-2011)

Added support for :D_SUM_FOLDER.DIST_CODE_COMBINATION_ID in DFF attributes default SQL

8.2.07 (11-Jul-2011)

RCV Transaction ID was being incorrectly loaded into the Receipt Line Number column for older package body versions

8.2.06 (07-Jul-2011)

Added support for :INV_SUM_FOLDER.INVOICE_TYPE in DFF attributes default SQL

8.2.05 (04-Jul-2011)

Fix for Cancel button not working for Duplicate Invoice error messages
Widened invoice number columns in download form’s list boxes
Changed space between downloaded invoices from 2 rows to 1 row.
Added status bar message to download form when search button is clicked.
Changed download messages – removed the word download. eg Message was Downloading: Downloading Headers, now Downloading: Headers

8.2.04 (01-Jul-2011)

Bugs fix for 11i distributions download: Quantity Invoiced was downloading PO Quantity Invoiced,
Unit Price was downloading PO Unit Price

8.2.03 (28-Jun-2011)

Fixed bug in Matching Form Screen where Splash Screen would get stuck in a loop.
Added Receipt Line to Matching Form

8.2.02 (27-Jun-2011)

Changed Receipt Line validation to load RCV Transaction ID rather than Receipt Line Number

8.2.01 (16-Jun-2011)

Multiple-select enabled for selecting Invoices to upload
Multiple-select and range select enabled for Delete Invoice function
Added “Loading Form” popup form to prevent users operating or closing forms before they are ready
Fix for invalid Start and End dates appearing in Tasks LOV on Distributions form
Remove ‘No AP Invoice Batches were found’ message from Batch submit form

8.2.00 (14-Jun-2011)

Allow to operate on older versions of the database package prior to the SGA performance enhancements in 8.0.00 (package version 3.0.0)

8.1.15 (14-Jun-2011)

Added a check box so users can choose not to download the Tax lines. Not downloading tax lines is the default.
Added columns to the download: Currency Code, Pay Currency Code, Pay Cross Rate, Pay Cross Date and organization
New Tax clause for R12 in download

8.1.14 (13-Jun-2011)

P.O. Download feature added

8.1.13 (11-Jun-2011)

Fix for error when using Date criteria in download form

8.1.12 (09-Jun-2011)

Added test to make sure there is at least one Distribution
Fix for not validating Distributions in Validate-only mode when Profile option set to ignore Total variance

8.1.11 (02-Jun-2011)

Invoices containing Charge Controls errors in Project related Distributions are no longer partially loaded

8.1.10 (20-May-2011)

Attachments loader now able to upload files directly from HTTP(s) sources

8.1.09 (12-May-2011)

Fix for upload/validation error when ‘Validation Status’ column is removed
Fix for object error when clicking the Diagnose button in the URL config form

8.1.08 (06-May-2011)

Update for non-ascii character problem

8.1.07 (25-Apr-2011)

Bug fix for Supplier Site validation failing when Supplier Site ID > 32767
Added bind variable method to Supplier Site validation to reduce hits on the SGA
Site LOV on Invoice header form was not allowing Site to be selected when there are more than 5000 Sites
Added substitution for :D_SUM_FOLDER.AMOUNT in DFF segment defaults or value sets
Fix to avoid a cell formatting error in Excel 2007
Fix for bug in Tax Code validation when more than 1000 Tax codes exist

8.1.06 (21-Apr-2011)

Added DFF substitution for :D_SUM_FOLDER.PO_DISTRIBUTION_ID form field

8.1.05 (15-Apr-2011)

Copy/Paste function was disabled on PC while validation or upload is running
Added validation for GL Date and Accounting Dates to ensure they are in Open or Future GL Periods
Batches are checked when submitting the import to detect and warn of any potential Accounting date errors

8.1.04 (07-Apr-2011)

Further performance improvement to post login processes

8.1.03 (31-Mar-2011)

Includes Tax Flag was being cleared when opening the Distributions form

8.1.02 (24-Mar-2011)

‘Increased size of default VAT code variable to prevent ‘PL/SQL: numeric or value error: character string buffer too small’ message
GL Date was loading into the Invoice and Batch control forms using the US format even if the PC uses Euro date format

8.1.01 (21-Mar-2011)

Fix for incorrect colour coding on deleting an invoice

8.1.00 (16-Mar-2011)

Significant performance improvements to login process
Fix for file based Attachments not working on Windows 7
Fix for Copy/Paste feature on machine being temporarily disabled while uploading
Profile Option ‘More4Apps: PIW Skip P.O. validation’ added to allow P.O. related distributions to be loaded unvalidated
Added Setup option to disable Global DFFs.  This option is turned on by default.  Saves time logging in

8.0.08 (18-Feb-2011)

Tax rounding changed to Line level rather than on the Total – to match Oracle form
Bug fix for profile option ‘More4Apps: PIW Override Function Security’ not allowing override of submit batch import functionality

8.0.07 (10-Feb-2011)

Changes to support new 3.1.0 package. This is to fix the trial constraint not resetting on login in R12.
Load Counter profile option now redundant
Minor fix to About form to prevent double-logging out and message when non-named user using form

8.0.06 (03-Feb-2011)

Fixes added for non-ascii character handling

8.0.05 (29-Dec-2010)

Fix for error after login when focus switched to another application
Fix added for occasional lost feedback affecting any database call

8.0.04 (17-Dec-2010)

R12 Distributions download now downloads Line Line Type rather than the distributions Line Type
PO Matching Form fix to Quantity Billed and Quantity received values for Receipts. It was displaying Amount Billed and RCV_TRANSACTION_AMOUNT rather than Quantities
Load Tax Code as well as ID for R11i to workaround one site that seems to require the code
Separate Tax Lines were NOT being loaded properly

8.0.03 (11-Nov-2010)

Removed 32kb limit on Duplicate Invoice check when in Validate only mode
Fix bug where PO Matching form was wiping out Calc (or any non numeric value) in the Invoice Total column

8.0.02 (02-Nov-2010)

Fix for Supplier Site loaded when using P.O. related Distributions coming from P.O. and not spreadsheet

8.0.01 (27-Oct-2010)

New profile option to allow selected responsibilities/users to upload/submit import despite the responsibility having no Quick Invoice function on the menu
Profile option name is ‘More4Apps: PIW Override Function Security’

8.0.00 (13-Oct-2010)

Rewrite of upload to reduce load on the SGA. This consequently improves performance
This version MUST be accompanied by an upgrade to the AP Invoice Wizard database package
Some improvements to error message handling

7.1.50 (22-Sep-2010)

Added substitutions for :D_SUM_FOLDER.TASK_ID,:D_SUM_FOLDER.PROJECT_ID, :D_SUM_FOLDER.EXPENDITURE_ITEM_DATE
Fix for Distributions form field substitutions not working when loading Distributions DFF form

7.1.49 (16-Sep-2010)

Fix for current cell value being written to far right column when worksheet protection enabled
Multi-Org fix for R12 required for Supplier Site validation

7.1.48 (15-Sep-2010)

Fixed 11.5.10 download bug introduced in 7.1.47

7.1.47 (14-Sep-2010)

Added document sub type column and substitution – display name Invoice Sub-Type, only for R12

7.1.46 (03-Sep-2010)

Fixed DFF bug causing double-up of single quotes around substituted form fields

7.1.45 (02-Sep-2010)

Further mods to Hierarchical security

7.1.44 (02-Sep-2010)

Further mods to Hierarchical security

7.1.43 (31-Aug-2010)

Added Hierarchical Security to key flex form

7.1.42 (25-Aug-2010)

Added form field substitution for :INV_SUM_FOLDER.QUICK_PO_NUMBER
Use quotes around all Form field substitutions except mandatory numeric values

7.1.41 (17-Aug-2010)

Customisation added for (customer) to default the Expenditure Organization to the Task owning organization
Changes to search functionality on Distributions form to speed up data entry. New search button pops up for Exp Types and Orgs if % used
Can now select any Worksheet password. Use Password form on the ‘PIW Setup’ toolbar to store this password

7.1.40 (03-Aug-2010)

Further work on DFF dates. Now includes download conversion

7.1.39 (29-Jul-2010)

Bug fix for DFF Date validation implemented in 7.1.38

7.1.38 (28-Jul-2010)

Changes to DFF Date validation and upload values
Download change to r12 Distributions Line Type

7.1.37 (27-Jul-2010)

Fixed bug where Invoice Hold Name and Hold reason were not being added to the concurrent request
Added customization for (customer) to stop users being able to submit requests
Added download spreadsheet language fix for Dates and Numbers

7.1.36 (21-Jul-2010)

Fixed download of ‘Accounting Date’ and ‘Item Date’

7.1.35 (20-Jul-2010)

VBA in Excel 2007 can work through Worksheet Protection so any password can be used

7.1.34 (19-Jul-2010)

Allow VBA to operate through spreadsheet protection for Excel 2002 (Excel XP)

7.1.33 (29-Jun-2010)

Customisations added for (Customer) to prevent single invoice upload – and DISABLED again as TJX changed their mind
Minimum version profile option restriction was not preventing login
New button added to About form to change Responsibility
DFF change for R12. DFF segment name is now used to reference parent segments instead of value set name

7.1.32 (25-Jun-2010)

Tax Calculation Flag was not correctly set if Suppress Total Check profile option was switched on
Value Set security does not appear to be implemented in R12 ! Turned off R11i type conditions for R12

7.1.31 (17-Jun-2010)

Tax Rate Name was not validating properly if there was no Tax Juridiction
Set ‘Calculate Tax During Import’ to No rather than leave blank to override default behavior
Add condition to exclude end-dated Payment Methods

7.1.30 (16-Jun-2010)

Added several more form substitutions, :inv_sum_folder.doc_category_code, :inv_sum_folder.wfapproval_status, :inv_sum_folder.invoice_id

7.1.29 (15-Jun-2010)

Added support for form field ‘INV_SUM_FOLDER.Org_ID’ in DFF segment validation

7.1.28 (11-Jun-2010)

Added column ‘Calculate Tax During Import’ for R12. This is already defaulted to Yes when there are no separate Tax lines. This column allows the user to override this default behavior

7.1.27 (07-Jun-2010)

Fix for incorrect rejection in R11i when Includes Tax Flag used
Fix for Concurrent Requests form

7.1.26 (02-Jun-2010)

Custom Mandatory Fields feature added. On the PIW Setup toolbar you can now set some optional fields to be mandatory
Missing mandatory values cause upload to be rejected
In some circumstances the status columns were not coloured correctly

7.1.25 (27-May-2010)

Calculate Tax flag in R12 was being set to Yes if separate Tax lines were loaded. Should be set to No
Added column ‘Include in Taxable Line’ for R12 Tax
Fix to Distributions form. The wrong tabs were being hidden since a new tab was added in 7.1.16
Fix for overflow error when more then 32000 LOV items

7.1.24 (18-May-2010)

Change to LOV SQL for Distribution Line Type as the one added in 7.1.22 was not working except in English

7.1.23 (14-May-2010)

Fixed ‘Invalid use of null’ error arising in 7.1.22
Minor fix to Line Type LOV for 7.1.22
Fixed overflow error when quantity invoiced is zero

7.1.22 (12-May-2010)

Added profile option ‘More4Apps: PIW Reject Zero value Invoices’
Enabled multi-language for Line Type LOV
Added condition to Payment Methods for R12 to remove disabled items
Stop Header level P.O. Number from being loaded into non-ITEM Distributions
Fix for non-ascii characters in Description field of File type Attachments not being uploaded correctly

7.1.21 (11-May-2010)

Get column headers procedure was being called twice when double-clicking to load forms
Worksheet Protection may now be passworded but only with a specific password (Ask us)
Added two more rows for Overrides
Added override for zx_input_classifications_v for R12 Tax

7.1.20 (06-May-2010)

Terms ID was not resetting to empty between invoices
Change to Payment Method LOV for R12 to include PAYER_ORG as well as PAYEE Type Codes

7.1.19 (04-May-2010)

Added profile option “More4Apps: PIW Disable GL Date on Batch Import” to prevent users using the GL Date parameter on batch import

7.1.18 (03-May-2010)

Added profile option “More4Apps: PIW No Closed P.O.s” to allow control over users matching to CLOSED P.O.s and Releases
Stop Cancelled Receipts from passing validation
Added two more parameters to Suncorp’ custom Import Concurrent Request

7.1.17 (29-Apr-2010)

Fix required if new PAY AWT columns deleted

7.1.16 (22-Apr-2010)

Changed ‘Payment Method’ in header download for R12
Changed ‘AWT Group’ column name to ‘Invoice AWT Group’
Changed ‘Dist AWT Group’ column name to ‘Dist Inv AWT Group’
Added columns ‘Payment AWT Group’ and ‘Dist Pay AWT Group’
Changed ‘Tax Country’ to pop Invoice Header rather than Distributions form
Added profile option “More4Apps: PIW My Batches Only” to allow control over users accessing batches they didn’t load

7.1.15 (15-Apr-2010)

Added new payment Method LOV for R12. Changed interface table column for Payment Method for R12
Fix for failure to validate default Tax Type on first upload attempt

7.1.14 (09-Apr-2010)

Added back Set of Books constraint on Asset Book LOV for R12

7.1.13 (19-Mar-2010)

Default to Invoice Base Currency if Invoice Currency not available at System Parameter level
Fix in Header form. If you chose the first currency it wasn’t being picked up by the check to see if a currency can be determined

7.1.12 (17-Mar-2010)

Customised Concurrent Request submission for (customer)
Significant performance improvement in Concurrent Requests viewer

7.1.11 (10-Mar-2010)

Removed Set of Books constraint on Asset Book LOV

7.1.10 (04-Mar-2010)

Added ‘Invoice Type’ column as R12 supports ‘Prepayment and ‘Debit Memo’ Invoice Types

7.1.09 (23-Feb-2010)

Fix for VB error when there are no distributions on the invoice
Fix for VB error when deleting an invoice and the Tax Line ID column is missing

7.1.08 (19-Feb-2010)

Workaround added for LOV problem when changing Orgs in R12
New columns in 7.1.07 were causing flexfield problems

7.1.07 (15-Feb-2010)

Added Asset Book Type and Asset Category columns
Handle no Name value for records in Tax Rate Name LOV

7.1.06 (12-Feb-2010)

Some of the R12 Tax LOVs were not containing values

7.1.05 (10-Feb-2010)

Removed unused Invoice Holds module. Holds are optionally loaded when the batch is imported
Changed ‘Invoice Amount’ messages to ‘Invoice Total’ to reflect the correct column title

7.1.04 (04-Feb-2010)

Fix for incorrect Set of Books ID value in R12 when non-default Org used
Always set the context for R12 as Servlet was not doing this
Attachments upload was not working since no-port number enhancement in 7.1.00

7.1.03 (02-Feb-2010)

Load dist_code_concatenated column for ITEM distributions
Load segments values into balancing_segment, cost_center_segment, account_segment columns also for ITEM distributions
Add Tax Country LOV to Invoice Header form for R12
R12 Tax columns LOVs use default Country from Supplier Site

7.1.02 (28-Jan-2010)

Make Invoice Number mandatory
Completed R12 Tax columns ‘Tax Status’, ‘Tax Rate Name’, and ‘Tax Rate’
Added substitutions for :INV_SUM_FOLDER.PAY_GROUP_LOOKUP_CODE and :INV_SUM_FOLDER.EXCLUSIVE_PAYMENT_FLAG

7.1.01 (18-Jan-2010)

Allow distributions with both P.O. and Accounting segments

7.1.00 (29-Dec-2009)

Support non-ascii characters in R12
Pass ‘N/A’ value to batch name in R12 when batching not enabled to be consistent with Oracle form

7.0.01 (22-Dec-2009)

Fix to ORG_ID value in R12

7.0.00 (15-Dec-2009)

Workarounds added to compensate for significant Excel 2007 performance problems
Changed Refresh – one call for all Distributions on an invoice rather than one call for each line – huge performance improvement

6.3.52 (10-Dec-2009)

Fix for program stopping upload mid invoice when duplicate invoice encountered
Removal of Supplier Site column caused application error
Duplicate Invoices were not adding to rejected invoices counter
Further work on Global DFF. Now running off ‘Transaction Global DFFS’ and converting the context to the ‘Interface Global Dff’ value on upload

6.3.51 (09-Dec-2009)

Fixed Global DFF download. No values were being downloaded. And IDs we not converting to values
Changed the way country was being set for using the Global DFF – as no data was being returned for Chile.
JG: Territory profile value was better than using the territory of the Org
Further work on Global DFF download. Swapped usage of ‘Interface Global DFFs’ to using ‘Transaction Global DFFs’
Added substitutions for invoice type ‘CREDIT’
Cached table based values were causing invalid values to be validated when a non profile based substitution
was in the query

6.3.50 (30-Nov-2009)

Distribution number sequence altered to reflect load order, starting from 1. Required for R12 as this is visible in the Oracle form

6.3.49 (25-Nov-2009)

Submit button was not activating in batch control form
Invalid defaulting Income Task Type was not being checked by tool or loaded into Distributions form

6.3.48 (24-Nov-2009)

Fixed fault in Get_Aliases procedure

6.3.47 (17-Nov-2009)

Stop clearing trailing space from DFF value before validation as this may be valid in table validated value sets
Widen DFF form

6.3.46 (16-Nov-2009)

Key Flexfield module enhancement to handle segments containing the delimiter character
Licence model altered to prevent use of the tool for non-named users except for About form functions

6.3.45 (29-Oct-2009)

Added new ‘View Concurrent Requests’ form

6.3.44 (22-Oct-2009)

Added substitution for :INV_SUM_FOLDER.VENDOR_NUMBER

6.3.43 (13-Oct-2009)

Removed invalid entries from LOV for Document Categories

6.3.42 (25-Sep-2009)

Fix for ROWNUM limited queries returning wrong record set from multi-org queries

6.3.41 (23-Sep-2009)

Added M4APS_PIW_CUSTOM package allowing sites to devise their own validation rules and post-insert activities
Minor fix for error message containing trailing colon character

6.3.40 (16-Sep-2009)

Added two substitutions into the downloader

6.3.39 (07-Sep-2009)

Added repaint to Flexform activate. Form was not repainting properly at one site

6.3.38 (02-Sep-2009)

Message for invalid Requestor was not being recorded in the Invoice Error column

6.3.37 (19-Aug-2009)

Fixed download DFF bug introduced in 6.3.34
Error condition added if Supplier Name does not match Supplier Number

6.3.36 (18-Aug-2009)

DFF error in a Distribution was not stopping upload of the Distribution

6.3.35 (14-Aug-2009)

Fix for bug in 6.3.34
DFF module was not replacing Meaning with ID value for ID based value sets when cached
Correction to Responsibility Application ID for Security Rules

6.3.34 (13-Aug-2009)

Validation was not populating unused Supplier Name or Supplier Number column. Changed to be consistent with user form
Duplicate Invoice check was presenting an error as it was trying to run even if the Supplier failed validation

6.3.33 (03-Aug-2009)

Added Custom Account validation for (Customer)

6.3.32 (14-Jul-2009)

Added case insensitivity to (Customer) Customisation Financial Delegation code

6.3.31 (08-Jul-2009)

Added control allowing administrators to set the minimum allowable version number. Uses profile option “More4Apps: PIW Minimum version”

6.3.30 (01-Jul-2009)

Removed this customisation -6.3.23 01/05/09 Additional custom validation for (customer) for ‘Goods Received Date’
Replaced with custom validation on ‘Invoice Received Date’
Added (customer) customisation to take the 3 Letter financial delegation code and update it to include the employee number
Added DFF context filtering on Start_Date_Active and End_Date_Active for the contexts because non active (but enabled) contexts were selectable in the wizard but not in Oracle forms
Fixed download DFF bug. No download values in a DFF implemented without global data attributes would cause it to error

6.3.29 (26-Jul-2009)

Tool was not recognising an Invoice header change if Supplier Number NOT used and same Site and Invoice Total used
Removed 6.3.27 mod as it is not correcting an R12 batch header control total issue

6.3.28 (23-Jun-2009)

Added Accounting Date column to Distributions section

6.3.27 (17-Jun-2009)

Control Amount incremented for each invoice for R12 (This is still WIP)

6.3.26 (23-May-2009)

Support :D_SUM_FOLDER.EXPENDITURE_TYPE in Lines DFF

6.3.25 (21-May-2009)

Change Tax Code SQL so disabled Tax Codes are not shown
Fix to “Show Duplicates” messaging

6.3.24 (15-May-2009)

Line/Distributions DFF form was not correctly loading for R12

6.3.23 (01-May-2009)

Additional custom validation for (customer) for Goods Received Date

6.3.22 (24-Apr-2009)

Apply minor popup Calendar modifications
For R12 the Invoice Lines DFF configuration is used rather than Invoice Distributions
You are required to use the ‘AP: Copy Invoice Lines DFF to Distributions’ profile option if you want this copied to Distributions

6.3.21 (20-Apr-2009)

Added download message when download has finished<
Changes to match form: Match records will download into top row of invoice if no distributions belong to the header
Changed queries to look at invoice currency code if it exists and otherwise it uses the site/system currency code
Stopped downloader from converting null dates into 12:00am
Added error handling to downloader

6.3.20 (15-Apr-2009)

Add handlers for Invoice_ID and Distribution_Line_Number in DFF segment defaults

6.3.19 (26-Mar-2009)

Stop requirement to load a Tax Code on TAX Lines as this is not an import requirement
Fix for Distributions form defaulting Tax Code when user option has disabled this feature

6.3.18 (19-Mar-2009)

Attachments functionality enabled for R12

6.3.17 (18-Mar-2009)

Fix for Distribution form bug on loading when no Tax code exists
Fix for Distribution validation errors being cleared during validation/upload

6.3.16 (09-Mar-2009)

Added Downloader and P.O matching form
Fix bug in downloader caused by code change in dff
Fix bug in Distributions Form Tax Codes caused by controls not being activated

6.3.15 (05-Mar-2009)

Fix for bug validating Date type DFF segments causing them to fail validation

6.3.14 (27-Feb-2009)

Added Field type substitutions for Invoice Header DFFs used as defaults in Distribution level DFFs

6.3.13 (26-Feb-2009)

Duplicate check when Validating Invoices is always used now provided package body 2.0.9 or greater is installed
Added a 2nd custom Account validation rule for (customer)

6.3.12 (13-Feb-2009)

Added DFF form and full validation support for Global Descriptive Flexfields

6.3.11 (12-Feb-2009)

Added Product Category column for R12 Tax
Added Tax Regime, Tax, Tax Jurisdiction, Product Category columns to Distributions form

6.3.10 (10-Feb-2009)

Added job to check for Duplicate Invoices when in Validate only mode. Can handle several hundred invoices at a time
Requires new profile option “More4Apps: PIW Check for Inv Num Duplicates in Validate mode”

6.3.09 (09-Feb-2009)

PROJECT_ACCOUNTING_CONTEXT column is no longer used in R12
TAX_CODE_OVERRIDE_FLAG column is no longer used in R12
AMOUNT_INCLUDES_TAX_FLAG column swapped to INCL_IN_TAXABLE_LINE_FLAG for R12
New LOV for Tax Classifications in R12 replaces Tax Codes LOV

6.3.08 (03-Feb-2009)

Stop Invoice row from being skipped if the Invoice Total is blank but there are Supplier details

6.3.07 (23-Jan-2009)

Added option to Allow or Reject Duplicated Invoice Headers on the sheet. Some users want to copy the header information to all the distribution rows and some do not

6.3.06 (23-Jan-2009)

Removed obsolete columns affecting R12 queries

6.3.05 (21-Jan-2009)

Fix for problem validating new trial keys

6.3.04 (19-Jan-2009)

Fix for “Invalid Type” message in Refresh

6.3.03 (16-Jan-2009)

Fix to About and Activation key forms for v4 infrastructure package

6.3.02 (05-Jan-2009)

New debug button on error display form for Oracle errors

6.3.01 (10-Dec-2008)

Fix for tax code validation bug

6.3.00 (08-Dec-2008)

Internal changes to support new licence key model

6.2.08 (06-Dec-2008)

Tax Codes LOV was including disabled Tax Codes
Fix for Tax Code validation not selecting Tax Rate record effective for Invoice Date

6.2.07 (26-Nov-2008)

Fix to dependant value set LOV – was using Meaning column and should be using flex_value
Fix for Security rules not applying if the logged in Application is different to the standard Oracle module
Changes to Tax loading for R12
Update for code writing values to sheet to handle dates, long numbers etc

6.2.06 (20-Oct-2008)

Minor fix to error messaging pop-up settings in Distribution validation

6.2.05 (28-Oct-2008)

Allow error messages to accumulate instead of only the last message showing
Upgraded connection module for R12 logging
New profile option added to allow the blocking of responsibilities from using the tool
Removed duplicate validation of Prorate Flag

6.2.04 (10-Oct-2008)

Moved licence validation to validation upload to reduce queries at login time

6.2.03 (25-Sep-2008)

Program was stopping if Distribution errors encountered during upload even when user chose to continue

6.2.01 (10-Sep-2008)

Correct inefficient DFF segment validation on upload

6.2.00 (29-Aug-2008)

Upgrade to About form to accommodate new Activation Key

6.1.29 (16-Aug-2008)

Bug fix for apostrophe character in Invoice number

6.1.28 (07-Aug-2008)

Improvements to Named User maintenance form
Changed names of Login options. SSO method is now Standard
Disabled Holds form in favor of new Import option to add a Hold
Added option on Batch Control form to place Invoices on Hold during Import

6.1.27 (18-Jul-2008)

Check AP System Options value for Automatic Tax Calculation

6.1.26 (10-Jul-2008)

Added support for Invoice Holds. These can only be loaded after the Invoices are imported
Added new Override for Holds

6.1.25 (02-Jul-2008)

New profile option added to allow no Accounting on Distributions

6.1.24 (25-Jun-2008)

Add Description to LOV for Independant Value Sets in DFF segments

6.1.23 (10-Jun-2008)

Use “GL Set of Books ID” profile option if it exists in preference to AP System Parameters value

6.1.22 (29-May-2008)

Client specific customization added

6.1.21 (09-May-2008)

Customisation added for a customer for impossible DFF segment configuration

6.1.20 (29-Apr-2008)

Added support for “Receipt Line” column
Minor change to procedure handling apostrophes and non-ascii characters

6.1.19 (28-Apr-2008)

Support ‘Field’ type segment defaults
Stop DFF form from writing default Context to cell if not Displayed

6.1.18 (17-Apr-2008)

Add ‘Meaning’ column to Key Flexfield Segment LOVs in form
Substitution added for :INV_SUM_FOLDER.EMPLOYEE_ID to zero
Enable both P.O. and Receipt information to be loaded
Fix bug validating P.O. Release
Upload/Submit controls switched to Invoice Workbench form for a customer

6.1.17 (16-Apr-2008)

Allow override of Project Accounting according to profile option PA: Allow Override of PA Distributions in AP/PO

6.1.16 (11-Apr-2008)

When validating/uploading, DFF module was writing default/reference Contexts to s/s even if invalid

6.1.15 (11-Apr-2008)

Handle form fields in DFF Reference column
Added Defaulting for Invoice Tax Type

6.1.14 (11-Apr-2008)

Better form handling for Invalid DFF Contexts defaults or references
Do not write default DFF Context values to spreadsheet if Context is not displayed
Client specific addition to DFF form field substitutions

6.1.13 (10-Apr-2008)

Added Receipt Number column. Basic validation only

6.1.12 (07-Apr-2008)

Changes to both features added in 6.1.11

6.1.11 (25-Mar-2008)

Client specific validation added to Account Codes
Added ‘Income tax Type’ column

6.1.10 (20-Mar-2008)

Flexfield form was not displaying message if multiple segment values returned in search

6.1.09 (18-Mar-2008)

Allow user to duplicate values in Supplier, Site, Invoice Number, and Total columns without starting a new invoice

6.1.08 (17-Mar-2008)

VBA and Oracle disagree on whether to round .005 up or down. Force VBA to agree with Oracle

6.1.08 (17-Mar-2008)

VBA and Oracle disagree on whether to round .005 up or down. Force VBA to agree with Oracle

6.1.07 (06-Mar-2008)

Added Expiry date to Named Users maintenance form

6.1.07 (06-Mar-2008)

Added Expiry date to Named Users maintenance form

6.1.06 (05-Mar-2008)

Substitution added to support form field :D_SUM_FOLDER.PO_HEADER_ID in DFF segments

6.1.06 (05-Mar-2008)

Substitution added to support form field :D_SUM_FOLDER.PO_HEADER_ID in DFF segments

6.1.05 (26-Feb-2008)

Discountable Amount column was causing an upload error if removed

6.1.04 (14-Feb-2008)

Form fix – Typing into Date field resulted in a VBA error on date conversion

6.1.03 (11-Feb-2008)

DFF module and form upgraded ready for User Definable Attributes

6.1.02 (01-Feb-2008)

Fix for Exchange rate being reversed wrongly if “Journals: Display Inverse Rate” not set to Yes
If the profile option is set to Yes then you MUST use the inverse rate on the spreadsheet

6.1.01 (24-Jan-2008)

Application Information set in database for logging purposes
Fix for bug introduced in 6.0.15 stopping invoice upload (sorry)

6.0.15 (22-Jan-2008)

Client customisation added to change Batch Name
Added Charge Account to P.O. Distributions LOV<

6.0.14 (11-Jan-2008)

Modified Tax Code LOV to act as a search list or a cached list depending on the number of Tax Codes in Oracle Apps

6.0.13 (08-Jan-2008)

New Setup Sheet
Links to Online documentation added to About form
Online Documentation and Release Notes links added to login forms
Installation level and logged in Operating Unit added to About form
Added ‘Discountable Amount’ column to Invoice Header
Search buttons removed from Key Flexfield form. Search is now automatic on exiting field
Modified Terms LOV to act as a search list or a cached list depending on the number of Terms in Oracle Apps

6.0.12 (13-Dec-2007)

New profile option “More4Apps: PIW Suppress Total Check” allows you to control the total checking against the distributions

6.0.11 (06-Dec-2007)

Removed dummy values from form LOVS as the SQL does not work on some databases

6.0.10 (19-Nov-2007)

DFF form was showing messages about missing columns even if the column was not set to displayed

6.0.9 (09-Nov-2007)

Refresh was not working for Invoice Numbers containing the Apostrophe character
Fix for date formatting problem in forms writing values to spreadsheet

6.0.8 (31-Oct-2007)

New parameter added to Process Block to allow alternative XML feedback returned to spreadsheet

6.0.7 (20-Oct-2007)

Mod to Refresh function to stop it clearing Rejected Status for Distributions not uploaded

6.0.6 (09-Oct-2007)

Mod to Refresh function to stop it clearing Rejected message for Distributions not uploaded

6.0.5 (02-Oct-2007)

Changes to stop toolbars from locking up

6.0.4 (02-Oct-2007)

Added support for 11th segment to Flexfield form

6.0.3 (24-Sep-2007)

Flex form was sometimes not displaying buttons on Alias tab
Flex form now only selects Alias tab on startup if there is an Alias already in the calling form
Automatic Retry added to connection attempts to avoid whitespace error
‘Invalid user’ message avoided when session has expired
Allow for Offset Tax in Invoice total calculations

6.0.2 (18-Sep-2007)

DFF fix for Standard Date segments not being properly formatted when in Table Validated values sets
Handler added for very long numbers. Excel changes them to scientific format which is not desirable

6.0.1 (27-Aug-2007)

DFF fix for Invalid Context values. Ignore in upload
Client specific rules for checkboxes on Batches form added
Fixes for UNION statement not working on some older databases

6.0.0 (22-Aug-2007)

Fix for bug in Distributions form when Line Type column on sheet is removed
Mods for new R12 connection
Change behavior in LOVs on Distributions form to allow TypeAhead to work
Remove single quote substitution as not necessary
Right trim values for free form text DFF segments

5.1.9 (02-Aug-2007)

Handle brackets surrounding SQL based defaults in Key and Descriptive Flexfields
Right Trim spaces from Text DFF segments on upload

5.1.8 (01-Aug-2007)

Stop forms from converting date from spreadsheet into DD-Mon-YYYY format

5.1.7 (31-Jul-2007)

Fix for form bug where P.O. searched for and supplier is not set already
Key Flexfield form was not handling Profile Options in Value Set SQL

5.1.6 (24-Jul-2007)

VBA Protection added. Can now use Excel Protection from Excel menu – Tools / Protection
DFF form fix required where segment is Enabled but not Displayed
DFF fix for Profile options embedded in Value Set SQL
Enforce 150 character maximum on DFF segments with no value set

5.1.5 (18-Jul-2007)

Enforce 150 character maximum on DFF segments with no value set
Connection upgraded ready for R12

5.1.4 (09-Jul-2007)

Inverted loaded currency exchange rate to be consistent with Invoice form

5.1.3 (08-Jul-2007)

Refresh changed to stop it marking Rejected Duplicated Invoices as Processed

5.1.2 (06-Jul-2007)

Flexfield form was not enabling Ok button in certain circumstances
Flexfield form was not indicating when search required once criteria entered

5.1.1 (29-Jun-2007)

Enhancements to Tax Defaulting Rules to better reflect Payables Options Setup
New option on Setup toolbar to use or not use defaults when user does not provide a value
Bug fix for Tax Code not being loaded when default was used and user did not provide a value
Fix for missing profile option error message when using trial version

5.1.0 (22-Jun-2007)

URL attachments now supported. Requires M4APS_XML package body version 3.0.11

5.0.8 (19-Jun-2007)

DFF form fields are now disabled where columns are not available on the spreadsheet

5.0.7 (18-Jun-2007)

Attachment Category LOV not populated for German customer – Language issue in LOV SQL
Minor mods to DFF form

5.0.6 (13-Jun-2007)

Upgraded DFF and Flex modules. Bug fix for Standard Date type DFF segments

5.0.5 (12-Jun-2007)

Added parameter to Import submission to override default number of Print copies

5.0.4 (11-Jun-2007)

Apply licence key control to Validate function

5.0.3 (08-Jun-2007)

Program was ignoring user override for Expenditure Types

5.0.2 (10-May-2007)

Removed duplicate Get_Profile function
Avoid validating Invoice ID column if it contains a single space
Maximum Length validation was not working in DFF module during upload

5.0.1 (09-May-2007)

Added validation for Numeric only and Uppercase to Descriptive Flexfield form
Upload was allowing characters for certain Numeric only Descriptive Flexfield value sets
Added logged in responsibility to About form
This and all future versions will NOT operate in MS-Excel 97

5.0.0 (08-May-2007)

Added support for Single Signon

4.0.1 (30-Apr-2007)

Enable DFF Context LOV and validation if Reference field used as otherwise this is not supported
The above excludes Vendor Type Code and Profile Option based Reference values because these are already supported
Both Reference and Default Fields in the DFF Contexts are now defaulted by the Wizard in the Upload process

4.0.0 (26-Apr-2007)

Changed Load Counter method so Profile option is only written to for trial version customers
Requires AP Invoice Package body version 2.0.0 or trial version users will not be able to load more than 5 distributions at all

3.1.02 (16-Apr-2007)

URLEncoding added to handle special characters in new bind variable performance technique
Slight changes to rules for DFF context defaulting
Add support for Vendor Type Code Reference default

3.1.01 (29-Mar-2007)

Performance enhancements added to upload validation

3.1.00 (19-Mar-2007)

Fix for timeout problem caused by Internet Explorer 7

3.0.10 (06-Mar-2007)

Fix bug in Supplier Name and Number search
Added Document Category to override tables

3.0.09 (26-Feb-2007)

Further enhancements for Standard Date and Standard DateTime type value sets in Descriptive Flexfields

3.0.08 (23-Feb-2007)

Address NLS problem in Flexfield value sets with TO_DATE() on Date values

3.0.07 (20-Feb-2007)

Security Rules only apply where value set has “Security Enabled Flag” set to Yes

3.0.06 (16-Feb-2007)

Add support for Security Rules for Accounting Segment LOVs
Limit to 5000 records in search was not working in Key Flexfield LOVs if no search criteria entered

3.0.05 (07-Feb-2007)

Handle very large Supplier Site LOV with search function. Enabled for over 5000 Sites
Client specific customisation added

3.0.04 (03-Feb-2007)

Overrides for Payment Methods, Pay Groups, and Tax Codes LOVs

3.0.03 (30-Jan-2007)

Tolerate missing port number in login URL (for 8000 default)
Better error handling for invalid URL setup

3.0.02 (23-Jan-2007)

Multi-language fix in DFF module
Fix for DFF validation bug introduced in 3.0.01
Key Flexfield fix for Non-validated value sets>

3.0.01 (22-Jan-2007)

Batch Source parameter added to Batch submit process – prior to this only batches with seeded default MORE4APPS batch source were being imported
Batch Submit button on Submit form was enabled if there were no batches to import
Minor cosmetic improvements to Batch Submit form

2.2.30 (18-Jan-2007)

Client specific customisation added

2.2.29 (18-Jan-2007)

Non-validated DFF segments were not being coloured on validation
Dist DFF segment 2 was being incorrectly mapped to the spreadsheet column for DFF segment 1 in upload/validation

2.2.28 (16-Jan-2007)

Was not loading IDs for DFFs. Fix for Date type DFF segments

2.2.27 (12-Jan-2007)

Batch Name changed to include year

2.2.26 (09-Jan-2007)

Bug fix in DFF/Flex modules for multiple Profile Options in Table Validated value sets
Special value set based DFF segments were not changing coluor on form load if value correct

2.2.25 (03-Jan-2007)

Expenditure Orgs LOV was excluding all Organisations end-dated before the current date
Removed this condition as it stops Item Dates being used before the current date for these Orgs

2.2.24 (28-Dec-2006)

Completed Mods for installation on OOD instances
10g database was not being detected properly for non-ASCII character handling

2.2.23 (19-Dec-2006)

DFF module enhanced to handle multiple dependencies

2.2.22 (12-Dec-2006)

Added Dist AWT Group column
Added check for AWT Group Flag on Supplier Site

2.2.21 (11-Dec-2006)

Enhancement to Flexfied module to better handle very large value sets

2.2.20 (08-Dec-2006)

Added AWT Group column

2.2.19 (30-Nov-2006)

Added support for Liability Account
Two fixes to DFF form for ‘Special’ value sets

2.2.18 (21-Nov-2006)

Terms Date column is not available in 11.5.5

2.2.17 (20-Nov-2006)

Add support for DFF Context Reference based on Profile options
Add support for “Special” Value Sets

2.2.16 (17-Nov-2006)

Fix for DFF and Flex Segments dependant on other segments where surrounding brackets used
Workaround added to not validate against Table Validated value sets with multiple dependencies

2.2.15 (17-Nov-2006)

DFF form was trying to get default values before parent segments determined, causing SQL errors

2.2.14 (15-Nov-2006)

DFF form was not using SQL conditions in Table validated value sets in some scenarios
Fix for Supplier Name value in form field for use in DFF validation
Handle defaults in DFF context, and Required flag

2.2.13 (14-Nov-2006)

Upload process changed to only generate values from defaults if mandatory and no value provided
DFF form generates values from all defaults if loaded

2.2.12 (13-Nov-2006)

Cope with space left in Invoice Total column

2.2.11 (10-Nov-2006)

Handle Supplier Site ID form field reference in DFF segments
Apply single quotes around Profile Option substitutions

2.2.10 (08-Nov-2006)

Further fix for case where no Tax Codes are defined
Handle Supplier Name form field reference in DFF segments

2.2.09 (07-Nov-2006)

Handler added for errors caused by apostrophe character in filename

2.2.08 (01-Nov-2006)

Handle case where no Tax Codes are defined
Validate Invoice Line before running DFF form for Distributions
Handle Account form field reference in Distributions DFF segments

2.2.07 (26-Oct-2006)

DFF form changed to not automatically select 1st value in LOV
DFF form now watches for values that will be stripped or truncated by Excel
Handle numerous Invoice Header form fields in DFF segments

2.2.06 (21-Oct-2006)

DFF validation procedure was not resetting result array
Duplicate Invoice and PA validation feedback was failing for European language PCs

2.2.05 (19-Oct-2006)

Supplier Name was being validated even if Supplier Number was supplied

2.2.04 (18-Oct-2006)

Added check for Postable flag on Account
Attachments form required the same fix as in 2.2.03 for Pending Invoices
Lowered cache size to 28KB to prevent failure in bulk upload

2.2.03 (14-Oct-2006)

Refresh function was incorrectly attempting to load Attachments when Invoice Pending

2.2.02 (10-Oct-2006)

Add distribution level Global Attributes

2.2.01 (03-Oct-2006)

Removed unnecessary post login PA patch level checks

2.2.00 (28-Sep-2006)

Add validation to prevent upload of duplicate Invoice Numbers. Requires package body version 1.2.0

2.1.30 (21-Sep-2006)

Stop forms from overwriting spreadsheet cell values when there is no change

2.1.29 (15-Sep-2006)

Upload process was displaying the wrong form if the user elected to respond to Invoice Date warning

2.1.28 (14-Sep-2006)

Added global attribute columns

2.1.27 (13-Sep-2006)

Tolerate using either ‘Date Received’ or ‘Invoice Received Date’ column headings

2.1.26 (12-Sep-2006)

Distributions form was incorrectly setting the tax code to the first one when no default existed

2.1.25 (30-Aug-2006)

Group ID column was not being checked for non-ascii characters for hex conversion
Additional DFF substitution for Jacobs

2.1.24 (30-Aug-2006)

New column added, “Goods Received Date”. Renamed “Date Received” column to “Invoice Received Date”

2.1.23 (18-Aug-2006)

Search button added for Aliases instead of caching all Aliases at startup

2.1.22 (16-Aug-2006)

Attachment Categories LOV changed to multi-language view

2.1.21 (02-Aug-2006)

Fixed P.O. LOV problem displaying duplicate records
Added another segment to the Accounting Key Flexfield module – now supports 10 segments

2.1.20 (21-Jul-2006)

Changed layout of Batches form
Calender form changed to fix backspace bug

2.1.19 (20-Jul-2006)

Fix to Replace97 procedure for Excel 97 users

2.1.18 (07-Jul-2006)

New Tax code validation was not preventing the upload if the Tax code is invalid

2.1.17 (05-Jul-2006)

Tax code active dates now compared with Invoice Date, not System date

2.1.16 (30-Jun-2006)

“Tax: Allow Override of Tax Code” profile option setting was being interpreted as No if left blank instead of Yes which was inconsistent with the Oracle form’s behavior

2.1.15 (26-Jun-2006)

Warnings added for future invoice dates and invoice dates greater than a year old

2.1.14 (20-Jun-2006)

Fix for Excel 97 for certain Replace scenarios
Switch to AP_TOLERANCE_TEMPLATES for 11.5.10 for Tax tolerances
Added validation to ensure Tax Code is loaded against Tax Lines
Allow Distributions form to tolerate missing Tax Code column and still calculate Tax

2.1.13 (14-Jun-2006)

Fix for bug in Invoice Header form when querying Supplier Number and no Supplier Name column exists

2.1.12 (13-Jun-2006)

Account validation error messages were not being written to the Line Error column

2.1.11 (09-Jun-2006)

Change to Tax tolerance code was not working on 11.5.9

2.1.10 (07-Jun-2006)

Useability improvements to login form
Tax code was not being loaded where the Tax: Allow Override of Tax Code is set to No

2.1.09 (23-May-2006)

Fix to SQL based default Flexfield segment processing
Extend character conversion for 11.5.10CU2 Apache security

2.1.08 (17-May-2006)

Table based validation added for Key Flex fields
Minor enhancement to Named User form
Enhancement to login form to better show HTML error messages

2.1.07 (12-Apr-2006)

Prepayment columns added
Totals and Distribution Totals Validation comparison fixed
Messaging changed to allow suppression of the load form option on the Error form. Useful for when the columns being validated have no form
Enhancement to login form to better show HTML error messages
Fix for minor form bug when Supplier Name column missing

2.1.06 (06-Apr-2006)

Login enhanced to allow non alphanumeric and space characters in password

2.1.05 (28-Mar-2006)

Fix for Distribution total calculation where Tax: Allow Override of Tax Code set to ‘No’

2.1.04 (21-Mar-2006)

Refresh function was not clearing Tax Line ID

2.1.03 (20-Mar-2006)

Calc function not working on form for Line Tax Code level tax calculations

2.1.02 (01-Mar-2006)

Fix to intermittant failure in Attachment upload
Calendar positioned for Excel 97

2.1.01 (21-Feb-2006)

DFF module was not turning default user values into IDs when user leaves value blank

2.1.00 (17-Feb-2006)

Attachments operating for 11.5.10
MS-Office Calendar replaced with VBA calendar

2.0.69 (14-Feb-2006)

Change in Alias selection was not re-populating Segments
Refresh was not showing Validation status for unpurged, processed Invoices
Attachments functionality added

2.0.68 (19-Jan-2006)

Loop added to counter intermittant failure to show toolbars on startup

2.0.67 (23-Dec-2005)

Requester column added

2.0.66 (23-Nov-2005)

Allow TAX Lines to be loaded for sites set to Tax code and Line Tax calculation levels
Account was not being colour coded properly after validation
Line Type was not being colour coded properly after validation in form

2.0.65 (14-Nov-2005)

Prevent duplicate database call populating LOVs in DFF form
Fix bug stopping LOV being populated when a default exists
Allow for carriage returns in strings in DFF Value sets
Late binding implemented for Calendar Control
Stop commas being accepted as Numeric by DFF module

2.0.64 (11-Nov-2005)

9th Key Flexfield segment was not working
Stop login loop if M4APS_XML package not installed

2.0.63 (04-Nov-2005)

Batches form was not limiting the LOV to the selected user

2.0.62 (31-Oct-2005)

PO Header ID was not clearing after each Distribution for subsequent PO related Distributions

2.0.61 (19-Oct-2005)

User value for Currency Type was being loaded into interface instead of Currency Type Code
Fix for Excel truncating leading and trailing zeros from text values

2.0.60 (18-Oct-2005)

Correct overflow error in PO validation caused by using Integer instead of Long variable types

2.0.59 (14-Oct-2005)

Correct Line level Tax calculation problem
Correct form re-loading getting the wrong Distribution line total
Allow for no values in Tax: Allow Tax Code Override profile option
Move tests for DFF configuration to Startup
Add logic suppressing unnecessary DFF buttons on toolbar

2.0.58 (29-Sep-2005)

Fix for calculated Invoice total not resetting if user chooses to reload form

2.0.57 (27-Sep-2005)

Added Search button to Named User Licence form
New Voucher Number column added

2.0.56 (12-Sep-2005)

Switched XML object from Fixed Reference to Late Binding
Cosmetic forms fixes

2.0.55 (29-Aug-2005)

Invoice number validation was incorrectly set to 150 characters instead of 50

2.0.54 (28-Jul-2005)

Use Site level Up/Down/Nearest setting for Tax rounding
Use Tax Precision instead of Currency precision for Tax calculations

2.0.53 (27-Jul-2005)

Stop repeated DFF configuration caching when no columns defined

2.0.52 (26-Jul-2005)

Added ‘List My Batches Only” checkbox to Batches form

2.0.51 (25-Jul-2005)

Added Optional Validation Status column so Refresh can show this information

2.0.50 (20-Jul-2005)

Exclude inactive Suppliers and Supplier Sites

2.0.49 (06-Jul-2005)

Fix for MLS code change affecting procedure calls including apostrophe characters

2.0.48 (22-Jun-2005)

Remove Digital Certificate
Support new login validation method
Fix DFF Reference field issue

2.0.47 (14-Jun-2005)

Bug fix in DFF module
Switched to MLS lookup tables

2.0.46 (06-Jun-2005)

Support Unicode usernames and passwords. Requires XML package body 2.0.46

2.0.45 (03-Jun-2005)

Fix for Ascii characters mixed with Unicode values
Conversion to MLS tables

2.0.44 (30-May-2005)

Bug Fix to DFF module
Changes to cope with Unicode characters. Requires XML package body 2.0.45
Unicode workaround is unavailable for databases prior to 8i

2.0.43 (09-May-2005)

DFF module bug fix for Independant value sets

2.0.42 (02-May-2005)

Bug fix for ID incorrectly loaded into DFF column for independant value set items
Fix for change in Oracle PA Transaction validation parameters in 11.5.8 / PA.J
Handle single quote character in DFF values

2.0.41 (27-Apr-2005)

Fix for incorrect ‘No Accounting’ message for PO matched Distributions

2.0.40 (18-Apr-2005)

Support Profile Option in DFF Context Reference field
Bug fix for ID incorrectly loaded into DFF column for independant value set items
Package Body corrected for fix to PA transaction control validation

2.0.39 (13-Mar-2005)

Remove ‘No Accounting’ message for Prorate Distributions
Release Notes link added to About form

2.0.38 (13-Mar-2005)

Changes to DFF module

2.0.37 (30-Mar-2005)

Errors in DFFs were not stopping upload
Support for optional column “Terms Date” added
Fix for Digital signature being removed

2.0.36 (14-Mar-2005)

Defaults were not applying for DFFs in upload process
Fix for Profile option defaults in Accounting Key Flexfield
Hide login configuration toolbar unless Setup toolbar shown
Add “Hide permanently” option to Setup toolbar

2.0.35 (03-Mar-2005)

Fix for European decimal character not being handled properly

2.0.34 (22-Feb-2005)

Remove Function to Check for non-Ascii characters

2.0.33 (22-Feb-2005)

Improve DFF module performance

2.0.32 (16-Feb-2005)

Support for Named User Licence model added
Descriptive Flexfields module added

2.0.31 (14-Feb-2005)

Stopped Default organisation from writing over Project Number in Distributions form
Required search criteria for P.O. Search
Fixed minor form bug in Distributions form where Default Tax code is invalid
Multiple Invoice Upload was aborting if error encountered

2.0.30 (20-Jan-2005)

Added default Expenditure Organisation for Project Related Invoice Distributions

2.0.29 (10-Jan-2005)

Bug fix – “Accounting is not completed” message was overrriding a validation error message

2.0.28 (22-Dec-2004)

Bug fix – was not allowing for Inactive date on Supplier Site
Performance enhancement for SQL processing

2.0.27 (06-Dec-2004)

Fix for Refresh not working if leading or trailing blanks in invoice number
Added validation step to ensure Accounting is completed for non TAX Distributions

2.0.26 (29-Nov-2004)

New column ‘Tax Amount’ added for an alternative to separate Tax Distributions
Program was stopping prematurely if a Distribution error prevented the Invoice total from being calculated
Additional validation added for Supplier Site Calculation level
Added Supplier site defaulting for only one Pay Site exists

2.0.25 (24-Nov-2004)

Added message for incompatible use of Includes Tax flag and Site calculation level = Header or None
Added message for incompatible use of TAX Distributions and Site calculation level = Line or Tax Code

2.0.24 (21-Nov-2004)

Removed incorrect rule stopping revenue accounts from being charged to

2.0.23 (01-Nov-2004)

Support scenario for Calculation Level set to Line/Tax Code and non tax-inclusive distribution amounts loaded

2.0.22 (29-Oct-2004)

Fix for Rounding problem with negative Distribution Amounts

2.0.21 (22-Oct-2004)

Minor fix to Batches form – Submit button was disabled

2.0.20 (06-Oct-2004)

Cached Account codes so only validated once – Considerable speed improvement

2.0.19 (29-Sep-2004)

Support for aliases and SQL segment derived default codes added
New option to select alternative Batch Sources

2.0.18 (20-Sep-2004)

Efficiency improvements

2.0.17 (12-Sep-2004)

Removed references to VBProject collection code. Improvement to double-click technique

2.0.16 (10-Sep-2004)

Fix for “EXCEPTION” / “lock completed” message when no new data uploaded but upload attempted again
Further fix to Distributions form for Tax code
Mod to Submit Batches form to change Invoice Batch name when Gateway Batch selection changes

2.0.15 (09-Sep-2004)

Distributions form had incorrect logic for Includes Tax Flag/Tax Code combination
AP was not accepting Tax Code overrides because we were not correctly setting a flag

2.0.14 (07-Sep-2004)

Fix for bug loading wrong Invoice ID against Invoice Line after block processed

2.0.13 (01-Sep-2004)

Error handling improved for invalid formula in Distribution Amount
Simplified checking for Processed Invoices status

2.0.12 (29-Aug-2004)

Major speed improvement through caching entire upload process
Fix for issue with CCID validation
Can now use any responsibility provided AP functions included

2.0.11 (13-Aug-2004)

Added caching to increase upload performance

2.0.10 (31-Jul-2004)

Add Function to Check for non-Ascii characters
Check for duplicated column headings added

2.0.09 (05-Aug-2004)

Applying currency precision to all Invoice and Distribution amounts

2.0.08 (14-Jul-2004)

Fix for fault in auto calc procedure
Added support for secure socket connection

2.0.07 (07-Jul-2004)

Fix for fault in error message in Invoice ID invalid
Added import/export config settings feature

2.0.06 (22-Jun-2004)

Change fixed array to dynamic for user responsibilities

2.0.05 (18-Jun-2004)

Invoice Total check modified to avoid VBA maths error comparing two numbers
Task LOV in Details form was not working perfectly
Switched IE API to handle UniCode characters

2.0.04 (14-Jun-2004)

Check invoice total against total distributions amount and add optional auto invoice total calculation feature

2.0.03 (04-Jun-2004)

Fix for Invoice header form error if Document Category column removed

2.0.02 (03-Jun-2004)

Login script change to allow for port numbers larger than integer size limit

2.0.01 (30-Apr-2004)

Only enabled currency codes selected
Minor change to cope with possibility of apostrophe in sheet name

2.0.00 (13-Apr-2004)

Change from ADO to XML HTTP data access method

1.2.06 (26-Apr-2004)

Backported to R11.0.3

1.2.05 (24-Mar-2004)

Added Charge controls validation for Project related Lines
New error message form allowing user to fix errors then continue upload
Added support for “Pay Group” column to sheet and Invoice form

1.2.04 (02-Mar-2004)

Bug fix – Program stopped immediately if Supplier Invalid
Bug fix – 2nd query of Project Numbers returned error

1.2.03 (24-Feb-2004)

Added ability to select a range of Invoices to upload

1.2.02 (23-Feb-2004)

Improved error handling for Project related columns
Form was not clearing fields on sheet if Project Number cleared

1.2.01 (20-Feb-2004)

New button on Setup toolbar allows show/hide of Template sheet
Added public code to enable double-click in external workbooks

1.1.09 (27-Jan-2004)

Distributions form was incorrectly obtaining values for previous line
Cleared Status bar after logging in
Distributions form showed error in Amount/Quantity/Price fields on load
Cosmetic change for Invoice and Line Status for “Processed” invoices

1.1.08 (17-Jan-2004)

Cleared Unit Price and Qty Invoiced fields in no Shipment Line
Stopped Amount field from clearing if no Shipment Line
Always load Invoice Currency to avoid bug in AP Invoice Import
Ensure Amounts are within currency precision
Fixed problem with cleared fields not clearing data on sheet
Fixed minor bug in searching through cached P.O. Numbers
Fixed minor bug in Distributions form causing PO Number field to be red
Delete Batch was not clearing LOV afterwards if LOV empty
Minor Form fix for Invoice form – Amount was not being formatted properly on sheet
Now warns user then writes values changed during precision check to spreadsheet
New error message for no Supplier AND no PO at Invoice Header level
Improvements to Account Flexfield forms functionality
Allowed P.O number and Site selection without Supplier selection
Corrected “Processed” colour for sheet status

1.1.07 (14-Jan-2004)

Fix for Round() function which does not work in Excel 97
Changed “Item Date” label to “Invoice Date” on Invoice form

1.1.06 (28-Dec-2003)

Major changes to P.O. matching, new Quantity Invoiced and Unit Price columns
Added support for Cross Charge Projects and Tasks
Updated Flex form for non-mandatory Key Flexfield segments

1.1.05 (11-Dec-2003)

Was not resetting test for P.O. Supplier ID for each new invoice
Improved handling for P.O.s with Releases
Enhancement to auto-complete behavior in Account Flexfield form

1.1.04 (03-Dec-2003)

Permission to Import or Load was not working first time

1.1.03 (18-Nov-2003)

Enhance About form and password expiry feature
Allowed numeric characters at beginning of database password

1.1.02 (07-Nov-2003)

Fixed bug in PO Lines and Inventory Items LOVs
Added Password Expiry check
Added Inventory Item number to LOV
Cosmetic improvements to Distributions form
Added Ctrl I and Ctrl D Hotkeys
Function security calls added

1.1.01 (12-Oct-2003)

Added “Date Received” column
Improved colour handling for Status columns

1.0.09 (30-Sep-2003)

Removed (invalid) link on P.O. to Supplier Site from form
Clearing supplier on form now clears other Supplier columns
Corrected potential error if Supplier/P.O. arrays filled and no match
Allowed users to type into Accounting Segment string on form

1.0.08 (22-Sep-2003)

Added Inventory Item column
Added Delete Batch function
Linked Supplier site on P.O. to Supplier Site on form
Added Address to Supplier Site LOV

1.0.07 (08-Sep-2003)

Corrected bug in Submit Import process from 1.0.06
Minor forms improvements
Now forms hide tabs if tabs not relevant to sheet data
Added conditions to P.O.s for not cancelled, finally closed etc

1.0.06 (05-Sep-2003)

Added “Invoice Batch” parameter to Submit Import process

1.0.05 (04-Sep-2003)

Terms ID was not correct. Was retrieving the form LOV’s sort key instead of the ID value

1.0.04 (01-Sep-2003)

First release. Built on R11i 11.5.8 and 11.5.9