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 the green triangle icon is the buttonbar's EDIT button 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 the disk icon is the button bar's SAVE button 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

Did you find this article helpful?