Does anybody have any experience with setting up c...
# accountingj
Jacob Jackson
03/10/2021, 7:36 PMDoes anybody have any experience with setting up custom templates for Positive Pay files?
a
Anthony Dixon
03/11/2021, 3:37 PMYes, I've created a few. They're not the most intuitive, unfortunately. But let me know if you need any assistance... or just have specific questions.
j
Jacob Jackson
03/12/2021, 6:08 PM@Anthony Dixon I'm trying to get it setup for just a linear set of data on a single line, for each check. Account Number, Payee Name, Date, etc.
a
Anthony Dixon
03/12/2021, 6:17 PMDoes your bank have a standard template that they're looking for? Or is this "linear set of data" in line with that?
j
Jacob Jackson
03/12/2021, 6:17 PMThey have a standard
a
Anthony Dixon
03/12/2021, 6:22 PMGot it. Let me know if you have any specific questions and I'll try to help.
j
Jacob Jackson
03/12/2021, 6:23 PMBasically they just need the file to generate, and then they upload it to their bank portal. But I'm not seeing an option to get a file to generate in that format
Jacob Jackson
03/12/2021, 6:24 PMdo you know where I can get a positive pay file to generate that is all on one line? the ones I see are multi-line formats
a
Anthony Dixon
03/12/2021, 6:27 PMYou'll need to customize one of the existing ones in NetSuite to get it the way you want it to look. Sounds like you'll be collapsing the data into one line. So if you edit one, change the 'Bank File Template' section and then Save As.
j
Jacob Jackson
03/12/2021, 6:28 PMhow do I know if the reference fields and validator fields are correct?
Jacob Jackson
03/12/2021, 6:31 PMcan I just do this with a saved search, pulling the custom record fields?
a
Anthony Dixon
03/12/2021, 6:47 PMya, customizing these things aren't the most intuitive. It's a bit of trial and error.
Anthony Dixon
03/12/2021, 6:48 PMand if you can get the data you need from a saved search, then sure... the client would them have to manually organize that and save it to a txt file... therefore bypassing the Electronic Payments bundle (which I assume is what you're using)... but if they're ok with that, then a saved search could work.
Anthony Dixon
03/12/2021, 6:49 PMBut if not, you'll need to find someone that knows how to customize those templates. If you're willing to subcontract that piece out, I can do it for you, if you'd like.
j
Jacob Jackson
03/12/2021, 10:15 PMI have everything figured out except for the output Bank File Template, the BoA format is fairly close, I'm trying to figure out how to manipulate it to get it to what I need it as
Jacob Jackson
03/12/2021, 10:15 PMdo you know what programming language this is in? because there's some syntax here that I don't recognize and I'm having a hard time getting it to work
a
Anthony Dixon
03/13/2021, 1:16 AMHmm. I don't know what language that is, unfortunately.
j
Jacob Jackson
03/15/2021, 7:01 PM@Anthony Dixon It's FreeMarker. I got it all figured out, the only last thing I can't seem to get, is to have the fields on the output file display in separate cells instead of all in the same cell. Any suggestions?
a
Anthony Dixon
03/15/2021, 7:36 PMGreat to hear! separate cells? is it not all just spaces/tabs and lines?
j
Jacob Jackson
03/15/2021, 7:37 PMits a separate row for each check, but it displays everything in a single cell in excel when you download the file
Jacob Jackson
03/15/2021, 7:37 PMthere's a space separating each field, but that's it, that <sep>, doesn't seem to work, even though it's a CSV
Jacob Jackson
03/15/2021, 7:38 PMso it outputs like 123456789 123456 1234455 03152021 Vendor Name
Jacob Jackson
03/15/2021, 7:38 PMI need each of those values to be in separate cells
Jacob Jackson
03/15/2021, 11:17 PMI got them into separate cells finally, but it only does it for the first row of the list.
a
Anthony Dixon
03/16/2021, 12:22 AMHey Jacob. You're venturing into unknown territory for me here. I've never had to put things into separate cells. The bank is requiring this? Most banks just want the file that NetSuite provides and the user then just uploads the txt file into their banking portal.