
Dear All
I have tried to generate EFT file in excel by indicating a file extension of .xlsx, however when a tried to open the file I get this message " Excel cannot open the file 'Payment CHECKBOOK 20160217-0001.xlsx' because the file format or extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file"
Is there something am doing wrong or that GP 2015 cannot generate the EFT file in ecxel.
Will appreciate your response.
Thank you.
*This post is locked for comments
I have the same question (0)I typically see the file extension as a .txt. You can delimit it in the EFT file format which once the file is generated could then be opened with Excel but can't say I've ever seen the file saved directly as an .xlsx.