Field
Options
Details
Format ID T his is a system-generated field value providing a unique reference to each import template that is created.
Bank Name A user-entered description of the template which is generally used to identify which bank the template relates to.
Setting Up Enprise Bank
53
Field
Options
Details
One relating to this bank template. T his is a default value and can be altered when processing the import allowing the user to have multiple bank accounts linked to the same template.
Transaction Date T he column number in the bank-generated import file that relates to the date of the transaction. Cheque No T he column number in the bank-generated import
file that relates to the cheque reference number.
Details T he column number in the bank-generated import
file that relates to the details about the transaction. Reference T he column number in the bank-generated import
file that relates to reference information about the transaction.
Particulars T he column number in the bank-generated import file that relates to other party information about the transaction.
Header Row Skip T he header and footer rows which usually contain column titles which are for the benefit of the file user, but not required by the system when importing the file. T hese rows within the import file need to be ignored when the system carries out the import. T his option identifies to the system the number of rows that should be ignored and not imported into SAP Business One.
54
Field
Options
Details
Footer Row Skip T his option is the same as the Header Row Skip function but applies to footer information within the import file which is not relevant to the import. Field Has Total
Amount Certain import files separate out the incoming and outgoing amounts into two columns, while other files contain a single column for all the transactions with a designator (such as a - sign) to identify whether the value is an incoming or outgoing transaction.
Total Amount T he column number in the bank-generated import file that relates to the total transaction value. T his option is only enabled if the Field Has Total
Amount option is checked.
Credit Amount T he column number in the bank-generated import file that relates to the incoming transaction value. T his field is only enabled if the Field Has Total
Amount option is not checked.
Debit Amount T he column number in the bank-generated import file that relates to the outgoing transaction value. T his field is only enabled if the Field Has Total
Amount option is not checked.
Reverse Sign With certain bank files, the file is generated from the bank's perspective rather than from the customer's perspective. T his results in a negative
Setting Up Enprise Bank
55
Field
Options
Details
amount (which in the bank's perspective is an outgoing transaction) actually reflecting an incoming amount for the customer and vice versa for positive amounts.
T he reverse sign orders the import process to reverse the sign on the transaction so that negative amounts are treated as incoming amounts, and positive amounts are treated as outgoing transactions.
T his field is only enabled if the Field Has Total
Amount option is checked.
Evaluation Column Where the actual transaction amount does not designate an incoming or outgoing payment, but rather another column in the file provides this information, the company can specify the column number related to this field.
T his field is only enabled if the Field Has Total
Amount option is not checked.
Value If the company chooses the Evaluation Column option, then the value column needs to provide the information that the system must use to evaluate whether the transaction is an incoming or outgoing value.
T his field needs to hold the field value from the file that relates to either the incoming or outgoing
56
Field
Options
Details
transaction.
Type Debit - Column Value
indicates Debit
Credit - Column Value indicates Credit
T he type field identifies whether the value entered in the Value field reflects the designator for an incoming (credit) transaction or an outgoing (debit) value. If the system encounters a transaction that does not contain the value entered in the Value field, the system will automatically assign it to alternate the Type value.
Date Format DMY
DYM MDY MYD YMD YDM YD
T he format of the date that the bank uses when exporting the data.
Date Separator / - . ~
T he separator that is used by the bank to separate the different date elements.
Values Have Decimal Identifies whether the amount columns within the bank file contain decimal values or not. If the option is unchecked, the system will then assume that the last two digits in the amount columns are decimal values.
Setting Up Enprise Bank
57
Field
Options
Details
Remove Non-
Numeric Characters from Value
T his option will automatically remove any non- numeric characters from the amount columns on import of a file. T his is to accommodate the scenario where the bank files automatically contain the currency symbol in the amount columns.
Use Non Default
Separator Character T he system assumes that the file is a comma separated file and evaluates the columns based on this structure. If the bank uses an alternate separator between columns, the separator needs to be identified.
Character T his field allows the company to specify which character is used to separate fields within the bank export file. T his field is only enabled if the
Use Non Default Separator Character option is
checked.
2.3
Data Export / Import
An import and export function is available to allow templates to be transferred between databases. T he functions can be accessed from the Administration -> Data Import/Export -> Data Import or Data Export.