Dynamics Community Forum Thread Details

Safe Pay and leading zeros in account number

I'm trying to get Safe Pay set up in GP 2015 R2. Our bank account starts with a leading zero, and that zero is not showing up in the positive pay file.

Our account number is 9 characters long. The field is supposed to be 13 characters long, left justified, with the last 4 positions left blank. Instead, we're getting an 8 character account number with 5 blanks at the end.

I have it configured in Safe Pay to use the standard field "Account Number", with field type "text", and 13 as the number of characters. Filler type is spaces, and the justification is left.

I know I can make this work by using an extra field of length 1 that's always zero (it's a fixed field file), but that seems kludgy to me. Is there some way to make Safe Pay emit the leading zero on the account number?

Thanks,

Unfortunately you are correct and Safe Pay will emit the leading zero on the account number. Your option and a fixed format are the only two options.

OPTION ONE

You could hard-code it as a constant value with the leading zero. Then if you have another field somewhere in ANY of the lines of the file that is blank or not used, you could map the 'account number' to that field, and then just leave it blank on the checkbook setup. This will satisfy the requirement to have it mapped in the configurator, but it will print blank if there is no account number so you won't know the difference on the output file. (If you have another optional field in ANY line that is blank or you elect not use, you could map the account number to that field, so it will print blank, this will get you around it.)

OPTION TWO

Use a 'fixed format' and right justify the field and pad it with a zero. But you would also have to add a field in between each field to hard-code the comma. the field would have to be a fixed length wide and would have to be wide enough for the largest check you plan to write. When this format is used it adds spaces to the left of the amount. You would just have to make sure the bank is okay with this and can still read it.

Quick Links

Leaderboard