I am having problem while automating EBS upload in SAP
Currently people here use to do it manually, assign each line with particular G/L account
What I need to do is to automate such process. The process is like we receive bank statements for reconciliation from different banks. They are around 20 and use to send Debit amount, credit amount, Text field that has description of transaction and date. We manually have to add G/L account after analyzing it that is 0001,0002, etc. Can you please suggest if it can get automated. What we have figure out is to design a program that reads Text and on the basis of its text we add G/L account no. But I m not sure if its suitable for us or is it a best practice. The problem is banks do not provide bank statements in any format and though we have to do it manually. Kindly suggest some solution to it or whats the best practice to tackle such process.