Change Log

v1.21.0

New:
  • Where possible, filters applied to a RadiusCore table are now persistent through report refresh.
  • Account Transactions: Now supports system accounts GST and Realised Currency Gain.
  • Account Transactions: Now uses local data caching to significantly improve speed of report refresh.
  • API: Added new method, AddUser.
  • Redesigned select template user interface.
  • Updated numerous user interfaces with modern design elements.
  • Custom Templates: More... button can now be used to open old template versions.
  • Custom Templates: When entering the template's version number, cursor input will now be automatically moved to the next box when the period key is pressed.
  • Autocomplete is now available when typing to select a Xero entity to connect to Excel.
  • Practice Manager: Staff billable rates can now be cleared.
  • Practice Manager: Added hyperlinks to relevant settings in Xero Practice Manager when performing practice manager setup.

Fixed:

  • Account Transactions: Fixed a foreign currency conversion issue that resulted in incorrect amounts showing in Debtors/Creditors system accounts when a foreign currency invoice had a payment applied.
  • Account Transactions: Fixed closing balance going to the wrong column in rare instances.
  • Account Transactions: Should no longer cause HighVolumeException error when querying Xero's API for large data sets.
  • Account Transactions: Improved/added checks for nil quantity lines to ensure they do not show on report.
  • Fixed email address validation to accept modern domain structures.
  • Updated error handling during the Sign In process.
  • Fixed decoding of JWTs in rare instances.
  • Removed external library dependency for base64 encoding/decoding.
  • Improved behaviour of user prompts when closing various forms in the Practice Manager/Workpaper setup procedures.
  • Changed list control used on all user interfaces to avoid compile error when Excel has ActiveX controls disabled.

v1.20.0

New:
  • Overhauled core application data models to fix long-standing design flaw with relationships between Xero API Tokens, Tenants, and Connections.
  • Application can now recover from a run-time compile failure without needing to restart Excel.
  • 1.20.3: Number of available shared and personal connections are now displayed when adding a Xero connection to a workbook.

Fixed:

  • Workpapers: Shortcut can now be used to refresh general ledger data when importing from file.
  • User Management: Changed list control used to display user information to avoid compile error when Excel has ActiveX controls disabled.
  • User Management: Fixed crash that could occur in rare instances if server is slow to respond.
  • User Management: Sorting by last logged in date is now correct.
  • Report Engine: Fixed bug due to inconsistency with Xero's data structures for foreign currency transactions.
  • Fixed various typos in error messaging.
  • 1.20.1: Removed all instances of VBA's user-defined enumerator attribute as it is bugged, causing RadiusCore to be unusable.
  • 1.20.2: Enforce maximum date range (365 days) for profit & loss report.
  • 1.20.2: Fixed stale data preventing new connections in rare instances.
  • 1.20.3: Report Settings: Changed list control used to display available and active report columns to avoid compile error when Excel has ActiveX controls disabled.
  • 1.20.3: Connection Management: Changed list control used to display user's connection information to avoid compile error when Excel has ActiveX controls disabled.
  • 1.20.3: User Management: Resolved visual interface bug when display scaling is enabled.
  • 1.20.4: Workpapers: Fixed error reading saved General Ledger connection details for connections established prior to v1.17.0.

v1.17.0

New:
  • Workpapers: Import from File is now available to use as a General Ledger source.
Fixed:
  • Fixed application fatal error when attempting to create a report while using an unsupported Xero version.
  • Corrected issue with error handling when API response returns 403 - Forbidden.
  • Status of Practice Manager connection is now checked when starting setup wizard.

v1.16.0

New:
  • NEW: Added BAS Report Xero report for Australian organisations.
  • 1.16.1: Workpapers: Added automation for Aged Payables/Receivables workpaper population from Xero.
  • 1.16.1: Workpapers: Enabled certain workpaper integrations for subscriptions with Custom Template access, so these can be utilised when overlaid on a custom workpaper.
  • 1.16.2: Workpapers: D1/K1: Added custom progress bar when retrieving data from Xero.
  • 1.16.2: Workpapers: Enabled shortcut key Ctrl+Shift+Q to change workpaper status to awaiting queries.
  • 1.16.2: Workpapers: When updating a workpaper status, only add a workpaper event if the target status is different from the current one.
  • 1.16.3: Workpapers: D1/K1: Updated Xero integration to have dynamic columns and configurable report detail.
Fixed:
  • 1.16.1: Aged Payables/Receivables: Minimum ageing period is now 1.
  • 1.16.2: Adjusted application initialisation and sign-in process to improve error handling and dataflow.
  • 1.16.2: Corrected variable usage during a failed API call's error handling process.
  • 1.16.2: Fixed an issue preventing the custom tempalte dropdown from rendering when a custom template has no description.
  • 1.16.3: Aged Payable/Receivable: Added rounding to calculated report value.
  • 1.16.3: Activity Statement: Corrected labelling & messaging when creating report.
  • 1.16.3: Workpapers: Client setup now uses the current workpaper balance date by default.
  • 1.16.4: Fixed issue with report engine error handling.
  • 1.16.4: Fixed issue with AES encryption.
  • 1.16.4: Workpapers: Added error handling & user messaging for blank workpaper CodeName property.

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.