Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Before extracting a district's data from the Classic system (n in order for it to be imported in Inventory), the following may need to be addressed: must be addressed:

  1. Run an EIS304 of all tags, A, N, EH, EN status codes, capitalized only.  Please review the columns for missing fund, function or asset class codes.

Tip

Recommend running three different ways (sorting by fund, then again by function and then once more by asset class).  This will make it easier to find items with missing codes because they will be displayed at the top of the report

    1. If missing, these need to be corrected by creating TRNTRNs 

2. Run EIS GAAP reports

    1. Run the EIS101 using the default settings
      1. check to see if an EISERR.TXT report was generated.  Items where the original cost is LESS THAN the total dollar amount of all acquisitions posted to the item will be listed on the error report and will also be incorrectly reported on the 'Acquisitions Prior to System Start-up" line on the EIS101.TXT report.
        1. To correct this:
          1. District determines which amount is correct (OC or total ACQTRNs).  Recommended to look up all acquisitions in ACQTRN, ensure totals ACQTRN figure is correct and compare to OC.
          2. If OC is correct, post an ACQTRN with a negative difference between the total ACQTRN and the OC and set update original cost to “N”.  
          3. If total ACQTRNs is correct (OC is wrong), post new ACQTRN for the difference and set update original cost to “Y”. NOTE: this will increase OC to the correct amount but will also increase ACQTRN total.  Post another ACQTRN with a negative amount for the difference between OC and all ACQTRNs setting update original cost to “N”.
      2. review the EIS101.TXT report
        1. The report is broken down by fund type (governmental, proprietary, fiduciary) and possibly an 'Assets with unknown fund type' section.
          1. If there are amounts in the unknown fund type section, it's because
            1. the tag has no value in the "fund" field in ITMSCN; or
            2. the fund code for a tag does not have a defined "fund type" in EISMNT>FNDSCN
              1. To locate and correct this:
                1. Access EISMNT>FNDSCN and ensure all funds listed contain a fund type
                2. Perform step 1 above and locate tags with missing fund codes.  Create TRNTRNs to add the missing fund codes to the tag
        2. Review the EIS101.TXT for any amounts listed under 'Acquisitions Prior to System Start-up'.  The original cost of the item will appear on this line if:
          1. the tag was entered without an associated acquisition record (no associated ACQTRN).
          2. the fund dimension of the USAS Account code on the ACQTRN record is missing. 
            1. To locate and correct items with missing ACQTRN records
              1. Locate: Run EIS304 for capitalized items with status of A, N, EH, EN, sorted by Tag #.  Next, run EIS203 for capitalized items with status A, N and sort by tag #.  Compare the reports, looking for tags which appears on the EIS304 but not on the EIS203.  (Items on EIS203 must have at least one acquisition record).
              2. Correct: Add an ‘historical’ acquisition record via ACQTRN and make sure ‘update original cost’ is “N”.  Enter a TI and fund dimensions in the account code (i.e. 05 001) and the original cost as the acquisition amount.  The date can be set to the date recorded in ITMSCN.
            2. To locate and correct items with missing fund dimension in USAS Account code
              1. Locate: Run EIS203 for capitalized items with status of A, N, EH & EN and scan account code for missing fund dimension
              2. Correct: Modify ACQTRN and add fund dimension in account code
        3. Review the EIS101.TXT for
    2. 102 report - **invalid function** message means the function code is not located in EISMNT>FNCSCN.