3.4.32 (26-Nov-2024)

Adjustment mode: Fixed VBA error when opening form.

3.4.31 (22-Nov-2024)

Internal bug fix.

3.4.30 (15-Oct-2024)

Added Default Browser Login option.

3.4.29 (30-Sep-2024)

Refund Attributes - Fixed errors when removing Refund Customer Name/Address columns.

3.4.28 (27-Sep-2024)

Refund Attributes - Moved to end of section on sheet.

3.4.27 (24-Sep-2024)

Refund Attributes - Pay alone defaults to No on upload if not provided.

3.4.26 (19-Sep-2024)

Fixed SQL error on Pay Group validation.

3.4.25 (19-Sep-2024)

Fixed SQL error on download (non refunds), added alphabetical sorting to refund LOVs.

3.4.24 (13-Sep-2024)

Added Refund Attributes (Create/Apply modes).

3.4.23 (06-Aug-2024)

Cleaned value from Customise Fields.

3.4.22 (06-Aug-2024)

Fixed Digital Signature breaking when modifying Template123.

3.4.21 (18-Mar-2024)

Fixed error when selecting Tax Code with a '%'.

3.4.20 (18-Dec-2023)

Fixed issue where an end to end trace might not return the SQL statement's execution plan.
Updated Product Install File (ARW_install.zip) to include Extension Package functionality.

3.4.19 (22-Nov-2023)

Fixed Transaction Number Query when 'Allow Payment of Unrelated Customers' is disabled.

3.4.18 (16-Nov-2023)

Fixed Unapply not returning a status for first record.

3.4.17 (13-Nov-2023)

Improved Transaction Number Query.

3.4.16 (03-Oct-2023)

Fixed APIs being skipped for activity applications.

3.4.15 (01-Aug-2023)

Fixed upload error for On Account Receipts.

3.4.14 (01-Aug-2023)

Fixed Customer Name when downloading via transaction.

3.4.13 (28-Jul-2023)

Fixed Customer Name when downloading via transaction.

3.4.12 (19-Jul-2023)

Fixed Applications not downloading when they have no override Customer.

3.4.11 (18-Jul-2023)

Fixed Customer Name/Override Customer Name returning only 50 characters on download.

3.4.10 (06-Jun-2023)

Internal update.

3.4.09 (28-Mar-2023)

Fixed Adjustments not returned adj Number.

3.4.08 (16-Mar-2023)

Fixed Adjustments not returning successful ID/Status.

3.4.07 (09-Mar-2023)

Internal update.

3.4.06 (27-Feb-2023)

Fixed error when downloading Receipt with new servlet.

3.4.05 (03-Feb-2023)

Fixed ribbon Logging button showing code instead of label.

3.4.04 (27-Jan-2023)

Internal update.

3.4.03 (23-Jan-2023)

Internal update.

3.4.02 (23-Jan-2023)

Fixed extension package not recognising currency Code/Payment Method/Bank Account.

3.4.01 (15-Dec-2022)

Internal update.

3.4.00 (09-Dec-2022)

Internal update.

3.3.13 (02-Dec-2022)

Internal update.

3.3.12 (02-Dec-2022)

Fixed Receipt Number clearing on upload error.

3.3.11 (01-Dec-2022)

Fixed Receipt Number clearing on upload error.

3.3.10 (30-Nov-2022)

Fixed Misc Receipt data not being used in extension package.

3.3.09 (30-Nov-2022)

Fixed upload error.

3.3.08 (02-Nov-2022)

Internal update.

3.3.07 (19-Oct-2022)

Updated extension package error message.

3.3.06 (19-Oct-2022)

Modified extension package available parameters.

3.3.05 (07-Oct-2022)

Internal update.

3.3.04 (03-Oct-2022)

Fixed extension package writing back errors as Accepted.

3.3.03 (28-Sep-2022)

Fixed extension package results showing as errored, fixed Create_misc error on upload.

3.3.02 (22-Sep-2022)

corrected upload issue with new extension package upload rewrite when using extension package.

3.3.01 (13-Sep-2022)

Corrected upload issues with new extension package upload rewrite.

3.3.00 (12-Sep-2022)

Added Extension Package for Receipt uploads.

3.2.96 (01-Aug-2022)

Fixed spelling of Denormalize Data and Normalize Data for the 'Format Data' icon on the ribbon.

3.2.95 (20-Jul-2022)

Fixed VBA error when uploading adjustments on an installment.

3.2.94 (20-Jul-2022)

Fixed VBA error when uploading adjustments on an installment.

3.2.93 (20-Jul-2022)

Fixed compile error in upload.

3.2.92 (18-Jul-2022)

Fixed Adjustments applying to the wrong invoice.

3.2.91 (06-Jul-2022)

Internal update.

3.2.90 (04-Jul-2022)

Fixed error when creating new sheet.

3.2.89 (30-Jun-2022)

Internal bug fix.

3.2.88 (29-Jun-2022)

Fixed SQL error when using Apply.

3.2.87 (29-Jun-2022)

Added p_called_from to Apply, apply_in_detail and apply_on_account API calls. Fixed Issue with attachment form.

3.2.86 (29-Jun-2022)

Added p_called_from to Create_cash and Create_misc API calls.

3.2.85 (28-Jun-2022)

Enhanced Transaction Number Query efficiency.

3.2.84 (21-Jun-2022)

Fixed Bank Account Query default value invalid when no Receipt Date provided.

3.2.83 (07-Jun-2022)

Internal update.

3.2.82 (10-May-2022)

Internal update.

3.2.81 (28-Mar-2022)

Custom Query SQL Injection update.

3.2.80 (09-Mar-2022)

Bill to Location is no longer required when System Setting "Require Billing Location for Receipts" is set to Yes.

3.2.79 (04-Mar-2022)

Internal update.

3.2.78 (15-Dec-2021)

Fixed GL Accounts ID error.

3.2.77 (25-Nov-2021)

Fixed Cross Currency API error.

3.2.76 (06-Sep-2021)

Fixed columns shipping 0's when defaulting a value (e.g. Bank Account).

3.2.75 (18-Aug-2021)

Corrected Transaction Number SQL Query.

3.2.74 (04-Aug-2021)

Internal update.

3.2.73 (16-Jul-2021)

Customer LOVs now return inactive customers.

3.2.72 (05-Jul-2021)

Added Download filter clear message box popup after Download via Sheet.

3.2.71 (02-Jul-2021)

Fixed bug with Download by Sheet (Transaction).

3.2.70 (15-Jun-2021)

Download by sheet now inserts a row before printing results.

3.2.70 (15-Jun-2021)

Download by sheet now also inserts a row before printing results.

3.2.69 (15-Jun-2021)

Updated security.

3.2.69 (15-Jun-2021)

Updated security.

3.2.68 (15-Jun-2021)

Fixed Licence Security issue.

3.2.67 (13-May-2021)

Fixed Bank Charges not uploading decimal values.

3.2.66 (07-May-2021)

Fixed Error when uploading after 10 in trial mode.

3.2.65 (05-May-2021)

Download by sheet now starts inserting downloaded rows below selected cells.

3.2.64 (27-Apr-2021)

Fixed Bank Charges not appearing for All Columns. Correct Bank Charges form placement.
Fixed Apply Amount defaulting error when Bank Charges not populated.

3.2.63 (21-Apr-2021)

Increased performance with Transaction Number validation.

3.2.62 (16-Apr-2021)

Fixed another validation error when Bank Charges is blank.

3.2.61 (16-Apr-2021)

Fixed validation error when Bank Charges is blank.

3.2.60 (14-Apr-2021)

Fixed Misc Receipt upload error when trying to use Bank Charges column.

3.2.59 (12-Apr-2021)

Corrected Bank Charges formatting and heading color default.

3.2.58 (09-Apr-2021)

Added Bank Charges column to Receipt section.

3.2.57 (31-Mar-2021)

Fixed error when multiple On Account Unapplications on same Receipt.

