Child pages
  • Post Import Procedures
Skip to end of metadata
Go to start of metadata

SSDT strongly recommends ITCs run test imports on their district's data two months before the dual-processing period.


There are a few processes that need to be setup and verified after the USAS data has been imported.

  • Go to System/Configuration
    • Classic Migration ConfigurationEnter the 'Fiscal Year Closed' date and time from Classic's USASDAT/USACON.  This is the date and time Classic's ADJUST program was run when closing the fiscal year prior to extracting the district's data. 
    • EIS Classic Integration Configuration: If the district is currently using Classic's EIS (Equipment Inventory System), enter the 'Pending Threshold' amount from Classic and either checkmark the 'automatic' box for it to automatically update the pending file for 6xx object codes or leave unchecked and the user will be prompted for both 5xx and 6xx object codes.
    • EMIS SOAP Service Configuration: Enter the fiscal year the district will be reporting for the next Period H submission.  This is required before running the EMIS extract option under the Extracts menu.
    • Transaction Configuration: Specify the highest transaction number used instead of the system using the highest number retrieved from the database.  This will be helpful in eliminating gaps in transaction numbers.
  • Go to System/Modules to install the following modules:
    • Classic Requisition Approval Module: must be installed if they use Onbase or RAM). 
    • File Transfer Notification Services: must be installed if they use RAM
    • USPS Integration Module
    • Windows Active Directory Service Authentication: must be installed if they would like to use Active Directory
  • Go to Transactions/Activity Ledger. If the following warning message is displayed, please be advised that the ledgers have not finished posting and the data you are seeing in the Activity Ledger is incomplete.  Once this message no longer displays, the posting of the ledgers has completed and all data is available from the import.

Data Cleanup

Once your data has been imported into the redesign, your ITC may contact you with a list of errors that occurred during import.  Errors may include, but are not limited to:

Vendors 

We're seeing a lot of errors related to vendor addresses.  Specifically an incorrect state abbreviation or trailing hyphens in postal codes.  You'll need to edit the vendor to correct the erroneous data.

Balancing

After the import process completes you'll want to run, at a minimum, the following reports in both Classic and the Redesign to check totals and ensure all of your amounts balance.  Don't be surprised if you notice a few differences, especially with the Carryover Encumbrances.  Don't panic, we're here to help and each difference can be explained.  Once you understand the reason for the difference, you may decide that you need to post adjusting entries to ensure your expendable amounts are what they should be.

You are seeing a difference because the calculation of remaining encumbrance in the Redesign is different from that of Classic.  We have corrected some of the deficiencies in Classic's calculations of remaining encumbrance.  There were certain circumstances where Classic simply could not get this calculation correct.  


Classic

Redesign

Notes


APPSUMSSDT Appropriation SummaryWhen your run these reports, if your Carryover Encumbrances do not match you will want to run a Budget Summary report to narrow it down to the Budget that was impacted. You'll also want to run the SSDT Carry Over Reconciliation Report, see explanation below.
BUDSUMSSDT Budget SummaryCompare the totals on the Budget Summary Report report to classic's BUDSUM figures.
BUDLEDSSDT Budget Account Activity ReportCompare the totals on the Budget Account Activity report to the totals on classic's BUDLED. You can run it for the current month and/or the current year on both systems to make sure everything is in balance.
FINDETSSDT Financial Detail ReportCompare the totals on the Financial Detail to the totals on classics' FINDET report. You can run it for the current month and/or the current year on both systems to make sure everything is in balance.
FINSUMMSSDT Cash Summary ReportCompare the totals on the Cash Summary report to the totals on classic's FINSUMM.
REVSUMSSDT Revenue SummaryCompare the totals on the Revenue Summary report to classic's REVSUM.
REVLEDSSDT Revenue Account Activity ReportCompare the totals on the Revenue Account Activity report to the totals on classic's REVLED. You can run it for the current month and/or the current year on both systems to make sure everything is in balance.
PODETLSSDT Purchase Order Detail Report

If you run this report for outstanding purchase orders, you'll want to take into consideration that the Redesign does not consider purchase order amounts that have been invoiced to be outstanding. You will need to compare an outstanding Classic report to an outstanding Purchase Order Detail Report and includes invoices from the Payables UI. You can run a report from the Payables grid to get a total of filled invoices and add it to your Purchase Order Detail Report in the redesign to equal the amount you see on classic's PODETL.

The PO Total on the report is the original PO amount. 'Adjusted' in classic is taking into consideration any cancelled amounts. Currently, PO cancelled amount is not included in the Redesign so when comparing against the PO adjusted in classic, you have to take the PO original amount minus cancelled PO amounts.


CHEKPYSSDT Disbursement SummaryYou can run reports for all checks and/or outstanding checks. If you want to run a report for outstanding checks, select 'outstanding' on the Disbursement Summary report and compare the figures to Classic's outstanding CHEKPY. Classic includes transfer checks.. redesign doesn't. Reconcile memo checks.
SM2SM2 Spending Plan SummaryIf the districts runs the SM2 on a monthly basis, compare the SM2 Spending Plan Summary to Classic's SM2M from the SM12 program to compare totals.

SSDT Carry Over Reconciliation ReportThis report summarizes the differences between Classic's imported carryover encumbrances and the Redesign's calculated amount. The adjustments are derived by taking the carryover encumbrance imported from Classic, calculating the carryover encumbrance according to the Redesign's more correct calculations, and finding the difference between the two amounts.

SSDT Impact on Encumbrance ReportIf you run the report for a particular PO, you will see all associated transactions that had an impact on the original encumbrance for that PO. Please keep in mind, this will NOT list every transaction associated with the PO, only those that had an impact on encumbrance. For example, creating an invoice that partially fills a charge for less than the total amount does NOT impact encumbrance. However, partially filling an item for more than the original charge amount DOES impact encumbrance, increasing it by the difference of the original charge and the invoiced amount.


Differences in Encumbrances

Once you have the difference narrowed down to an account and purchase order, you can run the Impact on Encumbrance Report listed above for that particular PO to assist you in seeing that POs impact on encumbrance.

We will be documenting scenarios we've encountered and what had to be done to determine the difference in the calculation.

  • No labels