Change Log

v1.16.0

New:
  • NEW: Added BAS Report Xero report for Australian organisations.

v1.15.0

New:
  • NEW: Added Invoice Payable and Invoice Receivable reports with detailed and summary options.
  • Aged Payables/Receivables: Added foreign exchange columns Currency and Currency Rate to detailed reports.
  • 1.15.1: Force Excel to be opened in admin mode to update RadiusCore for system-wide RadiusCore installations.
  • 1.15.2: Account Transactions, Aged Payable/Receivable, Invoice Payable/Receivable: Reports can now have tracking category columns added as optional user-selected columns to the report.
  • 1.15.2: Workpapers: Digitally signing a workpaper only updates the state if the current state is equal to or before the target state in workpaper state array.
  • 1.15.2: Workpapers: Updated workpaper review setup form with modern design elements.
  • 1.15.2: Added support for idempotent API requests.
Fixed:
  • Aged Payables/Receivables: Correctly format numeric columns when aging by invoice date.
  • Aged Payables/Receivables: Payments & Outstanding Tax are now correctly converted to base currency.
  • API: CreateReport: Corrected detection of invalid Location parameter.
  • 1.15.1: Fixed date parsing for dates after 19th January 2038.
  • 1.15.2: Invoice Payable/Receivable: Contact filter is now correctly applied to report data.
  • 1.15.2: Invoice Payable/Receivable: Detailed reports with a table layout are now created with the correct number of rows.
  • 1.15.2: Budget Summary: Will now correctly retrieve report data when the report period spans more than a 24-month period.
  • 1.15.2: Account Transactions: Added check for nil balance quantity line that also has an account code to address a suspected Xero bug allowing transactions to be saved with line items of this nature.
  • 1.15.2: Staff billable rate now defaults to Zero when blank, rather then preventing the user from leaving the control.

v1.14.0

New:
  • NEW: Added Aged Payable and Aged Receivable reports for all contacts at once, with detailed and summary views.
  • Aged Payables by Contact and Aged Receivables by Contact reports have been moved to Legacy.
  • 1.14.1: Aged Payables/Receivables: Improved speed for Xero organisations with a large number of contacts.
  • 1.14.3: Disabled WorkflowMax connections, as this app is no longer operational.
  • 1.14.3: NOTE: Support for WorkflowMax by BlueRock will likely be added in a future version.
  • 1.14.3: Workpapers: Disable table auto-fill for workpapers.
Fixed:
  • Corrected issue with date formatting in Excel in rare instances.
  • Accounts are now checked for an empty account code when compiling array of related accounts.
  • 1.14.1: Aged Payables/Receivables: Fixed incorrect report data in rare instances.
  • 1.14.1: Aged Payables/Receivables: Each contact's transactions are now correctly sorted by date.
  • 1.14.1: Workpapers: An organisation's balance date can no longer be updated in Xero Practice Manager when running workpaper setup.
  • 1.14.1: Minor improvements to various user interfaces.
  • 1.14.1: Workpapers: Practice Manager workpaper setup no longer shows if the subscription doesn't have a linked Xero Practice Manager connection.
  • 1.14.3: Aged Payables/Receivables: Foreign currency transaction amounts are now correctly converted to local currency.
  • 1.14.3: Aged Payables/Receivables: Fixed incorrect variable usage that was preventing Overpayment being added to the report.
  • 1.14.3: Aged Payables/Receivables: Prepayments made on the report date are now shown.
  • 1.14.4: Bank Summary: Maximum date range is now enforced to prevent bad requests.
  • 1.14.4: Bank Summary: Can now be created for Xero organisations with foreign currency bank accounts.
  • 1.14.4: Improved handling of web sockets to prevent issues when connecting new Xero organisations.
  • 1.14.5: Aged Payables/Receivables: Prepayments after the report date are now correctly added to report when aging by Invoice Date.
  • 1.14.5: Aged Payables/Receivables: Credit Note allocations are now correctly recognised as payments.

v1.13.0

New:
  • NEW: Added new Cash Summary report.
  • Account Transactions: Now supports multiple accounts in a single report. This is currently only available when creating the report via API.
  • Account Transactions: Added 8 new optional columns.
  • Account Transactions: now supports Debtor & Creditor system accounts.
  • Account Transactions: can now be created using cash basis.
  • Report column widths are now capped at a maximum size, and text wrapping is enabled for multi-line cells.
  • 1.13.1: Account Transactions: Added description line No transactions in period when a selected account has no transactions for the period.
  • 1.13.1: Updated connection selection interface to improve performance and address VBA Unexpected Error issues.
  • 1.13.2: Account Transactions: Improved performance when creating reports for system accounts DEBTORS and CREDITORS.
  • 1.13.2: Minor performance improvement when retrieving prepayment allocations.
