on 08-27-2015 6:18 PM
Hi Experts,
We are having trouble in F-03 clearing GL account. The value in the GL line item display (FBL3N) net Zero, but when we go to F-03 to clear the line items, it shows different values.
Ex: (FBL3N – item value USD 130 but in f-03 value is USD – 115)
What could be the reason and how to correct this?
Thank you in advance for your help!
Sanjay
Hi
It looks like its resulted from foreign currency valuation ..you need to check the document currency for this transaction. You will find its recorded by different exchange rate . F-03 is using today exchange rate applied in system to calculate the value.
Regards
Mahmoud El nady
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mahmoud,
I checked the document currency, the user has posted manual entry with different exchange rate and this account hasn't used for FX revaluation. I tried to run FX revaluation but I get the following error:
Message no. FAGL_POST_SERVICE012
You use G/L account XXXX in company code XXXX with open item management. However, postings are not permitted to G/L accounts in individual ledgers with open item management.
If you have not yet made any postings to this account and if the account is to be used for closing processes in non-leading ledgers, deactivate the Open Item Management indicator in the company code data for the G/L account.
Is there any other option to clear this without deactivating IOM?
Thanks
Hi
the error relsulted from that this item is managed as open item , the revaluation process need to post the difference on line item GL .. Could you check the FORX configuration for this GL in OBA1 - Exchange Rate Dif.: Open Items/GL Acct.
you need to assign line item GL on balance sheet adjustment GL
Regards
Mahmoud El Nady
Hi Sanjay,
If GL is balance sheet account in 'Bal. Sheet Adj.1' then it won't be problem. But if it has open item management activated then it creates problem.
Ideally, we dont assign the same gl for which we are valuating foreign currency valuation in balance sheet adj. field to post differences.
Regards,
Dattatraya B.
Hi,
This message comes from system design. You can deactivate it, though. Please, consult note 1646406 - FI FAGL_FC_VAL/FAGL_FCV throws error FAGL_POST_SERVICE012 Postings to G/L
accounts with open item management are not permitted
Regards,
Eli
Hello Sanjay,
In FBL3N select open items on key date. It will show all the open items even it has cleared in past.
F-03 only impact to open items to be cleared.
Hope this helps!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.