3.2.56 (08-Mar-2021)

Updated security.

3.2.55 (12-Feb-0021)

Updated security.

3.2.54 (09-Feb-2021)

Improved Transaction Number further.

3.2.53 (05-Feb-2021)

Improved performance of Transaction Number.

3.2.52 (27-Jan-2021)

Added ApplRefNum to Receipt/Application form.

3.2.51 (26-Jan-2021)

Updated Appl Ref Num colouring on example sheets.

3.2.50 (26-Jan-2021)

Fixed DFF defaulting error with multiple rows.

3.2.49 (26-Jan-2021)

Fixed Default Row 10 not identifying formulas with blank result.

3.2.48 (26-Jan-2021)

Fixed DFF attributes not defaulting on defaulted values.

3.2.47 (25-Jan-0021)

Fixed DFF attribute defaulting error.

3.2.46 (22-Jan-2021)

Added Application Ref Number to upload. Fixed issues with default row 10.

3.2.45 (15-Jan-2021)

Fixed Flex dependencies with no LOV Value set.

3.2.44 (13-Jan-2021)

Added :APP_MAIN>CUSTOMER_ID form reference.

3.2.43 (02-Dec-2020)

Updated security.

3.2.42 (11-Nov-2020)

Fixed Location Query not returning locations based on inactive status.

3.2.41 (10-Nov-2020)

Corrected Receipt Customer Query to allow inactive Site uses. Added System Parameter validation for Site Required setting.

3.2.40 (04-Nov-2020)

Added Receipt Status to Receipt Download form.

3.2.39 (03-Nov-2020)

Updated security.

3.2.38 (24-Sep-2020)

Fixed Setup Toolbar hide on startup showing after logging in.

3.2.37 (14-Sep-2020)

Now always checks Responsibility function for upload.

3.2.36 (07-Sep-2020)

Added ability to process Adjustments with Adjustment function access.

3.2.35 (03-Aug-2020)

Updated security.

3.2.34 (22-Jul-2020)

Added error when trying to upload downloaded adjustments.

3.2.33 (09-Jul-2020)

Updated security.

3.2.32 (16-Jun-2020)

Fixed Upload error when using invalid Receipt Amount.

3.2.31 (15-Jun-2020)

Fixed Receipt Amount erroring with invalid numerical value.

3.2.30 (05-Jun-2020)

Fixed Upload error when Adjusting.

3.2.29 (05-Jun-2020)

Receipt Number LOV no longer returns Reversed Receipts.

3.2.28 (21-May-2020)

Fixed SQL error when using Apply Activity.

3.2.27 (15-Apr-2020)

Fixed Transaction Number not returning Invoices that have had its first installment paid.

3.2.26 (15-Apr-2020)

Internal update.

3.2.25 (14-Apr-2020)

Internal update.

3.2.24 (08-Apr-2020)

Fixed issue of getting 'Subscript out of range' error when changing action mode after changing Secure Modes.

3.2.23 (07-Apr-2020)

Handle error after removing Template123 sheet.

3.2.22 (03-Apr-2020)

Fixed Application Lines not coloring in on upload.

3.2.21 (02-Apr-2020)

Fixed Application DFFs coloring in as uploaded despite no data to upload.

3.2.20 (31-Mar-2020)

Fixed error when applying Lines.

3.2.19 (30-Mar-2020)

Fixed error when applying Lines.

3.2.18 (25-Mar-2020)

Fixed some columns not coloring for upload.

3.2.17 (17-Mar-2020)

Fixed error messages not returned in bold format.

3.2.16 (16-Mar-2020)

Added skipping the More4apps servlet error message if Servlet checking returns 400(bad request) as in a small chance it returned 400 error with properly installed Servlet.

3.2.15 (16-Mar-2020)

Fixed error messages not returning in bold format.

3.2.14 (11-Mar-2020)

Updated logic causing errors when duplicate LOV results are case insensitive.

3.2.13 (11-Mar-2020)

Added function to handle European decimal standard when applying to a receipt.

3.2.12 (10-Mar-2020)

Added Exception handling to receipt upload, tidied Template123 formatting.

3.2.11 (06-Mar-2020)

Fixed error messages not returning in bold format.

3.2.10 (05-Mar-2020)

Fixed Mismatch Error when automatically allocating to On Account.

3.2.09 (04-Mar-2020)

Refreshed Code Line Numbers.

3.2.08 (02-Mar-2020)

Fixed New Sheet button not working for 'All Columns'.

3.2.07 (02-Mar-2020)

Updated security.

3.2.06 (27-Feb-2020)

Updated with new color formatting.

3.2.05 (26-Feb-2020)

Fixed error when Misc Comment has 'invalid' characters for upload.

3.2.04 (07-Feb-2020)

Increased error readability for apply to account errors.

3.2.03 (05-Feb-2020)

Increased error readability for cases where Upload errors.

3.2.02 (24-Jan-2020)

Fixed issue where Activity would show Activities from other Operating Units.

3.2.01 (03-Dec-2019)

Customer Number column is now mandatory for all modes except Adjustment.

3.1.45.27 (27-Nov-2019)

Fixed certain columns not being created despite user selection in Customize Columns form.

3.1.44.27 (26-Nov-2019)

Fixed Receipt ID being required for validation.

3.1.43.27 (22-Nov-2019)

Receipt ID is now mandatory for Create mode.

3.1.42.27 (20-Nov-2019)

Fixed Accepted not printing to templates without ID/Number columns.

3.1.41.27 (15-Nov-2019)

Fixed ribbon not always updating when logging in.

3.1.40.27 (15-Nov-2019)

Added Example sheet for Apply mode.

3.1.39.27 (15-Nov-2019)

Fixed Line Level applications not returning errors or IDs.

3.1.38.27 (13-Nov-2019)

Fixed Line Application errors.
Fixed invalid Unapply/Apply Upload messages not being returned to sheet.

3.1.37.27 (11-Nov-2019)

Fixed incorrect error when miscellaneous amount adds up to exactly receipt amount.

3.1.36.27 (05-Nov-2019)

Fixed receipt validation error with invalid date.
Fixed issue when applying duplicate lines with the same receipt.

3.1.35.27 (05-Nov-2019)

Fixed incorrect error messaging when applying to lines and invoices at the same time.
Fixed error when applying lines to multiple invoices for the same Receipt.
Removed Customer Reason from Adjustment Mode sheet.

3.1.34.27 (25-Oct-2019)

Fixed error when applying a Receipt to multiple different Invoices.

3.1.33.27 (25-Oct-2019)

Fixed error when Receipt Type column removed while in Create mode.

3.1.32.27 (24-Oct-2019)

Made Payment method dependent on Receipt Type.

3.1.31.27 (23-Oct-2019)

Receipt Form tab order and validation order fixed.

3.1.30.27 (23-Oct-2019)

Payment Method is now dependent on Currency Code. Receipt Form has been rearranged to reflect this.

3.1.29.27 (21-Oct-2019)

Bank Account is now dependent on Currency Code.

3.1.28.27 (07-Oct-2019)

Added ability to filter with wildcards (Custom Query).

3.1.27.27 (19-Sep-2019)

Fixed Override Customer Number/Name labels in forms.

3.1.26.27 (17-Sep-2019)

Provided ability to upload Adjustments via Adjustment mode on a Create sheet.

3.1.25.27 (09-Sep-2019)

Fixed Customer Number being required when a previous row had a Customer Name.

3.1.24.27 (05-Sep-2019)

Fixed issue with Customer Numb er being invalid without a reason.

3.1.23.27 (04-Sep-2019)

Customer Number must now exist on sheet for Create mode and is now required when a Cust Name exists.

3.1.22.27 (29-Aug-2019)

Fixed SQL upload error when Applying.

3.1.21.27 (29-Aug-2019)

Fixed non Attachment columns validating when Attachment upload.

3.1.20.27 (19-Aug-2019)

Fixed error in upload when Installment column is removed.
Appl ID now shows receivable_application_id rather than Cash_receipt_id.

