cancel
Showing results for 
Search instead for 
Did you mean: 

MRN9 report adding GL account

former_member203642
Participant
0 Kudos


Hi All,

Can I know hot to add a GL account in MRN9 report and how to cross check the same.

Thanks

Regards,

John

Accepted Solutions (1)

Accepted Solutions (1)

former_member183424
Active Contributor
0 Kudos

Why do you need to add G/L account in this report..

Its a Balance Sheet Value by Account...

When you enter the material, you can see the balance sheet value by account for the material...

I hope you can't add G/L account as selection field for any standard configuration..

You can do for a development...

Consult your abaper to copy the program RMNIWE90 and make a new program like as ZRMNIWE90.

And then make changes on this program...

And assign into a t-code ZMRN9.

former_member203642
Participant
0 Kudos

Dev,

My user want to see report for one particular GL, whether we can the MRN9 report for particular GL?  we are first time analyzing this report, if possible can you help us how to get report for particularly one GL account and from where this report pulling data (it may be pulling the data based on the GL account)

Thanks.,

former_member183424
Active Contributor
0 Kudos

This report is not designed like that...

You have to go for a development to set the report as per your requirement...

Also check MB5L report and FS10N report..

I hope MB5L report will suitable for you...

You can select G/L account and valuation area as plant (if you use valuation area as plant) as a selection field...

former_member203642
Participant
0 Kudos

Thank You Dev, let me check this with my technical team.

Sorry I am not able to give you the score, the score option not appearing for me.  I don't why.

Once again tanks for your help,

Regards,

John


former_member203642
Participant
0 Kudos

Dev,

I have run the report I can able to see the GL account and values for examble: I can see the GL A/c. 5000 Valules, now I want to see the values or add in this report 5001 also.  How we have add in this report?

Please help me.,

Regards,

John

former_member183424
Active Contributor
0 Kudos

Try with multiple selection for G/L account in MB5L report..

Then enter two G/L accounts

Then Press execute...

You can see the two G/L accounts balance value...

former_member183424
Active Contributor
0 Kudos

If you are using FS10N

Then select multiple G/L, then press execute..

Double click The line item in executed report... You can see details as per G/L accounts..

former_member203642
Participant
0 Kudos


Thanks, MBL5 report is OK we got it,  But we are looking for MRN9 report.

Kindly refer the below screen shot which I have taken from MRN9 report, now we want to see the report for GL 135000 (GL 130010,131000,134000&136000 - already added to this report like this way we want to see the MRN9 report for GL 135000 also)

Regards,

John

former_member203642
Participant
0 Kudos

Dev,

I will give more clarification if you required.,I have to complete this today

former_member183424
Active Contributor
0 Kudos

What is problem you have faced to see the balance for G/L account 13500 in MB5L ??

As you can see the others G/L account balance...

former_member203642
Participant
0 Kudos

Yes you're right, but my users are not accepting, they want to see the balance in MRN9 also.,

former_member183424
Active Contributor
0 Kudos

But as I have told, There are no selection option for MRN9 report...

You have to develop it your self...

Concern your user to see the report from MB5L

Or give you enough time to make a Z report as per their requirement...

former_member203642
Participant
0 Kudos

Dev,

we cannot add the GL account in MRN9 report?

if not possible to add the GLs in MRN9, how the existing GL accounts added in the report?

we have to do some configuration?

former_member203642
Participant
0 Kudos

And we are not looking for GL a/c in input selection parameter, we are looking for report has to add the one more GL account.

former_member183424
Active Contributor
0 Kudos

Which Selection you are using ?

Are you using any particular material ???

former_member203642
Participant
0 Kudos

with material & Plant and without material & Plant selection also we have tried, that GL is not appearing in the report.  But values are there in FS10N.

former_member183424
Active Contributor
0 Kudos

Check table T030

Give the Chart of Acc, Transaction as BSX, Valuation Class.

Find the valuation class.....

Then give the valuation class in report MRN9. Then execute....

Check the G/L account comes or not..

former_member203642
Participant
0 Kudos

No, it is not appearing.,

former_member183424
Active Contributor
0 Kudos

Not this way.....

I said find the Valuation class which is assign to this G/L...

Go to SE16, enter the table T030, then give this details, then execute (You can also check OBYC)

You will find the valuation class, then pick the valuation class and give the valuation class in MRN9..

former_member203642
Participant
0 Kudos

I have done but same values Dev.,
The GL is not appearing.,

former_member183424
Active Contributor
0 Kudos

But you have the value in MB5L report ?

Strange...

former_member203642
Participant
0 Kudos

yes., MB5L report values are there, but MRN9 is the problem

former_member203642
Participant
0 Kudos


Any Idea Dev, still I am analyzing.,

former_member183424
Active Contributor
0 Kudos

Can you post the screen shot for MB5L or FS10N report for G/L account 135000..

I have checked all the three report, I can't find any difference..

former_member203642
Participant
0 Kudos

MB5L screen attached herewith, FS10N also values are there.,

former_member183424
Active Contributor
0 Kudos

I hope there would be a different value which is not belong to Valuation class or material..

In this screen (MB5L), Double click on the G/L account, check what it shows...

Is there any material ?

(Note: I have checked that, all times value comes same in my both report in my system ...)

former_member203642
Participant
0 Kudos

Dev,

We have checked the same, which  I am looking for adding the GL in this report  is the Stock In Transit GL account. that maid be not able to add or not displaying in the report.

But we are working on for picking the particular GL in this report.

Answers (1)

Answers (1)

former_member203642
Participant
0 Kudos

Hi All,

We have to add GL account to MRN9 report, please help where we have to add the GL account for appearing in the MRN9 report and how to cross check the same.