AR Invoice Wizard Version

Package Body Version

10.3.91 (14-May-2025)

1.2.4 (Minimum 1.2.4)

10.3.91 (14-May-2025)

Internal bug fix.

10.3.90 (01-May-2025)

Internal update.

10.3.89 (30-Apr-2025)

Tidied up Accounting Segments custom defaulting.

10.3.88 (28-Apr-2025)

Internal Update.

10.3.87 (11-Apr-2025)

Added support for Dynamic Insertion of Accounting Segments column.

10.3.86 (02-Apr-2025)

Internal update.

10.3.85 (01-Apr-2025)

Fixed the SQL issues while updating Finance Project Number and Region Code.
Added validator for account segments replaced with Project Number and Region Code.

10.3.84 (31-Mar-2025)

Corrected Exchange Rate being always required.

10.3.83 (28-Mar-2025)

Fixed error when creating new sheet.

10.3.82 (25-Mar-2025)

Added customisation.

10.3.81 (24-Mar-2025)

Fixed Exchange Rate defaulting.

10.3.80 (25-Feb-2025)

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

10.3.79 (12-Feb-2025)

Fixed a bug where transaction numbers and accepted messages were not displayed in the sheet after invoice creation, specifically when a previous invoice creation attempt had failed due to an API error.

10.3.78 (29-Jan-2025)

Fix for customisation.

10.3.77 (28-Jan-2025)

Added substitution for [:TGW_HEADER.ORG_ID:NULL].

10.3.76 (28-Jan-2025)

Added Substitutions for [:TGW_HEADER.BILL_TO_CUSTOMER_ID], [:TGW_HEADER.ORG_ID].
Tidied up Batch mode columns.

10.3.75 (27-Dec-2024)

Added fix for Error: ORA-06550 PLS-00172: string literal too long.

10.3.74 (08-Oct-2024)

Added Default Browser Login option.

10.3.73 (04-Oct-2024)

Fixed Multi Org issue with tax columns.

10.3.72 (05-Sep-2024)

Fixed error when logging in.

10.3.71 (22-Aug-2024)

Fixed error when retrieving Master Orgs.

10.3.70 (22-Aug-2024)

Fixed error when retrieving Master Orgs.

10.3.69 (15-Aug-2024)

Fixed issue when logging in.

10.3.68 (17-Jul-2024)

Major upgrade
- Improved performance.
- Added modes to split out different types of transactions.
* Single Transaction
* Batch Transaction
* Credit Transaction
* Apply Credit Memo
* Create and Apply Credit Memo
- Renamed to AR Invoice Wizard (was previously AR Invoice API Wizard)
- Added ability to manage worksheets with template functionality.
- Improved Workflow messaging for Applied Credit Memos
- Improved Form selection and display
- Templates save to database to be easily re-used across environments and versions
- Redesigned ribbon icons

9.4.97 (04-Aug-2021)

Internal update.

7.6.16 (12-Mar-2024)

Fix for Applied Credit Memo when skipworkflow is removed from sheet.

7.6.15 (12-Feb-2024)

Fix for VBA using bankers rounding (round up on 1.5, round down on 2.5).

7.6.14 (15-May-2023)

Internal update.

7.6.13 (20-Apr-2023)

Internal update.

7.6.12 (20-Apr-2023)

Internal update.

7.6.11 (19-Apr-2023)

Internal update.

7.6.10 (18-Apr-2023)

Internal update.

7.6.09 (03-Apr-2023)

Internal update.

7.6.08 (14-Mar-2023)

Fixed issue where some customers received an expired licence key message when it was still valid.

7.6.07 (13-Mar-2023)

Internal update.

7.6.06 (10-Mar-2023)

Added internal upload restriction.

7.6.05 (03-Mar-2023)

Fixed issue with Single master org.

7.6.04 (21-Feb-2023)

Changed all the http links to secure https links.

7.6.03 (27-Jan-2023)

Fixed About form/Setup page links.

7.6.02 (23-Jan-2023)

Internal update.

7.6.01 (16-Dec-2022)

Internal update.

7.6.00 (05-Dec-2022)

Internal update.

7.5.19 (02-Dec-2022)

Internal update.

7.5.18 (01-Nov-2022)

Internal update.

7.5.17 (07-Oct-2022)

Corrected issues that arose when operating unit has multiple master orgs associated.
Improved Item SQL query.

7.5.16 (30-Aug-2022)

Added Include Tax data on Example sheet.

7.5.15 (26-Jul-2022)

Fixed issue where attributes would not show if the system has more than 500 for a given flexfield.

7.5.14 (12-Jul-2022)

Internal update.

7.5.13 (12-Jul-2022)

Fixed Batch source list not including valid end dated batch sources.

7.5.12 (12-Jul-2022)

Fixed the issue that fake error message shown when uploading file.

7.5.11 (16-Jun-2022)

Fixed the issue where uploading attachment with multi-bytes file name failed on R11.
Added error message for uploading file type attachment failed when the attachment file is opened or in use.

7.5.10 (15-Jun-2022)

Fixed the issue where attachment with multi-bytes file name and content (ex Japanese characters) were corrupted.

7.5.09 (02-Jun-2022)

Fix bug where statestep blocks could be run in the wrong order.

7.5.08 (09-May-2022)

Internal update.

7.5.07 (03-May-2022)

No longer attempt to update record with credit reason in Batch mode.

7.5.06 (28-Mar-2022)

Internal update.

7.5.05 (10-Jan-2022)

Added long list functionality to Tax Code for R12.

7.5.04 (19-Oct-2021)

Fixed error with Line Reason LOV.

7.5.03 (19-Oct-2021)

Removed Line Reason Modifications as unsupported by API.

7.5.02 (11-Oct-2021)

Line Reason is now uploaded for CM uploads.

7.5.01 (11-Oct-2021)

Line Reason now shows credit memo reasons if Txn Type is CM.

7.5.00 (13-Sep-2021)

Internal update.

7.4.99 (09-Sep-2021)

Fixed Header Global DFFs 16-30 being inaccessible.

7.4.98 (11-Aug-2021)

Added :TGW_HEADER.CTT_CLASS form reference to Txn Class column.

7.4.95 (15-Jul-2021)

Refixed DFF error when binds exist with .ID format.

7.4.94 (14-Jul-2021)

Fixed DFF error when binds exist with .ID format.

7.4.93 (15-Jun-2021)

Internal update.

7.4.92 (26-May-2021)

Fixed error when uploading file Attachments.

7.4.91 (11-May-2021)

Fixed Upload error with non numeric Tax Rate.

7.4.90 (05-May-2021)

Fixed Upload error with non numeric Tax Rate.

7.4.89 (19-Apr-2021)

Fixed issue with Attachments not loading with >500 lines.

7.4.88 (15-Apr-2021)

Updated security.

7.4.87 (06-Apr-2021)

Updated security.

7.4.86 (29-Mar-2021)

Provided ability to upload ONLY REC Distribution Lines.

7.4.85 (08-Mar-2021)

Updated security.

7.4.84 (18-Feb-2021)

