18.3. Validation

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