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

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)

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

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

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

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