Updated customer customisation.

7.4.83 (16-Feb-2021)

Updated customer customisation.

7.4.82 (12-Feb-2021)

Updated customer customisation.

7.4.81 (11-Feb-2021)

Fixed error when removing Item/Memo columns.

7.4.80 (02-Feb-2021)

Updated security.

7.4.79 (19-Jan-2021)

Fixed invoices not defaulting Unit Selling Price.

7.4.78 (12-Jan-2021)

Fixed error in Lines form during initialisation.

7.4.77 (11-Jan-2021)

Removed Default Unit Selling Price for Credit Memos.

7.4.76 (02-Dec-2020)

Updated security.

7.4.75 (03-Nov-2020)

Updated security.

7.4.74 (15-Oct-2020)

Fixed Concurrent Refresh for Upload Selected.

7.4.73 (08-Oct-2020)

Fixed Concurrent Refresh not finding Request ID.

7.4.72 (08-Oct-2020)

Fixed Download form ignoring first result of Txn Class.

7.4.71 (05-Oct-2020)

Corrected wrong status return for Applied Credit Memos.

7.4.70 (05-Oct-2020)

Corrected Request ID cell location.

7.4.69 (01-Oct-2020)

Fixed Out of Stack Space error with Primary Sales Rep.

7.4.68 (01-Oct-2020)

Added non US Language support for Concurrent Refresh.

7.4.67 (29-Sep-2020)

Added allow 'Default Ship Location' Profile Option.

7.4.66 (16-Sep-2020)

Updated Primary Sales Rep validation heirarchy.

7.4.65 (16-Sep-2020)

Updated Paying Location label in form. Fixed Address SQL error with blank Location.

7.4.64 (14-Sep-2020)

Fixed form error when opening via Ship To or Paying Customer information.

7.4.63 (11-Sep-2020)

Fixed issue with Ship To Address when Removing Ship To Location.

7.4.62 (10-Sep-2020)

Moved Ship to Customer information to front tab of Invoice form.

7.4.61 (07-Sep-2020)

Updated security.

7.4.60 (25-Aug-2020)

Internal update.

7.4.59 (21-Aug-2020)

Added Ship To Site address to Primary Sales Rep Default heirarchy.

7.4.58 (21-Aug-2020)

Added Customer to Default terms heirarchy.

7.4.57 (03-Aug-2020)

Updated security.

7.4.56 (03-Aug-2020)

Fixed CustomizeFields generating incorrectly formatted columns.

7.4.55 (27-Jul-2020)

Internal update.

7.4.54 (24-Jul-2020)

Fixed compile error when initialising Wizard.

7.4.53 (21-Jul-2020)

Updated colors and formatting to new brand style.

7.4.52 (01-Jul-2020)

Updated security.

7.4.51 (26-Jun-2020)

Fixed error in Setup sheet.

7.4.50 (24-Jun-2020)

Internal update.

7.4.49 (02-Jun-2020)

Updated security.

7.4.48 (13-May-2020)

Fixed compile error during upload.

7.4.47 (13-May-2020)

Fixed DFF date uploading format issue.

7.4.46 (07-May-2020)

Fixed custom DFF form reference error.

7.4.45 (05-May-2020)

Updated security.

7.4.44 (04-May-2020)

Added functional dependence for custom DFF form references.

7.4.43 (30-Apr-2020)

Fixed Credit Memo Distribution DFF updating to wrong columns.

7.4.42 (30-Apr-2020)

Updated security.

7.4.41 (03-Apr-2020)

Internal update.

7.4.40 (31-Mar-2020)

Internal update.

7.4.39 (26-Mar-2020)

Internal update.

7.4.38 (02-Mar-2020)

Updated security.

7.4.37 (20-Jan-2020)

Fixed error when defaulting Terms.

7.4.36 (16-Jan-2020)

Fixed Customer not returning all results when profile/profile class inactive.

7.4.35 (16-Dec-2019)

Fixed Instrument not erroring upload with insufficient data.

7.4.34 (06-Dec-2019)

Enabled firewall encoding solution.

7.4.33 (02-Dec-2019)

Internal update.

7.4.32 (26-Nov-2019)

Fixed reliable Tax dependent column data.

7.4.31 (21-Nov-2019)

Added Logging and Help buttons to the ribbon.

7.4.30 (15-Nov-2019)

Fixed Quantity/Unit Selling Price not erroring when blank for Invoices.
Added ability to calculate a total amount of 0.

7.4.29 (13-Nov-2019)

Added new example sheets.

7.4.28 (07-Nov-2019)

Updated security.

7.4.27 (06-Nov-2019)

Added check for Credit Memo upload with only Quantity or Unit Selling Price populated.

7.4.26 (18-Oct-2019)

Accounting Rule is now dependent on Operating unit.
Fixed Duration Accounting Rules.

7.4.25 (16-Oct-2019)

Added support for users with 1000+ credit reasons.

7.4.24 (23-Sep-2019)

Added Pending when uploading rows for Concurrent uploads.

7.4.23 (23-Sep-2019)

Fixed Attribute tables fix causing SQL error in upload.

7.4.22 (23-Sep-2019)

Added digital signature.

7.4.21 (23-Sep-2019)

Fixed Applied Credit Memo Attributes not clearing previous values.

7.4.20 (09-Sep-2019)

Fixed Description validation always coming back as an error.

7.4.19 (09-Sep-2019)

Fixed error when using dependent DFF validation type.

7.4.18 (04-Sep-2019)

Removed required validation for Description column for Tax/Freight Lines.

7.4.17 (04-Sep-2019)

Added Accounting Rule duration to upload.

7.4.16 (02-Sep-2019)

Fixed issue where DFF columns could be ignored for upload.

7.4.15 (23-Aug-2019)

Fixed issue with Distribution download.
Fixed form error when Adding Distribution Grid line.

7.4.14 (22-Aug-2019)

Distributions against Lines with Accounting rules will now only Download Account Sets.

7.4.13 (16-Aug-2019)

Fixed issue when opening interface DFF forms.

7.4.12 (15-Aug-2019)

Fixed issue where certain errored scenarios would attempt to upload anyway.
Fixed issue when defaulting with Unit Price API with no UOM column.

7.4.11 (14-Aug-2019)

Fixed REV Distribution Lines not erroring when uploading invalid percent.

7.4.10 (14-Aug-2019)

Fixed compile error.

7.4.09 (13-Aug-2019)

Fixed Total Amt column not defaulting for Credit Memos.
Fixed error when calculating total distributions.

7.4.08 (05-Aug-2019)

Fixed issue when uploading Credit memo with a Quantity or Unit Selling Price only.

7.4.07 (01-Aug-2019)

Fixed issue when uploading Credit memo with no total Amount.

7.4.06 (27-Jun-2019)

Fixed error when validating Apply Amount with an invalid Txn Type.

7.4.05 (27-Jun-2019)

Fixed error when validating Apply section with an invalid Txn Type.

7.4.04 (27-Jun-2019)

Fix for SQL error caused by Credit Memo Numbers having apostrophes in the name.

