Limit selection of warehouse in a sales order

[Former Member]

hi,is it possible to write a transaction notification that can prevent a user from selecting more than one warehouse in a single sales order?

In this case, the warehouse should be the same for all items selected but the user should have the option of selecting any warehouse.

[former_member187610]

Hi,

Step 1: Maintain Delivering plant in Customer Master record

Step 2: Maintain in the Material master record.

Step 3:In SO document type "check" the read customer info record. To get automatic plant in SO.

Regards,

Sharan

[Lakshmipathi]

Sharan G S

While I appreciate your keen interest in helping the OP, at the same time, before giving suggestion, please read the requirement carefully once again.  The requirement is about warehouse and your suggestion is about plant

G. Lakshmipathi

[Former Member]

hi,

thanks a lot guys for the help. i managed to get a solution below

IF @transaction_type IN ('A','U') AND @object_type = '17'

BEGIN

IF (

SELECT     COUNT(distinct ItemCode)

FROM         RDR1 where RDR1.DocEntry = @list_of_cols_val_tab_del ) > 1.00

BEGIN

SELECT @Error = 92, @error_message = 'Use one Warehouse'

END

END

[moazzam_ali]

Hi

Where is this field in sale order? Could you please share the table and field name and share screen of this field?

Thank$