Search for answers or browse our documentation.
CSV
First National CSV Screen
Figure 1
User statement reference – This decides what will appear on the Customer statement reference on the file that is sent to the bank: “Supplier name”, “EFT number/Supplier code” or “EFT number/Supplier name”.
Encryption required – Yes (if this check box is ticked)/No (if the check box is not ticked). If selected, a calculated encryption will be included in the BTS file extracted for the bank.
Namibia – Yes (if this check box is ticked)/No (if the check box is not ticked). If selected, there are 2 fields on the Supplier Maintenance that are needed to be populated and these two fields appear on the payment extract file. If this fields is unticked (set to No, these fields are not used). Please note this feature is only available from SYSPRO 8 onwards.
This BTS Bank format is available for the following SYSPRO Nationalities:
- RSA (Republic of South Africa)
Additional Information Trigger Screen
There are extra details required when using this BTS bank format. When maintaining the Supplier and/or Cash Book beneficiary in SYSPRO, the following screen as per Figure 2 will be seen:
Figure 2
It is possible to send a payment notification to a maximum of 5 email addresses, 2 SMSs and 2 faxes. The notify fields above are used to action the details entered.
All the fields in Figure 2 are optional and are generally explained below:
- notify fields – if entered to be used must contain Yes. The 2 fields following each notify field will be ignored by the bank if this field does not contain Yes
- email address fields – if entered to be used may not exceed 200 characters and must contain the email address to send the payment notification to
- subject fields – if entered to be used may not exceed 50 characters. These will be seen on the email to be sent as proof of payment
- code fields – if entered to be used must contain the first 3 digits of the cellphone or fax in question
- number fields – if entered to be used must contain the remaining 7 digits of the cellphone or fax number in question
SWIFT BIC Code
SWIFT BIC code – This field is mandatory if the Namibia switch in the control has been selected for this format and optional if not selected. This field will replace the supplier’s bank branch in the extracted file for Namibia. Please note this feature is only available from SYSPRO 8 onwards. Available options to select from as per Figure 3
Figure 3
Reason Code
Reason code – This field is mandatory if the Namibia switch in the control has been selected for this format and optional if not selected. This field is added to the end of the payment file only if Namibia in the control has been selected. Please note this feature is only available from SYSPRO 8 onwards. Available options to select from as per Figure 4
Figure 4
CSV(First National)