3.1.19.27 (01-Aug-2019)

Fix for potential memory leak issue when uploading bulk data.

3.1.18.27 (22-Jul-2019)

Made Adjustment Activity required for upload.

3.1.17.27 (15-Jul-2019)

Fixed error when invalid date was selected in Apply mode.

3.1.16.27 (02-Jul-2019)

Fixed error when processing with multiple sheets selected.
Fixed Application section uploading when Miscellaneous transaction.
Fixed error when uploading Invoice Number with special characters.
Fixed various number errors occurring when using european decimals.

3.1.15.27 (02-Jul-2019)

Now clear [X] when trying to open sections that are not available.

3.1.14.27 (02-Jul-2019)

Fixed Attachment ribbon button. Added validation to restrict Attachment Sequence Number.

3.1.13.27 (19-Jun-2019)

Fixed error when validating in Adjustment mode.

3.1.12.27 (11-Jun-2019)

Corrected colours when validating blank values.

3.1.11.27 (07-Jun-2019)

Fixed error when uploading Attachments.
Added message to long text download (was previously just 'Long Text').

3.1.10.27 (07-Jun-2019)

Fixed overflow error when validating.

3.1.09.27 (06-Jun-2019)

Updated colours of Wizard to cater to new design.

3.1.08.27 (05-Jun-2019)

Customer Number no longer mandatory for Crete mode (for Misc Transactions).

3.1.07.27 (24-May-2019)

Added maximum length for Reference column.

3.1.06.27 (21-May-2019)

Fixed issue where Instrument LOV would show instruments for manual Payment Method types.

3.1.05.27 (15-May-2019)

Added new functionality for encoding SQL when encountering troublesome Firewalls.

3.1.05 (14-May-2019)

Added Logging and Help buttons to the ribbon.

3.1.04.26 (03-May-2019)

Fixed Override Customer Number error when duplicate Override Customer Names exist.

3.1.03.26 (05-Apr-2019)

Fixed SQL error in R11i when creating Receipts.

3.1.02.26 (28-Mar-2019)

Removed Receipt default customisation for Agility.

3.1.01.26 (13-Mar-2019)

Fixed Instrument API returning messages twice.

3.1.00.26 (13-Mar-2019)

Enabled Receipt Default customization for Agility.

3.0.97.26 (22-Jan-2019)

Corrected error when entering a new grid row with a formula in Default row.

3.0.96.26 (21-Jan-2019)

Updated security.

3.0.95.26 (21-Jan-2019)

Fixed SQL error when defaulting Bill to Location.

3.0.94.26 (18-Jan-2019)

Fixed issue with Bill to Location returning locations from other operating units.

3.0.93.26 (27-Dec-2018)

Fixed error when doing receipt write-offs if using a comma as the decimal symbol.

3.0.92.26 (27-Dec-2018)

Fixed error when doing receipt write-offs if using a comma as the decimal symbol.

3.0.91.26 (22-Nov-2018)

Fixed issue where Customer Name defaulted from IdentifyBy column would truncate at 50 chars.

3.0.90.26 (30-Oct-2018)

Corrected error when Validating Tax code with an alphanumeric Receipt Amount.
Added Customer Number to Miscellaneous Receipt example worksheet.
Corrected Upload error when not including Customer Number column in sheet.

3.0.89.26 (26-Oct-2018)

Fixed Tax Code being unable to take a value.

3.0.88.26 (16-Oct-2018)

Updated security.

3.0.86.26 (09-Oct-2018)

Internal update.

3.0.86 (02-Oct-2018)

Added functionality for bypassing Firewall issues.

3.0.85 (25-Sep-2018)

Fixed Receipt Download Customer TO column returning no results.

3.0.84 (25-Sep-2018)

Fixed issue with Date format when selecting a date from a calendar.

3.0.83 (25-Sep-2018)

Now sort Receipt Download by Receipt Number.

3.0.82 (21-Sep-2018)

Added Creation Date/Created by User to Receipt Download Form.

3.0.81 (21-Sep-2018)

Fixed issue with Custom Query when filtering by child data

3.0.80 (12-Sep-2018)

Transaction Download Form - Customer filters are no longer dependent on each other.

3.0.79 (07-Aug-2018)

GL Date, Deposit Date and Maturity Date are now defaulted based on Receipt Date.

3.0.78 (01-Aug-2018)

Updated security.

3.0.77 (30-Jul-2018)

Slight database performance increase for bulk Applications.

3.0.76 (19-Jul-2018)

Fixed error in Outstanding balance with Installments.

3.0.75 (18-Jul-2018)

Corrected Transaction Number list of values to return seeded values (On Account etc).

3.0.74 (11-Jul-2018)

Fixed error when logging in to Adjustment mode.

3.0.73 (10-Jul-2018)

Fixed 64bit issue with download.

3.0.72 (05-Jul-2018)

Added Search control to Installment column for queries > 1000.
Sped up Invoice validation for invoices with many related instalments.

3.0.71 (04-Jul-2018)

Fixed Download Form not providing LOV data.

3.0.70 (04-Jul-2018)

Fixed error when opening Download Forms on a row 500 blank rows down.

3.0.69 (04-Jul-2018)

Fixed error when utilising Wizard in 64bit excel.

3.0.68 (02-Jul-2018)

Updated security.

3.0.67 (02-Jul-2018)

Fixed Upload issue when not installment controlled Invoice.

3.0.66 (29-Jun-2018)

Fixed issues encountered with Invoices using Installments.

3.0.65 (26-Jun-2018)

Fixed issue with Applying with no Cross Currency column.

3.0.64 (11-Jun-2018)

Updated security.

3.0.63 (05-Jun-2018)

Corrected 11i error when validation Invoice Number.

3.0.62 (29-May-2018)

No longer load Application Level column for R11.

3.0.61 (29-May-2018)

Fixed check for initialising Wizard in R11i environment.

3.0.60 (28-May-2018)

No longer added Line application section to validation if R11i.

3.0.59 (28-May-2018)

Fixed issue when user removes one of Application Line columns.
Fixed error in R11i when validating Invoice Number.

3.0.58 (25-May-2018)

Fixed error when validation with no Line section on sheet.

3.0.57 (24-May-2018)

Added error for line validation when amount is 0.

3.0.56 (23-May-2018)

Removed ability to halt upload on Invoices by setting amount of 0.

3.0.55 (23-May-2018)

Removed R11/R12 patch check.

3.0.54 (22-May-2018)

Apply/Unapply now leaves header section status column as validated instead of setting to Accepted when uploading.

3.0.53 (21-May-2018)

Added Ribbon and Toolbar options for Line Application section.

3.0.52 (21-May-2018)

Fixed occasionally VBA error when searching using Line Form after.
Fixed Invoice lines without tax not showing in validation.

3.0.51 (18-May-2018)

Renamed Line Amount Applied to Detail Amount to alleviate confusion about purpose (now includes tax amount).

3.0.50 (14-May-2018)

Fixed issue where removing Application Level column halts Line application validation.
Made Tax Line information appear in Line Number LOV.

3.0.49 (14-May-2018)

Added error when user does not have line information with Application Level of Line.

3.0.48 (09-May-2018)

Apply in detail Line section now shows Amount when invoice batch source used Generate Line Balances = No.
Apply in detail no longer defaults line amount.

3.0.47 (07-May-2018)

Corrected Application Level error messages.
Updated Example sheet Misc Distributions - removed irrelevant columns.

3.0.46 (18-Apr-2018)

Internal update.

3.0.45 (18-Apr-2018)

Internal update.

3.0.44 (16-Apr-2018)

Added Line Level application functionality.
Handle API error when Invoice was created in 11i environment.

3.0.43 (06-Mar-2018)

Updated Misc Receipts Sheet - removed unnecessary columns.
Fixed with Misc Receipts when using multiple distributions using Amount only.

3.0.42 (02-Mar-2018)

