1 to 4: I can fix all that easily... Before you upload the request to the Mass upload tool.

Problem with the mass upload tool (reasons why I need to check after the upload, just FYI)

1. We change price/freight very often, when too many “condition” have been uploaded for the same Part Number the upload can go wrong (new price/freight don’t overwrite the old ones)
2. When too many conditions have been uploaded for the same part number funny IFR may be created like NL10 with import duties or wrong vendors.
3. When we have too many vendors for the same part, the upload tool can mess up and change price/freight for the wrong vendor.
WE can take those tasks away from the MUT and give them to Excel and VBA, But first let's get the request fixed as much as possible.

I wish to introduce a new Programming Term to you: "Business Rules."

Examples of Business Rules for Requests:

  1. No blank Spaces.
  2. Only Number Formats "$" and "€"
    1. Exception: When Value = zero or Blank, NumberFormat = "$0.00"

  3. When column B = US20 then Freight must be expressed in Number Formats "$"
  4. when NL10 in Column B import duties column must have a value
    1. exception: when the part number starts with 8FI* there must be NO import duties.

  5. when Column B <> NL10 there must be NO import duties.
  6. Import Duties NumberFormat = "General" (No Number Format)