CREATING A FORMAT FOR A CSV FILE CONTAINING INFORMATION FOR RECONCILIATION USING ELECTRONIC FILE MANAGER PART 2
This blog is continuation of :
CREATING A FORMAT FOR A CSV FILE CONTAINING INFORMATION FOR RECONCILIATION USING ELECTRONIC FILE MANAGER PART 1
Aimed to explain how to design a bfp file bank statement format type, containing information relevant for reconcilation in SAP Business One Bank Statemt Processing.
(Steps 1 to 4)
–CONTINUATION (from STEP 4)–
The import statement functionality is designed to link the statement to the specific bank account selected in the bank statement processing window.
This has one consequence: The mapping of the bank account is mandatory.
Problem: In the csv file we don’t have any information related to the bank account, the bank account is something that we just know.
The functionality allows assigning a Constant instead of Source value, so we will set our bank account as a constant value
The system allows assigning an additional field to same position, so we do will use any of the already defined fields and link to it the additional mapping
Give Name and a Reference No
Notice that we are assigning same location (index 1) than the field Date.
Could be any field that we are sure must be present in the file.
Notice that we have selected the box Use Constant instead of Source Value and in there the bank Account: 12345678
5 DO TEST HOW WOULD IT LOOK LIKE: DATA PREVIEW
In the menu File>Data Preview you can check if the outcome is as you like:
6 DO TEST IN BUSINESS ONE
After having assigned the new format to the company database and bank account 12345678 you can test with sample
Training material and other examples related to this topic can be found in: