How do I generate an ESR testing file?

Steps

Prepare the ESR testing file

1. Start with a text file like this one: ESR-file-how-to.txt

   Note: You can use any text editor to open and edit your file. We do recommend using Notepad++ for its text selection highlighting feature.

   

   Explanation:

   • The upper part contains two example ESR lines based on the first reference number.
   • In the lower part the new file is built based on your reference number.
     
     
2. Copy the reference number of your invoice (taken from the database) and paste it above the lower reference number.
3. Split the reference number using spaces exactly like in the file (see screenshot), to have all those separate parts.

4. Then select one part in the original file to see which part of the line itself is selected:

   

5. Select the equivalent part of the reference number and copy it over to its corresponding place in the line:

   

6. Repeat this procedure for all other numbers:

   

Save the ESR testing file

1. When you are done preparing the file, copy the lines and paste them to a new file
2. Important: Remove all white spaces between the numbers to avoid errors!

3. Give your file a name, e.g., something.v11.

   

Notes

1. These numbers are not part of the reference number. They define the date when the import shall be done:

   

2. These numbers can be ignored. Leave them at 0.

   

3. For higher amounts, just go to the left and replace those zeros.

   Note: This procedure is TBV (To Be Verified) as higher amounts haven’t been used for testing before.