7.4.03 (24-Jun-2019)

Now return a message when Template123 sheet has been deleted.

7.4.02 (20-Jun-2019)

Added check for max length (20) for Invoice Number.

7.4.01 (06-Jun-2019)

Added PO Revision column.

7.4.00 (29-Mar-2019)

Updated Wizard Version Number for release.

7.3.68 (28-Mar-2019)

Corrected Core Code version number in the About form.

7.3.67 (26-Mar-2019)

Fixed Credit Memo Number being returned with preceeding 0's or converted to scientific notation after refresh.

7.3.66 (26-Mar-2019)

Corrected validation for Apply Amount column.

7.3.65 (26-Mar-2019)

Fixed Invoice Number being returned without preceeding 0's or converted to scientific notation after upload.

7.3.64 (21-Mar-2019)

Updated Setup sheet.

7.3.63 (19-Mar-2019)

Fixed error encountered when cell contains invalid text.

7.3.62 (15-Mar-2019)

Updated Setup sheet.

7.3.61 (04-Mar-2019)

Updated security.

7.3.60 (04-Mar-2019)

Fixed Unit of Measures not uploading occasionally.

7.3.59 (15-Feb-2019)

Cleaned up Invoice upload.

7.3.58 (08-Feb-2019)

Fixed 11i download not correctly downloading invoices with manual Receipt Methods.

7.3.57 (07-Feb-2019)

A new checkbox 'Allow Popups' was added in the Login form to enable the user to turn on or turn off pop up dialogues.
As default 'Allow Popups' will be unselected to stop from showing Java script error during the login.

7.3.56 (07-Feb-2019)

Corrected Download form downloading all invoice.

7.3.55 (04-Feb-2019)

Updated security.

7.3.54 (16-Jan-2019)

Fixed error when removing a Customer Number column.

7.3.53 (11-Jan-2019)

Fixed issue with Instrument upload (and related customisations).

7.3.52 (09-Jan-2019)

Redesigned Customer Name/Number functionality (caused issue when many numbers to one name) (Bill to/Ship To/Paying/Sold to).

7.3.51 (07-Jan-2019)

Updated security.

7.3.50 (03-Dec-2018)

Updated security.

7.3.49 (06-Nov-2018)

Fixed issue where Tax Exemption columns would incorrectly error with when Profile ebTax disabled.

7.3.48 (05-Nov-2018)

Added Fusion Business Unit download filtering.

7.3.47 (01-Nov-2018)

Updated security.

7.3.46 (26-Oct-2018)

Fixed some defaulting values not being used in the Lines upload.
(TotalAmt/Quantity/UnitSellingPrice/LineNumber/Description/UnitStandardPrice/RuleStartDate/RuleEndDate).

7.3.45 (23-Oct-2018)

Fixed Ship To Line Address search returning the location and failing validation.

7.3.44 (19-Oct-2018)

Added search controls to R12 Tax columns.

7.3.43 (16-Oct-2018)

Added functionality to debug API (Only controlled by M4A).

7.3.42 (12-Oct-2018)

Refined control around Exemption Certificate and Exemption Reason defaulting.

7.3.41 (12-Oct-2018)

Fixed errors that occurred when initialising with no Bill To/Ship To Address/Location, Transaction Date, Invoice Rule.

7.3.40 (12-Oct-2018)

Updated Tax Exemption comments.
Fixed error with uploading Tax Exemption Certificate.
Added Duplicate options of Certificates with different Exempt Reasons.

7.3.39 (11-Oct-2018)

Fixed VBA issue with Wizard set up.
Fixed bug with selecting exemption certificates with case insensitivity.

7.3.38 (11-Oct-2018)

Added Tax Exemption Columns (and Line Ship to - Only Reference/Download columns).

7.3.37 (03-Oct-2018)

Corrected defaulting issue when defaulting Unit Selling Price with Differing Decimal notation in excel to Operating system.

7.3.36 (24-Sep-2018)

Fixed issue when uploading Credit Applications with no GL Date or Currency columns.

7.3.35 (03-Sep-2018)

Updated security.

7.3.34 (20-Aug-2018)

Corrected issue caused by V7.3.31/7.3.32.

7.3.33 (08-Aug-2018)

Corrected Credit Reason being set for subsequent On Account Credits after a Credit Reason has been set.

7.3.32 (07-Aug-2018)

Fixed issue with default DFF form references.

7.3.31 (26-Jul-2018)

Fixed defaulting DFF form reference with Invoice and Line sections.

7.3.30 (25-Jul-2018)

Added: TGW_HEADER.CUST_TRX_TYPE_ID DFF form reference (based on Trx Type column).

7.3.29 (02-Jul-2018)

Updated security.

7.3.28 (20-Jun-2018)

Corrected Patch version check for apply functionality.
On Account Application right-click menu name corrected.
Fixed issue where Application would attempt despite expected error from invoice API.

7.3.27 (18-Jun-2018)

Fixed error in 11i when validating Apply To Invoice column.
Error Application Columns if Apply To Invoice column is not present.
Fixed Download Timeout error.
Now don't execute On Account Application API when Invoice Creation failed.

7.3.26 (15-Jun-2018)

Corrected error with Apply API error handling.

7.3.25 (14-Jun-2018)

Switched OK Cancel tab order in Apply form.
Fixed On Account Apply Issues:
1. Transaction Type not CM
2. Patch correctly installed
3. Overapplication Flag check
ValidatorApply.ValidateAmount - Added check for amount vs txntype setting.
Fixed incorrect error when validating Quantity.
Now don't validate Amount/Quantity when both are blank and CM type.
Fixed Apply API failing and leaving a dry credit memo.

7.3.24 (13-Jun-2018)

Made Unit Selling Price and Quantity not required for Credit Memo.
Fixed error when opening Apply form with minimal data on sheet.
Provided access to extra columns in Apply To Invoice column.

7.3.23 (11-Jun-2018)

Updated security.

7.3.22 (11-Jun-2018)

Removed Location/Address 1 to 1 validation for Bill and Ship To.

7.3.21 (07-Jun-2018)

Added On Account Credit Application functionality.

7.3.20 (30-May-2018)

Extended width of Memo line drop-down box.

7.3.19 (26-Apr-2018)

Fixed SQL error when uploading in Batch mode.

7.3.18 (18-Apr-2018)

Fixed error when initialising with Fusion instance.

7.3.17 (17-Apr-2018)

Extended Memo LOV on Lines form.

7.3.16 (12-Apr-2018)

Extended Item and Memo LOV on Lines form.

7.3.15 (03-Apr-2018)

Updated security.

7.3.14 (23-Mar-2018)

Allowed Header comments up to 1760 characters (was 240).

7.3.13 (19-Mar-2018)

Updated Core Menu - Commented out Dependent Employee Wizard related functions.

7.3.12 (05-Mar-2018)

Updated security.

7.3.11 (21-Feb-2018)

Added error when DFF depends on a parent column in another section.

7.3.10 (13-Feb-2018)

Updated Custom Query messages.

7.3.09 (08-Feb-2018)

