Hello,
I have a question about the bank statement import.
I have a line of payment that is identified as “04” and a second line that give much details about this payment line identified as “05”
When I try to import a file with those 2 types of lines, IFS considers the line “05” as an independant line and I get errors.
Is there a way that IFS detects the line “05” as linked to the previous “04” line ?
Best regards.
+15
Hi
I believe you are using external file templates for this purpose. In that case I would say to default your column number 5 to a default value. maybe to fetch the same value as column number 4 using external file templates detail function.
Let me know if you need further clarifications.
Hello
Exactly I am using external file.
Can you give me more information about this setup ?
Best regards.
+15
Hi
In the external file template you can use details functions to define the function
And you can define a function like below for the Column 5 so it would take the value from column 4 always
Hi
In my external file template I have only one column for the amount.
+15
Hi
Check you external file type definition and you would be able to add a coloumn
The problem is i’m using the french stdbank as a template and there’s only the colum “Amount” in this template.
The “Dom amount” and “Cur Amount” does not exist
+15
Hi
Please share you external file type screen shot
+15
Hi
Dom amount and curr amount is just a screen shot reference and it does not need to exactly the same in your case
Yes i got, I tried to use it.
But The problem is that in the same position i have date for the line that starts with 04
And a transaction info for the line that starts with 05.
+15
Hi
Column no in external file template can be re arranged to fit your requirements in the file
Hi
Will IFS understand that the 2 lines 04 and 05 refer to the same transaction ?
Best regards
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
