SafePay configuration for Canadian Banks in Microsoft Dynamics GP
This article describes steps to set up the required fields in the SafePay configurator.
Applies to: Microsoft Dynamics GP
Original KB number: 2584867
There are certain fields required in the Safe Pay file by Canadian banks that customers need assistance in setting up. Some of these fields may also apply to US bank requirements.
Not all fields are available in the Safe Pay configurator.
Use the steps below to set up the respective fields:
TOTAL NUMBER OF TRANSACTIONS - This field is a count of the number of checks in the SafePay file. It will count in the Batch Trailer or File Trailer Record Lines only. It won't count in the File Header or Batch Header Record lines by design. It can only count after the detail lines have been provided.
Field Name: Total number of Transactions
Standard Fields: Check Number
Field Type: Numeric
Field Format: Item Count
Number of Characters: 8 (or as defined by your bank's specific requirements) Filler Type: zeroes (or as defined by your bank's specific requirements) Justification: Left (or as defined by your bank's specific requirements)
TOTAL DOLLAR AMOUNT OF TRANSACTIONS - This field is a sum total of the check amounts in the SafePay file. It will sum in the Batch Trailer or File Trailer Record Lines only. It won't sum in the File Header or Batch Header Record lines by design. It can only sum after the detail lines have been provided.
Field Name: Total Dollar Amount of Transactions
Standard Fields: Check Amount
Field Type: Currency - no $/no decimal (or as defined by your bank's specific format requirements) Field Format: Net Total
Number of Characters: 13 (or as defined by your bank's specific requirements) Filler Type: zeroes (or as defined by your bank's specific requirements) Justification: Right (or as defined by your bank's specific requirements)
FILE CREATION NUMBER - This field will increment by one (1) for every subsequent SafePay file generated for each CRS account number. The bank will reject any files with a used file creation number within the last 16 submitted files to safeguard against the same file being processed twice. Unfortunately, this incrementing field isn't currently available in SafePay at this time. Your options include:
Option 1 - Look for a Microsoft ISV who can do this as a dexterity customization for you, or search for a third party Positive Pay file that is compatible with Dynamics GP that may already have this functionality.
Option 2 - Another option is to hard-code a constant value in the file such as '000X'. Then you can manually track the incrementing value separately and edit the SafePay file with this value each time before sending the file to the bank.
Field Name: File Creation Number
Standard Fields: Constant
Field Type: Text
Number of Characters: 4 (or as defined by your bank's specific requirements) (for fixed format type only) Constant Value*: 000X (Key as many digits as defined by your bank's requirements for the length of this field) Filler Type: zeroes (or as defined by your bank's specific requirements) (for fixed format type only) Justification: Right (or as defined by your bank's specific requirements)
Due to the length requirement on the line in the output file, be sure the user doesn't remove or add any extra spaces when they edit this field before sending the file to the bank. For example, let's say this field is hard-coded as 000X and this is the 14th file, so they need to edit this field to be 14, they will need to overwrite this field as 0014. It has to remain 4 characters (or the number of characters defined by their bank requirements.) So if the total line length is 94, and the user keys 00014 (which makes that particular field 5 characters wide instead of 4) then this will push the total line length to 95 characters wide (instead of the required 94), so the bank will not accept the file. Be cautious to only overwrite the exact number of characters needed when editing the file so that the total line width is not jeopardized.
If you would like to see the File Creation Number field added to Microsoft Dynamics GP as a future enhancement, please go to the Microsoft Product Suggestion link below and enter this product suggestion. The more votes it gets over time, the higher in priority this enhancement will be considered as a future enhancement.
TRANSACTION TYPE - The bank will provide specific required codes to indicate what type of document the Detail lines in the SafePay file are, such as Issues, Stop-Pays, Voids, or Deletes, and so on. The SafePay file in Microsoft Dynamics GP will only pull Checks, Voids, or EFTs, so they're the only types that can be entered. Here are the steps to set up the Transaction Type codes:
Enter the Transaction Codes in the Configurator:
- In the Safe Pay Configurator window, select Codes Entry in the top menubar and select Transaction Codes Entry.
- In the Transaction Types Entry window, select the drop-down list next to Transaction Type, and choose Check, Void or EFT as needed.
- Key in the bank's required code for that document type in the Matching Code field.
- Proceed to enter the next Transaction Type and Matching code as needed. (Usually values for Check and Void are entered.)
- Select Save.
Now in the Detail Record Line of the Configurator file, you'll need to map one of the fields as defined by your bank's requirements to pull the corresponding Transaction Type Codes you entered above.
In the Safe Pay Configurator window, select the Detail Line in the 'Step 2 - Create Output Records Lines' section.
In the 'Step 3 - Edit Record Fields' section, double-click on the field that you wish to map as indicated by our bank's requirements.
Enter the field as follows and save:
Field Name: Transaction Code Standard Fields: Transaction Type
Field Type: Text
Number of Characters: 3 (or as defined by your bank's specific requirements)
The Filler Type and Justification fields can be left blank. (Usually if the bank requires the field to be three characters wide, for example, then the codes they supply are also same the width, so a filler type or margin justification isn't needed. The code will fill the entire field.)
FIELD WITH ALL ZEROES - These steps show how to create a Filler type field with all zeroes in it. Field Name: Filler
Standard Fields: Filler
Field Type: Text
Number of Characters: 8 (or as defined by your bank's specific requirements) Filler Type: zeroes
BLANK FIELD - These steps show how to create a Filler type field that is blank or has spaces in it. Field Name: Filler
Standard Fields: Filler
Field Type: Text
Number of Characters: 8 (or as defined by your bank's specific requirements) Filler Type: spaces
ABSOLUTE VALUE OF DEBITS AND CREDITS - Some banks require the absolute total of the debits and credits (added together) in the footer line. In Dynamics GP 2016 and later versions, you can select an Amount field and the amount type of Net Total- Absolute Value. In Dynamics GP 2015 and prior versions, there is only has a Net Total field available. There is a free cnk file that will allow for absolute values in the Safe Pay file.
For more information on how to set up the SafePay Configurator, select the following article number to view the article in the Microsoft Knowledge Base:
You can contact the Partner Advisory Team to inquire on a billable consulting engagement for any other customizations needed. All services are handled through the Partner, as the only form of currency accepted is to decrement your Partner Advisory hours (PAH hours).