Reg:Open Item Management

[Former Member]

HI Guru's,

At the time of GL/AC creation my client is not click the Open Item management and posted some documents. now my client needds to add open item managemnt to particular GL Accounts. How to do it plz advice me.

regards

JK

[Former Member]

Hi

if you directely change fs00

Error msg will come like dis

This account does not balance to zero.

for that you nned to that Zero that particualr GL after that you can change...

regards

ss

[former_member597706]

Hi,

I am also facing a simliar scenario. I have made the account balance zero (i reversed the accounting document posted in this fiscal year) and when i am trying to master data in FS00 i am getting an error saying that - "Account Balance is Zero- open items still exist in the account".

I am not able to understand - when we say make the account balance to Zero- what exactly needs to be done.

Thanks and regards,

Ankur

[Former Member]

Some open items may exits in your account.

first check your account using FBL3N(GL LINE ITEMS DISPLAY) is there any open items , if you have open items first you clear open items.

Then change the GL account .

system will accept.

chandra

[former_member597706]

Hi,

Thanks for your reply. Yes some open items do exist in that account.

But I tested one more account. for that account i executed the FBL3N report and as of today in that account open items also exist- though for that account no balance carry forward has been executed for the current fiscal year and nor any document has been posted.

Why the system is behaving in a different way- when open items exist for both the accounts.

Ankur

[Former Member]

HI Chandra

Can we clear items on two different GL accts.

If so please let me know the tCode and also any GLmaster changes , if needed

Thanks

[Former Member]

Hi,

Is this resolved or not because i have faced same kind of problem, but it was resolved

Thanks

phaneendra

[Former Member]

HI Phaneendra, Can you please let me know the solution , as how you resolved this issue?

Thanks in advance

Sharath

[Former Member]

Hi,

GL OPEN ITEM MANAGEMENT

Any GL account has a balance standard SAP will not allow to change status to open item managed, if the GL account is not an open item managed earlier. “Z” Program (ZRFSEPA02) will make it an open item managed.

We have created an OSS Message and SAP told us to copy RFSEPA02 to Z program(ZRFSEPA02) and

Follow the steps to enable Open Item Management for GL accounts

Step # 1

Create a Dummy or Temporary clearing account to move balance from clearing accounts.

Use t.code FS01

Step # 2

Move balance from clearing account (Ex: 113073) to Dummy account.

Post a journal entry using T.code F-02 or FB50.

Step # 3

Lock Clearing account for any postings.

Use T.code FS01 and Lock the account.

Step # 4

Run Z program

To go T.code SA38 and enter program: ZRFSEPA02 and Execute.

Enter Company Code: 1000

GL account: 113073 and Execute (F8).

Step # 5

Go to T.code FS01 and validate GL account Open Item Management check box and unlock account for postings.

Step # 6

Move balance from Dummy account to Clearing account (Ex: 113073).

Post a journal entry using T.code F-02 or FB50.

Step # 7

Validate Clearing account (Ex: 113073) and Dummy account balances.

Use T.code FBL3N

Step # 8

Clear dummy account balance using T.code F-03

Please execute each step carefully and follow aforementioned steps to convert non open item management GL accounts to open item Management GL accounts.

If this helps,please assign points.

Thanks,

Rau

[Former Member]

HI Rau

Your explanation seems interesting and seems to work in my case.

please read my issue:

I have an acct 200024(GRIR clearing acct)-Open Item Managed.

I have a P/L acct 456020(Freight Cost on Sales)(not open item).

There are some wrong Credit entries made into acct 200024(GRIR) with off setting Debit entries into 456020.

Now we want to manually clear the open items in 200024 and make offsetting entries into 456020.

The business people dont want to reverse the documents which made wrong entries , but need a solution to clear the open items in the GRIR manually.

please respond with Tcodes, so that I can have a clear idea.

Many thanks in advance.

Sharath

[vinay_h]

GO TO - T.code F-03 and select the open items in GR/IR clearing account (Open item managed). This will be debited automatically.

Select back button and pass seperate line item for the balance offsetting credit to frieght account.

By this, GR/IR is open items will be cleared and line item is recorded in non open item managed account (Freight).

Hope I have provided a suitable solution.

Vinay

[Former Member]

Hi,

First u have to check the balance of that particular G/L account and reverse that balance by posting another entry after that you have to select open item for that particular G/L Account

Thanks

Phaneendra

[Former Member]

HI Vinay and Phaneendra, I tried as you said, it says

"GR/IR clearing account cannot be manually cleared".

Please suggest.

Thanks

Sharath

[Former Member]

hi

have you checked the balance by using T.Code fs10n

Thanks

Phaneendra

[Former Member]

HI Phaneendra

Yes, I checked,

there is a debit balance it it.

Cant we post to a GRIR clearing acct manually which is a Open Item managed acct?

Thanks for all the messages, I really appreciate it.please help me in resolving this issue.

Sharath

[Former Member]

HI,

Please de-select the post automatically only in that particular G/L Account

Please let me know

Thanks

Phaneendra

[Former Member]

OK I did deselect post automatically in the GL master for GRIR acct.

So do you think, now I can just post any entry to clear the open items in the GRIR acct and the offsetting entry to another acct? If so please let me know the steps and the Tcodes for that.

Many thanks man.

Sharath

[Former Member]

HI

By using t.code f-02 you can post the reverse entry for that one

for eg:that particular G/L acount having 1000 /- debit balance you have to reverse that one by crediting that particular G.L account and select open item for that particular G.L account

please do it first in tst system

Thanks

phaneendra

[Former Member]

hi guru,

u done a good job, u r explanation is very good, but guru i have a doubt pl explain, what is the meaning validate, and at what situation we prefer valadation. pl explain guru,

with regards

raja

[Former Member]

HI Phannendra

Cna you please explain the reverse entry and oepn item selection, can you please explain , as how to do in my situation,

Your explanation seems interesting and seems to work in my case.

==================

please read my issue:

I have an acct 200024(GRIR clearing acct)-Open Item Managed.

I have a P/L acct 456020(Freight Cost on Sales)(not open item).

There are some wrong Credit entries made into acct 200024(GRIR) with off setting Debit entries into 456020.

Now we want to manually clear the open items in 200024 and make offsetting entries into 456020.

The business people dont want to reverse the documents which made wrong entries , but need a solution to clear the open items in the GRIR manually.

please respond with Tcodes, so that I can have a clear idea.

Many thanks in advance.

Sharath

[Former Member]

Hi,

the substitution and validation is generally used to post any value to Fico side if it is not happening automatically we can use this substitutions and validations

for eg: one particular cost element related to primary cost /cost reducing revenues, but we want to post some of the revenue amounts in that particular cost element in these circumstances we can use this substitutions and validations

condition which was given in substitution if it satisfy the value will pass to that particular cost element if not satisfied the error will come based on validation

Thanks

phaneendra

[JozsefSzikszai]

hi JK,

first make the G/L account balance to zero, than you can change the master data. If you want the earlier posted items to be open itam managed as well, than you have to block the account from posting, run program RFSEPA02, than unblock the account.

hope this helps

ec