======18.3. Validation====== 
Before the import the system validates the import file. The validation is split into two phases. 

=====18.3.1. Format validation=====
In the first phase the system checks the file for format errors.

Possible issues:
  * Row type is not valid
  * Row sub-type is not valid
  * Mandatory field is not given
  * Given value doesn’t match to the type of the field (for example alphabetical character in numeric field etc.)
  * Surplus value is given
  * Invalid row order (for example a header row follows another header row)

=====18.3.2. Content validation=====
In the second phase the document/element is validated with the company database in order to detect content errors.  

====Manufacturing Operations====
Possible issues:
  * Invalid value when range is defined (Operation Break)
  * Code cannot be found in SAP Business One (Item Group Code, Feature, Work Center)
  * Invalid UoM (Operation Times, Allocation Window)
  * Mandatory value is missing:
    * Mandatory Work Center is required, but Preferred Work Center is missing

====Bills of Materials====
Possible issues:
  * Invalid value when range is defined (Issue Method, Milestone Type, Operation Break Type)
  * Code cannot be found in SAP Business One (Item, Feature, Work Center, Supplier, Warehouse etc.)
  * Invalid UoM (Operation Times, Allocation Window, Outsourcing)
  * Rules of using Issue Method and Milestone Type are violated
  * Required correspondences between rows are violated (unfinished product must precede unfinished material etc.)
  * Work Center does not support the Work Center Feature
  * Mandatory value is missing:
    * Mandatory Work Center is required, but Preferred Work Center is missing
    * Operation is marked as outsourced, but no valid supplier is given
  * Operation is not marked as outsourced, but a supplier row is given
  * Sum of planned quantities exceeds quantity in header
  * SAP Business One validates the following: Distribution Rule, Distribution Rule Dimensions, Price List

====Production Order====
Possible issues:
  * Invalid value when range is defined (Issue Method, Milestone Type, Operation Break Type)
  * Code cannot be found in SAP Business One (Item, Feature, Work Center, Supplier, Warehouse, Sales order, etc.)
  * Invalid UoM (Operation Times, Allocation Window, Outsourcing)
  * Rules of using Issue Method and Milestone Type are violated
  * Required correspondences between rows are violated (unfinished product must precede unfinished material etc.)
  * Work Center does not support the Work Center Feature
  * Mandatory value is missing:
    * Mandatory Work Center is required, but Preferred Work Center is missing
    * Operation is marked as outsourced, but no valid supplier is given
  * Operation is not marked as outsourced, but a supplier row is given
  * Sum of planned quantities exceeds quantity in header
  * SAP Business One validates the following: Distribution Rule, Distribution Rule Dimensions, Price List, WIP Code, Project