I have situation where the GR/IR account was created without open item managed.  Now they want to make it open item but account has line items / values.  It been in use for almost a year.    Now that they are reconciling it end of fiscal year and they find a mess with account and wants to get this open item management fixed in GR/IR account for the future. 

Have tried a few option, but the system pops error message telling either " Clear or transfer all open items".  There are 10,000 line items in a/c.   How can we transfer this line item to new account.   Is there any other option to make it open item.

Answer:

For old line items, you can't enter. Before changing the account master for open line item management the account balance should be 0 (ZERO). You can try doing the following:

1. Pass one JV transferring the balance to some suspense account.
2. By doing above the balance will become 0 (zero). So change the account master & tick on Open line item management.
3. Again pass the reversal entry of the first one.

For doing the above, you may have to first remove the tick of automatic line item.
 

Please follow this steps to setup G/L 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.

Get help for your SAP FI/CO problems
SAP FICO Forum - Do you have a SAP FI/CO Question?

SAP Books
SAP FICO Books  - Certification, Interview Questions and Configuration

SAP FICO Tips
SAP FI/CO Tips and Financial Accounting/Controlling Discussion Forum

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com