Added error handling for trying to access Global DFF in Adjustment mode.
Made (Appl Messages, Adj Date, Adj GL Date) Mandatory for Adjustment mode.

3.0.41 (02-Mar-2018)

Fixed error when clicking CalculateDiscount without Receipt section.
Modified GL Date Open Periods error to be less misleading.
Fixed issue when user removes all available sections using Secure Modes.

3.0.40 (27-Feb-2018)

Fixed error when opening Form in Apply mode on a Create sheet.

3.0.39 (27-Feb-2018)

Updated Security.

3.0.38 (27-Feb-2018)

Fixed error when trying to use Wizard with Responsibility without Receipt access in Adjustment mode.

3.0.37 (27-Feb-2018)

Fixed error searching Customer Number.
Added error message when trying to upload Attachments with no Receipt.

3.0.36 (26-Feb-2018)

Added Amount to default Unapply sheet.
Fixed Instrument required for receipts with no customer.
Now make Customer Required for Upload when selecting Automatic Payment Method.
Fixed error when selecting a number too large in Download form MaxRows.
Added default Row to frozen rows at top of worksheet.

3.0.35 (23-Feb-2018)

Fixed On Account upload not returning receipt ID when uploading the same row multiple times.
Helped to determine Unapply error 'Invalid Combination of Receipt Identifier and Application Identifier'.

3.0.34 (23-Feb-2018)

Fixed occasional error with Transaction Number SQL.

3.0.33 (22-Feb-2018)

New Package Version; Header 2.0.5, Body 2.1.7
Added functionality to On Account status upload (was not fully implemented and caused errors).
Fixed error with Instrument with no Currency code set.
Fixed Oracle error not returning from API.
Now check for Cross Currency when doing on Account receipt upload.

3.0.32 (20-Feb-2018)

Fixed Application Customer Name not validating correctly.
Made ApplActivity required if Transaction Number is not an Invoice or On Account.
Fixed Customer Being required for Misc Distributions etc.
Fixed SQL Error (number to date) with exchange rate.

3.0.31 (19-Feb-2018)

Corrected validation for Customer columns.

3.0.30 (14-Feb-2018)

Fixed Null error when opening Receipt form with different and valid Customer name/Number.

3.0.29 (06-Dec-2017)

Fixed error with Miscellaneous Receipt section missing.
Fixed error with invalid Payment Method.

3.0.28 (10-Nov-2017)

Bank Account field will no longer show Banks that have been end-dated.

3.0.27 (29-Sep-2017)

Fixed issue when Currency column removed.
Added right click support for forms.
Fixed error when opening form during Adjust Mode.

3.0.26 (28-Sep-2017)

Fixed MiscDist Form not writing non DFF data back to sheet after OK click.

3.0.25 (26-Sep-2017)

Fixed Misc Dist (and DFF) issues with multiple rows.

3.0.24 (18-Sep-2017)

Fixed Misc Dist DFF not uploading.
Corrected misleading error messages for Distribution Upload when Percent/Amount columns missing.

3.0.23 (14-Sep-2017)

Return only one Error when uploading Standard transaction with Misc DFF populated.
Fixed error when attempting upload with no Receipt Type column.

3.0.22 (13-Sep-2017)

Fixed error with Misc Dist Validation when entering invalid Amount value.

3.0.21 (06-Sep-2017)

Added error for Misc Dist section when data is entered with receipt Type of Standard.
Fixed error if user tried to enter text into Amount column.

3.0.20 (01-Sep-2017)

Fixed error with Activity showing required message twice.
Fixed error with Validating Misc Dist section with no Receipt Amount (or 0).

3.0.19 (31-Aug-2017)

Fixed issue where leaving one data column remaining on sheet would ignore section.

3.0.18 (31-Aug-2017)

Fixed issue with error appearing twice when data was present in Misc Dist section at the same time as DFF with an invalid setup.

3.0.17 (29-Aug-2017)

Added query to return currently installed Misc Dist Profile Name for clearer errors.
NEW PACKAGE VERSION: Header 2.0.4, Body 2.1.6
Fixed Wizard checking for Misc Dist results when none were uploaded.

3.0.16 (24-Aug-2017)

Fixed Upload issues with Misc Dist Percent/Amount columns.
Fixed issue with saving form data to sheet when opening form via ribbon.
Fixed inconsistency with Activity control erroring instead of becoming Required (yellow).

3.0.15 (22-Aug-2017)

Fixed error when downloading with Transaction Number column removed.
Various fixes for Miscellaneous Distribution functionality.

3.0.14 (18-Aug-2017)

Fixed AddBlankRow error when opening Misc Dist form with no Receipt information.
Fixed error while uploading after removing Misc Dist columns.
Now return Misc Percent error to Receipt section.

3.0.13 (16-Aug-2017)

Added Character Limit for Receipt Number (30).
Added Downloader to Wizard.

3.0.12 (09-Aug-2017)

Fixed issue with Misc Dist DFF form not showing all Segments.

3.0.11 (08-Aug-2017)

Fixed various Misc Dist errors.

3.0.10 (03-Aug-2017)

Tidied up auto generated Comments formatting.

3.0.09 (02-Aug-2017)

Fixed issue in Misc Dist upload when DFF section missing.
Tidied up Comments formatting.

3.0.08 (01-Aug-2017)

Fixed error in loading MiscDist form in 11i environment.
Now load MiscDist DFF page if attribute column selected for load.
Fixed Attributes not retaining their data on OK click.
Issue with Upload when not utilising MiscDist Data.

3.0.07 (13-Jul-2017)

Added fix for non-create modes error on initialisation.

3.0.06 (04-Jul-2017)

Corrected Package versioning: Current/Min Header 2.0.3 22 Jun 2017, Body 2.1.4 28 Jun 2017

3.0.05 (03-Jul-2017)

Updated Security.

3.0.04 (30-Jun-2017)

Added Miscellaneous Distribution functionality for R12 (only valid for patch 24375569).
New Package Version: Header 2.0.3, Body 2.1.4

3.0.03 (12-Jun-2017)

Updated Security.

3.0.02 (30-May-2017)

Added "Include Closed Transactions" to sheet download form popup.
Added Transaction Sheet download functionality for Apply/Unapply modes.

3.0.01 (29-May-2017)

Enabled Transaction Download from Sheet for Adjustment mode.
Moved "Include closed" checkbox to make it more obvious in Transaction Download form.

3.0.00 (25-May-2017)

Final version for release to Website

2.9.99 (16-May-2017)

Adjusted handling of adjustment defaulting when connection is slow.
Fixed opening the Download form from the default values row.
Handled when more than 2 errors are returned from API for a single section on a single row.
Fixed Adjustments getting ignored for upload during Create/Apply modes.
Fixed error when user tries to enter a large Max Rows in Download form.
Added Attachment upload procedures to right click context menu.

2.9.98 (15-May-2017)

Corrected order of transaction numbers when multiple returned.

2.9.97 (12-May-2017)

Enabled use of Refund activity for R12 EBS only.
New Package Version 2.1.3 Adds backwards compatibility.
Fixed no_data_found Error when uploading with an invalid Receipt Number.

2.9.96 (09-May-2017)

Updated Security.

2.9.95 (08-May-2017)

Added new Setup and Example sheets.

2.9.94 (05-May-2017)

Fixed error when searching for Transaction Number during Misc Receipts.
Corrected DFF ribbon button.

2.9.93 (26-Apr-2017)

Fixed error with blank Amount column.
Fixed error when loading Adjustment form.

2.9.92 (18-Apr-2017)

Fixed Outstanding Amount Column defaulting Transaction Number (or 0 if text based number).

2.9.91 (12-Apr-2017)

Fixed error in new Override Customer SQL when populated.
Various Fixes/Modifications to new Download forms.

2.9.90 (10-Apr-2017)

Modified error messages for Application section to avoid 'PROGRAM FAILED' ambiguity.
Modified Download buttons to provide popup form to choose form/sheet download. (Last chosen selection is remembered).
Modified Override Customer SQL to show all Customers with null Receipt Customer.

