I am trying to figure out how to get the Positive Pay output file to be a comma deliminated file. Right now the out of the box file txt is not working with our bank. I was told it can still be txt but needs to be comma deliminated.
Hope someone can help!
Thank you!
Krista
Ms. Krista: I gave up trying to get the “Epicor Positive Pay”. I just created a “Check Register” report style that is structured to only output the bank requirements. Typically Check number Amount and Name - and this is pretty much it. Some banks are different so your requirements will likely be different.
So as an alternate - make a Check register report style and upload to Bank as CSV or Excel.
DaveO
This is also what I did. Not much to it, but there are still some hoops you may have to jump through (as @DaveOlender mentioned, it is all driven by your bank’s requirements):
This is my Check Register report style for Positive Pay.
A few notes, depending on your bank’s requirements…
Vendor Names: Since you want a comma delimited file, and comma’s in your vendors’ names are going to cause issues. So, in my name field, I used the following expression: =Replace(Fields!Name.Value.ToString(),","," ")
This replaces any comma’s in the name to spaces.
Instead of: My Company, Inc.
It gets changed to: My Company Inc.
Epicor’s “CSV” output format defaults to CSV UTF-8, which was unacceptable to my bank.
Epicor’s “CSV” output includes column headings, which was also unacceptable to my bank.
My work around:
I set the output when running the Check Register report to Excel-Data Only.
This exports a .xlsx file.
In Excel, I simply open the file and then “Save As”… choose the file type there as CSV (Comma delimited) (*.csv)
Or ya know, y’all make a function and drop it in EpicorData… Server File Download.
I just made a dashboard and they copy to excel and save as csv
Cant you write an EI for this?
You could, but Positive Pay is pretty simple and @klincecums idea of a Function would be far easier to implement than an Electronic Interface. No need to access the server and you could call it any time, not just during a check run.
