By using this website, you agree to our Terms of Use (click here)
I ran across an issue today while trying to demonstrate some Acumatica functionality for a customer. Using the Vendor Price Worksheet screen to update vendor prices, I downloaded the detail grid to excel with the intention of updating prices, and then used the "load records from file" to import the changes back into the screen (something I've done numerous times previously).
When importing the file, I received an error stating that "Data is Absent", which I have never seen before. I did some additional testing and found the same issue on other screens using the "load records from file" feature - all of them would give the same error.
The only thing that had changed was that I had installed Velixo. So I disabled the add-in from within Excel, and tried the same processes with no error.
So just a heads up to anyone that experiences this same issue - disabling the add-in will resolve it, and then you can re-enable it for reporting.
@Myrcenary - thanks for reporting the issue. I'll issue a fix as soon as possible and update you on this forum.
Thanks for the heads up Myrcenary. I actually had the same issue yesterday coincidentally, but I didn't realize that it was because of Velixo Reports.
This is the message that pops up in Acumatica after you click on the OK button:
Data is absent
Version 1.0.17 was released a few minutes ago and fixes the issue reported by @Myrcenary. The hidden sheet that contains the list of connections is now added after the existing sheets in the file to ensure Acumatica doesn't try to read from it. I also added another improvement to prevent creating this hidden sheet if no connections have been configured in the current workbook.
Excel will prompt you to update to the new version next time you start it.
P.S. existing worksheets that have this problem won't be fixed, please re-create them or contact me if that's a problem - I can manually fix them
Thanks Gabriel. That fix worked for me. I just created an Excel file and imported it into a screen successfully.
Thanks for the feedback!