Updated Downloader ribbon to Custom Query ribbon.

7.3.08 (08-Feb-2018)

Fixed error messages being retained from earlier uploads.

7.3.07 (07-Feb-2018)

Corrected Substitution DFF error during download.

7.3.06 (07-Feb-2018)

Updated Upload to hopefully return clearer errors.

7.3.05 (24-Jan-2018)

Updated Tax Rate Name column to reflect end dated taxcodes based on Transaction Date.

7.3.04 (22-Jan-2018)

Fixed error occurring when attempting to validate DFF setup.

7.3.03 (09-Jan-2018)

Fixed issue with dynamic DFF form reference LOV values.

7.3.02 (28-Dec-2017)

Added Currency Code and Inventory Item Oracle form reference substitutions for DFFs.

7.3.01 (19-Dec-2017)

Error when user tries to enter an Automatic Receipt without an Account Number.

7.3.00 (18-Dec-2017)

Updated Wizard version number for release.

7.2.63 (18-Dec-2017)

Restrict Customer payment methods by transaction date.
Fixed reverse validation on R11 bank columns.
Fixed R11 inconsistent bank error Message display.

7.2.62 (15-Dec-2017)

Only return one bank columns error to sheet/Processing form when uploading.
Return all errors associated with bank column instead of just one error.

7.2.61 (15-Dec-2017)

Added Bank columns for R11 upload (Customer Bank, Bank Branch, Account Number).

7.2.60 (14-Dec-2017)

Fixed error encountered when opening DFF form and error when searching invalid data.

7.2.59 (14-Dec-2017)

Removed Clear button from DFF form as it was not working as intended.

7.2.58 (14-Dec-2017)

Fixed Download form not downloading with a valid date.

7.2.57 (14-Dec-2017)

Fixed error on download form when trying to download with an invalid date.

7.2.56 (14-Dec-2017)

Fixed white space error when uploading multiple contexts.

7.2.55 (11-Dec-2017)

Fixed error when using Credit Refresh button with missing columns.

7.2.54 (11-Dec-2017)

Fixed error when select an Instrument.

7.2.53 (08-Dec-2017)

Fixed form buttons losing function when Interface DFF button was clicked.

7.2.52 (08-Dec-2017)

Default Row now frozen with header rows on sheet.
Updated Receipt Method SQL to use R12 tables instead of R11 ones.

7.2.51 (08-Dec-2017)

Updated Security.

7.2.50 (05-Dec-2017)

Fixed error where Receipt Methods would not show for Currencies that were not USD.

7.2.49 (23-Nov-2017)

Updated version notes.

7.2.48 (20-Nov-2017)

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

7.2.47 (20-Oct-2017)

Fixed "'TRX_CONTINGENCIES_TBL_TYPE' must be declared" error.

7.2.46 (13-Sep-2017)

Removing the error message about couldn't find e4awand_Oracle.xll

7.2.45 (12-Sep-2017)

Updated Security.

7.2.44 (16-Aug-2017)

Corrected defaulting for Bill To Contact.

7.2.43 (14-Aug-2017)

Made Currency no longer mandatory. If column is removed, Exchange columns are ignored.

7.2.42 (27-Jul-2017)

Added Taxable flag column to Wizard to suppress Automatic Tax calculation on Lines.

7.2.41 (26-Jul-2017)

Increased efficiency of Lines download query.

7.2.40 (26-Jul-2017)

Fusion: Fixed Item search control on lines form and fixed error encountered on upload.

7.2.39 (25-Jul-2017)

Line Number will now be valid for rows with an amount of 0.

7.2.38 (13-Jul-2017)

Fixed issue with Credit Memo uploads.

7.2.37 (11-Jul-2017)

Fixed upload errors for uploads with multiple records.

7.2.36 (03-Jul-2017)

Updated Security.

7.2.35 (26-Jun-2017)

Fixed R11i issues with SourceLineDataKey1 and ContractLineID.

7.2.34 (23-Jun-2017)

Fixed SQL parse error when setting the language on systems with 10G databases.

7.2.33 (12-Jun-2017)

Added Contract_Line_ID and Source_data_key1 columns.

7.2.32 (05-May-2017)

Increased download speed further.

7.2.31 (03-May-2017)

Fusion: Added debit memos to Transaction Types.
Fixed issues during large uploads.

7.2.30 (27-Apr-2017)

Fixed error for Tax Rate column when populated.

7.2.29 (27-Apr-2017)

Sped up download for all cases.

7.2.28 (24-Apr-2017)

Added Batch Source form for selecting a batch source when batch source is missing.
Sped up Download when Tax Lines are excluded.

7.2.27 (06-Apr-2017)

Fusion: Disabled Attachments as not implemented yet.

7.2.26 (04-Apr-2017)

Profile Option - "More4Apps: RIW Default Tax Rate and Amount" will now enable validation on TotalAmt and TaxRate Columns (Error if not defaulted value).

7.2.25 (03-Apr-2017)

Updated Security.

7.2.24 (30-Mar-2017)

Added Defaulting TaxRate/Total Amt Columns enhancement.
Added Profile option to manage it: "More4Apps: RIW Default Tax Rate and Amount".

7.2.23 (14-Mar-2017)

Modified error messages for LineType/Line Number/Total Amt columns missing.

7.2.22 (14-Mar-2017)

Fixed removing Total Amount column error.
Fixed non numeric Unit Selling price/Quantity not erroring as expected.
Fixed error in GLDate validation caching the wrong date for defaulting.

7.2.21 (03-Mar-2017)

Fixed XML error when validating Date in 11i.

7.2.20 (01-Mar-2017)

Fixed invalid date bug when Batch Source does not have a start_date specified.
Fixed error when batch source is selected with a different format.

7.2.19 (27-Feb-2017)

Fixed form error when loading Invoice form.

7.2.18 (24-Feb-2017)

Fixed "Not a valid month" SQL error when validating date with a batchSource date using different format to Wizard.

7.2.17 (17-Feb-2017)

Added Sales Order Line column and validation to ensure a Sales Order Numb exists for sales order data (Line/Date).

7.2.16 (16-Feb-2017)

Fusion: Enabled DFFs (Excluding Global). Also added DFFs to header download.

7.2.15 (10-Feb-2017)

Updated customer customizations.

7.2.14 (10-Feb-2017)

Fixed problem where items and carriers were not validating correctly.

7.2.13 (09-Feb-2017)

Fixed issue with DFF setup where user encountered issue with data.
Download form - renamed error when missing download columns (was "Date Actual", now "Transaction Date").

7.2.12 (02-Feb-2017)

Added calendars to GL date buttons on Download form.

7.2.11 (08-Feb-2017)

Fixed End-To-End Trace not working.

7.2.10 (07-Feb-2017)

Fixed SQL issues with users that do not have Inventory installed.

7.2.09 (03-Feb-2017)

Fixed issue with missing error when attempting upload with a responsibility that does not have access to form functions.

7.2.08 (03-Feb-2017)

Updated Common Modules in attempt to fix customer DFF issue.

