Skip to Content
0
Former Member
Dec 21, 2007 at 04:18 AM

clearing of open items

508 Views

Hi,

One of our client has one issue, They want to archive the data for a particular year. If they want to archive the data there should not be any open items for that particuar gl account.

The RFBLG table is very large and needs to be archived. Unfortunately, there are some accounts that were set up as open item managed accts that should not have been. eg.loss Clearing Acct on xxx company code. Thus, these open items not cleared are present and cannot be archived until matched off.

we have to Create a custom ABAP program that will read the open items for a selected co code for a selected account for a selected month in a selected year that will summarize by the various key fields and then mark them as cleared. Or suggest if there are any other options to handle. The initial data integrity by doc type, etc. should not be lost but used by the program when clearing the open items. Thus, balance carry forward will be correct by doc type as in the past.

So, can u please help me how i have to proceed, there are some crores of open items for that particular gl account.

Awarded with points........

Regards.

sai

Edited by: sai baba on Dec 21, 2007 5:43 AM

Edited by: sai baba on Dec 21, 2007 6:00 AM