cancel
Showing results for 
Search instead for 
Did you mean: 

GL a/c clearing - F-03 shows different value than the FBL3N

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member200703
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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:

Postings to G/L accounts with open item management are not permitted

Message no. FAGL_POST_SERVICE012

Diagnosis

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.

Procedure

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

former_member200703
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Mahmoud,

Thanks for your reply. Yes, these account being set up in OBA1 but Bal.Shett.Adj. is same account ( ex: 113006). Could that be a reason for this error? 

regards,

Sanjay

former_member267327
Active Participant
0 Kudos

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.

former_member200703
Active Contributor
0 Kudos

Hi

yes , this might be the reason , you need to assign different BS GL with line item management..

Regards

Mahmoud El Nady

iklovski
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Sanjay,

It may be due to system termination. for the above issue you please run Transaction GLGCU1 give parameters then execute. then consolidate the balances of both.

Thanks,

Arun

nru_house
Active Participant
0 Kudos

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!!