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
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?