7.2.07 (01-Feb-2017)

Added client customizations to latest release.

7.2.06 (27-Jan-2017)

Disabled several Common Macros from list (now functions instead of subs - core macros still exist).

7.2.05 (26-Jan-2017)

Fixed Error with Concurrent Upload "Encountered the symbol BEGIN".

7.2.04 (25-Jan-2017)

Significant performance improvements for mass uploads.

7.2.03 (23-Jan-2017)

Fusion - Added p_called_from parameter back in.

7.2.02 (20-Jan-2017)

Fixed issue with returning Memo data for r11i Environment.

7.2.01 (20-Jan-2017)

Fixed Upload for R11i Environments.
Modified Batch patch Message to better explain Batch issue

7.2.00 (19-Jan-2017)

Fixed issue with Date format in Tax Initialisation for Uploads.

7.1.99 (12-Jan-2017)

Enabled defaulting of formulas that do not return a value in row 10.
Fixed Issue with concurrent Upload with simultaneous Applied and non-Applied transactions with a Tax code.

7.1.98 (11-Jan-2017)

Fixed error running Upload All attachments without logging in previously.

7.1.97 (10-Jan-2017)

Fixed Concurrent Upload for Batch mode.

7.1.96 (06-Jan-2017)

Added Message to Batch Mode Upload Option to warn that Applied CM's will not be uploaded.

7.1.95 (06-Jan-2017)

Various tabbing corrections across forms.

7.1.94 (05-Jan-2017)

Fixed SQL Error with Attachments.

7.1.93 (05-Jan-2017)

Fixed SQL error with Transaction Code Upload.

7.1.92 (05-Jan-2017)

Fixed Batch mode error when there are coloured cells that are far below upload data.
Disabled Credit Memos in Batch Mode.
Converted 'Credit Request Created' message to proper case.

7.1.91 (16-Dec-2016)

Language for the user is now being set from user's EBS preferences irrespective of what is chosen on the Browser Login page.

7.1.90 (15-Dec-2016)

Fixed ZX_Security Error occurring with lines using R12 Tax data.
Fixed "Error 13 (Type mismatch) in procedure LoadFromXML" Error.
Modified online documentation and release notes on login form to link to RIW-API version instead of Interface.

7.1.89 (05-Dec-2016)

Fixed VBA Errors occurring with SalesRep Number Validation.

7.1.88 (30-Nov-2016)

Fixed a number of columns becoming required when not required.

7.1.87 (30-Nov-2016)

Added new Example Sheets.

7.1.86 (29-Nov-2016)

Fixed Error when Description column is removed during Applied Credit Memo.
Fixed Distributions being uploaded without erroring Account Class.

7.1.85 (28-Nov-2016)

Sales Rep num/Name is now dependent on Transaction Type.
Fixed Credit Refresh adding Accepted on lines that had no data.
Transaction Date will no longer be required for Applied Credit Memos.

7.1.84 (24-Nov-2016)

Corrected SalesRep not Defaulting occasionally, removed salesrep required for Credit Memos.

7.1.83 (21-Nov-2016)

Added Defaulting for Primary Sales Rep. Only defaults from Bill to Customer.

7.1.82 (18-Nov-2016)

Fusion - Removed parameter that no longer exists in R9.

7.1.81 (16-Nov-2016)

Corrected SalesRep not Defaulting occasionally, removed salesrep required for Credit Memos.

7.1.80 (14-Nov-2016)

Credit Invoice is now loosely dependent on Transaction Type - if no type is selected, all invoices against customer will be visible.

7.1.79 (10-Nov-2016)

Fixed issue with cached values when switching between Operating units.

7.1.78 (09-Nov-2016)

Added pending Messages for Credit memos statuses stalled in Workflow process (when using Credit refresh).

7.1.77 (08-Nov-2016)

Updated Security.

7.1.76 (02-Nov-2016)

Improved performance of mass validation by only updating the sheet every 50rd record.

7.1.75 (02-Nov-2016)

Download form now retains Checkbox Selection after closing (Include Rev Lines and Tax Lines).

7.1.74 (31-Oct-2016)

Fixed issue in Fusion where create accounting would result in errored status.

7.1.73 (27-Oct-2016)

Fixed problem where the request ID was updated when clicking "Credit Status" - this seems obsolete and so has been removed as it was causing issues.
The download form now sorts results in the shuffler by date correctly.

7.1.72 (26-Oct-2016)

GL Date can now be uploaded with applied credit memos when patch 19035538 is installed.
Fixed bug where applied credit memo line status would always display "ACCEPTED" when refreshing using "Credit Status" button.

7.1.71 (25-Oct-2016)

Changed the default max size to 150 (Was 250) because the API only accepts 150 characters.

7.1.70 (25-Oct-2016)

Fusion - Fixed "invalid line amount" error when uploading in Fusion and GL Date was not provided. Added defaulting for GL Date.

7.1.69 (19-Oct-2016)

Users no longer have to enter Batch Source for Downloads.
Fixed error with searching an Item.

7.1.68 (18-Oct-2016)

Fixed Attachment section Error when using sheet with renamed Invoice number and Customer columns.

7.1.67 (17-Oct-2016)

Memo and Item Columns no longer dependent on Bill To locations' language.

7.1.66 (10-Oct-2016)

Fixed error when Validate Concurrent Upload fails for Large Invoices.

7.1.65 (06-Oct-2016)

Fixed invalid transaction type error message with batch upload.

7.1.64 (04-Oct-2016)

Updated Security.

7.1.63 (30-Sep-2016)

Fusion - Reverted Bill To/Paying Customer changes, Fixed Location Upload in R9.

7.1.62 (26-Sep-2016)

Fusion - Modified columns to match API in Fusion R9 Upload.

7.1.61 (22-Sep-2016)

Fixed UOM upload for On Account Memos.

7.1.60 (19-Sep-2016)

UOM now validates based on Value instead of code. Now defaults UOM for all transactions (only Invoice types will be uploaded).
Fixed UOM upload for On Account Memos.

7.1.59 (14-Sep-2016)

Fixed table not found error when refreshing credit status.

7.1.58 (12-Sep-2016)

Added Customer Number as download criteria on the Download form.

7.1.57 (12-Sep-2016)

Updated Security.

7.1.56 (09-Sep-2016)

Fixed SQL error when validating Tax Rate Name when profile option "More4Apps: RIW Limit Tax Classifications LOV by OU" was set but "More4Apps: RIW r12 Tax Validation only uses the Tax Rate Name Column" wasn't.

7.1.55 (09-Sep-2016)

Modified UOM validation to return same results as Oracle.

7.1.54 (07-Sep-2016)

Undone UOM restriction for Credit Memos, now only uploads value if Invoice Transaction Type. This is to allow a value for defaulting a Unit Price using API call (Price_request).

7.1.53 (07-Sep-2016)

Fusion - Fixed overflow error when uploading. Fixed error when searching in download form and also disabled several download criteria.

7.1.52 (06-Sep-2016)

Fusion - Disabled DFF declaration for now.

7.1.51 (31-Aug-2016)

