A Dutch customer is using bank statement processing for importing bank statements of the Dutch bank Rabobank. It is beneficial that there is an EFM bank statement available already, which the customer is using for its bank imports.
However, there are some issues with matching the invoice references in the bank statement and documents in SAP B1.
Question: What function do I need to use to get the complete invoice number in the Document-ID field?
If this can be done, all the invoice numbers can be matched through bank statement processing automatically.
I tried out the following solution myself, but this didn’t fix the whole problem:
[see image 3 - image-3.jpg]
The result was not suitable because the ‘enter’ didn’t result in taking the whole invoice number to the Document Identifier field in SAP.
[see image 4 - image-4.jpg]
I am very interested in the solution for this issue. Thanks in advance.