Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Mar 31, 2016 at 07:36 AM

    Hi Altaf,

    Welcome to the forum.

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

    Thanks,

    Harshal

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Apr 01, 2016 at 04:05 AM

    Hello All,

    Does anyone have solution to this???

    Regards

    Altaf

    Add comment
    10|10000 characters needed characters exceeded