Added Download Wizard to Ribbon.

7.1.50 (26-Aug-2016)

Fixed SQL error when using the search button on the Download form.

7.1.49 (26-Aug-2016)

Fixed increasing performance issues when uploading multiple credit memos.

7.1.48 (26-Aug-2016)

Fixed bug where new core would not work with Fusion when the servlet is not up to date.

7.1.47 (22-Aug-2016)

Fixed function check bug on upload (Introduced by Fusion code).

7.1.46 (19-Aug-2016)

Wizard now harmonizes with Fusion.

7.1.45 (29-Jul-2016)

Fixed errors when loading applied credit memos with a batch source that has manual numbering.

7.1.44 (09-Aug-2016)

Fixed false negative on credit refresh "Error in Header: E".

7.1.43 (28-Jul-2016)

Fixed issue with attachment column header names.
Reorganised tab order on Download form.
Fixed issue downloading more than one Item.

7.1.42 (27-Jul-2016)

Fixed Issue in Download for Invoices that don't have Paying Customers.

7.1.41 (25-Jul-2016)

Added profile option "More4Apps: RIW r12 Tax Validation only uses the Tax Rate Name Column".

7.1.40 (25-Jul-2016)

Added profile option "More4Apps: RIW Limit Tax Classifications LOV by OU".

7.1.39 (21-Jul-2016)

Fixed Error when Moving Attachment columns while logged in.

7.1.38 (19-Jul-2016)

Added Paying Customer Number, Paying Customer Name and Paying Location columns.
Fixed terms not defaulting when bill location doesn't exist on the sheet.

7.1.37 (19-Jul-2016)

Customer Issue if they remove Bill Location column (Customization to default Paying Site Use ID).

7.1.36 (07-Jul-2016)

Credit Reason and Print Option LOV will no longer include values which are not within the effective dates.
Added "Interface DFF" button on the header form to allow access to the interface DFF form.
Added "Invoice Interface DFF" to ribbon DFF's dropdown.
Fixed incorrect validation and messages around SC/Dist amount and percent with alpha characters.
Fixed issue where Ship to and Bill to contact LOV was returning values inconsistent with professional forms.
Renamed Customize Columns form display to Customize Fields.
Fixed DKFF.Initialize setup messages incorrectly showing for plsql special validation.

7.1.35 (06-Jul-2016)

Successfully uploaded invoices will now say Accepted rather than Loaded.
Fixed error on upload when distribution columns were not on the sheet.
Fixed precision bug when the amount is between 0 and -1 e.g. -0.003
Corrected the max length of Shipping Ref field from 240 down to 50.
Added column comments for 'Orig System Ref', 'Resolution Summary' and 'Invoice Comments' fields.

7.1.34 (05-Jul-2016)

Fixed API error Invalid batch source ID. INVALID_VALUE:12079 when transaction date was outside transaction source effect dates.

7.1.33 (30-Jun-2016)

Internal fix.

7.1.32 (28-Jun-2016)

Handled error when Item selected on second row and Bill To Address does not have a Language.

7.1.31 (23-Jun-2016)

Modified SQL in item Column to use Master Organization instead of Inventory Org.

7.1.30 (22-Jun-2016)

Fixed error when searching Item with invalid dependent columns.
Fixed error in Invoice Form Caused by Carrier (error: 9999 setCtlText encountered a Runtime error).

7.1.29 (22-Jun-2016)

Fixed error not showing Customer when customer Profile status was set to 'I' (inactive).

7.1.28 (21-Jun-2016)

Fixed issue with term defaulting - will no longer overwrite value with default on upload, will only default if a customer and Transaction Type are selected.

7.1.27 (16-Jun-2016)

Fixed issue with defaulting an address that has multiple locations

7.1.26 (15-Jun-2016)

Terms will now derive default value from Bill Contact - derives from Address, or Location if no value found at address level.

7.1.25 (15-Jun-2016)

Added option on download form to restrict download to only REV distributions for easier download->upload.

7.1.24 (15-Jun-2016)

Credit Reason only needs to be required for applied Creditmemos (determined by a value in credit invoice column), rearranged order of credit memo details in form.

7.1.23 (10-Jun-2016)

Fixed another issue with salescredit amount total calculation.
Fixed problem where Item would not download and Carrier/Warehouse would not validate in 11i.
Remit to Address now downloads Address line 1 instead of the concatenated address to be consistent with upload.
Distributions will now be ordered by account class when downloaded.

7.1.22 (10-Jun-2016)

Fixed issue with blank Total Amount column functionality.

7.1.21 (09-Jun-2016)

Fixed bug where sales credits would give a sum of amounts error when the sum was correct.
Distributions with NULL amounts will no longer be downloaded.

7.1.20 (09-Jun-2016)

Added check for null Total Amount column - will now use 0 instead of erroring.

7.1.19 (08-Jun-2016)

Remove Batch Source Name dropdown Control if user left unselected between responsibilities.

7.1.18 (07-Jun-2016)

Resized Customize Fields form as the ok and create buttons were not visible.
Remit to address will now download correctly.

7.1.17 (03-Jun-2016)

Fixed l_attribute_table error when uploading applied credit memos in 11i.

7.1.16 (03-Jun-2016)

Updated Wizard password.

7.1.15 (03-Jun-2016)

Fixed ARP_GLOBAL error when uploading in 11i.

7.1.14 (27-May-2016)

Corrected error in Item LOV.

7.1.13 (26-May-2016)

Fix to Item LOV bug.

7.1.12 (23-May-2016)

Updated Security.

7.1.11 (19-May-2016)

Interim fix to get memo-line working.

7.1.10 (19-May-2016)

Fixed bug: Searching or validating 'Memo Line' field/column caused a SQL Error.
SQL Error: ORA-00904: "B"."DESCRIPTION": invalid identifier
On some systems AR_MEMO_LINES_B has the description columns and on other systems it doesn’t.
At more4apps all EBS instances except strata have the description column.
Customer Issues (14452, 13423) have been on EBS version 12.2.4 and 12.1.3.
To further confuse things it looks like when the description column is missing AR_MEMO_LINES_B is a view and when the description column is present AR_MEMO_LINES_B is a synonym.

7.1.09 (11-May-2016)

Fixed Implementation, Validation and UOM Search errors when certain dependent columns were not on the sheet.

7.1.08 (11-May-2016)

Terms now required for Invoice upload - Fixed API Error "Error in Header: U ORA-06503: PL/SQL: Function returned without value" when Terms were not entered.

7.1.07 (11-May-2016)

Fixed Error 5 when validating DFFs and Memo or Item columns were missing from the sheet.

7.1.06 (05-May-2016)

Fixed customization issue for customer.

7.1.05 (04-May-2016)

Fixed another XML Parse error when validating the Memo pre R12.1.3

7.1.04 (04-May-2016)

Fixed error when retrieving customer data when certain columns removed from the sheet or invalid (customization).

7.1.03 (03-May-2016)

Fixed error when validating memo lines for Oracle R12 pre 12.1.3

7.1.02 (26-Apr-2016)

