How to use Minimum order quantity field in item master data to block purchse order

[former_member250611]

Hello Experts,

I am new to this forum

My question is that how do I block Purchase order if exceeds minimum order quantity (standard Pack size) and calculate the pack configuration based on the same

For example 1

For Item A , I have defined minimum order quantity as 25 kg

When I go to purchase order and enter the quantity that is below the MInimum  order quantity lets say 24 kg, it should block to add.

Example 2

For Item A , I have defined minimum order quantity as 25 kg

My requirement is 40 kg, then in Purchase order  I should be allowed to enter quantity as 50 kg and not 40 kg because because my Standard pack size 25 kg, and pack should get calculated in next column or any udf field as 25*2 as rounding figure.

Please resolve this query

Regards

Altaf Borkar

[former_member250611]

Hello All,

Does anyone have solution to this???

Regards

Altaf

[Former Member]

Hi Altaf,

Welcome to the forum.

You can use maximum field in Item master rather than Minimum field.

Thanks,

Harshal

[former_member250611]

Hi Harshal,

Thanks for your quick reply.

My purchase request is generating through MRP run

SO I'm using Minimum order quantity field from planning data tab and not Inventory data tab.

Please Suggest.

Regards

Altaf

[former_member250611]

Hi Harshal,

Below SP_TN notification I have used

IF @transaction_type IN ('A', 'U') AND @Object_type = '22'

IF EXISTS

(SELECT T0.ItemCode  FROM POR1 T0 INNER JOIN OITM T1 ON T0.ItemCode =T1.ItemCode

  WHERE (Quantity<MinOrdrQty) AND

t0.DocEntry = @list_of_cols_val_tab_del)

SELECT @ERROR= 2,

@error_message = N'Please enter quantity that matches or greater than Minimum order quantity'

But I only blocks the quantity below Minimum order quantity

How do I do this with My second example as mentioned earlier.

Regards

Altaf