SCS - Post-Import Rental Asset Revaluation

This tool can be used to reset the value of Rental Inventory by exporting existing information for bulk rentals, non-bulk equipment or all, to a spreadsheet and then re-importing the updated values from the file.
No G/L postings are generated.

Note: Asset tags must have a quantity greater than 0 to be included.

The import data will update the following values on the relevant Fixed Asset Tag Details:

• Quantity (but not 0 or less than 0)
• Owning Division
• List Price
• Date Acquired
• Original Cost
• Additions
• Total Accumulated Depreciation
• Number Of Months Depreciation
• Depreciation Class
• Product Class
• Group

Export Current Values Action

Asset Tags which have less than 1 on hand, or have any transfers, or disposals, will not be exported and will not be updated on import.

When the export spreadsheet is generated, the products are listed in product number sequence, with the Asset Tag for bulk products, and the current values for owning division, list price, date acquired, total original cost, additions total, accumulated depreciation, number of months depreciated and depreciation class, from the Fixed Asset Tag Details.

Dates:
The Date Format defined must be used on the spreadsheets for date values.
An Addition Date can be entered to be used for all additions to the tag.
A Date Acquired is required for all assets, and the Depreciation History is calculated and depreciation is written from that date forward as of the end of each month, along with the YTD number and YTD dollar depreciation totals.

Any conditions that prevent a product from being included in the spreadsheet are reported on an exceptions log using Information Log.

After the required changes to the product value information are made on the spreadsheet, the spreadsheet must be saved as a Tab-Delimited ASCII file in preparation for re-importing it.

Import New Values Action

Enter the corresponding import Tab-Delimited ASCII file on the Client machine as outlined in Select a File to Upload.
The directory path is not required if the file has been saved in the data directory on the server.

The import creates a new spreadsheet logging all changes made, and creates a separate exception log that can be viewed or printed using Information Log.
If there are any errors a rollback is forced, otherwise confirmation to import is required before changes are made.