A Redesign Technical Setup and Migration Guide is available in an effort to consolidate the various pieces of our documentation relevant to setting up a new school on USXS-R.
SSDT strongly recommends ITCs run test imports on their district's data two months before the dual-processing period. When running a test import, please review the Balancing Reports listed below to ensure account and transaction totals are correct.
There are a few processes that need to be setup and verified after the USAS data has been imported.
Once your data has been imported successfully into the Redesign, the following balancing reports need to be run in both Classic and Redesign and compared for accuracy.
Don't be surprised if you notice a few differences, especially with the Carryover Encumbrances.
See the Differences in Carry Over Encumbrances page for more information on locating possible differences.
Start by running the SSDT Classic Carry Over Reconciliation Report for a summary of the differences between Classic and Redesign. This difference will impact the Account Summary reports (Cash, Budget, Appropriation Summary) report totals for Prior Year Encumbrance and FYTD Expendable. When reviewing the differences on this report consider whether they are positive or negative amounts to narrow down which of the possible situations may be causing the difference (see grid at the top of the Differences in Carry Over Encumbrances wiki page). The SSDT Post Import Closed Purchase Orders with Remaining Balance can be run to compare to the SSDT Classic Carry Over Reconciliation Report in order to locate possible differences due to Partial Invoices dated after Full Invoices.
|SSDT Classic Carry Over Reconciliation Report||This 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 Post Import Closed Purchase Orders with Remaining Balance|
This report shows POs with a remaining balance that are marked as NOT Invoiceable. This can happen if the Purchase Order is associated with a Partial invoice dated after a Full Invoice. If the PO/Invoices are dated in a prior year then this can cause a difference with the Carry Over Encumbrances. This report is sorted by Cash Account then Full Account code so that it can easily be compared to the Classic Carry Over Reconciliation Report. See the Differences in Carry Over Encumbrances documentation page for how to correct POs in this situation.
This could also indicate that the Purchase Orders have been Invoiced but not yet posted to disbursements (review Payables grid). If this is the case, an adjustment is not necessary. The remaining encumbrance amount on the Purchase Order will be cleared when the Payable is posted. To assist with balancing, a report from the Payables grid can be run to balance the filled total.
|SSDT Impact on Encumbrance Report||If 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.|
Check for Invoiceable Purchase Orders with a $0.00 Remaining Encumbrance. In some situations, third party software applications have been able to update the Classic Purchase Order status to "Completely Paid" even though all associated invoices are "Partial" status. Redesign requires a "Full" transaction in order to consider the Purchase Order to be no longer Invoiceable so the Purchase Order status in Redesign will show a Invoiceable causing it to be inconsistent with Classic reports. There are a couple different ways to locate these transactions. Once located, these transactions should be closed to match the Classic status.
To locate these transactions on the Purchase Order grid:
For a Report of Invoiceable Purchase Orders with a $0.00 Remaining Encumbrance.
|SSDT Post Import Outstanding Purchase Orders with Zero Balance||This report shows PO line items with a no remaining balance that are marked as Invoiceable.|
Review the list of Purchase Orders from the grid/report that are Invoiceable with no remaining encumbrance amount. Look up the Purchase Order in Classic USAS or USASweb and compare the status. If the purchase order is still open in Classic then no action is needed. If the Purchase Order status is "Completely Paid" in Classic then proceed with the fix below.
If the most recent Partial Invoice is in a posting period that is not archived, the period can be opened and then the status can be changed from "Partial" to "Full" when viewing the invoice.
If the most recent Invoice is in an archived posting period, create a Cancel_Full invoice for $0.00. Once the Invoice to cancel is saved, the Purchase Order status may not automatically update to show as not Invoiceable. If the Purchase Order does not automatically update, use the Purchase Order Refresh (requires Admin access) to update the PO to not Invoiceable. The Purchase Order Refresh can be found on the Utilities menu. Users with Admin access can navigate to this page, enter the Purchase Order number, and click "Refresh State." The Purchase Order status will update to not Invoiceable.
At minimum, the following reports in both Classic and the Redesign should be run to check totals and ensure all of your amounts balance.
|APPSUM||SSDT Appropriation Summary||When 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.|
|BUDSUM||SSDT Budget Summary||Compare the totals on the Budget Summary Report report to Classic's BUDSUM figures.|
|BUDLED||SSDT Budget Account Activity Report||Compare 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.|
|FINDET||SSDT Financial Detail Report||Compare the expended and received totals on the Financial Detail to the totals on Classic's 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. If you also compare encumbered amounts, you'll want to take into consideration Classic's FINDET includes all prior year plus current year outstanding encumbrances. Redesign's Financial Detail report, when entering a date range for the FY, only includes the outstanding encumbrances for the current FY.|
|FINSUMM||SSDT Cash Summary Report||Compare the totals on the Cash Summary report to the totals on Classic's FINSUMM.|
|REVSUM||SSDT Revenue Summary||Compare the totals on the Revenue Summary report to Classic's REVSUM.|
|REVLED||SSDT Revenue Account Activity Report||Compare 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.|
|PODETL||SSDT 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.
|INVLST (outstanding)||SSDT Outstanding Invoices by Vendor Name||Compare the totals on the Outstanding Invoices Report to an Outstanding INVLST in Classic to ensure any outstanding payables are valid and in balance.|
|CHEKPY||SSDT Disbursement Summary||You 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.|
|REQSUM||SSDT Requisition Summary Report||You can run both reports for outstanding requisition amounts. If the amounts do not balance (and Redesign amount is higher), there may be requisitions appearing in the Redesign as outstanding when they are considered closed in Classic. This is caused by closed (converted) requisitions in Classic where the associated PO is no longer on file in Classic (i.e. PO was deleted). In this case, the requisition will be imported with 'converted' equals false (outstanding requisition) and if the requisitions amount are being tracked, the amounts will be included on the accounts. If these requisitions should not be included in the import, please delete the requisitions in Classic before doing a live import of the district's data.|
|SM2||SM2 Spending Plan Summary||If 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. NOTE: Classic's SM2M will not calculate encumbrances totals if run for more than one month.|
|VENLST||SSDT Vendor Listing||Compare YTD totals on the Vendor Listing to Classic's VENLST YTD totals.|