Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Question from PNIGAM on Dec 10 at 10:09 PM Electronic Bank Statement Derive Customer Number
Hello friends,
I am working on Electronic bank statement and the business requirement is to derive Customer number from the incoming file and if it found then clear open item, else post to incoming payment account.
I have done the following configuration.
1. I have created a new posting rule 1000 with customer. With Posting area 2 and Posting key, bank clearing account symbol, customer Posting key and posting type - 2.
2. Assigned the same to external transaction key 50.
With regards to configuration, how can I derive the customer number from the bank file? I think the possible solution would be to use standard interpretation 31. Is this correct?
Customer number is given at a fixed space in the bank file. Should I use search string?
How should I configure so that customer is derive correctly, and if customer is not found then post the document in an intermediatory account?
Further Scenario is: Direct check deposit/bank transfer from customer to our bank. In this instance it will want to DR Bank and CR Customer (Posting Area 2).
What is the configuration to ensure that if posting to Customer fails then system automatically posts fo GL account. Can we use any user exit, etc?
Thanks in advance.
Regards,
PN
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
