Skip to Content
0
Former Member
Jun 16, 2014 at 01:20 PM

Edit format in EFM, bank statement suppliers

44 Views

Hi Experts,

I'm hoping someone can help me with an BFP-file we are working on.

We are trying to create a file to import a bank statment for paid supplier invoices. It almost works. 😊

There is basically one problem: I can’t find a way to import more than one payment for the same Business Partner. The txt file works like this:

260002559334Swedbank AB (publ) Dustin AB

14000255933411233798 00000171730000000000000O2448

14000255933411247958 00000007980000000000000O2449

Where 26 specifies the BP (Swedbank in this case) and 14 are two payment details, one for 17173000 SEK and one for 798000 SEK.

I tried different specifications for transaction row etc but all of them result in only one of the payments going into SAP B1 or 3 rows (one with BP and two with transaction amounts), there is no way to get two rows with the same business partner and two transaction amounts.



Any idea or someone that has created something similar?


Thank you


Br

Anders