Normally the field GL account(BSEG-HKONT) is not readily available for substitution in OBBH.To have this done table GB01 needs to be copied and modified so as to make the HKONT field substitutable.
There may be good reasons why you want to include this field for substitution but please take care that it doesnot create any inconsistency.
Yes. You need to copy and make modifications. Standard SAP doesnot allow you to make changes to GB01.
Send me a test mail to the ID listed in my business card. I shall forward you a good doc on that.
Assign points if useful
Edited by: Aravind Aitipamula on Jan 23, 2008 9:07 PM
unfortuanately you get here completely wrong information
G/L account cannot be substituted (because of compatibility reasons and you would ruin your complete rules of accounting immediately) and copying table GB01 makes also no sense at all.
If my understanding is right, if a posting goes to a specific account (A), than you want to post to a different account (B) instead.
There are several ways to solve this:
1. A program would run each night and repost all items from A to B - In this case you have all items reposted the next day.
2. To develop a substitution exit which would add two more lines into the posting, if account A is posted:
Let's say if account A is debited with 100 USD, than the follwing lines would be added (to the already existing items):
credit A 100 USD
debit B 100 USD
This would make no balance on account A immediately.
hope this helps
Thanks for you reply. Ok, here's the scenario - Standard F110 posts automatically to FX difference GL account (Gain/Loss) for foreign currency transactions. The local currency equivalent has the following postings:
Cr Realized Gain (or Dr Realized Loss)
What i wanted to do is change the GL account of the line item 3 (Realized Gain/loss). Can i put substitution rule to that? Like, if ever there will be an FX diff, it should be posted to other GL accounts (Misc/ Suspense) instead of Realized FX diff GL account.
Thanks in advance!
Normally you shouldnt be doing this unless you have specific criteria to do so. Up till now no specific criteria is given, please give more info as to what other conditions is required. Becoz std config is to make use of OB09 where the criteria used is GL A/c,Currency code and currency type to distinguish different GL Acct posting for Forex. I believe you should at least consider the std options of Auto accct determination for Open Item Clearing for Exchange rate differences before using substitution.
Thanks for your reply =)
I think I cannot use OB09 because its a standard and global config for the business.
Here are the specific criterias for this transactions:
Transaction Code = F110
Document Type = TP (Treasury F110 Payment Txns)
Company Codes = CC1,CC2,CC3,CC4
Vendors Country Code is = to Turkey
Transaction Currency is NOT = to TRY
If those criterias are met, F110 should not post to GL Accounts for Forex diff.
Sorry Joelle, Im afraid standard application for open item clearing activating for Forex differences would be an inherent process that you could not do without heavy customisation of F110. I would strongly advise against this procedure. Our client is having the same problems but we have a weak way of making sure there would be no forex differences that is by manipulating the forex rate before invoices are entered and payment rates are adjusted everyday based on the exchange rate table. Then by assigning another exchange rate type for at the parameters of F110 to ensure the rates tie between payment and invoice. This scenario is based on the assumption that invoices are always held off until payment is required. But still we may have rounding issues, so we have to use manual payments F-53 to ensure there would be no foreign exchange differences by manipulating the local currency amount of the total payment during entry. I dont think OBBH will work at all in this case, if what you intend is to escape from the system calculating any forex differences.
Hello Loong Hin Pang,
Thanks again for your immediate response. Its not really escaping the calculation of forex difference. Actually, Forex diff will really be realized from the Invoice Date upto the Payment Date (F110 Date).We will just suspend the posting to a GL account until we receive another document from our Vendor - thats the time we will still post it to their respective FX Difference's GL account. It's actually a local regulation in that country, to only post realized FX diff once additional document is provided by the Vendor.
Manipulating the exchange rates that will be used in F110 is not also an option because it should really revaluated by the dates (Invoice Dates Vs. F110 Date).
If we are to customize F110 Program, would you know exactly the Event/Function Module/User exit that does the assignment of the FI Postings there? So we can check on where to touch the F110 Program?
Thank you very much! =)
If that's the case then it would be more of an accounting requirement of which you can post to any other account (suspense) then the finance dept would have to manually reclassify when the actual event is realised. Things should not be made more complicated than it should be. You would still be using OB09 for this setting just have to be creative about using the different combinations of criterias GL A/c, currency code and currency type. If all else fails then its a manual reclassification
Yeah, that's the initial plan to post it to a suspense account at F110 level and then will later on be reclassed to the FX diff. There should not be any postings to the FX difference in F110 postings.
The problem now is how should i do that in the system. Should i do that in OBBH? or F110 customization?
Aw.. this is a tough decision which has to be made. If it was up to me, I would just create a new bank account no which only used by F110 postings then all these postings will go to the suspense acct using OB09 settings. Please use customisation as a last resort , there will be nitemares later on just supporting the new programs.