F-03 Clearing

[former_member183690]

Dear All,

we have requirement , we have  one GL which contains 14lakh open line items , we need to clear that account we know that we need to transfer the balance and make the balance Zero through F-02 ,  but when we want to see the open item balance system is throwing dump error / Abap run time error in FBL3n so we are unable to see the balance of total open items.

we check in the table BSIS there are 14 lakh open items , but we are unable to down load to excel file here also system is throwing ABAP run time error

we tried to clear through F.13 only 50k line items got clear rest still is open

any one help us .

[former_member198650]

Hi Hidyath,

If the all open items balance are 0, then run the report FBL3N, do mass changes by adding some value in the assignment field or some of the field and save it. Later in OB74 configuration you maintain the GL with the above field as a clearing criteria, later on do F.13. It will automatically clear the balance.

Regards,

Mukthar

[former_member183690]

This message was moderated.

[former_member183690]

This message was moderated.

[former_member182098]

Have you looked into OB74 transaction configuration to increase the hit rate of F.13

If the profit centers are locked write substitutions in GGB1 and assign them in OBBH.

It would ideal to extend the open item clearing layout in F-03 would ideal to include new columns. It would help users to clear them easily by sorting.

[former_member183690]

This message was moderated.

[iklovski]

Hi,

I can imagine a situation you describe. Though, of course, it was a mistake to allow this to happen. However, the only feasible solution would be clearing in portions. You have to divide your open items by group, say fiscal year, and clear them gradually.

Regards,

Eli

[former_member183690]

Hi Eli,

Thanks for the response ,

yes we agree for your advice we can do by yearly basis but when we are doing yearly basis some of the profit centers are locked system is throwing error , its not allowing to post .

Regards

Hidayath

[iklovski]

Well, this issue you would have to solve this way or another. Either unlocking profit centres or making substitutions.

[former_member183690]

Hi Eli,

Our client will not agree for any substitutions is any way, this GL is created on 2002 , is any other way we can clear whole GL open items or any Programme .

please help us

Regards

Hidyath

[iklovski]

If you clear an object with locked/non-active profit centre, you won't have any choice, except to those I mentioned.