on 05-08-2012 6:18 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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:).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.