2.9.89 (10-Apr-2017)

Disabled Refund Activities from Transaction Number column.
Fixed Defaulting of invalid Transaction Number.
Fixed Exception: Block Completed Message during Create uploads.

2.9.88 (07-Apr-2017)

Renamed "Adj Status" Column to Adj Completion Status to avoid errors while using older templates.
Now Error application rows with Amount Applied of 0 to ensure an explanation for records that didn’t get uploaded.
Fixed Appl Identify By Column opening Application Form instead of Receipts Form during create mode.

2.9.87 (05-Apr-2017)

New Minimum Package Version 2.1.2 - Modify Error messages returned to sheet (No more "Program Failed").
Made Override Customer Dependent on Receipt customer to ensure only correct Transaction Numbers could be selected.

2.9.86 (03-Apr-2017)

Updated Security.

2.9.85 (22-Mar-2017)

Fixed Apply Upload error when using European decimal Standard.
Corrected Application Amount Default truncating decimal values in European format.

2.9.84 (21-Mar-2017)

Fixed potential errors with decimal defaulted value on a system using comma decimal formatting.
Fixed "Unrelated" Invoice search not returning Seeded LOV values (On Account, Refund etc).

2.9.83 (17-Mar-2017)

Fixed "Type Mismatch" error when uploading Application data.
Fixed SQL error when tabbing out of Transaction Number field in form (instead of purposely searching).

2.9.82 (15-Mar-2017)

Fixed error when validating Outstanding Balance using comma based decimals in older versions of excel.

2.9.81 (15-Mar-2017)

Fixed error when validating application data during Adjustment Mode.

2.9.80 (13-Mar-2017)

Fixed error on Application Upload: Invalid combination of the customer trx id and instalment.

2.9.79 (23-Feb-2017)

Fixed the issues where users are being logged in with the wrong language and not able to select a language from the EBS Browser Login page. Overrides the language selected on the Login Page to the user's EBS preferences default language. Caused by an EBS 12.2 framework patch.
Note – Loss of Functionality. This now means users cannot change languages if they want to.

2.9.78 (09-Mar-2017)

Fixed Related customers not showing if pay unrelated invoices disabled.
Fixed error in Transaction Number SQL.

2.9.77 (08-Mar-2017)

Fixed Related customers not showing if Pay unrelated Invoices enabled but have an Override Customer.

2.9.76 (07-Mar-2017)

Fixed error when validating unapplied field when Header amount is blank.
Modified Transaction Number column to increase LOV populating speed.

2.9.75 (28-Feb-2017)

Fixed issue with Unapply Mode Upload.

2.9.74 (27-Feb-2017)

Corrected Adjustment status returning to Comments column.

2.9.73 (24-Feb-2017)

Added Read only Adjustment Status column - Renamed Adjustment Upload Status column to "Adj Upload Status".

2.9.72 (23-Feb-2017)

Added defaulting to Adjustment Date columns when Adj Amount has a value.

2.9.71 (21-Feb-2017)

Fixed issue where forms would run validation for each time form had been opened.

2.9.70 (17-Feb-2017)

Fixed defaulting error with Amount Applied returning "0".

2.9.69 (13-Feb-2017)

Fix for Validation Error while in Apply/Unapply mode.
Fix for Apply Uploads with a blank Unapplied Amount.
Fixed Issue with removed Override Customer Columns when Pay Unrelated Flag is disabled.

2.9.68 (09-Feb-2017)

Fixed error 5 bug when uploading Adjustment data.

2.9.67 (02-Feb-2017)

LOV for Activity is no longer available during Standard Transactions (Only MISC).
Fixed bug where trying to prepare a sheet after having used adjustment mode.'
Fixed Issue where downloading a single transaction would immediately delete the data.

2.9.66 (27-Jan-2017)

Fixed Misc DFF uploading to wrong columns when there were columns missing from sheet.

2.9.65 (27-Jan-2017)

Fixed issue with removing Applications section for MISC receipt uploads.

2.9.64 (26-Jan-2017)

Fixed Attachment form right click toolbar error.
Fixed error with Attaching Attachments to MISC receipts.

2.9.63 (09-Jan-2017)

Added TRX number Dependency to Application Activity to ensure correct type is chosen.

2.9.62 (22-Dec-2016)

Fixed error when Consolidated Billing Number or Instalment columns are removed from sheet.

2.9.61 (01-Dec-2016)

Modified Receipt form to show Address when a Location is selected.

2.9.60 (25-Nov-2016)

Fixed error in Adjustment Mode when opening form.
Attachments error when they are removed from any mode but Create.
Grids on forms now start from selected row instead of top of section.

2.9.59 (23-Nov-2016)

Fixed ID and number columns being coloured incorrectly.
Fixed row error messages when Amount applied is set to 0 (designed to ignore on upload).
Application section Read only columns now retain correct colouring.
Fixed SQL error when opening form in Apply mode.
Fixed colour issue for Appl Ref Num.

2.9.58 (17-Nov-2016)

Added ability for Txn download to retain amount values.
Fixed issue where download with no results will cause an error.

2.9.57 (16-Nov-2016)

Fixed issue with Receipt Number not defaulting when in manual numbering.
Fixed Accepted appearing on row 40 every time.

2.9.56 (16-Nov-2016)

Fixed error encountered when Transaction Number column missing, fixed sheet formatting issue when downloading more than the pre-formatted cells.

2.9.55 (14-Nov-2016)

Fixed lag with Txn download, now allow for Transaction Number only, populating a Customer is optional.

2.9.54 (09-Nov-2016)

Enforced download Transactions to require Transaction Num and a Customer column (any of header or override columns).
Fixed issue with Open Txn download moving data to the right.

2.9.53 (04-Nov-2016)

Handled errors appearing when using Adjustment section for download/upload.
Added Override Customer columns to all download selected modes to avoid any confusion.
Fixed Transaction download overwriting un-downloaded header information.
Fixed issue with downloading Lines using sheet download.
Adjustments are now only downloaded during Adjustment Mode(affects sheet download only).

2.9.52 (02-Nov-2016)

Fixed selected downloaded rows being inserted as blanks below download results for Transaction download.

2.9.51 (02-Nov-2016)

Fixed errors with missing Instalment Consolidated Billing and Transaction Number.

2.9.50 (02-Nov-2016)

Fixed errors with missing Customer columns (Both CustNumber and CustName).

2.9.49 (31-Oct-2016)

Fixed SQL error when selecting a Transaction Number.
Fixed error with Transaction download when Customer columns are missing.

2.9.48 (27-Oct-2016)

Transaction download copies Override customer data into Header Customer columns (where available).
Prevent Transaction Download when invalid criteria supplied (Customer and Txn Number Must be populated for all selected rows).
Added Format Data (Normalise/Denormalise) to ribbon.

2.9.47 (20-Oct-2016)

Removed download criteria duplicating for Transaction downloads.

2.9.46 (14-Oct-2016)

Fixed error encountered in 11i when validating Payment Method column.

2.9.45 (12-Oct-2016)

Added new functionality for Header Attachments for Create mode.

2.9.44 (07-Oct-2016)

Added new download option (Open Transaction via Sheet).
Corrected "A party context attribute is missing, or does not have referential integrity with its source table" error when uploading Instrument.
Fixed error when selecting a text based Transaction Number.

2.9.43 (05-Oct-2016)

Fixed issue with Instruments not showing up for a selected Customer.

2.9.42 (28-Sep-2016)

Upload now only runs Transaction Extension API for Create types.

2.9.41 (28-Sep-2016)

Instrument now downloads with Create download.

2.9.40 (21-Sep-2016)

Currency Code is now always required.

2.9.39 (21-Sep-2016)

Added defaulting to Currency and Bill to location fields.

2.9.38 (16-Sep-2016)

Modified Instrument to show Customer level Instrument with Blank Location.
Made Instrument and Currency Fields required depending on the Payment Method.

2.9.37 (16-Sep-2016)

