Default Values

Row 10 of the Wizard is reserved for Default Values. Opening the data entry form will populate any default values into blank rows below Row 10.

Any values that exist in the Default Values (Row10) where the column is hidden, will default.

Standard validation will apply if the defaulted value is not valid for the field.

Note – You cannot have a default ‘Quantity’ and therefore this field is coloured grey.

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'