Message if a Shipment go to abroad Respondida

Jennifer Paya

Hello,
I need to know how I can create a validation when I open a sales order to receive a message if a shipment is sent abroad. The reference field must contain a text or numbering and if "DE" (Germany) is not shown in the shipping address.
Because SQL Query is not sensitive, a message is also displayed if an address includes "DE".
Example: If the shipment is for Spain (in this case, foreign country), but the street is called "Calle Conde", I do not receive a message, even if it is a shipment abroad.

My configuration is the following: 

IF($[$14.0.0]) like '%___%' AND ($[$92.6.0]) NOT LIKE 'DE'

BEGIN

SELECT 'Pop Up' FOR BROWSE END

https://drive.google.com/open?id=1fFB2vYURpTyADrimneE1SL1mLPBX_ShA 



Comentarios

1 comentario

  • Comment author
    Thomas
    • Comentario oficial

    Answered in a ticket

Iniciar sesión para dejar un comentario.