Fix for Row 10 Defaulting Error when a formula is used in Row 10.: Error 438 (Object doesn't support this property or method) in procedure TheDefaults of Module Main.

7.1.01 (21-Apr-2016)

Fix for error (ORA-01422: exact fetch returns more than requested number of rows) when 'Caching session values' during login.

7.1.00 (04-Mar-2016)

Ship to Address is now the primary column over Ship to Location - This is to stop the location from defaulting the incorrect value to address.

7.0.99 (24-Mar-2016)

Fixed incorrect "Invalid Txn Type" error when entering a Txn Class.

7.0.98 (24-Mar-2016)

Implemented the Transaction Class (Txn Class) column, add to form, download form criteria and the value is downloaded (not used for upload as txn type takes precedence).

7.0.97 (21-Mar-2016)

Updated Security.

7.0.96 (09-Mar-2016)

Fixed bug where "Executing Invoice Creation" would be called even when no records had uploaded in "Create Batch" mode.
Improved performance of validating the GL Date.
Fixed "Compile Error in Hidden Module: RIW Ribbon" for Excel 2003.

7.0.95 (09-Mar-2016)

Fixed error when opening Customize Fields form, it was opening the wrong form.

7.0.94 (08-Mar-2016)

Descriptions defaulting from item and memo will now be in the correct language based on the Bill To Location.
Fixed error when opening the Lines Attachment form.

7.0.93 (08-Mar-2016)

Extended list on "Customize fields" form as not all values were showing.

7.0.92 (04-Mar-2016)

Batch Name is now coloured like a status column to identify it as read only - batch loads status bar now say "Executing Invoice Creation" instead of "FALSE" when uploading.

7.0.91 (04-Mar-2016)

Fixed error when changing to "Create Batch" mode when not logged in - Added cell comment for Batch Name column.

7.0.90 (02-Mar-2016)

Fixed error when uploading applied credit memos when using "," as the computers decimal symbol (e.g. German Number Formatting).

7.0.89 (01-Mar-2016)

Fixed invalid CCID error when doing mass uploads (OVER 9000).

7.0.88 (25-Feb-2016)

Added substitution for transaction type name.

7.0.87 (24-Feb-2016)

Fixed "invalid number" error on login.

7.0.86 (24-Feb-2016)

The Bill To Address form the LOV will now have the Location appended to the value when duplicate addresses exist for the customer.

7.0.85 (19-Feb-2016)

Performance fix for large batch loads.

7.0.84 (18-Feb-2016)

Added a message to warn user if package version of API contains bug - and to patch it.

7.0.83 (18-Feb-2016)

Fixed an issue with large batch loads that trigger statestep, causing lines to become detached from their headers.

7.0.82 (16-Feb-2016)

Implemented Batch loading mode and Batch Name column.

7.0.81 (12-Feb-2016)

Fixed amount calculation and rounding bugs when using German regional settings.

7.0.80 (12-Feb-2016)

Changed hardcoded currency USD in DefaultUnitPriceAPI to take the currency off the sheet.

7.0.79 (10-Feb-2016)

Price List defaulting is now done using the Price Request API.

7.0.78 (05-Feb-2016)

Fixed whitespace error when uploading values with [%] and ['].

7.0.77 (28-Jan-2016)

Fixed bug where Exchange Rate Type would default for base currency invoices and result in error.

7.0.76 (21-Jan-2016)

Fixed issue with Unit Selling Price not defaulting from the correct price list line.

7.0.75 (19-Jan-2016)

Freight lines are no longer automatically linked to the line above when "Link To Line" is not entered.

7.0.74 (11-Jan-2016)

Fixed problem with uploading addresses that have duplicates.

7.0.73 (22-Dec-2015)

Updated Security.

7.0.72 (17-Dec-2015)

Unit Price can now be derived from secondary price lists if 'More4Apps: RIW Allow Price List Defaulting' enabled.

7.0.71 (04-Dec-2015)

Added DFF logging capabilities.

7.0.70 (17-Nov-2015)

Fixed bug where concurrent data feedback was being overwritten from data in previous sql statement. This caused no results to be returned to the sheet from an upload when it is run as a concurrent job.
Fixed bug where memo wouldn’t return any values in the form or validate in EBS 11i.
Re-introduced sql (for EBS 11i only) that was changed 28/04/15.
Fixed License key validation bug when loading in Validate Concurrent Mode.
Symptoms were: Able to upload unlimited invoice lines when in trial mode (no license key or expired short term license).
Unable to upload invoices when license key is valid (whereas in Validate Commit you could upload unlimited as expected).

7.0.69 (10-Nov-2015)

Improved performance when downloading Tax lines.
Fixed Tax Line ID coming down instead of the Line Number.

7.0.68 (09-Nov-2015)

Improved performance of downloading lines when not including Tax lines - Removed tax tables from line sql.

7.0.67 (09-Nov-2015)

Fixed bug where missing DFF columns in the sheet would cause 'object or block variable not set' error.

7.0.66 (05-Nov-2015)

Added in a defaulting for Bill to Location to the customer’s primary site.

7.0.65 (30-Oct-2015)

Fixed "Missing In or Out parameter" error in Default Bill Contact SQL - was using :CUST twice when should be using :CUST and :SITE.
Fixed API error when passing customer bank account ID - Also need to pass paying customer ID and paying site use ID.

7.0.64 (23-Oct-2015)

Implemented Format Data button (Normalize/Denormalize).

7.0.63 (12-Oct-2015)

Added Substitutions for :TLIN_LINES.INVENTORY_ITEM_ID and :TLIN_LINES.MEMO_LINE_ID

7.0.62 (06-Oct-2015)

Added Bill Contact Defaulting so the Bill to Contact will now default based on the Customer when only 1 contact exists.

7.0.61 (25-Sep-2015)

Added names to DefaultMulti and DefaultParent so they can be identified in LineType Validation.

7.0.60 (24-Sep-2015)

Fixed an "Invalid Use of Null" error when a primary column attempts to overwrite the other column (which already has a valid value).

7.0.59 (22-Sep-2015)

Fixed errors when using row 10 defaults.

7.0.58 (15-Sep-2015)

Cleaned up workbook styles to prevent the "too many different cell formats" error.

7.0.57 (15-Sep-2015)

Fixed error with customer’s Default Account Customization.

7.0.56 (11-Sep-2015)

Added customer Customization to determine and pass customer_bank_account_id to the API.
Added customer check in Account Validation to set Accounting Segments not required.

7.0.55 (08-Sep-2015)

Added new profile option More4Apps: RIW Use Alternative Credit Refresh which does the following when set to Yes and the Allow Skip Workflow profile is set:
When the Credit Request call errors, do our own custom check and override the Oracle return status.

7.0.54 (04-Sep-2015)

Implemented Global DFFs at line level.
Fixed error in LineType Validation caused by invalid header data.

7.0.53 (03-Sep-2015)

Implemented Global DFFs at header level.
Fixed bug with customer customisation where a valid line under an invalid line would make the record valid.

7.0.52 (03-Sep-2015)

Added Customisation for customer to convert line attributes 7, 8 and 9 into DD-MON-YYYY format.

7.0.51 (25-Aug-2015)

Updated DFF row 10 defaulting.

7.0.50 (25-Aug-2015)

Added DFF substitutions for transaction type ID and previous transaction line ID for customer.

7.0.49 (24-Aug-2015)

Fixed errors in Line Type Validation and Credit Reason Validation.

7.0.48 (19-Aug-2015)

Removed Text column type from all DFF Attribute uploads.

7.0.47 (19-Aug-2015)

Fixed bug where line date DFFs were not formatted correctly on upload.
Credit Reason is now required for Credit Memo transactions (API errors if it's not passed).
UOM will no longer default for Credit Memo transactions, UOM will also error if entered for a credit memo as the API rejects it.

7.0.46 (20-Jul-2015)

Added fix for download selected when using formulas.
Updated ValidatorExchange - When we have a default exchange type - exchange type is no longer required for foreign currency codes.
Added profile "More4Apps: RIW Use Customer Name as Primary Column" which controls the following - When the form is open and the customer number is blank, selecting a customer name that has duplicates will default the correct customer number. After that, to have it overwrite the customer number, you must pick a different name (not one of the duplicates) or clear it, then change it back to the value you want.

7.0.45 (17-Jul-2015)

Changed price list line defaulting from using list_price to using nvl(list_price, operand).

7.0.44 (14-Jul-2015)

Fix for customer.

7.0.43 (19-Jun-2015)

Upload Invoice - Swapped (Ship to and Sold to) Name and Number as Number is unique and should overwrite name.

7.0.42 (16-Jun-2015)

Unit Selling Price can now default based on customer price list lines if 'More4Apps: RIW Allow Price List Defaulting' enabled.

7.0.41 (11-Jun-2015)

Fix for Distributions not updating correctly for applied credit memos.

7.0.40 (08-Jun-2015)

Distributions are now allowed for Applied Credit memos when it's just DFF and Comment values.

7.0.39 (05-Jun-2015)

You can now search for Items using Description criteria.
Item now defaults 'Unit Selling Price', 'Unit of Measure' and 'Description'.

7.0.38 (02-Jun-2015)

Fixed validation issue with Primary Sales Rep Number and Name.

7.0.37 (02-Jun-2015)

Added 'Rules Method' and 'Instalment Method' for extra detail when uploading Credit Memos.

7.0.36 (18-May-2015)

All Special Validation DFFs are now loaded through direct table updates.

7.0.35 (14-May-2015)

Fixed bug with DKFF update where values were sometimes assigned to the wrong attributes.

7.0.34 (13-May-2015)

Credit Reason is now loaded through table updates.

7.0.33 (06-May-2015)

WIP - Implementing DKFFs for customer.

7.0.32 (06-May-2015)

New Package Spec Required (1.1.3).
DFFs are now available for Applied Credit Memos.

7.0.31 (28-Apr-2015)

Improved Memo Line SQL.

7.0.30 (28-Apr-2015)

Bill to Address and Ship to Address now pass to bill_to_address_id and ship_to_address_id in the API.

7.0.29 (22-Apr-2015)

Broke down the SQL as a customer was having problems with the check_access function in the AR_MEMO_LINES_VL view.

7.0.28 (21-Apr-2015)

Fixed error in above change where memo lines distributions would always have their totals checked.
Changed Memo column to a searchable field on the form for large lists.

7.0.27 (26-Mar-2015)

You can now use direct distribution DFF updates without a memo line.

7.0.26 (18-Mar-2015)

Fixed Excel 2003 Validate_Option bug.

7.0.25 (13-Mar-2015)

Cleaned up workbook styles.

7.0.24 (06-Mar-2015)

Added new column Dist Comments.

7.0.23 (05-Mar-2015)

Changed documentation links to API version.

7.0.22 (05-Mar-2015)

Fixed problem with Dist DFF update where multiple attributes would add multiple "set" keywords.

7.0.21 (04-Mar-2015)

Added direct table updates to Dist DFFs for memo lines when only DFF data is entered in distributions.

7.0.20 (09-Feb-2015)

Added profile option "More4Apps: RIW Use AutoAccounting to Generate Memo Line Account" for auto memo distributions.
Added warning message for success/failed distribution generation.
Fixed unit price and quantity bugs in Total Amount Validation.
Fixed distribution DFF not writing back values in correctly.

7.0.19 (27-Jan-2017)

Changed Accounting Rule SQL to be more in line with the Oracle form trace.

7.0.18 (05-Feb-2015)

During Upload, only pass up the customer_id from the Customer Name if the Customer Number has no value. This is to prevent the ID being over-written with an incorrect ID. This can happen if the Customer Name is a duplicate.
Distributions are no longer required if you only have DFF data in the section and it's a memo line. Dist defaulting still needs to be added.

7.0.17 (20-Jan-2015)

Fixed validation for Total Amount column.

7.0.16 (19-Jan-2015)

Fix for non-numeric character error.

7.0.15 (15-Jan-2015)

Changed the Master Org SQL.

7.0.14 (15-Dec-2014)

Modified download for performance reasons.

7.0.13 (11-Nov-2014)

Modified precision validation.

7.0.12 (10-Dec-2014)

Double-click now correctly says "row 11 or below" instead of "row 10 or below".

7.0.11 (01-Dec-2014)

Added missing columns to Template123 sheet and Example sheet.
Added default 'Sheet1' from 7.0.0
Fixed bug where Accounting Rule would be invalid whenever the line type wasn't LINE.
Renamed 'Line Item' to 'Line Number'.
Renamed 'Payment Reason' to 'Line Reason'.

7.0.10 (27-Nov-2014)

Added 'Payment Reason' column.

7.0.9 (21-Nov-2014)

Check credit invoice column exists before retrieving.

7.0.8 (18-Nov-2014)

Added colouring and comments for row 10 defaults.

7.0.7 (14-Nov-2014)

Added checks in implementation for null columns when adding dependency due to new dependence changes.

7.0.6 (13-Nov-2014)

Carrier – Fixed SQL Validation.

7.0.5 (11-Nov-2014)

Updated Exchange Rate SQL.
Fixed bug in Accounting Validation as a result of the new dependence.

7.0.4 (03-Nov-2014)

Changed Login method to 'Standard Login' it was on SSO Bypass.

7.0.3 (03-Nov-2014)

Special version for Website (see details below). This version is based on version 7.0.0 not 7.0.2
Fix for handling long columns in EBS 12.1.*. NB Previous fix for 12.2 broke some EBS 12.1.* instances
Some versions of 12.1.* will error with: oracle.xml.sql.OracleXMLSQLException: Stream has already been closed
Does not affect 11.5.10 or 12.2.

7.0.2 (12-Sep-2014)

Updated Common Modules 009

7.0.1 (12-Sep-2014)

Fixed bug in Alias for key flexfield

7.0.0 (28-Aug-2014)

Initial release of AR Invoice Wizard that uses APIs instead of the AutoInvoice interface tables to create transactions in real-time