Clear Cache

Created by Harry Lewis, Modified on Thu, 27 Jun at 5:58 PM by Harry Lewis

Applies to:

  • Velixo NX

Using Clear Cache will remove all currently cached data within your workbook.

Under typical circumstances, Velixo NX remembers data your report has already retrieved from the ERP, so that the data does not have to be retrieved again - making your reports as performant as possible.

Removing the cached data allows a Refresh to reload all data associated with the Velixo functions in your report.  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 and a status notification may be displayed at the bottom of the Excel window:

This technique is most valuable when:

  • Manual data integrity corrections have been made directly via a SQL query to the database (usually by your ERP's support or a consultant)
  • 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 (length of the account or subaccount structure)

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article