Version 4.2.00 (23-September-2011)
Removed package check from upload_invoices and upload_all_invoices to allow the wizard to run against older package versions. |
 |
Version 4.1.99 (23-September-2011)
Fixed r12 tax bug - tax column was loading into tax_code column in interface table now changed to load into tax column in interface table.
Fixed bug where include tax validation was causing an Application-defined or object-defined error when no tax code column was on the sheet.
Version 4.1.98 (14-September-2011)
r12 Tax columns implemented.
Fixed Link Line Bug - Extra attributes in the interface transaction flexfield cause lines not to be linked.
Version 4.1.97 (23-August-2011)
Fixed bug where AmountVsDistributions would error when flexfield forms were opened - This would only occur if validation for some other reason had not run before opening the dff form. NB didnt affect Header DFF.
Put DFF icons back into toolbar.
Fixed Ship Location/Address validation. If you choose cancel from an invalid location it would continue to validate the address
and pop a validation message for the address.
Transaction Source Details - fixed the following bugs: Changing sheets could cause the upload to run off the previous sheets upload, Invalid batch source could cause the upload to run off the last valid transaction source, Fixed Amount/Percent messages when running the wrong column for the transaction source, further message changes.
p_block was not being reset at the start of an upload. Meaning cancelled uploads could find their way into the database.
Version 4.1.96 (22-August-2011)
Common modules updated to 173.
Version 4.1.95 (19-August-2011)
Version not released - r12 Tax Testing.
Version 4.1.94 (12-August-2011)
Version not released - r12 Tax Testing.
Version 4.1.93 (08-July-2011)
Updated Sales Order validation.
Added validation to compare line amount to distribution amounts.
Sped up the Sales Credit Defaulting - poor performance was very noticeable when the invoice was the last one in the sheet.
Version 4.1.92 (30-June-2011)
Fixed bug for Excel 2010 when entering batch source - If you click on the blank value in the list (at top) excel error "unable to get “DropDowns” property of class “Worksheet”".
Fixed bug language dependent bug in exchange rate. Type mismatch would occur if decimal separator was not ".".
Exchange Rate Type download changed from conversion_type to user_conversion_type.
Version 4.1.91 (29-June-2011)
Removed vbCritical icon from OperatingUnitInfo Initialisation - so the message doesnt look so scary.
Version 4.1.90 (28-June-2011)
Fixed bug where extra attributes in the Transaction Line flexfield would not be populated in the sales credits interface table: if Sales Credits were required Auto Invoice would reject the import with
sales credit required error, if Sales Credits were not required the invoice would be imported without the sales credits.
Version 4.1.89 (27-June-2011)
Further work to stop erroring when Logging in as sys admin without a set of books.
Now populating Created_by and Creation_date in interface tables.
Modified validation for comments and commitments.
Version 4.1.88 (23-June-2011)
Customization added for customer
Version 4.1.87 (08-June-2011)
Fixed bug where r12 customers with inactive party flag were not being displayed in the Customer LOV.
Updated common modules to v165.
Version 4.1.86 (30-May-2011)
Now allowing responsibilities without a Set Of Books to log in to the wizard.
Fixed bug where Key Flex Field definitions were not being dumped from previous session when logging in.
Version 4.1.85 (16-May-2011)
Fixed bug for Trial Mode. The wizard would error when trial limit was reached while operating in trial mode.
Fixed SQL Bug. This bug would only occur in some EBS versions. The fix is making sure there is a space between a bind variable and a ')'.
Version 4.1.84 (3-May-2011)
Fixed bug in Profile retrieval. The wizard would error when trying to retrieve profile values.
Version 4.1.83 (29-Apr-2011)
Key Flexfield fix for 11.5.9.
Fixed bug in refresh. If the refresh didnt bring back any data this message would display 3 times: "Entity list cannot be added as Unique keys are different"
Version 4.1.82 (21-Apr-2011)
Fixed bug where request from would return no data. This would occur for a user with a leading 0 (eg 074695). The Request form would show no requests as it was querying 74695 rather than 074695. Also, the login screen would show with the 0 missing. Hence you would have to re-type username on login.
Version 4.1.81 (13-Apr-2011)
Fixed bug where logging in as sys admin was causing the "Unable to determine the GL Account Structure" message to pop and the program to stop.
Version 4.1.80 (12-Apr-2011)
Fixed major bugs in version 4.1.78. If you have version 4.1.78 please upgrade to this version.
Removed Extension Package functionality. To be re-released in the near future.
Fixed bug in invoice number validation - now testing for length 20 rather than 30.
Customer Name Search changed to be non-case sensitive for searching and ordering.
Made change to Attachments that will fix windows7 file upload problems.
Version 4.1.78 (01-Mar-2011)
Fix for program validating entire invoice when loading DFF form for lines and Distributions
New extension package added. Requires changes to AR package. This spreadsheet version requires AR Invoice Wizard package version 2.0.01 or greater
Version 4.1.77 (22-Feb-2011)
Added attachment customization for (customer site)
Version 4.1.76 (17-Feb-2011)
Made a change to Attachment Document Category query. No results were being returned for (customer site)
Version 4.1.75 (28-Jan-2011)
Fixed bug in Validating Sales Rep. Error would occur if ID was used in the Transaction Source for SalesPerson.
Version 4.1.74 (25-Jan-2011)
Fixed bug in header form. An invalid Transaction Date entry would cause a Type Mismatch error.
Fixed bug in Item Upload SQL. Fixes in 4.1.72 broke Item Upload if the Transaction Source used Value rather than ID.
Version 4.1.73 (07-Jan-2011)
Added Attachment at header level
Version 4.1.72 (15-Dec-2010)
Change made for oddity in interface tables.
In interface table SEGMENT1 column seems to run off the segment order rather than actual segment defined in oracle.eg SEGMENT1 in the interface table will take the value for oracle SEGMENT3 if SEGMENT3 is the first column defined in the flexfield.
Version 4.1.71 (02-Dec-10)
Fixed bug in Total Amount Validation introduced in 4.1.70.
Version 4.1.70 (23-Nov-10)
Fixed bug in PriceAndQuantity validation implemented in 4.1.69.
Fixed 2007 size/speed bug caused by conditional formatting in set_status
New setup sheet added - One of the links was wrong.
Fixed bug - Interface Attributes form was not popping from the toolbar
Version 4.1.69 (17-Nov-10)
Added substitution ":SYSTEM.CURRENT_FORM", "'ARXTWMAI'".
Fixed bug in submit. Incorrect date format for default date parameter was causing the Batch GL Date to be incorrect ie 18/11/210 would give a Batch GL Date of 20-NOV-0018. Correct format for submit is yyyy/mm/dd 00:00:00.
Download enhancement. Made download support different langauges.
Changed validation around tax_lines, Quantity, Unit Selling Price and Total Amount. Now checking to ensure Unit Selling Price * Quantity = Total Amount so it doesnt get failed by the interface.
Version 4.1.68 (11-Oct-10)
Supports package change for reducing sga overhead for insert statements.
Changed item query - it was excluding some valid items.
Version 4.0.67 (29-Sep-10)
Fixed bug where memo wouldnt validate if batchSource.MemoRule = "Id"
Version 4.0.66 (27-Sep-10)
Further work on defaulting and Validation of Payment Terms.
Version 4.0.65 (21-Sep-10)
Added substitution for :SYSTEM.current_form.
Corrected defaulting and validation of Payment Terms.
Fixed bugs in validation caused when the Bill Customer is invalid.
Version 4.0.64 (07-Sep-10)
Fixed bug in ValidateAccountingSegments - Would only occur when distributions section columns existed but the Accounting Segment column was missing from the sheet.
Support for Hierarchical Security added.
Version 4.0.63 (31-Aug-10)
Upgrade to DFF module.
Changed col.trimcell because it caused a sheet to run amazingly slow for a Customer. Normally this runs very fast. I couldnt find anything wrong with the customer's sheet. But it caused a 1 minute delay for each line on the sheet.
Version 4.0.62 (23-Aug-10)
Fixed bug in customer sql where party original_system_ref was being used rather than cust_acct.original_system_ref which would cause the import to fail if values were being used against the customer and the party.cust_acct.original_system_ref had a different value to the cust_acct.original_system_ref.
Version 4.0.61 (22-Jul-10)
Added Quick Download functionality for Invoice Numbers.
Fixed Item Flexfield broken in 4.0.60
Fixed DFF bug where validation would error if there were contexts but no attributes.
Re-wrote Distributions validation to allow columns to be removed from the spreadsheet without unhandled errors occurring.
Version 4.0.60 (20-Jul-10)
Modified Validating of Transaction Date and Ship Via.
Turned off Key Flexfield security for r12.
Added new setup sheet
Standardised Invoicing Rule validation.
Upgraded DFF module
Version 4.0.59 (05-Jul-10)
Changed LOV for tax code for r12. Also change in download sql for this.
Updated common modules to v128.
Version 4.0.58 (16-Jun-10)
Changed retrieving of Invoice Number for Autonumbering batch sources - have added the context back into the query as a filter. Because the wrong invoice number was sometimes being returned.
Added context filter to the delete query.
Version 4.0.57 (10-Jun-10)
Fixed download bug where a sales credit or distribution could end up in an odd place if a multiple invoice download
was running or lines needed to be inserted to print into ie - the next row had other data in it.
Version 4.0.56 (08-Jun-10)
Re-wrote item combo sql.
Version 4.0.55 (25-May-10)
Header form change. The cancel button wasnt working properly when using the form from the toolbar. This was caused by the form caching the wrong row when opened. If cancel was clicked on the form the wrong row would be copied back.
Transaction Type validation - changed to say 'A value is required' rather than value '' does not exist.
Fixed cancel bug in dff form; Using the cancel button was not reverting the row.
Version 4.0.54 (24-May-10)
Fixed bug where site level contacts were not being returned (the customer level contacts were returned).
Version 4.0.53 (22-Apr-10)
Removed hz_loc_assignments from address sql because it was causing no records to be returned on r12.
Fixed bug in Terms validation which allowed records to be uploaded when the Term was invalid.
Version 4.0.52 (16-Mar-10)
Fixed bug where upload would continue without a transaction source causing the table insert to fail
Added 'Ship To Customer' to download criteria.
Batch Number in cell A6 was being validated as allowing size of 50. Changed to validate on size of 40.
Fixed bug: if Invoice was last on the sheet the end row was determined as 500 rows more than the real end row. This caused the 'line ok' col to be updated (with values like deleted or unprocessed) for 500 rows below the end of the invoice.
Fixed bug in Ship Location/Address validation. An error would occur when a Location/Address was provided and the Ship Customer is invalid.
Fixed bug in sales rep where blank values were being searched for in the database - Speed problem rather than a functional issue.
Added bind variables where appropriate.
Added new quicker version of concurrent request viewer.
Added hidden defaulting (ie it doesnt update the spreadsheet but does default the exchange date) of exchange date from the transaction date When a currency code is provided but no exchange date is provided.
Fixed bug in header upload where GDF validation would reset the invoice to valid and hence allow uploads when they shouldnt go ahead.
Fixed upload bug caused by spaces in Interface ID column. The wizard was taking the spaces as a value and inserting records into the interface tables with the space going into the interface tables as the id value. Now trimming the cell before upload.
Renamed 'Batch Number' Cell(A5) to 'Original System Batch Name'. 'Batch Number' is wrong and it was causing confusion.Changed to not required as it is not required.
Fixed bug in gl date validation where invalidated values were allowed to upload.
Change combo box property on exchange rate so it didnt error trying to load an invalid value.
Version 4.0.51 (11-Mar-10)
Upgraded fnd modules to fix r12 context setting problem.
Fixed logout bug caused by core module update.
Fixed bug on ship_location validation which caused err 91.
Fixed Bill Address defaulting bug. Bill Address was being defaulted on the sheet but not uploaded.
Colouring on customer errors fixed for validation.
Fixed bugs in build_header, build_lines, build_sales_credits and build_distributions where invalid header records were being uploaded.
Upgraded fnd code to v118.
Fixed bug where upload selected would continue uploading when cancel was chosen.
Version 4.0.50 (02-Feb-10)
Removed warehouseID column. Added Warehouse Name column.
Fixed bug where opening lines form caused bill location and bill address to be written to the header on the same row as the line. If the line
was not on the original header row then this meant a new header row had been created.
Fixed bug in header form where locations would not display if lines form had been opened previous to opening the header form.
Version 4.0.49 (14-Jan-10)
Added customer customizations.
Downloader query change for r12.
Version 4.0.48 (2-Dec-09)
Fixed download of GL Account Description - Which was broken by upgrade of downloader in 4.0.46.
Fixed bug where Hiding Setup toolbar at startup caused it to be hidden permanently.
Version 4.0.47 (30-Nov-09)
Removed ShipTo Location and ShipTo Address controls from the main tab on the Header form - Now only on the customer tab.
Added check for missing customer or location when validating terms and Sales Reps for upload.
Version 4.0.46 (17-Nov-09)
Fixed bug where Includes Tax control in lines form was breaking the code when column was removed from sheet if Tax Code column was also removed.
Upgraded downloader to latest version.
Stopped downloading of child sections if there is no columns on the sheet.
Added Reference to download form filter.
Version 4.0.45 (13-Nov-09)
Fixed bug where the Wizard would not run against r12.
Version 4.0.44 (04-Nov-09)
Changed download to use ids rather than Transaction Numbers. This enables the download to distinguish between Transactions with duplicate Transaction Numbers.
Added GL Account Description column as a read only column.
Changed header form so on a credit transaction it didn't search for blank invoice values.
Added column comments to template sheet.
Updated Key Flexfiedl module.
Added Bill Address and Ship Address Columns.
Changed template sheet.
Changed upload all and download icons in toolbar
Added Test for Rules Method and Credit Invoice columns in the Header Upload.
Fixed bugs in loading of key flexfields into interface tables through individual segments.
Version 4.0.43 (17-Sep-09)
Fixed bug where changing the batch source caused an error when the distribution columns were removed from the wizard.
Version 4.0.42 (15-Sep-09)
Fixed 'too many commas' bug when tax rate column is removed from the wizard.
Version 4.0.41 (9-Sep-09)
Key Flexfield security updated to use Responsibility Application ID not AR Application ID.
Key Flexfield module updated to support 15 segments.
Version 4.0.40 (31-August-09)
Fixed bug in contact validation - where contact had no last name the wizard would invalidate it even if the name was valid.
Fixed divide by zero error in precision rounding.
Fixed bugs in Header and Line validation that allowed invalid data to be uploaded into the interface tables.
Changed GL Date validation to allow uploads with no GL date for 'in arrears' invoicing rule.
Made Ship To address required if a Ship To Customer is provided - otherwise oracle rejects the record.
Version 4.0.39 (19-August-09)
Fixed validation of Ship to contact - it was using the reference instead of the id.
Added ship to contact to download.
Fixed bug where Rule Duration was not being downloaded.
Fixed coloring of Accounting Rule on validation.
Changed LOV for accounting rule - it was restricting the results incorrectly.
Version 4.0.38 (14-Aug-09)
Fixed bug in downloader created in version 4.0.37.
Version 4.0.37 (13-Aug-09)
Columns added: Ship To Contact, Rules Method and Tax Rate.
Fixed Sales Credit Defaulting Bug. Sales credits were being defaulted even though Sales Credits were not required. This bug occurred when the sales credits columns were removed from the wizard.
Fixed Bug where the wizard errored when the accounting section was removed from the wizard.
Version 4.0.36 (15-June-09)
Upgraded more4apps core modules.
Added new download form.
Fixed upload bug caused by bill contact when the transaction Batch source used id for bill contact - It was causing an ora not enough values error.
Added dff download functionality to convert ids to values.
Adding missing customer columns and primary sales rep name to download.
Version 4.0.35 (22-May-09)
Fixed bug caused by substitutions when p_currentrow = 0 (only occurs at login) and a_item is empty (because column headers hasnt been run at this stage). Caused by caching of FlexInfo
when the flexfield has a default value (of sql type with a :$profile$ in it).
Version 4.0.34 (23-April-09)
Added Code to stop excel 2007 size explosions when caching rows.
Moved the row caching in the header form to the top of the activate - some columns could already have there values changed before the row was cached. eg Terms.
Fixed Bug where terms was being blanked out when Header form was opened.
Version 4.0.33 (1-Mar-09)
Added Qantas customization.
Fixed bug in transactionType.postToGL which caused the GL Date not to be loaded on first upload after login.
Version 4.0.32 (24-Feb-09)
Import Qantas Customizations.
Version 4.0.31 (30-Jan-09)
Added trim to stop spaces being picked up on upload.
Version 4.0.30 (9-Dec-08)
Fixed Bill to Location Bug - if the column wasn't on the spreadsheet it wouldn't default and an error would occur.
Version 4.0.29 (10-Oct-08)
Added Form to change the interface attributes used for the import
Version 4.0.28 (9-Oct-08)
Fixed bugs caused by changes in 4.0.27.
1)When using Auto Numbering couldn't find invoice number to update wizard.
2)Not all transaction attribute values were making it into sales credits or distributions causing them to be orphaned.
Version 4.0.27 (9-Oct-08)
Added functionality to allow easy modification of Interface attributes for AutoInvoice.
hanged validation of Customer Sites to exclude non active sites.
Version 4.0.26 (29-Aug-08)
Added trimming to all text cells before validation to errors caused by spaces.
Version 4.0.25 (5-May-08)
Changes made to allow blank gl date when transaction type doesn't post to gl.
Version 4.0.24 (24-Feb-08)
Changes made for better date handling
Version 4.0.23 (16-Feb-08)
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
Version 4.0.20 (12-Feb-08)
Added commitment column
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 lOV's 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' doesn't 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
Version 3.3.44 (26-Jun-2007)
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
Version 3.2.10 (20-Feb-2006)
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-Ja n-2005)
Set current row for dff form
Version 3.1.00 (21-J an-2005)
Add new DFF module
Version 3.0.08 (19-Oc t-2004)
Create new invoice for each header even for same customer
Version 3.0.07 (14-Oc t-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