Fixed:
  • Fixed an issue with floating point rounding in various reports.
  • Trial Balance: now has a title indicating whether it is a cash-basis report.
  • Account Transactions: Prepayment allocations are now correctly shown.
  • Account Transactions: Transactions with two tracking categories are now correctly displayed.
  • Account Transactions: Opening account balances are now correct when tracking is applied.
  • Column widths are now preserved when refreshing a Print style report.
  • Account Transactions: Transactions of type Bank Transfer now correctly show their related account.
  • 1.13.1: Fixed error when attempting to retrieve too many items at once from Xero's API.
  • 1.13.1: Account Transactions: Transactions of type Bank Transfer now have the correct polarity when tracking is applied.
  • 1.13.1: Account Transactions: Section totals on print-style report are now correct for accounts with no transactions.
  • 1.13.2: When generating journals, if a transaction type is not recognised by RadiusCore's report engine, it is now skipped so that reports will still compile (albeit potentially missing data).
  • 1.13.2: Don't show warning message when skipping transactions of type bank transfer during journal creation.
  • 1.13.2: Account Transactions: Fixed prepayment allocations missing for system accounts DEBTORS or CREDITORS.
  • 1.13.3: Fixed error preventing journal generation when a manual journal has more than one tracking category.
  • 1.13.3: Account Transactions: Manual Journal narration is once again included in line-item description.

v1.12.0

New:
  • NEW: Added Account Transactions report.
  • Updated Reports Excel ribbon menu to group reports by category.
  • 1.12.2: QuickRefresh warning is now only displayed if RadiusCore's progress bar is visible.
  • 1.12.3: Account Transactions: Added secondary progress bar during report creation.
  • 1.12.3: Improved User Interface when a date field is linked to a spreadsheet cell.
  • 1.12.3: Account Transactions: Major speed improvements.
  • 1.12.5: Workapers: Adjusted workpaper review system restrictions to always allow access to workpaper states even if the review system is disabled for that workpaper.
  • 1.12.6: Updated User Management interfaces to bring modern design elements.
  • 1.12.6: Updated Advanced Setting interface to bring modern design elements.
  • 1.12.6: Local template cache can now be cleared via Advanced Settings.
  • 1.12.6: Workpapers: Account codes are now validated following workpaper setup.
  • 1.12.6: Workpapers: Improved behaviour of Practice Manager client setup interface.
  • 1.12.7: Account Transactions: Added Related Account as an optional column.
  • 1.12.7: Account Transactions: now supports creation of a transaction report for system account type Bank.
  • 1.12.7: Account Transactions: now correctly displays information for transactions of type Prepayment and Overpayment.
  • 1.12.7: Account Transactions: Added Transaction ID and Line Item ID report columns to report.
  • 1.12.7: Account List: Added System Account ID as an optional report column.
  • 1.12.7: Account List: Renamed report column Xero Identifier to Account ID.
  • 1.12.8: Account Transactions: now supports creating a report for accounts with no account code.
  • 1.12.8: Adjusted display of account list in report settings to correctly show accounts without an account code.
  • 1.12.9: Account Transactions: now returns Related Accounts for transactions of type Invoice and Credit Note.
  • 1.12.9: Minor formatting improvements for Print style reports.
  • 1.12.9: Manually dispose of objects from memory to minimise VBA memory leaks.
  • 1.12.10: Workpapers: Added additional workpaper configuration to control whether manual entity setup is available.
  • 1.12.10: Workpapers: Updated UI design elements for workpaper setup and review system.
  • 1.12.11: Workpapers: Exposed workpaper general ledger refresh method via API.
