SafePay Alternative Formats

SafePay Alternative Formats

Written By: Dave Dery

from October 26, 2015

If your bank requires you to submit something other than the standard comma or tab delimited formats, you can accomplish this task by using Fixed Field as your output type.

We recently had a customer that requested an unusual format. Their bank required ‘#’ as the delimiter. Using fixed format, I was able to accomplish this relatively simply by following the steps below.

To create a detail row SafePay file, open Microsoft Dynamics GP, go to Financial, Routines, SafePay, Configurator. Create the name and description for your new format and save when prompted. As the output type, select Fixed Field, add the appropriate row details, and click add. Keep in mind that with this row, you are adding in the delimiter manually, so you will likely have to double the number of fields that the bank actually requires. For example, if the bank requires five fields, you will actually have nine or 11, depending on opening and closing constraints. Define your data fields as normal, but in-between each standard data field, simply drop in a constant with the ‘#’ symbol. This way you can meet your bank’s requirements and still work within the typical SafePay model.

Once this new template was complete, our final output looked something like this:
#NAD#ISSUE#7200360604#SINGLE###20160309#4405.10#20012#######20991231#############