cancel
Showing results for 
Search instead for 
Did you mean: 

Exclude posted items in FAGLB03

former_member242326
Participant
0 Kudos

Hello,

When we use transaction FAGLB03 (G/L Account Balance Display), we have some GL accounts that have lots of items.

The selection we make is this:

We execute this request, the next screen is shown:

On the screen we double click the amount at period 8 (yellow field). This pop up is shown:

We select Yes, because we only want to see open items.

On the result screen, which takes a long time to show, we see open items (red icon), but also posted items (green icon):



The lines with a green icon are posted, the are automatically cleared by the system, balance 0.

The manually cleared items are not showed.

How can we prevent to show the posted items? We selected the open items only here!?

Is it possible that those posted items causes the long wait time?


Thanks!

Accepted Solutions (0)

Answers (3)

Answers (3)

João_FI_FIN-CS
Active Contributor
0 Kudos

Hi,

Is strange. I guess is better you contact SAP.

JPA

former_member267327
Active Participant
0 Kudos

HI,

In report FAGLL03 change the layout where you can sort your line item by RED i.e. OIM and set this as default layout to this account so next onwards whenever you will run this report it will show you open item only.

Second way is create new GL on OIM basis and transfer all your entries to this account and cleared all transaction from old GL account. so it will aslo reflect in your financial stament (if it is balance sheet account).

In case of clarification, please let me know.

Regards,

Dattatraya

João_FI_FIN-CS
Active Contributor
0 Kudos

Hi,

If this account has a flag to display items, why don't you use the FAGLL03 just for open items?

JPA

former_member242326
Participant
0 Kudos

Hello JPA,

If I use FAGLL03, I still have the same issue, the posted items are showed too:

Result on following screen:

Did you mean something else?

Thanks


former_member198650
Active Contributor
0 Kudos

Hi,

You are checking the GL balances in two different systems. If your GL has maintained with OIM, then the below 2 symbols displays for cleared and open items.

If you GL account is non OIM,then it displays the items with tick mark in green color as you attached in the last screenshot. So check once again the report, it displays only open items in FAGLB03.

Regards,

Mukthar

former_member242326
Participant
0 Kudos

Hello Mukthar,

Thanks for your reply.

I checked the OIM, and I think it could be the reason:

The GL account is OIM now, but it was originally non OIM:

The items with the green tick mark are created (document date) at 28.10.2011.

At the moment it was non OIM.

That makes sense.

Is there a way to change the status of the items to cleared, so they are not visible anymore when selecting open items only?

former_member198650
Active Contributor
0 Kudos

Hi,

At the time of changing of NON OIM to OIM through correction program, you have not switched on the indicator in the middle not from first document posting date. Due to this before the changed date the items are showing with tick mark sign and also it is showing along with the open items. Hence it is not possible to change the items as OIM.

Regards,

Mukthar

siwar_taleb
Active Participant
0 Kudos

Hello,

I'm quite sure that the change done for this GL account from NON Open item managed to OIM is the cause of the issue...

If you try using another G/L account without modification, you'll see that if you select to display only open items, no cleared items are displayed.

Regards,

Siwar

former_member242326
Participant
0 Kudos

Hello Siwar,

Thanks for your reply.

I agree, probably that is the reason.

I was hoping there is a solution available, so the posted items are no longer be showed there.

Would be great.