How To: Stop Sales Orders to Countries with Export Restrictions

Page approved.



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)
************************************************************/


WARNING icon
Data Query is an Advanced User feature.

See Also

Visit KhaosWikiX at https://support.khaoscontrol.com/wiki_kcx/ to see the following:

Contact the Khaos Team