GR / IR Balances report

[Former Member]

Dear Friends ,

We have the Txn MB5S in place to undersatnd the GR/IR Balances according to the PO and Material

In our scenario we need the Balances according to the Material Document number.

Is there any standard report available to know the above.

If it is not available is there any way to get the material document number in the report MB5S itself

Venkatesan

[former_member187989]

In MB5S report,Select purchase order no.,Click bar graph icon,u can see balances material document no. wise.

[Former Member]

Hi

Try this report "S_ALR_87012991" - Accounting Documents for Material.

Regards

Antony

[Former Member]

Hi

Use ME80FN ( Layout purchase order history) to get desired results

[Former Member]

Dear,

Thanks for the earlier response

I have run the report and got only the Purchase order details.

Our requirement is

We have a purchase order where the multiple receipts has been done.

Invoicing has been done for Some of the receipts.

Now we need the Balance to Inovoice according to the Material document.

Trust you could understand the requirement

Thanks

Venkatesan

[Former Member]

HI

In ME80FN choose layout for Purchase History from application tool bar ( Change View button from the tool symbols )

This will give you material document as well as MIRO document nos also.

[Former Member]

Dear,

Thanks for the input

I have tried this and the report shows all the data.

Please Let me brief the requirement more clear.

I have the PO with one material number "X"

Multiple GR's has been booked against the material number for an Example 100 GR's has been booked.

about 75 invoices has been received and accounted thro MIRO with reference to material document.

Now we want the Balances according to the material document (25 GR's which has booked and not invoiced).

[former_member187989]

Dear,

In MB5S,Enter purchase order no. & material,execute report,In report,click,place cursor over p.o no.click purchase order history(ctrlshiftf9),u can see balances material doc no. wise.

Hope it clarifies.

[Former Member]

Dear,

Please read the last line of my latest reply as 25 GR's which has booked and not accounted.

Venkatesan

[Former Member]

HI

Try using SAP query for tables RSEG and MSEG