Format Definition for Bank Statement Processing

[Former Member]

Hi All,

I am using SAP B1 8.8 PL08

I have bank statement in .csv format and I made .bfp file through FormatDefinition add-on.

Now I am doing Bank Statement Processing but when I am importing from bank statement showing error "Operation failed due to file Mismatch". Can anyone help me out in .bfp definition. How to create it.

Regards,

Sachin

[Former Member]

Hi Sachin,

Based on 8.8 help, Not all countries have specific formats delivered by SAP. Your localization might be one of them.

Thanks,

Gordon

[Former Member]

Hi Gordon,

Thanks for reply. I am using India localization as you mentioned is right but through FD add-on we can create our customized .bfp file as per our bank statement right??

Regards,

Sachin

[Former Member]

That is right. How have you made your bfp file? Could you share more steps?

[Former Member]

Hi Gordon,

I have my bank statement in .csv format, I opened it checked columns and create accordingly in FD in .bfp file. After creation assigned in file format set in House bank setup.

Then Banking->Bank Statements and External Reconciliations->Bank Statement Processing->

import text(Tab delimited) file in Bank Statement summary.

Actually it is processing but at the end of it showing operation failed error, I checked all settings as well.

Guide me if I am wrong somewhere.

Regards,

Sachin

[Former Member]

Hi Sachin,

Why don't you use DTw for importing Bank Statement process.

regrads,

pankajk

[Former Member]

Hi Pankaj Kejriwal,

Can you elaborate how to do it and How much time you will import it for every reconciliation? Then what is the use of BTHF add-on??

Regards,

Sachin