Message if a Shipment go to abroad

Answered

Jennifer Paya

• November 23, 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

• Official comment

  

  Thomas

  • November 27, 2018 07:49

  Answered in a ticket

Please sign in to leave a comment.