Electronic incoming bank transfer to FICA payment lot

[Former Member]

Hi export ,

Can anyone advise me how to handle the bank incoming file transfer to FICA payment lot?

I tried to ran T-code FPB7 but there is always show no data . does anyone figer out what kind of data should input for " ID"

[Former Member · Accepted solution]

Hi Mary Lee.

In order to use the FPB7 transaction (Data transfer from Account Statement to Payment/Returns Lot) for electronic bank statement, you first need to have the electronic bank statement imported into the FI part.

Check transaction FF_5 which imports the electronic bank statement data file in various formats into the SAP. Once you have the electronic bank statement imported, go to transaction FPB7 and choose Company code, House bank, House bank account and Statement number. The latest field will autocomplete the statement date and ID (which is usualy the statement number).

In case you want to import the electronic bank statement only to FI-CA part, then check transaction FPB17. In that case, you will have to have the electronic bank statement in MultiCash format.

Marko

[Former Member]

Hi Marko,

Thank for your help.. I 'll go back FI to check that ...

Mary

[Former Member]

Hi Marko ,

Thanks for your response , so helpful to solve the problem.

May I ask you another question here ?  In bank incoming file there will some reference no.(like invoice no.)  for clear open item purpose , my question is how to connect this reference no with open item? I know there is standard event 0950 ,could you give some idea?

thanks !

Mary

[Former Member]

Hey Mary Lee.

Connecting the open items with the payments is done via Note to payee functionality. You can chech that in Financial Accoutning (New) – Contract Accounts Receivable and Payable – Business Transactions – Payments – Processing Incoming and Outgoing Payments – Define Interpretation Rules for Note to Payee (and the following programs in IMG, where you can test your setting).

Using that functionality, you can define how will you "read" the note to payee field from the electronic bank statement (you have that field in the MT940 file format, if youre using it; if youre using the local country file convertor, then you have to check which fields get written in the needed field) and how will you extract the data to identify the open item. For example, you can use the document number, or the combination of contract account and reference document number, or any other solution that fits your business scenario.

Marko

[Former Member]

Hello Marko,

Could you guide me how to config "Define Interpretation Rules for Note to Payee"  . if we use BP no.+ Invoice no.as key field . since I have done define rule ,but I  didnot get expected results from test run.

Thanks in advance!

Mary

[Former Member]

Hi Mary.

There is a variety of different setups for the note to payee field, but if your single field consists of the contract account + invoice (for example: 98114-322318) then I suppose you will have to expand the default functionality with your own logic, to combine the two information.

Additionaly, if you use invoice number, it should be enough to determine the business partner from it, and then you will have everything you need to correctly connect the payment with the invoice, assuming the invoice number is unique and not issued per business partner.

Marko

[Former Member]

Thanks Marko.

[Former Member]

This message was moderated.