Package Body Version - This is the product packages included in the current version of the wizard. The Minimum version (shown in brackets) is the lowest version of the package required to enable the wizard to function.
Wizard Version
|
9.0.06 (27-Apr-2012)
|
|
Package Body Version
|
3.1.4 (Minimum 2.0.7) |
-
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
Wizard Version
|
9.0.05 (18-Apr-2012)
|
|
Package Body Version
|
3.1.4 (Minimum 2.0.7) |
-
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
Wizard Version
|
9.0.04 (03-Apr-2012)
|
|
Package Body Version
|
3.1.4 (Minimum 2.0.7) |
-
Added Customer Taxpayer column
Wizard Version
|
9.0.03 (02-Apr-2012)
|
|
Package Body Version
|
3.1.4 (Minimum 2.0.7) |
-
Fix for Subscript out of Range messages in Distributions form after change of Operating Unit
Wizard Version
|
9.0.02 (03-Mar-2012)
|
|
Package Body Version
|
3.1.4 (Minimum 2.0.7) |
-
Clear the profile option cache when changing responsibility
-
Multi-Org: Tax Rate Name, Regime Tax Codes, Tax Status Codes
Wizard Version
|
9.0.01 (22-Feb-2012)
|
|
Package Body Version
|
3.1.4 (Minimum 2.0.7) |
-
Multi-orged: location,legal entity,Tax codes
Wizard Version
|
9.0.00 (22-Feb-2012)
|
|
Package Body Version
|
3.1.4 (Minimum 2.0.7) |
-
Major changes for new 'Operating Unit' column
Wizard Version
|
8.2.35 (22-Feb-2012)
|
|
Package Body Version
|
3.1.4 (Minimum 2.0.7) |
-
Instance shown on status bar and forms. Fix color bug in URL setup and Help forms
Version 8.2.33 (15-Feb-2012)
Added Header Level Liability Account to download
Version 8.2.34 (17-Feb-2012)
Added Doc Sequence Value to Voucher Number download
Version 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
Version 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
Version 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.
Version 8.2.29 (22-Nov-2011)
Payment Terms LOV and validation was not rejecting end-dated values
Version 8.2.28 (16-Nov-2011)
Fix for matching form error. Form would error if wizard was not already logged in
Version 8.2.27 (16-Nov-2011)
Fix for form error when closing 'Edit Match Quantity' form
Version 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
Version 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.
Version 8.2.24 (04-Nov-2011)
Add support for Award Number column to Form and Upload. Download not done yet
Version 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
Version 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.
Version 8.2.21(19-Oct-2011)
Tax Code now downloading into text column to stop leading zeros being stripped.
Version 8.2.20 (17-Oct-2011)
Trim Tax code column to remove leading spaces
Skip Invoice Header DFF validation for client
Version 8.2.19 (14-Oct-2011)
Added Customization for client. Pay details defaulting from site in header form
Version 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
Version 8.2.17 (11-Oct-2011)
Added columns - Tax Control Amount and Tax Region.
Added Accounting Date to distributions form.
Version 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.
Version 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
Version 8.2.14 (20-Sep-2011)
Change to customization for (customer)
Version 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
Version 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
Version 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
Version 8.2.29 (22-Nov-2011)
Payment Terms LOV and validation was not rejecting end-dated values
Version 8.2.28 (16-Nov-2011)
Fix for matching form error. Form would error if wizard was not already logged in
Version 8.2.27 (16-Nov-2011)
Fix for form error when closing 'Edit Match Quantity' form
Version 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
Version 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.
Version 8.2.24 (04-Nov-2011)
Add support for Award Number column to Form and Upload. Download not done yet
Version 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
Version 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 client.
Version 8.2.21 (19-Oct-2011)
Tax Code now downloading into text column to stop leading zeros from being stripped.
Version 8.2.20 (17-Oct-2011)
Trim Tax code column to remove leading spaces
Skip Invoice Header DFF validation for client
Validation 8.2.19 (14_Oct-2011)
Added Customization for Client - Pay details defaulting from site in header form
Version 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.
Version 8.2.17 (11-Nov-2011)
Added columns - Tax Control Amount and Tax Region.
Added Accounting Date to distributions form.
Version 8.2.16 (03-Nov-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.
Version 8.2.15 (27-Sep-2011)
Added customization for client to 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
Version 8.2.14 (20-Sep-2011)
Change to customization for (customer)
Version 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
Version 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'.
Version 8.2.11 (26-Aug-2011)
Fix for Tax Code Error: 'Tax Code '*Tax Name*' is not valid for the invoice date
Version 8.2.10 (24-Aug-2011)
Fix for problem when closing combinations form caused by new Splash form
Version 8.2.09 (25-Jul-2011)
Fixed bug in rounding during Tax calculations
Version 8.2.08 (12-Jul-2011)
Added support for :D_SUM_FOLDER.DIST_CODE_COMBINATION_ID in DFF attributes default SQL
Version 8.2.07 (11-Jul-2011)
RCV Transaction ID was being incorrectly loaded into the Receipt Line Number column for older package body versions
Version 8.2.06 (07-Jul-2011)
Added support for :INV_SUM_FOLDER.INVOICE_TYPE in DFF attributes default SQL
Version 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.
Version 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.
Version 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.
Version 8.2.02 (27-Jun-2011)
Changed Receipt Line validation to load RCV Transaction ID rather than Receipt Line Number
Version 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
Release 8.2.00 (14-June-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)
Release 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
Release 8.1.14 (13-Jun-2011)
P.O. Download feature added
Release 8.1.13 (11-Jun-2011)
Fix for error when using Date criteria in download form
Release 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
Release 8.1.11 (02-Jun-2011)
Invoices containing Charge Controls errors in Project related Distributions are no longer partially loaded
Release 8.1.10 (20-May-2011)
Attachments loader now able to upload files directly from HTTP(s) sources
Version 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
Version 8.1.08 (06-May-2011)
Update for non-ascii character problem
Version 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
Version 8.1.06 (21-Apr-2011)
Added DFF substitution for :D_SUM_FOLDER.PO_DISTRIBUTION_ID form field
Version 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
Version 8.1.04 (07-Apr-2011)
Further performance improvement to post login processes
Version 8.1.03 (31-Mar-2011)
Includes Tax Flag was being cleared when opening the Distributions form
Version 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
Version 8.1.01 (21-Mar-2011)
Fix for incorrect colour coding on deleting an invoice
Version 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
Version 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
Version 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
Version 8.0.06 (03-Feb-2011)
Fixes added for non-ascii character handling
Version 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
Version 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
Version 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
Version 8.0.02 (2-Nov-2010)
Fix for Supplier Site loaded when using P.O. related Distributions coming from P.O. and not spreadsheet
Version 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'
Version 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
Version 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
Version 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
Version 7.1.48 (15-Sep-2010)
Fixed 11.5.10 download bug introduced in 7.1.47
Version 7.1.47 (14-Sep-2010)
Added document sub type column and substitution - display name Invoice Sub-Type, only for R12
Version 7.1.46 (3-Sep-2010)
Fixed DFF bug causing double-up of single quotes around substituted form fields
Version 7.1.45 (2-Sep-2010)
Further mods to Hierarchical security
Version 7.1.44 (2-Sep-2010)
Further mods to Hierarchical security
Version 7.1.43 (31-Aug-2010)
Added Hierarchical Security to key flex form
Version 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
Version 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
Version 7.1.40 (3-Aug-2010)
Further work on DFF dates. Now includes download conversion
Version 7.1.39 (29-Jul-2010)
Bug fix for DFF Date validation implemented in 7.1.38
Version 7.1.38 (28-Jul-2010)
Changes to DFF Date validation and upload values
Download change to r12 Distributions Line Type
Version 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
Version 7.1.36 (21-Jul-2010)
Fixed download of 'Accounting Date' and 'Item Date'
Version 7.1.35 (20-Jul-2010)
VBA in Excel 2007 can work through Worksheet Protection so any password can be used
Version 7.1.34 (19-Jul-2010)
Allow VBA to operate through spreadsheet protection for Excel 2002 (Excel XP)
Version 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
Version 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
Version 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
Version 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
Version 7.1.29 (15-Jun-2010)
Added support for form field 'INV_SUM_FOLDER.Org_ID' in DFF segment validation
Version 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
Version 7.1.27 (7-Jun-2010)
Fix for incorrect rejection in R11i when Includes Tax Flag used
Fix for Concurrent Requests form
Version 7.1.26 (2-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
Version 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
Version 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
Version 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
Version 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
Version 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
Version 7.1.20 (6-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
Version 7.1.19 (4-May-2010)
Added profile option "More4Apps: PIW Disable GL Date on Batch Import" to prevent users using the GL Date parameter on batch import
Version 7.1.18 (3-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
Version 7.1.17 (29-Apr-2010)
Fix required if new PAY AWT columns deleted
Version 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
Version 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
Version 7.1.14 (9-Apr-2010)
Added back Set of Books constraint on Asset Book LOV for R12
Version 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
Version 7.1.12 (17-Mar-2010)
Customised Concurrent Request submission for (customer)
Significant performance improvement in Concurrent Requests viewer
Version 7.1.11 (10-Mar-2010)
Removed Set of Books constraint on Asset Book LOV
Version 7.1.10 (4-Mar-2010)
Added 'Invoice Type' column as R12 supports 'Prepayment and 'Debit Memo' Invoice Types
Version 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
Version 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
Version 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
Version 7.1.06 (12-Feb-2010)
Some of the R12 Tax LOVs were not containing values
Version 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
Version 7.1.04 (4-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
Version 7.1.03 (2-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
Version 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
Version 7.1.01 (18-Jan-2010)
Allow distributions with both P.O. and Accounting segments
Version 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
Version 7.0.01 (22-Dec-2009)
Fix to ORG_ID value in R12
Version 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
Version 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
Version 6.3.51 (9-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
Version 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
Version 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
Version 6.3.48 (24-Nov-2009)
Fixed fault in Get_Aliases procedure
Version 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
Version 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
Version 6.3.45 (29-Oct-2009)
Added new 'View Concurrent Requests' form
Version 6.3.44 (22-Oct-2009)
Added substitution for :INV_SUM_FOLDER.VENDOR_NUMBER
Version 6.3.43 (13-Oct-2009)
Removed invalid entries from LOV for Document Categories
Version 6.3.42 (25-Sep-2009)
Fix for ROWNUM limited queries returning wrong record set from multi-org queries
Version 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
Version 6.3.40 (16-Sep-2009)
Added two substitutions into the downloader
Version 6.3.39 (7-Sep-2009)
Added repaint to Flexform activate. Form was not repainting properly at one site
Version 6.3.38 (2-Sep-2009)
Message for invalid Requestor was not being recorded in the Invoice Error column
Version 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
Version 6.3.36 (18-Aug-2009)
DFF error in a Distribution was not stopping upload of the Distribution
Version 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
Version 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
Version 6.3.33 (3-Aug-2009)
Added Custom Account validation for (Customer)
Version 6.3.32 (14-Jul-2009)
Added case insensitivity to (Customer) Customisation Financial Delegation code
Version 6.3.31 (8-Jul-2009)
Added control allowing administrators to set the minimum allowable version number. Uses profile option "More4Apps: PIW Minumum version"
Version 6.3.30 (1-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.
Version 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
Version 6.3.28 (23-Jun-2009)
Added Accounting Date column to Distributions section
Version 6.3.27 (17-Jun-2009)
Control Amount incremented for each invoice for R12 (This is still WIP)
Version 6.3.26 (23-May-2009)
Support :D_SUM_FOLDER.EXPENDITURE_TYPE in Lines DFF
Version 6.3.25 (21-May-2009)
Change Tax Code SQL so disabled Tax Codes are not shown
Fix to "Show Duplicates" messaging
Version 6.3.24 (15-May-2009)
Line/Distributions DFF form was not correctly loading for R12
Version 6.3.23 (1-May-2009)
Additional custom validation for (customer) for Goods Received Date
Version 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
Version 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
Version 6.3.20 (15-Apr-2009)
Add handlers for Invoice_ID and Distribution_Line_Number in DFF segment defaults
Version 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
Version 6.3.18 (19-Mar-2009)
Attachments functionality enabled for R12
Version 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
Version 6.3.16 (9-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
Version 6.3.15 (5-Mar-2009)
Fix for bug validating Date type DFF segments causing them to fail validation
Version 6.3.14 (27-Feb-2009)
Added Field type substitutions for Invoice Header DFFs used as defaults in Distribution level DFFs
Version 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)
Version 6.3.12 (13-Feb-2009)
Added DFF form and full validation support for Global Descriptive Flexfields
Version 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
Version 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"
Version 6.3.09 (9-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
Version 6.3.08 (3-Feb-2009)
Stop Invoice row from being skipped if the Invoice Total is blank but there are Supplier details
Version 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
Version 6.3.06 (23-Jan-2009)
Removed obsolete columns affecting R12 queries
Version 6.3.05 (21-Jan-2009)
Fix for problem validating new trial keys
Version 6.3.04 (19-Jan-2009)
Fix for "Invalid Type" message in Refresh
Version 6.3.03 (16-Jan-2009)
Fix to About and Activation key forms for v4 infrastructure package
Version 6.3.02 (5-Jan-2009)
New debug button on error display form for Oracle errors
Version 6.3.01 (10-Dec-2008)
Fix for tax code validation bug
Version 6.3.00 (8-Dec-2008)
Internal changes to support new licence key model
Version 6.2.08 (6-Dec-2008)
Tax Codes LOV was including disabled Tax Codes
Fix for Tax Code validation not selecting Tax Rate record effective for Invoice Date
Version 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
Version 6.2.06 (20-Oct-2008)
Minor fix to error messaging pop-up settings in Distribution validation
Version 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
Version 6.2.04 (10-Oct-2008)
Moved licence validation to validation upload to reduce queries at login time
Version 6.2.03 (25-Sep-2008)
Program was stopping if Distribution errors encountered during upload even when user chose to continue
Version 6.2.01 (10-Sep-2008)
Correct inefficient DFF segment validation on upload
Version 6.2.00 (29-Aug-2008)
Upgrade to About form to accommodate new Activation Key
Version 6.1.29 (16-Aug-2008)
Bug fix for apostrophe character in Invoice number
Version 6.1.28 (7-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
Version 6.1.27 (18-Jul-2008)
Check AP System Options value for Automatic Tax Calculation
Version 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
Version 6.1.25 (2-Jul-2008)
New profile option added to allow no Accounting on Distributions
Version 6.1.24 (25-Jun-2008)
Add Description to LOV for Independant Value Sets in DFF segments
Version 6.1.23 (10-Jun-2008)
Use "GL Set of Books ID" profile option if it exists in preference to AP System Parameters value
Upgraded Flexfield support to 15 segments
Version 6.1.22 (29-May-2008)
Client specific customization added
Version 6.1.21 (9-May-2008)
Customisation added for a customer for impossible DFF segment configuration
Version 6.1.20 (29-Apr-2008)
Added support for "Receipt Line" column
Minor change to procedure handling apostrophes and non-ascii characters
Version 6.1.19 (28-Apr-2008)
Support 'Field' type segment defaults
Stop DFF form from writing default Context to cell if not Displayed
Version 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
Version 6.1.17 (16-Apr-2008)
Allow override of Project Accounting according to profile option PA: Allow Override of PA Distributions in AP/PO
Version 6.1.16 (11-Apr-2008)
When validating/uploading, DFF module was writing default/reference Contexts to s/s even if invalid
Version 6.1.15 (11-Apr-2008)
Handle form fields in DFF Reference column
Added Defaulting for Invoice Tax Type
Version 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
Version 6.1.13 (10-Apr-2008)
Added Receipt Number column. Basic validation only
Version 6.1.12 (7-Apr-2008)
Changes to both features added in 6.1.11
Version 6.1.11 (25-Mar-2008)
Client specific validation added to Account Codes
Added 'Income tax Type' column
Version 6.1.10 (20-Ma r-2008)
Flexfield form was not displaying message if multiple segment values returned in search
Version 6.1.09 (18-Ma r-2008)
Allow user to duplicate values in Supplier, Site, Invoice Number, and Total columns without starting a new invoice
Version 6.1.08 (17-M ar-2008)
VBA and Oracle disagree on whether to round .005 up or down. Force VBA to agree with Oracle
Version 6.1.07 (6-Mar- 2008)
Added Expiry date to Named Users maintenance form
Version 6.1.06 (5-Mar- 200 8)
Substitution added to support form field :D_SUM_FOLDER.PO_HEADER_ID in DFF segments
Version 6.1.08 (17-Mar-2008)
VBA and Oracle disagree on whether to round .005 up or down. Force VBA to agree with Oracle
Version 6.1.07 (6-Mar-2008)
Added Expiry date to Named Users maintenance form
Version 6.1.06 (5-Mar-2008)
Substitution added to support form field :D_SUM_FOLDER.PO_HEADER_ID in DFF segments
Version 6.1.05 (26-Feb-2008)
Discountable Amount column was causing an upload error if removed
Version 6.1.04 (14-Feb-2008)
Form fix - Typing into Date field resulted in a VBA error on date conversion
Version 6.1.03 (11-Feb-2008)
DFF module and form upgraded ready for User Definable Attributes
Version 6.1.02 (1-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
Version 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)
Version 6.0.15 (22-Jan-2008)
Client customisation added to change Batch Name
Added Charge Account to P.O. Distributions LOV
Version 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
Version 6.0.13 (8-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
Version 6.0.12 (13-Dec-2007)
New profile option "More4Apps: PIW Suppress Total Check" allows you to control the total checking against the distributions
Version 6.0.11 (6-Dec-2007)
Removed dummy values from form LOVS as the SQL does not work on some databases
Version 6.0.10 (19-Nov-2007)
DFF form was showing messages about missing columns even if the column was not set to displayed
Version 6.0.9 (9-Nov-2007)
Refresh was not working for Invoice Numbers containing the Apostrophe character
Fix for date formatting problem in forms writing values to spreadsheet
Version 6.0.8 (31-Oct-2007)
New parameter added to Process Block to allow alternative XML feedback returned to spreadsheet
Version 6.0.7 (20-Oct-2007)
Mod to Refresh function to stop it clearing Rejected Status for Distributions not uploaded
Version 6.0.6 (9-Oct-2007)
Mod to Refresh function to stop it clearing Rejected message for Distributions not uploaded
Version 6.0.5 (2-Oct-2007)
Changes to stop toolbars from locking up
Version 6.0.4 (2-Oct-2007)
Added support for 11th segment to Flexfield form
Version 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
Version 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
Version 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
Version 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
Version 5.1.9 (2-Aug-2007)
Handle brackets surrounding SQL based defaults in Key and Descriptive Flexfields
Right Trim spaces from Text DFF segments on upload
Version 5.1.8 (1-Aug-2007)
Stop forms from converting date from spreadsheet into DD-Mon-YYYY format
Version 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
Version 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
Version 5.1.5 (18-Jul-2007)
Enforce 150 character maximum on DFF segments with no value set
Connection upgraded ready for R12
Version 5.1.4 (9-Jul-2007)
Inverted loaded currency exchange rate to be consistent with Invoice form
Version 5.1.3 (8-Jul-2007)
Refresh changed to stop it marking Rejected Duplicated Invoices as Processed
Version 5.1.2 (6-Jul-2007)
Flexfield form was not enabling Ok button in certain circumstances
Flexfield form was not indicating when search required once criteria entered
Version 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
Version 5.1.0 (22-Jun-2007)
URL attachments now supported. Requires M4APS_XML package body version 3.0.11
Version 5.0.8 (19-Jun-2007)
DFF form fields are now disabled where columns are not available on the spreadsheet
Version 5.0.7 (18-Jun-2007)
Attachment Category LOV not populated for German customer - Language issue in LOV SQL
Minor mods to DFF form
Version 5.0.6 (13-Jun-2007)
Upgraded DFF and Flex modules. Bug fix for Standard Date type DFF segments
Version 5.0.5 (12-Jun-2007)
Added parameter to Import submission to override default number of Print copies
Version 5.0.4 (11-Jun-2007)
Apply licence key control to Validate function
Version 5.0.3 (8-Jun-2007)
Program was ignoring user override for Expenditure Types
Version 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
Version 5.0.1 (9-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
Version 5.0.0 (8-May-2007)
Added support for Single Signon
Version 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
Version 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
Version 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
Version 3.1.01 (29-Mar-2007)
Performance enhancements added to upload validation
Version 3.1.00 (19-Mar-2007)
Fix for timeout problem caused by Internet Explorer 7
Version 3.0.10 (6-Mar-2007)
Fix bug in Supplier Name and Number search
Added Document Category to override tables
Version 3.0.09 (26-Feb-2007)
Further enhancements for Standard Date and Standard DateTime type value sets in Descriptive Flexfields
Version 3.0.08 (23-Feb-2007)
Address NLS problem in Flexfield value sets with TO_DATE() on Date values
Version 3.0.07 (20-Feb-2007)
Security Rules only apply where value set has "Security Enabled Flag" set to Yes
Version 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
Version 3.0.05 (7-Feb-2007)
Handle very large Supplier Site LOV with search function. Enabled for over 5000 Sites
Client specific customisation added
Version 3.0.04 (3-Feb-2007)
Overrides for Payment Methods, Pay Groups, and Tax Codes LOVs
Version 3.0.03 (30-Jan-2007)
Tolerate missing port number in login URL (for 8000 default)
Better error handling for invalid URL setup
Version 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
Version 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
Version 2.2.30 (18-Jan-2007)
Client specific customisation added
Version 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
Version 2.2.28 (16-Jan-2007)
Was not loading IDs for DFFs. Fix for Date type DFF segments
Version 2.2.27 (12-Jan-2007)
Batch Name changed to include year
Version 2.2.26 (9-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
Version 2.2.25 (3-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
Version 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
Version 2.2.23 (19-Dec-2006)
DFF module enhanced to handle multiple dependencies
Version 2.2.22 (12-Dec-2006)
Added Dist AWT Group column
Added check for AWT Group Flag on Supplier Site
Version 2.2.21 (11-Dec-2006)
Enhancement to Flexfied module to better handle very large value sets
Version 2.2.20 (8-Dec-2006)
Added AWT Group column
Version 2.2.19 (30-Nov-2006)
Added support for Liability Account
Two fixes to DFF form for 'Special' value sets
Version 2.2.18 (21-Nov-2006)
Terms Date column is not available in 11.5.5
Version 2.2.17 (20-Nov-2006)
Add support for DFF Context Reference based on Profile options
Add support for "Special" Value Sets
Version 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
Version 2.2.15 (17-Nov-2006)
DFF form was trying to get default values before parent segments determined, causing SQL errors
Version 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
Version 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
Version 2.2.12 (13-Nov-2006)
Cope with space left in Invoice Total column
Version 2.2.11 (10-Nov-2006)
Handle Supplier Site ID form field reference in DFF segments
Apply single quotes around Profile Option substitutions
Version 2.2.10 (8-Nov-2006)
Further fix for case where no Tax Codes are defined
Handle Supplier Name form field reference in DFF segments
Version 2.2.09 (7-Nov-2006)
Handler added for errors caused by apostrophe character in filename
Version 2.2.08 (1-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
Version 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
Version 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
Version 2.2.05 (19-Oct-2006)
Supplier Name was being validated even if Supplier Number was supplied
Version 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
Version 2.2.03 (14-Oct-2006)
Refresh function was incorrectly attempting to load Attachments when Invoice Pending
Version 2.2.02 (10-Oct-2006)
Add distribution level Global Attributes
Version 2.2.01 (03-Oct-2006)
Removed unnecessary post login PA patch level checks
Version 2.2.00 (28-Sep-2006)
Add validation to prevent upload of duplicate Invoice Numbers. Requires package body version 1.2.0
Version 2.1.30 (21-Sep-2006)
Stop forms from overwriting spreadsheet cell values when there is no change
Version 2.1.29 (15-Sep-2006)
Upload process was displaying the wrong form if the user elected to respond to Invoice Date warning
Version 2.1.28 (14-Sep-2006)
Added global attribute columns
Version 2.1.27 (13-Sep-2006)
Tolerate using either 'Date Received' or 'Invoice Received Date' column headings
Version 2.1.26 (12-Sep-2006)
Distributions form was incorrectly setting the tax code to the first one when no default existed
Version 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
Version 2.1.24 (30-Aug-2006)
New column added, "Goods Received Date". Renamed "Date Received" column to "Invoice Received Date"
Version 2.1.23 (18-Aug-2006)
Search button added for Aliases instead of caching all Aliases at startup
Version 2.1.22 (16-Aug-2006)
Attachment Categories LOV changed to multi-language view
Version 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
Version 2.1.20 (21-Jul-2006)
Changed layout of Batches form
Calender form changed to fix backspace bug
Version 2.1.19 (20-Jul-2006)
Fix to Replace97 procedure for Excel 97 users
Version 2.1.18 (7-Jul-2006)
New Tax code validation was not preventing the upload if the Tax code is invalid
Version 2.1.17 (5-Jul-2006)
Tax code active dates now compared with Invoice Date, not System date
Version 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
Version 2.1.15 (26-Jun-2006)
Warnings added for future invoice dates and invoice dates greater than a year old
Version 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
Version 2.1.13 (14-Jun-2006)
Fix for bug in Invoice Header form when querying Supplier Number and no Supplier Name column exists
Version 2.1.12 (13-Jun-2006)
Account validation error messages were not being written to the Line Error column
Version 2.1.11 (9-Jun-2006)
Change to Tax tolerance code was not working on 11.5.9
Version 2.1.10 (7-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
Version 2.1.09 (23-May-2006)
Fix to SQL based default Flexfield segment processing
Extend character conversion for 11.5.10CU2 Apache security
Version 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
Version 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
Version 2.1.06 (6-Apr-2006)
Login enhanced to allow non alphanumeric and space characters in password
Version 2.1.05 (28-Mar-2006)
Fix for Distribution total calculation where Tax: Allow Override of Tax Code set to 'No'
Version 2.1.04 (21-Mar-2006)
Refresh function was not clearing Tax Line ID
Version 2.1.03 (20-Mar-2006)
Calc function not working on form for Line Tax Code level tax calculations
Version 2.1.02 (1-Mar-2006)
Fix to intermittant failure in Attachment upload
Calendar positioned for Excel 97
Version 2.1.01 (21-Feb-2006)
DFF module was not turning default user values into IDs when user leaves value blank
Version 2.1.00 (17-Feb-2006)
Attachments operating for 11.5.10
MS-Office Calendar replaced with VBA calendar
Version 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
Version 2.0.68 (19-Jan-2006)
Loop added to counter intermittant failure to show toolbars on startup
Version 2.0.67 (23-Dec-2005)
Requester column added
Version 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
Version 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
Version 2.0.64 (11-Nov-2005)
9th Key Flexfield segment was not working
Stop login loop if M4APS_XML package not installed
Version 2.0.63 (04-Nov-2005)
Batches form was not limiting the LOV to the selected user
Version 2.0.62 (31-Oct-2005)
PO Header ID was not clearing after each Distribution for subsequent PO related Distributions
Version 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
Version 2.0.60 (18-Oct-2005)
Correct overflow error in PO validation caused by using Integer instead of Long variable types
Version 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
Version 2.0.58 (29-Sep-2005)
Fix for calculated Invoice total not resetting if user chooses to reload form
Version 2.0.57 (27-Sep-2005)
Added Search button to Named User Licence form
New Voucher Number column added
Version 2.0.56 (12-Sep-2005)
Switched XML object from Fixed Reference to Late Binding
Cosmetic forms fixes
Version 2.0.55 (29-Aug-2005)
Invoice number validation was incorrectly set to 150 characters instead of 50
Version 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
Version 2.0.53 (27-Jul-2005)
Stop repeated DFF configuration caching when no columns defined
Version 2.0.52 (26-Jul-2005)
Added 'List My Batches Only" checkbox to Batches form
Version 2.0.51 (25-Jul-2005)
Added Optional Validation Status column so Refresh can show this information
Version 2.0.50 (20-Jul-2005)
Exclude inactive Suppliers and Supplier Sites
Version 2.0.49 (6-Jul-2005)
Fix for MLS code change affecting procedure calls including apostrophe characters
Version 2.0.48 (22-Jun-05)
Remove Digital Certificate
Support new login validation method
Fix DFF Reference field issue
Version 2.0.47 (14-Jun-05)
Bug fix in DFF module
Switched to MLS lookup tables
Version 2.0.46 (06-Jun-05)
Support Unicode usernames and passwords. Requires XML package body 2.0.46
Version 2.0.45 (03-Jun-05)
Fix for Ascii characters mixed with Unicode values
Conversion to MLS tables
Version 2.0.44 (30-May-05)
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
Version 2.0.43 (9-May-05)
DFF module bug fix for Independant value sets
Version 2.0.42 (2-May-05)
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
Version 2.0.41 (27-Apr-05)
Fix for incorrect 'No Accounting' message for PO matched Distributions
Version 2.0.40 (18-Apr-05)
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
Version 2.0.39 (13-Mar-05)
Remove 'No Accounting' message for Prorate Distributions
Release Notes link added to About form
Version 2.0.38 (13-Mar-05)
Changes to DFF module
Version 2.0.37 (30-Mar-05)
Errors in DFFs were not stopping upload
Support for optional column "Terms Date" added
Fix for Digital signature being removed
Version 2.0.36 (14-Mar-05)
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
Version 2.0.35 (03-Mar-05)
Fix for European decimal character not being handled properly
Version 2.0.34 (22-Feb-05)
Remove Function to Check for non-Ascii characters
Version 2.0.33 (22-Feb-05)
Improve DFF module performance
Version 2.0.32 (16-Feb-05)
Support for Named User Licence model added
Descriptive Flexfields module added
Version 2.0.31 (14-Feb-05)
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
Version 2.0.30 (20-Jan-05)
Added default Expenditure Organisation for Project Related Invoice Distributions
Version 2.0.29 (10-Jan-05)
Bug fix - "Accounting is not completed" message was overrriding a validation error message
Version 2.0.28 (22-Dec-04)
Bug fix - was not allowing for Inactive date on Supplier Site
Performance enhancement for SQL processing
Version 2.0.27 (06-Dec-04)
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
Version 2.0.26 (29-Nov-04)
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
Version 2.0.25 (24-Nov-04)
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
Version 2.0.24 (21-Nov-04)
Removed incorrect rule stopping revenue accounts from being charged to
Version 2.0.23 (01-Nov-04)
Support scenario for Calculation Level set to Line/Tax Code and non tax-inclusive distribution amounts loaded
Version 2.0.22 (29-Oct-04)
Fix for Rounding problem with negative Distribution Amounts
Version 2.0.21 (22-Oct-04)
Minor fix to Batches form - Submit button was disabled
Version 2.0.20 (06-Oct-04)
Cached Account codes so only validated once - Considerable speed improvement
Version 2.0.19 (29-Sep-04)
Support for aliases and SQL segment derived default codes added
New option to select alternative Batch Sources
Version 2.0.18 (20-Sep-04)
Efficiency improvements
Version 2.0.17 (12-Sep-04)
Removed references to VBProject collection code. Improvement to double-click technique
Version 2.0.16 (10-Sep-04)
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
Version 2.0.15 (09-Sep-04)
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
Version 2.0.14 (07-Sep-04)
Fix for bug loading wrong Invoice ID against Invoice Line after block processed
Version 2.0.13 (01-Sep-04)
Error handling improved for invalid formula in Distribution Amount
Simplified checking for Processed Invoices status
Version 2.0.12 (29-Aug-04)
Major speed improvement through caching entire upload process
Fix for issue with CCID validation
Can now use any responsibility provided AP functions included
Version 2.0.11 (13-Aug-04)
Added caching to increase upload performance
Version 2.0.10 (31-Jul-04)
Add Function to Check for non-Ascii characters
Check for duplicated column headings added
Version 2.0.09 (05-Aug-04)
Applying currency precision to all Invoice and Distribution amounts
Version 2.0.08 (14-Jul-04)
Fix for fault in auto calc procedure
Added support for secure socket connection
Version 2.0.07 (07-Jul-04)
Fix for fault in error message in Invoice ID invalid
Added import/export config settings feature
Version 2.0.06 (22-Jun-04)
Change fixed array to dynamic for user responsibilities
Version 2.0.05 (18-Jun-04)
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
Version 2.0.04 (14-Jun-04)
Check invoice total against total distributions amount and add optional auto invoice total calculation feature
Version 2.0.03 (04-Jun-04)
Fix for Invoice header form error if Document Category column removed
Version 2.0.02 (03-Jun-04)
Login script change to allow for port numbers larger than integer size limit
Version 2.0.01 (30-Apr-04)
Only enabled currency codes selected
Minor change to cope with possibility of apostrophe in sheet name
Version 2.0.00 (13-Apr-04)
Change from ADO to XML HTTP data access method
Version 1.2.06 (26-Apr-04)
Backported to R11.0.3
Version 1.2.05 (24-Mar-04)
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
Version 1.2.04 (02-Mar-04)
Bug fix - Program stopped immediately if Supplier Invalid
Bug fix - 2nd query of Project Numbers returned error
Version 1.2.03 (24-Feb-04)
Added ability to select a range of Invoices to upload
Version 1.2.02 (23-Feb-04)
Improved error handling for Project related columns
Form was not clearing fields on sheet if Project Number cleared
Version 1.2.01 (20-Feb-04)
New button on Setup toolbar allows show/hide of Template sheet
Added public code to enable double-click in external workbooks
Version 1.1.09 (27-Jan-04)
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
Version 1.1.08 (17-Jan-04)
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
Version 1.1.07 (14-Jan-04)
Fix for Round() function which does not work in Excel 97
Changed "Item Date" label to "Invoice Date" on Invoice form
Version 1.1.06 (28-Dec-03)
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
Version 1.1.05 (11-Dec-03)
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
Version 1.1.04 (03-Dec-03)
Permission to Import or Load was not working first time
Version 1.1.03 (18-Nov-03)
Enhance About form and password expiry feature
Allowed numeric characters at beginning of database password
Version 1.1.02 (07-Nov-03)
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
Version 1.1.01 (12-Oct-03)
Added "Date Received" column
Improved colour handling for Status columns
Version 1.0.09 (30-Sep-03)
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
Version 1.0.08 (22-Sep-03)
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
Version 1.0.07 (08-Sep-03)
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
Version 1.0.06 (05-Sep-03)
Added "Invoice Batch" parameter to Submit Import process
Version 1.0.05 (04-Sep-03)
Terms ID was not correct. Was retrieving the form LOV's sort key instead of the ID value
Version 1.0.04
First release. Built on R11i 11.5.8 and 11.5.9
