Child pages
  • Post Import Procedures

Versions Compared

Key

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

...

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.

Carryover Encumbrances

When Classic's Carryover Encumbrance amounts do not balance with Redesign's Carryover Encumbrance amounts,  the Redesign's 'Classic Carryover Reconciliation' report should be run to see the accounts involved and the carryover amounts adjusted.  The 'Grand Total' on the report should match the difference between Redesign and Classic's carryover encumbrances.

HELPFUL TIP: The Impact on Encumbrance report may be helpful in determining the positive and negative adjustments that were made.  You can filter the report by entering the account from the classic carryover reconciliation to find the PO transactions tied to that account.

A positive adjusted carryover encumbrance means Redesign had to increase the carryover encumbrance figure from classic due to one of the following reasons:

  • In Classic, backdating an invoice to a date in the prior fiscal year.  For example, you are in July 2018 (FY19) processing but you entered an invoice with a FY18 date.  Redesign import thinks the invoice was in FY18 and increases the prior carryover encumbrances.

A negative adjusted carryover encumbrance means Redesign had to decrease the carryover encumbrance figure from classic due to one of the following reasons:

  • In Classic, modifying a prior year PO date to a date in the current fiscal year.  Redesign import thinks the encumbrance should be reflected in the current FY and will reduce the prior carryover encumbrances. 
  • In Classic, deleting a prior year PO in the current fiscal year and re-adding it with a date in the current fiscal year.  Redesign import thinks the encumbrance should be reflected in the current FY and will reduce the prior carryover encumbrances.

    Note

    In the two situations above, the district intentionally changed the prior year PO date to reflect the current fiscal year.  Redesign import corrected the CO encumbrances by decreasing the amounts on the CO figure so that the encumbrances are reflective in the new year and no longer in the prior year.   District should keep this CO reconciliation report on file to show the adjustments in encumbrances that were made because the Redesign figures are correct.


  • In Classic, defaulting an invoice date to the current system date (July) when you are still in June processing. For example, posting invoices on July 2nd using the default July 2nd date when you are still in June processing.  Redesign import thinks the invoice is a current year invoice and will reduce the prior carryover encumbrances.