- The quantity and unit price fields must have a numeric value in them. They must contain a number greater than or equal to zero. These fields can not contain values like N/A, NA, -, none, etc.
- Each part number must have a value in the quantity field using the rules above.
- For part numbers that have multiple supplier names/supplier part numbers, the first row (entry) for the part must contain all the fields with the first supplier name/supplier part number filled in. Subsequent rows should only contain the supplier name and supplier part number for the remaining suppliers. See example below of the proper format for an input file.
- Information can be contained at the top of the input file. This information will be skipped over when you designate which line to start reading from on your input screen. From the first row with part number information to the end of the file must contain either part number information or blank lines. If any other information is in there, the application will try to load them as part numbers and errors will occur.
- A part should only be defined once in an assembly. If the part is contained in the BOM multiple times, all the information about the part will be loaded into the system the first time the part is read. After that, if the part is encountered again, only the unit price will be updated for each subsequent time the part if found in the BOM. Therefore, the last unit price is the price that is actually stored for the part. the quantity loaded will be from the first time the part is read.
The application does not sum up the quantities for the part: