Refresh features (NX)

Created by Harry Lewis, Modified on Mon, 25 Nov at 12:25 PM by Harry Lewis

Applies to:

Velixo NX (this article includes features that are included in Velixo NX 2024.10

TABLE OF CONTENTS

Overview
Velixo NX refresh features
The basics of refreshing a report
Recommendations

Overview

A common question is...

"Which Velixo Refresh option should I choose?"

Let's look at the Velixo NX Refresh options and how they work

Velixo NX refresh features

Velixo NX is built using the latest extensibility technologies available in current versions of Excel and Microsoft 365 for Windows, Mac, and Web versions of Office.

Velixo NX is built on the modern official Microsoft Office extensibility framework (Office.js) available in current versions of Excel and Microsoft 365 for Windows, Mac, and Excel Online.

The Refresh options for Velixo NX are

Current Sheet
Entire Workbook
Full Refresh (Slow)
All Open Workbooks

The basics of refreshing a report

Refreshing a Velixo report will update the data of the Velixo functions and will cause Excel to recalculate the Excel functions and formulas.

The Velixo NX All Open Workbooks option will (as the name suggests) recalculate all open workbooks.

Velixo NX offers additional capabilities to refresh only the currently active worksheet or only the currently active workbook.

Smart Refresh

Most of the Refresh options for Velixo NX use the Velixo Smart Refresh capability. These include:

Current Sheet
Entire Workbook
All Open Workbooks

Smart Refresh will only load data that is new since the last refresh of your report. Any change to the Chart of Account or subaccounts will also be retrieved.

Whenever a Velixo function is used to retrieve data from the ERP, that data remembered or "cached".

Smart Refresh is incremental and is based on the question: "what has been added or updated in the ERP since we last refreshed the report?" Because only a subset of the data is being retrieved from the database, this can be done very quickly. The cache is updated with the new/updated data, and you are now working with up-to-date information.

A Smart Refresh is most valuable when new or updated data is available or when new accounts or subaccounts have been added to your database.

Deleted Records

As discussed above, Smart Refresh is incremental and is based on the question: "what has been added or updated in your ERP since we last refreshed"? It does this by examining the timestamps applied to the records in the database and comparing those to the cached data.

By definition, Smart Refresh cannot adjust when data been DELETED from your database, or in a situation where a database script has been applied against the Acumatica instance, without modifying the timestamps of the records.

If it's simply deactivation as opposed to deletion (and it changes the records' timestamp) then smart refresh will pick it up.

As a result, in such situations, it is necessary to use one of the Full Refresh options.

Full Refresh

The other refresh option - Full Refresh (Slow) - will ignore any cached data and reload all data associated with the Velixo functions in the entire workbook. This includes all new transactions, any transactional data that was already loaded, and any new underlying information in your database (such as changes to the chart of accounts, subaccounts, branches, etc.).

Because all data associated with your Velixo functions is being retrieved, this will generally take longer than a Smart Refresh.

This same functionality can also be obtained by using the Clear Cache feature:

This will remove all data currently being cached for this workbook.

When the report is next Refreshed (using any of the Refresh options), all data associated with the Velixo functions in your report will be re-retrieved as through a Full Refresh were done.

Recommendations

Velixo recommends the use of the Smart Refresh options by default. Incremental refresh is substantially faster and handles the vast majority of usage scenarios with your ERP system.
Avoid hard-deleting records in your ERP system. Instead, deactivate records and revert transactions. If you hard-delete a record that was used in a report, the Smart Refresh options will not be able to pick up this fact and you'll need to use a Full Refresh option, which is typically much slower.
The Full Refresh or Clear Cache option may also be needed if you or an ERP administrator have altered the data structure of your ERP system, such as:

through an SQL script
via changes to data access classes (Acumatica)
publishing new customizations with data schema changes (Acumatica)
data schema updates, such as new dimensions (Sage Intacct), custom objects, or fields
There have been changes to your system's security configuration - such as branch access restrictions or row-level security (also known as restriction groups)
Changes have been made to segmented key configuration (such as the length of the account or subaccount structure)

Note: Clear Cache is not available if you have chosen to work offline.

Info: The Cancel Refresh option allows you to cancel a Refresh operation you have already started. This can be handy if a problem occurs with the connection to your ERP system, and Velixo/Excel is having difficulty completing the process.