Changes made for better date handling
Sales Rep defaulting added
GL Date defaulting on upload as per the form
Upgraded for Oracle Release 12
Fixed bug in substitutions where dff would cause the key flex substitutions to crash
Fixed bug in lines form where the download button loaded all the credit lines into the first line, hence only the last line was downloaded
Version 4.0.22 (21-Feb-08)
Added customization for customer
Version 4.0.21 (19-Feb-08)
Fixed bug in credit memo. When an invoice to credit was chosen sometimes tax lines were being loaded into the reference_line_id column in the interface table rather than lines
Added Line Type sort order into the lines download
Stopped Distributions and Sales Credits being re-uploaded. They were ignoring the pending status in the 'Line OK' column.
Fixed bug where spaces in the Invoice Number cell were causing the upload to think that it was at the start of a new invoice.
Version 4.0.19 (01-Feb-08)
Removed restriction on GL Date imposed by choosing an invoice rule.
Version 4.0.18 (25-Jan-08)
Removed select null a, union all/union from lovs because this sql dies on some systems.
Changed the corresponding comboboxes to combo boxes rather than drop down lists if they were not already comboboxes.
Version 4.0.17 (24-Jan-08)
Commented out join on context in the query that brings back the invoice number when you refresh. This is only relevant to AutoNumbering batch sources.
Stopped Ship To Location query from running twice - it was running once for each control on the form.
Changed Ship To location to a long list of values.
Version 4.0.16 (18-Jan-08)
Commented out join on ct_refrence and trx_date in the query that brings back the invoice number when you refresh. This is only relevant to AutoNumbering batch sources.
Fixed bug on header form where accounting rules control stayed disabled if the form was opened on a blank line in the spreadsheet.
Fixed bug where the ship_to location wasn't being defaulted when a ship_to location was provided but the Ship_to column was not on the spreadsheet.
Version 4.0.15 (11-Jan-08)
Added Substitution: Substitutions = ReplaceCase(Substitutions, ":TCMI_CRTRX.CUSTOMER_TRX_ID", "NULL")
Version 4.0.14 (09-Jan-08)
Sales Order Date column added.
Fixed bug in Accounting Rule start date in lines form.
Accidentally removed from the Bill Location change event on 04/01/08 - FormatTerms False.
Fixed bug where the interface dff was not including the global data elements.
Version 4.0.13 (04-Jan-08)
Removed gl_code_combinations_kfv from the distributions download because it was bringing back the wrong delimiter in oracle apps version 11.5.8.
Fixed bug where Bill Contact was disabled when starting on a blank record.
Version 4.0.12 (17-Dec-07)
Changed downloader so ra_customer_trx_partial_v isnt used when not necessary - done for speed reasons.
Version 4.0.11 (14-Dec-07)
LOV for Bill-To Contact changed.Now defaulting Bill-To Location in the upload if it is blank - to the primary location.Now defaulting Account Class in the upload if it is blank - to "REV".
Cosmetic fix to Sales Credits form.
Version 4.0.10 (03-Dec-07)
Custom Concurrent programs now supported using optional "CustomCP" sheet.
Version 4.0.9 (28-Nov-07)
LOV for CreditInvoice changed to filter closed invoices.
Version 4.0.8 (12-Nov-07)
DFF fix for Invalid Context values ignored in upload.Fix for date formatting problem in forms writing values to spreadsheet.
Version 4.0.7 (09-Nov-07)
Removed defaulting of Ship_to customer when Ship_to location is blank.
Version 4.0.6 (06-Nov-07)
Allow for Default Terms being set at Customer rather than Site level.
Version 4.0.5 (06-Nov-07)
Updated DFF module to tolerate optional column in DFF Context Reference.Header form - fixed defaulting of BillTo and ShipTo Locations. Incorrect BillTo defaulting was causing the Terms defaulting to fail.
Version 4.0.4 (31-Oct-07)
Payment Terms list of values now dependent on address override value.
Transaction Type and Terms on header form now colouring properly when exact match searched on.
Profile Class and Tax registration added to the Bill to Customer LOV.
Version 4.0.3 (29-Oct-07)
Function security check to Invoice Upload and Import Batch Submit.
Version 4.0.2 (25-Oct-07)
Form block substitution added for :TGW_HEADER.CTT_TYPE_NAME_MIR
Handle case if AR_DEFAULT_EXCHANGE_RATE_TYPE Profile Option is set to an Invalid Exchange Rate Type.
Fix to SQL used in search for Invoice Lines to credit.Use Master Org ID parameter in Item search in form.
Version 4.0.1 (24-Oct-07)
Fixed bug where removing GL date column stopped Transaction Date from being loaded.
Version 4.0.0 (19-Oct-07)
Mods for new R12 connection.
Version 3.3.53 (16-Oct-07)
Allow blank to be loaded into Includes_Tax_Flag.
Fix problem uploading Sales Credits.
Fix for negative numerics in DFF segments being rejected.
Version 3.3.52 (24-Sep-07)
Protect upload from running midway within a Line.
Version 3.3.51 (27-Aug-07)
Single delete and Single invoice upload upgraded to selection delete and selection upload.
Cell colouring during validation fixed
When Caching VAT Tax null values of amount_includes_tax_override set to 'N'. This the 'multi' tax cases.
Version 3.3.50 (25-Jul-2007)
DFF fix for Profile options embedded in Value Set SQL
Connection upgraded ready for R12
VBA Protection added. Can now use Excel Protection from Excel menu - Tools / Protection
Version 3.3.49 (24-Jul-2007)
Enforce 30 character maximum on Interface DFF segments with no value set
DFF form fix required where segment is Enabled but not Displayed
Version 3.3.48 (17-Jul-2007)
Fix to Warehouse ID for Freight Carriers
Enforce 150 character maximum on DFF segments with no value set
Stop caching of Terms after login now this is a search column
Version 3.3.47 (13-Jul-2007)
Cosmetic changes to Lines form
Licence key model changed to allow 10 Lines, not 10 Distributions
New package body version number is 1.1.2
Download - include tax flag added decode statement so the value 'DEFAULT' doesnt download
Refresh changed to handle the case of non-purging interface tables
ShipTo and SoldTo default to BillTo if no values are supplied
Sales Rep colouring on the header form fixed
Changes in BillTo Customer to update the soldto and shipto customer to the bill to customer when empty
Fixed bug where Transaction Type and Terms were trying to upload when invalid
Fixed colouring on Description txt box of Lines form.
Version 3.3.46 (10-Jul-2007)
Handle reserved Line Transaction Flexfields being made mandatory
Improvements to Bill-To, Ship-To, Sold-To customer LOVs in Header form
Set Warehouse ID to Master Inventory Org when Freight Carrier used
Version 3.3.45 (2-Jul-2007)
New Carriers LOV added
Added new Org subquery to Item LOV in Lines form
Cosmetic fixes to Invoice Header form frames and label justification
Fixed Long List searches so a wildcard is not used on the search when the form is opened. Also added this to the customer search
Sales Rep Number added to Header and Sales Credits
Search functionality added to Sales Rep, Terms and Transaction Types
Percent removed from template sheet
Sample sheet - new sample invoices added
GL Date defaulting re-fixed
Version 3.3.43 (20-Jun-2007)
Changes to downloader. Credit Reason Code was being downloaded changed to meaning
Stopped downloader from erroring when header had no associated lines
Ship to customer was being downloaded into SoldTo column
Shipto and Soldto customers were not defaulting to Billto customer values when the columns were displayed on the spreadsheet but no values were supplied
Version 3.3.42 (19-Jun-2007)
DFF form fields are disabled where columns are not available on the spreadsheet
Minor enhancements to DFF and KFF functionality
Version 3.3.41 (18-Jun-2007)
Carrier and Ship Date rules added
Shipto and Sold to Address OSR columns added.
These columns will update the ship/sold customer and location if no ship/sold customer info is supplied.
These columns are not in the template sheet. Only customers who specifically request this feature will be informed about these columns
Version 3.3.40 (13-Jun-2007)
New DFF module and form imported from project wizard
Carrier and Ship Date added - not using correct Oracle Rules yet
Version 3.2.39 (6-Jun-2007)
Columns added: Ship To and Sold To Cust Name/Number
Version 3.2.38 (28-May-2007)
DFF errors were not being displayed in the rejection reason column
Version 3.2.37 (23-May-2007)
Fixed bug - Selection of Credit Invoices was using a view that was missing the required join columns
Fixed bug - for downloading credit invoice lines. Customer number was joining on customer id
Stopped GL Date from defaulting to December 1899 when no default date was found
Version 3.2.36 (3-May-2007)
Fixed bug - using customer number to match to customerid for finding Invoices to Credit
Key Flexfield and Descriptive Flexfield modules upgraded. Now long lists to search in LOVs
Version 3.2.35 (27-Apr-2007)
New Downloader feature added
Transaction Code column added
Shipping Ref, FOB and Sales Order Number columns added
Minor Currency Code behavior changes
Version 3.2.34 (3-Apr-2007)
Fixed UOM defaulting in lines from when a memo is chosen
Fixed GL Date formatting for database queries in the header form
Further date formatting fixes in the header form
Version 3.2.33 (29-Mar-2007)
10g database was not being detected properly for non-ASCII character handling
Receipt Method column added
Fixed bug in client specific customisation where Customer ID column was being extracted to the customer_number column
Fix for timeout problem caused by Internet Explorer 7
Added columns Interface_line_attributes 3-15. Fixed GDF column upload
Fix to date formatting for Date columns in forms
Added minor SQL performance improvements to Location validation
Version 3.2.32 (19-Dec-2006)
Bill Contact SQL was being passed the customer number rather than customer id
Updated some of the comments to reflect the change
Fixed bug where XML error occurred on refresh if request id was blank
Version 3.2.31 (14-Dec-2006)
Form fixes to stop Excel from truncating leading zeros on strings that are also numbers
Order Management settings table changed for 11.5.10
Version 3.2.30 (13-Dec-2006)
Defaulted Item Inventory Org to Order Management parameters setting
Version 3.2.29 (10-Nov-2006)
Removed Org ID as a parameter into the Item search
Version 3.2.28 (17-Nov-2006)
GL Date validation was not functioning
Version 3.2.27 (15-Nov-2006)
Bug fix for Locations introduced in 3.2.24
Forms background changed
Version 3.2.26 (10-Nov-2006)
Workaround added for Oracle AutoInvoice Bug affecting REC Distributions
Fix for Refresh function not displaying Import errors
Re-enable URL Setup if login fails
Fix to Overrides function
Fixed bug where lines form did not handle an invalid tax code in the spreadsheet
Version 3.2.25 (08-Nov-2006)
Added Customer Name column. Removed the customer selection form
Added Customer Number Customer Name selection to Header form
Fixed bug - customer_ship_to_ref not being populated if header form was loaded
Item unit price defaulting added
Tab order on header form fixed
Overrides form message removed (was only relevant for odbc)
Missing column error fixed for quantity
Customer name/number change has killed PO selection on header form and killed credit download in lines form
All issues with Customer name/number fixed
Validation for Auto Invoice numbering added
Defaulting for Item tax code added
Inventory Org ID defaulting added
Concurrent request - request id is now shown on sheet
Tax code override flag defaulting
Handler added for errors caused by apostrophe character in filename
Profile option installation moved to VBA
Version 3.2.24 (20-Sep-2006)
Added search functionality for aliases to replace post-login caching
Added Rule Duration column
Controls re-ordered on lines form. Item place above memo
New tab added to header form.
Bugs for comments and special instructions controls on header form fixed
Requirement for search criteria in contact search removed on header form
Upload bugs fixed for invoicing rule, accounting rule and rule start date if the columns were missing the logic didnt work correctly
Further fixes for accounting rule columns
'Bill to RefID' and 'Ship to RefID' columns changed to 'Bill to Location' and 'Ship to Location'
Further 'Bill to address' and 'Ship to address' on header form changed to 'Bill location and 'Ship location'
GL Date defaulting changed on the header form
Version 3.2.23 (02-Aug-2006)
Organisation selection for Items was based incorrectly on Inventory Orgs. Change to LOV
Flex form was not loading properly for missing or empty value sets
Table based validation added for Key Flex fields
Fix to ADHB RefreshStatus customisation
Some fixes to stop VBA errors when doing precision checks
New column credit memo reason added
Fix to UOM not being populated when an item is selected - Lines form
Version 3.2.22 (03-Aug-2006)
Calender form changed to fix backspace bug
Payment Terms now defaults from Customer Bill-To Address Profile Class
Added another segment to the Accounting Key Flexfield module - now supports 10 segments
Minor improvements to Header form for Customer and Address search
Fix to Replace97 procedure
Fix for upload not erroring line if UOM invalid
Fix to colour coding inconsistencies in Lines section
P.O. Number and Credit Invoice columns added
P.O. Date added to header
Currency precision rounding added
Version 3.2.21 (28-Jun-2006)
Client specific customisation added for Invoice and Line Transaction Flexfields
Some minor fixes to colour coding on forms for mandatory/optional fields
Version 3.2.20 (03-Jul-2006)
Line level DFFs were being copied from the first line to all other lines for that Invoice
Version 3.2.19 (19-Aug-2006)
Refresh was not retrieving Invoice number for Automatically Numbered Invoices
Validation added to Lines form to ensure the Description column does not exceed 240 characters
Version 3.2.18 (31-May-2006)
Customer ID column removed. Always use Customer Number in Layout
Was not trapping missing 'Description' value error condition
Added new special character conversions for Apache in 11.5.10CU2
Enhancement to Login form to capture invalid Host in LOV
Support for selecting Inventory Organisation for Lines including Items
Improve color coding in forms to hightlight mandatory fields
Cosmetic enhancements to Distributions form to make consistent with other products
Version 3.2.17 (22-May-2006)
Fix to SQL based default Flexfield segment processing
Version 3.2.16 (13-Apr-2006)
Item Key Flexfield issue with combinations fixed
Debug facility added for database calls
Version 3.2.15 (12-Apr-2006)
GDF and Warehouse ID columns added
Version 3.2.14 (7-Apr-2006)
Login enhanced to allow non alphanumeric characters in password
Version 3.2.13 (31-Mar-2006)
Item column was stopping the upload if deleted. Fix to Item validation in Lines form
Version 3.2.12 (15-Mar-2006)
Calendar positioned for Excel 97
Version 3.2.11 (27-Feb-2006)
MS-Office Calendar replaced with VBA calendar
Allow negative invoice totals for all Transaction Types except for Credit Memos
Version 3.2.09 (23-Dec-2005)
Added support for Inventory Item
Improve colour coding in validated values
Remove assumption re linking of Segments to Display order in key Flexfields
Regardless of Batch Source Setup, use consistent appearance for Term, Txn Type, Memo, Sales Rep, Sales Credit Type
Version 3.2.08 (13-Dec-2005)
Handle missing calendar control on the PC with a user message
Prevent login procedure from looping if no M4APS_XML package installed
Version 3.2.07 (14-Nov-2005)
Fix for no Line ID uploaded in certain circumstances
Version 3.2.06 (31-Oct-2005)
Comments column was incorrectly set to Mandatory
Version 3.2.05 (25-Oct-2005)
Moved caching code for Descriptive flexfields to post login operations
Added support for Invoice header level "Comments" column
Suppress DFF buttons on toolbar when DFFs not configured
Version 3.2.04 (4-Oct-2005)
Further fix to Upload SQL for Lines
Refresh function was not retrieving new Invoice Number when Auto Numbering turned on
Version 3.2.03 (28-Sep-2005)
Added search button to Named User licence form
Use "Journals: Display Inverse Rate" profile option to control exchange rate display
Version 3.2.02 (16-Sep-2005)
Correct behavior of Batch Source dropdown
Fix to Upload SQL for Lines
Version 3.2.01 (31-Aug-2005)
Memo Line values were not being loaded where Batch Source option set to "Value"
Improvements to Lines form for Memo line functionality
Was not loading Tax Codes on LINE records if the Includes Tax was not set to "Yes"
Version 3.2.00 (15-Aug-2005)
Switched XML object from Fixed Reference to Late Binding
Fix for loop problem in upload if no Distributions on sheet
Cosmetic changes to statuses on Upload, Delete, Refresh
Form was disabling Tax Code field incorrectly
Version 3.1.27 (12-Aug-2005)
Fix for certain DFF Value sets containing $Profiles$: and IN statements
Version 3.1.26 (1-Aug-2005)
Excluded end-dated Transaction types
Version 3.1.25 (30-Jul-2005)
Stop repeated DFF configuration caching when no columns defined
Expired users removed from Named User form
Fix for GL Date check not handling non-English dates
Version 3.1.24 (22-Jul-2005)
Named user form was not handling more than 32767 users in the LOV
Corrected calendar forms not defaulting to today's date
Corrected duplicate customers on search form
Version 3.1.23 (13-Jul-2005)
Fix formatting of Amount and Price columns in forms and upload process
Add default Exchange Rate Type based on Profile option 'AR: Default Exchange Rate Type'
Version 3.1.22 (6-Jul-2005)
Fix for MLS code change affecting procedure calls including apostrophe characters
Version 3.1.21 (28-Jun-2005)
Add Currency and fix ORA-00936 error during upload if trial version line > 10
Fix for fault in DFF form message
Remove Digital Certificate
Support new login validation method
Version 3.1.20 (26-Jun-2005)
Fix DFF reference field issue
Version 3.1.19 (14-Jun-2005)
Fix to DFF module
Version 3.1.18 (6-Jun-2005)
Support for all languages added. Convert to NLS views
Version 3.1.17 (31-May-2005)
Set Term Name/ID to Null for Credit Notes ie Total Amt <>
Version 3.1.16 (27-May-2005)
Bug Fix: Invalid subscript value used in A_CacheIdData array
Version 3.1.15 (9-May-2005)
DFF module bug fix for Independant value sets
Version 3.1.14 (3-May-2005)
Add Prepare_String to DFF mod, Fix to Load_flexfield_to_array
Stop loading ID for Independant List in Array
Version 3.1.13 (19-Apr-2005)
Support Profile Option in DFF Context Reference field
Version 3.1.12 (13-Apr-2005)
Performance enhancements to DFF module. ID columns supported
Added Release Notes link to About form
Fix for Digital Certificate being removed
Version 3.1.11 (16-Mar-2005)
Defaults were not applying for DFFs in upload process
Fix for Profile option defaults in Accounting Key Flexfield
Version 3.1.10 (04-Mar-2005)
Add Memos to lines form and upload
Fix for European decimal character not being handled properly
Allow Include Tax, Unit of Measure, Unit Selling price, and Quantity columns to be optional
Version 3.1.09 (01-Mar-2005)
Handle errors when SalesCredit columns are omitted, set BG color during upload
Fix upload counter and error handling for first invoice header row
Remove Function to Check for non-Ascii characters
Version 3.1.08 (21-Feb-2005)
Improve performance and Double_Click Proc. Change Column DFF Names
Version 3.1.07 (21-Feb-2005)
Support for Named User Licence model added
Version 3.1.06 (17-Feb-2005)
Remove Replace97 call for chr(0), Don't error when context column missing
Version 3.1.05 (09-Feb-2005)
Fix bug to align dependent array values
Version 3.1.04 (02-Feb-2005)
Remove limit to flexfield attributes
Version 3.1.03 (19-Feb-2005)
use fnd_profile.get instead of deleted m4aps_xml.get_apps_profile proc
Version 3.1.02 (26-Jan-2005)
Fix bug where non-displayed enabled fields and non-existent dff column generated error
Version 3.1.01 (24-Jan-2005)
Set current row for dff form
Version 3.1.00 (21-Jan-2005)
Add new DFF module
Version 3.0.08 (19-Oct-2004)
Create new invoice for each header even for same customer
Version 3.0.07 (14-Oct-2004)
Large performance improvement due to block upload processing
Version 3.0.06 (09-Oct-2004)
Improvements to Accounting segment handling
Support for Account Aliases added
Version 3.0.05 (08-Oct-2004)
Error message handling for failed upload improved
Version 3.0.04 (28-Sep-2004)
Rewrite upload & delete logic using Interface ID
Fix bug to capture top row inv header data when multi inv lines exists
Version 3.0.03 (22-Sep-2004)
Add Interface id column and generate auto invoice(attribute2) number if not entered in s/s
Version 3.0.02 (11-Aug-2004)
Change from ADO to XML HTTP data access method
New button on Setup toolbar allows show/hide of Template sheet
Added upload/download config settings feature
Add Function to Check for non-Ascii characters
Check for duplicated column headings added
Version 2.2.02 (23-Apr-2004)
Fixes/ enhancements to upload validation module and add Org ID parameter to concurrent process
Version 2.2.01 (12-Oct-2003)
Hardcoded setup configuration of Invoice and Transaction Flexfields to make operation simpler
Version 2.1 (24-Aug-2003)
TAX/FREIGHT line was linking to wrong line
Version 2.0
First public release. Built on R11i / AR.G