Distribution, Manufacturing, and Internet Modules

[jasonitspyder]

Hi,

I'm wondering how can I prevent my sales people entering a *negative* order quantity in a Sales Order entry?

The reason why I'm asking this is because I believe this negative quantity (negative SO amount) will circumvent the credit limit checking. It also makes the available quantity not accurate.

Running MAS 200 4.4 PU4.

Please help. Thanks.

[Natasha · Accepted solution]

You can write a simple user-defined script to validate quantity ordered.

In SO_SalesOrderDetail - Pre Validate QuantityOrdered:

retVal = 0

qty = 0

retVal = oBusObj.GetValue("QuantityOrdered", qty)

if qty < 0 then 

     retVal = oScript.SetError("Quantity must be greater than 0")

end if

[jasonitspyder]

Thanks a lot Natasha! Works perfectly.

[zip]

You could also just set the Validation on the Quantity Ordered field with a Range of 0 thru 9999999999999999 - via Custom Office > UDF Maint > S/O Sales Order Detail > Advanced Field Settings