Ideas for Acumatica

Feedback processing: We do not reply to all messages, but we do read them, analyze them, and work to improve Acumatica based on the feedback we receive. Ideas and comments may not appear immediately. Some legitimate ideas are flagged as spam and will be added when we review the spam folders.
Content: This portal is for product ideas and feedback only. If you need customer service assistance, contact your Acumatica Support Partner, submit a support case, or get assistance from community resources: LinkedIn Group or StackOverflow
No Reliance: Information is maintained on a best-efforts basis and may be changed without notice. Acumatica cannot guarantee the accuracy of the information provided or guarantee completion of features/ideas described on this portal.

Export Generic Inquiry data to Excel as a Table with OData connection

This idea is a follow-up to an existing idea what was already implemented:

The previous idea implemented in 2018 R2 is a huge improvement to how Generic Inquiries get exported to Excel.

But, in the spirit of continuous innovation, let's see if we can make it even better.


Here are two additional ideas to make the export of Generic Inquiry data to Excel even better:

  1. Format the data on the Data worksheet as an Excel table automatically. This can be manually done in Excel with this option (but it would be nice if it automatically happened):
  2. Don't just bring the data into Excel, but also include the OData connection so the data can be refreshed from Excel over the OData connection without having to re-export from Acumatica.


Some things to consider about #2 above:

  • There is an "old way" to connect to data sources from Excel and a "new way". The "new way" used to require the installation of a free add-in from Microsoft called Power Query. Now the "new way" is automatically included in Excel 2016.
  • I'm not sure if the export from Acumatica could detect the user's version of Excel (I'm doubtful that it could).
  • My preference would be to use the "new way" to setup the OData connection and everyone would just know that they couldn't refresh the data in Excel versions prior to Excel 2016.
  • To use the "new way" in Excel 2016, you go to Data -> Get Data -> From Other Sources -> From OData Feed like this:

  • Tim Rodman
  • Jun 7 2018
  • Future consideration
  • Attach files
  • Vladimir Panchenko commented
    8 Jun, 2018 05:49am

    Tim, thank you for creating this idea! As I told you here, we'll consider it in the future.