Fixed:
  • Report Setup no longer repeatedly checks Xero for tracking categories for organisations with no categories setup.
  • Detect End of Last Financial Year before End of Last Quarter when they are the same date.
  • Fixed incorrect date definitions for Date At report setting.
  • Updated Report Engine error handling to correctly reflect changes in v1.11.0.
  • 1.12.1: Account Transactions: Fixed incorrect application of tracking filter to Payment transactions.
  • 1.12.1: Account Transactions: Updated report, so a Payment's linked transaction reference is used when it doesn't have a Reference of its own.
  • 1.12.1: Fixed incorrect name of Xero transaction type.
  • 1.12.2: Advanced settings can once again be accessed when the user is logged in.
  • 1.12.2: XPM/WFM: Job List: Fixed Web Url column not returning any data.
  • 1.12.2: Improved error handling in edge cases.
  • 1.12.2: Fixed minor report settings interface issue when report layout is set to Print.
  • 1.12.3: Fixed an issue with foreign exchange accounts preventing report creation in rare instances.
  • 1.12.3: Cell contents are now correctly cleared when report creation experiences an error.
  • 1.12.3: Account Transactions: Fixed currency conversion error preventing report creation in rare cases.
  • 1.12.4: Account Transactions: Further adjustments to prevent timeout issues with Xero's API.
  • 1.12.4: Account Transactions: Secondary Progress Bar now displays API page number during report creation.
  • 1.12.5: Balance Sheet: Fixed issue when switch rules were present in the API response.
  • 1.12.5: Fixed issue with accounts of type Liability when creating various Xero reports.
  • 1.12.5: Number formatting is now correctly applied to table Total row.
  • 1.12.5: Minor adjustments to error handling.
  • 1.12.5: Workpapers: Setup now correctly uses configuration to determine whether Practice Manager setup is shown.
  • 1.12.6: Account Transactions: Fixed incorrect variable usage when compiling report data.
  • 1.12.6: Fixed issue preventing permission changes being saved in some instances.
  • 1.12.7: Account Transactions: Fixed blank Currency Code column for transaction type Payment.
  • 1.12.7: Account Transactions: Improved messaging to the user when creating report for an unsupported account.
  • 1.12.7: API: CreateReport: Parameter Location is now checked to ensure a valid object/variable reference before checking the variable type.
  • 1.12.8: Account Transactions: Fixed issue preventing report being created when report dates are dynamically read from a sheet cell.
  • 1.12.8: Account Transactions: Reports containing transaction type Bank Transfer and column Contact can now be created.
  • 1.12.9: Account Transactions: Data for the Running Balance column in print report is now correctly placed.
  • 1.12.9: Account Transactions: Corrected total formula for Running Balance column.
  • 1.12.10: Account Transactions: Running Balance column now correctly includes the opening account balance.
  • 1.12.10: Workpapers: Fixed minor issues with data validation during workpaper setup.
  • 1.12.11: API: WorkpaperSetup: Improved how method determines whether setup was successful.
  • 1.12.11: API: Disconnect: Fixed bug when the Location parameter is not passed.

v1.11.0

New:
  • Redesigned report settings user interface with modern design elements.
  • Re-wrote reporting engine to improve speed, configuration, and provide framework for additional reports in future updates.
  • Refactored how report settings are stored in Excel documents. Backwards support for reports created from v1.3.0 - v1.10.4.
  • Removed support for reports created with RadiusCore versions older than v1.3.0.
  • Reports created with the Print layout option can now have their data refreshed.
  • Balance Sheet, Budget Summary, Profit & Loss: can now have up to 36 comparison periods.
  • Budget Summary, Profit & Loss: can now have custom comparison period lengths (i.e., X days, X months).
  • Budget Summary, Legacy Budget Summary, Profit & Loss: can now optionally have a Total column added.
  • All Xero reports now have optional display of decimals.
  • Print layout now uses Excel formula for total rows & columns.
  • Account List: can now have multiple filters applied.
  • XPM/WFM: Client List: Added Quick Refresh option.
  • XPM/WFM: All reports with filters can now have multiple filters applied.
  • XPM/WFM: Invoice List: report now returns Draft invoices where appropriate.
  • XPM/WFM: Invoice List: can now be filtered by invoice status.
  • XPM/WFM: Added additional report fields (columns) to numerous reports.
  • API: GenerateReportSettings: now returns an XML string.
  • API: CreateReport: now requires an XML string for the ReportSettings parameter.
  • API: Refresh, Disconnect: Parameter TableName deprecated. Superseded by Location parameter, which accepts a {ListObject}, {Range}, or {String}.
Fixed:
  • GST Report: can now only be created by New Zealand Xero organisations.
  • 1.11.1: Fixed issue detecting existing reports due to an Excel bug.

v1.10.0

New:
  • Added Sign up with Xero.
  • 1.10.1: Workpapers: Added ability to customise workpaper periods when using manual setup.
  • 1.10.1: Workpapers: Removed requirement for a linked XPM account to use workpapers.

Fixed:

  • 1.10.1: Workpapers: Workpaper tab colour is now correctly cleared where no colour is specified for the active workpaper status.
  • 1.10.1: Updated various UI elements.
  • 1.10.1: Minor logging adjustments.
  • 1.10.3: Updated Business Structures to reflect changes made in Xero Practice Manager.
  • 1.10.3: Updated New/Edit admin form with new UI design elements.
  • 1.10.3: Profit and Loss: Fixed bug preventing report creation when accounts are grouped.
  • 1.10.4: Workpapers: Updated available business structures to reflect changes in Xero Practice Manager when using manual setup.

v1.9.0

New:
  • Added Custom Templates feature; user-managed templates. Includes version control and centralised distribution via RadiusCore Excel ribbon.