to identify shipments to EU countries is there a n...
# suiteanalytics
n
to identify shipments to EU countries is there a neater way that this formula of all EU country codes?
CASE WHEN {shippingaddress.countrycode} IN ('AT','BE','BG','CY','CZ','DE','DK','EE','EL','ES','FR','HR','HU','IE','IT','LT','LU','LV','MT','NL','PL') THEN 1   ELSE 0  END
d
Item fulfilment fields... Shipping Country and select with the native Netsuite list might possibly be faster, but still needs manual selection of applicable countries.
n
Thanks @Dominic B. I was hoping there was going to be Netsuite native field somewhere which would stay updated.
d
There ought to be an "is EU" field somewhere given the tax and border implications, but I'm not aware of one. Unfortunately, Netsuite's understanding of these type of issues outside the US seems a bit lacking.
n
@Netsuite Tragic Why not utilize a combination of subsidiary (if the EU transactions are different in terms of subsidiary and NetSuite is One World) and / or Currency (EUR if you have only one currency...if you have multiple you can select other currencies as well but I am guessing it would be a shorter list compared to EU and also would not need much maintenance in future in case there is another brexit !)
n
@neerajrtiwari i just looked at that but I don't see a reliable relationship for this client.'most' of the goods going to EU are priced in EUR and then there are ones with USD.