Material Request Status not Received When Updating Stock From Purchase Invoice

If I skip creating a purchase receipt and instead go straight to creating a purchase invoice and tick the box to update stock, it says the items are 100% received on the purchase order, but the material request status remains “ordered”.

Is this a bug?

In our company the creation of a purchase receipt is a somewhat redundant exercise. It seems to me that if the purchase order shows the stock 100% received than the material request status should show the same, regardless of whether the stock was received via a purchase receipt, or by ticking update stock on the purchase invoice.

Am I missing something?

This is not a bug. The Material Request is linked with Purchase Order. Once the Purchase Order is placed, the status of the MR will changed to ordered. Subsequent creation of PR and PI will have an effect on the PO and not the MR.

Hope this helps.

Well that would all be good, except that a PR does have an effect on an MR. When a PR is submitted if it is linked to PO that is linked to an MR, the status of the MR becomes “Received”.

I’ve changed the Buying Settings to prevent the creation of a PI without at PR. This is OK, and IDK maybe it’s actually a good thing.

I still think if you’re going to allow stock updates from a PI and update the quantity received percentage from a PI, it is illogical not to update the status of the MR, afterall the PO has been updated.

I can see some logic in the way it’s currently done. The problem is that it doesn’t make sense to simultaneously allow update stock from PI, and in some areas treat this act as an receival (received percentages are updated), but in another area not treat this data the same way. Its the same data, ie. stock has been received against a PO, treating this data differently depending on the source of the update is logically inconsistent.

The most logical solution would be to prevent stock update from PI and force all users to generate a PR. Since this would be laborious an exception has been made, users are allowed to update stock directly from the PI. Why make this exception for the sake of convenience, but stop short of updating the MR status, which is updated when an PR is submitted. Do you see what I’m saying, it’s not that I think a PI should be able to update the MR status, it’s that if you decided to allow any kind of stock update from a PI, you have to follow that logic throughout all the other dependent doctypes.

But like I said, I updated the Buying Settings and I’m happy with that solution.