Payment Wizard - Bank File Creation not working (Japan Customization)

[mreinhardt86]

Hello forum,

we are implementing SAP Business One v10 for a customer in Japan.

We would like to create bank files for outgoing payments via the Payment Wizard.

We have activated the Payment as well as the EFM Format Definition Addon.

Each time we want to generate a file, we receive the following error that the "Payer Name" is missing (支払人名 in Japanese). I understand that the program is referring to OPEX table. I checked the table but couldn´t find an entry which mentions the "Payer Name". We selected the "SAPBPJPOPBT_JIS" template as delivered by SAP.

My questions would be:

1) Can somebody please point me into which direction I have to look? Am I missing something?

2) Is there any way to download the SAPBPJPOPBT_JIS and check the mapping logic? Or can the original template be found as part of the installation files?

As a remark: Before, we had another error that the "Payer Code" was missing (支払人コード). I checked the House Bank master and found an entry called "Company Code". I set a dummy value and the error disappeared, which led me to the current one.

Any hint is greatly appreciated!

Thank you and regards,

Michael

[hdolenec]

These errors are usually from EFM mapping file, because you can define conditions for each tag in XML. Maybe you have payer code in OPEX table, but it's not mapped in appropriate field in EFM.

To access mapping file, go to Payment MEthods => CFL button on field Format File => New => right click on format => Download Format Project. When you donload it, you can open it in EFM and check everything (from EFM you can download CR file that is a data source for mapping).

[mreinhardt86]

Hello Hrvoje,

Thank you very much for your input!

Initially I thought that it might be related to a mapping issue. I tried to download the format project for the file but got the following error:

"File format not assigned yet"

Currently, we have the following file format setup in our system:

For Number 2-4 I am able to generate an output file, although it (obviously) does not match our country specific requirements. No 1, the one in question, will give us the error.

Interestingly, during the payment wizard not SAPBPJPOPBT_JIS is mentioend as the "Bank File Format type", but "DLL Format", although I assigned the JPOPBT_JIS to that specific bank account.

Thank you and best regards,

Michael

[hdolenec]

Hmm that is a bit strange, because the error would indicate that a format is assigned, but "Payee Name" field remains empty even though it should be filled. I would expect a different error if the format was not assigned at all, but never mind. It seems that you need to create a mapping for this mapping from the start, by using EFM.

[mreinhardt86]

Hello Hrvoje,

Thanks again for your reply.

Some kind of format is being used - I am just not sure if it is the DLL one or the EFM one.

I might have to reach out to SAP directly as I would like to avoid coding anything myself.

Again, thank you very much.