Does anyone know if there is a way to pass a parameter to a BAQ that is run via the BAQ Export Process?
We’re outsourcing our check printing process so need to upload a delimited text file of a Check Group. I just need to output the file to a location on a share and then the file will be set to FTP to the check processing company. I’ve been looking at multiple ways to accomplish and was hoping to do this with the ICE tools but not have to rely on any C# programming.
I already have a BAQ Dashboard set up that will allow users to get the data then they can export to Excel but I was hoping for a more elegant (but non-programming…at least much) solution.
Have you looked at the Electronic Interface capabilities in Epicor? There’s already a generic payment interface that produces a delimited file during a check run. To reorder or eliminate columns is VERY easy.
I agree with Mark.
We use it for ACH payments, although we went with the JPMC-specific interface instead of the generic, comma-delimited one.
Once it’s generated, I use a program called Diplomat Managed File Transfer that automatically picks up the file once it’s generated, encrypts it, sends it to our bank via SFTP, and then moves the generated file to a secure archive to reduce the chance that someone could alter the file prior to sending it off.