Error Handling and ValidationThere are two levels of validation:
• Spreadsheet Validation - The Invoice Header and Invoice Distributions Forms validate the data using lists of values, date formats, field lengths and some other field level validation.
• Upload Validation - The upload process will perform the spreadsheet validation above as well as the validation within the API.
Data keyed directly into the worksheet (not via the Invoice Header and Invoice Distributions Forms) will be validated when it is uploaded. If you wish to check anything before it is uploaded, simply open the form.
Refer to section:
|