By using this website, you agree to our Terms of Use (click here)
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.
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.
@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.