02-08-2018 2:15 AM - edited 02-04-2024 3:00 AM
Hello Experts,
I'm hoping someone can give me some direction. I am working on configuration for all of our bank accounts. I have a couple of accounts where checks are issued from SAP using F110 functionality which I can easily clear using standard configuration including creating a Posting Rule using Posting Type 4 - Clear debit G/L acct and then assigning the BTC (475) to our Transaction Type. These banks also have checks that are issued outside of SAP and are recorded in the G/L using manual journal entries. There is no check detail to clear against. I am trying to figure out if I could use Search String functionality to configure BTC 475 "twice", once using the Posting Rule mentioned above and again using a different posting rule of type '1' - Post to G/L account. I've never used the Search String functionality so it's a bit confusing to me. I would want the search string to find the check numbers for the SAP checks by looking for a number LIKE '2nnnnnn' and the second Search String to look for non SAP checks by looking for a number LIKE '23nnn'.
I don't want or need (at least I don't think I do) to fill a "Target Field" since I already have the check number for the SAP checks and can easily clear them with algorithm 011.
Am I completely on the wrong track here? Are there other suggestions on how to accomplish this?
Thank you!
Barbara
Hi Barbara,
I would recommend that you separate the SAP and non-SAP checks to different bank accounts. Then, set up a separate transaction type for the non-SAP check account. You can do so by copying the transaction type for the SAP check account and renaming. Then, change the clearing algorithm from 011 to 015. This clearing algorithm will facilitate clearing by the assignment field. The assignment field on the manual journal entries must contain the check number on the clearing bank line (credit) entry. Please let me know how this works out.
Sincerely,
Steven Dey
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
The below blog series should help you to achieve the same using search strings
https://blogs.sap.com/2014/05/06/ebs-configuration-of-search-string-part-1/
regards
Sanil Bhandari
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.