Skip to main content
Solved

How to export excel file in GI when using Quick Search


Forum|alt.badge.img

Hi All,

I notice when I use the quick search and try to export an excel file, it only export from a certain fields while ignoring others. Example below:

You can see I search for “FT” and items that contain FT in their product number or description would show. 
 

However when I export to excel, only product number with “FT” is showing and it does not pull the item that have “FT” in description. 

What do I need to do in GI screen in order to enable the description field to be able to export to excel? Like what governs the field that will be export to excel?

Kind regards,

Calvin 

Best answer by BenjaminCrisman

Hi @Calvin! This is actually part of a known issue:

https://community.acumatica.com/generic-inquiries-and-dashboards-236/known-issue-in-acumatica-erp-2022-r1-users-could-not-export-data-from-a-generic-inquiry-to-microsoft-excel-if-a-filter-was-applied-in-the-search-box-of-a-form-10372

You can get around the issue by including * on each side of the filter terms

View original
Did this topic help you find an answer to your question?

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

In addition to @BenjaminCrisman 

This is because there is a search result being used on the GI, with multiple pieces.

This is a known issue and fixed in Newer Builds of 22R2, and 22R1 Latest version

As a workaround could you please try to use the filter at column headers and export to excel?

This behavior can be seen on other screens as well.


Forum|alt.badge.img
  • Jr Varsity III
  • March 9, 2023

Thank you @BenjaminCrisman @manikantad18 for the solution!

Kind regards,

Calvin


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings