Guidelines and Limitations for Splitting Assets in Bulk using CSV Import

When creating a CSV file for bulk asset split, review the following guidelines and limitations:

• The CSV file must include values for the new assets generated by the split.

• The Asset and Quantity columns are required. If left blank, the CSV file won't be processed.

• The Original Cost, Current Cost, Current Book Value, Residual Value, and Last Depreciation Amount columns are optional. If left blank, values for these columns are automatically calculated based on the quantity ratio.

• If you enter values for the optional columns, make sure that the Original Cost, Current Cost, and Current Book Value must all have values. Otherwise, the CSV file won't be processed.

• The value in the Asset column must match the Asset internal ID.

• The total values entered can't exceed the original asset's values. The original asset must also have at least one quantity remaining after the split.

• The CSV file size can't exceed 10 MB and is subject to the File Cabinet's storage availability.

• Numbers and currency amounts in the CSV file should follow the formats defined in the General Preferences page.

• If the CSV file has validation errors, it won't be processed even if some rows are valid.

General Notices