An /wiki/spaces/rtd/pages/2753046 is available in an effort to consolidate the various pieces of our documentation relevant to setting up a school on Inventory, albeit migrating their Classic EIS data or starting new in Redesign.
SSDT strongly recommends ITC run test imports on their district's Classic EIS data into a test instance prior to importing their live data to ensure the import completed correctly. Please review the pre-data extract steps for any necessary clean-up that needs to be addressed in Classic prior to their live extraction. When running a test import, please review the import log and refer to the Common Import Errors and Warnings for more information as well as review the Data Cleanup and Balancing sections below to ensure amounts and reports balance.
Data Cleanup
- Review the Import Log for errors. This log can be found in the application under System > Monitor > on the Admin Log tab. A summary of each section imported will display the number of records imported and any errors encountered. Those errors will be detailed below the summary. In addition to the summary it is imperative that you scroll up and review the entire log for Exceptions. If you encounter an exception you need assistance with, please submit a service desk ticket to SSDT. For more information on possible exceptions, see the Common Import Errors and Warnings page.
Application Setup
There are a few processes that must be set up and/or verified:
- Go to Core>Configuration
- Compare the Configuration information to Classic (EISMNT>DATSCN) settings. District Name, IRN, Last Fiscal Year Closed, etc. should match back to Classic.
- Go to Core>Fiscal Years
- Compare the Fiscal Year grid to the 'Fiscal Year Closed' and Capitalization Criteria settings in Classic (EISMNT>DATSCN). Redesign should contain one row in the grid reflecting the current EIS processing year and correct capitalization criteria from Classic.
- For example, if the 'Last Fiscal Year Closed' reflects 2020, then the Fiscal Years grid should reflect FY2021 as being the open and current year.
- Compare the Fiscal Year grid to the 'Fiscal Year Closed' and Capitalization Criteria settings in Classic (EISMNT>DATSCN). Redesign should contain one row in the grid reflecting the current EIS processing year and correct capitalization criteria from Classic.
- Create Pending Item Data. Please refer to the 'Pull from USAS' option under Pending Items for steps on how to pull USAS-R PO items marked for inventory into the Inventory application.
- Go to System>Users to create user accounts for Inventory
- In USAS-R, ensure the EIS Classic Integration Module is installed as well as the EIS Classic Integration Configuration pending threshold criteria is set up. Both of these should have been completed as part of their USAS migration (USAS-R Post Import steps). Once in place, when a PO item meets the pending threshold (during AP Invoice processing), it will be marked for inventory and may pulled into the pending file using the 'Pull from USAS' option under Transactions>Pending Items.
Balancing
At minimum, the following reports in both Classic and Redesign should be run to check data and ensure all amounts and transactions balance.
Classic | Redesign | Notes |
---|---|---|
EIS101 | Fixed Asset by Source | Run both reports using the default settings. Compare the totals for each fund type to ensure they balance Please refer to pre-data extract steps for further details on possible Classic corrections, |
EIS102 | Fixed Asset by Function/Class | Run Classic report by option "F" (function and class) for the current FY period. Run Redesign reports by function and Class for current FY period and compare totals for each fund type back to classic reports to ensure they balance. Please refer to pre-data extract steps for further details on possible Classic corrections, |
EIS103 | Schedule of Change in Fixed Assets | Run Classic report, sorted by asset class. Run Redesign report, sorted by asset class, entering the current FY period and checkmark Summary box. Compare the totals to the Classic EIS103S.TXT. Run Redesign again, unchecking Summary box. Compare the totals against the Classic EIS103D.TXT . If an EIS103E.TXT is generated, please refer to EIS103E corrections section in pre-data extract steps for further details on Classic corrections, |
EIS104 | Schedule of Change in Depreciation | Run Classic report, sorted by asset class. Run Redesign report, sorted by asset class, entering the current FY period and checkmark Summary box. Compare the totals to the Classic EIS104S.TXT. Run Redesign again, unchecking Summary box. Compare the totals against the Classic EIS104D.TXT. Please refer to pre-data extract steps for further details on possible Classic corrections, |
EIS202 | Leased Assets Listing Report | **Optional if tracking leased items** Run both reports sorting by tag number. Compare the totals to ensure they match. |
EIS203 | Asset Listing by Grant/Source | Run Classic report using the default settings. Run Redesign report selecting Active and New Item and sort by Tag #. Compare the totals to ensure they match. |
EIS302 | Location Worksheet | **Optional** Run Classic using the default settings except sort L,T (location #, tag). Run the Redesign report using defaults except select Active and New Status and secondary sort by Tag # (default primary sort is location). Compare reports. |
EIS304 | Brief Asset Listing | Run both reports using defaults. Compare the grand total amounts to ensure they match. |
EIS305 | Book Value | Run the Classic report entering the current FY period as the reporting date, both capitalized and non-capitalized assets. Run the Redesign report, entering status of Active, New, Excess Asset Held for Sale, and Excess Asset Not in Use, sorting by Fund Type, Fund Code, Compare the grand total amounts to ensure they match. |
EIS501 | Pending Item List | Create the Pending File via Transactions>Pending Item's 'Pull From USAS' feature. Run the Pending Items List report (sorted by invoice date). Compare the generated report to the stored Classic EIS501 report. Note any differences and clean up the Inventory application Pending File. |