Row 10 of the Wizard is reserved for Default Values. Any data rows below Row10 will be populated with default values if they are blank - this occurs when validation is initiated on the worksheet and also when the data entry form is opened.
Any values that exist in the Default Values (Row10) where the column is hidden, will default to your data entry rows.
Standard validation will apply if the defaulted value is not valid for the field.
Example:
Enter Default Values for any of the following columns - Customer Number, Currency, Amount, Type, Terms, Revenue Hard Limit, Invoice Hard Limit, and Administrator. Leave the columns blank for the rows with a Default Value in the Default Values row and upload. Blank values are populated with default values.
Default data can be derived from either:
Any manually entered value
A formula i.e. =TODAY()
A Profile Option i.e PROFILE: <Profile Name>
Note: A PROFILE query must be prefixed with PROFILE: otherwise an error will be returned.
<Profile Name> is the profile name and not the 'User Profile Name' value. For example the profile: GL Ledger ID has a profile name of 'GL_SET_OF_BKS_ID'
