block duplicate Customer Order Nbr just for the "SO" order type

Hi @yoelb 

Can you use customer order Nbr validation on  order types,

Hi @manikantad18 ,

to use the built in validation it needs to be checked “Require Customer Order Nbr”, and it will not allow to be empty, which will not work for us

@yoelb Try adding a fieldUpdated event for CustomerOrderNbr, do the search and raise an error if another order has the same customer order:
 

public void SOOrder_CustomerOrderNbr_FieldUpdated(...){
 if(e.Row == null) return;
 if(PXSelect<SOOrder, Where<SOOrder.customerOrderNbr, Equal<Required<SOOrder.customerOrderNbr>>,
And<SOOrder.orderType, NotEqual<Required<SOOrder.orderType>>,
And<SOOrder.orderNbr, NotEqual<Required<SOOrder.orderNbr>>>>>>
.Select(Base, e.Row.CustomerOrderNbr, e.Row.OrderType, e.Row.OrderNbr)
.Count() > 0)
{
 throw new PXException("Another order has same customer order...");
}
}

Probably you would need to implement this same validation in RowPersisting event to make it more robust.

@darylbowman  -  Thank you

Hello,

Here is the Screen ID in 23R1 to change the Customer Order Nbr. Validation.

Order Types (SO201000)