The ‘Customize Fields’ button on the Item Cost Wizard – Setup ribbon, opens the ‘Set Item Cost Fields’ form.
The following form will open and this enables the user to determine how the worksheet will appear when the ‘Create Sheet’ button on the form is used.
The following customizations are provided by the form:
•Wizard Mode– There are six options available for ‘Item Cost Wizard’.
•Select– The user can select to remove the column. This does not physically remove the column from the worksheet, but does remove the fields from the form and tells the Wizard to ignore the column for this implementation.
•Custom Label– The Wizard has standard column names which are consistent with the Oracle forms. This provides you with the ability to customize these column names to suit your business needs.
•Mandatory– Allows you to specify which columns must be entered for your worksheet. If any of the selected Mandatory fields (i.e. made mandatory by More4apps or by the user) are not populated or are not present in the worksheet, then the upload will fail.
•Comment– Comments are inserted in each column heading cell to assist users when completing the worksheet. This can be customized to provide the appropriate comments for your business needs.
Click OK button to close the form.
Click Create Sheet button to create a new worksheet based on your selection.
Click Cancel button to exit the form without changing the settings.
To later create another worksheet based on the selection, simply open this form and click on the ‘Create Sheet’ button again.
Default Values
Item Cost Wizard provides you with the ability to enter default values in Row 10.