Fixed issue with Instrument validation when payment method is blank.

2.9.36 (15-Sep-2016)

Corrected Credit Card based Receipt issue with instrument.

2.9.35 (14-Sep-2016)

Fixed Instrument error not getting returned to sheet. Now returns Oracle API error.
Handled error for selecting Payment method with a Payment Channel with no value in BillToLocation.

2.9.34 (05-Sep-2016)

Updated Security.

2.9.33 (08-Aug-2016)

Fixed issue where related customer Transactions were unable to be selected in Transaction Number Column.

2.9.32 (01-Aug-2016)

Added error for attempting to apply receipts that have been reversed.
Fixed bug in sheet that would cause the scroll bar to move too fast.

2.9.31 (29-Jul-2016)

Fixed problem where invoice numbers were not considered valid for related customers.

2.9.30 (15-Jul-2016)

Updated Security.

2.9.29 (08-Jun-2016)

Zero balance due invoices can now be downloaded in any mode.

2.9.28 (07-Jun-2016)

Adjustments can now be made to 0 balance due invoices.

2.9.27 (31-May-2016)

Fixed Type Mismatch error when validating amount if non-numeric values were entered.
Removed use of chunk validation for transaction numbers in attempt to improve performance.

2.9.26 (27-May-2016)

Transaction numbers are now validated one at a time instead of in chunks of five to avoid timeouts.

2.9.25 (23-May-2016)

Updated Security.

2.9.24 (22-Apr-2016)

Fixed Query for Locations that use 'P' instead of 'Y' for BillTo Flag.

2.9.23 (30-Mar-2016)

Fixed XML Parse error on upload when trying to create and apply at the same time.

2.9.22 (24-Mar-2016)

Further improvements to the Transaction Number performance.
Fixed XML Parse Error when loading applications.

2.9.21 (16-Mar-2016)

Fixed errors (Error 457) when loading Applications when certain columns were removed from the sheet.
Improved the performance of validating/searching the Transaction Number.

2.9.20 (15-Mar-2016)

Fixed upload issues when trying to Create/Apply/Adjust in the same upload.

2.9.19 (03-Mar-2016)

Internal fix.

2.9.18 (25-Feb-2016)

Fixed issue where global DFF dates were being uploaded incorrectly.

2.9.17 (18-Feb-2016)

Fixed error when applying transactions where the transaction number is too long causing 'string buffer too small' error.

2.9.16 (11-Feb-2016)

Improved the performance of validating Instrument.

2.9.15 (11-Feb-2016)

Fixed timeout when validating multiple transaction numbers.

2.9.14 (22-Jan-2016)

Fixed Adjustment downloads duplicating when related customers exist.
Fixed download Open Items not downloading when "Include Adjustments" checked and transactions have no adjustments.
The Invoice LOV on the download form now includes transactions with 0 balance due - in case someone wants to reverse adjustments.

2.9.13 (15-Jan-2016)

Adjustment download is now downloaded for Adjustment mode using selected customer/transaction number, criteria can also be specified for Adjustments in the open items form.

2.9.12 (05-Jan-2016)

Corrected download for Adjustment section.

2.9.11 (24-Dec-2015)

Added download for Adjustment section.

2.9.10 (23-Dec-2015)

Fixed bug where adjustments were not loaded with applications.
If Pay Unrelated Invoices flag is true then do not restrict the invoice LOV to the customer.

2.9.09 (22-Dec-2015)

Updated Security.

2.9.08 (24-Sep-2015)

Fixed 'Bill To Location' field which contained no values in the LOV.

2.9.07 (17-Sep-2015)

Fixed Transaction Date column causing excel to error when date is invalid.

2.9.06 (07-May-2015)

Corrected the use of the mandatory columns after the Common Code 012 update.

2.9.05 (06-May-2015)

Changed the Pre-Cache to use the validateColumn and the col.unique keys.

2.9.04 (05-May-2015)

Implemented the Pre-Cache for the transaction number.

2.9.03 (30-Apr-2015)

Updated the Common Code 012.

2.9.02 (16-Mar-2015)

Corrected error when the Misc Comment was present but not populated.

2.9.01 (16-Mar-2015)

Added the Misc Comment column. Profile controlled "More4Apps: ARW Activate Misc Distribution DFF".

2.9.00 (10-Mar-2015)

Ensure the set is only on the first line for the update of the Misc distribution DFF values.

2.8.99 (18-Feb-2015)

Moved 'Login' and 'About' to the top of the right click menu.
Removed Show/Hide Login Info from the right click menu.
Changed label from 'Download Data' to 'Download Receipt Data' on the right click menu.

2.8.98 (16-Feb-2015)

Fixed R11i issue with Receipt Download.

2.8.97 (13-Feb-2015)

Added the ability to add misc distribution DFF values. Profile controlled "More4Apps: ARW Activate Misc Distribution DFF".

2.8.96 (09-Feb-2015)

Updated to Common version 011 which implements the common stubs.

2.8.95 (09-Feb-2015)

Reinstated the receipt amount dependence for the tax code query.

2.8.94 (16-Jan-2015)

Removed receipt amount dependence from the 11i tax code query

2.8.93 (09-Jan-2015)

Fixed issue where DFFs being uploaded as numbers rather than text.

2.8.92 (13-Dec-2014)

If there is a parse error, then use the parent section to display error message.

2.8.91 (12-Dec-2014)

Removed the use of the RA_CUSTOMER_RELATIONSHIPS_ALL in the DownloadInvoice form.

2.8.90 (03-Dec-2014)

Changes the query on the Receipt Number to ensure loose dependence works when the customer_id is null.

2.8.89 (27-Nov-2014)

Ensure column exists before trying to use in upload code.

2.8.88 (26-Nov-2014)

Fixed dependence initialization to ensure dependence exists even if column removed.

2.8.87 (21-Nov-2014)

Add Org ID to Apply uploads for R12.

2.8.86 (14-Nov-2014)

Reinstated the PAY UNRELATED INVOICES check to allow them to pay any invoice.

2.8.85 (30-Oct-2014)

Added the column Refund Payment Terms.

2.8.84.3 (16-Dec-2014)

Fix for handling long columns in EBS 12.1

2.8.84 (23-Oct-2014)

Changed wording on right click menu from 'Mandatory Fields' to 'Customize Fields'

2.8.83 (13-Oct-2014)

Add bank account Id for use with form references in DFF download

2.8.82 (10-Oct-2014)

Ensure the parent section is set before trying to display the form from the ribbon
Default the Bank Account based on the Payment method
Use the receipt ID if it is available for application
Fixed the download of the receipt id

2.8.81 (08-Oct-2014)

Ensure the DFF is implemented before trying to display the form from the ribbon

2.8.80 (03-Oct-2014)

Changed the message when required columns missing from the sheet as per IEW solution that was implemented

2.8.79 (03-Oct-2014)

Fixed chunking problem when the receipt Id was lost when a new receipt was created

2.8.78 (03-Oct-2014)

Fixed the usage of the secure modes

2.8.77 (02-Oct-2014)

Make the Wizard work when the Override column is removed. The assumption made that they know what they are doing with it removed.

2.8.76 (02-Oct-2014)

Fixed problem when unapplying transaction using the generated sheet for the Unapply mode

2.8.75 (01-Oct-2014)

Added support for the Unapplied of an Electronic Refund

2.8.74 (29-Sep-2014)

New fix so DFF defaults are set

2.8.73 (26-Sep-2014)

Changed DFF code to support defaulting when form is opened

2.8.72 (25-Sep-2014)

Added Customer Reason column.

2.8.71 (10-Sep-2014)

Added support for :RGW_FOLDER.REMITTANCE_BANK_ACCOUNT_ID

2.8.70 (04-Sep-2014)

Updated ribbon core.

2.8.69 (01-Sep-2014)

Update the Common code to 009 - speed enhancements

2.8.68 (26-Aug-2014)

Added the globalDFF for Argentina

