cancel
Showing results for 
Search instead for 
Did you mean: 

Electronic Bank Statement: file uploading

Former Member
0 Kudos

Hello,

I have a query regarding uploading of the EBS, in FF_5 there is an option to upload 2 files one is statement file and the other is item file. What is the difference between the two and is it always necessary to upload both the files? My bank has given me only one file. Where do I upload it? as a statement file or as an item file?

And what is the use of BELNR and XBLNR fields in the same screen ?

Please explain in detail

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello

There are two files

1--- header data

2--- line item level

we need to first check the format of the bank statement file, before uploading the bank statement e.g. multicash, MT940, etc...

Accordingly there would be file format.

BELNR and XBLNR fields help to find out the reference from the EBS file so that the clearing can be done automatically. These are the field from Invoice numbers. Which help to find the correct to be cleared.

Answers (2)

Answers (2)

former_member193513
Contributor
0 Kudos

HI

As you said there are two options in Ff_5 to upload two files i e statement file and line item files

This is use full when you are uploading bank file of multi cash format

In multi cash format we will upload two files 1. header file 2. line item file

Normally banks will give you one file we have to convert the bank file in to two files for Multi cash format using some  programs ( in my case we are using z program to convert bank files in to multi cash format)

Fields BELNR and XBLNR are used to make the work  of interpretation algorithm easy.

If you have mentioned BELNR or XBLNR algoritham will check document numbers with in the range you have mentioned and post  clearing entries

Hope you are clear if not let me know

Thanks & regards

Prasad

Former Member
0 Kudos

I want to know what is the difference between BELNR and XBLNR. How they will help me. Presently I think it is clearing based on amount. Because when I try to clear incoming and outgoing payment of same amount the batch session stops at the screen where it has to pick the amount to clear. If try with different amounts this issue is not there. please help me. I upload only one file in siwft international unstructured format. And I do not use the BELNR and XBLNR.

Thanks for the first reply.

former_member193513
Contributor
0 Kudos

Hi

Check the below link it might help you

http://scn.sap.com/thread/1411720

Regards

Prasad

former_member194797
Active Contributor
0 Kudos

Hi,

don't hesitate to use F1 key.

For field "Line item file", you will get this documentation:

Line item file                                                              

                                                                            

    Enter the path name and file name for the file containing the line item data.                                                                   

                                                                            

    This field can only be entered when you use the MultiCash format. For all other formats, it is not required.                                  

                                                                            

    When importing from a PC (hard drive or disk drive), you must also specify the disk drive name (for example A:).