Suppress Column headers in GI export to Excel - Acumatica Generic Inquiries & Pivot Tables

RE: Suppress Column headers in GI export to Excel

Shawn P Slavin — Mon, 16 Mar 2020 19:30:54 +0000

@Coleen, well done. You might also consider enabling OData access on your GI and then linking to it directly from within Excel. If you use the data from Acumatica on a regular basis, you can move to a pull approach. This can save time in your process and streamline your automation.

RE: Suppress Column headers in GI export to Excel

Coleen McNally — Mon, 16 Mar 2020 19:07:14 +0000

I have created the generic inquiry for a positive pay file, but then I have used the Export as Report function on the GI form, and formatted the file in the report designer the way the user needed. This way you can eliminate the header rows, and the report can still be exported to excel.

Suppress Column headers in GI export to Excel

Jane Williams — Mon, 16 Mar 2020 18:22:02 +0000

Anyone know how to suppress the column headers when exporting to Excel? I have a PositivePay GI that is going to Excel but I don't want to the headers as the bank knows the format.