2.8.67 (21-Aug-2014)

Changed the validation of the GL Date as the SOB Id was causing an error

2.8.66 (20-Aug-2014)

Implemented the Invoice Claim for Trade Management

2.8.65 (20-Aug-2014)

Update the Common code to 007 - includes defaults line in Row 10

2.8.64 (14-Aug-2014)

Changed the Validation of the Invoice to reset Customer dependence for every line

2.8.63 (08-Aug-2014)

Fixed problem with the initialization of the Application DFF

2.8.62 (25-Jul-2014)

Fixed problem when duplicate receipt encountered for the same Customer

2.8.61 (25-Jul-2014)

Imported Core 209 plus the latest Common version

2.8.60 (10-Jul-2014)

Saved the Max Rows so that it is used during download selected

2.8.59 (02-Jul-2014)

Ensure the initialiseColumn call from DownloadSelected has isDownload = vbTrue

2.8.58 (26-Jun-2014)

Fixed order by on the invoice download to use the criteria determined by Order by Form

2.8.57 (19-Jun-2014)

Fixed error when the Unapplied Amount was missing from the sheet in Apply Mode

2.8.56 (03-Jun-2014)

Added the Refund Messages 1,2,3

2.8.55 (27-May-2014)

Added the Tax Code for Miscellaneous Receipts

2.8.54 (19-May-2014)

Fixed error when Application section removed during Create mode

2.8.53 (30-Apr-2014)

Do not remove the receipt information during a download selected in Apply mode

2.8.52 (08-Apr-2014)

Added support for refund application

2.8.51 (25-Mar-2014)

Fixed problem when Customer not selected in the download invoices form

2.8.50 (25-Mar-2014)

Ensure the row status is set as Valid when form activation takes place

2.8.49 (11-Mar-2014)

Fixed problem with the Download Invoice via form getting two order by clauses

2.8.48 (10-Mar-2014)

Changed the Download in Apply mode to use the Overrider Customer Name and Number
Added order by to the Download Selected for Invoices

2.8.47 (06-Mar-2014)

Added brackets to the DownloadSelected to ensure the OR runs across all the customer numbers in the criteria

2.8.46 (04-Mar-2014)

Raised a message when the user tries to download invoice while in the Unapply mode.

2.8.45 (28-Feb-2014)

Fixed problem with the Customer Name field on the DownloadInv form.
Added the common templating solution which includes the frmWizardColumns and frmNewWorksheet forms.

2.8.44 (17-Feb-2014)

The upload of the Application DFF was not working

2.8.43 (17-Feb-2014)

Fixed error in Download form when in Adjustment mode.

2.8.42 (12-Feb-2014)

Corrected the download via sheet when the Customer Name is used

2.8.41 (11-Feb-2014)

Corrected the Adjustment Download

2.8.40 (04-Feb-2014)

Changed invoice query to ensure related party and related customer invoices are returned

2.8.39 (23-Jan-2014)

Clear returnCall in AddRows and not ParseReturnString to ensure all applications get the receipt id during create mode

2.8.38 (17-Jan-2014)

Fixed problem with the exchange rate when using the Corporate and validation run twice and string comparison incorrect

2.8.37 (07-Jan-2014)

Changed Base Currency query to use Get_Cached(CG_OU_ID) instead of fnd_global.org_id;

2.8.36 (16-Sep-2013)

Add Interface DFF columns into the download

2.8.35 (27-Aug-2013)

Updated the Common code
Fixed problem when the Override Customer Name and Number removed from sheet

2.8.34 (24-Jul-2013)

Do not allow the download receipt during Adjustment mode.

2.8.33 (12-Jul-2013)

Changed the DefaultParent to use the EntitySearch list as per change to ValidatorLOV
Fixed bug where On Account sets the ReturnCall incorrecty causing Adjustments to fail

2.8.32 (11-Jul-2013)

Restored creating an ‘On Account’ using the receipt status.
Updated to core version 205.
Fixed a problem with an invalid receipt number during the Application mode.

2.8.31 (08-Jun-2013)

Added additional tests for non-numeric values in the ValidatorOutstandingBalances

2.8.30 (15-May-2013)

Implemented the timeout form functionality

2.8.29 (15-Apr-2013)

Updated common modules to include new processing form functionality

2.8.28 (10-Apr-2013)

Corrected spelling mistake in ribbon

2.8.27 (09-Apr-2013)

Fix for error’s when opening form on GL Date & Receipt Date columns and the ‘upload action’ is Apply

2.8.26 (08-Apr-2013)

Fix for error in Adjustment (Row 20)

2.8.25 (04-Apr-2013)

Fix frmDff loading incorrectly

2.8.24 (03-Apr-2013)

Forms now clear Grid/Events to nothing when exiting the form

2.8.23 (03-Apr-2013)

Added C_SYSDATE to exception handler in GetMainMultiCall

2.8.22 (03-Apr-2013)

Updated WGrid code to handle a grid having another grid as a child
Updated core code to 203.21, mainly so that we can use the timeout form functionality

2.8.21 (26-Jan-2013)

Added exception handler to GetMainMultiCall

2.8.20 (27-Dec-2012)

Added the Adjustment GL Code

2.8.19 (05-Dec-2012)

Fixed problem when receipt columns removed from the sheet

2.8.18 (29-Nov-2012)

Added Adj Number as return column

2.8.17 (16-Nov-2012)

Added Adjustment form
Added FINCHRG to Adjustment Types

2.8.16 (12-Nov-2012)

Added Download for Adjustment mode
Added Adj Reason Code and Adj Comments Columns

2.8.15 (07-Nov-2012)

Added Adjustment mode to allow invoice adjustments without requiring an application

2.8.14 (02-Nov-2012)

Fixed problem with data only storing the first value when column sql returns more than one value

2.8.13 (19-Oct-2012)

Added Appl Identify By so that client can determine Override Customer using the Invoice Number
Added Appl Amount check to the consolidated Billing Application

2.8.12 (11-Sep-2012)

Added ribbon

2.8.11 (23-Aug-2012)

Fixed problems associated with the introduction of latest common code

2.8.10 (06-Aug-2012)

Removed the use of the RA_CUSTOMER_RELATIONSHIPS_ALL

2.8.09 (31-Jul-2012)

Fixed problem with Exchange validation when control is deactivated

2.8.08 (15-Jun-2012)

Restored default customer name based on identify column

2.8.07 (15-Jun-2012)

Fixed problem with Validator Outstanding where the balance was not being set Wizard Version

2.8.06 (14-Jun-2012)

Fixed problem with the forms when consolidated invoice column removed

2.8.05 (08-Jun-2012)

Ensure entry points are set correctly for error handling

2.8.04 (01-Jun-2012)

Added lines numbers and changed the set mode controls

2.8.03 (31-May-2012)

Fixed problem with return call when allocation forced over to second record

2.8.01 (16-Apr-2012)

Fixed problem with DFF on upload

2.8.00 (04-Apr-2012)

Added new data structure

2.7.22 (17-Feb-2012)

Fixed problem with miscellaneous receipts

2.7.21 (03-Feb-2012)

Fixed a problem with applications losing the receipt number on large loads
Fixed problem with Adjustment unable to find the invoice details

2.7.20 (05-Dec-2011)

Changed Upload to ensure line adjustments are applied prior to invoice an a

2.7.19 (17-Nov-2011)

Add mo_global.init(‘AR’) to procedure calls for R12 to ensure environment set correctly
Changed the return behaviour for application id to match change in package

2.7.13 (26-May-2011)

Added new Customize columns form

2.7.12 (27-Apr-2011)

Ensured bind variables have a trailing space

2.7.11 (01-Dec-2010)

Changed Status column order as per standard

2.6.110 (03-Aug-2010)

Fixed problem with due date default

2.7.09 (25-Nov-2010)

Removed transaction comments that are not supported in 11.5.9 implementation

2.6.109 (29-Jul-2010)

Added unapplied amount to ensure previous applications set the On Account amount correctly

2.7.08 (03-Nov-2010)

Fixed adjustment line upload for DFF issue

2.6.108 (26-Jul-2010)

Fixed download of transaction date

2.7.06 (01-Nov-2010)

Added Line Outstanding, Tax Outstanding
Added Application DFF
Added Download criteria for Transaction Type, Transaction Code and PO Number

2.6.106 (20-Jul-2010)

Added the installment column to the wizard
Added Due Date to the invoice download form

2.7.05 (14-Oct-2010)

Updated DFF to cater for profile defaults embedded in sql string default

2.6.105 (06-Jul-2010)

Made the invoice sort order applicable to all downloads methods

2.7.04 (24-Sep-2010)

Corrected customer sql to use TCA tables directly

2.6.104 (05-Jul-2010)

Fixed problem where large applications did not roll the receipt id correctly

2.7.02 (28-Aug-2010)

Added additional clause to exclude the o balanced invoices that are not activity applications

2.7.01 (27-Aug-2010)

Fixed the processing of large application loads

2.7.00 (11-Aug-2010)

Added support for activity applications both apply and unapply transaction types

2.6.100 (30-Jun-2010)

Added the applications records to a receipt download

2.6.96 (10-Jun-2010)

Made receipt number dependent on customer to ensure correct receipt number returned during applications

2.6.94 (19-May-2010)

Added the ability to unapply applications
Added support for Instruments required for certain payment methods in r12

2.6.91 (16-Mar-2010)

Changed Toolbar and Right Click Menu to adhere to wizard standards

2.6.89 (01-Mar-2010)

Updated the common code for caching improvements

2.6.88 (04-Feb-2010)

Fixed ValidateOnly error

2.6.87 (07-Jan-2010)

Fixed problem with on account application

2.6.86 (30-Dec-2009)

Fixed problem with reset of currentEnd on application section

2.6.85 (29-Dec-2009)

Fixed an R12 download issue related to bank accounts

2.6.84 (18-Dec-2009)

Modified bank account sql to use the CE tables

2.6.83 (07-Dec-2009)

Fixed problem with the identify by field

2.6.82 (15-Dec-2009)

Fixed problem with Application on Account

2.6.81 (04-Dec-2009)

Fixed problem with cell formulas causing errors

2.6.80 (02-Dec-2009)

Update toolbars and generic code as per standardization procedures

2.6.79 (24-Nov-2009)

Changed invoice sql to use lookup code and not meaning

2.6.78 (05-Oct-2009)

Updated template for Unearned discount column

2.6.77 (25-Sep-2009)

Fixed the calculation when receipt amount less than expected amount less discount

2.6.76 (23-Sep-2009)

Pointed Calculate Earned Discount Functionality to the Outstanding Balance Column

2.6.75 (17-Sep-2009)

Added Calculate Earned Discount Functionality<

2.6.74 (31-Aug-2009)

Fixed problems with application discounts when loaded during the receipt creation

2.6.73 (31-Aug-2009)

Fixed problems with application discounts when loaded during the receipt creation

2.6.71 (20-Jun-2009)

Fixed problem with control focus for application section

2.6.70 (17-Jun-2009)

Always reset the column headers to ensure column movements captured

2.6.69 (05-Jun-2009)

Exchange rate now using validator unique

2.6.68 (04-Jun-2009)

Changed Bill To to a restricted list
Updated exchange type to use conversion_type

2.6.67 (03-Jun-2009)

Updated max rows on bill_to to 1000 from 500

2.6.66 (25-May-2009)

Updated forms to fire events on save

2.6.64 (24-Mar-2009)

Fixed problem with the connection timing out.

2.6.62 (04-Feb-2009)

Fixed problems with Adjustments, Download Selected and On Account processing

2.6.61 (03-Feb-2009)

Changed write to cell content to differentiate between download and form

2.6.60 (07-Jan-2009)

Changed structure to process a large receipt application in batches specified by a limit

2.5.60 (26-Nov-2008)

Changed determine end to take into consideration child records

2.5.59 (19-Sep-2008)

Fixed problem with from/to fields returning data based on id and not text.
Fixed problem with validator from to using the id instead of text.

2.5.58 (15-Sep-2008)

Fixed problem with validation of activity when valid value in use.
Added validation for activity when using miscellaneous receipts.

2.5.57 (11-Sep-2008)

Added validation for activity when using miscellaneous receipts

2.5.56 (28-Jul-2008)

Added Maturity Date

2.5.55 (22-Jul-2008)

Performance Issues in Office2007 addressed by removing the copy-paste to temp worksheet

2.5.54 (22-Jul-2008)

Fixed problem with conditional formats erroring with large string

2.5.53 (18-Jul-2008)

Fixed problem with large allocation not processing all lines

2.5.52 (10-Jul-2008)

Modified Consolidated Billing upload to use Invoice Amount so that default oracle allocation occurs
Fixed problem with upload of large application introduced in 2.5.43

2.5.50 (02-Jul-2008)

Consolidated Billing number is now enabled for upload

2.5.49 (25-Jun-2008)

Fixed mismatch between the transactions comments column and definition

2.5.48 (23-Jun-2008)

Added the closed invoices to the download invoices form and query

2.5.47 (18-Jun-2008)

Fixed problem with Currency Control on Invoice Download

2.5.46 (25-May-2008)

Added Application Date and Application GL Date
Added Invoice download form
Added Allocated Receipt amount

2.5.45 (18-May-2008)

Fixed problem with negative applications introduced in 2.5.33

2.5.44 (12-May-2008)

Fixed problem with toggle on child grid giving incorrect row numbers

2.5.43 (07-May-2008)

Added lasted grid code to overcome problem with columns not displaying

2.5.42 (02-May-2008)

Fixed problem with form values not saving when loaded from a blank row

2.5.41 (30-Apr-2008)

Fixed R12 problem with API expecting bank account use id rather than bank account id

2.5.40 (29-Apr-2008)

Added changes for R12

2.5.38 (28-Apr-2008)

Added the Bill To Location to the download criteria when downloading the open transactions for a particular customer. Fixed errors in rounding of application figures for amounts less than a dollar. Changed the identify column to default the customer number and not the customer name to prevent the wrong customer being returned when duplicate names in use.

2.5.32 (04-Apr-2008)

Changed the application amount to default to the lessor of the outstanding balance and receipt remainder. Also added the transaction date. Corrected the bug with an On Account receipt that failed if no application record was specified. Also fixed the problem where the wizard tried to pass zero application amounts (should ignore zero amounts)

2.5.30 (14-Feb-2008)

Changed the validation process and removed reliance on controls during the upload

2.4.27 (18-Dec-2007)

Added support for adjustments, the payment of unrelated invoices and for placing unallocated on account. Also added a new column to allow the use of an invoice number to identify the customer

2.3.27 (19-Nov-2007)

Fixed tab order of main form and added outstanding balance warning message

2.3.26 (09-Nov-2007)

Added error handler to procedure exceptions returned from an Oracle API call

2.3.25 (01-Aug-2007)

Added bank account number

2.3.24 (20-Jul-2007)

Added single sign-on

2.2.23 (16-Jul-2007)

Added override to the application section

2.2.22 (12-Jul-2007)

Fixed miscellaneous receipt functionality

2.2.21 (06-Jul-2007)

Changed dff to accept form references

2.2.20 (02-Jul-2007)

Added latest modFlex that uses either value set name or segment name for :$FLEX$

2.2.19 (26-Jun-2007)

Fixed problems with excel 2000 in support and forms

2.2.18 (22-Jun-2007)

Updated the flex code for table based value sets

2.2.17 (12-Jun-2007)

Updated the date handling to utilise WRS

2.2.16 (11-Jun-2007)

Added date variable to PrepareSQLDate

2.1.13 (11-Jun-2007)

Added Application Form

2.1.12 (11-Jun-2007)

Added Outstanding Values to the wizard

2.0.12 (13-Apr-2007)

Corrected upload to use the customer id and not customer number