FI- AP Open Items - historic postings.

[vasanth_rajagopal]

Hi ,

I need a Bex report which can be reconcilled with FBL1N (Open items) for any 'Key date".

The report has to calculate open items for any past historic key date. (eg: 31.12.2009).

I am currently calculating FI - AP , open items as part of aging report.

The below calculation (RKF) was tested for any date this year and it worked.

but when checked across any historic date it doesnt give

Open Items -  Amount,

Posting Date < Date Entered by user,

Clearing Date = #,

Key due date > Date Entered

Can I achieve it with requires adjustment in the above RKF.?

Regards

vasanth.R

[Former Member]

Dear Vasanth,

You can add below filter to get historic open items

Clearing Date = # or >=Date Entered by user

Regards,

Sucheta

[yasemin_kilinc]

Hi Vasanth,

If your RKF works for this year but not for previous years, then there may be some problem with previous years data. Are you sure that you have data for past years? If you have data then check the due dates of those data, they may have initial values.

Regards

Yasemin.

[Former Member]

HI Vasanth.

Since you want open items till the key date:-

We can use only these conditions, I guess:-

Posting Date <= Date Entered by user,

Clearing Date = #.

that should work for all data..

Regards,

Sakthi.