Open items report

[Former Member]

Hi

I required to get a report which shows the number of open items. The report should contain the GL account and the number (count) of open line items. This should also have the facility to execute several GL accounts at once as well.

I checked with FBL3N, but it does not show the number of open line items for the GL accout

Please let me know the transaction code for such report

Thanks

[Former Member]

Hi ArithW,

For the number(count) of open item you can use SE16.

- Open Item G/L Account : BSIS

- Open Item Customer : BSID

- Open Item Vendor : BSIK

You can directly see the count of open item in "Number of hits"

[Former Member]

Hello everybody:

I need open clearing items to clearing with other items. For example in my job was issued a payment to a supplier, but was applied to the wrong invoice, for this reason I need to open this compensation payment and apply it to the right invoice, the Tx FBRA, tells me that I must cancel the payment, but the payment was delivered and collected by the supplier, so I can not avoid it and just need to open the clearing.

Can us help me please????

Thanks

María

[kingofthe_ring]

Dear,

In tcode FBL3N, after putting the G/L account number, you need to select the option Open Items which at the bottom and then execute the report.

It will give you the detailed information about the open items as per the G/L account.

regards

[Former Member]

Hi

Actually my requirement is to analyse the number of open litems. Ie say in one GL account I got 50 open items, the report should show the GL accout ID and the how many open items are there for that GL account. I do not require a detail report. Only require the GL account and th count of the open items

Thanks

[kingofthe_ring]

Dear,

As per my knowledge this is not possible.

regards

[Former Member]

Hi ArithW

try with report painter using a library that refers to FI table (i.e. GLT0, GLT1,... GLT3) or some ZGLT table used as mirror ( more details are on FI- SL customizing]).

Than you can check the count indicator, otherwise a simple query onto the referred tables