Creating new Format Mapping for Incoming Files

To begin the Format Mapping process, we first need to create a new Format Mapping and define its header data. The following exercise will guide you through how to accomplish this.

Having defined the header data, we can now proceed to test the accuracy of the data mapping.

For this exercise, we'll be testing the mapping using a demo file for a bank statement. The demo file contains the following information:

12345678

:AI:DE54500700100113369800
:SI:00106/00001
:OB:CEUR100000
:I:PMNTCCRDFEES 22 SAP10000
:I:PMNTCCRDFEES 23 WV20000
:I:PMNTCCRDFEES 24 CIMRMAN10000
:CB:CEUR140000

Now that we've established the format mapping for the header data, the next step is to add the mapping for the items from the bank statement. Continue with the following exercise to learn how to add and configure items.

Similar to what we did for the header data, we can now test the mapping for these items as well. Follow along with this exercise to learn how to test the format mapping for the items.

Having already defined and tested the header data and items for the format mapping of the bank statement, we now move to the final step: defining the Closing Balance. After this, we will conduct a final test of the complete format mapping.

We are now ready to proceed with the last step: testing the entire format mapping to ensure its completeness and accuracy.