cancel
Showing results for 
Search instead for 
Did you mean: 

Material document not considered in MB5B

Former Member
0 Kudos

Dear All,

While checking MB5B Report I came to know that system is not considereing the 101 Material document which is having Account assignment category 'F' ie against PM order?

While creating the PM order the user checks the components availability if stock not available he keeps Item category as 'N' while saving the order system is generating PR and then Processed to PO and then GR(against that order directly it is getting issued, stock is not coming to stock)

In our customized consumption report we are considering the stock value which is issued against order (101 against order).

But when we check total issues in MB5B sytem instead of showing it as consumption, not even considered that document

Please suggest

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Thanks for ur replies

1. According to client he has purchased some 100 qty and paid 100000 to vendor with the reference of that order but in MB5B total issues it is not considering that document

Atleast Total receipts value (100000) and total issues(100000) it should have got added and should have got nullified. now the entire MB5B report shows wrong value(only Receipts & Issues) closing value is OK

@Jurgen Sir,  @ Dibyendu Sir:

You have replied saying it has not created stock.

1. Our client is asking that if stock not created how come system issued to that order and the actual cost value got updated against that order?

2. It is not an receipt or issue then only in PM order it is showing that material document and value?

Total issues in MB5B is no where getting tallied.

rafael_zaragatzky
Active Contributor
0 Kudos

Hi Pravanesh,

The purchased value went directly to the PM order, bypassing the stock. If you want to see all received values (to stock and not to stock) you can use the report MB51 or PURCHIS (e.g. trs MCE3).

BR

Raf

former_member183424
Active Contributor
0 Kudos

MB5B doesn't include the stock increase or decrease on an Order.

MB5B is purely for MM stock report. It will not take the details from PM order. It reads only MM related tables.

Former Member
0 Kudos

Hi Rafael & Dibyendu thanks for ur replies

Finally the user want to see Opening stock/Value, Total Receipts/Value, Total Issues/Value, Closing stock/Value

In total issues it is not getting tallied(according to client even though movment happened value updated)

Finally We have decided to create ZMB5B copying MB5B in addition we need to add two columns for PM order against Receipts & Issues values to get our consumption report to get tally. We will add the value of 101 against PM order in Receipts and the same value with negative sign in Issues.

So the final Closing value remains same and also we will ask the user to calculate the total issues as (Value in total issues + value of stock issue against order(101 against order))

Thanks for ur replies

former_member183424
Active Contributor
0 Kudos

You said that "stock is not coming to stock", then of-course it will not consider in MB5B. MB5B is for stock analysis report.

System will not take the non-stock movement types in MB5B report..

JL23
Active Contributor
0 Kudos

MB5B is a stock report, and your account assigned PO does not create any stock, hence it is not considered.