Report needed to match Goods Issues with Goods Receipts

[Former Member]

In my current system I have a single inventory account.  We post GRs and after IR these are turned into exactly matching GIs.  Ultametly the account is then equal to all the GRs that have not yet had a GI. 

We are required to reconcile the account with all the purchase orders of these Goods Receipts that do not have GIs.

Is there a way I can determine all of the GRs which have not been issued?  With this list I should be able to reconcile. 

[JL23 · Accepted solution]

Do you do anything physically and in SAP to identify a single receipt?

I mean how does your stock look in MMBE, is it just one line with total stock, or do you have individual lines for each receipt?

If you do not have individual lines for each receipt (batch management needed) then how do you know that the physical goods issue is done from receipt 123 from May 2nd?

Have a look into

[BijayKumarBarik]

Hi,

You can refer report with t.code S_P00_07000139 with movement types associated of yours goods receipt and goods issue.

Regards,

Biju K

[jagdeepsingh83]

Hi Robert,

As explained by Jurgen, if you have batch management for each goods receipt then you easily find the goods issue document.. Also if you Goods issue document have reference of 101 document while posting goods issue in any text fields again you can match ..

Another approximate method will be .. goods receipt date < goods issue date, match quantity, and value .. but this maximum you can get close  to matching GRs to GIs,.. I do not see any other option as goods issue is independent process and it is never linked to PO or goods receipt.