How To: Stop Sales Orders to Countries with Export Restrictions

The Foreign and Commonwealth Office publishes a list of sanctions and export controls by country.

To prevent Sales Orders being placed for customers in countries with export restrictions:

1. Open a System Data screen (show me how).
2. Open the [ System Data | Countries ] screen.
3. Press Alt+E or click to enter edit mode..
4. Select a country that export restrictions apply to (e.g. "Sudan").
5. Set the 'Max SO value' for each affected to "0.01".
6. Press Ctrl+S or click to save changes to the countries table.

The effect of this would be that an error dialog "Exception - The order value exceeds the maximum order value for the customer country" is displayed (and the save aborted) should an operator attempt to save a Sales Order with a value exceeding 0.01 for a customer based in that country.

Data Query

The following data query shows those countries for which maximum Sales Order values have been set:

SELECT country, country2_code, max_so_value FROM country
 WHERE max_so_value <> '0.00'
ORDER BY country
/************************************************************
 Sales Orders - Countries with sales order restrictions

 This data query is provided as a teaching aid and is not
 covered by your support agreement

 13-May-2009 Created (GKS)
************************************************************/

Data Query is an Advanced User feature.

See Also

• Sales Orders
• System Data screen