Skip to main content
Solved

Error when importing external file template STDFRBNKSTAT


Forum|alt.badge.img+4

Version : 23.1.4

External file template STDFRBNKSTAT is used to import standard external CFONB file (file template issued by French banking society)

External File Template
​​​​

A dedicated external file template STATFRANCE has been created by copying standard template STDFRBNKSTAT

Banking file import has been done based on STDFRBNKSTAT template

External File Transactions

However lines starting with 04 have not been imported

Error statement ‘Unpack error’ : “Format de valeur ou symbole décimal non valide dans le fichier chargé.” Meaning format not appropriate

 

Possible root cause: 

 

  • Standard banking file incorporate alphanumeric values in amounts (eg E on below screenshot).
  • These values are used to determine signs and others information. Below matrix to interprete these values

 

  • I need some assistance to resolve this issue. 

Best answer by Suchithra Fernando

Hi @bergeron,

We have successfully resolved the issue. The problem was related to the external file, which did not conform to the required format ‘STDFRBNKSTAT’ and the structure specified in the external file template. Please review both the external file and the template. If you continue to experience issues, feel free to raise a ticket for further assistance. 

Best regards, 

Suchithra. 

View original

Forum|alt.badge.img+1
  • Do Gooder (Customer)
  • November 5, 2024

bonjour, auriez vous reussi à passer cette problematique. nous aurions sur ifs et nous avons besoin d’importer nos releves. merci pour votre aide

 


Forum|alt.badge.img+4

Hi @bergeron,

We have successfully resolved the issue. The problem was related to the external file, which did not conform to the required format ‘STDFRBNKSTAT’ and the structure specified in the external file template. Please review both the external file and the template. If you continue to experience issues, feel free to raise a ticket for further assistance. 

Best regards, 

Suchithra. 


Forum|alt.badge.img+1
  • Do Gooder (Customer)
  • November 21, 2024

bonjour, pouvez vous m’envoyer un exemple d’un fichier repondant à la structure de STDFRBNKSTAT car j’ai le meme pb avec mes releves afin que je pusise voir avec les banque pourquoi je n’ai pas le bon format. merci

 


Forum|alt.badge.img+1
  • Do Gooder (Customer)
  • November 21, 2024

ma question est surtout de savoir si vous avez trouve comment retranscrire l’alphanumérique qui est sur les montants des relevés bancaire?

(Standard banking file incorporate alphanumeric values in amounts (eg E on below screenshot).


Forum|alt.badge.img+1
  • Do Gooder (Partner)
  • November 26, 2024

Hi everybody,

Anyone in France who succeeded to handle French Bank Statements import in IFS Cloud ?

We are struggling with that issue within 24R1, while IFS documentation states that CFONB format for French Bank Statement is covered in standard by 24R1 release.

We have to handle hundreds of bank statements import in IFS Cloud per day, in order to proceed the bank reconciliation process.

Thanks in advance for any help you can provide ! ;-)


Forum|alt.badge.img+1
  • Do Gooder (Partner)
  • November 26, 2024

Hi ​@Suchithra Fernando ,

I read your message but sorry I didn’t get what you mean.

Indeed, the bank statement files are provided by the bank, and we cannot change them.

Regarding File Template STDFRBNKSTAT it is supposed to be structured in a way that enables it to be used without modifications to import French Bank Statements.

Thanks in advance for all clarifications that you can provide.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings