I spent a few hours fine tuning my clients EBS settings.
The best way to customize the Posting is to analyze real time EBS statements , and fine tune them with search strings.
The problem with that, is that MT940 statements are posting with different transaction codes, for the same bank, but in a different country.
You can create search strings for almost any data found in the note to payee field.
For the company in Poland for example, they activated Business Area as a segment for document splitting in order to be able to generate financial statements per business areas, within a single company code. The business area's are used to report on different business area's per country.
So in order to automatically recognize the correct business area, there were exchange rates mentioned.
For example : Any time there was a CSZ exchange rate mentioned, I knew it belonged to a particular business area for CZ ,and whenever HUF exchange rate is mentions, I use another for HU country.
This is a good way for statement items which can be defined.
but for other area's where it is not clear from the note to payee field, the business area is a mandatory field for posting, so the statement posting rule just goes to a red traffic light and users can just complement the posting in FEBA.
There are usually not many issues with outgoing payments that have cleared open vendor items. As long as they have been mapped to the correct sub-account such items are usually auto-cleared in FEBA.
A bigger challenge is posting entries for a Market fund account, especially when the interest earned is not separately defined.
such entries get tagged with an automatic payment advice note.
Within FEBA, you can then change the principal amount on the payment advice, take off the interest part, post the difference to the interest earning account and clear the principal against the originial investment placed.
There are some gray area's where information is missing, so you need to park the statement on a suspense account. for example, in some cases, a investment account needs to be posted to. but there are different transactions, whith different currencies, requiring different GL Accounts.
In those cases, you sometimes have to let the user decide where the posting will go to.
You make a initial posting to sub-account (reflecting a green traffic light) and then let the user transfer post the suspense account item to the actual GL account.
Configuring Electronic Bank statements on SCN
7 comments:
Some links to Related topics : http://www.sap-topjobs.com/bankreco.pdf
Nice post ! Keep an open mind and you can tap into the collected wisdom of smart people all over the globe and from many different industries and backgrounds.
SAP FICO Training in Chennai
Best SAP finance and controlling(FICO) Training Institutes in Chennai by Leading HR Company.Real Time SAP FICO Training by Mr.Karthick.
Contact No: 9003085882
http://thecreatingexperts.com/sap-fico-training-in-chennai/
We also provide this SAP FICO Training in Vadapalani,Velachery,ECR,Adyar,Chrompet,
Pallavaram & Guindy.
Class Room / Online Training Available!
To get the best training with hands on real-time projects for SAP FICO take a glance at http://thecreatingexperts.com/sap-fico-training-in-chennai/
CREATING EXPERTS is the destination,if you are looking for hands on training with real time experience in SAP related professional courses,for SAP FICO training take a look at
http://thecreatingexperts.com/sap-fico-training-in-chennai/
This blog article is much good to learn in all perspectives.
But having a trainer and working with real-time scenarios give us a much more targeted approach to our career.
Anyone looking for a SAP FICO can approach THE CREATING EXPERTS
This is an awesome blog thanks for information.
Contact: 8122241286
http://thecreatingexperts.com/sap-fico-training-in-chennai/
Contact for SAP Certification Training & Support
Email: sap.cert.help@gmail.com
Post a Comment