Message if a Shipment go to abroad

Respondida

Jennifer Paya

• 23 de noviembre de 2018 08:06

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 

Vote

0

• Comentario oficial

  

  Thomas

  • 27 de noviembre de 2018 07:49

  Answered in a ticket

Iniciar sesión para dejar un comentario.