Versions Compared

Key

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

SSDT Canned Reports

Classic Comparison

Replaces Template Report

Definition

Account Activity Report

BUDLED / REVLED

SSDT Budget Account Activity Report
SSDT Revenue Account Activity Report

Generates a detailed report of transactions that make up the amounts in either the Budget accounts or the Revenue accounts per selection.  Canned report version of the Budget/Revenue Account Activity Report to increase performance.

Account Payable Report

PAYABL


Generates a report listing all accounts payable

Account Status

ACCSTS


Contains both budget and revenue activity on a single report

Audit Report

AUDITS

SSDT Audit Trail
SSDT Auditable Events

Produces a report showing the 'audit trail' of transactions when adding, deleting, or making modifications while using the programs in USAS-R

Budget Summary Report

BUDSUM

SSDT Budget Summary

Produces a report of budget account information including expendable amount, actual expenditures, current encumbrances and unencumbered balances

Canned Reports#Disbursement Detail Report

CHEKPY

SSDT Disbursement Detail
SSDT Outstanding Disbursement Summary

Produces a report of disbursements which have been processed.  

Financial Detail Report

FINDET

SSDT Financial Detail Report
SSDT Financial Detail Report July 1 Cash Balances
SSDT Financial Detail Report for Current Period

Produces a detailed report of the transactions that make up the amounts in the cash accounts.  The report includes both receipt and expenditure data

Financial Summary by Fund Report

FUNDSUMM


Contains the general fund accounts listed by function or object and the remaining accounts are listed by fund totals only

Group Chain Report

N/A


Generates a report listing all Group Chains with the option to include Archived group chains.  

Purchase Order Detail Report

PODETL

SSDT Purchase Order Detail Report
SSDT Outstanding Purchase Orders

Detailed purchase order report containing information on individual purchase order items

Vendor New Hire

VENHIRE


Contains independent contractors data meeting the Ohio New Hire reporting requirements

Revenues and Expenditures Report

FNDREVEX


Contains MTD and FYTD activity for each Fund/Fund-SCC with calculated difference between Revenue and Expenditures

Requisition Approval Report



Generates a report listing the requisition approval audit trail for those requisitions in the Workflow process.  This information is also available on each requisition.

...

Snapshot of the report in pdf format.

...

Anchor
audit
audit
Audit Report

A report showing additions, deletions and modifications to transactions with the ability to sort by username and date as well as to use control and page breaks.

...

 Objects to be Audited

Included Target Types

Purchase Order

PurchaseOrder, PurchaseOrderItem, and PurchaseOrderCharge

Invoice

Invoice, InvoicePOItem, and Source

Fund

AccountMapping

CashAccount

CashTransaction

Appropriation


ExpenditureAccount

ExpenditureAccountHistory

RevnueAccount

RevenueAccountHistory

BankAccount


DeliveryAddress


Opu


Oganization


PostingPeriod


Project


Vendor

VendorLocation, MergedVendor

ActivityLedger


Invoice

InvocieItem and InvoicePOItem

Disbursement

DisbursementItem, DisbursementRefundItem, DisbursementInvoiceItem,

DisbursmentExpenditureItem,BankTransaction

Distribution


PurchaseOrder

PurchaseOrderItem, PurchaseOrderCharge

Receipt

ReceiptIem

Refund

RefundItem

Requisition

RequisitionItem, RequisitionCharge, FileStore

Building


CashReconciliation

CashRecItem

CivilProceeding


FederalAssistanceDetail


FederalAssistanceSummary


CustomFieldDefinition


Role

Permission

User


Budget

BudgetTransaction

AnticipatedRevenue

AnticiaptedRevenueTransaction


...

Anchor
budsum
budsum
Budget Summary Report

Summary report for one, several, or all of the budget accounts. It includes the expendable amount, actual expenditures, current encumbrances, unencumbered balance, and percentage expended/encumbered.

...

Anchor
Disbursement Detail Report
Disbursement Detail Report
Disbursement Detail Report

A report listing disbursements (checks) which have been processed.  The report can produce a summary or a detailed report. The report can include various types of checks, including Accounts Payable, Refund and Payroll, and allows for various check statuses to be chosen (reconciled, voided or outstanding.)

...

Snapshot of the report 

...

Anchor
findet
findet
Financial Detail Report

A Detailed report of the transactions that make up the amounts in the cash accounts.  The report includes both receipt and expenditure data.   Allow users to enter a date range to generate the report. 

...

Snapshot of the report with Initial Cash Balance:

...

Anchor
fundsumm
fundsumm
Financial Summary by Fund Report

A summarized financial report using one print line for each cash balance record, sorted by Fund. This report contains the general fund accounts listed by function or object and the remaining accounts are listed by fund totals only. Displays Fund, Function, Description, Appropriation, Expended, % Expended, Encumbered, Balance. The July 1 Cash Balance, Total MTD receipts and Current Cash Balance (all funds) are displayed at the end of the report.

...

Snapshot of report:

...

Anchor
venhire
venhire
Vendor New Hire

The Vendor New Hire program allows for reporting of independent contractors to the Ohio New Hire reporting center.  Requirements and specifications can be found here: https://newhire-reporting.com/OH-Newhire/default.aspx.  The program will create a report listing all vendors with payments of at least $2,500.00 for the calendar year based off the reported date entered.  Vendors must have the "Report Status" field set to 'reportable' under the 'New Hire' section of the vendor record in order for the Vendor New Hire report to include them.  Other Vendor fields that may be filled in include:

...