Report writing is as much art as it is science. As a result, it is both exact and subtle.
There are many factors that can impact the results of a report and sometimes you may look at report and...
See a different value than what you expect or than what someone else sees
Wonder what data lies behind a particular value
See no data and expect something else
Let's look at an overview of techniques that you can apply to help you resolve general issues. For specific error messages, please type the error text in the search bar of this Help Center to find a more specific symptom/cause/resolution article.
Perform a full refresh
A Full Refresh reloads all data associated with the Velixo functions in your report. This includes all new transactions in the database, 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.).
Look for any error message during refresh
We all tend to dismiss on-screen messages, out of habit. However, it can be vitally important to gather all information we can whenever we are trying to troubleshoot an issue. As a result, pay special attention to any messages that appear. Write them down and try looking for the message within the Velixo online Help Center.
Try to login with another, known, good user account from the machine involved
Having another person (especially an administrator) run the report (from the same computer) can provide valuable information. If the results are different, this indicates that the difference is due to some access rights within the ERP and not due to some other influence related to the specific machine.
It may be necessary to adjust the access rights to one or more of the underlying Velixo generic inquiries. After changing the access rights of the affected user, make sure to do a Full refresh (see above) on any device where this user has previously run reports to ensure the caches are properly reloaded.
Try to download and run a sample report from our online Help Center
We can provide credentials on request for accessing our internal demo Acumatica. In this way, you can ensure that your report works against known data and compare it with the same data we can retrieve with the report.
Using the Velixo drilldown feature to compare differences between two users seeing different data can help highlight accounts/ledgers/branches/sub accounts/etc. which may be restricted by access rights or restriction groups within the ERP.
View the data within the ERP
Is the user able to view the data from within the ERP? Remember that the user is subject to the same access rights (which apply to their use of the ERP) when they are using Velixo Reports. If running a financial report from within the ERP shows the same values as running the financial report using Velixo Reports, that would be the expected results. If those values are not what is expected, it may be necessary to adjust access rights or restriction groups in order for the user to see the desired data.
Recalculate Account History and Project Balances in Acumatica
In rare cases, the tables that track historical balances in Acumatica can get out of sync with the underlying data. There are two processing screens in Acumatica that can help you recalculate these balances: Recalculate Account History (GL.50.99.00) and Recalculate Project Balances (PM.50.40.00)