Inventory 1.5.1 Release Notes

Summary

This hotfix of SSDT Inventory corrects the following issues

• Improved the Acquisition and Item exporter to use the same header rows as the importer so the data can be updated.  The ID was added and is required so the update process can work properly.  Only those fields included in the CSV file will be updated.  Previously blank fields were used to update fields effectively removing values. 

  • The following date formats are valid to use in the importer: 

    • MM-dd-yyyy

    • MMddyyyy

    • MM/dd/yyyy

    • MM-dd-yy

    • MM/dd/yy

    • MMddyy

• Corrected problems with how the 103 and 104 reports handled transfers.  The 103 report was creating a separate line for transfer and beginning balance values.  The 104 report was using the LTD depreciation amount instead of the current depreciation amount.  Both reports have been corrected.

• The inventory item view was updated to properly display the asset class.

• The ability to reopen prior fiscal years has been disabled, due to an issue that was inflating life-to-date depreciation amounts.

• For any capitalized items created prior to 1.5, their related acquisition records should be checked to ensure the update_original_cost flag is checked (set to true).  Acquisitions with incorrect update_original_cost flags can be reset by doing the following:

  • In the Acquisition grid, filter for the Acquisitions entered in redesign.

  • Click the "Export Grid Items" button

  • Select the Excel file type

  • Click Export. 

  • Open the export file in Excel and update the "Update Original Cost" values to Y. 

  • Save as a CSV file. 

  • In Inventory, go to System → Import. 

  • Upload the CSV file you just saved

  • Select Acquisitions in the drop-down. 

  • Click the Import button. The acquisitions will then be updated with the correct update original cost values.

• If Fiscal Years have been reopened and closed, you will need to reset the Life-To-Date depreciation.  To do this:

  • Filter for new items added

  • Click the "Export Grid Items" button

  • Select the Excel file type

  • Click Export

  • Open the downloaded file in Excel

  • Remove the life_to_date_depreciation column

  • Rename the original_ltd_depreciation column to life_to_date_depreciation

  • Save the file as CSV

  • In Inventory, go to System → Import

  • Upload the CSV file you modified in Excel

  • Items should be selected in the dropdown

  • Uncheck the Create Transfers box

  • Click the Import Button.  The items will now be updated with the correct Life-To-Date depreciation values.

All updates for this release