Number
T his option is only relevant to certain localizations. T he field maps to OCRB. UsrNumber1.
IBAN IBAN code from the bank account setup.
Creditor Details
If the transaction type is an outgoing payment, the system will bring through the name of the Business Partner linked to the payment.
Where the transaction is an incoming payment, the system will bring through the SAP Business One company name. Data Format String from account table Acc Field Name
Code T he extended Acc
Field Name option allows the company to identify the specific master data element that is required in the export file.
If information is required that resides in Name Foreign name T elephone 1 T elephone 2 Mobile Phone Fax Email
32
Type Description Footer Fields
Options Description
Active a User Defined Field on the master data, an additional data type
User Defined Fields
should be used. On Hold Account Balance Street Block City Zip code County State Country Reference DME Identification Instruction Key Creditor Number
If the transaction type is an outgoing payment, the system will bring through the account number of the Business Partner linked to the payment.
Data Format
String from account table
Setting Up Enprise Bank
33
Type Description Footer Fields
Options Description
Where the transaction is an incoming payment, the system will bring through the SAP Business One company name
Date Date information relating to the payment
Data Format
HH:MM With all the format options, the following references are used:
YY = 2 digit year value
YYYY = 4 digit year value MM (not when associated with HH) = 2 digit month reference DD = 2 digit day reference HH = 2 digit hour reference MM (when associated to HH) = 2 digit minute YYYYDDD HHMM HH:MM:SS HHMMSS MM/DD/YYYY MM/DD/YY YYYY/MM/DD YY/MM/DD DD/MM/YYYY DD/MM/YY YYDDD MMDDYYYY MMDDYY
34
Type Description Footer Fields
Options Description
YYYYMMDD reference
YYYYDDD = special case Julian date format
YYDDD = special case Julian short date format
YYMMDD DDMMYYYY DDMMYY
Date If the format selected above is HHMM, the available options are: T oday's time Payment date For all other formats the available options are: T odays date Payment date
Setting Up Enprise Bank
35
Type Description Footer Fields
Options Description
Date + x Date information relating to the payment made but allowing the company to add on additional days to incorporate a file expiry date.
Data Format
HH:MM With all the format options, the following references are used:
YY = 2 digit year value
YYYY = 4 digit year value MM (not when associated with HH) = 2 digit month reference DD = 2 digit day reference HH = 2 digit hour reference MM (when associated to HH) = 2 digit minute reference YYYYDDD = special case Julian date format
YYDDD = special case Julian short YYYYDDD HHMM HH:MM:SS HHMMSS MM/DD/YYYY MM/DD/YY YYYY/MM/DD YY/MM/DD DD/MM/YYYY DD/MM/YY YYDDD MMDDYYYY MMDDYY YYYYMMDD YYMMDD DDMMYYYY DDMMYY
36
Type Description Footer Fields
Options Description
date format Date If the format
selected above is HHMM, the available options are: T oday's time Payment date For all other formats the available options are: T odays date Payment date
X Value Integer value Identifies the number of days that need to be added to the selected date,.
Payer Bank
Contains all the banking details of the SAP
Data Format
Option Details
Setting Up Enprise Bank
37
Type Description Footer Fields
Options Description
Account Business One company using Enprise Bank.
Option Details
2-4-7-2 bank, branch, account number and suffix in one string value.
The first option will not have an separators between the different elements while the second option will insert a - between the elements.
The first two digits will be taken as the bank number.
The second 4 digits will be taken as the branch number.
The following 7 digits will be taken as the account number.
The last 2 digits will be used as the suffix. 2473 Combination string of
bank, branch, account number and suffix in one string value.
The first option will not have an separators between the different elements while the second option will insert a - between the elements.
The first two digits will be taken as the bank number.
The second 4 digits will be taken as the branch 2-4-7-3
38
Type Description Footer Fields
Options Description
Option Details
number.
The following 7 digits will be taken as the account number.
The last 3 digits will be used as the suffix. 2474 Combination string of
bank, branch, account number and suffix in one string value.
The first option will not have an separators between the different elements while the second option will insert a - between the elements.
The first two digits will be taken as the bank number.
The second 4 digits will be taken as the branch number.
The following 7 digits will be taken as the account number.
The last 4 digits will be used as the suffix. 2-4-7-4
2483 Combination string of bank, branch, account number and suffix in one string value.
The first option will not have an separators between the different elements while the second option will insert 2-4-8-3
Setting Up Enprise Bank
39
Type Description Footer Fields
Options Description
Option Details
a - between the elements.
The first two digits will be taken as the bank number.
The second 4 digits will be taken as the branch number.
The following 8 digits will be taken as the account number.
The last 3 digits will be used as the suffix. 2484 Combination string of
bank, branch, account number and suffix in one string value.
The first option will not have an separators between the different elements while the second option will insert a - between the elements.
The first two digits will be taken as the bank number.
The second 4 digits will be taken as the branch number.
The following 8 digits will be taken as the account number.
The last 4 digits will be used as the suffix. 2-4-8-4
40
Type Description Footer Fields
Options Description
Option Details Branch
No Only Exports only the branch number associated to the bank account.
Bank No
Only Exports only the bank number associated to the account.
Account No Only
Exports only the bank
account number
associated to the account. Suffix 2 Exports only the suffix of the account number. T his option will deem the last 2 digits to be the suffix. Suffix 3 Exports only the suffix of
the account number. T his option will deem the last 3 digits to be the suffix. Suffix 4 Exports only the suffix of
the account number. T his option will deem the last 4 digits to be the suffix. BSB
Number BSB code from the Business Partner user
Setting Up Enprise Bank
41
Type Description Footer Fields Options Description Option Details defined field. Unformat ted Bank Account Number
Bank account details with no formatting applied. T his option will take the information as it has been entered into SAP Business One.
User No.
1 User fields from the bank setup.
DSC1.UsrNumber1 User No.
2
User fields from the bank setup.
DSC1.UsrNumber2 User No.
3 User fields from the bank setup.
DSC1.UsrNumber3 User No.
4 User fields from the bank setup.
DSC1.UsrNumber4 Account
Name Name of the bank
account Control
42
Type Description Footer Fields
Options Description
Option Details account setup. Swift
Number Swift number
IBAN IBAN code from the bank account setup.
Payer Details
If the transaction type is an outgoing payment, the system will bring through the SAP Business One company name.
Where the transaction is an incoming payment, the system will bring through the account name of the Business Partner linked to the payment. Data Format Code Name Foreign Name T elephone 1 T elephone 2 Mobile Phone Fax Email Active OnHold Account Balance Street Block City
Setting Up Enprise Bank
43
Type Description Footer Fields Options Description Zip Code County State Country Reference DME Identification Instruction Key Payment Currenc y
Identifies and brings the
currency symbol
associated to the payment into the export file.
T he currency option has an impact on the
Payment Field that is
brought through into the export file. If the currency is the same as the system currency, the system will export the
Data Format
Payment Currency
44
Type Description Footer Fields
Options Description
local currency value of the payment transaction. If the currency has any other value, the system will export the foreign currency payment value.
T he payment currency is set on step 6 of the payment wizard for foreign or multi-currency business partners. Payment Field Additional payment information. Data Format Payment Field Pay Field Name Payment Doc Number Payment Reference Details T he Payment Doc Number links directly to either the incoming or outgoing payments tables (OVPM or ORCT ).
T he reference information relates to the reference field that
Setting Up Enprise Bank
45
Type Description Footer Fields
Options Description
is entered on step 6 of the payment wizard. ( PWZ3.IsrRef)
Sequenc e
Number
Provides a unique reference number for each payment row transaction.
Data Format
Sequence Number
Seed Allows the user to
identify a starting number for the sequence number.
Increment Determines the value
by which the sequence
number should
increase with each payment row.
Sum Calculates the total value of the payment batch which can be added to the batch as a hash total.
Data Format Sum amount with DP Sum Accs (HSBC with DP) Sum Accs.
Sum amount with DP = totals the local currency value of all the payments in the batch.
Sum Accs (HSBC) = a format specific to
46
Type Description Footer Fields Options Description (HSBC) Sum Accs (BNZ) Sum Amount (Header/ Footer) the HSBC bank which sums the last four digits of the bank account number and then forces the result to be 4 characters by either padding the right of the string with zeros or removing the left portion that exceeds 4 characters.
Sum Accs (HSBC with DP) = similar to the Sum Accs (HSBC) however inserts a decimal point in the middle of the 4 characters.
Sum Accs (BNZ) = a format specific to the BNZ bank which combines the 4 digit branch and 7 digit
bank account
Setting Up Enprise Bank
47
Type Description Footer Fields
Options Description
totals this new number. Based on
the bank
requirements, the system then forces the result to be 11 characters long by either padding the right of the string with zeros, or dropping the left portion of the string that exceeds 11 characters.
Sum Amount
(Header / Footer) = T otals the local currency value of all the payments in the batch, ignoring the decimal point. i.e - the decimal values are assumed to be part of the actual number 123.45
48
Type Description Footer Fields Options Description becomes 12345. Unmodif ied String T he unmodified string option provides controls around the file layout and the ability to enter non- database related information. Data Format Carriage Return Empty Field No Formatting Carriage Return - forces a carriage return in the export file allow for the separation between title and header rows, or where each payment requires multiple rows.
Empty Field - provides the ability to insert a blank space in the file for data that may no longer be required by the bank.
No Formatting - provides the ability to enter static, non- database related information. T his information will be brought through into
Setting Up Enprise Bank
49
Type Description Footer Fields
Options Description
the database file with
no formatting
manipulation being carried out.
User Bank
T he user bank option will bring through the bank details of the SAP Business One company that is used is relation to the payment.
Data Format
User Bank T he exported data will include the bank code, branch ID and account number.
User Defined Fields
Provides the ability to insert data from user- defined fields on the business partner or payment methods screen into the export file.
Data Format
User Defined Fields
Field Name List of user defined fields on the BP master and the Payment Methods master.
50
2.1.2
Linking export templates to payment methods
In order to export transactions based on the SAP Business One payments wizard, export templates need to be linked to the relevant payment method that has been set up within SAP Business One. T he link is established via a user defined field on the standard SAP Business One Payment Methods form, which is created when the Enprise Bank add-on is installed.
Access to the SAP Business One Payment Methods form is from the following menu option:
Administration -> Setup -> Banking -> Payment Methods
Payment Methods Setup
T he same export template can be attached to multiple payment methods.
Having the Check Bank Details option selected is recommended as it will ensure that all the bank details are correctly entered against the Business Partners assigned to this payment method.
Setting Up Enprise Bank