Issue Regarding MB5B report

[former_member391140]

Hi......

When i am running standard report MB5B to calculatte opening stock and closing stock on the output screen i am getting one table with no data selected and the below screen shot of that MB5B report is attached in this discussion please go through and revert back.

As i am fresher there is a requirement to develop RFC to calculatte opening stock and closing stock please help me for which tables i have to refer.

The input should be only plant and from and to date.......Please help me....

Thank U...

Pavan Kumar K

[former_member391140]

[Former Member]

Hi,

In MB5B report, on selection screen select the CATEGORY and tick all the relevant check boxes,

then under settings select

"Totals Only-Non-Hierarchical presentation layout"

Then execute the report.

you are getting blank screen in your screen shot because, there is no mvt in the materical code, neither issue qty nor receipt qty thats why you are not getting data.

Only opening n closing stock is available.

Just do as suggested, hope your issue will resolved.

-Regards

Rohit

[former_member391140]

Dear Sir,

We are using ECC 4.7 "Totals Only-Non-Hierarchical presentation layout" is not there..please suggest me with any other answer please....

thank u

[Former Member]

Please send the screen shot of MB5B Report Selection Screen.

-Regards

Rohit

[former_member391140]

Dear Sir,

I have attached the screen shot. Thanks for ur quick response.

Thank U.

[former_member391140]

[Former Member]

screen shot after expanding scope of list.

[former_member391140]

[Former Member]

Hi Pavan,

I think in 4.7 it is not possible, it is available from 6.0

-Regards

Rohit

[Former Member]

Hii,

on front screen please click on "Totals Only-Non-Hierarchical presentation layout"

Regards,

Nisha S.