Three general options are available for the import of template data. You can overwrite only blank Asset Master fields, overwrite all Asset Master fields, or cancel the template data import altogether.
This radio button is the first option available for the import of template data. It is active by default.
If you select this option, the system will NOT overwrite existing asset data in the row with template data except as determined by your checkbox selection.
Use this option to safeguard autocreated data while, at the same time, supplying additional data that is required in Asset Master records (but not obtainable from Costpoint Purchasing/ Receiving/Accounts Payable).
Much of the data in columns in the main screen, such as Vendor ID, and so on, may already have been captured from Costpoint Purchasing, Receiving, and/or Accounts Payable during the autocreation process. Alternately, you may have already entered a Vendor ID in the row that you do not want to be overwritten with template data. With this overwrite option, therefore, you can retain the existing data in the row (regardless of its source) and supplement only blank columns with the template data.
Each of the checkboxes associated with this radio button selection provides an overwrite option because each of these columns displays a default value in this row and is not considered "blank," as follows:
The Asset Record Status (Active/Inactive) default is "A" (Active).
The Asset Depr Status (Depreciable/Non-Depreciable) default is "D" (Depreciable).
The Asset Condition Code (New/Used) default is "N" (New).
The Asset Auto Calc Flag (Y/N) default for all books is "Y."
When you select this radio button, you must also choose from two alternatives regarding the import of user-defined data from the template. These are "all or nothing" options, in which you can populate ALL Asset Master user-defined data fields with ALL template user-defined data, OR you can you can populate NO Asset Master user-defined fields with template user-defined data.
Although user-defined fields do not display in columns in this screen, if you have selected the "ALL" option, the template user-defined data will automatically be imported to Asset Master records when you run the final autocreation step from the Process Autocreation Transactions screen.
This checkbox is selected by default.
This checkbox is available only if you have selected the Overwrite only BLANK Asset Master fields with template data radio button in this group box.
If you leave this checkbox selected, the system will populate only blank Asset Master columns in this screen with template data, and the system will overwrite the default "Active" ("A") Record Status in the Edit Autocreation Transactions screen with the template data. If, for example, you had selected the Inactive Record Status in the template, selecting this option will copy the "I" status from the template and otherwise populate only blank Asset Master columns in this screen with template data.
If you uncheck this checkbox, the system will populate only BLANK Asset Master columns in this screen with template data, and the system will ignore the value you have specified for the Record Status in the template. The system will automatically populate the Record Status column in the Edit Autocreation Transactions screen with "A," which is the "Active" default value.
This checkbox is selected by default.
This checkbox is available only if you have selected the Overwrite only BLANK Asset Master fields with template data radio button in this group box.
If you leave this checkbox selected, the system will populate only blank Asset Master columns in this screen with template data, and the system will overwrite the default "Depreciable" ("D") Depr Status in the Edit Autocreation Transactions screen with the template data. If, for example, you had entered a Depr Status of Non-Depreciable in the template, selecting this option will copy the "N" status from the template and otherwise populate only blank Asset Master columns in this screen with template data.
If you uncheck this checkbox, the system will populate only blank Asset Master columns in this screen with template data, and the system will ignore the value you have specified for the Depr Status in the template. The system will automatically populate the Depr Status column in the Edit Autocreation Transactions screen with "D," which is the "Depreciable" default value.
This checkbox is selected by default.
This checkbox is available only if you have selected the Overwrite only BLANK Asset Master fields with template data radio button in this group box.
If you leave this checkbox selected, the system will populate only blank Asset Master columns in this screen with template data, and the system will overwrite the default "New" ("N") Condition Code in the Edit Autocreation Transactions screen with the template data. If, for example, you had entered a Condition Code of Used in the template, selecting this option will copy the "U" status from the template and otherwise only populate blank Asset Master columns in this screen with template data.
If you uncheck this checkbox, the system will populate only blank Asset Master columns in this screen with template data, and the system will ignore the value you have specified for the Condition Code in the template. The system will automatically populate the Cond Cd column in the Edit Autocreation Transactions screen with "N," which is the "New" default value.
This checkbox is selected by default.
This checkbox is available only if you have selected the Overwrite only BLANK Asset Master fields with template data radio button in this group box.
If you leave this checkbox checked, the system will populate only blank Asset Master columns in this screen with template data, and the system will overwrite the default "Yes" ("Y") Auto Calc Flag columns in this screen with the template data. If, for example, if the Auto Calculate Depreciation checkbox is selected in the template for Book 1 only, selecting this option will copy the "N" flag for Book 1 and the "Y" flags for Books 2-10 from the template and otherwise populate only blank Asset Master columns in this screen with template data.
If you uncheck this checkbox, the system will populate only blank Asset Master columns in this screen with template data, and the system will ignore the values you have specified for the Auto Calc flags in the template for all books. The system will automatically populate the Auto Calc Flag columns in this screen with "Y," which is the "Yes" default value.
This radio button is the second option available for the import of template data.
This radio button is unselected by default.
Select this radio button to populate all Asset master fields with template data, including all template UDF data. When you select this option, blank template fields will overwrite existing Asset Master data columns with blanks.
This radio button is unselected by default. Select this radio button to cancel the Template Data Import and close this dialog box.