Restriction in PO for materials having stock & no consumption

[Former Member]

Dear Sapiens,

Our requirement is that if the material is having stock in the warehouse & if its consumption has not happened in last 3 months,then if the user want to create new PO,then the new PO should not be saved first showing the error message as " You cannot create new PO as material is having stock & no consumption".

If the new PO required to be created,then it should be done with the relevant authorization only i.e. new release strategy should be applied to this than the existing one.

Please suggest the solution for this as the main intent in this is to have control on procurement & proper use of stock.

Best Regards

Deepak Rade

[Former Member]

Hi Deepak,

, give this requirement to your Technical Consultant in the form of FS (Functional Spec) to develop the logic.

Umakanth R

[madlercm]

As it was said, there's no standard functionality for this, but there's a report for slow moving/dead stock (MC46, MC50), where you can get materials with no consumption. hen you check stock in MB52. So at the end you get your population of materials, and then set them in material master a material status that blocks purchasing.

Of course, you can automate all this, by writing a program with such logic.

[Former Member]

Hi Deepak,

As far as I know, there isnt any standard solution for your requirement, you need to use the User Exit,

again there will a lot of questions to be asked for the logic to be written, like what is the Quantity of the Stocked Item,

if the New procurement is done with Account Assignment should it be allowed to procure or not, and for how much quantity of a certain material this logic should work like if you have a huge setup and you use a particular material in a particular period of time and not after that or before that, in that case you should be having the material in the Stores for that period of time, but some left over from the previous period will not let you order the material.

As far as the New PO cretaion is to be done with different Release strategy, you can create a new Document Type, and give the Authorization to the respective Persons only, and you need to have a class in the release strategy for the Document type.

Hope it helps you.

Regards,

Yawar Khan